Oracle not getting Start

[#1]

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

[tamil_arasan · Accepted solution]

Dear All,

Issue was resolved by startup force; command.

Thanks a lot!!

Kind regards,

Tamil

[Former Member]

Hi Pradeep,

Check your oracle's archive directory "/oracle/SID/oraarch "

Regards,

Suresh Daniel

[Former Member]

HI Pradeep,

What O/S are you running?

1. If windows check that all processes in task manager for Oracle and in MMC was stopped. If linux/aix run command ps -ef |grep ora

2. Are there any processes still running from old, if so check if there are backups or statistics or unfinished jobs running keeping database from shutting down as the others said check your ora alertlog.

3. Once all is checked shut down now processes running ensure you start cleanly. The error could also be a max number of sessions meaning it never shutdown properly.

Please advise on your log.

Kind Regards,

Johan

[Former Member]

Hi,

It seems your DB is already up and running (it says "connected" instead of "connected to idle instance").

Stop SAP instance and try to shutdown the database. Take a reboot of server.

If same issue, then past last 50 lines of alertSID.log

Regards,

Nick Loy

[Reagan]

Hello

Were there any changes made to the database prior to this ?

Regards

RB

[Former Member]

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.

[S_Sriram]

Hi Pradeep

Kindly refer the SAP Note 1202767 - Error: "Failed to retrieve data from the database ORA-01012 : not logged on" when connecti...

Regards

Ram

[Former Member]

Hi Pradeep,

Please share the last 1000 lines from alert_SID.log file.

Regards,

Deepak Kori