RE: ORA-01033 After upgrading Oracle 9.2 to Oracle 10g on Windows
2000. 2004-05-03 - By Josh Collier
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@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of Kumar, Dharminder
Sent: Monday, May 03, 2004 7:49 AM
To: oracle-l@(protected)
Subject: ORA-01033 (See ORA-01033.ora-code.com) 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 (See ORA-01033.ora-code.com) 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@(protected) 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@(protected)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
