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)
Getting ip of the host which initiated creation of a dedicated process [message #557469] Wed, 13 June 2012 00:48 Go to next message
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
Re: Getting ip of the host which initiated creation of a dedicated process [message #557525 is a reply to message #557469] Wed, 13 June 2012 08:41 Go to previous message
BlackSwan
Messages: 22789
Registered: January 2009
Senior Member
SELECT SID, SERIAL, LOGON_TIME, MACHINE FROM V$SESSION
WHERE TO_CHAR(LOGON_TIME,'HH24:MI') = '14:51';
Previous Topic: Finding a Particular Pattern From a File in UNIX
Next Topic: variable not found error
Goto Forum:
  


Current Time: Thu Sep 18 07:00:22 CDT 2014

Total time taken to generate the page: 0.12043 seconds