Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01033: ORACLE initialization or shutdown in progress

973295Jan 10 2013 — edited Jan 10 2013
Hello ,

I am using Oracle 11.2.0 on Window 7 and since yesterday I am unable to connect to my database . I am seeing this error on my EM console.

ORA-01033: ORACLE initialization or shutdown in progress (DBD ERROR: OCISessionBegin)

I tried to manually shutdown and startup from the console but resulted in the same error.

I was not able to connect from sqlplus as well.

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Jan 10 11:58:58 2013

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

Enter user-name: SYS
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error

Here is the lsnrctl status

C:\windows\system32>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.1.0.5.0 - Production on 10-JAN-2013 11:59
:37

Copyright (c) 1991, 2004, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 10-JAN-2013 10:39:08
Uptime 0 days 1 hr. 20 min. 29 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\POSSuiteApps\OracleDB\product\11.2.0\dbhome_1\netwo
rk\admin\listener.ora
Listener Log File c:\possuiteapps\oracledb\diag\tnslsnr\<host>\list
ener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>)(PORT=1521
)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl.us.oracle.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

Could someone help me out in resolving this issue.

Thank you,
Lakshmi
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 7 2013
Added on Jan 10 2013
17 comments
2,276 views