Best Of
Re: Orchestration Monitoring - Where is the trigger/setup to monitor a particular ORCH stored
Hi John
This is a total guess on my part as we don't have this feature in our Tools Release (we're on 9.2.8.4), but my guess would be that it's held in the blob data column (OROMRBLOB) within table F9524810.
Take a look at the table using Databrowser and open the blob data to see the XML. If you can find the code that switches on for a known Orchestration then you could possibly use SQL to find entries that have the monitoring switched on. For example, if the XML contains "<monitor>" for Orchestrations where it is switched on then something like the below should work for an Oracle database:
SELECT ORWOBNM as Object_Name
, ORWOUSER as Object_Owner
, ORWOOBNMS as Orchestrator_Name
, ORWOOBNML as Description
, ORSY as System_ID
, ORUSER as Updated_By
, ORWOUTIME as Updated_On
, ORPID as Updated_Pgm
, ORMKEY as Machine_Key
, TO_CLOB(OROMRBLOB) as Blob_Data
, 'PD920' as Env
FROM PD920.F9524810
WHERE DBMS_LOB.INSTR(OROMRBLOB, UTL_RAW.CAST_TO_RAW('<monitor>')) > 0;
Hope it helps
Jonathan
MasonJo
Re: Oracle EBS Login Page - How to add personalized legal notice/attestation text
Hi there,
Why don't you look on below documents that explain in details about how to personalize the EBS Home Page.
How To Add Content in Personalize Page? (Doc ID 2366829.1)
How to Personalize 12.1.3 Login Page to add a "Register Here" Link and point it to a custom URL (Doc ID 2522944.1)
How to Personalize E-Business Suite Login Page in 12.2.5+ (Doc ID 2451925.1)
How To Customize Oracle EBS Login Page Logo, Privacy Statement And Add ToolTips In E-Business Suite 12.2 (Doc ID 2321108.1)
Thanks,
Neeraj
Re: How to Get Current CVE Information on Oracle Linux
Dear All,
The question was reoslved. Thank you.
Re: How to migrate database from ODA (X8-2)19.6 to ODA (X11-2)19.26
Thank you very much for your reply.I setup dataguard between 19.6 in X8 and 19.26 in X11.Switchover worked perfectly and datapatch also executed successfully.
DDeb
Re: Do not connect SBC to OCSM via wancom0 port
Antonio,
I created new network-interface, intended just for OCSM, and created the realm on top of it. One interesting thing I revealed in this analysis: if you create just network-iface, add proper host-route and connects comm-monitor to this iface, then nothing works. There are SYN requests from SBC to OCSM and SYN,ACK responses from OCSM to SBC in packet-trace captured on the network-interface, but there are no ACKs from SBC to OCSM. If you check log.atcp, then there will be no those SYN,ACKs only SYNs. So, SYN,ACK are lost somewhere between network-interface and atcpd daemon. IP address of OCSM does no appear in any acl or ip connection table or even in shell's 'netstat -a' output. Once you create realm, SBC stops blocking of the SYN,ACKs. So, without the realm, the network-interface is absolutely useless hole.
Regards, Daureen
Re: Do not connect SBC to OCSM via wancom0 port
Hello,
According to OCSM graph "Active calls" the number of active session had abruptly grown from normal ~8K to ~18K. This issue occurred on September 5 afternoon. After we connected comm-monitor to media ports on September 26 the number of session had fallen to normal 8K. There were no changes made on SBCs before September 5 that could cause the issue. Also there were no changes on network that could somehow reduce the bandwidth in mgmt vlan (and reduce the throughput of wancom0).
All SBCs connected to this OCSM generate ~5K session in total.
Regards,
D
