I have installed oracleXE in my local meachine.
I have changed the services of Oracle level Automatic to Manual. Know when i start the Oracle Services all are getting started except the OracleXNTNSListener service.
It saying some times below mentioned 1 error or 2 error
1>Windows could not start OracleXETNSListner service on Local Computer.
Error 1067:The process terminated unexpectedly.
OR
2>The OracleXNTNSListener service on Local Computer startred and then stopped.Some services stop automatically if they are not in use by other services or programs.
After some trials the listener got started.
What I did is for this, I have edited the listener.ora file.
In this line intialy HOST = hostname was there, I changed that to localhost ip i.e 127.0.0.1
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
I know its a very old thread but, changing 127.0.0.1
to localhost
in both listener.ora
and tnsnames.ora
helped me.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With