Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01034 and ORA-01034, if starting oracle from script

Re: ORA-01034 and ORA-01034, if starting oracle from script

From: cyril <chico_at_grumly.info>
Date: 8 Jul 2004 00:50:53 -0700
Message-ID: <3123d61c.0407072350.652475ce@posting.google.com>


> What are you seeing in your spooled files?

SQL> shutdown immediate;
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory SQL> spool off

This is the same output than my shell prompt.

> The "ORA-01034: ORACLE not
> available" means the database isn't started. And since your scripts
> have so many errors, it's guaranteed you'll never get the db started
> with them. Your spool files should reveal some fundamental problems.

Damned, I don't know Oracle at all, I just have to install a RadHat cluster with an Oracle service and I was trusted The scripts from Redhat.

> First, you have to connect to the instance, and neither your start or
> stop scripts issues a 'connect' command. The string 'sys as sysdba'
> is an argument of the 'connect' command, but you've never said to
> connect.

Actually, I understand that I redirect "sys as sysdba" into sqlplus input. This input, at this moment, correspond when the shell prompt : "Enter user-name:"

I try enter "sys as sysdba" and all is fine, I connect to an idle instance (I specify an empty password)

>
> Second, what is the purpose of the 'open;' command in your startup
> script? If startup works, the database is open -- assuming no
> specific arguments to the contrary.

I trust RedHat ...

>
> And on your shutdown script, why are you doing a 'shutdown abort'?
> While a shutdown abort is recoverable and not to be feared of itself,
> I'd hardly call that a 'tidy' shutdown.

I change it with a "shutdown immediate" but I the problem still remain. Received on Thu Jul 08 2004 - 02:50:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US