Q
Problem solve Get help with specific problems with your technologies, process and projects.

Insufficient privileges error connecting as sysdba

I am doing a DR test for my production SAP database. I restored the datafiles and redo log files. I get an insufficient privileges error when I try to connect as sysdba.

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 9.2.0.6. I type:
Sqlplus /nolog
Connect / as sysdba
At this point we receive the following message:
ERROR:
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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close