RE: ORA-01033 After upgrading Oracle 9.2 to Oracle 10g on Windows 2000.

From: Josh Collier <Josh.Collier_at_Banfield.net>
Date: Mon, 3 May 2004 10:29:06 -0700
Message-ID: <219647973E94D211A8F20008C709725211D6B824@mercury.hq.vetsmart.com>

I am not sure about 10g, but 9i comes with a utility called :Oracle Administration Assistant for Windows NT you can use this to set the database to open with the service starts.

Josh C.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Kumar, Dharminder Sent: Monday, May 03, 2004 7:49 AM
To: oracle-l_at_freelists.org
Subject: ORA-01033 After upgrading Oracle 9.2 to Oracle 10g on Windows 2000.

Hi All,

Recently I upgraded an Oracle 9.2 database to Oracle 10g using dbua the gra=
phical utility provided by 10g for upgrade. But after upgrade whenever I st=
art the database using Windows Service OracleServiceSID and then try to con=
nect to oracle using sqlplus, I get ORA-01033 Oracle Initialization Shutdow=
n in progress ( I get this error even if I try sqlplus half an hour after b=

ooting the system).=20

But if try to startup the database as follows, the database becomes operati= onal and then I can connect to the database without above error.

SQL>connect /nolog;
sql> conn sys/password_at_sid as sysdba;
sql>shutdown;
sql>startup;

.....

So where should I look into so that Oracle DB start with the Windows Servic= e and I do not need to manually start the database.=20 Thx.

Dharminder Kumar
Senior Consultant
AllStream IT=20

<FONT SIZE =3D 1>**********************************************************=
******************
This e-mail and any attachments may contain confidential and privileged inf=
ormation. If you are not the intended recipient, please notify the sender i=
mmediately by return e-mail, delete this e-mail and destroy any copies. Any=
 dissemination or use of this information by a person other than the intend=

ed recipient is unauthorized and may be illegal. Unless otherwise stated, o= pinions expressed in this e-mail are those of the author and are not endors= ed by the author's employer.</FONT>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Mon May 03 2004 - 12:26:43 CDT