Oracle Database Upgrade from 11204 to 12102 During Installation of Oracle 12.1.0.2

Hai, this article will illustrate you how to upgrade your oracle database from 11204 to 12102 during installation of 12.1.0.2 Oracle Database on Linux Platform.

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 ~]#

[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> 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> 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> 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>

SQL> select name from v$tempfile;

NAME

--------------------------------------------------------------------------------

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

SQL>

SQL>

SQL> show parameter spfile;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

spfile                               string      /u01/app/oracle/product/11.2.0

                                                 /dbhome_1/dbs/spfileDELL.ora

SQL>

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

Run Root Scripts

[root@rac1 ~]#

[root@rac1 ~]# /u01/app/oracle/product/12.1.0/dbhome_1/root.sh

Performing root user operation.

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u01/app/oracle/product/12.1.0/dbhome_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The file "dbhome" already exists in /usr/local/bin.  Overwrite it? (y/n)

[n]: y

   Copying dbhome to /usr/local/bin ...

The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)

[n]: y

   Copying oraenv to /usr/local/bin ...

The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)

[n]: y

   Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

[root@rac1 ~]#

[root@rac1 ~]#

Thus we have successfully upgraded Oracle Database from 11204 to 12102 During Installation of Oracle 12.1.0.2

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 
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