Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Posts
    80

    Unanswered: Remote connect error

    When I connect to a remote Oracle server with a normal user by using sqlplus, it is ok

    "
    SQL> connect dpsdev@dpsdev/dpsdev
    Connected.
    "

    However, when I connect with a sysdba user, it prompts the following error:

    "
    SQL> connect system@dpsdev as sysdba
    Enter password:
    ERROR:
    ORA-01031: insufficient privileges
    "

    If I go to the server console and directly connect to the Oracle, it is ok.

    "
    SQL> connect / as sysdba
    Connected
    "

    How can I fix the problem?

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    You need a password file for remote sysdba connections

    http://download-uk.oracle.com/docs/c....htm#sthref139


    .

Posting Permissions

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