TNSListener.exe will not start
This installation was working just fine for days, then after reboot of the machine the listener will no longer start. I just downloaded the XE universal Oracle XE 10.2.0.1 for Windows 32 bit (XPpro), and within a week it stops working.
I get the error when the start-up fails: "TNSLSNR.EXE lsnrctl.exe Entry Point not found the procedure entry point snlinAddrLocalhost could not be found in the dynamic link library oranl10.dll"
The last DDL change I made was to create a new user with all privileges, and I was able to test and log in with that user from command line 'sqlplus', and the user was added from the web page front end without error.
The reason i rebooted the machine was that the AIA installer was having problems determining if the user credentials supplies was a DBA or not, I tried 'SYS' user and also the new user I had just created, but both were failing the validation test. Although the 'sqlplus' was logging in just fine for both.
After reboot, the listener would no longer start.
i dont think it is a listener.ora problem because i did not change anything, however, here are the contents of that file:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\OracleXEu\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\OracleXEu\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
... I tried the fully qualified host name instead of localhost IP, and also tried the loopback adapter IP but both are not working.
Here is my 'hosts' file content, only 2 entries:
10.10.10.10 LA850113.fmr.com LA850113 Sandbox1
127.0.0.1 localhost
Please help, this is urgent.