This content has been marked as final. Show 11 replies
I think there is some lock being held on oracle by a previous shutdown.
Try do this:
Go to the task manager and kill 'oracle.exe'. Kill if there is any sqlplus.exe and tnslsnr.exe also.
Also, How many databases are running on this windows 7 machine?
970292 wrote:What edition of Windows? Home? Pro? Ultimate?
To give a small background , today I was getting the following error while trying to connect to one of the schema.
I am seeing the same error on my EM console too.
ORA-01033: ORACLE initialization or shutdown in progress (DBD ERROR: OCISessionBegin)
To resolve this issues , I thought of doing a manual start up . The shutdown was successful and failed to mount the DB . I am getting this error "ORA-01102: cannot mount database in EXCLUSIVE mode"
SQL> shutdown abort;
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size 2176288 bytes
Variable Size 1275071200 bytes
Database Buffers 369098752 bytes
Redo Buffers 7172096 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode
Could someone help me in resolving this issue? I am using Oracle 11.2.0 on Window 7
Thanks for your response .
I could see two processes oracle.exe . I could not kill one of them .
Image Name PID Session Name Session# Mem Usage
========================= ======== ================ =========== ============
oracle.exe 2856 Services 0 268,388 K
oracle.exe 5408 Services 0 211,972 K
Though I kill both the process . (Process 2856 always shows up ) . Killing the process 5408 stops the Oracleservice.
Also only one DB is set up on this machine.
Windows 7 Professional edition
Do you have Oracle restart setup on your machine?
How many databases are running on this machine?
There is only one DB instance running on my machine .
I don't have restart set up .
Go to the command prompt and run this command and post the result
crsctl stop has
I am not able to execute this command
C:\windows\system32>crsctl stop has
'crsctl' is not recognized as an internal or external command,
operable program or batch file.
(Do I need to install any utility ?)
I just of sharing the output the listerner status
LSNRCTL for 32-bit Windows: Version 10.1.0.5.0 - Production on 15-MAR-2013 16:44
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
Version TNSLSNR for 64-bit Windows: Version 22.214.171.124.0 - Produ
Start Date 15-MAR-2013 15:34:26
Uptime 0 days 1 hr. 9 min. 38 sec
Trace Level off
Security ON: Local OS Authentication
Listener Parameter File C:\POSSuiteApps\OracleDB\product\11.2.0\dbhome_1\netwo
Listener Log File c:\possuiteapps\oracledb\diag\tnslsnr\lapattab-us\list
Listening Endpoints 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 BLOCKED, has 1 handler(s) for this service...
The command completed successfully
Could someone help me in resolving this issue? I am using Oracle 11.2.0 on Window 7which version of windows 7 you are using ?
I am using Windows 7 Professional edition (64 bit) .
Also , I tried restarting my machine which killed one of the oracle.exe process and I was able to start and mount the DB successfully .
Edited by: 970292 on Mar 18, 2013 11:46 AM
This is what I was trying to achieve by getting your process killed. In Windows , "Restart always works" ;)
Please mark your question answered if your problem is resolved.