TNS could not resolve error!!
Moderators: chulett, rschirm, roy
TNS could not resolve error!!
Hi All,
I transferrred my job from one project to other new project in same server..and this is first time iam running a job in this project..
i was getting following error....
Stored_Procedure_93,0: Error: ORA-12154: TNS:could not resolve the connect identifier specified
Stored_Procedure_93,0: Error occurred in call to ORPHCallActivePluginInitialize().
Server is same for old and new project....job ran succesfully for old project....do we need to configure any thing for new project in same server....
Any suggestions...
I transferrred my job from one project to other new project in same server..and this is first time iam running a job in this project..
i was getting following error....
Stored_Procedure_93,0: Error: ORA-12154: TNS:could not resolve the connect identifier specified
Stored_Procedure_93,0: Error occurred in call to ORPHCallActivePluginInitialize().
Server is same for old and new project....job ran succesfully for old project....do we need to configure any thing for new project in same server....
Any suggestions...
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
Re: TNS could not resolve error!!
Have you set the TNS_ADMIN or ORACLE_HOME variable as it is set in the project you migrated from?
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com
Re: TNS could not resolve error!!
where can i check wheather they are set or not???
thanks...
thanks...
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
![Confused :?](./images/smilies/icon_confused.gif)
Something else is going on, me thinks.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 54
- Joined: Thu Oct 18, 2007 4:20 am
- Location: Chennai
Not the same case for me, but might help
1. In my case I created an entry in the tnsnames.ora using the login I use to login to DataStage and to Unix (for example in the following path apsdev/app/tnsadmin etc)
2. when I used the SQLPLUS option in UNIX and gave username@SID and password, I was able to work with SQL.
3. However I was not able to connect to table from DataStage. I raised a request to my Admin and he said to add a user_defined variable in the administrator as TNS_ADMIN=apsdev/app/tnsadmin
Guess what it is working for me now and I don't know why and give some answer to it.
Even if I change the name of TNS_ADMIN to ACD_AMIN it still works..
Still I don't know why.
Hopefully I will try to bring this issue in a separate Topic later..
Try adding a variable TNS_ADMIN and point to your local tnsnames.ora and let as the result
1. In my case I created an entry in the tnsnames.ora using the login I use to login to DataStage and to Unix (for example in the following path apsdev/app/tnsadmin etc)
2. when I used the SQLPLUS option in UNIX and gave username@SID and password, I was able to work with SQL.
3. However I was not able to connect to table from DataStage. I raised a request to my Admin and he said to add a user_defined variable in the administrator as TNS_ADMIN=apsdev/app/tnsadmin
Guess what it is working for me now and I don't know why and give some answer to it.
Even if I change the name of TNS_ADMIN to ACD_AMIN it still works..
Still I don't know why.
Hopefully I will try to bring this issue in a separate Topic later..
Try adding a variable TNS_ADMIN and point to your local tnsnames.ora and let as the result
Regards
LakshmiNarayanan
LakshmiNarayanan
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
Craig is correct, TNS_ADMIN or ORACLE_HOME could be set at the project level and many do set it there, but not all people. Because you moved to another project and began receiving the error it led me to believe that this is where your problem may exist.
Do you have access to the Administrator Client? If so compare the value for ORACLE_HOME in the roject Vairables in your new and
If you look at the directory where your ORACLE_HOME variable is set, then go to the subdirectory /network/admin/. You should see your tnsnames.ora.
Do you have access to the Administrator Client? If so compare the value for ORACLE_HOME in the roject Vairables in your new and
If you look at the directory where your ORACLE_HOME variable is set, then go to the subdirectory /network/admin/. You should see your tnsnames.ora.
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com
-
- Premium Member
- Posts: 54
- Joined: Thu Oct 18, 2007 4:20 am
- Location: Chennai