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!

Redo Transport problem with SYNC option

981760Jan 9 2014 — edited Jan 13 2014

Hello Experts,

I have some unique issue with redo transport.

I am actually trying to use Dataguard redo shipment for Oracle Streams.

If I am using ASYNC redo transport ,my environment is working fine, but if I change it to SYNC then I see the error from LGWR.

Basically , LGWR will not write to the standby redo logs and throws me the below error from the LNS log files.

Redo shipping client performing standby login

*** 2014-01-06 10:14:39.091 68920 kcrr.c

Logged on to standby successfully

Client logon and security negotiation successful!

*** 2014-01-06 10:14:39.091 61296 kcrr.c

LNSb: connect status = 0

*** 2014-01-06 10:14:39.111

ksedmp: internal or fatal error

ORA-00600: internal error code, arguments: [kcrrnsfwa.15], [4294967104], [512],

[], [], [], [], []

----- Call Stack Trace -----

calling call entry argument values in hex

location type point (? means dubious value)

-------------------- -------- -------------------- ----------------------------

ksedmp()+728 CALL ksedst() 000000017 ?

FFFFFFFF7FFFCEBC ?

000000000 ?

My understanding is during SYNC , LGWR should write the redo log files using LNS and RFS recieves those messages at Standby site and writes it to the standby log file.

My standby log files are of same size as online redo log files and I also have the same orapwd transferrred.

Even though it makes me believe that issue is with network , when I contacted the nework people they say everything looks good.

Another strange thing, I have the setup working in different server , its only with this server , SYNC does not work, also I tried with different versions of ORacle in the same box and none of them would be successfully able to write to the standby logfiles.

Any suggestions with this issue is highly appreicated.

Thanks,

Krishna

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 10 2014
Added on Jan 9 2014
6 comments
3,060 views