ORA-01012: not logged on.
815181Dec 29 2010 — edited Mar 16 2011Hi All,
I am upgrading EBS R12.1.1 database 111.0.7.0 to 11.2.I installed 11.2 software and Example CD.While database up gradation I got error given below.
ORA-01012: not logged on.
When I tried to see the mode of 11.2 database I got below error.
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
When I tried to shut down database I got below error.
ORA-12432: LBAC error: zllesesinit:OCIStmtExecute
In 11g Release 2 (11.2) document I saw the cause which is given below.
If you are upgrading a pre-11.2 database with OLS installed and configured, then you need to do one of the following for the upgrade of the database to succeed:
* Execute a custom installation of OLS in the 11.2 installation before starting the upgrade of the pre-11.2 database.
* If you do not want OLS in the upgraded database, then deinstall OLS before starting the upgrade.
If you do not execute one of the previously mentioned actions, then you will encounter an error (ORA-01012: not logged on) during the upgrade (reference Bug 8707506). For example, after executing the SHUTDOWN IMMEDIATE command, the following error appears:
ORA-12432: LBAC error: zllesesinit:OCIStmtExecute
I installed Vision instance of R12.1.1 where I didn't enable OLS.I am not getting why this error is coming.
Any suggestions is appreciated.
Thanks in advance.
Neel