Тёмный

Oracle Database 12c to 19c Upgrade Manually on Linux 

Database Guy
Подписаться 6 тыс.
Просмотров 4,3 тыс.
50% 1

Step by Step upgrade of Oracle Database 12c to 19c Upgrade Manually on Linux
1. Source Database - 12.2.0.1 (12cR2)
2. Target Database - 19.0.0 (19c)
3. Red Hat Linux 7.8
4. Virtual Box 7.6
Timeline:
00:00 Introduction
00:12 Steps Overview
03:30 Softwares Used
03:50 Install Oracle 19c
08:50 Pre-Upgrade - Recompile and Gather Stats
10:28 Configure FRA, take backup and create restore point
16:50 Preupgrade.jar script
24:16 Perform Upgrade
36:20 Modify /etc/oratab
36:50 Start Upgraded 19c Database
38:02 Upgrade Timezone
41:54 Run Postupgrade fixup
42:35 Validate components using DBA_REGISTRY
43:00 Drop Flashback Restore Point
44:20 Upgrade Database Compatible Parameter
45:32 Recompile Invalid Objects and Gather Stats
46:30 Start Oracle 19c Listener
48:00 Test Remote Connectivity
48:50 Ending Notes

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

 

21 июл 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 18   
@itsmeyoussef
@itsmeyoussef 10 месяцев назад
good video and very clear explanation
@rameshbalraj
@rameshbalraj Год назад
Nice Video, Could you please share the document which you are explaining the upgrade step by step, this would be very helpful to get this done successfully.
@elevenkings5486
@elevenkings5486 9 месяцев назад
Great Job Man.
@shashiranjan06cse04
@shashiranjan06cse04 Год назад
Nice Video.. If possible please put steps used in video in video description part so that it will be complete for anyone wants to follow this video for their upgrade .
@Actions_Only
@Actions_Only Год назад
Thank you so much bro...
@Actions_Only
@Actions_Only 10 месяцев назад
Hi brother...i hope ur doing good... 1. Upgrade failure while doing upgrade. 2. Upgrade successfully completed but customer required after 3 hrs..back to old version. 3. Performance tuning. Please upload these videos. Thank you.
@alexbrown5968
@alexbrown5968 8 месяцев назад
Hello, thanks for the super Video. If the Video-Documentation with the Scripts ist also available for the share?
@dsgamingfreefire6392
@dsgamingfreefire6392 Год назад
Pls give me the suggestion I am continuously trying to install but get some error
@yassersayed5009
@yassersayed5009 2 месяца назад
Could you share the doc steps that been used in the tutorial?
@GauravSingh-bp8nw
@GauravSingh-bp8nw 8 месяцев назад
so simple, Thnaks. doubt: 1)execution of DBMS.STATS, it is executed on 12c software/ or 19c software? 2) what if you would have upgrade the db on separate machine/server, then would it require to run DBMS.STAT package
@dsgamingfreefire6392
@dsgamingfreefire6392 Год назад
I have one doubt bro
@lratsoma
@lratsoma 4 месяца назад
Hi i am getting an error running the preupgrade command "ORA-04045: errors during recompilation/revalidation of SYS.DBA_REGISTRY_SQLPATCH"
@DB2_Oracle
@DB2_Oracle 4 месяца назад
This is an Internal Bug. Are you doing on PDBs?
@lratsoma
@lratsoma 4 месяца назад
It is not..@@DB2_Oracle
@renatovw
@renatovw 9 месяцев назад
E o txt pra nóis?
@dsgamingfreefire6392
@dsgamingfreefire6392 Год назад
How to install Oracle Database 19c from OL9 os
@DB2_Oracle
@DB2_Oracle Год назад
Oracle 19c is not supported on OL9. Use OL7.
@dsgamingfreefire6392
@dsgamingfreefire6392 Год назад
Thank you sir
Далее
Oracle 12c to 19c upgrade using AutoUpgrade Method
1:02:22
Oracle switchover using Data Guard broker(dgmgrl)
10:52
How NVIDIA just beat every other tech company
9:20
Просмотров 1,1 млн
How to UPGRADE ORACLE 12c to 19c using RMAN Backup
8:39