Best Of
Re: environment variable ORACLE_PDB_SID doesn"t work
Hi,
does PDB1 exist in your CDB CDB1?
BR
Markus
Re: SBC HA when using SIP/TCP
I fear here we'd need to go back to basics and catch on anything that would give a lead on what best practice should be. And I do believe 3261 gives a hint
8.1.3.1 Transaction Layer Errors In some cases, the response returned by the transaction layer will not be a SIP message, but rather a transaction layer error. When a timeout error is received from the transaction layer, it MUST be treated as if a 408 (Request Timeout) status code has been received. If a fatal transport error is reported by the transport layer (generally, due to fatal ICMP errors in UDP or connection failures in TCP), the condition MUST be treated as a 503 (Service Unavailable) status code.
and here we come to the area of proprietary SIP stack implementation and how TCP reset may map upstream to SIP error. Most SBCs will map transport TCP RST received into internal 503 and failover/re-try based on configuration. Moreover most SBCs will have an option to re-map default internal error into any other SIP error just to trigger custom desired behavior.
In any case, reported behavior, such as —> "do nothing" on receipt of TCP RST seems clearly to be misbehavior.
Re: OCW Release Update 19.28.0.0.250715 fails, looking for ins_has.mk
I ran into this too, and while I appreciate the response "not intended for Oracle Client" … this raises a HUGE question for me personally. I have an open SR about it too.
January '25 was applied without issue, April '25 was applied. All of 2024, 2023, etc. back to the original 19c.
So, i went digging … the reason WHY it is failing is that the section that executes the "make" has been moved, again. Each month it was different. WHY?
January '25 CPU:
37262208/37257886/37268031/etc/config/actions.xml
<oracle.has.db.cvu opt_req="O" version="19.0.0.0.0">
<copy backup_in_zip="false" file_name="cv/cvdata/cvu_prereq.xml_db" name="cvu_prereq.xml" path="%ORACLE_HOME%/cv/cvdata" retain_permission="true" shaolue="6EA609ABC1738B54145FC6ADD37329FBCBB1E113"/>
</oracle.has.db.cvu>
Make located in: oracle.rhp.common
April '25 CPU:
37591516/37641958/37654975/etc/config/actions.xml
<oracle.has.db.cvu opt_req="O" version="19.0.0.0.0">
<copy backup_in_zip="false" file_name="cv/cvdata/cvu_prereq.xml_db" name="cvu_prereq.xml" path="%ORACLE_HOME%/cv/cvdata" retain_permission="true" shaolue="6EA609ABC1738B54145FC6ADD37329FBCBB1E113"/>
</oracle.has.db.cvu>
Make located in: oracle.has.crs
July '25 CPU:
37952382/37957391/37962946/etc/config/actions.xml
<oracle.has.db.cvu opt_req="O" version="19.0.0.0.0">
<copy backup_in_zip="false" file_name="cv/cvdata/cvu_prereq.xml_db" name="cvu_prereq.xml" path="%ORACLE_HOME%/cv/cvdata" retain_permission="true" shaolue="6EA609ABC1738B54145FC6ADD37329FBCBB1E113"/>
<make change_dir="%ORACLE_HOME%/srvm/lib" make_file="ins_srvm.mk" make_target="install_srvm"/><make change_dir="%ORACLE_HOME%/racg/lib" make_file="ins_has.mk" make_target="install"/>
</oracle.has.db.cvu>
Notice that the "make" commands now exist in "oracle.has.db.cvu", the last few that I have checked, they existed in different components. Perhaps there is a logical explanation. But this becomes a moving target and hard to justify to any type of auditor why the OCW is now stuck at 19.27.0.0 when everything else has move to 19.28.0.0
Moving the "make change_dir" out of "oracle.has.db.cvu", I was able to successfully apply this patch, which maybe is NOT ideal … Since though it exists on Oracle Client, but "it isn't required" … what options actually exist?
Re: Can HMR modify the SIP Method?
Hello,
It is written in HMR configuration guide, that manipulation cannot change one method to another. I was checking log.sipd and came across a system message, that the CSeq field and RURI field itself are somehow protected against such manipulations as well as From/To tag uri-parameters.
Regards,
Daureen
Re: Unable to create requisition for Description based item through work order in EAM
Can you please provide the error messages ?
If not present in the Req Import output report then use this query:
SELECT POE.COLUMN_NAME,
POE.ERROR_MESSAGE,
RQI.INTERFACE_SOURCE_LINE_ID,
RQI.WIP_ENTITY_ID,
RQI.TRANSACTION_ID,
RQI.PROCESS_FLAG,
RQI.AUTHORIZATION_STATUS,
RQI.DELIVER_TO_LOCATION_ID,
RQI.PREPARER_ID,
RQI.DESTINATION_ORGANIZATION_ID,
RQI.DESTINATION_TYPE_CODE,
RQI.SOURCE_TYPE_CODE,
RQI.LINE_TYPE_ID,
RQI.ITEM_ID,
RQI.NEED_BY_DATE,
RQI.QUANTITY,
RQI.UNIT_PRICE
FROM PO_REQUISITIONS_INTERFACE_ALL RQI,
PO_INTERFACE_ERRORS POE
WHERE RQI.WIP_ENTITY_ID in
(select wip_entity_id
from wip_entities
where wip_entity_name = '&WO_Number')
AND RQI.TRANSACTION_ID = POE.INTERFACE_TRANSACTION_ID(+)
AND RQI.INTERFACE_SOURCE_CODE = 'EAM';
Regards,
Florin
Re: Unable to create requisition for Description based item through work order in EAM
Where do i need to enter the deliver location @SriniS-Oracle, @Piyush-Oracle
Re: Unable to create requisition for Description based item through work order in EAM
Department definition.
Re: When will the OLAM ansible playbook code be upgraded to support 2.3 and OL9?
I opened a new issue @
Thanks
Jim Davis
Re: Where is Windows Patch for oracle 19.28?
OJVM Patches being incorporated into the DB Patches with 21c and newer is not a "fix", it's simply a change in delivery method (which has been used for the past decade). There is nothing to "fix", as there is nothing "broken".
Upgrading from a Long Term Support release to a Feature Release, just to have a difference in patch delivery method is not a "fix", and would not be recommended as such by Oracle Support.
