Re: ORA-01034: ORACLE not available

From: <steve_veilleux_at_canammanac.com>
Date: Wed, 20 Jan 1999 17:18:57 GMT
Message-ID: <78535l$hoi$1@nnrp1.dejanews.com>

In article <36a4cde6.0_at_ecn.ab.ca>,
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
>
> --
> Best regards,
>

Hi,

I found maybe something that can help you : ( Maybe it's something to do with the permission ... check : sgadef file itself or its parent directory (?/dbs)... , check tnsnames.ora and listener.ora whether used the valid alias

Problem Description:

You are trying to connect to sqlplus, and it fails with the following errors:

ora 7318
ora 1034

Problem Explanation:

Operating System permissions need to be set correctly.

Solution Description:

Set the Operating System permissions with the following steps:

cd $ORACLE_HOME/bin
chmod 6751 oracle

hope this Help!

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Jan 20 1999 - 11:18:57 CST