I have 2 users: oracle (dba) user and other (staff) user which has permission on Oracle
What happens is that when login to local schema as oracle user for sqlplus, for example, do not need to attach SID; e.g. sqlplus user/passw
but for the other user I have; e.g. sqlplus user/passw@sid
All the ENV vars are set up correctly for the staff user, listener is up so what could be the problem?
07-16-2004, 02:24 PM
you dont have the oracle sid set.
obviously something is different, and you dont even provide an error message
07-16-2004, 02:33 PM
I have the SID environmental var set. This is the error
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
SVR4 Error: 13: Permission denied
this is calling sqlplus user/passw
If attach SID, it is ok, no error
07-16-2004, 02:37 PM
is this unix?
whats the permissions on the oracle executable?
07-16-2004, 02:53 PM
It is Solaris 9, Oracle 9i
Oracle's executables have the permission set on installation, owned by oracle:dba
07-16-2004, 02:55 PM
what are the permissions on the executebale, not who owns it
07-16-2004, 03:09 PM
The second user also needs the envirenment variable LD_LIBRARY_PATH set.
07-16-2004, 03:12 PM
07-16-2004, 03:13 PM
you not making this easy
ls -l oracle, what does that say - i wanna see if the setuid permission is set
07-16-2004, 03:18 PM
-rwsr-s--x 1 oracle dba 55100996 Oct 22 2003 oracle*