Monday, 21 January 2019

set sqlplus prompt name same as instance name

How to set sqlplus prompt name same as Database/Instance name


We need to change one file called glogin.sql, steps are as below...

Path where glogin.sql 

cd $ORACLE_HOME/sqlplus/admin

/u01/app/oracle/product/12.1.0/dbhome_1/sqlplus/admin

set below mention line at the end of the file

vi glogin.sql

SET SQLPROMPT 'PROD-SQL>'

save and exit

Now next login you can see your db name like PROD

Thanks

Prerequisite Check “CheckActiveFilesAndExecutables” Failed

While applying a patch to oracle binary using opatch utility, got below error. Error -  $ORACLE_HOME/OPatch/opatch apply Oracle Interim Patc...