sql>!cat/etc/issue
Enterprise Linux Enterprise Linux Server release 5.5 (Carthage)
Kernel \ r on an \m
sql> SELECT * from v$version where rownum<2;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-production
When you open the listener today, the following error is reported:
Tns-12560:tns:protocol Adapter Error
Tns-00507:connection closed
Linux Error:29:illegal Seek
Starting to think of Linux itself as an internal error, check the Hosts file:
[Email protected] ~]$ cat/etc/hosts
# don't remove the following line, or various programs
# that require network functionality would fail.
127.0.0.1 localhost.localdomain localhost
:: 1 localhost6.localdomain6 Localhost6
There's no problem.
Check Listener.ora:
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = Localhost.localdomain) (PORT = 1521))
)
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Global_dbname = jing)
(Oracle_home =/u01/app/oracle/product/11.2.0/dbhome_1)
(Sid_name = orcl3939)
)
(Sid_desc =
(Global_dbname = Tai)
(Oracle_home =/u01/app/oracle/product/11.2.0/dbhome_1)
(Sid_name = orcl3939)
)
)
Sid_list_wen =
(Sid_list =
(Sid_desc =
(Sid_name = Plsextproc)
(Oracle_home =/u01/app/oracle/product/11.2.0/dbhome_1)
(program = Extproc)
)
)
WEN =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = Localhost.localdomain) (PORT = 1522))
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0))
)
)
Check Tnsnames.ora:
DIY =
(DESCRIPTION =
(Address_list =
(Address= (protocol=tcp) (HOST = Localhost.localdomain) (PORT = 1522))
)
)
Sql> Show parameter Local_listener;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
Local_listener string DIY
Sql> Show parameter service_names;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
Service_names string A,b,c,d,diy
Sql> show parameter instance_name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string orcl3939
The above checks are not unusual.
After restarting the OS, you can start the listener:
[Email protected] ~]$ lsnrctl start listener
Lsnrctl for Linux:version 11.2.0.1.0-production on May-August-2015 22:01:27
Copyright (c) 1991, Oracle. All rights reserved.
Start/u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: Please wait ...
Tnslsnr for Linux:version 11.2.0.1.0-production
System parameter file is/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log information written to/u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Write Trace information for/U01/APP/ORACLE/DIAG/TNSLSNR/LOCALHOST/LISTENER/TRACE/ORA_5336_3086415552.TRC
Monitoring: (Description= (Address= (protocol=tcp) (Host=localhost.localdomain) (port=1521)))
Connecting to (Description= (address= (protocol=tcp) (Host=localhost.localdomain) (port=1521))
The STATUS of LISTENER
------------------------
Alias Listener
Version Tnslsnr for Linux:version 11.2.0.1.0-production
Start Date May-August-2015 22:01:27
Uptime 0 days 0 hours 0 minutes 0 seconds
Trace level support
Security On:local OS Authentication
SNMP OFF
Listener parameter File/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener log File/u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listener trace File/u01/app/oracle/diag/tnslsnr/localhost/listener/trace/ora_5336_3086415552.trc
Listener Endpoint Summary ...
(Description= (address= (protocol=tcp) (Host=localhost.localdomain) (port=1521)))
Service Summary:
The service "Jing" consists of 1 instances.
The instance "orcl3939", State UNKNOWN, contains 1 handlers for this service ...
The service "Tai" consists of 1 instances.
The instance "orcl3939", State UNKNOWN, contains 1 handlers for this service ...
Command execution succeeded
[Email protected] ~]$ Lsnrctl start wen
Lsnrctl for Linux:version 11.2.0.1.0-production on May-August-2015 22:01:36
Copyright (c) 1991, Oracle. All rights reserved.
Start/u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: Please wait ...
Tnslsnr for Linux:version 11.2.0.1.0-production
System parameter file is/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log information written to/u01/app/oracle/diag/tnslsnr/localhost/wen/alert/log.xml
Monitoring: (Description= (Address= (protocol=tcp) (Host=localhost.localdomain) (port=1522)))
Monitoring: (Description= (Address= (PROTOCOL=IPC) (KEY=EXTPROC0)))
Connecting to (Description= (address= (protocol=tcp) (Host=localhost.localdomain) (port=1522))
The STATUS of LISTENER
------------------------
Alias Wen
Version Tnslsnr for Linux:version 11.2.0.1.0-production
Start Date May-August-2015 22:01:38
Uptime 0 days 0 hours 0 minutes 0 seconds
Trace level off
Security On:local OS Authentication
SNMP OFF
Listener parameter File/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener log File/u01/app/oracle/diag/tnslsnr/localhost/wen/alert/log.xml
Listener Endpoint Summary ...
(Description= (address= (protocol=tcp) (Host=localhost.localdomain) (port=1522)))
(Description= (address= (PROTOCOL=IPC) (KEY=EXTPROC0)))
Service Summary:
The service "Plsextproc" consists of 1 instances.
The instance "Plsextproc", State UNKNOWN, contains 1 handlers for this service ...
Command execution succeeded
It is unclear whether the OS or Oracle is responsible for the above reasons. Online friends Encounter the same error solution blog.chinaunix.net/uid-20048945-id-471098.html, still do not understand I can use after restarting.
Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.
Linux Error:29:illegal Seek
