| listener issues [message #592486] |
Thu, 08 August 2013 18:57  |
 |
sa_dwhite
Messages: 15
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 #592488 is a reply to message #592487] |
Thu, 08 August 2013 20:03  |
|
sa_dwhite
Messages: 15
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 #592490 is a reply to message #592488] |
Thu, 08 August 2013 20:09 |
|
sa_dwhite
Messages: 15
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
is that conflict the reason for not being able to start?
|
|
|
|
|
|
|
|
|
|
| Re: listener issues [message #592496 is a reply to message #592495] |
Thu, 08 August 2013 21:18 |
|
sa_dwhite
Messages: 15
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
