We are using Win2k3 service pack 2 and on our HP G6 servers some of our customers are having issues that the Oracle (10g) services are not restarting after reboot. We logged a case with Oracle and they said it is a bug that they have chosen not to fix. The bug, they say is with the OS in that it is not waiting long enough for the Oracle services to terminate and so it is causing Oracle to Crash. So after reboot Oracle is attempting to recover and it is taking longer than the OS allows and the service never actually starts. Our customers have to have an Admin go in and stop and restart the Oracle services manually and then the database comes up. Anyone else run into this and have any suggestions? We have put some shutdown and startup scripts in the Group Policy that tries to shutdown the database cleanly on shutdown and then restart the services again on startup. These scripts do allow the database to startup ok after reboot, but there are just some adverse side effects with our application that we would like to avoid. Any suggestions would be appreciated. TIA

Before any reboot of an Oracle server you should properly shutdown your database with the proper commands within Oracle which would stop this from happening.

Before any reboot of an Oracle server you should properly shutdown your database with the proper commands within Oracle which would stop this from happening. That is what we are doing with the group policy shutdown/startup scripts we implemented. But in order to get those scripts to work, there is a unwanted side effect to our application. In order to get those startup/shutdown scripts to work, we had to implement NT Authentication via the entry in the sqlnet.ora file. We then also had to add the app owner to the OS Group - ORA_DBA so the user can get logged into sqlplus to issue the Oracle shutdown and startup commands. Once we added those changes, it prevented users from logging into our application from the database server. We can not go back and change our application to allow the logins to work in this situation. We just want the OS to wait long enough for the Oracle Services to stop before shutting down the server.

Oracle is not very good on PC servers. They ignore the issues at their peril as rivals without the problems are plentiful. I have run across lots of gripes over the years with their PC servers. I am on their forums occasionally. Windows MVP, XP, Vista, 7. Expanding into Windows Server 2008 R2, SQL Server, SharePoint etc. I feel badly for my American friends who have to endure the extremists in Washington who are bankrupting the nation over ideology. My page on Video Card Problems is now my most popular landing page. See my gaming site for game reviews etc. Developer | Windows IT | Chess | Economics | Hardcore Games | Vegan Advocate | PC Reviews

I know what Oracle is talking about on this, it is a bug with Oracle 10g that they don't address. The token reply from Oracle is how wonderful upgrading to 11 is for you. Sad fact is that you will need to Manually shut down Oracle, I have not seen many Oracle dba's have luck scripting it, maily because the script runs faster than Oracle can shut down cleanly.:P Advice offered, If you need more help it is advised to seek the council and advice of paid professionals. The answer is always 42, or reboot.

If Oracle Services stay open until all processes have ended you would get this hang up. Oracle likes to finish it processing but this processing can take a long period of time which is why a shutdown immediate is needed to shutdown the DB before a reboot. Try raising the time instead of lowering the time for fast shutdown http://www.extremestudio.ro/blog/?p=807

In my shop I have more options, and Linux is well known for its capabilities. I use Linux here extensively. I also have SQL Server so that is what I use on my server If you can, look into migrating away from Oracle as they seem to be getting too expensive (not as many developers) compared to rivals Windows MVP, XP, Vista, 7. Expanding into Windows Server 2008 R2, SQL Server, SharePoint etc. I feel badly for my American friends who have to endure the extremists in Washington who are bankrupting the nation over ideology. My page on Video Card Problems is now my most popular landing page. See my gaming site for game reviews etc. Developer | Windows IT | Chess | Economics | Hardcore Games | Vegan Advocate | PC Reviews

Hello, for Oracle issues, contact Oracle Technical Support. This posting is provided "AS IS" with no warranties or guarantees , and confers no rights. Microsoft Student Partner 2010 / 2011 Microsoft Certified Professional Microsoft Certified Systems Administrator: Security Microsoft Certified Systems Engineer: Security Microsoft Certified Technology Specialist: Windows Server 2008 Active Directory, Configuration Microsoft Certified Technology Specialist: Windows Server 2008 Network Infrastructure, Configuration Microsoft Certified Technology Specialist: Windows Server 2008 Applications Infrastructure, Configuration Microsoft Certified Technology Specialist: Windows 7, Configuring Microsoft Certified IT Professional: Enterprise Administrator Microsoft Certified IT Professional: Server Administrator

You might try increasing the service <var>TimeoutPeriod</var>. http://support.microsoft.com/kb/824344 Regards, Dave Patrick .... Microsoft Certified Professional Microsoft MVP [Windows]