Re: Help needed on oracle error
Date: 1996/10/02
Message-ID: <3253409D.240A_at_tibalt.supernet.ab.ca>#1/1
Erwin Joosten wrote:
>
> Can someone help me with the next error message:
>
> ERROR: ORA-01034: ORACLE not available
> ORA-07320: smsget: shmat error when trying to attach sga
> AT&T System V/386 Error: 13: Permission denied.
>
> I'm running oracle 7.0.16 on a SCO UNIX 3.2 server. It occures when i login
> to oracle with just a unix account. when i login as oracle i have no
> problems, which rights must i set to correct this problem.
Do you have the correct pointers (usually UNIX environment variable $ORACLE_SID) set?
I normally put the $ORACLE_HOME/bin/oraenv (or coraenv for C shell) script into a public directory (/usr/local/bin is a good one) and have the users run that before running apps (SQL*Plus). oraenv can be run from your .profile.
/Hans Received on Wed Oct 02 1996 - 00:00:00 CEST