Re: ORA 01034 and ORA 07320

Check the permissions on $ORACLE_HOME/bin/oracle. It should be setuid to the oracle user (4755). If it is not, that's why the failure is occurring.

My only concern is why it is succeeding using SQL*Net. Is the listener setuid to the Oracle user? If so, that's why it works through SQL*Net. In most cases, the listener should not be setuid. However, it may have had to be in 7.3.

                                     Rick

Mirena Wanadoo <mirena_at_wanadoo.fr> writes:

> I am working under Oracle 7.3.3.6 with SQL*PLUS 3.3.3.0.
>
> On this server, when I am trying to connect by the command "sqlplus
> user/password", I have the following error:
> ERROR: ORA-01034: ORACLE not available
> ORA-07320: smsget: shmat error when trying to attach sga
> IBM AIX RISC System/6000 Error: 13: Permission Denied.
>
> Tests:
> When the user unix belongs to groupe dba, it works well.
> With the connexion by sqlnet, it works well too.
>
> Have you any idea to correct this problem of the connection "sqlplus
> user/password"?
>
> Thanks very much.
>
>
>

-- 
                                Rick Wessman
                                Security Assurance Group
                                Oracle Corporation
                                Rick.Wessman_at_oracle.com

     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.