How to create alias in oracle database -
. oraenv
<sid>
alias ua_dba='sqlplus "/ as sysdba"'
alias ua_oper='sqlplus "/ as sysoper"'
alias ua_sp='sqlplus "/ as sysdba"'
alias ua_pfile='cd ${ORACLE_HOME}/dbs'
alias ll='ls -alrt'
alias ua_diag='cd `orabase`/diag/rdbms/${ORACLE_SID,,}/${ORACLE_SID}/trace'
alias ua_alert='tail -100 `orabase`/diag/rdbms/${ORACLE_SID,,}/${ORACLE_SID}/trace/alert_${ORACLE_SID}.log'
alias ua_lsinv='${ORACLE_HOME}/OPatch/opatch lsinventory -invPtrLoc ${ORACLE_HOME}/oraInst.loc'
alias ua_util_cleanup='${ORACLE_HOME}/OPatch/opatch util cleanup -invPtrLoc ${ORACLE_HOME}/oraInst.loc'
alias ua_dgconf='dgmgrl / "show configuration;"'
alias ua_dbinfo='echo -e "col name for A10 \n select name, open_mode, database_role, log_mode, current_scn from v\$database;" | sqlplus -s / as sysdba'
. oraenv
<sid>
alias ua_dba='sqlplus "/ as sysdba"'
alias ua_oper='sqlplus "/ as sysoper"'
alias ua_sp='sqlplus "/ as sysdba"'
alias ua_pfile='cd ${ORACLE_HOME}/dbs'
alias ll='ls -alrt'
alias ua_diag='cd `orabase`/diag/rdbms/${ORACLE_SID,,}/${ORACLE_SID}/trace'
alias ua_alert='tail -100 `orabase`/diag/rdbms/${ORACLE_SID,,}/${ORACLE_SID}/trace/alert_${ORACLE_SID}.log'
alias ua_lsinv='${ORACLE_HOME}/OPatch/opatch lsinventory -invPtrLoc ${ORACLE_HOME}/oraInst.loc'
alias ua_util_cleanup='${ORACLE_HOME}/OPatch/opatch util cleanup -invPtrLoc ${ORACLE_HOME}/oraInst.loc'
alias ua_dgconf='dgmgrl / "show configuration;"'
alias ua_dbinfo='echo -e "col name for A10 \n select name, open_mode, database_role, log_mode, current_scn from v\$database;" | sqlplus -s / as sysdba'
Thanks
DB Tech Solutions Team