This discussion is archived
8 Replies Latest reply: May 2, 2013 12:52 PM by user5790434 RSS

Oracle 11R2 remote login as sysdba fails

user12004297 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points