This content has been marked as final. Show 11 replies
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.
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 18.104.22.168.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