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