Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
vasubabu
Participant
Posts: 153 Joined: Wed Jan 25, 2006 2:38 am
Post
by vasubabu » Wed Oct 20, 2010 12:58 am
Hi ,
I am getting the fallowing error when tryin to view the date from OCI enterprise stage.
"ORA-12514: TNS:listener does not currently know of service requested".
But i am able to connect with ODBC stage ,can import the meta data from Plug-in as well.
When using the OCI stage only i am getting the above error.
Can anybody help on this to resolve.
VASU..
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Oct 20, 2010 7:51 am
Have you used any of the native Oracle stages yet? They are configured in a different manner than ODBC. Do you have an Oracle client installed on your DataStage server?
-craig
"You can never have too many knives" -- Logan Nine Fingers
vasubabu
Participant
Posts: 153 Joined: Wed Jan 25, 2006 2:38 am
Post
by vasubabu » Wed Oct 20, 2010 9:47 pm
Yes.I have the Oracle client installed on Datastage server.I am having the problem with OCI stage alone.
Please advice me to set any properties.
VASU..
cfuller
Premium Member
Posts: 70 Joined: Mon Mar 24, 2003 10:08 pm
Location: Australia
Post
by cfuller » Wed Oct 20, 2010 10:16 pm
Have you checked you have the tnsnames.ora file configured correctly on the Datastage server. Are you able to tnsping your database from the Datastage server?
Regards
Chris Fuller
"Reality is what refuses to go away when you stop believing in it"
vasubabu
Participant
Posts: 153 Joined: Wed Jan 25, 2006 2:38 am
Post
by vasubabu » Thu Oct 21, 2010 12:04 am
Hi,
I am able to ping tnsping and working fine.
do i need to set the Datastage environment variables?
VASU..
evee1
Premium Member
Posts: 96 Joined: Tue Oct 06, 2009 4:17 pm
Location: Melbourne, AU
Post
by evee1 » Wed May 18, 2011 5:43 pm
Hello, have you managed to solve this issue?
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed May 18, 2011 7:34 pm
evee1, why don't you start your own post and tell us the details of your particular issue?
-craig
"You can never have too many knives" -- Logan Nine Fingers
evee1
Premium Member
Posts: 96 Joined: Tue Oct 06, 2009 4:17 pm
Location: Melbourne, AU
Post
by evee1 » Wed May 18, 2011 8:11 pm
I think I will. I just didn't want to double up posts.
I managed to fix THIS problem, but I'm having another one
. So see you in the other post.