Home » RDBMS Server » Networking and Gateways » ORA-609 : opiodr aborting process unknown ospid
icon2.gif  ORA-609 : opiodr aborting process unknown ospid [message #601470] Thu, 21 November 2013 07:03 Go to next message
onkarbanerjee
Messages: 11
Registered: April 2013
Location: Bangalore
Junior Member
I am facing one issue, where i get this error in alert log :

ORA-609 : opiodr aborting process unknown ospid (11781_47743630466656)
Cause:
The ORA-609 error is thrown when a client connection of any kind failed to complete or aborted the connection
process before the server process was completely spawned.
A default value for inbound connect timeout has been set at 60 seconds.

This is also triggered, when a DB session is killed/aborted manually from the OS prompt.

Now what i want to know is which client connection is this?basically whose process is this ospid (11781_47743630466656) that we get in the alert log?
Re: ORA-609 : opiodr aborting process unknown ospid [message #601472 is a reply to message #601470] Thu, 21 November 2013 07:13 Go to previous messageGo to next message
BlackSwan
Messages: 23029
Registered: January 2009
Senior Member
It may have been written into listener.log; then again may be not.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

[Updated on: Thu, 21 November 2013 07:13]

Report message to a moderator

Re: ORA-609 : opiodr aborting process unknown ospid [message #601473 is a reply to message #601472] Thu, 21 November 2013 07:14 Go to previous messageGo to next message
onkarbanerjee
Messages: 11
Registered: April 2013
Location: Bangalore
Junior Member
you mean to say the ospid (11781_47743630466656) belong to which client connection process can be found out in the listener.log?
Re: ORA-609 : opiodr aborting process unknown ospid [message #601475 is a reply to message #601473] Thu, 21 November 2013 07:16 Go to previous messageGo to next message
BlackSwan
Messages: 23029
Registered: January 2009
Senior Member
every connection request that gets to the listener is recorded in the listener.log file.
Re: ORA-609 : opiodr aborting process unknown ospid [message #601488 is a reply to message #601475] Thu, 21 November 2013 07:48 Go to previous messageGo to next message
onkarbanerjee
Messages: 11
Registered: April 2013
Location: Bangalore
Junior Member
is there any other way? as the listner.log file seems not to be written.

LSNRCTL> show log_file
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.25.105)(PORT=1521)))
LISTENER parameter "log_file" set to (null)
The command completed successfully
LSNRCTL>


so, any alternative way for this?
Re: ORA-609 : opiodr aborting process unknown ospid [message #601489 is a reply to message #601488] Thu, 21 November 2013 07:53 Go to previous messageGo to next message
BlackSwan
Messages: 23029
Registered: January 2009
Senior Member
post complete results from OS command below

lsnrctl status
Re: ORA-609 : opiodr aborting process unknown ospid [message #601525 is a reply to message #601489] Thu, 21 November 2013 16:08 Go to previous messageGo to next message
onkarbanerjee
Messages: 11
Registered: April 2013
Location: Bangalore
Junior Member
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.25.105)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.7.0 - Production
Start Date 16-JUL-2012 22:06:46
Uptime 492 days 18 hr. 30 min. 13 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/product/11g/db/network/admin/listener.ora
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.25.105)(PORT=1521)))
Services Summary...
Service "ora11g" has 1 instance(s).
Instance "ora11g", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> quit
Re: ORA-609 : opiodr aborting process unknown ospid [message #601526 is a reply to message #601525] Thu, 21 November 2013 16:22 Go to previous messageGo to next message
BlackSwan
Messages: 23029
Registered: January 2009
Senior Member
learned something new today!

[oracle@localhost ~]$ lsnrctl

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 21-NOV-2013 14:19:45

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

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> show log_status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))
LISTENER parameter "log_status" set to ON
The command completed successfully
LSNRCTL> set log_status off
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))
LISTENER parameter "log_status" set to OFF
The command completed successfully
LSNRCTL> show log_file
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))
LISTENER parameter "log_file" set to /home/oracle/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
The command completed successfully
LSNRCTL> show log_status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))
LISTENER parameter "log_status" set to OFF
The command completed successfully
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date                14-NOV-2013 05:41:48
Uptime                    7 days 8 hr. 39 min. 12 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /home/oracle/app/oracle/product/11.2.0/dbhome_2/network/admin/listener.ora
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=80))(PROTOCOL_STACK=(PRESENTATION=HTTP)(SESSION=RAW)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=21))(PROTOCOL_STACK=(PRESENTATION=FTP)(SESSION=RAW)))
Services Summary...
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 2 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> set log_status on
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))
LISTENER parameter "log_status" set to ON
The command completed successfully
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date                14-NOV-2013 05:41:48
Uptime                    7 days 8 hr. 39 min. 44 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /home/oracle/app/oracle/product/11.2.0/dbhome_2/network/admin/listener.ora
Listener Log File         /home/oracle/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=80))(PROTOCOL_STACK=(PRESENTATION=HTTP)(SESSION=RAW)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=21))(PROTOCOL_STACK=(PRESENTATION=FTP)(SESSION=RAW)))
Services Summary...
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 2 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> 

Re: ORA-609 : opiodr aborting process unknown ospid [message #601529 is a reply to message #601526] Thu, 21 November 2013 18:34 Go to previous message
onkarbanerjee
Messages: 11
Registered: April 2013
Location: Bangalore
Junior Member
That is ok, but its not going to help me --- my problem is that i have already had the OSPID error, not i want to know which client connection was it that had faced the issue.. setting logging on for lisnrctl now, wouldn't help me retrieve that info now.. so i am looking for any alternative way to find that out. Smile

[Updated on: Thu, 21 November 2013 18:35]

Report message to a moderator

Previous Topic: opiino : Attach Failed due to ORA-12560
Next Topic: Tns connection not established
Goto Forum:
  


Current Time: Sat Nov 22 15:35:00 CST 2014

Total time taken to generate the page: 0.07509 seconds