Hello All,
I am facing a problem TNS-12541: TNS:no listener despite all the things in place. kindly help if i am doing anything wrong. the details of my files and various commands are below.
The sqlnet ,listener and tnsnames details are below:
sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
tnsname.ora:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.1.1 )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
listener.ora:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.1.1)(PORT = 1521))
)
)
ADR_BASE_LISTENER = d:\app\Administrator
When i do a tnsping <service_name> it gives , Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.1.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl))) TNS-12541: TNS:no listener.
when i try to do lsnrctl start it gives me:
Starting tnslsnr: please wait...
Service OracleOraDb11g_home1TNSListener already running.
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
I am able to telnet on 1521. But while trying to connect with Java code i am getting error java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection. Please help me to figure our the problem. I had tried many things. I had deleted the listener and recreated with net assistant still no success.
ashutosh