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

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".