ORA-01012: not logged on

sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jun 24 12:32:12 2013
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Connected.
SQL> select status from v$instance;
select status from v$instance;
*
ERROR at line 1:
ORA-01012: not logged on

SOLUTION

“The ORA-01012: not logged on” error occurred due to heavy load in the database. If there is maximum number of sessions connected to the database, database does not allow sysdba privileged user as well as other users are connected to the database.

Solution 1: First Check /etc/hosts file if there is incorrect host name or IP correct it and try Start database.

Solution 2: Without shutdown anything just kill that database processes which are not local processes. Local means background processes.

ps -ef | grep $ORACLE_SID | grep -v grep | grep "LOCAL=NO" | awk '{print $2}' | xargs kill -9

Solution 3: Shut down application server sessions