Re: Unix users cannot access Oracle

Konstantin,

Do you get a message like the following?

ERROR: ORA-01034: ORACLE not available
ORA-07320: smsget: shmat error when trying to attach sga. $YourUnixOS Error: ##: Permission denied

If so, your Unix permissions are probably wrong for the oracle file located in $ORACLE_HOME\bin.

Incorrect permissions:
-rwxr-x--x oracle dba $filesize $date oracle

Correct permissions:
-rwsr-s--x oracle dba $filesize $date oracle

Issue a chmod 6751 oracle to correct the problem.

-William Huang / mailto:whuang_at_earthlink.net

Konstantin Kivi <kivi_at_glas.apc.org> wrote:
>
> Hello All!
>
> My company have recently moved from Oracle 6 to 7.
>
> With Oracle 6 every Unix user had access to the
>
> database providing all environment variables was
>
> set properly. In Oracle 7 however, only oracle
>
> user can start sqlplus and so on. All others
>
> get an error message like "shmat or shmget failed".
>
> What is wrong with shared memory? Is it Unix or
>
> Oracle problem? What should I do about it.
>
> Thank you in advance
>
> Konstantin Kivi.
Received on Sun Mar 10 1996 - 00:00:00 CET