Best Of
Re: SAP on Oracle 19c — Multiple SIDs Mapped to Same OS Process
Never looked with that detail into such a thing, why must it be a problem ?
If you kill a database session, it would just kill one database session … even if on same OS process ?
What database version are you running ?
Mr. C
Webinar: Troubleshooting & Monitoring of Oracle EBS Using OCI Observability & Management Platform
Live Webinar: Hear about the new technology and best practices designed to help troubleshoot and proactively monitor E-Business Suite, both in the cloud and on-premise. See how you can eliminate risk and manual work by automating simple, repetitive tasks using alerts and notifications.
You will see how to monitor, analyze, and manage multicloud applications and infrastructure environments with full-stack visibility, prebuilt analytics, and automation using Oracle Cloud Observability and Management Platform.
Register for the webinar: OCI/ERP - Improve Troubleshooting, Performance, and Monitoring of Oracle E-Business Suite Using OCI Observability & Management Platform that will take place on November 8, 2022 at 10am PST. Click this link to register: https://community.oracle.com/customerconnect/events/604146-oci-erp-improve-troubleshooting-performance-and-monitoring-of-oracle-e-business-suite-using-oci-observability-management-platform
Re: Adding cipher suites to SBC version 10. Is it possible?
Hi Daureen
that info shows just the negotiated cipher , but it does not show the list of ciphers supported by the client so it is unknown if ciphers included in version 10 are supported by the clients .
Cheers
Antonio
Re: Convert xml/clob to readable varchar
Well GazinOz , your post is just a hint . A good but the simple one. In fact in mean time I have already found a solution.
SELECT bv.name name,
bv.pos position,
bv.TYPE TYPE,
bv.VALUE VALUE
FROM gv$sql_monitor s,
XMLTABLE ('/binds/bind'
PASSING xmltype (s.binds_xml)
COLUMNS name VARCHAR2 (30) PATH '@name',
pos NUMBER PATH '@pos',
TYPE VARCHAR2 (15) PATH '@dtystr',
VALUE VARCHAR2 (4000) PATH '.') bv
WHERE s.sql_id = '2mf4jt8s968kb' AND s.sql_exec_id = '33689343'
ORDER BY bv.pos;
KP_2
Re: Adding cipher suites to SBC version 10. Is it possible?
Hi Daureen,
If you run a packet capture on the interface you want to check offered cipher suites on you should be able to see the TLS handshake and the cipher suites being offered. SSH onto the SBC and run packet-trace local start M20:0 on the interface replacing M20:0 with whatever is appropriate. You then need to SFTP onto the SBC to retrieve pcap file where you should be able to see TLS handshake. You might need to leave the capture running for a while to capture the TLS handshake or prompt some kind of failover between SBC's like Antonio described to force the SBC to renegotiate a TLS handshake.
Regards,
David.
Re: Group Session Limit Across Four SIP Interfaces (Two Groups, Shared Limits)
Hi Antonio,
I think your understanding is correct.
Hi Shilpi,
I’m just testing and validating my idea.
Of course, deploying a new SBC would quickly resolve this issue.
Thanks everyone for your assistance.
YyL
Re: Group Session Limit Across Four SIP Interfaces (Two Groups, Shared Limits)
Hi Shilpi
it is exactly what I ment on my previous reply .
Thanks for the confirm
Antonio
Re: Adding cipher suites to SBC version 10. Is it possible?
Hello Daureen
depending from how many clients your customer have ( if are many probably more time is needed ) they can try to trace the TLS handshake , after make an HA switchover TLS is negotiated again and in that moment , when clients behave as client TLS actors , it is possible to check which ciphers are offering .
Unfortunately shell on the SBC does not support openssl or nmap commands , with that it would have been much faster to check remote supported ciphers .
Cheers
Antonio
Re: Announcements not showing up in the delivery method
Hello User_SECH1,
I moved your post from PeopleSoft on the Oracle Cloud (MOSC)to Human Resources and ELM - PSFT (MOSC) as your question is related to PeopleSoft HCM application.
From the screenshot shared, I see you are looking for announcements on the HR Notification page. You would be able to post new announcements from the HR Announcements page:
Set Up HCM > Common Definitions > HR Notification > HR Notification > HR Announcements
The blog information shared is quite old, and since PUM 29 there have been significant changes, hence for posting Fluid announcements, you need to use HR Announcements page.
Re: Has anyone reached the max on Shift Code setup in UDC - 06/SC
Hello,
We have run out of codes, when a request comes in for a new one i run a query to find the last time a code was used by company and if it has not been used in a while, I recycle codes. Hope this helps some.
Lisa
Lisa J