Best Of
Re: getting the error Failed to send test email: certfile for SMTP config on Oracle session monitor
Re: Enter Feedback Here for the EBS Workflow Java Mailer Analyzer KB551591
Thanks for the feedback.
The correct version 200.45 workflow java mailer analyzer zip file is now downloadable on
Workflow Java Mailer Analyzer (Doc ID 2901874.1).
Re: newer java version certified with Java Web Starter
Ow OK. Thank You Rajagopalan.
I Will use 1.8.0_461 version.
Re: Form control UDC dropdown to display values based on a selection of value in another FC drop down
Try combo box or override the data dictionary item using system function.
E1: FDA: Using a Combo Box Control in Form Design Aid (FDA) (Doc ID 1391121.1)
https://docs.oracle.com/en/applications/jd-edwards/development-tools/9.2.x/eotfd/set-data-dictionary-overrides-1.html
Re: How to check if AIS Server Configuration was successful?
BTW, the json file is named defaultconfig.json.
Thanks.
How does Oracle AP6350 SBC select local-policy used to route a call?
Hi Experts,
I have two local-policy configured on OCSBC AP6350 as follows. The SBC is running software version SCZ920p5.
Local-Policy A:
local-policy
from-address *
to-address 100.200.100.1
source-realm Core
description Outbound to SBC1
activate-time
deactivate-time
state enabled
parallel-forking disabled
policy-priority none
policy-attribute
next-hop SAG:SBC1
realm SBC1_Access
action none
terminate-recursion disabled
carrier
start-time 0000
end-time 2400
days-of-week U-S
cost 0
state enabled
app-protocol
methods
media-profiles
lookup single
next-key
auth-user-lookup
eloc-str-lkup disabled
eloc-str-match
Local-Policy B:
local-policy
from-address +441171234567
+441171234578
+441171234589
to-address *
source-realm Core
description
activate-time
deactivate-time
state enabled
parallel-forking disabled
policy-priority none
policy-attribute
next-hop SAG:SBC2
realm SBC2_Access
action none
terminate-recursion disabled
carrier
start-time 0000
end-time 2400
days-of-week U-S
cost 0
state enabled
app-protocol
methods
media-profiles
lookup single
next-key
auth-user-lookup
eloc-str-lkup disabled
eloc-str-match
Please note that both local-policy has the same source-realm named Core.
When +441171234567 calls 08000123456, and the call gets routed to the SBC from the Core Network, the SBC uses local-policy A to route the call to SAG:SBC1 instead of local-policy B which should route the call to SAG:SBC2.
How do we configure the SBC to always use local-policy B instead of local-policy A for this type of call scenario where a number in the from-field of local-policy B calls any destination number?
Thanks.
Re: How does Oracle AP6350 SBC select local-policy used to route a call?
Hello
in local-policy A what 100.200.100.1 in To-address field is ? is that address present in incoming To or RURI ? if yes probably is the reason why it is matching LP-A , since To-address has priority over From-address .
as general rules below the routing preferences and priority , from top to down :
- Cost (cost in local policy attributes) is always given preference.
- Matching media codec (media profiles option in local policy attributes).
- Longest matching To address (to address list in local policy).
- Shortest matching To address (to address list in local policy).
- Longest matching From address (from address list in local policy).
- Shortest matching From address (from address list in local policy).
- Narrowest/strictest day of week specification (days of week option in local policy attributes).
- Narrowest/strictest time of day specification (start time and end time options in local policy attributes).
- Wildcard matches (use of an asterisk as a wildcard value for the from address and to address lists in local policy).
- Wild card matches are given the least preference. A prefix value of 6 is given a higher preference than a prefix value of * even though both prefix values are, in theory, the same length.
Cheers
Antonio
Re: how to unset _smu_debug_mode in 11g database
Hi,
Greetings, thanks for reaching community. Please find the below inline response.
Once you set this parameter its set in the database. You dont have option to get it removed ( Workaround is below)
»set the following command to set to unset the parameter( This is default parameter value):-
SQL>alter system set "_smu_debug_mode" = 0;
Although you have one option to get it removed from show parameter.
Solution:
Get temporary pfile created from that spfile;
Edit pfile and remove that _smu_debug_mode from pfile and startup database using the modified pfile
voila…
Example:
++++
SQL> create pfile='/tmp/a.ora' from spfile;
File created.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.23.0.0.0
[oracle@celvp**** ~]$ vi /tmp/a.ora
[oracle@celvp***** ~]$ cat /tmp/a.ora | grep smu
*._smu_debug_mode=0
[oracle@celvp**** ~]$ vi /tmp/a.ora
[oracle@celvp****** ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Oct 22 16:19:01 2024
Version 19.23.0.0.0
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.23.0.0.0
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup pfile='/tmp/a.ora';
ORACLE instance started.
Total System Global Area 1073740632 bytes
Fixed Size 9186136 bytes
Variable Size 675282944 bytes
Database Buffers 381681664 bytes
Redo Buffers 7589888 bytes
Database mounted.
Database opened.
SQL> show parameter smu
SQL> SELECT x.ksppinm "Parameter",
Y.ksppstvl "Session Value",
Z.ksppstvl "Instance Value"
FROM x$ksppi X,
x$ksppcv Y,
x$ksppsv Z
WHERE x.indx = Y.indx
AND x.indx = z.indx
AND x.ksppinm LIKE '/_%' escape '/'
and x.ksppinm like '%smu_debug%'
order by x.ksppinm ; 2 3 4 5 6 7 8 9 10 11
++++++
_smu_debug_mode
0
0
SQL> show parameter smu
SQL»»»»»»»» NOTHING SHOWING HERE.
SQL>
Now use this pfile and change this pfile to spfile using known method.
Regards,
Rahul Kumar
[Please Mark the Answers as accepted. If it helps or resolves your issue/queries.]
Re: is it possible to clone a mounted pdb?
Hi,
basically no, it must be in open mode. why do you need that? you may open database in read only mode and then open it.




