Oracle Grid + RAC Upgrade from 12c to 19c using DBUA

Подписаться 3,3 тыс.

Просмотров 6 тыс.

50% 1

This session provides step-by-step instructions for upgrading Oracle Database and Oracle Grid Infrastructure from release 12.2.0.1 to 19c
Oracle RAC Internals - Real Application Cluster
 The Oracle RAC Architecture
 VIP and SCAN
 VIPs and Networks
 Listeners
 SCAN
 Listeners, SCAN and Services
 Client Connectivity
 Node Membership
 The Interconnect
 Installation in AWS
 Installation and Upgrade - This is covered in this session.
 RAC Administration - This is covered in this session.
#RACArchitecture #RACBasicUnderstanding #OracleRACInternals #RAC #Exadata #Oracle #Database
#database #oracle #rac #upgrade
For more videos on Oracle RAC, please click on the below playlist :
• Oracle RAC
Updates and additional patches may be required for your existing installation before upgrading to Oracle Database 19c and Oracle Grid Infrastructure 19c.
Please click on the below link for documentation regarding the session :
infraxpertzz.com/step-by-step...
1. Overview of Oracle Rac
2. Oracle rac 19c setup part 1 - Steps to create your own virtual machine and set up DNS
3. Oracle rac 19c setup part 2 - Steps to configure Oracle RAC
4. Oracle rac 19c scan name change
5. Oracle rac on aws - Steps to configure Oracle RAC on AWS
6. Adding and removing disk to the disk group in aws
7. Oracle grid + rac upgrade from 12c to 19c
8. Step by step silent Upgrade of oracle rac from 12c to 19c
9. Add and delete a node in oracle rac
10. Step by step set up of dataguard in a heterogeneous OS platform with stand alone primary and Rac standby
The above topics are covered in the below playlist :
Oracle RAC: • Oracle RAC
Apart from these, please find the blog links to the below topics :
1. Steps to fix a corrupted spfile in asm infraxpertzz.com/steps-to-fix...
2. Step by step Grid and Oracle database patch from 19.3 to 19.5 in Oracle RAC 19c
infraxpertzz.com/step-by-step...
3. Fix Opatch : Missing command :fuser Prerequisite CheckSystemCommandsAvailable Failed
infraxpertzz.com/fix-opatch-m...
4. De-install Oracle 19c Grid Infrastructure
infraxpertzz.com/de-install-1...
5. PRVG - 1032 : slewing option “-x” not found on the NTP daemon command line on nodes
infraxpertzz.com/prvg-1032-sl...
6. Roll Forward your Standby Oracle RAC database
infraxpertzz.com/roll-forward...
7. Step by step creation of 2 Node RAC Physical Standby database
infraxpertzz.com/step-by-step...
8. Steps to setup Dataguard with RAC Primary and Standalone Physical Standby
infraxpertzz.com/steps-to-set...
9. Steps to convert 2 Node Physical Standby RAC database to Snapshot Standby
infraxpertzz.com/steps-to-con...
Click on the below link to
1. Check the Laptop used for creating the content
amzn.to/3FLAjMG
2. Microphones used for the recording
amzn.to/3vpH0zh
3. Kingston 8GB RAM
amzn.to/2XhwkpJ
4. For Screen recording and editing
amzn.to/3j89GIg
5. Wireless keyboard and mouse
amzn.to/2Z1dPqn

Опубликовано:

12 июн 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 24

@apurvanand1374 11 месяцев назад

nice and thanks to share this information...

@InfraXpertzz 11 месяцев назад

Glad you liked it. Thanks for the nice feedback

@ziadfawzi 2 года назад

Thank you so much.

@InfraXpertzz 2 года назад

My pleasure that u liked it

@thiruardura Год назад

Very informative, thank you.

@InfraXpertzz Год назад

Glad you liked it 😊

@kirankumar-np7tc 10 месяцев назад

