Best Of
Re: Performance issue when saving PC_FND_DIST component
Hi, @Pere Taule-Oracle.
Hope you are also well. We have submitted SR 3-41618840751 and it's been moved up to a sev 2 as it is impacting production.
Thanks so much!
Re: How to delete applied archived log from standby side with and without setting FRA?
I would say this is immature feature of oracle DB. On standby, If we need to schedule archive deletion script then what is benefit of having this policy ( RMAN archive delete policy applied on standby). On standby archives will anyway not be deleted until FRA is full. Nobody would like to wait in production for FRA to become full.
Re: Unable to see Setup Folder When I Download and Extract PT-INFRA-DPK-WIN-8.61-250717_1of2
Hi @User_I9NTZ
You will have to unzip either "PEOPLETOOLS-WIN-8.61.13_1of4" or "FSCM-920-UPD-054-WIN_1of11" in order to get the setup folder. The PT Infra DPK's are to be used along with either the PeopleTools DPK or the PUM DPK and not separately.
Thanks,
-Jitendra
Re: environment variable ORACLE_PDB_SID doesn"t work
please confirm that you are using correct cdb and pdb name:
select name from v$database;
select name from v$pdbs;
Re: environment variable ORACLE_PDB_SID doesn"t work
Hi
Please check this parameter in working and non working. It could be false in non working env.
_system_trig_enabled
select 'Hidden Parameters' "CHECK_NAME",a.inst_id, a.ksppinm "Parameter",
b.ksppstvl "Session Value",
c.ksppstvl "Instance Value"
from x$ksppi a, x$ksppcv b, x$ksppsv c
where a.indx = b.indx and a.indx = c.indx
and a.inst_id=b.inst_id and b.inst_id=c.inst_id
and a.ksppinm in ('_system_trig_enabled');
Thanks
Rahul Kumar
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
