Re: Starting Oracle 8.1.7 on boot

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3D08B6BB.7C4F7884_at_exesolutions.com...
> 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.

Followed the instructions to the letter, a very basic Oracle install.

>
> You don't mention whether you checked SERVICES in the CONTROL PANEL to see
if
> they are set to automatically start the database.

Yes, those are the services I was referring to.

> 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
>

The Raven Received on Thu Jun 13 2002 - 22:03:58 CDT