on 02-06-2014 8:38 AM
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
Dear All,
Issue was resolved by startup force; command.
Thanks a lot!!
Kind regards,
Tamil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pradeep,
Check your oracle's archive directory "/oracle/SID/oraarch "
Regards,
Suresh Daniel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
Were there any changes made to the database prior to this ?
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pradeep,
Please share the last 1000 lines from alert_SID.log file.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.