Database Administration (MOSC)

MOSC Banner

Connect fail after upgrade db from 11.1.0.6 to 11.1.0.7

edited Nov 21, 2011 2:10AM in Database Administration (MOSC) 4 commentsAnswered ✓
 Hi guys,
   My OS is Linux 32.

   Today I upgrade db from 11.1.0.6 to 11.1.0.7 with steps bellow:

   1. Download the patchset 6890831 from MOS.
   2. Extract this patchset, and run runInstaller to upgrade.
   3. Processing of upgrade success.
   4. I startup my db and received error: ORA-39700: database must be opened with UPGRADE option
   5. I use STARTUP UPGRADE and can start my db.
   6. When use "conn / as sysdba" ==> connect OK, but with "conn sys@develop as sysdba" ==> connect fail with error: ORA-12526: TNS listener: all approriate instances are in restrict mode.
   7. I edited tnsname.ora file by add the "UR=A" and can connect to db with sysdba user (conn sys@develop as sysdba == > OK).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center