Re: Starting Oracle Service/Instance

On 22 Jan 2004 15:25:52 -0800, vleandr_at_nai.com (Virginia) wrote:

Don't have my machine in front of me but on Windows you can modify the Instance startup config via a tool off of the Oracle Installation products.

Start > Programs > Oracle

There should be a box for you to check.

>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 - 19:33:39 CST