Page 1 of 1
TNS names
Posted: Mon Sep 04, 2006 5:51 am
by rprasanna28
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?
Posted: Mon Sep 04, 2006 7:15 am
by kcbland
Try using tnsping and your dsn entry name. If that doesn't resolve, use the fully qualified name.
Posted: Tue Oct 03, 2006 10:52 am
by ramcste
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
Posted: Tue Oct 03, 2006 11:06 am
by kcbland
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.
Posted: Tue Oct 03, 2006 12:12 pm
by avi21st
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
Posted: Tue Oct 03, 2006 4:34 pm
by ray.wurlod
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.