Results 1 to 9 of 9
  1. #1
    Join Date
    Apr 2003
    Posts
    9

    Angry Unanswered: remote login as sysdba

    Hello,

    I installed an 9i-database "test" on an w2k-client.
    After installation the remote_login_passwordfile - parameter in
    the .ini file was automatically set to exclusive.

    Then I grant a user test2 with "grant sysdba to test2" dba rights.

    Now the problem, why it is not possible to connect from a remote
    client with" connect test2/test2@test as sysdba". I always get
    the errormassage: ORA-01031: insufficient privileges

    It is also not possible to connect with sys as sysdba remote.
    Connecting sys without sysdba the message:
    ORA-28009: connection to sys should be as sysdba or sysoper.


    Thanks in advance.

  2. #2
    Join Date
    Jul 2003
    Posts
    11
    In sqlnet.ora file, comment out
    #SQLNET.AUTHENTICATION_SERVICES = (NTS)
    and try again.

  3. #3
    Join Date
    Jul 2003
    Posts
    11
    In sqlnet.ora file, comment out
    #SQLNET.AUTHENTICATION_SERVICES = (NTS)
    and try again.

  4. #4
    Join Date
    Apr 2003
    Posts
    9
    Originally posted by Harsh
    In sqlnet.ora file, comment out
    #SQLNET.AUTHENTICATION_SERVICES = (NTS)
    and try again.

    Thanks for help Harsh,

    but in my SQLNet.ora is this line:

    SQLNET.AUTHENTICATION_SERVICES = (none)

  5. #5
    Join Date
    Jul 2003
    Posts
    11
    You need to do the following:
    1. Create a password file:
    orapwd file=PWD<sid>.ora password=<password> entries=<users>
    where file - name of password file
    password - password for SYS and INTERNAL
    entries - maximum number of distinct DBA and OPERs

    The password file is located in $ORACLE_HOME\database in WIN2k
    Goto directory database like
    D:\oracle\ora92\database
    and execute

    orapwd file=PWDabc.ora password=abc entries=5

    HTH
    ~Harsh

  6. #6
    Join Date
    Apr 2003
    Posts
    9
    Originally posted by Harsh
    You need to do the following:
    1. Create a password file:
    orapwd file=PWD<sid>.ora password=<password> entries=<users>
    where file - name of password file
    password - password for SYS and INTERNAL
    entries - maximum number of distinct DBA and OPERs

    The password file is located in $ORACLE_HOME\database in WIN2k
    Goto directory database like
    D:\oracle\ora92\database
    and execute

    orapwd file=PWDabc.ora password=abc entries=5

    HTH
    ~Harsh
    Thanks,

    but this is already done. I executed the orapwd - command.
    With select * from v$PWfile_users i can see all the users
    that i gave sysdba - rights.

    Only the remote - connect as sysdba is not possible ......

  7. #7
    Join Date
    Jul 2003
    Posts
    11
    I also have the same configuration 9i on win2k and I'm able to connect from client as sysdba.
    The difference is
    in sqlnet.ora file, authentication is set to NTS at client and server side.
    SQLNET.AUTHENTICATION_SERVICES = (NTS)

  8. #8
    Join Date
    Apr 2003
    Posts
    9
    Originally posted by Harsh
    I also have the same configuration 9i on win2k and I'm able to connect from client as sysdba.
    The difference is
    in sqlnet.ora file, authentication is set to NTS at client and server side.
    SQLNET.AUTHENTICATION_SERVICES = (NTS)


    Hello,

    i did a big mistake ;(((. I forgot to tell that my client is a 8.0.5 client.

    Now i installed the 9i-client and it works.

    Is is correct, that the problem occours with an older client ?

    Thanks for your help again !!

  9. #9
    Join Date
    Jul 2003
    Posts
    11
    The minimum version of Oracle client required to connect 9i Release2
    is 8.0.6.
    But Oracle 9i Release1 works with 7.x

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •