Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle WebLogic Server installed on the remote host is missing a security patch

User_Z8VY1Nov 14 2022

Hi everyone,
Can anyone help and assist me in the following vulnerability solution with the required patch download link and guidelines to proceed step by step?

Oracle WebLogic Server (Oct 2022 CPU)
Description
The version of Oracle WebLogic Server installed on the remote host is missing a security patch from the October 2022 Critical Patch Update (CPU). It is, therefore, affected by multiple vulnerabilities, including:
- Vulnerability in the Oracle WebLogic Server product of Oracle Fusion Middleware (component: Centralized Third-party Jars (Bouncy Castle Java Library)). Supported versions that are affected are 12.2.1.3.0, 12.2.1.4.0 and 14.1.1.0.0.
Difficult to exploit vulnerability allows unauthenticated attacker with network access via TLS to compromise Oracle WebLogic Server. Successful attacks of this vulnerability can result in takeover of Oracle WebLogic Server.
(CVE-2020-28052)
- Vulnerability in the Oracle WebLogic Server product of Oracle Fusion Middleware (component: Centralized Third-party Jars (Apache Xerces-J)). Supported versions that are affected are 12.2.1.3.0, 12.2.1.4.0 and 14.1.1.0.0. Easily exploitable vulnerability allows unauthenticated attacker with network access via HTTP to compromise Oracle WebLogic Server. Successful attacks require human interaction from a person other than the attacker. Successful attacks of this vulnerability can result in unauthorized ability to cause a hang or frequently repeatable crash (complete DOS) of Oracle WebLogic Server. (CVE-2022-23437)
- Vulnerability in the Oracle WebLogic Server product of Oracle Fusion Middleware (component: Centralized Third-party Jars (Apache Groovy)). Supported versions that are affected are 12.2.1.3.0 and 12.2.1.4.0. Easily exploitable vulnerability allows low privileged attacker with logon to the infrastructure where Oracle WebLogic Server executes to compromise Oracle WebLogic Server. Successful attacks of this vulnerability can result in unauthorized access to critical data or complete access to all Oracle WebLogic Server accessible data. (CVE-2020-17521) )
Note that Nessus has not tested for these issues but has instead relied only on the application's self-reported version number.
Solution
Apply the appropriate patch according to the October 2022 Oracle Critical Patch Update advisory.
See Also
https://www.oracle.com/docs/tech/security-alerts/cpuoct2022cvrf.xml
https://www.oracle.com/security-alerts/cpuoct2022.html

Comments

John Edward Scott
Denes,

Excellent work, if you get stuck trying to find a way to make your application public, drop me a line and we'll sort something out.

John.
453354
Nice looking charts. Good work. Looking forward to seeing them!
Rafael M
Denes,

Good news !!! we will waiting for your results
Doug A. Gault
I'm looking forward to seeing your solution, and comparing it with what we've done internally. I know that what we have done internally is potentially overcomplicated for most people as we've developed with the idea of allowing end users to create graphs via a graphing wizard.

Looking forward to it.

Doug
partlycloudy
Very nice, looking forward to seeing the results and the how-tos.

Thanks for your efforts.
Dietmar Aust
Hi Denes,
htmldb.oracle.com is not an option, since it
doesn't allow access to the
underlaying file system and /i/ directory.
Sure, just put the files on any web server on the internet and reference them from apex.oracle.com. This way you can use Apex on apex.oracle.com and the charting files from the other server.

Regards,
~Dietmar.
Denes Kubicek
Dietmar,

It is not just about the files required for charting. I also need access to an oracle directory, If I want to demonstrate the full range of functionalities I have built in.

Denes Kubicek
533828
Hey Denes;

Thats great.
I look forward to seeing the finished package.
Keep up the good work.
John Edward Scott
I also need access to an oracle directory
Denes, what do you mean by this?
partlycloudy
I suppose some of the functionality he has implemented needs to read config files from the filesystem using the external tables feature which needs a DIRECTORY object to be created (and of course the underying physical directory on the OS level). This is not possible on the hosted site.

Just a guess.
Denes Kubicek
Vikas, thanks for answering - your guess was right.

Now, I would have a question to you if you don't mind. Do you know is there a way to force a page reload if back button is pressed:

1. I am on page 1 and I browse to page 2

2. If I press the back button I will be on page 1 again

3. Can I force reloading after returning to the page?

Thanks,

Denes Kubicek
partlycloudy
Not sure what this has to do with the topic at hand, but I am sure you have your reasons that you will disclose in due course!

Search this forum for Pragma: No-Cache, Expires: and the like. Those HTTP headers are directives that might affect browser behaviour regarding requesting pages from the server or reading from its local cache.

Or you could try using the Javascript "history" object to test if history.go(1) exists (that means the current page has been navigated to by using the browser's Back button) and if so, do a location.reload() or something like that.
Doug A. Gault
Denes,

How close are you to having this in a "publishable" format... My guys would love to take a look at it and are bugging me constantly to get it from you! :-)

Let me know when you're ready to feed your baby to the wolf pack!

Doug
Denes Kubicek
Doug,

I am almost done with debugging. First I need to test it by replacing existing charts in
my applications (numerous). I have to see how it performs in practice, while accessed
by many users. I don't want to publish a "ticking bomb" and loose my good reputation
:-). Second, you have eventually stumbled upon this thread:

1540844

This time I want to avoid any misunderstandings of that kind.

We have our German Oracle User Conference from Wednesday to Friday this week and
I will be there - this is a kind of "local Oracle Open World" for poor people. However,
interesting. Some of your fellow countrymen will be there (Joel Kallmann, Steve Muench)
and some of my fellow countrymen (Carsten Czarski, Dietmar Aust).

Next week I will start creating a demo application to cover all the important things I
came up with. Let me see how long it takes to make it right. I will do my best.

Denes Kubicek
Doug A. Gault
Good enough!

Let me know if you want a confidential beta tester... We have an application here that is made up of almost entirely graphs so I have LOADS of data that I can test with! :-P

Later!

Doug
Arie Geller
Hello Denes,

If you want to control the browser cache using the META tag, as Vikas suggested, you should read the following - http://www.htmlgoodies.com/beyond/reference/article.php/3472881

I'm guessing it is all related to the need to not cache the XML resource file. Why don't you want to use their suggested approach, and use some dynamic variable as a xml_source parameter? If I understand correctly, something like timestamp can do the trick, and be a simple cross browser solution.

Looking forward to your implementation,
Arie.
Denes Kubicek
Arie,

Thanks for the suggestion. I solved that problem in a different way. Yes, it was related to the
source.

Denes Kubicek
441184
Hi denes,

i asked the same half a year before (concerning the back-button)

here is my thread - look to the reference at the bottom; there is a solution described i used for my stuff and this worked with all types of browsers

1256256

regards
Denes Kubicek
Hallo Wolfgang,

I will look into that. Thanks agai.

Wie geht's? Lange nichts von dir gehört.

Denes Kubicek
441184
Hallo Denes,

um das Forum nicht zu stapazieren, habe ich Dir auf Deiner synventive-Adresse geantwortet!

Viel Spass bei Der DOAG, leider kann ich nicht - Viele Grüsse an Dietmar

Gruss Wolfgang
Denes Kubicek
I finaly found some time to do a preliminary "presentation" on what I have done so far.
If someone is interested, it can be found here:

http://htmldb.oracle.com/pls/otn/f?p=31517:58

It explains in few words, how the whole thing works.

Denes Kubicek
partlycloudy

Denes: Very nice.

Few questions, if you don't mind.

chart_template_in          => 'SERIES_SWITCH_1,DECIMAL_CHART_VALUE',

1. What determines the overall look and feel of the generated chart? Is it the XML file you show?
2. If so, where does that XML file live? In a Oracle DIRECTORY on the server?
3. What does the above IN parameter to your procedure do? Why are there 2 values to the parameter?

[Sorry if I am missing something basic about all this, my charting experience is close to zero]

Thanks

Denes Kubicek
Vikas,

No problems.

1. XML file reflects the layout only and can be used for debugging purposes.

2. If debugging is turned on, it requires a directory on the server.

3. You can generate own templates and reuse them at will. You can include as many as
you want as a comma delimited string. Templates are optional.
Standard values are used by default.

Denes Kubicek
partlycloudy
You can generate own templates and reuse them at will

I guess that is what I don't understand. What is the "template" in your example? Is it a XML config file? Where does it live? If I pass in multiple templates using that IN parameter, what does it do?
Denes Kubicek
A templete resides in a table as a piece of XML code - copy it from the file, modify, name it and save. Later, it can be referenced in charts.

Hopefully soon, once I'm done with live testing in my applications, I will be able to set up a
sample application, to show how exactly it works.

Denes Kubicek
a.stropp
Denes,

I was trying to install "Xml_Chart_Pkg" on Oracle XE, but there are some issues in it.
It has dependencies on APEX_APPLICATION and APEX_CUSTOM_AUTH, that in XE are named as FLOWS_020100.HTMLDB_CUSTOM_AUTH and FLOWS_020100.HTMLDB_CUSTOM_AUTH.

I bypassed them with a synonym.

Still there are errors:
SQL>show error package body Xml_Chart_Pkg
Errors for PACKAGE BODY XML_CHART_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
95/19    PL/SQL: SQL Statement ignored
98/46    PL/SQL: ORA-00942: table or view does not exist
105/13   PL/SQL: Statement ignored
105/34   PLS-00364: loop index variable 'C' use is invalid
106/13   PL/SQL: Statement ignored
109/24   PLS-00364: loop index variable 'C' use is invalid
130/22   PL/SQL: SQL Statement ignored
133/49   PL/SQL: ORA-00942: table or view does not exist
141/16   PL/SQL: Statement ignored
141/37   PLS-00364: loop index variable 'C' use is invalid
143/16   PL/SQL: Statement ignored
144/57   PLS-00364: loop index variable 'C' use is invalid
146/25   PL/SQL: SQL Statement ignored
162/43   PL/SQL: ORA-00942: table or view does not exist
168/19   PL/SQL: Statement ignored
169/57   PLS-00364: loop index variable 'D' use is invalid
170/19   PL/SQL: Statement ignored
170/40   PLS-00364: loop index variable 'D' use is invalid
181/22   PL/SQL: SQL Statement ignored
184/49   PL/SQL: ORA-00942: table or view does not exist
SQL>
would it be possible to have a list of dependencies on apex's objects so I can try to solve them with synonyms?

TIA
Andrea
Denes Kubicek
Sorry,

I didn't consider all the different versions of ApEx. Now, I updated the package
and you can download the newest version from here:

http://htmldb.oracle.com/pls/otn/f?p=31517:58

You can recreate the package body only and it should show no errors.

Tell me if it worked out.

Denes Kubicek
135285
Hi Denes,

really nice solution!

Patrick
-----------------------------------------------------------------------------------
Check out my Apex blog! http://inside-apex.blogspot.com
Denes Kubicek
Hello Patrick,

Does this mean you got it working?

Denes Kubicek
a.stropp
Hello, Denes.

I downloaded the new version.
I still had to create the two synonyms previously cited, and grant execute on UTL_FILE to the schema where XML_CHART_PKG is installed on.

Now it compiles correctly, but I'm still managing to make it work (I have still to understand all of the parameters to the procedure...)

I wlll let you know when I could make it work.

Thanks,
Andrea
Denes Kubicek

O.K.

Here is the explanation for the package parameters:

BEGIN
   xml_chart_pkg.xml_chart_pr
                           (item_for_query                 => ':P1_ITEM',
--item storing your chart query
                            chart_type_in                  => 'stacked',
--your chart type
                            sort_series_in                 => 'ASC',
--how to sort series
                            width_in                       => 600,
--width of your region
                            height_in                      => 450,
--height of your region
                            debug_xml_in                   => 'N',
--using debug option
                            xml_output_dir_name_in         => 'DIRECTORY',
--debug output directory
                            chart_template_in              => 'MY_TEMPLATE:SWITCH_COLORS',
--templates to be used with your chart
                            chart_standard_ignore_in       => 'N',
--ignore all standard settings
                            link_type_in                   => 'P',
--link type P for popup and R for redirect
                            page_to_pass_values_to         => '200',
--page to pass values in the link
                            request_in                     => 'SORT',
--request to pass within link
                            items_to_pass_values_to        => 'P200_ITEM',
--items to pass values to, comma delimited
                            values_to_pass_to_items        => '_category_',
--values to pass to items, see XML reference
                            link_pop_up_w_in               => '1000',
--link popup window width
                            link_pop_up_h_in               => '800',
--link popup window height
                            chart_background_color_in      => '#ededd6',
--region color
                            unique_id_in                   => NULL,
--unique string to identify your chart if the same chart
--type is used on the same page
                            turn_caching_on                => 'N'
--if your want to keep the session result per chart,
--use collection to store the result set
                           );
END;

item_for_query is the only parameter without a default option - means you need to specify only this one.

Denes Kubicek

135285
Hi Denes,

is it possible that the demos on your site do not work anymore? I was going to show the demo to a manager today, but it didn't show any charts.

I thought it's maybe a problem of my computer at work, tried it at home again and it doesn't work. :-(

Yesterday (sunday) it worked without a problem.

Patrick
------------------------------------------------------------------------------------
Check out my APEX-blog: http://inside-apex.blogspot.com
Earl Lewis
They worked for me a half hour ago.

Earl
Denes Kubicek
These demos are showing the end result and are created using a static xml file
from an ftp server. Sometimes, I noticed that as well, they do not get rendered.
I just tried again and it worked out. What I noticed as well is, that they don't get
rendered if I use Opera - don't ask me why... For the other two browsers they
work fine.

Something else. I provided the package for creating XML charts and made it
available for download. I'm still working on it and trying to get all the bugs out.
Why don't you try to install that package and generate your charts yourself?

Denes Kubicek
135285
Strange, it has something to do with my VPN! If disable it, everything is fine.

The really strange thing is that the demos of the vendor at http://www.maani.us/charts/index.php?menu=Gallery work without a problem.

So what's the difference? I don't really have to understand what computers are doing if the day is long... :-)

Patrick
-------------------------------------------------------------------------------------
Check out my APEX-Blog! http://inside-apex.blogspot.com
533828
Hey Denes;

I tried out your xml page.
When viewing the page, it looks pretty slick in the Firefox browser.
But for whatever reason it doesn't show anything in my IE ver6 browser.
Even after reinstalling the adobe flash player.
I'm going to assume its just my browser on my pc.

Unless anyone else has the same scenario.
Be sure to let me know.
Thanks.
Ilmars2
Denes: Awesome Job!

Colin,

You are not alone. I am seeing a similar behavior:
1) The flash graphs did not render on IE v6 (flash v9) at my work location nor at my home location (IE v6; flash v6). Tried multiple times through out the day (www.maani.us flash graphs worked just fine);
2) The flash graphs rendered properly on Safari.


Looking forward to implement the solution locally, although not quite sure how yet since I do not have access to /i/directory. Will have to do some more digging/reading to get some enlightenment.
Denes Kubicek
Colin,

forget about the page. It is getting the xml file from an FTP server. I have no idea why it
doesn't work in some situations. Get the download of the package and test the real
solution.

Denes Kubicek
489802
Hello,

