ORA-01033: ORACLE initialization or shutdown in progress
673774Dec 3 2008 — edited Dec 31 2008Hi,
I get the following issue "ORA-01033: ORACLE initialization or shutdown in progress"
case1:
--------------------------------------------------------------------------------------------------------
[oracle@testin99hl985v4 ~]$ sqlplus system/manager@test
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 23 21:33:30 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
------------------------------------------------------------------------------------------------------------
but this issue does not occur in the below case
case 2:
--------------------------------------------------------------------------------------------------------------
[oracle@testin99hl985v4 ~]$ ORACLE_SID=test
[oracle@testin99hl985v4 ~]$ export ORACLE_SID
[oracle@testin99hl985v4 ~]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 23 21:34:08 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: system
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
-------------------------------------------------------------------------------------------------------------------------
machine details:
Linux testmachine 2.6.9-42.ELsmp #1 SMP Wed Jul 12 23:27:17 EDT 2006 i686 i686 i386 GNU/Linux