Password file not generating on Primary server

[Former Member]

Hello Experts,

I am in the process of setting up Oracle Data Guard on Primary and STandby server. All parameters for ODG are configured. I am able to do tnsping . But logs are not shipping from Primary to Standby . This is related to Password file. I have setup password file at Primary and Standby site.Then restarted database. Primary server was Oracle 9i upgraded to 10.2.0.2 While Standby server is new install at Ora 10.2.0.2. But I get error in password authentication. Have tried putting password in "orapwd" in CAPITAL/SMALL But I get below error

**************************************************************************************

Mon Nov 02 16:52:56 2009

Error 1017 received logging on to the standby

-

---

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

-

---

Mon Nov 02 16:52:56 2009

Errors in file g:\oracle\pap\saptrace\background\pap_arc1_34608.trc:

ORA-16191: Primary log shipping client not logged on standby

PING[ARC1]: Heartbeat failed to connect to standby 'PAP_DR'. Error is 16191.

Mon Nov 02 16:53:57 2009

Errors in file g:\oracle\pap\saptrace\background\pap_arc1_34608.trc:

ORA-01017: invalid username/password; logon denied

Mon Nov 02 16:53:57 2009

Error 1017 received logging on to the standby

-

---

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

-

---

Mon Nov 02 16:53:57 2009

Errors in file g:\oracle\pap\saptrace\background\pap_arc1_34608.trc:

ORA-16191: Primary log shipping client not logged on standby

PING[ARC1]: Heartbeat failed to connect to standby 'PAP_DR'. Error is 16191.

*******************************************************************************************************

Appreciate any help available ..

regards,

Pravash Raikar

[stefan_koehler]

Hello Pravash,

> Appreciate any help available ..

Is the password of the SYS user the same on both database (primary / standby)?

What are the names of your SIDs/DBs and how are the password files named?

What is the value of your init paramter remote_login_passwordfile?

Regards

Stefan

[Former Member]

Hello Stefan,

Thanks for your quick response.

Is the password of the SYS user the same on both database (primary / standby)?

Reply : Yes

What are the names of your SIDs/DBs and how are the password files named?

Reply : SID is PAP . Naming is orapwPAP . "orapwd file=orapwPAP password=******** "

I tried putting password CAPITAL only,SMALL letters only .But with same result.

Parameter "SEC_CASE_SENSITIVE_LOGON=FALSE" not supported on 10.2.0.2

orapwd WITH option "IGNORECASE" not supported on 10.2.0.2.

What is the value of your init paramter remote_login_passwordfile?

Reply : Exclusive

When I run select * from v$pfile_users it shows entry .But on Primary server it shows Empty.

My guess is somehow its not registering password file on Primary server even though I have generated it and restarted database.

regards,

Pravash Raikar

[stefan_koehler]

Hello Pravash,

> Reply : SID is PAP . Naming is orapwPAP . "orapwd file=orapwPAP password=******** "

The database is running with the same ORACLE_SID on different servers? What is the db_unique_name?

Please post the content of both $ORACLE_HOME/dbs folders

shell> su - ora<SID>
shell> ls -la $ORACLE_HOME/dbs

> When I run select * from v$pfile_users it shows entry .But on Primary server it shows Empty.

Indeed .. this is a strange behaviour.

Regards

Stefan