oracle's local login
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: oracle's local login

  1. #1
    Join Date
    Mar 2003
    Location
    Miami, FL
    Posts
    10

    Question 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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you dont have the oracle sid set.

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

  3. #3
    Join Date
    Mar 2003
    Location
    Miami, FL
    Posts
    10
    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

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    is this unix?

    whats the permissions on the oracle executable?

  5. #5
    Join Date
    Mar 2003
    Location
    Miami, FL
    Posts
    10
    It is Solaris 9, Oracle 9i

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

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    what are the permissions on the executebale, not who owns it

  7. #7
    Join Date
    Apr 2001
    Posts
    108
    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!

  8. #8
    Join Date
    Mar 2003
    Location
    Miami, FL
    Posts
    10
    755

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you not making this easy

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

  10. #10
    Join Date
    Mar 2003
    Location
    Miami, FL
    Posts
    10
    oops

    -rwsr-s--x 1 oracle dba 55100996 Oct 22 2003 oracle*
    Last edited by marciamg@hotmai; 07-16-2004 at 03: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
  •  


Click Here to Expand Forum to Full Width