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
Request clarification before answering.
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.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.