8 Replies Latest reply: May 2, 2013 2:52 PM by user5790434 RSS

    Oracle 11R2 remote login as sysdba fails

    user12004297
      Hello

      i cant connect remotely as sysdba from client to server - oracle version SQL*Plus: Release 11.2.0.2.0

      the configuration is the following

      orapwd file=orapwdTESTDB entries=30 password=mypassword force=y
      on the init.ora i have the following

      remote_login_passwordfile=EXCLUSIVE

      and while going to another server i keep getting the following error message

      sqlplus sys/mypassword@testdb as sysdba

      SQL*Plus: Release 11.2.0.2.0 Production

      Copyright (c) 1982, 2010, Oracle. All rights reserved.

      ERROR:
      ORA-01031: insufficient privileges



      What else im missing? i had this configuration in oracle 10G and worked fine
      thanks