Hi all
This my first post and was wondering if you could help/advice on following please:-
We are planning to upgrade from 10.6 to 11.5.
Note that recently mysql certs had expired and but were updated manually via IBM support engineer
Plan is upgrade to 11.3 then 11.5 as I believe we cant go straight to 11.5-
Apply health check patch 10.0p9998.
Archive and purge system data.
Create a system backup. Include both your data and configuration files. ------ How do we backup config .files?
Apply upgrade patch "SqlGuard-10.0p11002_Upgrade_to_Version_11.3_Apr_2021"
Apply health check patch 11.0p9997.
Apply the latest version 11 GPU to upgrade from 11.3 to 11.5
"SqlGuard_11.0p500_GPU_Sep-2022-V11.5"
Apply latest bundle for 11.5
"SqlGuard_11.0p525_Bundle_May-18-2023"
Queries :-
(1)The 12c and 11g Oracle databases we monitor resides on RHEL 6 . What agents on this server do we need to update/how do I find this out?. I was not involved with the installation and have no document to refer to.
(2)How do I find the correct agents/versions that need downloading and installing on the database server?
(3)Not sure if we are using sniffer. How do you find out if needed/where does it sit?, what version we currently have ?
(4a)Read me for "SqlGuard-10.0p11002_Upgrade_to_Version_11.3_Apr_2021" says that I must also apply 11.0p370 or later after the upgrade because of the certs? Why is that when they are current e.g. readme says make sure mysql certs need to be updated prior to applying the patch?
(4b)If required can "SqlGuard_11.0p500_GPU_Sep-2022-V11.5" be applied INSTEAD of 11.0p370?
(5)Are there any good videos/training material available for upgrades of this nature
(6)Anything else I need to be aware of?
Apologies for all the questions , just want to make sure I have all aspects covered
Thanking you in advance
------------------------------
Mohammed azher khan
------------------------------