Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Database start listening TNS-12537, TNS-12560 error     - Linux 10 useful examples of command-line completion (Linux)

- Embedded Linux to solve the problem in the time zone (Linux)

- LVM mirrored logical volume to achieve (Linux)

- CentOS 7 virt-manager can not connect a local hypervisor (Linux)

- Linux print file and send mail (Linux)

- Linux5.8 installed phpMyAdmin was unable to issue related php-mcrypt (Database)

- Graphing tool: Gnuplot (Linux)

- Understand ASP.NET 5 running the command: DNVM, DNX, and DNU (Server)

- Father of Python: Why Python zero-based index (Programming)

- Scope of variables in Object-C (Programming)

- Caffe install under Ubuntu 14.04 64bit (Linux)

- Secondary exponential smoothing prediction method implemented in Python (Programming)

- Java Class file format parsing (Programming)

- MyEclipse configuration necessary (Linux)

- MySQL restart process can not be taken lightly (Database)

- Installation and configuration of Hadoop under Linux (Server)

- After the first remote installation GlassFish Web to remotely access their back office management system error solution appears (Server)

- Oracle 11g forget approach SYS and SYSTEM password (Database)

- Install Gnome Flashback Classic Desktop on Ubuntu 14.10 / Mint 7 (Linux)

- Linux script to copy the folder to all folders with the same name (Linux)

 
         
  Database start listening TNS-12537, TNS-12560 error
     
  Add Date : 2018-11-21      
         
       
         
  Environment Description:

OS: CentOS 6.5

DB: Oracle 11.2.0.3

Problem: Database start listening time, reported the following error:

[Oracle @ localhost admin] $ lsnrctl start

Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date 27-NOV-2015 08:44:40

Uptime 0 days 0 hr. 0 min. 18 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /ora01/app/oracle/product/11.2.0/db_01/network/admin/listener.ora

Listener Log File /ora01/app/oracle/diag/tnslsnr/dbtest001/listener/alert/log.xml

Listening Endpoints Summary ...

  (DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = EXTPROC1521)))

  (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST =) (PORT = 1521)))

TNS-12537: TNS: connection closed

TNS-12560: TNS: protocol adapter error

TNS-00507: Connection closed

Linux Error: 29: Illegal seek

Solution:

1, modify the terms host name, the default installation of the system when the host name localhost, the host name resolution when there will be a lot of strange questions, strongly suggest that you remember to modify the host name;

2, modify the / etc / hosts file

[Root @ localhost tmp] # cat / etc / hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

:: 1 localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.1.100 dbtest001

After the above operation, start listening again

[Oracle @ dbtest001 ~] $ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 27-NOV-2015 09:21:55

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Starting /ora01/app/oracle/product/11.2.0/db_01/bin/tnslsnr: please wait ...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production

System parameter file is /ora01/app/oracle/product/11.2.0/db_01/network/admin/listener.ora

Log messages written to /ora01/app/oracle/diag/tnslsnr/dbtest001/listener/alert/log.xml

Listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = EXTPROC1521)))

Listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 192.168.1.26) (PORT = 1521)))

Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date 27-NOV-2015 09:21:55

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /ora01/app/oracle/product/11.2.0/db_01/network/admin/listener.ora

Listener Log File /ora01/app/oracle/diag/tnslsnr/dbtest001/listener/alert/log.xml

Listening Endpoints Summary ...

  (DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = EXTPROC1521)))

  (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 192.168.1.100) (PORT = 1521)))

The listener supports no services

The command completed successfully

Shows Completed start listening.
     
         
       
         
  More:      
 
- GAMIT 10.50 installed in Ubuntu 12.04 system (Linux)
- Use exp exported EXP-00091 error (Database)
- SecureCRT 7.0 Log Ubuntu 12.04 server via SSH service under Vmware (Server)
- 15 things to do after installing Ubuntu 15.04 Desktop (Linux)
- Ubuntu Linux Change the PATH (Linux)
- C # mobile side and PC-side data exchange (Database)
- Applications Linux leap second problem caused (Linux)
- Linux using TCP-Wrapper Service Management (Linux)
- Heartbeat cluster components Overview (Server)
- tar decompression problems gzip: stdin: not in gzip format (Linux)
- Graphing tool: Gnuplot (Linux)
- MySQL view (Database)
- Linux system last command usage (Linux)
- 24 Docker recommendations (Linux)
- Docker commonly used commands Description (Linux)
- MySQL database master never solve the synchronization method (Database)
- WordPress blog installation Redis Cache (Server)
- MySQL Statistics (Database)
- ASM learning overview (Database)
- Java polymorphic methods inside constructors complete analysis (Programming)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.