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
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 27-JUN-2
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=ECQ2.ges.xxxxx
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:
(GLOBAL_DBNAME = ECQ2.GES.XXXXX.COM)
(ORACLE_HOME = /ECQ2/oh/1020)
(SID_NAME = ECQ2)