Connect fail after upgrade db from 11.1.0.6 to 11.1.0.7
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).
0