Home / Errors/Workarounds10g / ORA-01586: database must be mounted EXCLUSIVE and not open for this operation

ORA-01586: database must be mounted EXCLUSIVE and not open for this operation

ERROR

ORA-01586: database must be mounted EXCLUSIVE and not open for this operation

SOLUTION

 

$sqlplus / as sysdba

SQL>shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL>startup mount exclusive restrict;
ORACLE instance started.

Total System Global Area 2112354232 bytes
Fixed Size                  2212208 bytes
Variable Size            1356068952 bytes
Database Buffers          838652800 bytes
Redo Buffers                4065272 bytes
Database mounted.

SQL>drop database;
Database dropped.

 

 

About Syed Saad

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

OracleDBconfig

Manually remove ODA DB HOME

Manually remove OLD DB HOMES if odacli-delete dbhome fails Please follow the instructions below: 1. …

Leave a Reply