Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: SIGHUP killing Oracle Listener Process
Operating Systems AIX SIGHUP killing Oracle Listener Process Post 302596731 by jimthompson on Wednesday 8th of February 2012 07:01:41 AM
Old 02-08-2012
SIGHUP killing Oracle Listener Process
I have a cold backup script which backs up my database and then restarts the oracle listener and database at around 01:30
I can see at this time that my database and listener are indeed running. However at around 02:17 my listener process receives a SIGHUP 1 signal from the AIX OS ( version 5.3 ) that kills the listener process ( the background instance processes of the database remain uneffected, it is only the listener process that gets killed ). To compensate for this, I restart the listener via cron at 04:30. It starts fine and remains up

I have a truss log of the database listener process when it gets killed and it shows the following at the end of the log file

getsockopt(33, 65535, 4104, 0x00000001105985F4, 0x00000001105985F0) = 0
connext(33, 0x00000001105F85E8, 16) Err#79 ECONNREFUSED
shutdown(33, 2) Err#76 ENOTCONN
close(33) = 0
_nsleep(0x00000001105985E0, 0x00000001105986B0) Err#4 EINTR
Received signal #1, SIGHUP [default]
*** process killed ***

I have looked at the AIX errors being reported -

Error 79 in AIX is - connection refused
Error 76 in AIX is - socket is not connected
Error 4 in AIX is - interrupted system call

The unsual thing is that the script I use at the end of the backup to start the listener, is the exact same script I use in the 04:30 cron to restart it. Also the backup script has not changed in months, yet this problem has only started recently.

I am not sure why leaving the listener up means it does not get effected yet if I start it at the end of the cold backup, it can only seem to survive for about 45 mins before it gets killed. The AIX errors appear to be socket related but I am not sure why then that only effects the listener process if it is newly started rather than if it has been up all day

any ideas of finding out what is killing my Oracle Listener process and why only under quite specific circumatances ( i.e. only when started in the early hours of the morning )

Jim
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

killing parallel oracle process

Hi guys: I have a an oracle job which uses 10 parallel hints and would like to killit when it hangs. I want to kill all the processes that have been spawned. what I do right now is get the pid of the scheduler process which initiated theis job and the do a ps -ef| grep 'pid' and trace through... (1 Reply)
Discussion started by: oracle8
1 Replies

2. UNIX for Advanced & Expert Users

how to make a current running process ignore SIGHUP signal?

I ask this question since sometimes i run a time-consuming ftp in foreground and forget to use nohup ftp.sh & to put this work background and can still running after i log off. Assume this ftp task have run 1 hour, and still 1 hour time to end, i don't want to abort the ftp, first, i use ctrl+Z... (3 Replies)
Discussion started by: stevensxiao
3 Replies

3. Shell Programming and Scripting

Killing of a process and send a mail if the process doesnot come up within 2 minutes

Hi Friends, I am new to this forum as well as new to shell scripting. I have a problem here and i need someone to solve this. Let us consider there are two processes(abc & def).There is a script which kills these two processes(i.e killtheprocess abc). Here abc is the argument . There is a... (1 Reply)
Discussion started by: Prince89
1 Replies

4. UNIX and Linux Applications

Oracle - How to manage listener log files

Dear expert, I'm newbie in oracle, I have a problem regarding the listener log files under alert directory and trace directory(please refer to below). As the oracle hard disk size only 10GB, I have to manually delete the log files under alert directory and trace directory. Is that anyway for... (1 Reply)
Discussion started by: yhcheong
1 Replies

5. Shell Programming and Scripting

Finding the age of a unix process, killing old processes, killing zombie processes

I had issues with processes locking up. This script checks for processes and kills them if they are older than a certain time. Its uses some functions you'll need to define or remove, like slog() which I use for logging, and is_running() which checks if this script is already running so you can... (0 Replies)
Discussion started by: sukerman
0 Replies

6. Solaris

Killing a thread having a listener socket

Hi All I have a separate thread ListenerThread having a socket listening to info broadcasted by some remote server. This is created in my main thread. Because of requirements, once the separate thread is started I need to avoid any blocking function on the main thread. Once it comes to the... (2 Replies)
Discussion started by: manustone
2 Replies

7. Infrastructure Monitoring

Test if Oracle listener is running

Hi All , I am new to shall scripting, i want write an script for oracle tns and listener. If tns working i want o/p as "Listener and TNS are working" else o/p should be ""Listener and TNS are not Working" below is the command in unix to check the tns status, if no output it means TNS... (3 Replies)
Discussion started by: abdul bari
3 Replies

8. Shell Programming and Scripting

Killing oracle sessions

Hi, I need to write a shell script to kill all oracle sessions. I have to login in unix with unix userid and have to use sudo command to login with oracle userid and has to find out all oracle related sessions that are running currently and has to kill all sessions. please suggest me the way... (1 Reply)
Discussion started by: rohan10k
1 Replies

9. Red Hat

Oracle Listener Error on Red hat 5

Hello everybody, the reason why im posting this thread is because i've installed an oracle test database on RHEL 5, on a localhost (Since it is for test)... the thing is, after i have installed the DB it works just fine, but after i re start it, i get the following errors when i want to go into the... (5 Replies)
Discussion started by: blacksteel1988
5 Replies

10. AIX

Oracle Listener gets killed when root session is closed

Hi everyone, This is a strange thing, sometimes when I type > exit from root session, i get a message > There are processes running after this message is displayed the oracle listener dies out and have to startup the listener again. but this doesn't have always. Where should I start to... (5 Replies)
Discussion started by: filosophizer
5 Replies

LEARN ABOUT SUNOS

delete-iiop-listener

asadmin-delete-iiop-listener(1AS)				   User Commands				 asadmin-delete-iiop-listener(1AS)

NAME

       asadmin-delete-iiop-listener, delete-iiop-listener - removes the IIOP listener

SYNOPSIS

       delete-iiop-listener --user admin_user [--password admin_password] [--host localhost] [--port 4848] [--secure|-s] [--passwordfile filename]
       [--terse=false ] [--echo=false ] [--interactive=true ] listener_ID

       Removes the IIOP listener. This command is supported in remote mode only.

OPTIONS

       --user		       authorized domain application server administrative username.

       --password	       password to administer the domain application server.

       --host		       machine name where the domain application server is running.

       --port		       port number of the domain application server listening for administration requests.

       --secure 	       if true, uses SSL/TLS to communicate with the domain application server.

       --passwordfile	       file containing the domain application server password.

       --terse		       indicates that any output data must be very concise, typically avoiding human-friendly sentences and favoring well-
			       formatted data for consumption by a script. Default is false.

       --echo		       setting to true will echo the command line statement on the standard output. Default is false.

       --interactive	       if set to true (default), only the required password options are prompted.

OPERANDS

       listener_id	       unique identifier for the IIOP listener to be deleted.

       Example 1: Using delete-iiop-listener

       asadmin> delete-iiop-listener --user admin --password adminadmin
       --host fuyako --port 7070 sample_iiop_listener
       Command delete-iiop-listener executed successfully

       Where: sample_iiop_listener is the IIOP listener deleted.

EXIT STATUS

       0		       command executed successfully

       1		       error in executing the command

       asadmin-create-iiop-listener(1AS), asadmin-list-iiop-listeners(1AS)

J2EE 1.4 SDK							    March 2004					 asadmin-delete-iiop-listener(1AS)
All times are GMT -4. The time now is 03:30 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy