Connectivity with oracle10gr2

DSRajesh · Post by **DSRajesh** » Sun May 03, 2009 1:57 am

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

vrishabhsagar · Post by **vrishabhsagar** » Sun May 03, 2009 3:34 am

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?

chulett · Post by **chulett** » Sun May 03, 2009 7:22 am

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.

DSRajesh · Post by **DSRajesh** » Mon May 04, 2009 9:14 pm

i am uanble to connect to any instance using datastage but i am able to connect from sqlplus and other etl tool owb

DSRajesh · Post by **DSRajesh** » Mon May 04, 2009 9:17 pm

HI RISHAB

I AM NOT USING ANY SPECIAL CHARS AND WHERE TO CHECK NLS?

chulett · Post by **chulett** » Mon May 04, 2009 9:45 pm

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.

DSRajesh · Post by **DSRajesh** » Mon May 04, 2009 10:50 pm

chullet

i am trying to connect for first after install and its working fine in back end as well with the etl tool owb

ray.wurlod · Post by **ray.wurlod** » Mon May 04, 2009 11:56 pm

Describe the Oracle-related sections of the DataStage dsenv script. My guess is that you have not completed these properly.

DSRajesh · Post by **DSRajesh** » Tue May 05, 2009 1:26 am

i am using windows server and where to use dsenv command

ray.wurlod · Post by **ray.wurlod** » Tue May 05, 2009 1:36 am

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.

DSRajesh · Post by **DSRajesh** » Tue May 05, 2009 2:00 am

Hi

I am getting the error TNS 12557 Protocal adapter not loadable after setting proper oracle_home .

regards
rajesh

ray.wurlod · Post by **ray.wurlod** » Tue May 05, 2009 4:40 pm

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.

DSRajesh · Post by **DSRajesh** » Fri May 08, 2009 9:09 pm

Hi

This is got resolved and i need to use alias for service_name

thanks
rajesh

DSXchange

Connectivity with oracle10gr2

Connectivity with oracle10gr2

Re: Connectivity with oracle10gr2

Re: Connectivity with oracle10gr2