Home » RDBMS Server » Networking and Gateways » listener issues (10.2.0.3.0)
listener issues [message #592486] Thu, 08 August 2013 18:57 Go to next message
sa_dwhite
Messages: 5
Registered: August 2013
Location: United States
Junior Member
I tried to log on today to one of my databases and get a TNS Timeout error. ran a ps-aef | grep oracle and noticed that the listener was not up. I tried to restart it but got the following error

$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 08-AUG-2013 17:21:57

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

Starting /oracle/product/10.2.0.3/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.3.0 - Production
Log messages written to /oracle/product/10.2.0.3/network/log/listener.log
Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12545: Connect failed because target host or object does not exist
 TNS-12560: TNS:protocol adapter error
  TNS-00515: Connect failed because target host or object does not exist


When I went to my $ORACLE_HOME I noticed that the listener.ora file and sqlnet.ora file were missing.
I recreated the listener.ora file (see below)
LISTENER=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=tcp)(HOST= 192.168.1.66 )(PORT=1521))
      (ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))
SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=
      (GLOBAL_DBNAME=prepqa)
      (ORACLE_HOME=/oracle/product/10.2.0.3)
      (SID_NAME=prepqa))
    (SID_DESC=
      (SID_NAME=plsextproc)
      (ORACLE_HOME=/oracle/product/10.2.0.3)
      (PROGRAM=extproc)))


I was able to start the listner
$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 08-AUG-2013 19:29:49

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.66)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.3.0 - Production
Start Date                08-AUG-2013 19:29:21
Uptime                    0 days 0 hr. 0 min. 27 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File   /oracle/product/10.2.0.3/network/admin/listener.ora
Listener Log File         /oracle/product/10.2.0.3/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.66)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "plsextproc" has 1 instance(s).
  Instance "plsextproc", status UNKNOWN, has 1 handler(s) for this service...
Service "prepqa" has 1 instance(s).
  Instance "prepqa", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


When I try to log into the db I am getting the following error
$ sqlplus sagent@prepqa

SQL*Plus: Release 10.2.0.3.0 - Production on Thu Aug 8 19:30:05 2013

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory



here is my oracle sid
$ echo $ORACLE_SID
PREPQA
$

Any help is appreciated.

[Updated on: Thu, 08 August 2013 18:58]

Report message to a moderator

Re: listener issues [message #592487 is a reply to message #592486] Thu, 08 August 2013 19:05 Go to previous messageGo to next message
BlackSwan
Messages: 22685
Registered: January 2009
Senior Member
Decent first post!

just FYI, on *NIX ORACLE_SID is CaseSensiTive
"PREPQA" is different from "prepqa"; so which is the actual & real SID?

post results from following OS command

ps -ef | grep -i pmon
Re: listener issues [message #592488 is a reply to message #592487] Thu, 08 August 2013 20:03 Go to previous messageGo to next message
sa_dwhite
Messages: 5
Registered: August 2013
Location: United States
Junior Member
Thanks BlackSwan! the database is down now, but when it was up it was set to PREPQA.
when I set it to that, I get the following error when starting the listener.

$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 08-AUG-2013 21:00:20

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

Starting /oracle/product/10.2.0.3/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.3.0 - Production
System parameter file is /oracle/product/10.2.0.3/network/admin/listener.ora
Log messages written to /oracle/product/10.2.0.3/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.66)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
 NL-00303: syntax error in NV string

Listener failed to start. See the error message(s) above...

$

[Updated on: Thu, 08 August 2013 20:03]

Report message to a moderator

Re: listener issues [message #592489 is a reply to message #592488] Thu, 08 August 2013 20:08 Go to previous messageGo to next message
BlackSwan
Messages: 22685
Registered: January 2009
Senior Member
1) listener is NOT required to start or access any local DB.
2) listener.ora file is NOT required to start or utilize Oracle listener. It appears that listener.ora contains syntax errors & should be discarded.
3) trying to connect to a DB that is down, results only in errors like what you posted.

Problem Exists Between Keyboard And Chair

>but when it was up it was set to PREPQA.
please note that the SERVICE NAME that was reported by the listener was "prepqa"; not "PREPQA"
Re: listener issues [message #592490 is a reply to message #592488] Thu, 08 August 2013 20:09 Go to previous messageGo to next message
sa_dwhite
Messages: 5
Registered: August 2013
Location: United States
Junior Member
So now trying to start up the db we have the following issue now.

$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.3.0 - Production on Thu Aug 8 20:20:16 2013

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []


so I checked etc/hosts
$ cat  /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1       localhost.localdomain   localhost
192.168.1.66    Preprocessor
$


then checked hostname
$ hostname
qaprep
$


is that conflict the reason for not being able to start?
Re: listener issues [message #592491 is a reply to message #592490] Thu, 08 August 2013 20:12 Go to previous messageGo to next message
BlackSwan
Messages: 22685
Registered: January 2009
Senior Member
>SQL> startup
>ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []


what additional clues exist within alert_SID.log file?


ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

when was last time Oracle DB started without error?
what changed since then?
Re: listener issues [message #592492 is a reply to message #592491] Thu, 08 August 2013 21:01 Go to previous messageGo to next message
sa_dwhite
Messages: 5
Registered: August 2013
Location: United States
Junior Member
lat time it was started was about 3 weeks ago after a power failure. as far as whats changed, the only thing I can find is that the listener.ora file was missing.

the alert logs are not giving me really any information.
Re: listener issues [message #592495 is a reply to message #592492] Thu, 08 August 2013 21:09 Go to previous messageGo to next message
BlackSwan
Messages: 22685
Registered: January 2009
Senior Member
http://arjudba.blogspot.com/2009/01/ora-00600-arguments-keltnfy-ldminit-46.html

$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
192.168.1.66 qaprep

[Updated on: Thu, 08 August 2013 21:09]

Report message to a moderator

Re: listener issues [message #592496 is a reply to message #592495] Thu, 08 August 2013 21:18 Go to previous message
sa_dwhite
Messages: 5
Registered: August 2013
Location: United States
Junior Member
I found that blog post also that's what lead me to believe this was an issue. from what I can tell that file was changed shortly after we restarted the db after the power failure.

Thanks for all your help I really really appreciate it!!!!, I will need to get my sysadmin to look at this in the morning.
Previous Topic: Error while creating listener using netca
Next Topic: Centralized TNSNAMES.ORA
Goto Forum:
  


Current Time: Wed Aug 20 14:14:40 CDT 2014

Total time taken to generate the page: 0.13850 seconds