Dear all,
10.2.0.2 on linux
We are getting the below error in alert log and synchronization stopped
ORA-00922: missing or invalid option
Tue Oct 11 20:40:41 2011
PRMX: Alter session failed: ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
ORA-16154: suspect attribute: LGWR
ORA-00922: missing or invalid option
Tue Oct 11 20:40:41 2011
Errors in file /u01/PROD/db/tech_st/10.2.0/admin/PROD_dbprod/bdump/prod_j000_23657.trc:
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
ORA-16154: suspect attribute: LGWR
ORA-00922: missing or invalid option
Tue Oct 11 20:40:41 2011
PRMX: Alter session failed: ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
ORA-16154: suspect attribute: LGWR
ORA-00922: missing or invalid option
parameters :
SQL> show parameter log
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_syslog_level string
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
log_archive_config string DG_CONFIG=(PROD,PROD_STDBY)
log_archive_dest string
log_archive_dest_1 string LOCATION=/u01/PROD/db/Archive
MANDATORY
log_archive_dest_10 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string SERVICE=PROD_STDBY LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRI
MARY_ROLE) REOPEN=15 NET_TIMEO
UT=30 DB_UNIQUE_NAME=PROD_STDB
Y
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 2
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
log_buffer integer 15276032
log_checkpoint_interval integer 100000
log_checkpoint_timeout integer 1200
log_checkpoints_to_alert boolean TRUE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_file_name_convert string
logmnr_max_persistent_sessions integer 1
remote_login_passwordfile string EXCLUSIVE
Any idea what am missing ?
Kai