Re: ORA-01034: ORACLE not available

From: joon <joopark_at_home.com>
Date: Sun, 05 Mar 2000 17:12:19 GMT
Message-ID: <Tzww4.97655$up4.1555771@news1.rdc1.ab.home.com>

Whatup/

Yes, database never been mounted and opened. That ' s why Looks like you several instances, and starting wrong one

You should have initial file called "initARCH.ora" or something It is in $ORACLE_HOME/dbs/

go like this

>srvmgrl
>connect internal
>startup pfile=$ORACLE_HOME/dbs/initARCH.ora
>select * from v$database;

Let me know how it goes.

"Thomas Fischer" <himself_at_tfischer.de> wrote in message news:38c26514.1736837_at_news.uni-kassel.de...
> Hi,
>
> On Sun, 05 Mar 2000 06:27:59 GMT, "joon" <joopark_at_home.com> wrote:
>
> >Well, If your SID=ARCH and running internally , then you should be fine
for
> >Listener.
> >Which SID you want to use?
> ARCH
>
> >Is server really started?
> after 'dbstart', 'lsnrctl start' says:
>
> TNS-01106: Listener using listener name LISTENER has already been
> started
>
> >Test like
> >>srvmgrl
> >>connect internal/password_at_servicename
> >>startup
>
> two things can happen. when I log on as System I get ORACLE not
> available:
> --------------------------------------------------------------------------

> and when I do connect internal:
> --------------------------------------------------------------------------

> oracle_at_libretto:/home/oracle > svrmgrl
>
> Oracle Server Manager Release 3.0.5.0.0 - Production
>
> (c) Copyright 1997, Oracle Corporation. All Rights Reserved.
>
> Oracle8 Release 8.0.5.0.0 - Production
> PL/SQL Release 8.0.5.0.0 - Production
>
> SVRMGR> connect internal
> Connected.
> SVRMGR> startup
> ORACLE instance started.
> Total System Global Area 4554000 bytes
> Fixed Size 48400 bytes
> Variable Size 4227072 bytes
> Database Buffers 204800 bytes
> Redo Buffers 73728 bytes
> ORA-00205: error in identifying controlfile, check alert log for more
> info
> SVRMGR> shutdown
> ORA-01507: database not mounted
> ORACLE instance shut down.
> SVRMGR> exit
> Server Manager complete.
> -------------------------------------------------------------------------
>
> Thanks,
> Tom
Received on Sun Mar 05 2000 - 11:12:19 CST