Virginia wrote:
> 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
Go to c:\oracle\ora92\bin (or its equivalent)
Use oradim.exe to drop the existing service and recreate with "startmode
auto".
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Thu Jan 22 2004 - 23:49:26 CST
