Re: Starting Oracle 8.1.7 on boot

On Thu, 13 Jun 2002 15:14:11 GMT, Daniel Morgan <dmorgan_at_exesolutions.com> wrote:

>The Raven wrote:
>
>> 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
>
>It sounds to me like someone didn't install correctly and you are paying the
>price. You should probably just dump everything and reinstall this time
>following the exact directions on the CD.
>
>You don't mention whether you checked SERVICES in the CONTROL PANEL to see if
>they are set to automatically start the database.
>
>You should also have a system environment variable oracle_sid=<SID name> set in
>CONTROL FILE SYSTEM.
>
>The Oracle service and listener service are all that is required. That using
>some tool solves the problem has nothing to do with starting anything but rather
>is likely related to one of the above.
>
>Either way ... I'd reinstall correctly.
>
>Daniel Morgan

Which implies NOT ON A NETWORK DRIVE.
It simply doesn't work.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jun 13 2002 - 16:03:05 CDT