Export SID instance droped
|
1 |
export ORACLE_SID=database |
Connect database as sysdba
|
1 2 3 4 5 6 7 8 9 10 11 |
[oracle@SRV-BD-HOMOLOG ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 29 12:09:16 2021 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options |
Check status instance
|
1 2 3 4 5 |
SQL> select instance_name, status from v$instance; INSTANCE STATUS -------- -------------------- homolog OPEN |
Shutdown the database
|
1 2 3 4 |
SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. |
startup in exclusive mode restrict
|
1 2 |
SQL> startup mount exclusive restrict ORACLE instance started |
Check status instance
|
1 2 3 4 5 |
SQL> select instance_name, status from v$instance; INSTANCE STATUS -------- -------------------- MOUNTED OPEN |
Drop database
|
1 2 3 |
SQL> drop database; Database dropped. |