Tuesday, 25 August 2015

Find - Oracle DB Shut down Scripts Location

Steps involved for oracle server to shutdown:
--------------------------------------------------------

1- login to database server as  DBAPriviledgedUsername
2- [root@oracledbserver ~]$su - oracle  -- sudo oracle 
3- [root@oracledbserver ~]$.  oraenv  -->Type the Oracle_sid which you want to connect to, that is basically an oracle instance
 (Note: Oracle_sid should be in /etc/oratab)
4- [root@oracledbserver ~]$sqlplus / as  sysdba
5  SQL> select instance_name from v$instance;
or
SQL>select sys_context('USERENV','INSTANCE_NAME') from dual;  -- Please make sure you are in correct db instance

6- Please check  if they are the same instance as per above query where you are trying to start and / or shutdown the instance
7- shutdown immediate -- This will terminate or kill the sessions and rollback the sessions


Locate the dbstart and dbshut scripts:
------------------------------------------

[oracle@oracledbserver admin]$ cd /etc/init.d

[oracle@oracledbserver init.d]$ locate dbshut

/apps/home/oracle/OracleHomes/db10g/bin/dbshut
/apps2/oracle/app/oracle/product/11.2.0/dbhome_1/bin/dbshut
/apps2/oracle/app/oracle/product/12c/bin/dbshut

[oracle@oracledbserver init.d]$ locate dbstart

/apps/home/oracle/OracleHomes/db10g/bin/dbstart
/apps2/db2/samples/cobol_mf/dbstart.cbl
/apps2/oracle/app/oracle/product/11.2.0/dbhome_1/bin/dbstart

/apps2/oracle/app/oracle/product/12c/bin/dbstart

No comments:

Post a Comment