oracle's local login

[marciamg@hotmai]

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?
Thanks

[davey23uk]

you dont have the oracle sid set.

obviously something is different, and you dont even provide an error message

[marciamg@hotmai]

I have the SID environmental var set. This is the error
ERROR:
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
SVR4 Error: 13: Permission denied


Enter user-name:
*****
this is calling sqlplus user/passw
If attach SID, it is ok, no error

[davey23uk]

is this unix?

whats the permissions on the oracle executable?

[marciamg@hotmai]

It is Solaris 9, Oracle 9i

Oracle's executables have the permission set on installation, owned by oracle:dba

[davey23uk]

what are the permissions on the executebale, not who owns it

[justadba]

The second user also needs the envirenment variable LD_LIBRARY_PATH set.

[marciamg@hotmai]

755

[davey23uk]

you not making this easy

ls -l oracle, what does that say - i wanna see if the setuid permission is set

[marciamg@hotmai]

oops

-rwsr-s--x 1 oracle dba 55100996 Oct 22 2003 oracle*