How to get Client IP address in oracle apps.

Connect with APPS User.

Run below Statement.

SQL> set line 1000
SQL> select SID, PROCESS, MACHINE, CLIENT_IDENTIFIER from v$session;

SID     PROCESS          MACHINE            CLIENT_IDENTIFIER
322        19943           Sujeet.oracle.com            Sujeet jha
262        19943           Sujeet.oracle.com             Sujeet jha


Login with Application User.

[appl@sujeet]$ ps -ef|grep 19943 <User latest Process id>

502      19943  6616  0 14:35 ?        00:00:34 /u02/apps/apps/tech_st/10.1.2/bin/frmweb server webfile=HTTP-0,0,1,default,192.168.0.1
502      23747 23723  0 16:38 pts/2    00:00:00 grep 19943


OUT PUT:- 
Client Name:- Sujeet jha
Machine Name:- sujeet.oracle.com
IP:- 192.168.0.1


No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf...