Oracle : Setting up glogin.sql

Setting up glogin.sql : cd $ORACLE_HOME/sqlplus/admin cp glogin.sql glogin.sql.bkp vi glogin.sql SET termout off DEFINE myv = ‘Not connected’ COLUMN myc new_value myv select user || ‘@QA@’ || global_name myc from global_name; SET sqlprompt ‘&myv:SQL> ‘ Execution : $ sqlplus scott/PW SQL*Plus: Release 12.1.0.2.0 Production… Read More

Oracle : Setting up Oramenu for Databases

Use this script to setup oramenu:  

  ~$ chmod +x oramenu ~$ sudo su – root ~# cp /home/oracle/oramenu /usr/local/bin/ ~# exit logout ~$ . oramenu Or Example : $ chmod +x oramenu oracle@server123:ORCL1:/home/oracle > $ . oramenu Please select your SID to… Read More