Home » Server Options » Data Guard » not able to transfer archivelog wrong pass file (Oracle 10.2.0.4.0, Centos 4.5)
not able to transfer archivelog wrong pass file [message #468945] Mon, 02 August 2010 10:26 Go to next message
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
Re: not able to transfer archivelog wrong pass file [message #468952 is a reply to message #468945] Mon, 02 August 2010 10:56 Go to previous messageGo to next message
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.
Re: not able to transfer archivelog wrong pass file [message #468956 is a reply to message #468952] Mon, 02 August 2010 11:29 Go to previous messageGo to next message
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
Re: not able to transfer archivelog wrong pass file [message #468957 is a reply to message #468956] Mon, 02 August 2010 11:31 Go to previous messageGo to next message
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?
Re: not able to transfer archivelog wrong pass file [message #473119 is a reply to message #468945] Thu, 26 August 2010 02:20 Go to previous message
kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida
Member

Hi,
Solved, re-create the pass file.

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


Current Time: Thu Mar 28 14:03:50 CDT 2024