Re: Oracle starts as idle?

Hi Bob
Are you sure BOTH the service and the instance are started? Connected to an idle instance means the instance was not started. As you can issue a startup without problem that makes suspicions even bigger. Could you verify the oradim73 command in %ORACLE_HOME%\database\strt<SID>.cmd
or check out %RDBMS73%\oradim73.log?

Hth,

--
Sybrand Bakker, Oracle DBA
Bob <meyer_b_at_my-deja.com> wrote in message news:7u5bmg$4km$1_at_nnrp1.deja.com...
> I've just installed a copy of Oracle Workgroup server 7.3.3 on an NT 4.0
> SP3 platform. I've done this numerous times before wtihout problem, but
> this time I have an interesting problem.
>
> After installation I removed the default (ORCL) instand and
> created a new one. According to NT services and Oracle Instance Manager
> this instance is set to start automatically, and it does. At least
> both the instance manager and NT show it as started.
>
> But when I try to access it via SQL, I get a message that the SGA can't
> be found. When I use SVRMGR to connect internal, I can do that, but get
> a message that the database is idle. Issuing a plain START command from
> SVRMGR gets things going, but does anyone have any idea why the database
> is being started as idle? Or what I need to fix to change this?
>
> Thanks much,
>
> Bob
>
> --
> Bob M.
>
> Step outside. The graphics are AMAZING!
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Oct 14 1999 - 16:52:14 CDT