ISSUE WHILE CONNECTING ORACLE
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 46
- Joined: Mon Sep 24, 2007 12:37 am
- Location: INDIA
ISSUE WHILE CONNECTING ORACLE
Hi all,
Whenever i am trying to connect an ORACLE stage in DataStage i am geting this mesasge "Local Server Missing".
I can understand that it is releated to server since am not technically good in these areas i can't resolve it so please guide me how to get rid of this issue.
Thank you
Rajesh
Whenever i am trying to connect an ORACLE stage in DataStage i am geting this mesasge "Local Server Missing".
I can understand that it is releated to server since am not technically good in these areas i can't resolve it so please guide me how to get rid of this issue.
Thank you
Rajesh
-
- Participant
- Posts: 46
- Joined: Mon Sep 24, 2007 12:37 am
- Location: INDIA
-
- Participant
- Posts: 46
- Joined: Mon Sep 24, 2007 12:37 am
- Location: INDIA
-
- Participant
- Posts: 46
- Joined: Mon Sep 24, 2007 12:37 am
- Location: INDIA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You need to find a colleague conversant with Oracle client software. The tnsnames.ora is one of the fundamental Oracle client configuration files. Involve your Oracle DBA.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Connection problem with oracle
Hi Ray,
My Datastage PX 7.5 is in windows OS. Also installed Oracle 8i. Can able to connect oracle using Sql*Plus. But when i tried to connect using OracleEnterprise stage i am getting the below error.
##E TOSH 000205 18:17:10(004) <main_program> PATH search failure:
##E TOSH 000000 18:17:10(005) <main_program> Error loading "orchoracle": Could not load "orchoracle": The specified module could not be found.
##E TOSH 000000 18:17:10(006) <main_program> Could not locate operator definition, wrapper, or Unix command for "oraread"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
##E TCOS 000029 18:17:10(007) <main_program> Creation of step finished with status = FAILED
By seeing this error i can understand some thing related to path.
Can any one help me what else i need to do to connect oracle.
Thanks in advance.
Raja
My Datastage PX 7.5 is in windows OS. Also installed Oracle 8i. Can able to connect oracle using Sql*Plus. But when i tried to connect using OracleEnterprise stage i am getting the below error.
##E TOSH 000205 18:17:10(004) <main_program> PATH search failure:
##E TOSH 000000 18:17:10(005) <main_program> Error loading "orchoracle": Could not load "orchoracle": The specified module could not be found.
##E TOSH 000000 18:17:10(006) <main_program> Could not locate operator definition, wrapper, or Unix command for "oraread"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
##E TCOS 000029 18:17:10(007) <main_program> Creation of step finished with status = FAILED
By seeing this error i can understand some thing related to path.
Can any one help me what else i need to do to connect oracle.
Thanks in advance.
Raja
thanks & regards,
Raja
Raja
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Any time you see "unable to load" anything, suspect your shared library search list (an environment variable called LD_LIBRARY_PATH, LIBPATH or SHLIB_PATH, depending on which operating system you're using).
You may also need to check your command search list (the PATH environment variable), since this was recommended in the error messages, and/or your CLASSPATH environment variable if using any Java-based components.
You may also need to check your command search list (the PATH environment variable), since this was recommended in the error messages, and/or your CLASSPATH environment variable if using any Java-based components.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.