ORA-16025: parameter LOG_ARCHIVE_DEST contains repeated or conflicting attributes

alter system set log_archive_dest_2='service="(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db5.test.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=db1.test.com)(SERVER=DEDICATED)))"','LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="db1" net_timeout=15, valid_for=(all_logfiles,primary_role)' scope=both;

ERROR at line 1:

ORA-02097: parameter cannot be modified because specified value is invalid

ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes

Solution:

Remove “net_timeout”

alter system set log_archive_dest_2='service="(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db5.test.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=db1.test.com)(SERVER=DEDICATED)))"','LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="db1", valid_for=(all_logfiles,primary_role)' scope=both;

System altered.

The NET_TIMEOUT attribute is recommended, because it controls the amount of time that the LGWR process waits for status from the network server process before terminating the network connection. If there is no reply within NET_TIMEOUT seconds, then the LGWR process returns an error message (Oracle, 2008) .

 

Beginning with Oracle Database 10g Release 10.2, it is unnecessary to specify the NET_TIMEOUT attribute on the LOG_ARCHIVE_DEST_n destinations configured with both the LG LGWR and ASYNC attributes. This is because the log writer process never waits for the LNSn for any reason in release 10.2. Thus, specifying the NET_TIMEOUT attribute is not required (Oracle, 2008).

References:

Oracle. (2008). Data Guard Concepts and Administration. Retrieved 04 07, 2014, from http://docs.oracle.com/cd/B19306_01/server.102/b14239/log_transport.htm#i1265762

 

Comments