When I loggin into the DB from EM, I got the message
SQLException
IO : The Network Adapter could not establish the connection
And when I enter the following from prompt
Starting tnslsnr: please wait...
Failed to start service, error 3.
TNS-12536: TNS:operation would block
TNS-12560: TNS:protocol adapter error
TNS-00506: Operation would block
32-bit Windows Error: 997: Unknown error
and >> tnsping db_name
Used parameter files:
G:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 127.0.0.1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = nutri)))
TNS-12541: TNS:no listener
I do not know what is the problem.
Actually I previously install the oracle 10g twice and uninstall it.
But I observe from management console that the listener service on my PC would not be removed.
They are OracleOraDb10g_home1TNSListener and OracleOraDb10g_home2TNSListener.
I try to restart they but failed.
How could I fix this fatal problem.
Thanks a lot