No question at this time
DBA Top 10
1 M. Cadot 5800
2 B. Vroman 3800
3 J. Péran 2200
4 A. Kavsek 1400
5 P. Tsongayinwe 800
6 D. Johnson 700
7 T. Boles 600
8 D. Walgude 400
9 J. Alcroft 200
9 S. Spb 200
9 P. Wisse 200
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48667
Total active users1333
Act. users last 24h2
Act. users last hour1
Registered user hits last week22
Registered user hits last month182
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, 173 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, 173 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, 173 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, 173 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, 173 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