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
toddc76
Messages: 1
Registered: December 2008
Junior Member

Hello all, could a little direction here.

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


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.

-Todd
Re: ORA-01031: insufficient privileges [message #376563 is a reply to message #376503] Wed, 17 December 2008 20:07 Go to previous message
ebrian
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:

ALTER USER SYS IDENTIFIED BY <password>;

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


Current Time: Sat Dec 03 13:43:48 CST 2016

Total time taken to generate the page: 0.04385 seconds