Forgot to mention that I have tried SID option in CONNECT_DATA section, but no luck. How about playing with TWO_TASK or ORACLE_SID or any thing else without having to modify tnsnames.ora file ? Thank you for your responses. On Mon, Apr 7, 2008 at 9:56 AM, Joseph Imbimbo <joei@xxxxxxxxxxxxxx> wrote: > Hi: > > What if you add the following to the CONNECT_DATA part and retest both > environments: > > (SID=$sid) > -- //www.freelists.org/webpage/oracle-l