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
--------------------------------------------------------
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