Explore Oracle's Database Upgrade IX 12.1.0.1 update 12.1.0.2

Explore Oracle's database Upgrade nine

12.1.0.1 Update 12.1.0.2

First, check the current database version and System Information

[[email protected] ~]$ lsb_release-alsb Version:: Core-4.0-amd64:core-4.0-ia32:core-4.0-noarch: GRAPHICS-4.0-AMD64:GRAPHICS-4.0-IA32:GRAPHICS-4.0-NOARCH:PRINTING-4.0-AMD64:PRINTING-4.0-IA32: Printing-4.0-noarchdistributor ID:RedHatEnterpriseServerDescription:Red Hat Enterprise Linux Server release 5.8 ( Tikanga) release:5.8codename:tikanga[[email protected] ~]$ uname-alinux db01 2.6.18-308.el5 #1 SMP Fri Jan 27 17:17 : EST x86_64 x86_64 x86_64 gnu/li[[email protected] dbdata]$ df-hfilesystem Size used Avail use% Mounted on/d Ev/mapper/volgroup00-logvol00 53G 26G 24G 52%//dev/sda1 99M 13M 82M 14%/boottmpfs 4.0G 1.1G 3.0G 2 6%/dev/shmsql> SELECT * from V$version; BANNER con_id------------------------------------------------------------------------------------------Oracle Database 12c Enterprise Edition release 12.1.0.1.0-64bit Production 0pl/sql release 12.1.0.1.0-production 0CORE 12.1.0 .1.0 Production 0TNS for linux:version 12.1.0.1.0-production 0NLSRTL version 12.1.0.1.0-production 0sql> col comp_name format a40sql> Col Version format a13sql > Col Control format a8sql> col status format a15sql> set line 300sql> set pagesize 800sql> Select Comp_nam E,version,control,status from Dba_server_registry; Comp_name VERSION CONTROL STATUS----------------------------------------------------------------------------  Oracle Database Vault 12.1.0.1.0 sys validoracle application Express 4.2.0.00.27 sys validoracle Label Security 12.1.0.1.0 SYS validspatial 12.1.0.1.0 sys validoracle Multimedia 12.1.0.1.0 sys validoracle Text 12.1.0.1.0 sys validoracle WORKSPA Ce Manager 12.1.0.1.0 sys validoracle XML database 12.1.0.1.0 sys validoracle database Catalog views 12.1.0.1.0 sys Valido Racle Database Packages and Types 12.1.0.1.0 sys validjserver JAVA Virtual machine 12.1.0.1.0 SYS validoracle XDK 12.1.0.1 .0 sys validoracle Database Java Packages 12.1.0.1.0 sys validolap Analytic Workspace 12.1.0.1.0 sys validoRacle OLAP API 12.1.0.1.0 sys validoracle Real application Clusters 12.1.0.1.0 sys OPTION OFF16 rows selected. 

Second, remove EM

[[email protected] ~]$ emctl stop dbconsolesql> @ $ORACLE _home/rdbms/admin/emremove.sqlold 69:if (Upper (' & LOGGING ') = ' VERBOSE ') new 69:if (Upper (' VERBOSE ') = ' VERBOSE ') PL/SQL procedure successfully completed. [Email protected] ~]$ rm–rf $ORACLE _home/$HOSTNAME [[email protected] ~]$ RM–RF $ORACLE _home/oc4j/j2ee/oc4j_dbconsole_ *

Third, back up the database

