Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01034 and ORA-01034, if starting oracle from script
> 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