ora-01031 connecting as sys using remote connection ( via Tns'@')
I need to build active Dataguard and I created standby instance and when I tried to connect to database as sysdba ,Getting 01031 insufficient privileges
I used sqlplus sys/<password>@GPRSB as sysdba , when I omit "@" it will connect with no issues.I checked everything
1. remote_login_passwordfile is set to EXCLUSIVE
2. select * from v$pwfile_users shows user SYS with sysdba privs as TRUE
3. recreated password file with options ( ignorecase=Y,nosysdba=n,force=Y,password=<password>) . but still I see the problem
4. correct permissions are set to password file
5. Os user is in DBA group,Oinstall
6. Tnsping works fine
0