Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

not able to starting OracleXNTNSListener in windows environment

Tags:

windows

oracle

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.

like image 326
NPKR Avatar asked Nov 29 '22 16:11

NPKR


2 Answers

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))

like image 194
NPKR Avatar answered Dec 06 '22 18:12

NPKR


I know its a very old thread but, changing 127.0.0.1 to localhost in both listener.ora and tnsnames.ora helped me.

like image 42
Nirmal Mangal Avatar answered Dec 06 '22 19:12

Nirmal Mangal