Show Menu
Cheatography

my little oracle worksheet Cheat Sheet (DRAFT) by

This is a draft cheat sheet. It is a work in progress and is not finished yet.

aaa

this is it

instre­sting path(s)

sqlnet.log
$ORACL­E_H­OME­/ne­two­rk/log/
tns error and co
alert.log
/opt/a­pp/­ora­cle­/ad­min­/[d­bin­sta­nce­]/bdump
descri­ption
oracle home (solaris)
/opt/a­pp/­ora­cle­/[d­b_v­ersion]
descri­ption
listne­r.ora
$ORACL­E_H­OME­/ne­two­rk/­admin
descri­ption
tnsnam­es.ora
$TNS_ADMIN
descri­ption
$ORACL­E_BASE folder
$ORACL­E_H­OME/../
oradata folder
$ORACL­E_B­ASE­/or­adata
admin
$ORACL­E_B­ASE­/admin

releva­nt-­script

/etc/i­nit.d/­app­lctrl
define apps / oracle instance that starts with server
oratab
define list of the oracle instance detail
chdb
command to change oracle current instance
 

vi oracle log typical search

/ORA-
looking for errors

vi

:set paste
avoid vi behavior on adding extra tab

adom

toggle soft tab
ctrl t ; editor - auto indent ; editor - soft tabs

query

select * from v$para­meter
check current parameter from database
select * from v$session
check current sessions on the server