Rman> BACKUP database plus archivelog delete input format '/dbbackup/phycal/full_%u.bak '; Starting backup at 02-dec-14current log archivedusing channel Ora_disk_1channel ora_disk_1:starting archived log backup S Etchannel ora_disk_1:specifying archived log (s) in Backup SetInput archived log thread=1 sequence=48 recid=1 STAMP=865232 107input archived log thread=1 sequence=49 recid=2 stamp=865232108input archived log thread=1 sequence=50 RECID=3 STAMP=86 5232110input archived log thread=1 sequence=51 recid=4 stamp=865232124input archived log thread=1 sequence=52 RECID=5 STAM  P=865232126input archived log thread=1 sequence=53 recid=6 stamp=865232129input archived log thread=1 sequence=54 RECID=7 Stamp=865232130input archived log thread=1 sequence=55 recid=8 stamp=865232199input archived log thread=1 sequence=56 REC id=9 stamp=865232199input archived log thread=1 sequence=57 recid=10 stamp=865232203input archived log thread=1 sequence= recid=11 stamp=865232203input archived Log thread=1 sequence=59 recid=12 stamp=865232203input archived log thread=1 sequence=60 recid=13 stamp=865232203input archived log thr Ead=1 sequence=61 recid=14 stamp=865232209input archived log thread=1 sequence=62 recid=15 STAMP=865232380channel ORA_ Disk_1:starting piece 1 at 02-dec-14channel ora_disk_1:finished piece 1 at 02-dec-14piece handle=/dbbackup/phycal/full_0 5pp4pfs_1_1.bak tag=tag20141202t061940 Comment=nonechannel ora_disk_1:backup set complete, elapsed time: 00:00:01channel ora_disk_1:deleting archived log (s) archived log file name=/dbdata/fast_recovery_area/woo12c/ Archivelog/2014_12_02/o1_mf_1_48_b7st3cbs_.arc recid=1 stamp=865232107archived log file Name=/DBData/fast_recovery_ Area/woo12c/archivelog/2014_12_02/o1_mf_1_49_b7st3d69_.arc recid=2 stamp=865232108archived log file name=/DBData/ Fast_recovery_area/woo12c/archivelog/2014_12_02/o1_mf_1_50_b7st3fwr_.arc recid=3 STAMP=865232110archived log file Name=/dbdata/fast_recovery_area/woo12c/archivelog/2014_12_02/o1_mf_1_51_b7st3wto_.Arc recid=4 stamp=865232124archived log file name=/dbdata/fast_recovery_area/woo12c/archivelog/2014_12_02/o1_mf_1_ 52_b7st3ydw_.arc recid=5 stamp=865232126archived log file Name=/dbdata/fast_recovery_area/woo12c/archivelog/2014_12 _02/o1_mf_1_53_b7st41h9_.arc recid=6 stamp=865232129archived log file name=/dbdata/fast_recovery_area/woo12c/ Archivelog/2014_12_02/o1_mf_1_54_b7st428n_.arc recid=7 stamp=865232130archived log file Name=/DBData/fast_recovery_ Area/woo12c/archivelog/2014_12_02/o1_mf_1_55_b7st66z1_.arc recid=8 stamp=865232199archived log file name=/DBData/ Fast_recovery_area/woo12c/archivelog/2014_12_02/o1_mf_1_56_b7st67ox_.arc recid=9 STAMP=865232199archived log file Name=/dbdata/fast_recovery_area/woo12c/archivelog/2014_12_02/o1_mf_1_57_b7st6c1b_.arc RECID=10 STAMP= 865232203archived log File Name=/dbdata/fast_recovery_area/woo12c/archivelog/2014_12_02/o1_mf_1_58_b7st6c22_.arc recid=11 stamp=865232203archived log File name=/dbdata/fast_recovery_area/woo12c/archivelog/2014_12_02/o1_Mf_1_59_b7st6c6y_.arc recid=12 stamp=865232203archived log file name=/dbdata/fast_recovery_area/woo12c/archivelog/ 2014_12_02/o1_mf_1_60_b7st6c7o_.arc recid=13 stamp=865232203archived log file name=/dbdata/fast_recovery_area/ Woo12c/archivelog/2014_12_02/o1_mf_1_61_b7st6kq8_.arc recid=14 stamp=865232209archived log file Name=/DBData/fast_ Recovery_area/woo12c/archivelog/2014_12_02/o1_mf_1_62_b7stcwmv_.arc recid=15 STAMP=865232380Finished Backup at 02- Dec-14starting backup at 02-dec-14using Channel Ora_disk_1channel ora_disk_1:starting full datafile backup Setchannel ORA _disk_1:specifying DataFile (s) in Backup setinput datafile file number=00004 name=/dbdata/woo12c/datafile/o1_mf_ Undotbs1_b7gh653v_.dbfinput datafile file number=00001 name=/dbdata/woo12c/datafile/o1_mf_system_b7gh4dtv_. Dbfinput datafile file number=00003 name=/dbdata/woo12c/datafile/o1_mf_sysaux_b7gh21p2_.dbfinput datafile file number =00006 Name=/dbdata/woo12c/datafile/o1_mf_users_b7gh6409_.dbfchannel ora_disk_1:starting Piece 1 at 02-dec-14channel ora_disk_1:finished piece 1 at 02-dec-14piece handle=/dbdata/fast_recovery_area/woo12c/back UPSET/2014_12_02/O1_MF_NNNDF_TAG20141202T061942_B7STCYYX_.BKP tag=tag20141202t061942 Comment=NONEchannel ORA_DISK _1:backup set complete, elapsed Time:00:01:36channel ora_disk_1:starting full datafile backup Setchannel ora_disk_1:sp Ecifying DataFile (s) in Backup setinput datafile file number=00014 name=/dbdata/woo12c/ 0847d2a3397b02b0e0533307a8c077e9/datafile/o1_mf_sysaux_b7gknfyd_.dbfinput datafile file number=00013 name=/DBData/ Woo12c/0847d2a3397b02b0e0533307a8c077e9/datafile/o1_mf_system_b7gknfmp_.dbfinput datafile file number=00015 name=/ Dbdata/woo12c/0847d2a3397b02b0e0533307a8c077e9/datafile/o1_mf_users_b7gkngh6_.dbfchannel ora_disk_1:starting Piece 1 at 02-dec-14channel ora_disk_1:finished piece 1 at 02-dec-14piece handle=/dbdata/fast_recovery_area/woo12c/ 0847D2A3397B02B0E0533307A8C077E9/BACKUPSET/2014_12_02/O1_MF_NNNDF_TAG20141202T061942_B7STGZDO_.BKP tag=tag20141202t061942 Comment=nonechannel ora_disk_1:backup set complete, elapsed Time:00:01:55channel ora_disk_1: Starting full datafile backup Setchannel ora_disk_1:specifying datafile (s) in Backup setinput datafile file number=00009 Name=/dbdata/woo12c/08d98ea3271835f9e0533307a8c068ee/datafile/o1_mf_sysaux_b7ghrvm2_.dbfinput datafile File number=00008 Name=/dbdata/woo12c/08d98ea3271835f9e0533307a8c068ee/datafile/o1_mf_system_b7ghrvnw_.dbfinput datafile file number=00010 name=/dbdata/woo12c/08d98ea3271835f9e0533307a8c068ee/datafile/o1_mf_users_b7ght9rv_. Dbfchannel ora_disk_1:starting piece 1 at 02-dec-14channel ora_disk_1:finished piece 1 at 02-dec-14piece handle=/DBData/ fast_recovery_area/woo12c/08d98ea3271835f9e0533307a8c068ee/backupset/2014_12_02/o1_mf_nnndf_tag20141202t061942 _B7STLLL8_.BKP tag=tag20141202t061942 Comment=nonechannel ora_disk_1:backup set complete, elapsed time: 00:00:55channel ora_disk_1:starting full datafile backup Setchannel ora_disk_1:specifying datafile (s) in Backup setinput datafile file number=00007 name=/dbdata/woo12c/datafile/o1_mf_sysaux_b7gh7gjq_.dbfinput datafile File number=00005 Name=/dbdata/woo12c/datafile/o1_mf_system_b7gh7gkl_.dbfchannel ora_disk_1:starting piece 1 at 02- Dec-14channel ora_disk_1:finished piece 1 at 02-dec-14piece handle=/dbdata/fast_recovery_area/woo12c/ 08D970F59616336FE0533307A8C03C35/BACKUPSET/2014_12_02/O1_MF_NNNDF_TAG20141202T061942_B7STN9LY_.BKP tag= tag20141202t061942 Comment=nonechannel ora_disk_1:backup set complete, elapsed time:00:01:05finished backup at 02-DEC-1 4Starting backup at 02-dec-14current log archivedusing channel Ora_disk_1channel ora_disk_1:starting archived log backup Setchannel ora_disk_1:specifying archived log (s) in Backup SetInput archived log thread=1 sequence=63 recid=16 STAMP=8652 32715channel ora_disk_1:starting piece 1 at 02-dec-14channel ora_disk_1:finished piece 1 at 02-dec-14piece Handle=/dbbac Kup/phycal/full_0app4pqb_1_1.bak tag=tag20141202t062515 Comment=nonechannEl Ora_disk_1:backup set complete, elapsed Time:00:00:01channel ora_disk_1:deleting archived log (s) archived log file Na Me=/dbdata/fast_recovery_area/woo12c/archivelog/2014_12_02/o1_mf_1_63_b7stpbxz_.arc RECID=16 STAMP= 865232715Finished backup at 02-dec-14starting Control File and SPFILE autobackup at 02-dec-14piece handle=/dbdata/fast_re COVERY_AREA/WOO12C/AUTOBACKUP/2014_12_02/O1_MF_S_865232716_B7STPFTO_.BKP comment=nonefinished Control File and SPFILE Autobackup at 02-dec-14

