OraFAQ Forum: Unix » Getting ip of the host which initiated creation of a dedicated process

Home » Infrastructure » Unix » Getting ip of the host which initiated creation of a dedicated process (oracle database 10g , 10.2.0.3.0 , Solaris 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Getting ip of the host which initiated creation of a dedicated process [message #557469]

Wed, 13 June 2012 00:48

yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait

Senior Member

When i try to shutdown the database in shutdown normal mode due to some active sessions shutdown process is waiting for these sessions to be completed. I wanted to find out from the terminal which remote host has initiated the creation of this dedicated processes.

When i do a ps in the terminal i can find the following result

oracle 8314 1 0 14:51:34 ? 0:00 oraclePROD (LOCAL=NO)

Is it possible from Linux or Solaris to get the ip of the remote host this process is servicing, i there a way to get an output like.

oracle 8314 1 0 14:51:34 ? 0:00 oraclePROD (LOCAL=NO) 192.168.1.200 (remote ip address of the host the process is servicing)

Thank You
Yoonus

Report message to a moderator