Home » RDBMS Server » Networking and Gateways » ORA-01031: insufficient privileges
ORA-01031: insufficient privileges [message #376503] Wed, 17 December 2008 11:12 Go to next message
Messages: 1
Registered: December 2008
Junior Member

Hello all, could a little direction here.

OS: CentOS 5.2 (same as RHEL 5)
Oracle: 10gR2 (

I am attempting to connect from one oracle server to another via sqlplus, once this works I will try rman. When I attempt to run the command "sqlplus sys/password@otherdb as sysdba" I get the following error:

ORA-01017: invalid username/password; logon denied

I have checked and recreated the orapwd file, I have also verified the remote_login_passwordfile is exclusive on both servers. At this time the sys passwords match on both servers. I have also verified that the oracle user is in the oinstall and the dba groups.

I am not quite sure where to go from here to track this one down. Any advice or pointers that set me in the right direction would be appreciated.

Re: ORA-01031: insufficient privileges [message #376563 is a reply to message #376503] Wed, 17 December 2008 20:07 Go to previous message
Messages: 2794
Registered: April 2006
Senior Member
Your title says "ORA-01031: insufficient privileges", yet your post mentions "ORA-01017: invalid username/password; logon denied" ? So I am assuming you mean ORA-01017.

Are you sure you are using the correct SYS password ? To be certain, log into the database locally and issue the following:


then try to connect remotely again.
Previous Topic: removing a listener
Next Topic: error 1067 [merged]
Goto Forum:

Current Time: Thu May 26 02:11:45 CDT 2022