ORA-01102 cannot mount database in EXCLUSIVE mode
Cause: Some other instance has the database mounted exclusive or shared.
Action: Shut down the other instance or mount in a compatible mode.
shu immediate and try again to startup the database server
In my case there is problem in .bash_profile
where ORACLE_SID is not set.
"login with ORACLE user"
vim .bash_profile
"press i and add"
ORACLE_SID=orcl
restart/logout the machine to reflect the change to oracle user
sqlplus sys/orcl as sysdba
Cause: Some other instance has the database mounted exclusive or shared.
Action: Shut down the other instance or mount in a compatible mode.
shu immediate and try again to startup the database server
In my case there is problem in .bash_profile
where ORACLE_SID is not set.
"login with ORACLE user"
vim .bash_profile
"press i and add"
ORACLE_SID=orcl
restart/logout the machine to reflect the change to oracle user
sqlplus sys/orcl as sysdba
SQL startup pfile='/u01/app/oracle/product/11.2.0/dbhome/dbs/*.ora' ORACLE instance started. Database mounted. Database opened.
No comments:
Post a Comment