This is a draft cheat sheet. It is a work in progress and is not finished yet.
instresting path(s)
sqlnet.log |
$ORACLE_HOME/network/log/ |
tns error and co |
alert.log |
/opt/app/oracle/admin/[dbinstance]/bdump |
description |
oracle home (solaris) |
/opt/app/oracle/[db_version] |
description |
listner.ora |
$ORACLE_HOME/network/admin |
description |
tnsnames.ora |
$TNS_ADMIN |
description |
$ORACLE_BASE folder |
$ORACLE_HOME/../ |
oradata folder |
$ORACLE_BASE/oradata |
admin |
$ORACLE_BASE/admin |
relevant-script
/etc/init.d/applctrl |
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
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$parameter |
check current parameter from database |
select * from v$session |
check current sessions on the server |
|
