Page 1 of 1
Connectivity with oracle10gr2
Posted: Sun May 03, 2009 1:57 am
by DSRajesh
Hi
I am unable to connect with oracle10gr2 version database using plug in oraoci9.
i am getting ora error tns doe not identify the service connected.
regards
rajesh
Re: Connectivity with oracle10gr2
Posted: Sun May 03, 2009 3:34 am
by vrishabhsagar
DSRajesh wrote:Hi
I am unable to connect with oracle10gr2 version database using plug in oraoci9.
i am getting ora error tns doe not identify the service connected.
regards
rajesh
Are you using special characters in your password?
Have you tried to check the NLS between the DS server and the DataBase?
Posted: Sun May 03, 2009 7:22 am
by chulett
Can you connect to
any Oracle instance? Meaning, do you have a problem with just a specific instance or you cannot connect to any instance?
If you can't connect to anything Oracle, you need to verify that the DataStage server has an Oracle client installed on it and is configured properly. Are all of the environment variables set properly? And have you tripled checked all of the obvious reasons for an error like that? Verified you have a
tnsnames.ora file on the DataStage server in the normal place and the name you are using is listed in it? If you have multiple tns files or are unsure it is actually finding it, set the
TNS_ADMIN environment variable to the directory where it can be found and see if that helps.
Posted: Mon May 04, 2009 9:14 pm
by DSRajesh
i am uanble to connect to any instance using datastage but i am able to connect from sqlplus and other etl tool owb
Re: Connectivity with oracle10gr2
Posted: Mon May 04, 2009 9:17 pm
by DSRajesh
HI RISHAB
I AM NOT USING ANY SPECIAL CHARS AND WHERE TO CHECK NLS?
Posted: Mon May 04, 2009 9:45 pm
by chulett
Were you able to connect in the past and cannot now, or is this the first time you are attempting this and you cannot make it work? For the latter, as I noted, you need to ensure you have an Oracle client on the DataStage server and that it has been configured properly for DataStage. Do you? Have you?
Being able to connect from sqlplus or "other etl tool owb"
from your client pc means nothing if that's what you are asserting. Or do you mean you can connect using them from the DataStage server? That would at least imply a client is installed there.
This has nothing to do with special passwords or NLS. Yet.
Posted: Mon May 04, 2009 10:50 pm
by DSRajesh
chullet
i am trying to connect for first after install and its working fine in back end as well with the etl tool owb
Posted: Mon May 04, 2009 11:56 pm
by ray.wurlod
Describe the Oracle-related sections of the DataStage dsenv script. My guess is that you have not completed these properly.
Posted: Tue May 05, 2009 1:26 am
by DSRajesh
i am using windows server and where to use dsenv command
Posted: Tue May 05, 2009 1:36 am
by ray.wurlod
My error.
Describe fully the Oracle-related environment variables that you have set up in your Windows server. Prove (for example via a DataStage log entry) that these are being picked up correctly by DataStage processes.
Posted: Tue May 05, 2009 2:00 am
by DSRajesh
Hi
I am getting the error TNS 12557 Protocal adapter not loadable after setting proper oracle_home .
regards
rajesh
Posted: Tue May 05, 2009 4:40 pm
by ray.wurlod
If you don't answer the questions how do you expect us to help?
Veterinarians charge a lot more than human doctors because they have to diagnose patients who can't answer their questions.
Posted: Fri May 08, 2009 9:09 pm
by DSRajesh
Hi
This is got resolved and i need to use alias for service_name
thanks
rajesh