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.
tnsnames.ora file
Moderators: chulett, rschirm, roy
Where did you change this environment variable? You will need to set it in the dsenv file in the DataStage home directory in order for it to take effect.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
As ArndW suggested , search for "TNS" entry in .dsenv file and set it to the new tnsnames.ora file.
open the .dsenv file in vi and do /TNS
1)But my suggestion is .dsenv file should be belonging to the group dsadm too in addition to oracle. So , request your sys admin to make the change or send the tns entries for him to add it. maintaing too many copies of tnsnames.ora will lead to confusion and ambiguity.
2)Also think of other teams which might be getting effected because of your changing ths "TNS" entry.
Also try this will give a transparent answer of which file it is using in your case.
regards,
Prabu
open the .dsenv file in vi and do /TNS
1)But my suggestion is .dsenv file should be belonging to the group dsadm too in addition to oracle. So , request your sys admin to make the change or send the tns entries for him to add it. maintaing too many copies of tnsnames.ora will lead to confusion and ambiguity.
2)Also think of other teams which might be getting effected because of your changing ths "TNS" entry.
Also try
Code: Select all
which tnsnames.ora
regards,
Prabu
-
- Participant
- Posts: 78
- Joined: Wed Oct 26, 2005 6:12 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not when it's overriden by TNS_ADMIN. It allows you to have one central place to store your tnsnames.ora and associated files, while maintaining multiple ORACLE_HOME values.
Last edited by chulett on Tue Aug 15, 2006 7:02 am, edited 1 time in total.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: