Oracle listening lsnrctl command startup error (TNS-12537, TNS-12560, TNS-00507)

Source: Internet
Author: User

Oracle listening lsnrctl command startup error (TNS-12537, TNS-12560, TNS-00507)

When logging on to an oracle user in LINUX and starting a database using the lsnrctl start command, the following error is returned:

"[Oracle @ localhost ~] $ Lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0-Production on 29-APR-2015
07:38:11

Copyright (c) 1991,200 9, Oracle. All rights reserved.

Starting/home/oracle/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr:
Please wait...

TNS-12537: TNS: connection closed
TNS-12560: TNS: protocol adapter error
Linux Error: 29: Illegal seek

''

Cause:
There are two localhost hostnames in/etc/hosts, and the listener conflicts.

Solution:
1. modify a host name, such as oracle, and run the following command.

Hostname oracle

2. Change the host name to oracle in/etc/hosts.

[Root @ oracle etc] # cat/etc/hosts
127.0.0.1 localhost
: 1 oracle

3. in/etc/sysconfig/network, change the host name to oracle.

[Root @ oracle etc] # cat/etc/sysconfig/network
NETWORKING = yes
HOSTNAME = oracle

4. Restart and execute lsnrctl start under the oracle user.

[oracle@oracle ~]$ lsnrctl startLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 29-APR-2015 07:46:27Copyright (c) 1991, 2009, Oracle.  All rights reserved.Starting /home/oracle/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionSystem parameter file is /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oraLog messages written to /home/oracle/app/diag/tnslsnr/oracle/listener/alert/log.xmlListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))STATUS of the LISTENER------------------------Alias                     LISTENERVersion                   TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionStart Date                29-APR-2015 07:46:29Uptime                    0 days 0 hr. 0 min. 0 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oraListener Log File         /home/oracle/app/diag/tnslsnr/oracle/listener/alert/log.xmlListening Endpoints Summary...  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))The listener supports no servicesThe command completed successfully

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.