Thursday, December 21, 2017

Database Upgrade from 11204 to 12102 Using DBUA

Hai, this article will illustrate you how to upgrade your oracle database from 11204 to 12102 on linux Platform using dbua.
List of Topics (Linux, Database, RAC, EBS)

Assumptions:
11g ORACLE_HOME:  /u01/app/oracle/product/11.2.0/dbhome_1
12c ORACLE_HOME:  /u01/app/oracle/product/12.1.0/dbhome_1


Assumptions:
Machine
IP Address
DB Name
SID
Listener
RAC1
192.168.1.11
DELL
DELL
DELL

Linux Machine Details:
[root@rac1 ~]#
[root@rac1 ~]# lsb_release -a
LSB 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-noarch
Distributor ID: EnterpriseEnterpriseServer
Description:    Enterprise Linux Enterprise Linux Server release 5.7 (Carthage)
Release:        5.7
Codename:       Carthage
[root@rac1 ~]#
[root@rac1 ~]# arch
x86_64
[root@rac1 ~]#
[root@rac1 ~]# cat /etc/oratab
#



# This file is used by ORACLE utilities.  It is created by root.sh
# and updated by either Database Configuration Assistant while creating
# a database or ASM Configuration Assistant while creating ASM instance.

# A colon, ':', is used as the field terminator.  A new line terminates
# the entry.  Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
#   $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively.  The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#

DELL:/u01/app/oracle/product/11.2.0/dbhome_1:N
[root@rac1 ~]#
[root@rac1 ~]# ps -ef | grep pmon
oracle   10403     1  0 08:36 ?        00:00:00 ora_pmon_DELL
root     10862  4501  0 08:41 pts/1    00:00:00 grep pmon
[root@rac1 ~]#

Oracle Database (DELL) details:
[root@rac1 ~]#
[root@rac1 ~]# su - oracle
[oracle@rac1 ~]$ . dell.env
[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 21 12:30:50 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>


SQL> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/app/oracle/product/11.2.0
                                                 /dbhome_1/dbs/spfileDELL.ora
SQL>
SQL> select NAME, OPEN_MODE, PLATFORM_NAME from v$database;

NAME      OPEN_MODE            PLATFORM_NAME
--------- -------------------- -------------------------------
DELL      READ WRITE           Linux x86 64-bit

SQL>

Components Validity Check
SQL>
SQL> col COMP_NAME for a38
SQL> col VERSION for a15
SQL> select COMP_NAME,VERSION,STATUS from dba_registry;

COMP_NAME                              VERSION         STATUS
-------------------------------------- --------------- -----------
OWB                                    11.2.0.4.0      VALID
Oracle Application Express             3.2.1.00.12     VALID
Oracle Enterprise Manager              11.2.0.4.0      VALID
OLAP Catalog                           11.2.0.4.0      VALID
Spatial                                11.2.0.4.0      VALID
Oracle Multimedia                      11.2.0.4.0      VALID
Oracle XML Database                    11.2.0.4.0      VALID
Oracle Text                            11.2.0.4.0      VALID
Oracle Expression Filter               11.2.0.4.0      VALID
Oracle Rules Manager                   11.2.0.4.0      VALID
Oracle Workspace Manager               11.2.0.4.0      VALID

COMP_NAME                              VERSION         STATUS
-------------------------------------- --------------- -----------
Oracle Database Catalog Views          11.2.0.4.0      VALID
Oracle Database Packages and Types     11.2.0.4.0      VALID
JServer JAVA Virtual Machine           11.2.0.4.0      VALID
Oracle XDK                             11.2.0.4.0      VALID
Oracle Database Java Packages          11.2.0.4.0      VALID
OLAP Analytic Workspace                11.2.0.4.0      VALID
Oracle OLAP API                        11.2.0.4.0      VALID

18 rows selected.

SQL>
SQL>
SQL> select INSTANCE_NAME, VERSION from v$instance;

INSTANCE_NAME    VERSION
---------------- ---------------
DELL             11.2.0.4.0

SQL>
SQL>
SQL>
SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE    11.2.0.4.0      Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

SQL>
SQL>
SQL>
SQL> col PRODUCT for a20;
SQL> col version for a12;
SQL> col STATUS for a20;
SQL> select * from product_component_version;

PRODUCT              VERSION      STATUS
-------------------- ------------ --------------------
NLSRTL               11.2.0.4.0   Production
Oracle Database 11g  11.2.0.4.0   64bit Production
Enterprise Edition

PL/SQL               11.2.0.4.0   Production
TNS for Linux:       11.2.0.4.0   Production

SQL>
SQL> col platform_name format a35;
SQL> select platform_id, platform_name from v$database;

PLATFORM_ID PLATFORM_NAME
----------- -----------------------------------
         13 Linux x86 64-bit

SQL>
SQL>
SQL> show parameter compatible

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
compatible                           string      11.2.0.4.0
SQL>
SQL>

Archive Mode Status
SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch
Oldest online log sequence     1
Current log sequence           2
SQL>

C – R – D Files
SQL> select name,controlfile_type,open_mode from v$database;

NAME      CONTROL OPEN_MODE
--------- ------- --------------------
DELL      CURRENT READ WRITE

SQL>SQL>
SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/DELL/control01.ctl
/u01/app/oracle/DELL/control02.ctl

SQL>
SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/u01/app/oracle/DELL/redo03.log
/u01/app/oracle/DELL/redo02.log
/u01/app/oracle/DELL/redo01.log


SQL>
SQL> col tablespace_name for a20
SQL> select tablespace_name,file_name from dba_data_files;

TABLESPACE_NAME      FILE_NAME
-------------------- ----------------------------------------
USERS                /u01/app/oracle/DELL/users01.dbf
UNDOTBS1             /u01/app/oracle/DELL/undotbs01.dbf
SYSAUX               /u01/app/oracle/DELL/sysaux01.dbf
SYSTEM               /u01/app/oracle/DELL/system01.dbf

SQL>
SQL>

SQL>
SQL> select name from v$tempfile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/DELL/temp01.dbf

SQL>
SQL>
SQL>
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@rac1 ~]$
[oracle@rac1 ~]$ cat 12102.env
export ORACLE_SID=DELL
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
export TNS_ADMIN=$ORACLE_HOME/network/admin
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib/usr/lib; export LD_LIBRARY_PATH
[oracle@rac1 ~]$
[oracle@rac1 ~]$ . 12102.env
[oracle@rac1 ~]$

