Search my Blog

Follow me on Twitter

Sqlplus / as sysdba throws ORA-01012

Introduction.

This morning the first challenge of the day became the fact that we could not get proper access to one of the databases. We would set the Environment, set the proper ORACLE_SID and yet after logging on would get

ORA-01012: not logged on

with any query ( select * from v$instance ; show parameter blablah ).

Reading the posts on the web give a quick solution… First proof: the alert log was flooded with messages like these: