ORA-01507 and ORA-01102 errors while upgrading Oracle to 11g on Linux

Article Id: 159890

Status: Published

Updated On: 27-06-2012 23:19

Legacy Id: TECH219860

Products:

Data Loss Prevention Enforce

Issue/Introduction:

When performing the steps in the Oracle Upgrade Guide section "Configuring the upgraded 11g database", you receive the following errors:

ORA-01507: database not mounted
ORA-01102: cannot mount database in EXCLUSIVE mode

Resolution:

1. Update the ORACLE_HOME environment variable in the file ".bash_profile" for the oracle and protect users per step 34 on page 56 in the Oracle Upgrade Guide.
2. Log out of the oracle and/or protect user session(s).
3. Restart the Oracle database service by running the command as root "service dbora restart".