ORA-01033: ORACLE initialization or shutdown in progress or Process ID: 0 & Session ID: 0
Some times database will not mount correctly. we need to mount it manually step by step..C:\Users\Administrator>sqlplus
SQL*Plus: Release 11.2.0.2.0 Production on Mon Jul 25 14:59:33 2016
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: system
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
Enter user-name:
For manual shutdown and startup the database you need to follow the steps, first Shut down it and start it up then mount.see following commands and how to run the commands.
- sqlplus / as sysdba;
- shutdown immediate;
- startup nomount;
- alter database mount;
- alter database open;
ORA-01031: insufficient privileges.
then you have to run it as "sys as sysdba" and followed by the sequence.
Please check the below image I have executed the commands and able to connect the sysdba user.
Once all the commands were executed successfully, now oracle is mounted and open state and your able to connect the users.
In the above image also I am not able to connect sysdba, the I will use the sys as sysdba to connect.
I am facing same issue : ORA-01033: ORACLE initialization or shutdown in progress or Process ID: 0 & Session ID: 0
ReplyDeleteand while trying above solution not able to login as sysdba
showing this error --
C:\windows\system32>sqlplus / as sysdba;
SQL*Plus: Release 12.1.0.1.0 Production on Mon May 13 16:53:40 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Hi,
DeleteI am not able to run this "alter database open;" command
Error :
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2:
'D:\DSPLM\PRODUCT\ORACLE\ORADATA\X3DEXP19XX3DPASS_ADMIN.DBF'
It seems there is one data file missing from your database.
Deletetry to query this : select NAME from v$datafile where file#=2;
if the datafile missing or not readable from os .. you will get this error.In this case you have to drop the data file and try to open.
alter database datafile 2 OFFLINE DROP;
alter database open;
Thanks Murthy for this solution. This worked for me.
DeleteHey,
ReplyDeleteStep 1 is not working for me
Error :
Microsoft Windows [Version 10.0.17134.706]
(c) 2018 Microsoft Corporation. All rights reserved.
C:\windows\system32>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Tue May 14 11:37:47 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: sys as sysdba
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
Please help..
alter database mount
ReplyDelete*
ERROR at line 1:
ORA-00214: control file 'C:\APP\HOME\PRODUCT\18.0.0\ORADATA\XE\CONTROL01.CTL'
version 24566 inconsistent with file
'C:\APP\HOME\PRODUCT\18.0.0\ORADATA\XE\CONTROL02.CTL' version 24564
at step 4 i'm getting this error
please reply
Deleteshutdown immediate;
ReplyDeleteORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2260048 bytes
Variable Size 616563632 bytes
Database Buffers 444596224 bytes
Redo Buffers 5517312 bytes
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info
please help!!!
Delete