-
oracle's local login
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
-
you dont have the oracle sid set.
obviously something is different, and you dont even provide an error message
-
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
-
is this unix?
whats the permissions on the oracle executable?
-
It is Solaris 9, Oracle 9i
Oracle's executables have the permission set on installation, owned by oracle:dba
-
what are the permissions on the executebale, not who owns it
-
The second user also needs the envirenment variable LD_LIBRARY_PATH set.
Eric Hanson
There are 10 types of people in the world:
Those who understand binary and those who don't!
-
-
you not making this easy
ls -l oracle, what does that say - i wanna see if the setuid permission is set
-
oops
-rwsr-s--x 1 oracle dba 55100996 Oct 22 2003 oracle*
Last edited by marciamg@hotmai; 07-16-2004 at 02:21 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|