Re: ORA-01034: ORACLE not available

From: Thomas Fischer <himself_at_tfischer.de>
Date: Sun, 05 Mar 2000 13:53:58 GMT
Message-ID: <38c26514.1736837@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:

oracle_at_libretto:/home/oracle > svrmgrl

Oracle Server Manager Release 3.0.5.0.0 - Production

Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production

SVRMGR> connect System_at_ARCH
Password:
ORA-01034: ORACLE not available
SVRMGR> exit
Server Manager complete.

and when I do connect internal:

oracle_at_libretto:/home/oracle > svrmgrl

Oracle Server Manager Release 3.0.5.0.0 - Production

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 - 07:53:58 CST