facing problem with ORA-12154: TNS:could not resolve service

justicevb · Post by **justicevb** » Mon Feb 02, 2009 10:17 pm

Hi,

Good morning.

am facing the problem with server jobs, when pulling the data into data base table from sequencial file.

here just reading the data and writing it into data base table

iam new to the data stage, i have installed the data stage software 7.5 and able to work with files

am facing the below error.

ORA-12154 : TNS : Could not resolve service name.

Please suggest me on this..

Thanks & regards
vb

ray.wurlod · Post by **ray.wurlod** » Mon Feb 02, 2009 11:26 pm

Probably the Oracle client file tnsnames.ora is not set up correctly or the Oracle environment variables (especially ORACLE_HOME) are not set up correctly so that tnsnames.ora can not even be found.

jhmckeever · Post by **jhmckeever** » Mon Feb 02, 2009 11:53 pm

To verify Ray's suggestion try

Code: Select all

tnsping {SID}

to test if your paths are set up and whether Oracle client can see the specified instance.

anugrah86 · Post by **anugrah86** » Tue Feb 03, 2009 12:17 am

you need to check TNS entries in tnsnames.ora file.

This file can be located in $ORACLE_HOME/network/admin directory.

check if you can tnsping your database server from unix prompt.

>tnsping <database>.<domain>

chulett · Post by **chulett** » Tue Feb 03, 2009 8:15 am

I would think the first question should be - is there an Oracle client installed on the DataStage server?