OraFAQ Forum: Networking and Gateways » ORA-01031: insufficient privileges

Home » RDBMS Server » Networking and Gateways » ORA-01031: insufficient privileges

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01031: insufficient privileges [message #376503]

Wed, 17 December 2008 11:12

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

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #376563 is a reply to message #376503]

Wed, 17 December 2008 20:07

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:

Code: [Select all] [Show/ hide]

ALTER USER SYS IDENTIFIED BY <password>;

then try to connect remotely again.

Report message to a moderator

Previous Topic:	removing a listener
Next Topic:	error 1067 [merged]

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 04 21:14:46 CDT 2025