【Oracle 筆記 】Oracle EBS AP shutdown / startup 時，查看連結紀錄

Oracle EBS R12 的 Form Client 標準透過 Servelet 與 Form Server 溝通，但也允許以 WinSocket 方式 (比較不建議，需上 Patch)。

連上 Form Server時，可看到 frmweb 這些 process 等待處理回應。 當我們下 adstpall.sh 停掉 AP server 時，可到 /u01/apps/PROD/inst/apps/PROD_tw-srv/logs/oar/10.1.2/forms/socket.log 查看 Client 連結紀錄。這  log 紀錄 Oracle EBS AP server 在 10/30/14-19:04:26 被 shutdown， 而於 10/30/14-19:18:16 被 startup。



[Thu Oct 30 17:18:46 2014 CST]::LISTN: Connection Request [ConnId=482, Addr=xx.xx.xx.103:5128]
[Thu Oct 30 17:23:28 2014 CST]::LISTN: Connection Request [ConnId=483, Addr=xx.xx.xx.140:7952]
[Thu Oct 30 17:48:05 2014 CST]::LISTN: Connection Request [ConnId=484, Addr=xx.xx.xx.123:7698]
[Thu Oct 30 17:56:17 2014 CST]::LISTN: Connection Request [ConnId=485, Addr=xx.xx.xx.103:14089]

10/30/14-19:04:26 :: adformsrvctl.sh version 120.15.12010000.3
10/30/14-19:04:26 :: adformsrvctl.sh: Stopping  FORMS Server (Socket Mode)


10/30/14-19:04:26 :: adformsrvctl.sh: exiting with status 0

================================================================================


10/30/14-19:18:14 :: adformsrvctl.sh version 120.15.12010000.3
10/30/14-19:18:16 :: adformsrvctl.sh: Starting FORMS Server (Socket Mode)


10/30/14-19:18:16 :: adformsrvctl.sh: exiting with status 0


================================================================================


FORMS CONNECTION ACTIVITY LOG FILE
Developer:Forms/LogRecord

[Thu Oct 30 19:18:16 2014 CST]::Server Start-up Data:
        Server Log Filename: /u01/apps/PROD/inst/apps/PROD_tw-srv/logs/ora/10.1.2/forms/socket.log
        Server Hostname: tw-srv.elvismeng.com.tw
        Server Port: 9000
        Server Pool: 1
        Server Process Id: 23268

[Thu Oct 30 20:11:26 2014 CST]::LISTN: Connection Request [ConnId=0, Addr=xx.xx.xx.131:27909]
[Thu Oct 30 20:23:16 2014 CST]::LISTN: Connection Request [ConnId=1, Addr=xx.xx.xx.132:12552]
[Thu Oct 30 20:31:19 2014 CST]::LISTN: Connection Request [ConnId=2, Addr=xx.xx.xx:25599]


在 /u01/apps/PROD/inst/apps/PROD_tw-srv/logs/oar/10.1.2/forms 目錄下存放 3 種檔案: *.rti 檔案, frmweb_dump_(pid) 檔案與 .log 檔案。

前面提到，每個 Form Client 登入後，在 AP Server 端都會各自有唯一的 process 作為窗口，與之對應，提供服務。這 process 就是 frmweb 程序。 frmweb process 生成後， 會將登入檔案以 em_(pid).rti 的檔名紀錄，而所有關於 forms 的 frmweb 活動只記錄在 socket.log (若以 socket 溝通) 裡。 例如:

查看一個 frmweb 這 process:


[root@tw-srv ~]# ps -ef | grep 14675
dmgr  14675 23268  0 10:50 ?        00:00:01 frmweb webfile=5,49,tw-srv_9000,/u01/apps/PROD/inst/apps/PROD_twhc-srv-erp/logs/ora/10.1.2/forms/socket.log 


在這 log 目錄下，找到與之對應的 .rti 登入檔:


[root@tw-srv forms]# vi em_14675.rti
listener = tw-srv-_9011
pid = 14675
connect = Fri Oct 31 10:50:16 2014 CST
ip = 92.68.1.11
user = APPLSYSPUB
db_string = PROD
~


至於 frmweb_dump_(pid) 這些檔案紀載 client / server 的 connection 有問題的紀錄，可作為 debug 除錯 Oracle EBS 的參考。例如:


[root@tw-srv forms]# vi frmweb_dump_15207
[Tue Jun 24 15:52:18 2014 CST]::Client Status [ConnId=1007, PID=15207]
        >> ERROR: Abnormal termination of connection, Error Code: 6

FORM/BLOCK/FIELD: APXINWKB:BAT_SUM_FOLDER.DISTRIBUTION_LINE_NUMBER
Last Trigger: KEY-COMMIT - (Execution Suspended)
Msg: 
Last Builtin: COMMIT - (Successfully Completed)
------------- Call Stack Trace [ConnId = 1007, ProcId = 15207] -------------

calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
siehjmpterm()+755    CALL                          2 ? A591ED ? FFC2F8 ? 0 ?
                                                   0 ? 0 ?
                     CALL
                     CALL

(N/A)

------------- End of Call Stack Trace -------------
~
~
~
~
~
~
"frmweb_dump_15207" 46L, 2713C