Will not connect using HostName. Connects using IP Address

[jangjangjang]

Hi,
I currently installed the new version 9.06 and somehow when i connect, it will connect only if i put the ping'd IP address on the TNSNAMES HOST NAME but it wont recognize the HOST NAME

ex: My old Tnsnames has this and it wont connect
HOST = erpqa00.sc.esilicon.com

But if i change it to below then it connects. Any ideas?
HOST = 10.1.1.1

 

[Marco Kalter]

Does tnsping work correctly for this database?

 

[jangjangjang]

Hi,
Yes. When i tnsping the hostname of "erpqa00.sc.esilicon.com" it gives me the ip address.

 

[jangjangjang]

if the TnSNAMES looks like this it works
ERPTST.SC.CO.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.9.44)(PORT = XXXXX))
)
(CONNECT_DATA =
(SERVICE_NAME = ERPTST)
)
)

but if this way, it wont work
ERPTST.SC.CO.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ERPTSTDB.SC.CO.COM)(PORT = XXXXX))
)
(CONNECT_DATA =
(SERVICE_NAME = ERPTST)
)
)

and normally i dont care as long as it works but i found there are data inconsistencies that i noticed when doing this. I have a server where i still have the old version and uses the hostname instead of the IP address. Here i get all the data i need. In my new machine, sometimes i go to Oracle Applications and update a record but i dont immediately see this in my new machines point to the IP Address.

 

[Marco Kalter]

Hi,
Yes. When i tnsping the hostname of "erpqa00.sc.esilicon.com" it gives me the ip address.

Are you using ping or Oracle's TNSping?

You will need to use tnsping to check if it can be resolved. For example:

TNSPING ERPTST.SC.CO.COM

(database name copied from your most recent post)

 

[jangjangjang]

i am using PING. TNSPING is not recognized.

 

[Marco Kalter]

I think it is best to contact your database administrator or system administrator to get this resolved.