unable to connect / as sysdba
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: unable to connect / as sysdba

  1. #1
    Join Date
    Nov 2005
    Posts
    5

    unable to connect / as sysdba

    Hello,

    I'm using a solaris9 machine with oracle9i SE installed. When i try to connect / as sysdba in sqlplus, the following error came out.

    Error ORA-01031: insufficient privileges

    How do I configure so that the machine accept connect / as sysdba to login to sqlplus? I login in as root.

    Thank you.
    Keith

  2. #2
    Join Date
    Sep 2005
    Location
    Philippines
    Posts
    21
    sir
    try to add the oracle user to group OSDBA or OSOPER

    Quote Originally Posted by simply
    Hello,

    I'm using a solaris9 machine with oracle9i SE installed. When i try to connect / as sysdba in sqlplus, the following error came out.

    Error ORA-01031: insufficient privileges

    How do I configure so that the machine accept connect / as sysdba to login to sqlplus? I login in as root.

    Thank you.
    Keith

  3. #3
    Join Date
    Nov 2005
    Posts
    5
    already did,

    user created: oracle
    group created: dba

    dba group consist of root, oracle too.

    any other possiblity?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    root is prevented from doing it, use oracle account

  5. #5
    Join Date
    Nov 2005
    Posts
    5
    The problem is, i need to access oracle using root.

  6. #6
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by simply
    The problem is, i need to access oracle using root.
    Login as root(as you wish to) switch to Oracle user then you can do it.
    "What is past is PROLOGUE"

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    wont work as root, touch luck there

  8. #8
    Join Date
    Nov 2005
    Posts
    5
    the problem is, when I run an application, it will be using root and run some scripts and the script fails coz it will connect / as sysdba

    is there anyway?

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    NO! it wont work as root, you will have to switch to another user or supply the username and password in the script

  10. #10
    Join Date
    Nov 2005
    Posts
    5
    But even I login as oracle user, I can't connect / as sysdba

    Really desperate, do you suggest reinstall oracle9i?

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