Re: Starting Oracle 8.1.7 on boot

OraDim is what you should be using and making the services dependent on something (like the existence of the drive mappings ) .

You can do this reasonable easily using a C program (or even some scripting ) to call the Windoze APIs to check for the existence of the logons etc and then kick Oradim

write yer own service to sleep until the maps exist then make oracle dependent on that service.

Writing a service in c is quite easy.

"The Raven" <wsmc_at_flashmail.com> wrote in message news:ae982i$iun$1_at_otis.netspace.net.au...
> 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 Thu Jun 13 2002 - 04:52:08 CDT