on 11-02-2009 11:40 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.