oracle 基本的 alias

alert log 產出位子

SQL> show parameter background

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

background_core_dump                 string      partial

background_dump_dest                 string      /u01/app/oracle/diag/rdbms/orcl/orcl/trace

====================================================

export  PS1="\e[4m$ORACLE_SID\[\e[0m\]::\[\e[41m\]\h:\W \u\\$ \[\e[0m\] "

alias SS='sqlplus / as sysdba'

alias cdTNS='cd $ORACLE_HOME/network/admin'

alias cdDBS='cd $ORACLE_HOME/dbs'

alias cdALT='cd  /u01/app/oracle/diag/rdbms/orcl/orcl/trace'

alias viALT='vi  /u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log'

alias TAILALT='tail -f  /u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log '

前面有SID， 後面紅底白字

Prod

 PS1="\e[4m$ORACLE_SID\[\e[0m\]::\[\e[41m\]\h:\W \\$ \[\e[0m\] "

ColdStandby

 PS1="\e[4m$ORACLE_SID\[\e[0m\]::\[\e[36;44m\]\h:\W \\$ \[\e[0m\] "