I'm running Oracle9i on a WindowsXP machine. I have my own service application that is set to startup automatically and has the Oracle Service specified as a dependency. The problem is that if both the Oracle Service and my service are not running and I then attempt to start up my dependent service (e.g. when I re-start the machine) my dependent service starts up before the Oracle Service has finished starting and it fails when attempting to connect to the database. Now my understanding of service dependencies in the XP service manager is that the dependant service wouldn't try to start until the service it is dependent upon had completely finished starting up. So what's going on? How do I force my service to wait until the Oracle Database Service has finished starting up?
I'm not exactly sure how to get services to be dependant on another service. It has always been my experience that services are independant of each other. So if I had to fix your problem, I'd code my routine which runs as a service to do some error checking to verify that the database is up and running. If the database is not up and running, then I'd either wait and try again, or I'd have the process abort. If that doesn't help you, then your best bet is to converse with Windows API forums as this really isn't an Oracle database issue.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.