| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-01033 After upgrading Oracle 9.2 to Oracle 10g on Windows 2000.
Josh,
This utility is there in 10g too. I tried this utility, but I believe this =
utility does not help in setting up the Oracle Service, but it does tell yo=
u about the oracle OS users and installed databases etc.=20
Thx.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Josh Collier
Sent: May 3, 2004 1:29 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: ORA-01033 After upgrading Oracle 9.2 to Oracle 10g on
Windows 2000.
I am not sure about 10g, but 9i comes with a utility called :Oracle Administration Assistant for Windows NT =20 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=
=3D
phical utility provided by 10g for upgrade. But after upgrade whenever I st=
=3D
art the database using Windows Service OracleServiceSID and then try to con=
=3D
nect to oracle using sqlplus, I get ORA-01033 Oracle Initialization Shutdow=
=3D
n in progress ( I get this error even if I try sqlplus half an hour after b=
=3D
ooting the system).=3D20
But if try to startup the database as follows, the database becomes operati=
=3D
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=
=3D
e and I do not need to manually start the database.=3D20
Thx.
Dharminder Kumar
Senior Consultant
AllStream IT=3D20
<FONT SIZE =3D3D 1>********************************************************=**=3D
-- 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 ----------------------------------------------------------------- <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 -----------------------------------------------------------------Received on Tue May 04 2004 - 09:45:41 CDT
 |
 |