Forum Discussion

Kris__109062's avatar
Kris__109062
Icon for Nimbostratus rankNimbostratus
Sep 09, 2013

Replace SID to SERVICE_NAME in Oracle connnection string

Hi, I am trying to replace SID with SERVICE_NAME in an Oracle connection string using an irule on an F5 Oracle VS. I have used as a starting point the irule documented here - https://devcentral.f5....
application delivery
devops
iRules
oracle
hooleylist's avatar
hooleylist
Icon for Cirrostratus rankCirrostratus
Sep 09, 2013

Can you try regsub instead of regexp?

 http://www.tcl.tk/man/tcl8.4/TclCmd/regsub.htm
regsub -all {(SID=MYSID)} [TCP::payload] SERVICE_NAME=MYSERVICENAME $new_payload
TCP::payload replace 0 [TCP::payload length] $new_payload

Aaron