Re: ORA-01034: ORACLE not available

Also make sure that the oracle executable has the right permissions. To ensure that they are correct, execute the following commands: chown oracle $ORACLE_HOME/bin/oracle
chmod 4755 $ORACLE_HOME/bin/oracle

This is assuming that the oracle user has the user ID "oracle". If it does not, substitute the name of the user for "oracle" in the above statement.

Kathy Rodittis <rodittis_at_odo.edwards.af.mil> writes:

> Are you sure it's sgadef.dbf and not sgadefA.dbf?
> If you're on Unix, go to $ORACLE_HOME and look for a directory called
> 'dbs'. Check the permissions on sgadefA.dbf in that directory. Here is
> what they should look like:
> -rw-r----- oracle dba ...... sgadefA.dbf
>
> where 'oracle' is the username you set up to run Oracle.
>
> suisum_at_ecn.ab.ca wrote:
>
> > I got the following error. Please help.
> >
> > ORA-01034: ORACLE not available
> > ORA-07318: smsget: open error when opening sgadef.dbf file.
> > SVR4 Error: 13: Permission denied

<snip>
--

                                        Rick
                                        Rick Wessman
                                        Security and Directory Technologies
                                        Server Technologies
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com