Re: oracle 8i database mounted but not opned in winNT4

I had a problem with the database starting but not open after every reboot. In control panel > services the SID would be running but not open. If you are having this problem I would verify this:

1. SQLNET.ORA is set for AUTHENTICATION_SERVICES (NONE) Mine was set for (NTS) and after that change everything started fine without having to log in SQL and "startup open;" Make sure you are aware of the differences as far as security on your database.

Also check the Registry
HKEY_LOCAL_MACHINE/Software/Oracle/Home0/ORA_SID_AUTOSTART and ORA_SID_PFILE.
 AUTOSTART should be TRUE
and the PFILE should point to the correct init.ora

KC

"lba" <lba_at_lamjed.net> wrote in message news:<9uq6r0$ed6$1_at_bolzen.all.de>...
> hi
> my database oracle (vers 8i) start with mounted stat but not opned at start
> up of my server windows NT4 SP6
> how can start my database with stat open directly at start up. (actualy i
> opned it with dba studio)
>
> thanks
> lba
Received on Fri Dec 07 2001 - 21:35:46 CST