Iv. upload unzip 12.1.0.2 mounting media, and unzip

[[email protected] ~]$ ll p17694377_121020*-rw-r--r--1 Oracle oinstall 1673517582 DEC 2 05:38 p17694377_121020_linux-x86- 64_1of8.zip-rw-r--r--1 Oracle oinstall 1014527110 Nov 02:44 p17694377_121020_linux-x86-64_2of8.zip[[email protected ] ~]$ unzip P17694377_121020_linux-x86-64_1of8.zip[[email protected] ~]$ unzip P17694377_121020_linux-x86-64_2of8.zip

V. Create a software catalog for user-installed 12.1.0.2

[Email protected] ~]$ cd/dbsoft/product/[[email protected] product]$ ls12.1.0[[email protected] product]$ mkdir-p 12.1. 0.2/db_1[[email protected] product]$ lltotal 8drwxr-xr-x 3 Oracle oinstall 4096 Nov 05:39 12.1.0drwxr-xr-x 3 Oracle Oin Stall 4096 Dec 2 07:57 12.1.0.2

Six, start the installation:

Vii. execute the root.sh script after the software installation is complete

[Email protected] ~]#/dbsoft/product/12.1.0.2/db_1/root.shperforming root user operation. The following environment variables is set as:    oracle_owner= ORACLE    oracle_home=  /dbsoft/product/ 12.1.0.2/db_1 Enter The full pathname of the local bin directory: [/usr/local/bin]:the contents of "Dbhome" has not Chang Ed. No need to overwrite. The file "Oraenv" already exists in/usr/local/bin.  Overwrite it? (y/n) [n]: y   Copying oraenv to/usr/local/bin ... The contents of "coraenv" has not changed. No need to overwrite. Entries'll be added to The/etc/oratab file as needed bydatabase Configuration Assistant when a database is Createdfinis Hed running generic part of root script. Now product-specific root actions would be performed. [Email protected] ~]#

