OraFAQ Forum: Data Guard » not able to transfer archivelog wrong pass file

Home » Server Options » Data Guard » not able to transfer archivelog wrong pass file (Oracle 10.2.0.4.0, Centos 4.5)

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

not able to transfer archivelog wrong pass file [message #468945]

Mon, 02 August 2010 10:26

kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida

Member

Hi,
I am creating physical standby database through Rman duplicate command from 2 node rac cluster. rman do all its work. now am try to start the mrp process on physical standby database. I am getting following errors
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
ORA-16191: Primary log shipping client not logged on standby
------------------------------------------------------------
I copied the same pass file from primary to standby and many times verify the same but i got the same error.

Regd
rajnish

Report message to a moderator

Re: not able to transfer archivelog wrong pass file [message #468952 is a reply to message #468945]

Mon, 02 August 2010 10:56

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

16191, 0000, "Primary log shipping client not logged on standby"
// *Cause:  An attempt to ship redo to standby without logging on 
// to standby or with invalid user credentials. 
// *Action: Check that primary and standby are using password files and that 
//          both primary and standby have the same SYS password. 
//          Restart primary and/or standby after ensuring that 
//          password file is accessible and REMOTE_LOGIN_PASSWORDFILE
//          initialization parameter is set to SHARED or EXCLUSIVE.

I believe Oracle better reports reality than you do.

Report message to a moderator

Re: not able to transfer archivelog wrong pass file [message #468956 is a reply to message #468952]

Mon, 02 August 2010 11:29

kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida

Member

Hi,

Primary is my prod database i can't restart the primary i have restated multiple times standby database but prob still same.

i got the error

"Redo shipping client performing standby login
ORA-01017: invalid username/password; logon denied
OCI_DBVER attribute value retrieval failed error=1017"

regds
rajnish

Report message to a moderator

Re: not able to transfer archivelog wrong pass file [message #468957 is a reply to message #468956]

Mon, 02 August 2010 11:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Primary is my prod database i can't restart the primary i have restated multiple times standby database but prob still same.
So what can we do for you now?

Report message to a moderator

Re: not able to transfer archivelog wrong pass file [message #473119 is a reply to message #468945]

Thu, 26 August 2010 02:20

kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida

Member

Hi,
Solved, re-create the pass file.

Reds
rajnish

Report message to a moderator

Previous Topic:	remote_login_passwordfile for dataguard
Next Topic:	TNS-01189: The listener could not authenticate the user

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 08:03:15 CDT 2025