kill pid

elainelaw · 04-07-2010, 02:14 AM

The below is the output of lsof -i tcp:7158

COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME
_ora1 5168 root 13u IPv4 584587222 TCP *

ra2 (LISTEN)
_ora2 5168 root 14u IPv4 848578242 TCP ORA

ra2->192.168.100.37:
5878 (ESTABLISHED)

"
"

I found that the process 5168 is locking the database , now the user can't access the database via the service port 7158 , I have to kill it to release the service port , but if I kill it , then I have to restart the database also , otherwise , I can't re-start the service port , can advise how can I only kill the device ID 848578242 , instead of kill the pid 5168 ? thx

TB0ne · 04-07-2010, 08:43 AM

Quote:

Originally Posted by elainelaw

The below is the output of lsof -i tcp:7158

COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME
_ora1 5168 root 13u IPv4 584587222 TCP *

ra2 (LISTEN)
_ora2 5168 root 14u IPv4 848578242 TCP ORA

ra2->192.168.100.37:
5878 (ESTABLISHED)

"
"

I found that the process 5168 is locking the database , now the user can't access the database via the service port 7158 , I have to kill it to release the service port , but if I kill it , then I have to restart the database also , otherwise , I can't re-start the service port , can advise how can I only kill the device ID 848578242 , instead of kill the pid 5168 ? thx

No, you have to shut down the database, or the listener, and restart it.