TNS names

rprasanna28 · Post by **rprasanna28** » Mon Sep 04, 2006 5:51 am

I have installed Oracle in my system as well as datastage. Oracle is working properly with Datasource name "Ora", username "scott". But when I use OCI stage in Datastage and when I try to connec to database with same DSN ........Iam getting an error message " TNS name couldn't be resolved". Can anyone tell me where the problem is ? whether is it in Oracle installation or Datastage installation?

kcbland · Post by **kcbland** » Mon Sep 04, 2006 7:15 am

Try using tnsping and your dsn entry name. If that doesn't resolve, use the fully qualified name.

ramcste · Post by **ramcste** » Tue Oct 03, 2006 10:52 am

Hi all, I have same problem with "TNS couldn't resolve service name".
Kenneth, I also executed tnsping command with dnsname. Still couldn't
resolve it.
Can you please help us. thanks a lot. - RAM

kcbland · Post by **kcbland** » Tue Oct 03, 2006 11:06 am

Look at your tnsnames.ora file, use the short name of the SID or the longer name, sometimes it looks like "xxxxx.world" or "xxxxx.abc.net". Look at the service_name value and try that.

avi21st · Post by **avi21st** » Tue Oct 03, 2006 12:12 pm

kcbland wrote:Look at your tnsnames.ora file, use the short name of the SID or the longer name, sometimes it looks like "xxxxx.world" or "xxxxx.abc.net". Look at the service_name value and try that.

Hi

TNSNAMES.ORA is the network configuration file- you need to have it defined at your client to access a Oracle database. It is usually present in your Oracle path -C:\Oracle\product\10.1.0\Client_3

Then in \network\admin folder

The standard format of a TNSNAMES.ORA file is given where you have the details of your development (here WSI1D) or your test (WSIS) or the production environment details

Code: Select all

WSI1D.WORLD = 
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.246.155.55)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = wsi1d) 
      (SRVR = DEDICATED)
    )
  )

WSI1S.WORLD = 
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.7.240.129)(PORT = 1524))
    )
    (CONNECT_DATA =
      (SID = wsi1s) 
      (SRVR = DEDICATED)
    )
  )

Let me know if you have any issues

ray.wurlod · Post by **ray.wurlod** » Tue Oct 03, 2006 4:34 pm

Since the DataStage job is the Oracle client application, the tnsnames.ora file must be correctly configured on the DataStage server machine. Also, the dsenv file on the DataStage server machine must have the Oracle environment variables correctly set.