tnsnames and listener
441110Mar 8 2008 — edited Mar 9 2008Hi,
I have a tnsnames.ora and listener.ora on separate machines. I'm completely baffled as to why I can't connect. The listener is started, the database is running and I can connect Enterprise Manager from the local machine using the same tnsnames.ora file with HOST=localhost. But when I try connecting Enterprise Manager from a remote machine using the tnsnames.ora below, I get the ubiquitous:
ORA-12541 TNS: no listener
The firewalls are turned off and I can ping the machine. I've looked all over the net, with no avail. Is there something simple that I'm missing?
PLUTO_SERVER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1521))
)
(CONNECT_DATA =
(SID = pluto)
(SERVER = DEDICATED)
)
)
LISTENER =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
#BEQUEATH CONFIG
(GLOBAL_DBNAME=pluto.domain1)
(SID_NAME=pluto)
(ORACLE_HOME=/opt/oracle/product/10.2/db_1)
#PRESPAWN CONFIG
(PRESPAWN_MAX=20)
(PRESPAWN_LIST=
(PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
)
)
)