Solution
Remove ORACLE_HOME environment variable.
Scenario
I installed 10g Dev Suite on the same XP box where I had 10.2 db previously installed. Now TNSListener service failed to start.
Installation locations:
C:\oracle\product\10.2.0\db_1\bin; C:\DevSuiteHome_1
* hosts:
127.0.0.1 localhost 10.10.10.10 mybox
* sqlnet.ora:
# sqlnet.ora Network Configuration File: C:\DevSuiteHome_1\network\admin\sqlnet.ora # Generated by Oracle configuration tools. SQLNET.AUTHENTICATION_SERVICES= (NONE) NAMES.DIRECTORY_PATH= (TNSNAMES)
* listener.ora:
# listener.ora Network Configuration File: C:\DevSuiteHome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mybox.my.com)(PORT = 1521))
)
)
TRACE_LEVEL_LISTENER = ADMIN* tnsnames.ora:
# tnsnames.ora Network Configuration File: C:\DevSuiteHome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mybox.my.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mybox.my.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)* %PATH%
C:\oracle\product\10.2.0\db_1\bin;C:\DevSuiteHome_1\bin;C:\DevSuiteHome_1\jdk\jre\bin\classic;C:\DevSuiteHome_1\jdk\jre\bin;C:\DevSuiteHome_1\jdk\jre\bin\client;C:\DevSuiteHome_1\jlib;C:\DevSuiteHome_1\jre\1.4.2\bin\client;C:\DevSuiteHome_1\jre\1.4.2\bin;
* Also tried but no help
netsh winsock reset catalog