Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1070
  • Last Modified:

listner issue in sun solaries


Hi,
On sun solaries . I am tring to start listner and i am getting follwoing error. Please let me know the reasone. it's same message in log file.
LSNRCTL> start
Starting /opt/oracle/product/9.2.0/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 9.2.0.6.0 - Production
System parameter file is /opt/oracle/product/9.2.0/network/admin/listener.ora
Log messages written to /opt/oracle/product/9.2.0/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=storm.epsilon.com)(PORT=1521)))
NL-00051: internal error code, arguments: [302], [1], [], [], [], [], []

Listener failed to start. See the error message(s) above...

===========
log file message

Started with pid=20715
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=storm.epsilon.com)(PORT=1521)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
NL-00051: internal error code, arguments: [302], [1], [], [], [], [], []
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=storm.epsilon.com)(PORT=1521)))

How to check the database on which port it is listning. If someone has created database but not created tnsnames or listner file . then where to find listner port as well as unix machin ip address?

Thanks a lot in advance.
D

0
dcmumbai
Asked:
dcmumbai
  • 3
2 Solutions
 
jwittenmCommented:
Has this worked before?  Can you post your listener.ora file '/opt/oracle/product/9.2.0/network/admin/listener.ora', making sure it has a SID_LIST_LISTENER entry?
0
 
boriskalavskyCommented:
Check sintax in listener.ora
0
 
boriskalavskyCommented:
"lsnrctl status" will show you port information
0
 
boriskalavskyCommented:
to check connections you can use "tnsping <tnsalias>" after you setup alias in tnsnames.ora
0
 
MetanilCommented:
Here is the step by step guide:
1) check whether the listener is aready running
       $lsnrctl status
2) if listener is not already running try issuing:
       $lsnrctl start
3) if step 2 fail try changing your 'storm.epsilon.com' to your ip Address
    you can view machine by issuing
          $ifconfig -a
    you can view port list that your machine is listening to by:
          $netstat -l

I think you have correct entry in your listener.ora file but domain name availble in the file may be unresolvable. Hence try chaning your /etc/hosts to proper IP address. Alternatively, you can directly change to ip address in place of domain name in listener.ora file as explain above.

If above doesn't work , post the entry for listener.ora and tnsnames.ora which available in following directory:
$ORACLE_HOME/network/admin

Hope this may help.
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now