Linux Error: 29: Illegal seek

Today I faced some issue regarding listener startup and want to share this info with you folks…
I got an email from users saying they are unable to connect to one of the production server. They are getting “NO LISTENER” message. So, its clear from this that listener could have been shutdown.
I logged in and checked the listener status using both “lsnrctl status” command and “ps -ef | grep tns” command. Both of the commands didn’t given any posivitive result.
So I started the listener with the below command and got error as this…
oracle@YesB.in:/home/oracle [PROD] >lsnrctl

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 23-FEB-2016 12:46:17

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

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> start
Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

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

 The problem is identified as a line is missing in /etc/hosts file (mine is a Linux server). I added below line and problem solved

127.0.0.1         localhost.localdomain       localhost

So, whenever you hit with the above error (Illegal Seek), please check hosts file and add the above line which will solve the issue……

Comments

Post a Comment

Popular posts from this blog

AWR Reports

AWR Reports Introduction Workload Repository Reports AWR Snapshots and Baselines Moving AWR Information Reading the AWR Report Useful Queries Remove and Disable AWR Links with AWR Analyzer Introduction AWR periodically gathers and stores system activity and workload data which is then analyzed by ADDM. Every layer of Oracle is equipped with instrumentation that gathers information on workload which will then be used to make self-managing decisions. AWR is the place where this data is stored. AWR looks periodically at the system performance (by default every 60 minutes) and stores the information found (by default up to 7 days). AWR runs by default and Oracle states that it does not add a noticeable level of overhead. A new background server process (MMON) takes snapshots of the in-memory database statistics (much like STATSPACK) and stores this information in the repository. MMON also provides Oracle10G with a server initiated alert feature, which notifies database admini
Read more

ORA-01565: error in identifying file '?/dbs/spfile@.ora'

QL> startup ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated SQL> create pfile from spfile; create pfile from spfile * ERROR at line 1: ORA-01565: error in identifying file '?/dbs/spfile@.ora' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3   SQL> shut abort SQL> create pfile='/home/oracle/initORA11G.ora' from spfile='+DATA/ORA11G/spfileORA11G.ora'; File created. oracle@rac1.localdomain:/home/oracle [ORA11G1] >dba SQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 6 20:15:29 2016 Copyright (c) 1982, 2011, Oracle.  All rights reserved. Connected to an idle instance. SQL> startup pfile='/home/oracle/initORA11G.ora'; ORACLE instance started. Total System Global Area 1653518336 bytes Fixed Size                  2228904 bytes Variable Size             956304728 bytes Database Buf
Read more

My Fav Song in Telugu: Aa challani samudra garbham

Image
                                                                                                          ఆ చల్లని సముద్ర గర్భం దాచిన బడబానలమెంతో  ఆ నల్లని ఆకాశంలో కానరాని భాస్కరులెందరో  ||ఆ చల్లని|| భూగోళం పుట్టుక కోసం రాలిన సుర గోళాలెన్నో  ఈ మానవ రూపం కోసం జరిగిన పరిణామాలెన్నో ఒక రాజుని గెలిపించుటలో ఒరిగిన నర కంఠములెన్నో కుల మతాల సుడిగుండాలకు బలియైన పవిత్రులెందరో  ||ఆ చల్లని|| మానవ కళ్యాణం కోసం పణమెత్తిన రక్తము ఎంతో  రణరక్కసి కరాళ నృత్యం రాచిన పసి ప్రాణాలెన్నో కడుపు కోతతో అల్లాడిన కన్నులలో విషాదమెంతో  భూస్వాముల  దౌర్జన్యాలకు  ధనవంతుల దుర్మార్గాలకు  దగ్ధమైన బతుకులు ఎన్నో  ||ఆ చల్లని|| అన్నార్తులు అనాథలుండని ఆ నవయుగమదెంత దూరం  కరువంటూ కాటకమంటూ కనిపించని కాలాలెపుడో పసిపాపల నిదుర కనులలో ముసిరిన భవితవ్యం ఎంతో  గాయపడిన కవి గుండెలలో రాయబడని కావ్యాలెన్నో ||ఆ చల్లని || a challani samudra garbham daachina badabaanalamentho  Aa nallani aakasamlo kanarani bhaskarulendharoooo || Aa Challani ||  Bhoogolam puttuka kosam raalina sura golaalenno Eee manava rupam kosam jarigina parin
Read more