Oracle Delete Library Run

--10g R2Startup Mount ExclusiveRestrict;Altersystem enable restricted session;Drop Database;--11gstartup Mount exclusive;Altersystem enable restricted session;Drop Database;--RAC 12.1.0.2.0 Delete library1. Stop all node instances first2. In one of the node operations, first turn off RAC mode startup Nomount;AlterSystemSetCluster_database=FALSE Scope=SPFile;shutdownimmediate;3. Start Mount Restric mode startup MountRestrict;4. Deleting a databaseDrop Database;

Delete the whole set of the library!

Su-Oracle--Delete ServiceSrvctl Remove Service-D Sgsopen-s Sopen1srvctl remove service-D Sgsopen-s Sopen2--Delete DB Library1. Stop all node instances first2. In one of the node operations, first turn off RAC mode startup Nomount;AlterSystemSetCluster_database=FALSE Scope=SPFile;shutdownimmediate;3. Start Mount Restric mode startup MountRestrict;4. Deleting a databaseDrop Database;--Delete db resourceSrvctl RemoveDatabase -D Sgsopen

1 -- 10g R2 2 Restrict ; 3 Alter system enable restricted session; 4 Drop database;

10g R2

1 -- 11g 2 startup Mount exclusive; 3 Alter system enable restricted session; 4 Drop database;

11g

--RAC 12.1.0.2.0 Delete library1. Stop all node instances first2. In one of the node operations, first turn off RAC mode startup Nomount;AlterSystemSetCluster_database=FALSE Scope=SPFile;shutdownimmediate;3. Start Mount Restric mode startup MountRestrict;4. Deleting a databaseDrop Database;

RAC 12.1.0.2.0 Delete library

1 --RAC 12.1.0.2.0 Delete Vault failure 12 startup Mount exclusive;3 Altersystem enable restricted session;4 Drop Database;5 6 7Oracle@DB01:/Home/Oracle#sqlplus/  asSYSDBA8 9Sql*Plus:release12.1.0.2.0Production onThursday August -  the: -: , 2018Ten  OneCopyright (c)1982, the, Oracle. Allrights reserved. A  -Connected toAn idle instance. -  theSql>startup Mount exclusive; - ORACLE instance started. -  -Total System Global Area1.5945E+ Onebytes +Fixed Size7726760bytes -Variable Size5.7982E+Tenbytes + DatabaseBuffers1.0039E+ Onebytes ARedo buffers1066012672bytes at Databasemounted. -Sql> -Sql> Altersystem enable restricted session; -  - System altered. -  inSql> Drop Database; - Drop Database to * +ERROR at line1: -ORA-01586: For this operation, the database must be loaded in EXCLUSIVE mode and not open the  *Sql> Alter Database Close; $ Alter Database ClosePanax Notoginseng * -ERROR at line1: theORA-01109: The database is not open +  ASql> Drop Database; the Drop Database + * -ERROR at line1: $ORA-01586: For this operation, the database must be loaded in EXCLUSIVE mode and not open $  -Sql> SelectOpen_mode fromv$Database; -  the Open_mode - --------------------WuyiMounted

RAC 12.1.0.2.0 Delete Vault failure 1

1 --RAC 12.1.0.2.0 Delete Vault failure 22 startup Mount;3 Altersystem enable restricted session;4 Drop Database;5 6Sql>startup Mount;7 ORACLE instance started.8 9Total System Global Area1.5945E+ OnebytesTenFixed Size7726760bytes OneVariable Size5.7982E+Tenbytes A DatabaseBuffers1.0039E+ Onebytes -Redo buffers1066012672bytes - Databasemounted. theSql> Altersystem enable restricted session; -  - System altered. -  +Sql> Drop Database; - Drop Database + * AERROR at line1: atORA-01586: For this operation, the database must be loaded in EXCLUSIVE mode and not open

RAC 12.1.0.2.0 Delete Vault failure 2

Oracle Delete Library Run