Dont need to install 19c yum packages on both nodes ?

@mohamedkhalifa2049 2 года назад

Thank u so much for this helpful tutorial , i want to ask u if u have any tutorial on how we can read awr reports

@InfraXpertzz 2 года назад

Glad you liked it. Sorry to say but as of now we don't have any tutorials on how to read awr report

@thiruardura Год назад

Can we use this method/steps to upgrade Oracle 12c SE2 RAC to Oracle 19c EE RAC?

@InfraXpertzz Год назад

No sorry. You need to upgrade from se2 to ee separately

@thiruardura Год назад

@@InfraXpertzz DBUA will not upgrade the SE2 RAC DB to 19c EE RAC DB?

@InfraXpertzz Год назад

No it won't. You can give it a try. But it's a totally separate process

@Ayanasaiyad3532 2 года назад

Could you share this document link for download

@InfraXpertzz 2 года назад

This session being upgrade using dbua, no documents have been made. U can refer to the silent installation video, where the blog link has been kept with

@Ayanasaiyad3532 2 года назад

@@InfraXpertzzthanks for reply could you share this silent upgrade doc link or drive link

@InfraXpertzz 2 года назад

You can check all documents in the below link. Requesting you to go through them infraxpertzz.com/oracle-blogs/

@InfraXpertzz 2 года назад

My bad. The upgrade using dbua blog is also present in the below link infraxpertzz.com/step-by-step-upgrade-oracle-rac-grid-infrastructure-and-database-from-12c-to-19c/

@Ayanasaiyad3532 2 года назад

Thanks

@SydneyIndian 3 года назад

I did this upgrade successfully before 3 months. I did dry run for upgrade a day before actual upgrade, it helped me save 3 hours of activity time. As you said issues occur during dry run especially due to a bug services restart during dryrun. 1) to over come that bug we have to apply latest RU patch in 19c grid home before even executing gridsetup.sh for dry run. let me know if you want me to post the metalink document id for same. 2) as soon as u apply latest ru after unzipping grid home, you will face another issue due to ocw bug and u have to apply a patch with bug number 3070425 i guess, post applying both u will be able to run dry run without any issues. Also ensure umask of root is set as 0022 before running rootupgrade.sh and root.sh. i will see full video and add more experience.

@InfraXpertzz 3 года назад

Thanks for the great comments. Please share your experience, which would help both myself and others gain more knowledge

@SydneyIndian 3 года назад

@@InfraXpertzz sure. I had to plan quite extensively. As i ensured that the cluvfy returns successful before grid dry run upgrade, it was simply next,next, finish for me across all steps. I will comment steps and also learnings in this same comment.

@InfraXpertzz 3 года назад

One more bug which is not mentioned in the video, even after notifying for applying patches prior upgrade in the dry run, the dry run was successful. Ideally the dryrun shouldn't be successful until and unless you have applied the prerequisite patches

@SydneyIndian 3 года назад

@@InfraXpertzz you should have patched till jan-2020 proactive bundle patch as per standard requirement. But below two patches are also required to get dry run and actual grid upgrade to run successfully as per plan without any issues. 1) Unzip Grid home and move the unzipped binary to location in /u01 then apply latest RU to the unzipped 19c grid binary home. Follow the metalink article ID:1410202.1 to understand how to apply ru and oneoff patch before running dryrun. Using the command run and apply the latest ru in grid home. This should be done post moving software to location and before dry run. Also ensure inventory backup is available before this step. 2) even after applying latest RU in previous step now you will face another bug related to OCW for grid setup, after applying latest ru on unzipped 19c grid home, older patches will become invisible. Follow the metalink document ID:32568731.8 and apply the one off patch also before dry run to over come this issue. 3) enable sudo access for both grid and db os user and run cluvfy as root with syntax as type sudo and user grid os user name. This should return successful without any warnings at all. If above procedure is successful dry run and actual upgrade will be smooth over all.