• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Listener not working - oracle 11g

babubudengm

Active Member
Hi All,

We had running( it was working fine) oracle 11g. It was installed on enterprise server. For some reason to delete logs of E1 server while bouncing JDE services i had stopped services of database (OracleServiceORCL,OracleOraDb11g_home1TNSListener) and able to delete E1 Server logs. Started again the DB services But listener not working.
Not able to login into Database
c:\>tnsping orcl showed no listener
ORA-12541: TNS:no listener

and example Security kernal log failed to connect database.
Error:OCI0000374 - Failed to connect to the database instance
OCI0000375 - Error - ORA-12541: TNS:no listener
OCI0000064 - Unable to create database server connection
OCI0000367 - Unable to connect to Oracle ORA-12541: TNS:no listener

Tried below things still Listener not working.

1.Edited sqlnet file
tcp.validnode_checking = yes
tcp.invited_nodes = (localhost, depser,webser)

2. starting Listener from cmd
from location D:\oracle\product\11.2.0\dbhome_1\BIN

3. executed command "services listener" has following output. looks listener output not showing the database service name.

LSNRCTL> services listener
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully

Please suggest if anyone came across this type Listener problem.

Thank you in advance.

Regards,
babu
 

Tom_Davidson

VIP Member
Babu,

I normally tell my users to reboot when this happens.

You could also log into your Oracle instance, and assuming it is up execute an 'alter system register'.

If it isn't up, try 'startup'

Tom
 

babubudengm

Active Member
Babu,

I normally tell my users to reboot when this happens.

You could also log into your Oracle instance, and assuming it is up execute an 'alter system register'.

If it isn't up, try 'startup'

Tom
Hi Tom,
Tired rebooting few times. Same issue persists. :(

Regards,
Babu
 

babubudengm

Active Member
Hi Tom,

Database login itself not working. Giving Network adopter error.
I have to execute alter system register after login to to database right?
correct me if i am wrong.

Regards,
babu
 

Tom_Davidson

VIP Member
Babu,

You are correct. You need to set up your SQLNET.ora to security NTS, set your Oracle SID to E1Local, and make sure you are part of the ora_dba group in windows. Google should be able to help a lot.

Tom
 

babubudengm

Active Member
Babu,

You are correct. You need to set up your SQLNET.ora to security NTS, set your Oracle SID to E1Local, and make sure you are part of the ora_dba group in windows. Google should be able to help a lot.

Tom
Hi Tom,

I had tired most of the option Including SqlNET.ora edition. that i had posted in my 1st Thread. I am looking for some other options to make Listener up.

Regards,
babu
 

BSorrell

Member
Hi Tom,

I had tired most of the option Including SqlNET.ora edition. that i had posted in my 1st Thread. I am looking for some other options to make Listener up.

Regards,
babu
Were you able to find a solution?

We are running into the same issues and here's what I've come up with. We recently upgraded our McAfee software from Virus scanning software to the version with Host Intrusion. This version controls the windows firewall. When I removed the McAfee Host Intrusion software everything worked fine.

After looking through the McAfee logs, I found where all the TCP calls were being blocked by the software, including the listener port (1521).

I'm in the process of working with Oracle to determine if there are other ports that we need to open. Once We have something definitive I will add it to this post, but in a nutshell I would start there.
 

sameiben

Member
i would delete my listener and recreate it. it helped me to fix my issue with listener last time i had similar issue.
 
Top