Hi,
Iam trying to run a job which has an ODBC as the lookup, but getting an error as
[b][DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-12203: unable to connect to destination|.[/b]
Previously our database password was changed and this change has been done in all ODBC related files.Before the change of password this was working fine,now we are having this issue.
So could any one tell me what need to be done regarding this issue.
ODBC connection Dead
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 5
- Joined: Tue Mar 27, 2007 10:56 pm
- Location: Bangalore
Welcome. Here is something a quick Google turned up:
http://ora-12203.ora-code.com/
Have you discussed this with your DBA? First thing to check seems to be to see if the listener is up. Can you connect to this instance from anywhere else? Are you sure you changed the password in your job, not just in 'all ODBC related files'?
http://ora-12203.ora-code.com/
Have you discussed this with your DBA? First thing to check seems to be to see if the listener is up. Can you connect to this instance from anywhere else? Are you sure you changed the password in your job, not just in 'all ODBC related files'?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 5
- Joined: Tue Mar 27, 2007 10:56 pm
- Location: Bangalore
Re: ODBC connection Dead
Thank's for your reply,but i have checked the password in my job as well,its the correct password.
[quote="shwetha.st"]Hi,
Iam trying to run a job which has an ODBC as the lookup, but getting an error as
[[color=red]b][DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-12203: unable to connect to destination|.[/b]
[/color]
Previously our database password was changed and this change has been done in all ODBC related files.Before the change of password this was working fine,now we are having this issue.
So could any one tell me what need to be done regarding this issue.[size=12][/size][/quote]
[quote="shwetha.st"]Hi,
Iam trying to run a job which has an ODBC as the lookup, but getting an error as
[[color=red]b][DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-12203: unable to connect to destination|.[/b]
[/color]
Previously our database password was changed and this change has been done in all ODBC related files.Before the change of password this was working fine,now we are having this issue.
So could any one tell me what need to be done regarding this issue.[size=12][/size][/quote]