I am doing a DR test for my production SAP database. I restored the datafiles and redo log files onto Windows 2000 Server and Oracle 22.214.171.124. I type:
Connect / as sysdba
At this point we receive the following message:
ORA-01031: insufficient privileges
Windows user as ORA_SID_DBA, ORA_SID_OPER privileges exists. All environment variables look good. I saw that the following parameter is set to true: remote_os_authent = true. Please advise on how to fix this issue.
On the server, create a group called ORA_DBA and add your user to that group. You should be able to CONNECT / AS SYSDBA after that.
Dig Deeper on Oracle database backup and recovery