Starting Oracle 8.1.7 on boot

OK,

        I know some of you are already saying "What is he on about, it automatically starts?" but there is a little bit more you need to know. For starters, I'm neither an Oracle or W2K expert so forgive me.

I have a W2K SBS server with an Oracle 8.1.7 database on it. For various reasons, Oracle is installed on a shared/mapped drive. Upon W2K startup it attempts to start the necessary Oracle services, which fails presumably because the share/mapping hasn't be loaded/set at this point of the startup.

I've modified the services startup so that it does several retries, on the basis that the map/share will eventually be set. This doesn't seem work or resolve the issue. The problem can't be mappings as I can easily start the services manually.

Now, here's something relatively new.

Until recently I knew that I needed to start only two services: OracleService[SID] and OracleOraHome81TNSListener.

Having recently upgraded from 8.1.5 to 8.1.7 starting the above two services does not seem sufficient as clients get an error "Memory Realm does not exist". The only way I've found to resolve this is to run one of the Oracle config tools (on the server) which apparently kickstarts whatever is needed. I've attempted to identify what this bit is but I can't see any additional services or processes starting etc.

In summary, Oracle won't automatically start nor will manually starting the relevant services (those I know of). Instead I resort to the half baked solution of starting a tool to kick start Oracle. This becomes a major pain when the server is reset because I am the only person who can get Oracle started.

Can one of our more enlightened users share their knowledge with a Oracle ignorant like myself? Any assistance will be greatly appreciated.

PS. Sorry if I offend anyone with the crossposting but I thought these were all relevant groups to ask.

The Raven Received on Wed Jun 12 2002 - 23:48:16 CDT