Starting Oracle Service/Instance

From: Virginia <vleandr_at_nai.com>
Date: 22 Jan 2004 15:25:52 -0800
Message-ID: <84c080d3.0401221525.5729705c@posting.google.com>

Platform: Windows 2000
Oracle 8i and Oracle 9i are installed on the same machine. Oracle 9i is the HOME.

I upgraded (using the Database Upgrade Assistant) a database from 8.1.7 to 9.2.

The Windows service (OracleService<SID>) starts fine wtih no errors. However, I cannot connect to the database. It seems that the database has to be started manually! I have to log into Oracle via SQLPLUS /nolog. I then connect as SYSDBA and issue the STARTUP command and the database starts right up with no problems.

I've tried using ORADIM to have the database mount and open automatically when the Windows Service is started. This didn't seem to have any effect.

Any ideas? I've spent much of today looking on google, metalink, and the Oracle documentation and can't seem to get pointed in the right direction!

Thank you for your time.

Virginia

PLEASE NO SPAM Received on Thu Jan 22 2004 - 17:25:52 CST