No question at this time
DBA Top 10
1 M. Cadot 6600
2 B. Vroman 3400
3 J. Péran 2200
4 A. Kavsek 1400
5 P. Tsongayinwe 900
6 P. Wisse 600
7 T. Boles 400
7 D. Walgude 400
7 D. Johnson 400
10 J. Alcroft 200
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48675
Total active users1328
Act. users last 24h0
Act. users last hour0
Registered user hits last week24
Registered user hits last month452
Go up

upgrade to 19c
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......... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Phuti Tsongayinwe Dec 03, 2021, 10:05
Thanks Team After following this https://suppor...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Phuti Tsongayinwe Dec 03, 2021, 10:48
Hi I don't know if you have registered to Mike...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts 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, 212 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, 212 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
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, 212 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
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, 212 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
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, 211 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