Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

tnsnames and listener

441110Mar 8 2008 — edited Mar 9 2008
Hi,

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))
)
)
)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 6 2008
Added on Mar 8 2008
4 comments
837 views