ORA-12541: TNS:no listener

[Seth.Dickerson]

Just installed fresh environment of InforServer v11.5. Attempting to test an Oracle connector to a known working DB but am getting error:

ORA-12541: TNS:no listener

I have setup env variables:

Code: Select all

ORACLE_HOME=/app/oracle/product/12.1.0/client_1

PATH=
/home/<username>/perl5/bin:
/usr/local/bin:
/usr/bin:
/usr/local/sbin:
/usr/sbin:
/app/oracle/product/12.1.0/client_1/bin:/app/oracle/product/12.1.0/client_1/lib:
/app/IBM/InformationServer/Server/PXEngine/bin:
/app/IBM/InformationServer/Server/DSEngine/bin:

When I do a TNSPING to the data source I get an error:

Used parameter files:
/app/oracle/product/12.1.0/client_1/network/admin/sqlnet.ora
TNS-03505: Failed to resolve name

I suspect this has to do with the oracle installation on the Linux side rather than anything to do with DataStage. Any assistance correcting this issue would be greatly appreciated.

[PaulVL]

shouldn't you be appending to PATH and not replacing it all?

I also recommend appending the Oracle information AFTER the DataStage path settings within your DSENV.

[vishnu.m]

Can you check if an entry of the instance is present in tnsnames.ora ?

[ArndW]

That sounds like a normal Oracle error. From the command line, try 'tnsping' to your instance; if that fails you have ruled out a DataStage problem.

[Teej]

It is indeed critical to define your Oracle path after your DataStage paths, because there are some files that Oracle uses that have the same name as DataStage's critical files.