===============================
PROJECT: UPGRADE 11gR2 To 12c
===============================
###############################
Current Database configuration
###############################
====================
System Information
====================
[oracle@dbtrmrk ~]$ date
Sat Apr 26 06:22:31 EDT 2014
[oracle@dbtrmrk ~]$ cat /etc/oracle-release
Oracle Linux Server release 6.4
[oracle@dbtrmrk ~]$ uname -r
2.6.39-400.209.1.el6uek.x86_64
[oracle@dbtrmrk ~]$ uname -p
x86_64
====================
Oracle SID,Home,Base
====================
[oracle@dbtrmrk ~]$ echo $ORACLE_HOME
/u01/app/oracle/11.2.0/11gR24
[oracle@dbtrmrk ~]$ echo $ORACLE_SID
dbtrmrk
[oracle@dbtrmrk ~]$ echo $ORACLE_BASE
/u01/app/oracle
[oracle@dbtrmrk ~]$
====================
Oracle Inventory
====================
[oracle@dbtrmrk ~]$ cat /u01/app/oracle/11.2.0/11gR24/oraInst.loc
inventory_loc=/u01/app/oraInventory
inst_group=oinstall
[oracle@dbtrmrk ~]$ cat /u01/app/oraInventory/ContentsXML/inventory.xml
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2013, Oracle and/or its affiliates.
All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
<SAVED_WITH>11.2.0.4.0</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME="OraDb11g_home2" LOC="/u01/app/oracle/11.2.0/11gR24" TYPE="O" IDX="2"/>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>
========
Listener
=========
[oracle@dbtrmrk ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 26-APR-2014 06:12:29
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 26-APR-2014 06:08:35
Uptime 0 days 0 hr. 3 min. 54 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/11.2.0/11gR24/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/dbtrmrk/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbtrmrk.localdomain)(PORT=1521)))
Services Summary...
Service "dbtrmrk" has 1 instance(s).
Instance "dbtrmrk", status READY, has 1 handler(s) for this service...
The command completed successfully
=========
OraTab
=========
[oracle@dbtrmrk ~]$ cat /etc/oratab
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
dbtrmrk:/u01/app/oracle/11.2.0/11gR24:N
============================
Oracle Envrionemnt Variables
=============================
[oracle@dbtrmrk ~]$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/11.2.0/11gR24
export ORACLE_HOME
ORACLE_SID=dbtrmrk
export ORACLE_SID
PATH=$PATH:$HOME/bin
PATH=$PATH:$ORACLE_HOME/bin:.
export PATH
PATH=$PATH:$ORACLE_HOME/OPatch:.
export PATH
alias spi="sqlplus / as sysdba"
==================
Oracle Version
==================
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
INSTANCE_N HOST_NAME VERSION STATUS
---------- -------------------- --------------- ----------
dbtrmrk dbtrmrk.localdomain 11.2.0.4.0 OPEN
===========================
Oracle Registry Components
===========================
SQL> select comp_name,version,status from dba_registry;
COMP_NAME VERSION STATUS
------------------------------------------------------------ --------------- --------
OWB 11.2.0.3.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
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
###############################
TARGET Database configuration
###############################
ORACLE_HOME=/u02/app/oracle/12.1.0/12cR1
ORACLE_SID=dbtrmrk
ORACLE_BASE=/u01/app/oracle
Oracle Inventory Location=/u01/app/oraInventory/ContentsXML/inventory.xml
Note: ORACLE_BASE, ORACLE_SID, Inventory should stay as it is, only ORACLE_HOME change
###############################
Oracle 12c Preparation Steps
###############################
1. Download Oracle 12c software
2. Unzip in a temporary location
3. Create new ORACLE_HOME for 12c
4. Prepared Response file for Silent install - Software Only
5. Run Installer in Silent Mode to install Software Only
6. Remove the Enterprise Manager prior to upgrade
7. Run DBUA from NEW ORACLE_HOME - Silent Mode
8. Verify upgrade
9. Modify environmental variables
10.Copy listener and tnsnames to new ORACLE_HOME
11. Verify Database Upgrade
12. Deinstall old ORACLE_HOME
===============================
1. Download Oracle 12c software
===============================
[oracle@dbtrmrk db_1201]$ pwd
/tmp/db_1201
[oracle@dbtrmrk tmp]$ ll
total 2419520
-rw-r--r-- 1 oracle oinstall 1361028723 Apr 19 09:00 linuxamd64_12c_database_1of2.zip
-rw-r--r-- 1 oracle oinstall 1116527103 Apr 19 09:17 linuxamd64_12c_database_2of2.zip
===============================
2.Unzip in a temporary location
===============================
[oracle@dbtrmrk db_1201]$ unzip /tmp/linuxamd64_12c_database_1of2.zip -d /tmp/db_1201
[oracle@dbtrmrk db_1201]$ unzip /tmp/linuxamd64_12c_database_2of2.zip -d /tmp/db_1201
===============================
3.Create new ORACLE_HOME for 12c
===============================
[root@dbtrmrk ~]# mkdir /u02
[root@dbtrmrk ~]# chown -R oracle:oinstall /u02
[root@dbtrmrk ~]# chmod -R 775 /u02
[root@dbtrmrk ~]# su - oracle
[oracle@dbtrmrk ~]$ mkdir -p /u02/app/oracle/12.1.0/12cR1
[oracle@dbtrmrk 12cR1]$ pwd
/u02/app/oracle/12.1.0/12cR1
============================================================
4. Prepared Response file for Silent install - Software Only
============================================================
Note: I have copied the necessary parameters from db_install.rsp sample file
Note: I have created a new file called db_12c_install.rsp in the same folder
[oracle@dbtrmrk response]$ pwd
/tmp/db_1201/database/response
[oracle@dbtrmrk response]$ ll
total 100
-rw-r--r-- 1 oracle oinstall 464 Apr 26 07:32 db_12c_install.rsp
-rwxrwxr-x 1 oracle oinstall 58021 Aug 29 2012 dbca.rsp
-rw-rw-r-- 1 oracle oinstall 26690 May 24 2013 db_install.rsp
-rwxrwxr-x 1 oracle oinstall 6038 Jun 18 2012 netca.rsp
[oracle@dbtrmrk response]$ cat db_12c_install.rsp
oracle.install.option=INSTALL_DB_SWONLY
oracle.install.db.InstallEdition=EE
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/oracle/app/oraInventory
ORACLE_HOME=/u02/app/oracle/12.1.0/12cR1
ORACLE_BASE=/u01/app/oracle
DECLINE_SECURITY_UPDATES=true
oracle.installer.autoupdates.option=SKIP_UPDATES
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=dba
oracle.install.db.BACKUPDBA_GROUP=dba
oracle.install.db.DGDBA_GROUP=dba
oracle.install.db.KMDBA_GROUP=dba
=========================================================
5. Run Installer in Silent Mode to install Software Only
=========================================================
[oracle@dbtrmrk response]$ export ORACLE_HOME=/u02/app/oracle/12.1.0/12cR1
[oracle@dbtrmrk database]$ ls
install response rpm runInstaller sshsetup stage welcome.html
[oracle@dbtrmrk ~]$ /tmp/db_1201/database/runInstaller -silent -responseFile /home/oracle/db_12c_install.rsp
Checking Temp space: must be greater than 500 MB. Actual 26825 MB Passed
Checking swap space: must be greater than 150 MB. Actual 3999 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-04-26_08-12-49AM. Please wait ...
You can find the log of this install session at:
/u01/app/oraInventory/logs/installActions2014-04-26_08-12-49AM.log
Note: We can do the tail on the log file while OUI is running in silent mode:
[oracle@dbtrmrk ~]$ tail -f /u01/app/oraInventory/logs/installActions2014-04-26_08-12-49AM.log
*** End of Installation Page***
The installation of Oracle Database 12c was successful.
Please check '/u01/app/oraInventory/logs/silentInstall2014-04-26_08-12-49AM.log' for more details.
The installation of Oracle Database 12c was successful.
INFO: Updating the global context
INFO: Path To 'globalcontext.xml' = /u02/app/oracle/12.1.0/12cR1/install/chainedInstall/globalcontext
INFO: Since operation was successful, move the current OiicAPISessionDetails to installed list
INFO: Number of root scripts to be executed = 1
INFO: isSuccessfullInstallation: true
INFO: isSuccessfullRemoteInstallation: true
INFO: Adding ExitStatus SUCCESS to the exit status set
INFO: Completed setting up InstallDB
INFO: Number of scripts to be executed as root user = 1
As a root user, execute the following script(s):
1. /u02/app/oracle/12.1.0/12cR1/root.sh
[oracle@dbtrmrk ~]$ su -
Password:
[root@dbtrmrk ~]# /u02/app/oracle/12.1.0/12cR1/root.sh
Check /u02/app/oracle/12.1.0/12cR1/install/root_dbtrmrk.localdomain_2014-04-26_08-23-34.log for the output of root script
[root@dbtrmrk ~]# cat /u02/app/oracle/12.1.0/12cR1/install/root_dbtrmrk.localdomain_2014-04-26_08-23-34.log
Performing root user operation for Oracle 12c
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u02/app/oracle/12.1.0/12cR1
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
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@dbtrmrk ~]#
=================================================
6. Remove the Enterprise Manager prior to upgrade
==================================================
Note: In Release 12.1 EM database control repository is removed during the upgrade.
We should run the emremove.sql from new ORACLE_HOME with SYS connected as DBA.
SQL> @/u02/app/oracle/12.1.0/12cR1/rdbms/admin/emremove.sql
old 69: IF (upper('&LOGGING') = 'VERBOSE')
new 69: IF (upper('VERBOSE') = 'VERBOSE')
PL/SQL procedure successfully completed.
===============================================
7. Run DBUA from NEW ORACLE_HOME - Silent Mode
===============================================
Note: I used the DBUA in silent mode
Note: While DBUA upgrade the DB, a new folder is created under ORACLE_BASE/cfgtoolslogs/dbua/sid_name/upgraden
[oracle@dbtrmrk ~]$ /u02/app/oracle/12.1.0/12cR1/bin/dbua -silent \
> -sid dbtrmrk \
> -oracleHome /u01/app/oracle/11.2.0/11gR24 \
> -diagnosticDest /u01/app/oracle \
> -autoextendFiles \
> -recompile_invalid_objects true \
> -degree_of_parallelism 2 \
> -upgradeTimezone \
> -emConfiguration NONE \
> -keepHiddenParams \
> -gatheringStatistics \
> -createGRP true \
> -upgrade_parallelism 2
Log files for the upgrade operation are located at: /u01/app/oracle/cfgtoollogs/dbua/dbtrmrk/upgrade3
Performing Database Backup
0% complete
16% complete
Performing Pre Upgrade
20% complete
33% complete
Performing RDBMS Upgrade
33% complete
34% complete
34% complete
49% complete
49% complete
50% complete
Performing Post Upgrade
51% complete
53% complete
66% complete
Upgrading Timezone
83% complete
Generating Summary
Database upgrade has been completed successfully, and the database is ready to use.
100% complete
Check the log file "/u01/app/oracle/cfgtoollogs/dbua/logs/silent.log_1398518640612" for upgrade details.
[oracle@dbtrmrk upgrade3]$ pwd
/u01/app/oracle/cfgtoollogs/dbua/dbtrmrk/upgrade3
[oracle@dbtrmrk upgrade3]$ ll
total 251232
-rw-r----- 1 oracle oinstall 190 Apr 26 09:28 Backup.log
-rw-r----- 1 oracle oinstall 248704839 Apr 26 10:32 catupgrd0.log
-rw-r----- 1 oracle oinstall 7988854 Apr 26 10:32 catupgrd1.log
-rwxr-xr-x 1 oracle oinstall 167 Apr 26 09:28 createSPFile_dbtrmrk.sql
-rwxr-xr-x 1 oracle oinstall 1211 Apr 26 09:28 dbtrmrk_restore.sh
-rwxr-xr-x 1 oracle oinstall 127 Apr 26 09:28 grpOpen_dbtrmrk.sql
-rw-r----- 1 oracle oinstall 1474 Apr 26 09:28 init.ora
-rw-r----- 1 oracle oinstall 152524 Apr 26 10:35 Oracle_Server.log
-rw-r----- 1 oracle oinstall 0 Apr 26 09:30 Oracle_Text.log
-rw-r----- 1 oracle oinstall 10290 Apr 26 10:43 PostUpgrade.log
-rw-r----- 1 oracle oinstall 929 Apr 26 09:30 PreUpgrade.log
-rw-r----- 1 oracle oinstall 6081 Apr 26 09:28 PreUpgradeResults.html
-rwxr-xr-x 1 oracle oinstall 42 Apr 26 09:28 shutdown_dbtrmrk.sql
-rw-r----- 1 oracle oinstall 98169 Apr 26 10:47 sqls.log
-rwxr-xr-x 1 oracle oinstall 35 Apr 26 09:28 startup_dbtrmrk.sql
-rw-r----- 1 oracle oinstall 224354 Apr 26 10:47 trace.log
-rw-r----- 1 oracle oinstall 0 Apr 26 09:26 trace.log.lck
-rw-r----- 1 oracle oinstall 5652 Apr 26 10:47 UpgradeResults.html
-rw-r----- 1 oracle oinstall 734 Apr 26 10:47 UpgradeTimezone.log
-rw-r----- 1 oracle oinstall 4117 Apr 26 09:28 upgrade.xml
=======================
8. Verify Upgrade
=======================
[oracle@dbtrmrk upgrade3]$ cat /etc/oratab
dbtrmrk:/u02/app/oracle/12.1.0/12cR1:N
[oracle@dbtrmrk upgrade3]$ cat /u01/app/oraInventory/ContentsXML/inventory.xml
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2013, Oracle and/or its affiliates.
All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
<SAVED_WITH>12.1.0.1.0</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME="OraDb11g_home2" LOC="/u01/app/oracle/11.2.0/11gR24" TYPE="O" IDX="2"/>
<HOME NAME="OraDB12Home1" LOC="/u02/app/oracle/12.1.0/12cR1" TYPE="O" IDX="3"/>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>
=================================
9. Modify environmental variables
=================================
Note: Modify the ORACLE_HOME value to new ORACLE_HOME
[oracle@dbtrmrk ~]$ cat .bash_profile
# User specific environment and startup programs
ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE
ORACLE_HOME=/u02/app/oracle/12.1.0/12cR1
export ORACLE_HOME
ORACLE_SID=dbtrmrk
export ORACLE_SID
PATH=$PATH:$HOME/bin
PATH=$PATH:$ORACLE_HOME/bin:.
export PATH
PATH=$PATH:$ORACLE_HOME/OPatch:.
export PATH
alias spi="sqlplus / as sysdba"
=================================================
10.Copy listener and tnsnames to new ORACLE_HOME
=================================================
[oracle@dbtrmrk ~]$ ps -ef | grep tns
oracle 2281 1 0 06:08 ? 00:00:02 /u01/app/oracle/11.2.0/11gR24/bin/tnslsnr LISTENER -inherit
[oracle@dbtrmrk ~]$ /u01/app/oracle/11.2.0/11gR24/bin/lsnrctl stop
[oracle@dbtrmrk ~]$ cp /u01/app/oracle/11.2.0/11gR24/network/admin/listener.ora /u02/app/oracle/12.1.0/12cR1/network/admin
[oracle@dbtrmrk ~]$ cp /u01/app/oracle/11.2.0/11gR24/network/admin/tnsnames.ora /u02/app/oracle/12.1.0/12cR1/network/admin
[oracle@dbtrmrk ~]$ mv /u01/app/oracle/11.2.0/11gR24/network/admin/tnsnames.ora /u01/app/oracle/11.2.0/11gR24/network/admin/tnsnames.ora.old
[oracle@dbtrmrk ~]$ mv /u01/app/oracle/11.2.0/11gR24/network/admin/listener.ora /u01/app/oracle/11.2.0/11gR24/network/admin/listener.ora.old
[oracle@dbtrmrk ~]$ cd /u02/app/oracle/12.1.0/12cR1/bin
[oracle@dbtrmrk bin]$ ./lsnrctl start
LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 26-APR-2014 11:28:17
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting /u02/app/oracle/12.1.0/12cR1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.1.0.1.0 - Production
System parameter file is /u02/app/oracle/12.1.0/12cR1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/dbtrmrk/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbtrmrk.localdomain)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production
Start Date 26-APR-2014 11:28:18
Uptime 0 days 0 hr. 0 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u02/app/oracle/12.1.0/12cR1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/dbtrmrk/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbtrmrk.localdomain)(PORT=1521)))
Services Summary...
Service "dbtrmrk" has 1 instance(s).
Instance "dbtrmrk", status READY, has 1 handler(s) for this service...
Service "dbtrmrkXDB" has 1 instance(s).
Instance "dbtrmrk", status READY, has 1 handler(s) for this service...
The command completed successfully
===========================
11. Verify Database Upgrade
===========================
SQL> select instance_name,version,status from v$instance;
INSTANCE_NAME VERSION STATUS
---------------- ----------------- ------------
dbtrmrk 12.1.0.1.0 OPEN
SQL>SELECT
to_char(action_time, 'DD-MON-YYYY HH:MI:SS AM') upgrade_date,comments source_version, version Target_Version
FROM dba_registry_history
WHERE action = 'UPGRADE';
UPGRADE_DATE SOURCE_VERSION TARGET_VERSION
-------------------------------------------------- ---------------------------------------- --------------------
11-APR-2014 02:27:48 PM Upgraded from 11.2.0.3.0 11.2.0.4.0
26-APR-2014 10:31:55 AM Upgraded from 11.2.0.4.0 12.1.0.1.0
COMP_NAME VERSION STATUS
------------------------------------------------------------ --------------- ---------------
Oracle Application Express 4.2.0.00.27 VALID
OWB 11.2.0.3.0 VALID
OLAP Catalog 11.2.0.4.0 OPTION OFF
Spatial 12.1.0.1.0 VALID
Oracle Multimedia 12.1.0.1.0 VALID
Oracle XML Database 12.1.0.1.0 VALID
Oracle Text 12.1.0.1.0 VALID
Oracle Workspace Manager 12.1.0.1.0 VALID
Oracle Database Catalog Views 12.1.0.1.0 VALID
Oracle Database Packages and Types 12.1.0.1.0 VALID
JServer JAVA Virtual Machine 12.1.0.1.0 VALID
Oracle XDK 12.1.0.1.0 VALID
Oracle Database Java Packages 12.1.0.1.0 VALID
OLAP Analytic Workspace 12.1.0.1.0 VALID
Oracle OLAP API 12.1.0.1.0 VALID
=============================
12. Deinstall old ORACLE_HOME
=============================
Note: Run this script from the Old ORACLE_HOME that need to be deinstall
SQL> !/u01/app/oracle/11.2.0/11gR24/deinstall/deinstall
Checking for required files and bootstrapping ...
Please wait ...
Location of logs /u01/app/oraInventory/logs/
############ ORACLE DEINSTALL & DECONFIG TOOL START ############
######################### CHECK OPERATION START #########################
## [START] Install check configuration ##
Checking for existence of the Oracle home location /u01/app/oracle/11.2.0/11gR24
Oracle Home type selected for deinstall is: Oracle Single Instance Database
Oracle Base selected for deinstall is: /u01/app/oracle
Checking for existence of central inventory location /u01/app/oraInventory
Checking for sufficient temp space availability on node(s) : 'dbtrmrk.localdomain'
## [END] Install check configuration ##
Network Configuration check config START
Network de-configuration trace file location: /u01/app/oraInventory/logs/netdc_check2014-04-26_11-54-48-AM.log
Network Configuration check config END
Database Check Configuration START
Database de-configuration trace file location: /u01/app/oraInventory/logs/databasedc_check2014-04-26_11-54-51-AM.log
Use comma as separator when specifying list of values as input
Specify the list of database names that are configured in this Oracle home []:
Database Check Configuration END
Enterprise Manager Configuration Assistant START
EMCA de-configuration trace file location: /u01/app/oraInventory/logs/emcadc_check2014-04-26_11-55-31-AM.log
Enterprise Manager Configuration Assistant END
Oracle Configuration Manager check START
OCM check log file location : /u01/app/oraInventory/logs//ocm_check3157.log
Oracle Configuration Manager check END
######################### CHECK OPERATION END #########################
####################### CHECK OPERATION SUMMARY #######################
Oracle Home selected for deinstall is: /u01/app/oracle/11.2.0/11gR24
Inventory Location where the Oracle home registered is: /u01/app/oraInventory
No Enterprise Manager configuration to be updated for any database(s)
No Enterprise Manager ASM targets to update
No Enterprise Manager listener targets to migrate
Checking the config status for CCR
Oracle Home exists with CCR directory, but CCR is not configured
CCR check is finished
Do you want to continue (y - yes, n - no)? [n]: y
A log of this session will be written to: '/u01/app/oraInventory/logs/deinstall_deconfig2014-04-26_11-54-45-AM.out'
Any error messages from this session will be written to: '/u01/app/oraInventory/logs/deinstall_deconfig2014-04-26_11-54-45-AM.err'
######################## CLEAN OPERATION START ########################
Enterprise Manager Configuration Assistant START
EMCA de-configuration trace file location: /u01/app/oraInventory/logs/emcadc_clean2014-04-26_11-55-31-AM.log
Updating Enterprise Manager ASM targets (if any)
Updating Enterprise Manager listener targets (if any)
Enterprise Manager Configuration Assistant END
Database de-configuration trace file location: /u01/app/oraInventory/logs/databasedc_clean2014-04-26_11-55-39-AM.log
Network Configuration clean config START
Network de-configuration trace file location: /u01/app/oraInventory/logs/netdc_clean2014-04-26_11-55-40-AM.log
De-configuring backup files...
Backup files de-configured successfully.
The network configuration has been cleaned up successfully.
Network Configuration clean config END
Oracle Configuration Manager clean START
OCM clean log file location : /u01/app/oraInventory/logs//ocm_clean3157.log
Oracle Configuration Manager clean END
Setting the force flag to false
Setting the force flag to cleanup the Oracle Base
Oracle Universal Installer clean START
Detach Oracle home '/u01/app/oracle/11.2.0/11gR24' from the central inventory on the local node : Done
Delete directory '/u01/app/oracle/11.2.0/11gR24' on the local node : Done
The Oracle Base directory '/u01/app/oracle' will not be removed on local node. The directory is in use by Oracle Home '/u01/app/oracle/11.2.0/11gR2'.
Oracle Universal Installer cleanup was successful.
Oracle Universal Installer clean END
## [START] Oracle install clean ##
Clean install operation removing temporary directory '/tmp/deinstall2014-04-26_11-54-17AM' on node 'dbtrmrk'
## [END] Oracle install clean ##
######################### CLEAN OPERATION END #########################
####################### CLEAN OPERATION SUMMARY #######################
Cleaning the config for CCR
As CCR is not configured, so skipping the cleaning of CCR configuration
CCR clean is finished
Successfully detached Oracle home '/u01/app/oracle/11.2.0/11gR24' from the central inventory on the local node.
Successfully deleted directory '/u01/app/oracle/11.2.0/11gR24' on the local node.
Oracle Universal Installer cleanup was successful.
Oracle deinstall tool successfully cleaned up temporary directories.
#######################################################################
############# ORACLE DEINSTALL & DECONFIG TOOL END #############
Enjoy.................Abid Malik
PROJECT: UPGRADE 11gR2 To 12c
===============================
###############################
Current Database configuration
###############################
====================
System Information
====================
[oracle@dbtrmrk ~]$ date
Sat Apr 26 06:22:31 EDT 2014
[oracle@dbtrmrk ~]$ cat /etc/oracle-release
Oracle Linux Server release 6.4
[oracle@dbtrmrk ~]$ uname -r
2.6.39-400.209.1.el6uek.x86_64
[oracle@dbtrmrk ~]$ uname -p
x86_64
====================
Oracle SID,Home,Base
====================
[oracle@dbtrmrk ~]$ echo $ORACLE_HOME
/u01/app/oracle/11.2.0/11gR24
[oracle@dbtrmrk ~]$ echo $ORACLE_SID
dbtrmrk
[oracle@dbtrmrk ~]$ echo $ORACLE_BASE
/u01/app/oracle
[oracle@dbtrmrk ~]$
====================
Oracle Inventory
====================
[oracle@dbtrmrk ~]$ cat /u01/app/oracle/11.2.0/11gR24/oraInst.loc
inventory_loc=/u01/app/oraInventory
inst_group=oinstall
[oracle@dbtrmrk ~]$ cat /u01/app/oraInventory/ContentsXML/inventory.xml
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2013, Oracle and/or its affiliates.
All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
<SAVED_WITH>11.2.0.4.0</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME="OraDb11g_home2" LOC="/u01/app/oracle/11.2.0/11gR24" TYPE="O" IDX="2"/>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>
========
Listener
=========
[oracle@dbtrmrk ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 26-APR-2014 06:12:29
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 26-APR-2014 06:08:35
Uptime 0 days 0 hr. 3 min. 54 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/11.2.0/11gR24/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/dbtrmrk/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbtrmrk.localdomain)(PORT=1521)))
Services Summary...
Service "dbtrmrk" has 1 instance(s).
Instance "dbtrmrk", status READY, has 1 handler(s) for this service...
The command completed successfully
=========
OraTab
=========
[oracle@dbtrmrk ~]$ cat /etc/oratab
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
dbtrmrk:/u01/app/oracle/11.2.0/11gR24:N
============================
Oracle Envrionemnt Variables
=============================
[oracle@dbtrmrk ~]$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/11.2.0/11gR24
export ORACLE_HOME
ORACLE_SID=dbtrmrk
export ORACLE_SID
PATH=$PATH:$HOME/bin
PATH=$PATH:$ORACLE_HOME/bin:.
export PATH
PATH=$PATH:$ORACLE_HOME/OPatch:.
export PATH
alias spi="sqlplus / as sysdba"
==================
Oracle Version
==================
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
INSTANCE_N HOST_NAME VERSION STATUS
---------- -------------------- --------------- ----------
dbtrmrk dbtrmrk.localdomain 11.2.0.4.0 OPEN
===========================
Oracle Registry Components
===========================
SQL> select comp_name,version,status from dba_registry;
COMP_NAME VERSION STATUS
------------------------------------------------------------ --------------- --------
OWB 11.2.0.3.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
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
###############################
TARGET Database configuration
###############################
ORACLE_HOME=/u02/app/oracle/12.1.0/12cR1
ORACLE_SID=dbtrmrk
ORACLE_BASE=/u01/app/oracle
Oracle Inventory Location=/u01/app/oraInventory/ContentsXML/inventory.xml
Note: ORACLE_BASE, ORACLE_SID, Inventory should stay as it is, only ORACLE_HOME change
###############################
Oracle 12c Preparation Steps
###############################
1. Download Oracle 12c software
2. Unzip in a temporary location
3. Create new ORACLE_HOME for 12c
4. Prepared Response file for Silent install - Software Only
5. Run Installer in Silent Mode to install Software Only
6. Remove the Enterprise Manager prior to upgrade
7. Run DBUA from NEW ORACLE_HOME - Silent Mode
8. Verify upgrade
9. Modify environmental variables
10.Copy listener and tnsnames to new ORACLE_HOME
11. Verify Database Upgrade
12. Deinstall old ORACLE_HOME
===============================
1. Download Oracle 12c software
===============================
[oracle@dbtrmrk db_1201]$ pwd
/tmp/db_1201
[oracle@dbtrmrk tmp]$ ll
total 2419520
-rw-r--r-- 1 oracle oinstall 1361028723 Apr 19 09:00 linuxamd64_12c_database_1of2.zip
-rw-r--r-- 1 oracle oinstall 1116527103 Apr 19 09:17 linuxamd64_12c_database_2of2.zip
===============================
2.Unzip in a temporary location
===============================
[oracle@dbtrmrk db_1201]$ unzip /tmp/linuxamd64_12c_database_1of2.zip -d /tmp/db_1201
[oracle@dbtrmrk db_1201]$ unzip /tmp/linuxamd64_12c_database_2of2.zip -d /tmp/db_1201
===============================
3.Create new ORACLE_HOME for 12c
===============================
[root@dbtrmrk ~]# mkdir /u02
[root@dbtrmrk ~]# chown -R oracle:oinstall /u02
[root@dbtrmrk ~]# chmod -R 775 /u02
[root@dbtrmrk ~]# su - oracle
[oracle@dbtrmrk ~]$ mkdir -p /u02/app/oracle/12.1.0/12cR1
[oracle@dbtrmrk 12cR1]$ pwd
/u02/app/oracle/12.1.0/12cR1
============================================================
4. Prepared Response file for Silent install - Software Only
============================================================
Note: I have copied the necessary parameters from db_install.rsp sample file
Note: I have created a new file called db_12c_install.rsp in the same folder
[oracle@dbtrmrk response]$ pwd
/tmp/db_1201/database/response
[oracle@dbtrmrk response]$ ll
total 100
-rw-r--r-- 1 oracle oinstall 464 Apr 26 07:32 db_12c_install.rsp
-rwxrwxr-x 1 oracle oinstall 58021 Aug 29 2012 dbca.rsp
-rw-rw-r-- 1 oracle oinstall 26690 May 24 2013 db_install.rsp
-rwxrwxr-x 1 oracle oinstall 6038 Jun 18 2012 netca.rsp
[oracle@dbtrmrk response]$ cat db_12c_install.rsp
oracle.install.option=INSTALL_DB_SWONLY
oracle.install.db.InstallEdition=EE
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/oracle/app/oraInventory
ORACLE_HOME=/u02/app/oracle/12.1.0/12cR1
ORACLE_BASE=/u01/app/oracle
DECLINE_SECURITY_UPDATES=true
oracle.installer.autoupdates.option=SKIP_UPDATES
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=dba
oracle.install.db.BACKUPDBA_GROUP=dba
oracle.install.db.DGDBA_GROUP=dba
oracle.install.db.KMDBA_GROUP=dba
=========================================================
5. Run Installer in Silent Mode to install Software Only
=========================================================
[oracle@dbtrmrk response]$ export ORACLE_HOME=/u02/app/oracle/12.1.0/12cR1
[oracle@dbtrmrk database]$ ls
install response rpm runInstaller sshsetup stage welcome.html
[oracle@dbtrmrk ~]$ /tmp/db_1201/database/runInstaller -silent -responseFile /home/oracle/db_12c_install.rsp
Checking Temp space: must be greater than 500 MB. Actual 26825 MB Passed
Checking swap space: must be greater than 150 MB. Actual 3999 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-04-26_08-12-49AM. Please wait ...
You can find the log of this install session at:
/u01/app/oraInventory/logs/installActions2014-04-26_08-12-49AM.log
Note: We can do the tail on the log file while OUI is running in silent mode:
[oracle@dbtrmrk ~]$ tail -f /u01/app/oraInventory/logs/installActions2014-04-26_08-12-49AM.log
*** End of Installation Page***
The installation of Oracle Database 12c was successful.
Please check '/u01/app/oraInventory/logs/silentInstall2014-04-26_08-12-49AM.log' for more details.
The installation of Oracle Database 12c was successful.
INFO: Updating the global context
INFO: Path To 'globalcontext.xml' = /u02/app/oracle/12.1.0/12cR1/install/chainedInstall/globalcontext
INFO: Since operation was successful, move the current OiicAPISessionDetails to installed list
INFO: Number of root scripts to be executed = 1
INFO: isSuccessfullInstallation: true
INFO: isSuccessfullRemoteInstallation: true
INFO: Adding ExitStatus SUCCESS to the exit status set
INFO: Completed setting up InstallDB
INFO: Number of scripts to be executed as root user = 1
As a root user, execute the following script(s):
1. /u02/app/oracle/12.1.0/12cR1/root.sh
[oracle@dbtrmrk ~]$ su -
Password:
[root@dbtrmrk ~]# /u02/app/oracle/12.1.0/12cR1/root.sh
Check /u02/app/oracle/12.1.0/12cR1/install/root_dbtrmrk.localdomain_2014-04-26_08-23-34.log for the output of root script
[root@dbtrmrk ~]# cat /u02/app/oracle/12.1.0/12cR1/install/root_dbtrmrk.localdomain_2014-04-26_08-23-34.log
Performing root user operation for Oracle 12c
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u02/app/oracle/12.1.0/12cR1
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
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@dbtrmrk ~]#
=================================================
6. Remove the Enterprise Manager prior to upgrade
==================================================
Note: In Release 12.1 EM database control repository is removed during the upgrade.
We should run the emremove.sql from new ORACLE_HOME with SYS connected as DBA.
SQL> @/u02/app/oracle/12.1.0/12cR1/rdbms/admin/emremove.sql
old 69: IF (upper('&LOGGING') = 'VERBOSE')
new 69: IF (upper('VERBOSE') = 'VERBOSE')
PL/SQL procedure successfully completed.
===============================================
7. Run DBUA from NEW ORACLE_HOME - Silent Mode
===============================================
Note: I used the DBUA in silent mode
Note: While DBUA upgrade the DB, a new folder is created under ORACLE_BASE/cfgtoolslogs/dbua/sid_name/upgraden
[oracle@dbtrmrk ~]$ /u02/app/oracle/12.1.0/12cR1/bin/dbua -silent \
> -sid dbtrmrk \
> -oracleHome /u01/app/oracle/11.2.0/11gR24 \
> -diagnosticDest /u01/app/oracle \
> -autoextendFiles \
> -recompile_invalid_objects true \
> -degree_of_parallelism 2 \
> -upgradeTimezone \
> -emConfiguration NONE \
> -keepHiddenParams \
> -gatheringStatistics \
> -createGRP true \
> -upgrade_parallelism 2
Log files for the upgrade operation are located at: /u01/app/oracle/cfgtoollogs/dbua/dbtrmrk/upgrade3
Performing Database Backup
0% complete
16% complete
Performing Pre Upgrade
20% complete
33% complete
Performing RDBMS Upgrade
33% complete
34% complete
34% complete
49% complete
49% complete
50% complete
Performing Post Upgrade
51% complete
53% complete
66% complete
Upgrading Timezone
83% complete
Generating Summary
Database upgrade has been completed successfully, and the database is ready to use.
100% complete
Check the log file "/u01/app/oracle/cfgtoollogs/dbua/logs/silent.log_1398518640612" for upgrade details.
[oracle@dbtrmrk upgrade3]$ pwd
/u01/app/oracle/cfgtoollogs/dbua/dbtrmrk/upgrade3
[oracle@dbtrmrk upgrade3]$ ll
total 251232
-rw-r----- 1 oracle oinstall 190 Apr 26 09:28 Backup.log
-rw-r----- 1 oracle oinstall 248704839 Apr 26 10:32 catupgrd0.log
-rw-r----- 1 oracle oinstall 7988854 Apr 26 10:32 catupgrd1.log
-rwxr-xr-x 1 oracle oinstall 167 Apr 26 09:28 createSPFile_dbtrmrk.sql
-rwxr-xr-x 1 oracle oinstall 1211 Apr 26 09:28 dbtrmrk_restore.sh
-rwxr-xr-x 1 oracle oinstall 127 Apr 26 09:28 grpOpen_dbtrmrk.sql
-rw-r----- 1 oracle oinstall 1474 Apr 26 09:28 init.ora
-rw-r----- 1 oracle oinstall 152524 Apr 26 10:35 Oracle_Server.log
-rw-r----- 1 oracle oinstall 0 Apr 26 09:30 Oracle_Text.log
-rw-r----- 1 oracle oinstall 10290 Apr 26 10:43 PostUpgrade.log
-rw-r----- 1 oracle oinstall 929 Apr 26 09:30 PreUpgrade.log
-rw-r----- 1 oracle oinstall 6081 Apr 26 09:28 PreUpgradeResults.html
-rwxr-xr-x 1 oracle oinstall 42 Apr 26 09:28 shutdown_dbtrmrk.sql
-rw-r----- 1 oracle oinstall 98169 Apr 26 10:47 sqls.log
-rwxr-xr-x 1 oracle oinstall 35 Apr 26 09:28 startup_dbtrmrk.sql
-rw-r----- 1 oracle oinstall 224354 Apr 26 10:47 trace.log
-rw-r----- 1 oracle oinstall 0 Apr 26 09:26 trace.log.lck
-rw-r----- 1 oracle oinstall 5652 Apr 26 10:47 UpgradeResults.html
-rw-r----- 1 oracle oinstall 734 Apr 26 10:47 UpgradeTimezone.log
-rw-r----- 1 oracle oinstall 4117 Apr 26 09:28 upgrade.xml
=======================
8. Verify Upgrade
=======================
[oracle@dbtrmrk upgrade3]$ cat /etc/oratab
dbtrmrk:/u02/app/oracle/12.1.0/12cR1:N
[oracle@dbtrmrk upgrade3]$ cat /u01/app/oraInventory/ContentsXML/inventory.xml
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2013, Oracle and/or its affiliates.
All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
<SAVED_WITH>12.1.0.1.0</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME="OraDb11g_home2" LOC="/u01/app/oracle/11.2.0/11gR24" TYPE="O" IDX="2"/>
<HOME NAME="OraDB12Home1" LOC="/u02/app/oracle/12.1.0/12cR1" TYPE="O" IDX="3"/>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>
=================================
9. Modify environmental variables
=================================
Note: Modify the ORACLE_HOME value to new ORACLE_HOME
[oracle@dbtrmrk ~]$ cat .bash_profile
# User specific environment and startup programs
ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE
ORACLE_HOME=/u02/app/oracle/12.1.0/12cR1
export ORACLE_HOME
ORACLE_SID=dbtrmrk
export ORACLE_SID
PATH=$PATH:$HOME/bin
PATH=$PATH:$ORACLE_HOME/bin:.
export PATH
PATH=$PATH:$ORACLE_HOME/OPatch:.
export PATH
alias spi="sqlplus / as sysdba"
=================================================
10.Copy listener and tnsnames to new ORACLE_HOME
=================================================
[oracle@dbtrmrk ~]$ ps -ef | grep tns
oracle 2281 1 0 06:08 ? 00:00:02 /u01/app/oracle/11.2.0/11gR24/bin/tnslsnr LISTENER -inherit
[oracle@dbtrmrk ~]$ /u01/app/oracle/11.2.0/11gR24/bin/lsnrctl stop
[oracle@dbtrmrk ~]$ cp /u01/app/oracle/11.2.0/11gR24/network/admin/listener.ora /u02/app/oracle/12.1.0/12cR1/network/admin
[oracle@dbtrmrk ~]$ cp /u01/app/oracle/11.2.0/11gR24/network/admin/tnsnames.ora /u02/app/oracle/12.1.0/12cR1/network/admin
[oracle@dbtrmrk ~]$ mv /u01/app/oracle/11.2.0/11gR24/network/admin/tnsnames.ora /u01/app/oracle/11.2.0/11gR24/network/admin/tnsnames.ora.old
[oracle@dbtrmrk ~]$ mv /u01/app/oracle/11.2.0/11gR24/network/admin/listener.ora /u01/app/oracle/11.2.0/11gR24/network/admin/listener.ora.old
[oracle@dbtrmrk ~]$ cd /u02/app/oracle/12.1.0/12cR1/bin
[oracle@dbtrmrk bin]$ ./lsnrctl start
LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 26-APR-2014 11:28:17
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting /u02/app/oracle/12.1.0/12cR1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.1.0.1.0 - Production
System parameter file is /u02/app/oracle/12.1.0/12cR1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/dbtrmrk/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbtrmrk.localdomain)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production
Start Date 26-APR-2014 11:28:18
Uptime 0 days 0 hr. 0 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u02/app/oracle/12.1.0/12cR1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/dbtrmrk/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbtrmrk.localdomain)(PORT=1521)))
Services Summary...
Service "dbtrmrk" has 1 instance(s).
Instance "dbtrmrk", status READY, has 1 handler(s) for this service...
Service "dbtrmrkXDB" has 1 instance(s).
Instance "dbtrmrk", status READY, has 1 handler(s) for this service...
The command completed successfully
===========================
11. Verify Database Upgrade
===========================
SQL> select instance_name,version,status from v$instance;
INSTANCE_NAME VERSION STATUS
---------------- ----------------- ------------
dbtrmrk 12.1.0.1.0 OPEN
SQL>SELECT
to_char(action_time, 'DD-MON-YYYY HH:MI:SS AM') upgrade_date,comments source_version, version Target_Version
FROM dba_registry_history
WHERE action = 'UPGRADE';
UPGRADE_DATE SOURCE_VERSION TARGET_VERSION
-------------------------------------------------- ---------------------------------------- --------------------
11-APR-2014 02:27:48 PM Upgraded from 11.2.0.3.0 11.2.0.4.0
26-APR-2014 10:31:55 AM Upgraded from 11.2.0.4.0 12.1.0.1.0
COMP_NAME VERSION STATUS
------------------------------------------------------------ --------------- ---------------
Oracle Application Express 4.2.0.00.27 VALID
OWB 11.2.0.3.0 VALID
OLAP Catalog 11.2.0.4.0 OPTION OFF
Spatial 12.1.0.1.0 VALID
Oracle Multimedia 12.1.0.1.0 VALID
Oracle XML Database 12.1.0.1.0 VALID
Oracle Text 12.1.0.1.0 VALID
Oracle Workspace Manager 12.1.0.1.0 VALID
Oracle Database Catalog Views 12.1.0.1.0 VALID
Oracle Database Packages and Types 12.1.0.1.0 VALID
JServer JAVA Virtual Machine 12.1.0.1.0 VALID
Oracle XDK 12.1.0.1.0 VALID
Oracle Database Java Packages 12.1.0.1.0 VALID
OLAP Analytic Workspace 12.1.0.1.0 VALID
Oracle OLAP API 12.1.0.1.0 VALID
=============================
12. Deinstall old ORACLE_HOME
=============================
Note: Run this script from the Old ORACLE_HOME that need to be deinstall
SQL> !/u01/app/oracle/11.2.0/11gR24/deinstall/deinstall
Checking for required files and bootstrapping ...
Please wait ...
Location of logs /u01/app/oraInventory/logs/
############ ORACLE DEINSTALL & DECONFIG TOOL START ############
######################### CHECK OPERATION START #########################
## [START] Install check configuration ##
Checking for existence of the Oracle home location /u01/app/oracle/11.2.0/11gR24
Oracle Home type selected for deinstall is: Oracle Single Instance Database
Oracle Base selected for deinstall is: /u01/app/oracle
Checking for existence of central inventory location /u01/app/oraInventory
Checking for sufficient temp space availability on node(s) : 'dbtrmrk.localdomain'
## [END] Install check configuration ##
Network Configuration check config START
Network de-configuration trace file location: /u01/app/oraInventory/logs/netdc_check2014-04-26_11-54-48-AM.log
Network Configuration check config END
Database Check Configuration START
Database de-configuration trace file location: /u01/app/oraInventory/logs/databasedc_check2014-04-26_11-54-51-AM.log
Use comma as separator when specifying list of values as input
Specify the list of database names that are configured in this Oracle home []:
Database Check Configuration END
Enterprise Manager Configuration Assistant START
EMCA de-configuration trace file location: /u01/app/oraInventory/logs/emcadc_check2014-04-26_11-55-31-AM.log
Enterprise Manager Configuration Assistant END
Oracle Configuration Manager check START
OCM check log file location : /u01/app/oraInventory/logs//ocm_check3157.log
Oracle Configuration Manager check END
######################### CHECK OPERATION END #########################
####################### CHECK OPERATION SUMMARY #######################
Oracle Home selected for deinstall is: /u01/app/oracle/11.2.0/11gR24
Inventory Location where the Oracle home registered is: /u01/app/oraInventory
No Enterprise Manager configuration to be updated for any database(s)
No Enterprise Manager ASM targets to update
No Enterprise Manager listener targets to migrate
Checking the config status for CCR
Oracle Home exists with CCR directory, but CCR is not configured
CCR check is finished
Do you want to continue (y - yes, n - no)? [n]: y
A log of this session will be written to: '/u01/app/oraInventory/logs/deinstall_deconfig2014-04-26_11-54-45-AM.out'
Any error messages from this session will be written to: '/u01/app/oraInventory/logs/deinstall_deconfig2014-04-26_11-54-45-AM.err'
######################## CLEAN OPERATION START ########################
Enterprise Manager Configuration Assistant START
EMCA de-configuration trace file location: /u01/app/oraInventory/logs/emcadc_clean2014-04-26_11-55-31-AM.log
Updating Enterprise Manager ASM targets (if any)
Updating Enterprise Manager listener targets (if any)
Enterprise Manager Configuration Assistant END
Database de-configuration trace file location: /u01/app/oraInventory/logs/databasedc_clean2014-04-26_11-55-39-AM.log
Network Configuration clean config START
Network de-configuration trace file location: /u01/app/oraInventory/logs/netdc_clean2014-04-26_11-55-40-AM.log
De-configuring backup files...
Backup files de-configured successfully.
The network configuration has been cleaned up successfully.
Network Configuration clean config END
Oracle Configuration Manager clean START
OCM clean log file location : /u01/app/oraInventory/logs//ocm_clean3157.log
Oracle Configuration Manager clean END
Setting the force flag to false
Setting the force flag to cleanup the Oracle Base
Oracle Universal Installer clean START
Detach Oracle home '/u01/app/oracle/11.2.0/11gR24' from the central inventory on the local node : Done
Delete directory '/u01/app/oracle/11.2.0/11gR24' on the local node : Done
The Oracle Base directory '/u01/app/oracle' will not be removed on local node. The directory is in use by Oracle Home '/u01/app/oracle/11.2.0/11gR2'.
Oracle Universal Installer cleanup was successful.
Oracle Universal Installer clean END
## [START] Oracle install clean ##
Clean install operation removing temporary directory '/tmp/deinstall2014-04-26_11-54-17AM' on node 'dbtrmrk'
## [END] Oracle install clean ##
######################### CLEAN OPERATION END #########################
####################### CLEAN OPERATION SUMMARY #######################
Cleaning the config for CCR
As CCR is not configured, so skipping the cleaning of CCR configuration
CCR clean is finished
Successfully detached Oracle home '/u01/app/oracle/11.2.0/11gR24' from the central inventory on the local node.
Successfully deleted directory '/u01/app/oracle/11.2.0/11gR24' on the local node.
Oracle Universal Installer cleanup was successful.
Oracle deinstall tool successfully cleaned up temporary directories.
#######################################################################
############# ORACLE DEINSTALL & DECONFIG TOOL END #############
Enjoy.................Abid Malik
No comments:
Post a Comment