DBAs,


I was trying to use enterprise manager console 10g to manage my databases. But I always get the ORA-12541 TNS :no listener error.
The listener is running actually.

Then I used tnsping to see if I can access it. Also get the same error. My listener on sever is running on port 1627. But from the output of tnsping, the system automatically changed the port from 1527 to 1521, Please see the output from the tnsping

tnsping ECQ2

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 27-JUN-2
007 16:48:44

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

Used parameter files:
C:\oracle\product\10.2.0\client\network\admin\sqlnet.ora

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=ECQ2.ges.xxxxx
.com))(ADDRESS=(PROTOCOL=TCP)(HOST=155.64.210.140)(PORT=1521)))
TNS-12541: TNS:no listener

Why did it use hostname adapter to resolve this? Why did it change the port to the default 1521?

The listener.ora on server is as follows:
=============================================================
SID_LIST_ECQ2 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ECQ2.GES.XXXXX.COM)
(ORACLE_HOME = /ECQ2/oh/1020)
(SID_NAME = ECQ2)
)
)

ECQ2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ecq2.ges.xxxxx.com)(PORT = 1527))
)
)
====================================================================

The sqlnet.ora on my client is

=================================================================
SQLNET.AUTHENTICATION_SERVICES = (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
=====================================================================

The tnsnames.ora on my client is

=======================================================


ECQ2_ecq2.ges.xxxxx.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ecq2.ges.xxxxx.com)(PORT = 1527))
)
(CONNECT_DATA =
(SID = ECQ2)
(SERVER = DEDICATED)
)
)
===========================================================

Thanks,

Lily