Install perl-TermReadKey-2.30-4.el5.x86_64.rpm
rpm –Uvh
perl-TermReadKey-2.30-4.el5.x86_64.rpm
Change compatible for the ASM diskgroup where your
database is belonged to
alter diskgroup DBA_DATA501 set
attribute 'compatible.asm'='12.1.0.1.0';
alter diskgroup DBA_DATA501 set attribute
'compatible.rdbms'='11.2.0.0.0';
Copy the parameter file to 12.1.0.1 Oracle home
cp init.ora
/apps/oracle/product/12.1.0.1/racdb/dbs/
Database Upgrade
alter system set
cluster_database=FALSE scope=spfile sid=’*’;
startup upgrade
cd $ORACLE_HOME/rdbms/admin
$ORACLE_HOME/perl/bin/perl
catctl.pl -n 6 -l
$ORACLE_HOME/diagnostics catupgrd.sql
There are 56 phases.
Running with parallel 6
Using
6 processes.
Serial Phase #: 0 Files: 1 Time: 327s
Serial Phase #: 1 Files: 3 Time: 105s
Restart Phase #: 2 Files: 1 Time: 0s
Parallel
Phase #: 3 Files: 18 Time: 22s
Restart Phase #: 4 Files: 1 Time: 1s
Serial Phase #: 5 Files: 5 Time: 43s
Serial Phase #: 6 Files: 1 Time: 24s
Serial Phase #: 7 Files: 3 Time: 15s
Restart Phase #: 8 Files: 1 Time: 0s
Parallel
Phase #: 9 Files: 60 Time: 58s
Restart Phase #:10 Files: 1 Time: 1s
Serial Phase #:11 Files: 1 Time: 30s
Restart Phase #:12 Files: 1 Time: 0s
Parallel
Phase #:13 Files: 199 Time: 38s
Restart Phase #:14 Files: 1 Time: 0s
Serial Phase #:15 Files: 3 Time: 1s
Restart Phase #:16 Files: 1 Time: 0s
Parallel
Phase #:17 Files: 33 Time: 44s
Restart Phase #:18 Files: 1 Time: 0s
Serial Phase #:19 Files: 3 Time: 11s
Restart Phase #:20 Files: 1 Time: 0s
Parallel
Phase #:21 Files: 23 Time: 144s
Restart Phase #:22 Files: 1 Time: 0s
Parallel
Phase #:23 Files: 11 Time: 78s
Restart Phase #:24 Files: 1 Time: 1s
Serial Phase #:25 Files: 1 Time: 81s
Restart Phase #:26 Files: 1 Time: 0s
Parallel
Phase #:27 Files: 0 Time: 0s
Serial Phase #:28 Files: 1 Time: 0s
Parallel
Phase #:29 Files: 130 Time: 8s
Serial Phase #:30 Files: 1 Time: 0s
Restart Phase #:31 Files: 1 Time: 0s
Serial Phase #:32 Files: 1 Time: 0s
Parallel
Phase #:33 Files: 122 Time: 11s
Serial Phase #:34 Files: 1 Time: 0s
Restart Phase #:35 Files: 1 Time: 0s
Serial Phase #:36 Files: 4 Time: 100s
Restart Phase #:37 Files: 1 Time: 0s
Parallel
Phase #:38 Files: 13 Time: 101s
Restart Phase #:39 Files: 1 Time: 0s
Parallel
Phase #:40 Files: 10 Time: 15s
Restart Phase #:41 Files: 1 Time: 0s
Serial Phase #:42 Files: 1 Time: 12s
Restart Phase #:43 Files: 1 Time: 0s
Serial Phase #:44 Files: 1 Time: 9s
Serial Phase #:45 Files: 1 Time: 0s
Restart Phase #:46 Files: 1 Time: 1s
Serial Phase #:47 Files: 2 Time: 408s
Restart Phase #:48 Files: 1 Time: 1s
Serial Phase #:49 Files: 2 Time: 560s
Restart Phase #:50 Files: 1 Time: 1s
Serial Phase #:51 Files: 2 Time: 2950s
Restart Phase #:52 Files: 1 Time: 0s
Serial Phase #:53 Files: 1 Time: 2s
Serial Phase #:54 Files: 1 Time: 296s
Serial Phase #:55 Files: 1 Time: 509s
Serial Phase #:56 Files: 1 Time: 34s
Grand
Total Time: 6042s
Upgrade to the new Oracle home in the cluster
srvctl upgrade database -d DBA12C
-o /apps/oracle/product/12.1.0.1/racdb
alter system set
cluster_database=TRUE scope=spfile sid=’*’;
startup
@utlu121s.sql
@catuppst.sql
@utlrp.sql
No comments:
Post a Comment