I'am trying the xml_chart package it works well but i don't understand how i can use 'chart_template_in' parameter. I suppose it is for adjust our graphic requirements. But it is not very clear for me. Can you help me ?

Thanks.

Patrick
Doug A. Gault
Denes,

I noticed that the body of the XML_CHART_PKG was wrapped. While I understand that you want to protect your work, but those of us who might want to extend this (or help you extend it) will now find it impossible.

Can you release the un-obfuscated source?

Doug
533828
Hey Denes, and others.

Thanks for the reply and feedback.
I wanted to make sure I wasn't misunderstanding something.
Glad to know I'm not alone on what I was seeing.

But I will do what you suggested and try the package myself and test it out.
I download, test, try and play.
Doug A. Gault
Denes.

I've downloaded and installed everything and created the page as you dictated in your document, and I've tried various queries and chart type combinations but always get the same result.

An empty chart with no data and no series in the legend.

I turned on debugging and in the <chart_data> area I'm only getting <null/> for data values.

Any insight on what might be wrong?

Doug
Denes Kubicek
Doug,

You say it is working, you just see no data. You should download the latest package - I have to admit it has been changed several times. The latest id of the document is:

3009307800339264987

You will see that in the link of the download. That with NULL values is strange. Try
to use this option:

turn_caching_on => 'Y'

and tell me if you get anything then.

I want to complete the package so it works and create a packaged application
demonstrating various techniques for creating charts. After I'm done, I will publish
the code behind.

Denes Kubicek
Denes Kubicek
Hello Patric,

I almost overlooked your post. You are also saying it works for you. So that's a good
news. I am working on the documentation but here is my advice. You shuld have the
latest version of the package - it will change in the next few days / weeks. The templates
you can use in the following way:

Create a template in the xml_chart_templates table. Name it i.e. MY_TEMPLATE1. In
thecolumn template_text put the following:

&lt;draw>
&lt;text transition="slide_up" DELAY="1" duration="2" color="000000" alpha="80"
font="arial" rotation="-90" bold="true" SIZE="20" x="1" y="278" width="200"
height="100" h_align="left" v_align="top">My first text&lt;/text>
&lt;/draw>

This will draw a text in you chart. You may play with it.

In the parameter of the procedure you would put your templates in the following way:

chart_template_in => 'MY_TEMPLATE1,MY_TEMPLATE2,MY_TEMPLATE3'

The reason I have chosen this way are the numerous parameters XML charts allow
one to pass / change. To me, this is the best way to control it. Imagine a procedure
having 500 parameters - would be a nightmare. However, I'm still learning and the whole
thing may change.

Denes Kubicek
Doug A. Gault
I downloaded the version I am using today, but just in case, I downloaded it again and re-installed it.

Same problem.. I also tried the TURN_CACHE_ON option, and no difference..

It's not a big deal.. I can wait until you have a reference implementation up so that I can compare and see what I've mucked up!

Thanks!

Doug
Denes Kubicek
Doug,

I am just curious. Do you see any collections created in the flows schema? They would
be named like CCOLUMN26332061503056641001 - the number is concatenated session_id, app_id and page_id. Column ist the type of the chart.

Denes Kubicek
Doug A. Gault
Yup.. I see the collections, and they have members that equate to the data that I would expect to see... Dunno what's going on.
Denes Kubicek
Can you send me the result of a debug - xml file you generate? To my email address

dkubicek at synventive dot com

Thanks,

Denes Kubicek
Doug A. Gault
Done!
Denes Kubicek
I received the .xml files. Thanks. It looks like it doesn't run the part where it loops for
the data and for the default settings - it does start, since the tags for the data is created.

I have noticed some differences in behaviour depending on the browser.
Which browser / version are you using? Did you import the .csv file into the table?

Also, which version of ApEx are you using?

Tomorrow, I will look into that and I may do some testing / changes. That's realy funny.

Denes Kubicek
1 - 50 Next

Post Details

Added on Nov 14 2022
0 comments
401 views