Database Software

Hi All,


The only info I have for setup of standby DB is to ensure that the orapwd file is identical on primary and standby db.

My Primary SID is "APM1" , standby sid is "apm1" - so what should be the name of the actual password file on each server - should they match the sid ,

So on primary I would have initAPM1.ora and identical password file (bar the name) on standby called initapm1.ora ??

How do I know what password file oracle uses when the standby tries to connect to Primary - is it the local one or the one on the Primary?


I see these errors during startup of the standby DB, how do I know what user is being used to login to Primary , is it the SYS user or another user that I currently dont have in my password file ?

My password file only contains the SYS user
SQL> select * from V$PWFILE_USERS
2 ;

USERNAME SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS TRUE TRUE FALSE


remote_login_passwordfile is set to EXCLUSIVE on both primary and secondary

Thanks a lot

Here the trace....

vi /opt/app/oracle/diag/rdbms/apm/apm1/trace/apm1_arc1_28645.trc
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
'
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
'

*** 2010-09-08 07:36:36.458
OCISessionBegin failed -1
.. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
'
*** 2010-09-08 07:36:36.458 4132 krsh.c
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
------------------------------------------------------------
*** 2010-09-08 07:36:36.459 4132 krsh.c
FAL[client, ARC1]: Error 16191 connecting to apmp1 for fetching gap sequence
ORA-16191: Primary log shipping client not logged on standby
ORA-16191: Primary log shipping client not logged on standby