Linux Error:29:illegal Seek

Source: Internet
Author: User
Tags snmp

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

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.