Do you want to terminate the oracle instance or an oracle user session? If it's the latter, then I would avoid killing an OS process if you can.
As a DBA capable account, have a look at the 'table' v$session. It lists various columns. If you can identify the one to clear out, you need to execute:-
Code:
alter system kill session ('sid,serial#') ;
Insert the appropriate values for sid and serial# from the v$session table. if that doesn't do the trick, then you may need to look at the start time to confirm the OS process id and terminate that will a kill -9
If you really want to terminate an oracle instance then (depending on version) you would be better to connect with either
svrmgrl then connect internal or
sqlplus then / as sysdba when prompted for the user-name.
In each case, you can issue the shutdown command. This allows for options such as immediate (signal all processes to stop & roll-back) and abort (crash instance, roll-back will be at next startup)
I hope that this helps,
Robin
Liverpool/Blackburn
UK
Hi All,
I am unable to kill a process using kill command. I am using HP-UX system. I have tried with kill -9 and i have root privilages.
How can i terminate this daemon ? ? ?
Regards,
Vijay Hegde (3 Replies)
I want to Kill a process without using kill command as i don't have privileges to kill the process. I know the pid and i am using Linux 2.6.9 OS. (6 Replies)
Hey
I'm writing a script that creates some processes,and some scripts which kill those processes.
the question is Simply:
How can I allow a group members to be able to kill (using kill command) processes created by other user at the same group?
and i need the change to be at the script... (5 Replies)
I am looking for a way to kill 2 processes from a user through some kind of script.
Using an oracle script, I get two process ids that need to be killed.
SQL> select ssn.process as client_process_id, pcs.spid as oracle_process_id, ssn.sid, ssn.serial#
2 from v$session ssn inner join... (5 Replies)
Hi Here is my problem:
1)I am login to unix server through my login id and do SU - xxx
2) Start the script which is running in background
I want that other user which login to there id and do SU - yyy(Different user) kill that
script.
Could you please help me in this. (9 Replies)
How can I kill a process owned by user1? I will be using another user (user2) (not root) and we are on the same primary and secondary group. I copied everything including it's .profile and set the path accordingly.
user1@hostnmae0:/home/user1 $ pkill java
pkill: Failed to signal pid 1234:... (2 Replies)
Hi,
When process listing, I came across a process running as user daemon.
daemon 23576 23574 0 07:32:04 ? 0:07 oracle (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
root 27526 27444 1 07:38:43 ttyp5 0:00 grep 23574
why a process runs as user daemon, when it should be... (3 Replies)
Good afternoon
I need to KILL a process in a single command sentence, for example:
kill -9 `ps -aef | grep 'CAL255.4ge' | grep -v grep | awk '{print $2}'`
That sentence Kills the process ID corresponding to the program CAL255.4ge.
However it is possible that the same program... (6 Replies)
the task is grant user1 to kill another (for example user2) process. My steps:
by root:
usermod -P "Process Management" user1
login user1
user1@server (~) pfexec kill <PID>
the result is:
ksh: <PID>: not found
or user1@server (~) pfexec pkill <PID>
the result: nothing happens, still... (0 Replies)
Discussion started by: dsyberia
0 Replies
LEARN ABOUT HPUX
killall
killall(1M)killall(1M)NAME
killall - kill all active processes
SYNOPSIS
[signal]
DESCRIPTION
is a procedure used by to kill all active processes not directly related to the shutdown procedure.
is chiefly used to terminate all processes with open files so that the mounted file systems are no longer busy and can be unmounted. sends
the specified signal to all user processes in the system, with the following exceptions:
the process;
all processes (including background processes) associated with the terminal from which was invoked;
any process, if owned by
any process, if owned by
any process;
any process;
any process.
obtains its process information from and therefore may not be able to perfectly identify which processes to signal (see ps(1)).
If no signal is specified, a default of (kill) is used.
is invoked automatically by The use of is recommended over using by itself (see shutdown(1M)).
FILES SEE ALSO fuser(1M), kill(1), ps(1), shutdown(1M), signal(5).
STANDARDS CONFORMANCE killall(1M)
08-21-2013
