Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-16198: LGWR received timedout error from KSR , 10.2.0.4.0 Database.

DarkwingDuckFeb 8 2016 — edited Feb 8 2016

Hello


I'm running into an ORA-16198 on an DG System running under 10.2.0.4.

I found Doc ID 808469.1- Redo Transport Services fails with ORA-16198 when using SYNC (synchronous) mode (Doc ID 808469.1)


https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=191201854938436&id=808469.1&_afrWindowMode=0&_adf.ctrl-state=kvm88v58r_4


If I issue

ALTER SYSTEM SET LOG_ARCHIVE_DEST_2 = 'service=xx_DATAGUARD LGWR SYNC DB_UNIQUE_NAME=xxx NET_TIMEOUT=30 VALID_FOR =(ONLINE_LOGFILES,PRIMARY_ROLE)'

I run into this error:

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

In systems running in async mode TIME_OUT is no longer needed since release 10.2, as far as I got it.

However, we are in sync here. Sadly, there is no DGMGRL.

Any Ideas?

Thx

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 7 2016
Added on Feb 8 2016
5 comments
1,219 views