Linux Installation of Oracle Database 12C(12.1.0.2)
[root@rac1 ~]#
[root@rac1 ~]# xhost +
access control disabled, clients can connect from any host
[root@rac1 ~]#
[root@rac1 ~]# su - oracle
[oracle@rac1 ~]$ cd /u01/sftwr_12102/database/
[oracle@rac1 database]$
[oracle@rac1 database]$ ls
install      response  runInstaller  stage
readme.html  rpm       sshsetup      welcome.html
[oracle@rac1 database]$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 500 MB.   Actual 27372 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 29996 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-12-21_12-46-12PM. Please wait ...[oracle@rac1 database]$ You can find the log of this install session at:
 /u01/app/oraInventory/logs/installActions2017-12-21_12-46-12PM.log








Upgrade Database using dbua

 [root@rac1 ~]#
[root@rac1 ~]# su - oracle
[oracle@rac1 ~]$ . 12102.env
[oracle@rac1 ~]$ dbua



















Thus we have successfully upgraded Oracle Database from 11204 to 12102 using DBUA.
This Article explains how to Upgrade ORACLE DATABASE in Linux Environment.

Thanks for Reading

Regards,
Mohammed Areefuddin
Suggested Topics :
Database Upgrade from 11.2.0.4 to 12.1.0.2 Manual Upgrade and DBUA Upgrade Installer Upgrade
11.2.0.1 to 11.2.0.4 Manual Upgrade
Linux
DATABASE
RMAN
RAC
EBS
5.7 Install
DATABASE Install

11201 Install
R1226 Install
Open Filer Instl
Active DataGaurd
Rman DataGuard
RAC DataGuard
EBS DataGuard


RMAN DB CLONE
RAC DB Clone
R1226 Clone

ASMCMD ASM Migrt
RMAN ASM Migrt

RMAN Clone

11204 M-Upgrade


11202 EBS Upgrade

12102 M-Upgrade


12102 EBS UPGRADE










Linux Basics
DATABASE Basics
RMAN Basics
RAC Basic
EBS Basics
Posted by at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)