RE: Permissions error

Was 'root.sh' run successfully? This should set the SUID/GID (set-UID and GID) on the 'oracle' executable...  

$ ls -l $ORACLE_HOME/bin/oracle

-rwxr-x--x 1 oracle dba 33734776 Jul 9 13:19 /u01/c4prdb/8.1.7/bin/oracle

If this is what you see (i.e. rwxr-x---x), then login as 'oracle' and add the SUID bit using the command  

$ chmod ug+s oracle
 

You should see that the permission changes to 'rws-r-s--x'. You may also have to restart the instances after this change... (not sure about DEC ALPHA).   John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)

Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' <http://www.needhim.org'/> for Grace and Mercy that is freely available!

• The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

-----Original Message-----
Sent: Tuesday, September 02, 2003 5:19 PM To: Multiple recipients of list ORACLE-L

Hi All

I get this error when I try to log into sqlplus from my DEC ALPHA machine through a telnet session.

Enter user-name: testid
Enter password:
ERROR: ORA-01034: ORACLE not available
ORA-07320: smsget: shmat error when trying to attach sga. DEC OSF/1 (AXP) Error: 13: Permission denied

Did some permissions get corrupted. I am able to connect using sqlplus from my oracle account.
This happens when I try to connect from a different account.

Thanks
David

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).