You're the man Jared....! The doc you referred me to 136214.1, referered to a patch 1522966 which basically has you Stop all services/instances Rename %Oracle_Home%\bin\orannts8.dll to orannts8.dll.bad Then copy over the new orannts8.dll that's provided in the patch Reboot
All my instances are auto starting! Many thanks bob > 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). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky 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).
