RE: Permissions error

[John Kanagaraj]

Title: Message

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' 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-----
From: Bartolo, David [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 02, 2003 5:19 PM
To: Multiple recipients of list ORACLE-L
Subject: Permissions error

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