Eight, the upgrade installation has been completed.

Nine. Check the database version after completion:

Sql> set line 300sql> set pagesize 1000sql> r   1* select * from V$versionbanner con_id------------------------ ------------------------------------------------------------------Oracle Database 12c Enterprise Edition Release 12.1.0.2.0-64bit Production 0pl/sql Release 12.1.0.2.0-production 0CORE 12.1.0.2.0 Production 0TNS for Linux:version 12.1.0.2.0-production 0NLSRTL Version 12.1.0.2.0-production 0

X. Check each component version:

Sql> select Comp_name,version,control,status from Dba_server_registry; Comp_name VERSION CONTROL STATUS----------------------------------------------------------------------------  Oracle Database Vault 12.1.0.2.0 sys validoracle application Express 4.2.5.00.08 sys validoracle Label Security 12.1.0.2.0 SYS validspatial 12.1.0.2.0 sys validoracle Multimedia 12.1.0.2.0 sys validoracle Text 12.1.0.2.0 sys validoracle WORKSPA Ce Manager 12.1.0.2.0 sys validoracle XML database 12.1.0.2.0 sys validoracle database Catalog views 12.1.0.2.0 sys Valido Racle Database Packages and Types 12.1.0.2.0 sys validjserver JAVA Virtual machine 12.1.0.2.0 SYS validoracle XDK 12.1.0.2 .0 sys validoracle Database Java Packages 12.1.0.2.0 sys validolap Analytic Workspace 12.1.0.2.0 SYS validoracle OLAP API 12.1.0.2.0 sys validoracle Real application Clusters 12.1.0.2.0 SYS OPTION OFF16 rows selected.

XI. Check the database invalidation object, is not invalid object, if any, perform utlrcmp.sql recompile

Sql> Select owner, object_name, object_type, status from Dba_objects where status=\ ' invalid\ ' ORDER by 1, 2,3;no rows s Electedsql>

Xi. Open All PDBs, and view PDBs status

Sql> show PDBs     con_id con_name OPEN MODE RESTRICTED---------------------------------------------------------- --         2 pdb$seed READ only NO         3 PDB01 mounted         4 woo_ora11g mountedsql> alter pluggable database all open; Pluggable database altered. Sql> show PDBs;    con_id con_name OPEN MODE RESTRICTED------------------------------------------------------------         2 pdb$seed READ Only no         3 PDB01 Read Write no         4 woo_ora11g Read Write No

Explore Oracle's Database Upgrade IX 12.1.0.1 update 12.1.0.2