Hi,

I've just installed an oracle 10g database on linux for the first time. The database is working fine, but I can't connect to it from a windows PC on the same lan.

Running tnsping on the server I get...
TNS Ping Utility for Linux: Version 10.1.0.2.0 - Production on 24-JUL-2004 18:02:56

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
/u01/app/oracle/product/10.1.0/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = monolith)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = monolith)))OK (0 msec)

whereas on the windows client I get ...

TNS Ping Utility for 32-bit Windows: Version 9.0.1.4.1 - Production on 24-JUL-2004 18:04:45

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
C:\DevSuiteHome\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = monolith)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = monolith)))TNS-12541: TNS:no listener


The server does have a firewall enabled, but the lan card is set to trusted, and it still does this even if I disable the firewall.

To ensure that the same parameters were used, I have copied the tnsnames.ora and sqlnet.ora from the server to the relevant directory on the client, but that didn't help either.

Could anyone suggest anything I should try to get this sorted?

Thanks.

I've figured it out - the hostname was defined in the /etc/hosts file as 127.0.0.1. Having put it's real IP address in the hosts file, the listener works fine.