Have you checked the event logs? Also take a look at Doc # 136214.1 on MetaLink.
Jared On Monday 20 January 2003 13:46, Bob Metelsky wrote: > My scenario > > Fresh install of w2k server, sp 3 high end machine, twin 2G processers > 4G ram ... > Installed Oracle 8.17 release 3, Install went perfectly smooth > built 9 databases connected and imported all data I could connect at > will ... All was well > > The problem: > when the machine reboots, the service and database does not start > automatically.If I try to > sqlplus user/pass@instance > I get the > "Oracle not available", "shared realm does not exist" (in other words > the dbs did not start) > > I can start manually using > startdb.bat > svrmgrl.exe command='@C:\db_startup\initdb8i.sql' > > initdb8i.sql > connect internal/pass@db8i > startup pfile=R:\OR_8I\ADMIN\DB8I\pfile\init.ora > exit > > The instance starts and all is well > #################################################### > > Ive deleted all the services using Oradim and rebooted, then recreated > using > > rem D:\install\setODIM.bat > set db=someinstance > sleep 1 > ORADIM -DELETE -SID %db% > sleep 2 > ORADIM -NEW -SID %db% -INTPWD passwd -STARTMODE auto -PFILE > D:\OraHome1\admin\%db%\PFILE\init%db%.ora -TIMEOUT 90 > sleep 2 > ORADIM -SHUTDOWN -SID %db% -USRPWD passwd -SHUTTYPE srvc,inst -SHUTMODE > i > sleep 2 > ORADIM -STARTUP -SID %db% -USRPWD passwd -STARTTYPE srvc,inst -PFILE > D:\OraHome1\admin\%db%\PFILE\init%db%.ora > echo off > echo. > echo Done creating oradim entries for %db% ! > > If I create one service, using the above batch file I can connect to > the database, > eg ORADIM -STARTUP -SID %db% -USRPWD passwd -STARTTYPE srvc,inst -PFILE > D:\OraHome1\admin\%db%\PFILE\init%db%.ora > but when the machine reboots and I try to connect I get the oracle not > available > > here are my registry settings > http://209.123.6.84/srvreg.jpg > > This is very frustrating as I had this problem on a server that had the > OS upgraded and I could never get the autostart working correctly > This is a new machine and I can reboot at will or make any changes (no > one is using this server yet) so I really need to get this working. > > I am at a loss... any suggestions would be appreciated > > thanks > bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
