tnsnames.ora file
Posted: Mon Aug 14, 2006 6:30 am
Hi,
In one of my job, I am using Oracle Enterprise stage and have set Remote server as "ETL".
I don't have write permission in current tnsnames.ora file under $ORACLE_HOME/network/admin, so I have created a new tnsnames.ora file under my home directory and I am connecting to oracle by setting TNS_ADMIN to the new tnsnames.ora which is there in my home dir.
But datastage is still reading the old tnsnames.ora. How can I make datastage to read Remote server from new file?
Thanks & Regards
Sheshadri.
In one of my job, I am using Oracle Enterprise stage and have set Remote server as "ETL".
I don't have write permission in current tnsnames.ora file under $ORACLE_HOME/network/admin, so I have created a new tnsnames.ora file under my home directory and I am connecting to oracle by setting TNS_ADMIN to the new tnsnames.ora which is there in my home dir.
But datastage is still reading the old tnsnames.ora. How can I make datastage to read Remote server from new file?
Thanks & Regards
Sheshadri.