cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

Dear Experts,

Oracle was down and we are unable to start it up now.

I am getting the error "ORA-01012: not logged on" once I gave startup; command.

SQL*Plus: Release 11.2.0.2.0 Production on Thu Feb 6 09:19:00 2014

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected.
SQL> startup;
ORA-01012: not logged on
SQL>

Could you please help me to sort it out.

Thanks in advance!

Regards,

Pradeep


0 Likes
View Entire Topic
Former Member
0 Likes

You need to be sure that DBMS was correctly stopped before starting it again. For this please check that no one of  oracle processes exists at OS level, all resources (shared memory, semaphores) are freed and lock file was deleted from dbs/database directory.