ORA-16025: parameter LOG_ARCHIVE_DEST_2

Questions relating to Oracle Real Application Clusters (RAC) and Clusterware.

Moderator: Tim...

ORA-16025: parameter LOG_ARCHIVE_DEST_2

Postby vivek_k47 » Thu Oct 17, 2013 7:41 pm

Hi,
i altered the LOG_ARCHIVE_DEST_2 with the following command:

SQL> alter system set LOG_ARCHIVE_DEST_2='service="us03msl_ukhrp050", LGWR ASYNC NOAFFIRM delay=0 optional compression=enable max_failure=0 max_connections=1 reopen=300 db_unique_name="US03MSL_ukhrp050" net_timeout=10, valid_for=(all_logfiles,primary_role)' scope=spfile;
System altered.

Now while tying to start the DB im getting the following error:

[oracle@urhrp050 oracle]$ srvctl start database -d US03MSL
PRCR-1079 : Failed to start resource ora.us03msl.db
CRS-5017: The resource action "ora.us03msl.db start" encountered the following error:
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
. For details refer to "(:CLSN00107:)" in "/local/grid/oragrid/product/11.2.0.3/grid/log/urhrp051/agent/crsd/oraagent_oracle/oraagent_oracle.log".
CRS-2674: Start of 'ora.us03msl.db' on 'urhrp051' failed
CRS-2632: There are no more servers to try to place resource 'ora.us03msl.db' on that would satisfy its placement policy
CRS-5017: The resource action "ora.us03msl.db start" encountered the following error:
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
. For details refer to "(:CLSN00107:)" in "/local/grid/oragrid/product/11.2.0.3/grid/log/urhrp050/agent/crsd/oraagent_oracle/oraagent_oracle.log".
CRS-2674: Start of 'ora.us03msl.db' on 'urhrp050' failed

[UAT][oracle@urhrp050 oracle]$ srvctl start database -d US03MSL -o mount
PRCR-1079 : Failed to start resource ora.us03msl.db
CRS-5017: The resource action "ora.us03msl.db start" encountered the following error:
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
. For details refer to "(:CLSN00107:)" in "/local/grid/oragrid/product/11.2.0.3/grid/log/urhrp051/agent/crsd/oraagent_oracle/oraagent_oracle.log".
CRS-2674: Start of 'ora.us03msl.db' on 'urhrp051' failed
CRS-5017: The resource action "ora.us03msl.db start" encountered the following error:
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
. For details refer to "(:CLSN00107:)" in "/local/grid/oragrid/product/11.2.0.3/grid/log/urhrp050/agent/crsd/oraagent_oracle/oraagent_oracle.log".
CRS-2674: Start of 'ora.us03msl.db' on 'urhrp050' failed
CRS-2632: There are no more servers to try to place resource 'ora.us03msl.db' on that would satisfy its placement policy


Please advise on how to overcome this.Thanks.
vivek_k47
Member
 
Posts: 23
Joined: Sun Aug 05, 2012 11:45 am

Re: ORA-16025: parameter LOG_ARCHIVE_DEST_2

Postby Tim... » Fri Oct 18, 2013 7:31 am

Hi.

1) Go back to your original settings and check everything is OK.
2) Add one new setting in (rather than a whole bunch). Check everything is OK.
3) Goto 2

Basically, add one change at a time until you find the setting that is freaking things out.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17933
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle RAC and Clusterware

Who is online

Users browsing this forum: No registered users and 1 guest

cron