Monthly Archives: January 2014

Oracle commands

ps -ef | grep pmon (List active instances) cat /etc/oratab (List instance installed) ORACLE_SID=INST1 sqlplus “/ as sysdba” (Connect to the instance) ORACLE_SID=INST1 sqlplus “/as sysdba” @/tmp/grantrights.sql shutdown immediate; startup SELECT username from dba_users (List all the schemas in a … Continue reading

Posted in AIX, Linux, Oracle | Tagged , ,