WHAT ARE .RTI FILES?
For the starters, we referred
- What Are .RTI And .FLI Files? (Doc ID 470850.1) and summarized as follows -
Format- em_<PID>.rti
These files are generated
by the forms runtime processes.
Used by Oracle Application
Manager "OAM" and the Enterprise Manager "EM" for Forms
Monitoring services
The rti files should automatically be cleaned up/removed when the user
logs out of the Oracle Applications in a normal logout fashion.
However, if a user does not logout, and just uses the 'X' button to
close the form or kills the browser session before logging out of forms, then
the rti file may not get cleared.
If the files are not automatically being removed, then you can write a
Unix shell script to remove them periodically.
We opened a forms session from ebs r12.1.3 to simulate -
1. Normal Logout Fashion for forms
2. Forms Abnormal termination
We used below environment for our test-case -
Normal Logout
Fashion for forms
Suppose client IP is
195.1.1.171
OS level "ps" command can
easily help us get process id of frmweb session as follows -
[applprod@prod forms]$ ps -ef | grep frmweb |
grep 195.1.1.171
applprod 21246 22589 0 14:25 ? 00:00:00
/data/prod/apps12/apps/tech_st/10.1.2/bin/frmweb server
webfile=HTTP-0,0,1,default,195.1.1.171
SQL Prompt –
SQL> select v.MACHINE,v.PROGRAM, v.MODULE,
v.ACTION, v.CLIENT_IDENTIFIER
from v$session v
where v.process = '21246';
We then checked $FORMS_TRACE_DIR -
[applprod@prod forms]$ ls -ltr | tail
-rw-r--r-- 1 applprod proddba 133 Jul
7 14:20 em_20068.rti
-rw-r--r-- 1 applprod proddba 133 Jul
7 14:21 em_20240.rti
-rw-r--r-- 1 applprod proddba 133 Jul
7 14:22 em_20479.rti
-rw-r--r-- 1 applprod proddba 133 Jul
7 14:23 em_20782.rti
-rw-r--r-- 1
applprod proddba 133 Jul 7 14:25 em_21246.rti
-rw-r--r-- 1 applprod proddba 132 Jul
7 14:25 em_21357.rti
-rw-r--r-- 1 applprod proddba 133 Jul
7 14:31 em_23143.rti
-rw-r--r-- 1 applprod proddba 133 Jul
7 14:33 em_24700.rti
-rw-r--r-- 1 applprod proddba 1701 Jul 7 14:40 Servlet_RTI.log_22589
-rw-r--r-- 1 applprod proddba 133 Jul
7 14:40 em_27036.rti
There were 2 files updated
-
[applprod@prod forms]$ tail Servlet_RTI.log_22589
20068 frmweb server
webfile=HTTP-0,0,1,default,195.1.1.137
20240 frmweb server
webfile=HTTP-0,0,1,default,195.1.1.150
20479 frmweb server
webfile=HTTP-0,0,1,default,195.1.9.136
20782 frmweb server
webfile=HTTP-0,0,1,default,195.1.1.177
21246 frmweb server
webfile=HTTP-0,0,1,default,195.1.1.171
21357 frmweb server webfile=HTTP-0,0,1,default,195.1.2.90
23143 frmweb server
webfile=HTTP-0,0,1,default,195.1.1.159
27036 frmweb server
webfile=HTTP-0,0,1,default,195.1.1.225
27984 frmweb server
webfile=HTTP-0,0,1,default,195.1.5.160
28143 frmweb server webfile=HTTP-0,0,1,default,195.1.2.142
[applprod@prod forms]$ cat em_21246.rti
listener = 1
config = default
pid = 21246
connect = Sun Jul 7 14:25:06 2019 +04
ip = 195.1.1.171
user = APPLSYSPUB
db_string = PROD
[applprod@prod forms]$
[applprod@prod forms]$
From front-end, we went for
a normal exit of Oracle Forms.
Closed form window as
follows –
Normal termination
automatically cleared file em_21608.rti from backend.
[applprod@prod forms]$ ls -ltr em_21246.rti
ls: em_21246.rti: No such file or directory
[applprod@prod forms]$
Even entry in file
Servlet_RTI.log_22589 was cleared
[applprod@prod forms]$ cat
Servlet_RTI.log_22589 | grep 21246
[applprod@prod forms]$
Forms Abnormal Termination -
Later we opened a new form
session for abnormal termination.
We abnormally terminated
this form by closing browser directly and cleared web browser cache,
reopened web browser and
started form session again
[applprod@prod forms]$ ls -ltr em_21246.rti
ls: em_21246.rti: No such file or directory
[applprod@prod forms]$ ls -ltr | tail
-rw-r--r-- 1 applprod proddba 133 Jul
7 14:20 em_20068.rti
-rw-r--r-- 1 applprod proddba 133 Jul
7 14:22 em_20479.rti
-rw-r--r-- 1 applprod proddba 133 Jul
7 14:23 em_20782.rti
-rw-r--r-- 1 applprod proddba 132 Jul
7 14:25 em_21357.rti
-rw-r--r-- 1 applprod proddba 133 Jul
7 14:31 em_23143.rti
-rw-r--r-- 1 applprod proddba 133 Jul
7 14:40 em_27036.rti
-rw-r--r-- 1 applprod proddba 133 Jul
7 14:42 em_27984.rti
-rw-r--r-- 1 applprod proddba 133 Jul
7 14:43 em_28143.rti
-rw-r--r-- 1 applprod proddba 1642 Jul 7 14:49 Servlet_RTI.log_22589
-rw-r--r-- 1 applprod proddba 133 Jul
7 14:49 em_30121.rti
[applprod@prod forms]$
[applprod@prod forms]$
[applprod@prod forms]$ cat em_30121.rti
listener = 1
config = default
pid = 30121
connect = Sun Jul 7 14:49:00 2019 +04
ip = 195.1.1.171
user = APPLSYSPUB
db_string = PROD
[applprod@prod forms]$
[applprod@prod forms]$ tail
Servlet_RTI.log_22589
20068 frmweb server
webfile=HTTP-0,0,1,default,195.1.1.137
20479 frmweb server
webfile=HTTP-0,0,1,default,195.1.9.136
20782 frmweb server
webfile=HTTP-0,0,1,default,195.1.1.177
21357 frmweb server
webfile=HTTP-0,0,1,default,195.1.2.90
23143 frmweb server
webfile=HTTP-0,0,1,default,195.1.1.159
27036 frmweb server
webfile=HTTP-0,0,1,default,195.1.1.225
27984 frmweb server
webfile=HTTP-0,0,1,default,195.1.5.160
28143 frmweb server webfile=HTTP-0,0,1,default,195.1.2.142
30121 frmweb server
webfile=HTTP-0,0,1,default,195.1.1.171
30236 frmweb server
webfile=HTTP-0,0,1,default,195.1.1.214
[applprod@prod forms]$
We closed browser directly
without closing form session to make sure there was abnormal termination for
forms.
[applprod@prod forms]$ ls -ltr | tail
-rw-r--r-- 1 applprod proddba 133 Jul
7 14:22 em_20479.rti
-rw-r--r-- 1 applprod proddba 133 Jul
7 14:23 em_20782.rti
-rw-r--r-- 1 applprod proddba 132 Jul
7 14:25 em_21357.rti
-rw-r--r-- 1 applprod proddba 133 Jul
7 14:31 em_23143.rti
-rw-r--r-- 1 applprod proddba 133 Jul
7 14:40 em_27036.rti
-rw-r--r-- 1 applprod proddba 133 Jul
7 14:42 em_27984.rti
-rw-r--r-- 1 applprod proddba 133 Jul
7 14:43 em_28143.rti
-rw-r--r-- 1 applprod
proddba 133 Jul 7 14:49 em_30121.rti
-rw-r--r-- 1 applprod proddba 1701 Jul 7 14:49 Servlet_RTI.log_22589
-rw-r--r-- 1 applprod proddba 133 Jul
7 14:49 em_30236.rti
[applprod@prod forms]$ cat em_30121.rti
listener = 1
config = default
pid = 30121
connect = Sun Jul 7 14:49:00 2019 +04
ip = 195.1.1.171
user = APPLSYSPUB
db_string = PROD
[applprod@prod forms]$
Concluding our use-case,
em_30121.rti will reside on server forever unless cleared manually as part of
house-keeping.
We can set a cron job to perform this, a shell script with below code will clear .rti files older than 15 days -
We can set a cron job to perform this, a shell script with below code will clear .rti files older than 15 days -
cd $FORMS_TRACE_DIR
find . -name "em_*.rti" -mtime +15 |wc -l
>> /data/prod/apps12/apps/scripts/file_count.lst;
echo "\n number of forms logfiles older
than 15 days - `cat /data/prod/apps12/apps/scripts/file_count.lst | tail
-1`"
find . -name "em_*.rti" -mtime +15 -exec
rm -f {} \;
No comments:
Post a Comment