I am using Oracle 10g(10.2.0.1) in RHEL 5 server. i have duplicated my prod database to standby and i want my archive logs to be shipped automatically. i have used the alter system log_archive_dest_2='service=STANDBY optional reopen=20' in my prod database but the archive logs are not shipped automatically. What might be the reason??Its not only with that parameter, you need to check
Allowed Values 10 for Oracle Database 10g authentication protocols 9 for Oracle9i authentication protocols 8 for Oracle8 authentication protocols 7.3 for Oracle 7.3 authentication protocols
ORA-16191: Primary log shipping client not logged on standbyMseberg has provided you with the solution. Copy the Password file of the primary database to the standby server and rename it to the format "orapw<STANDBY-SID>"
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.