Re: Oracle8i on NT Oracle 8i on NT error "Oracle not available"

In that case :
Two other ways to try to resolve it and one suggestion

The service should start using a file called strt<SID>.cmd This file used to sit in %ORACLE_HOME%\database but on Oracle8i they probably changed the location.
The file has an oradim command in it.
The command line is probably reading
-starttype srvc
instead of
-starttype srvc, inst
If this is true, there are 2 ways to resolve it: 1 edit the instance using oradim in GUI mode (so not from a DOS box) 2 edit the .cmd file directly

The other possibility is the internal password on the command line is incorrect or the internal password doesn't match the SYS password.

Hth,

Sybrand Bakker, Oracle DBA

<bstvalue_at_my-deja.com> schreef in berichtnieuws 8hjju1$gfb$1_at_nnrp1.deja.com...
> Thanks for the reply. The service starts ok. No problems are reported
> in the event viewer. I do not think there is any
> problem because when I start the instance manually it starts fine, and
> I'm able to do anything.
> I think there must be a place where I can specify that I want the
> *service* and *instance* to start when the machine is
> booted "You can do that in Windows NT Instance Manager " but I do not
> have that. Also I tried to do it using
> ORADIM.EXE which is the CLI for NT Instance Manager but no luck.
>
> Thanks,
> Marwan
>
>
> In article <960314426.17092.0.pluto.d4ee154e_at_news.demon.nl>,
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> > Check for error messages in oradim.log in your Oracle_home directory
 tree.
> > Something *must* be going wrong during service startup.
> > Alternatively you could query the NT event viewer, or the alert log,
 but
> > probably it doesn't get that far.
> > To start the *service* manually use
> > net start OracleService<SID>
> > to capture interactively the error message.
> >
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
> >
> > <bstvalue_at_my-deja.com> schreef in berichtnieuws
> > 8hjct6$p50$1_at_nnrp2.deja.com...
> > > How I can make an Oracle instance start automatic ? And yes, the
 service
> > > starts automatic and fine. I checked it in the Control Panel -->
 Services
> > > and I see it as started. Also going to properties it's marked as
 Automatic.
> > > What I endup doing is connect internal, and I do a manual startup to
 the
> > > database using the pfile parameter.
> > >
> > > Note: The error message I get is Oracle not available.
> > >
> > > Thanks,
> > >
> > > Marwan
> > > bstvalue_at_hotmail.com
> > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Jun 06 2000 - 00:00:00 CDT