Go up

Next thread:	Oracle11g data guarad failover config
Prev thread:	PL/SQL lock timer event not result of dbms_lock.sleep

Message	Score	Author	Date
Hi Team I am busy doing the upgrade from 12cR2......		Phuti Tsongayinwe	Dec 03, 2021, 09:40
It looks like the issue is linked to this issue.........		Phuti Tsongayinwe	Dec 03, 2021, 10:05
Thanks Team After following this https://suppor......		Phuti Tsongayinwe	Dec 03, 2021, 10:48
Hi I don't know if you have registered to Mike......		Joël Péran	Dec 03, 2021, 10:54
Thanks, Joel I have been reading about the auto......		Phuti Tsongayinwe	Dec 03, 2021, 16:26

Follow up by mail

Click here

---

Subject:	upgrade to 19c
Author:	Phuti Tsongayinwe, South Africa
Date:	Dec 03, 2021, 09:40, 547 days ago
Os info:	solaris 11
Oracle info:	Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Message:	Hi Team I am busy doing the upgrade from 12cR2 (12.2.0.1) to 19c. Now, the preupgrade.jar has been running for 2 hours now. When I check the execPreUpgrade_catCon_catcon_8566.lst I get lots of these lines... next_proc: Checking if process 0 (id = 8602) is available next_proc: Checking if process 0 (id = 8602) is available next_proc: Checking if process 0 (id = 8602) is available next_proc: Checking if process 0 (id = 8602) is available next_proc: Checking if process 0 (id = 8602) is available next_proc: Checking if process 0 (id = 8602) is available next_proc: Checking if process 0 (id = 8602) is available next_proc: Checking if process 0 (id = 8602) is available next_proc: Checking if process 0 (id = 8602) is available next_proc: Checking if process 0 (id = 8602) is available next_proc: Checking if process 0 (id = 8602) is available next_proc: Checking if process 0 (id = 8602) is available next_proc: Checking if process 0 (id = 8602) is available When I check the v$session_longops in the database I can see the below: Gather Table's Index Statistics Gather Table's Index Statistics Gather Table's Index Statistics Gather Table's Index Statistics Gather Table's Index Statistics Gather Table's Index Statistics Gather Table's Index Statistics I expect the preupgrade.jar to be faster. Please help, what should I do? Thanks in advance...
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: upgrade to 19c
Author:	Phuti Tsongayinwe, South Africa
Date:	Dec 03, 2021, 10:05, 547 days ago
Score:
Message:	It looks like the issue is linked to this issue... https://support.oracle.com/knowledge/Oracle%20Database%20Products/2637848_1.html I initial checked the v$session_longops on the APP PDB instead of the CDB. Now I can see the below in the CDB... Table Scan: AUDSYS.CLI_SWP$aad41284$1$1: 195931 out of 195931 Blocks done Table Scan: AUDSYS.CLI_SWP$aad41284$1$1: 195931 out of 195931 Blocks done Table Scan: AUDSYS.CLI_SWP$aad41284$1$1: 195931 out of 195931 Blocks done Table Scan: AUDSYS.CLI_SWP$aad41284$1$1: 195931 out of 195931 Blocks done Table Scan: AUDSYS.CLI_SWP$aad41284$1$1: 195931 out of 195931 Blocks done Table Scan: AUDSYS.CLI_SWP$aad41284$1$1: 195931 out of 195931 Blocks done Table Scan: AUDSYS.CLI_SWP$aad41284$1$1: 195931 out of 195931 Blocks done Table Scan: AUDSYS.CLI_SWP$aad41284$1$1: 195931 out of 195931 Blocks done Table Scan: AUDSYS.CLI_SWP$aad41284$1$1: 195931 out of 195931 Blocks done Table Scan: AUDSYS.CLI_SWP$aad41284$1$1: 195931 out of 195931 Blocks done I will follow the steps in the doc and see if that resolves the issue. Thanks, Team.
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: upgrade to 19c
Author:	Phuti Tsongayinwe, South Africa
Date:	Dec 03, 2021, 10:48, 547 days ago
Score:
Message:	Thanks Team After following this https://support.oracle.com/knowledge/Oracle%20Database%20Products/2637848_1.html and clearing of records from SYS.AUD$ table the preupgrade.jar run fine. Thanks !!!
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: upgrade to 19c
Author:	Joël Péran, France
Date:	Dec 03, 2021, 10:54, 547 days ago
Score:
Message:	Hi I don't know if you have registered to Mike Dietrich's blog about database upgrade but you should : it's really a gold mine in which I have found many many many hints about upgrading. May be you should (specially if you are not using Windows and Oracle :) ... which I am (don't have the choice)) use the autoupgrade tool to upgrade your db ? Regards, Joel
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: upgrade to 19c
Author:	Phuti Tsongayinwe, South Africa
Date:	Dec 03, 2021, 16:26, 546 days ago
Message:	Thanks, Joel I have been reading about the autoupgrade tool from Mike's Upgrade your Database - NOW! blog. It is amazing, most of the issues get handled by this amazing tool and he emphasized that it is now the recommended method for doing upgrades. Thanks again for your reply. Much appreciated !!! Regards TP
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here