{"id":19973,"date":"2022-10-20T02:33:04","date_gmt":"2022-10-20T00:33:04","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=19973"},"modified":"2022-10-20T02:33:06","modified_gmt":"2022-10-20T00:33:06","slug":"oracle-cloudworld-2022-day-3-more-sessions-and-meetings","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-cloudworld-2022-day-3-more-sessions-and-meetings\/","title":{"rendered":"Oracle CloudWorld 2022 – Day 3 : More sessions and meetings!"},"content":{"rendered":"\n

Let’s go for my third day in Las Vegas with more Oracle sessions and meetings. Also I was more than surprised this morning to meet for the first time, in the lift of the hotel, Carlos Ortiz, Sr. Principal Product Manager at Oracle, with whom I have been recently in contacts for tomorrow ODA CAB meeting! We could walk together, and discuss ODA subjects! What a coincidence!<\/p>\n\n\n\n\n\n\n\n

Hitchhiker’s Guide for Upgrading to Oracle Database 19c [HOL3999]<\/h2>\n\n\n\n

I had the great chance to be able to participate to a hands-on lab with the great Mike Dietrich, Senior Director, Product Management, at Oracle. I had the opportunity to play with AutoUpgrade in the Oracle Lab. I must really say that, the lab, the exercises were very well prepared and well made. I really appreciated this 1h30 session.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

As Mike said, “Complication is not database upgrade itself but the application (performance problem, aso)”.<\/p>\n\n\n\n

The Lab was setup with application and load. Purpose was to upgrade the database, run application, solve the performance problem and tune the application before giving it back to production.<\/p>\n\n\n\n

Doing more ODA upgrade and manual upgrade I was pleased to have my first try with AutoUpgrade in a CloudWorld session. AutoUpgrade is a tool that automatically upgrades databases. This tool is supporting version 11.2.0.4, 12.1, 12.2, 18, 19 and all architectures including RAC, SE2, EE, CDB, \u2026
Before proceeding it is important to always download last version of AutoUpgrade from MOS Note 2485457.1.<\/p>\n\n\n\n

For AutoUpgrade we first need to prepare a config text file with at least the source and target dbhome and SID of the database to be upgraded.
With the tool we can upgrade multi databases in the same time. Of course, we need to have one upgrade entry in the config text file.
The tool will create a guarantee restore point time or not, change compatible parameter or not, \u2026 several other options according to the configuration we setup.<\/p>\n\n\n\n

Command to run autoupgrade : java -jar autoupgrade.jar -config cdb1.cfg -mode deploy<\/code>
The tool will provide advanced monitoring and logging, and no license is needed.<\/p>\n\n\n\n

Presentation of the lab exercice:<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Starting the lab:<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Let me show you some feedback from my exercise on the lab. So easy to use AutoUpgrade!<\/p>\n\n\n\n

Preparing config file template :<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Moving config file, analyze AutoUpgrade and check the html report:<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Run AutoUpgrade and check status of the upgrade:<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

I would like to once again thanks Mike for this very nice hands-on, practice session, which, as expected, was a great one!<\/p>\n\n\n\n

Meeting with Sanjay Singh Vice President RACPack MAA, Product Development at Oracle Corp<\/h2>\n\n\n\n

I had the great opportunity to have a 30 minutes meeting with Sanjay Singh. Thanks to Hagen Herbst, Consulting Member of Technical Staff at Oracle, to have organised this meeting. We had very nice and interactive discussions about the ODA. I could explain how our customers are using it, what they expect, what challenges we are currently having, what are the top nice functionalities of the ODA, and what we can improve. I will raise the same points in the ODA CAB meeting tomorrow. I will then provide more details about this on my blog tomorrow.<\/p>\n\n\n\n

Protect All Your Databases with Oracle 23c Autonomous Health Framework [LRN1484]<\/h2>\n\n\n\n

I then followed an interesting session about AHF, presented by Bill Burton, Consulting Member of Technical Staff, Oracle.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Bill presented how we can efficiently use Oracle Autonomous Health Framework.<\/p>\n\n\n\n

Oracle Autonomous Health Framework, powered by Machine Learning, will offer following services:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

tfactl diagcollect -srdc dbperf<\/code> command will collect all needed information as ORAchk, OS Watcher, AWR and ADDM information, and more<\/p>\n\n\n\n

tfactl diagcollect -srdc dbperf<\/code> will be used to run a Service Request Data Collection (SRDC), get all information automatically together into a zip file to be uploaded into the Oracle Support SR. No need to manually generate ADDM, identify good and problem periods and gather AWR, get all AWR, ASH, OSWatcher output.<\/p>\n\n\n\n

With tfa we can setup notification with set notificationaddress option.<\/p>\n\n\n\n

tfactl diagcollect -srdc dbrac<\/code> will be used to collect all required diagnostics for the database and the clusterware.<\/p>\n\n\n\n

We studied some real case liked where AHF detected developing problem, or one of the RAC instance went done (With tfactl events from last 1h we can find some logs with instance been stopped unexpectedly).<\/p>\n\n\n\n

Use orachk for preupgrade :<\/strong><\/p>\n\n\n\n