no listener error when trying to connect to oracle 10g on linux from windows client
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.
Last edited by kheldar; 07-24-2004 at 01:14 PM.
|