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.
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
|
[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
11.2.0.1 to 11.2.0.4 Manual Upgrade
Linux
|
DATABASE
|
RMAN
|
RAC
|
EBS
|
EBS DataGuard
| ||||
No comments:
Post a Comment