===================================================
PROJECT: UPGRADE Physical Standby from 11gR2 To 12c
===================================================
#######################################
Current Physical Standby configuration
#######################################
====================
System Information
====================
[oracle@dbstandby ~]$ date
Sat Apr 26 06:22:31 EDT 2014
[oracle@dbstandby ~]$ cat /etc/oracle-release
Oracle Linux Server release 6.4
[oracle@dbstandby ~]$ uname -r
2.6.39-400.209.1.el6uek.x86_64
[oracle@dbstandby ~]$ uname -p
x86_64
====================
Oracle SID,Home,Base
====================
[oracle@dbstandby ~]$ echo $ORACLE_HOME
/u01/app/oracle/11.2.0/11gR24
[oracle@dbstandby ~]$ echo $ORACLE_SID
dbstandby
[oracle@dbstandby ~]$ echo $ORACLE_BASE
/u01/app/oracle
[oracle@dbstandby ~]$
====================
Oracle Inventory
====================
[oracle@dbstandby ~]$ cat /u01/app/oracle/11.2.0/11gR24/oraInst.loc
inventory_loc=/u01/app/oraInventory
inst_group=oinstall
[oracle@dbstandby ~]$ 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@dbstandby ~]$ 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/dbstandby/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbstandby.localdomain)(PORT=1521)))
Services Summary...
Service "dbstandby" has 1 instance(s).
Instance "dbstandby", status READY, has 1 handler(s) for this service...
The command completed successfully
=========
OraTab
=========
[oracle@dbstandby ~]$ cat /etc/oratab
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
dbstandby:/u01/app/oracle/11.2.0/11gR24:N
============================
Oracle Envrionemnt Variables
=============================
[oracle@dbstandby ~]$ 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=dbstandby
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
---------- -------------------- --------------- ----------
dbstandby dbstandby.localdomain 11.2.0.4.0 MOUNTED
===========================
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=dbstandby
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 on Physical Standby Server
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. Modify environmental variables
7. Modify /etc/oratab file manually
8. copy the Listener & tnsnames to new ORACLE_HOHME
9. Copy init.ora & pwd file to new ORACLE_HOME
10. Start Standby from new ORACLE_HOME
11. Start Redo Apply Process
12. Monitor the Redo Apply Process
13. Open Physical Standby and verify upgrade
===============================
1. Download Oracle 12c software
===============================
[oracle@dbstandby db_1201]$ pwd
/tmp/db_1201
[oracle@dbstandby 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@dbstandby db_1201]$ unzip /tmp/linuxamd64_12c_database_1of2.zip -d /tmp/db_1201
[oracle@dbstandby db_1201]$ unzip /tmp/linuxamd64_12c_database_2of2.zip -d /tmp/db_1201
===============================
3.Create new ORACLE_HOME for 12c
===============================
[root@dbstandby ~]# mkdir /u02
[root@dbstandby ~]# chown -R oracle:oinstall /u02
[root@dbstandby ~]# chmod -R 775 /u02
[root@dbstandby ~]# su - oracle
[oracle@dbstandby ~]$ mkdir -p /u02/app/oracle/12.1.0/12cR1
[oracle@dbstandby 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@dbstandby response]$ pwd
/tmp/db_1201/database/response
[oracle@dbstandby 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@dbstandby 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@dbstandby response]$ export ORACLE_HOME=/u02/app/oracle/12.1.0/12cR1
[oracle@dbstandby database]$ ls
install response rpm runInstaller sshsetup stage welcome.html
[oracle@dbstandby ~]$ /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 see the process running as:
[root@dbstandby ~]# ps -ef | grep oui
oracle 2308 2299 20 05:51 pts/0 00:00:01 /tmp/db_1201/database/install/.oui -silent -responseFile /tmp/db_1201/database/response/db_12c_install.rsp -J-Doracle.install.setup.workDir=/tmp/db_1201/database/response
Note: We can do the tail on the log file while OUI is running in silent mode:
[oracle@dbstandby ~]$ 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
Successfully Setup Software.
[oracle@dbstandby ~]$ su -
Password:
[root@dbstandby ~]# /u02/app/oracle/12.1.0/12cR1/root.sh
Check /u02/app/oracle/12.1.0/12cR1/install/root_dbstandby.localdomain_2014-04-26_08-23-34.log for the output of root script
[root@dbstandby ~]# cat /u02/app/oracle/12.1.0/12cR1/install/root_dbstandby.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@dbstandby ~]#
=================================
6. Modify environmental variables
=================================
Note: Modify the ORACLE_HOME value to new ORACLE_HOME
[oracle@dbstandby ~]$ 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=dbstandby
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"
====================================
7. Modify /etc/oratab file manually
====================================
Note: Since on Physical Standby we do not run DBUA, so we need to manually modify this file
[oracle@dbstandby ~]$ cat /etc/oratab
dbstandby:/u02/app/oracle/12.1.0/12cR1:N
=================================================
8.Copy listener and tnsnames to new ORACLE_HOME
=================================================
[oracle@dbstandby ~]$ cp /u01/app/oracle/11.2.0/11gR24/network/admin/listener.ora /u02/app/oracle/12.1.0/12cR1/network/admin
[oracle@dbstandby ~]$ cp /u01/app/oracle/11.2.0/11gR24/network/admin/tnsnames.ora /u02/app/oracle/12.1.0/12cR1/network/admin
[oracle@dbstandby ~]$ 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@dbstandby ~]$ 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@dbstandby ~]$ cd /u02/app/oracle/12.1.0/12cR1/bin
[oracle@dbstandby 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/dbstandby/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbstandby.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/dbstandby/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbstandby.localdomain)(PORT=1521)))
Services Summary...
Service "dbstandby" has 1 instance(s).
Instance "dbstandby", status READY, has 1 handler(s) for this service...
Service "dbstandbyXDB" has 1 instance(s).
Instance "dbstandby", status READY, has 1 handler(s) for this service...
The command completed successfully
==============================================
9. Copy init.ora & pwd file to new ORACLE_HOME
==============================================
[oracle@dbstandby admin]$ mv /u01/app/oracle/11.2.0/11gR24/dbs/spfilestandby.ora $ORACLE_HOME/dbs/
[oracle@dbstandby admin]$ mv /u01/app/oracle/11.2.0/11gR24/dbs/orapwdstandby $ORACLE_HOME/dbs/
======================================
10. Start Standby from new ORACLE_HOME
======================================
SQL*Plus: Release 12.1.0.1.0 Production on Sun Apr 27 06:37:24 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 801701888 bytes
Fixed Size 2293496 bytes
Variable Size 268435720 bytes
Database Buffers 524288000 bytes
Redo Buffers 6684672 bytes
SQL> alter database mount;
Database altered.
============================
11. Start Redo Apply Process
=============================
SQL> alter system set log_archive_dest_state_2='enable' scope=both;
System altered.
SQL> alter database recover managed standby database disconnect from session;
Database altered.
===================================
12. Monitor the Redo Apply Process
===================================
[root@dbstandby ~]# ps -ef | grep mrp
oracle 8324 1 26 06:39 ? 00:00:01 ora_mrp0_dbstandby
Note: When Media Recovery start at standby, MRP background process starts.
Alert.log file
RFS[5]: Opened log for thread 1 sequence 114 dbid 863520319 branch 826799617
RFS[6]: Opened log for thread 1 sequence 116 dbid 863520319 branch 826799617
Sun Apr 27 06:49:48 2014
Archived Log entry 109 added for thread 1 sequence 114 rlc 826799617 ID 0x3377fe3f dest 2:
Sun Apr 27 06:49:51 2014
Archived Log entry 110 added for thread 1 sequence 116 rlc 826799617 ID 0x3377fe3f dest 2:
RFS[6]: Opened log for thread 1 sequence 118 dbid 863520319 branch 826799617
RFS[5]: Opened log for thread 1 sequence 117 dbid 863520319 branch 826799617
Note: Run the below on Production to check the sequence#
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/arch
Oldest online log sequence 200
Next log sequence to archive 202
Current log sequence 202
on standby
Media Recovery Waiting for thread 1 sequence 202 (in transit)
Sun Apr 27 07:17:30 2014
Recovery of Online Redo Log: Thread 1 Group 4 Seq 202 Reading mem 0
Mem# 0: /u01/app/oracle/dbdata/dbstandby/standlog1.log
SQL> select process,status from v$managed_standby;
PROCESS STATUS
--------- ------------
ARCH CONNECTED
ARCH CONNECTED
ARCH CLOSING
ARCH CONNECTED
RFS IDLE
RFS IDLE
RFS IDLE
MRP0 APPLYING_LOG
RFS IDLE
!!!ALL CAUGHT UP !!!
============================================
13. Open Physical Standby and verify upgrade
============================================
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Database altered.
SQL> ALTER DATABASE OPEN READ ONLY;
Database altered.
SQL> select instance_name,version,status from v$instance;
INSTANCE_NAME VERSION STATUS
---------------- ----------------- ------------
dbstandby 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
SQL>select comp_name,version,status from dba_registry;
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) : 'dbstandby.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 'dbstandby'
## [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 Physical Standby from 11gR2 To 12c
===================================================
#######################################
Current Physical Standby configuration
#######################################
====================
System Information
====================
[oracle@dbstandby ~]$ date
Sat Apr 26 06:22:31 EDT 2014
[oracle@dbstandby ~]$ cat /etc/oracle-release
Oracle Linux Server release 6.4
[oracle@dbstandby ~]$ uname -r
2.6.39-400.209.1.el6uek.x86_64
[oracle@dbstandby ~]$ uname -p
x86_64
====================
Oracle SID,Home,Base
====================
[oracle@dbstandby ~]$ echo $ORACLE_HOME
/u01/app/oracle/11.2.0/11gR24
[oracle@dbstandby ~]$ echo $ORACLE_SID
dbstandby
[oracle@dbstandby ~]$ echo $ORACLE_BASE
/u01/app/oracle
[oracle@dbstandby ~]$
====================
Oracle Inventory
====================
[oracle@dbstandby ~]$ cat /u01/app/oracle/11.2.0/11gR24/oraInst.loc
inventory_loc=/u01/app/oraInventory
inst_group=oinstall
[oracle@dbstandby ~]$ 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@dbstandby ~]$ 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/dbstandby/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbstandby.localdomain)(PORT=1521)))
Services Summary...
Service "dbstandby" has 1 instance(s).
Instance "dbstandby", status READY, has 1 handler(s) for this service...
The command completed successfully
=========
OraTab
=========
[oracle@dbstandby ~]$ cat /etc/oratab
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
dbstandby:/u01/app/oracle/11.2.0/11gR24:N
============================
Oracle Envrionemnt Variables
=============================
[oracle@dbstandby ~]$ 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=dbstandby
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
---------- -------------------- --------------- ----------
dbstandby dbstandby.localdomain 11.2.0.4.0 MOUNTED
===========================
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=dbstandby
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 on Physical Standby Server
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. Modify environmental variables
7. Modify /etc/oratab file manually
8. copy the Listener & tnsnames to new ORACLE_HOHME
9. Copy init.ora & pwd file to new ORACLE_HOME
10. Start Standby from new ORACLE_HOME
11. Start Redo Apply Process
12. Monitor the Redo Apply Process
13. Open Physical Standby and verify upgrade
===============================
1. Download Oracle 12c software
===============================
[oracle@dbstandby db_1201]$ pwd
/tmp/db_1201
[oracle@dbstandby 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@dbstandby db_1201]$ unzip /tmp/linuxamd64_12c_database_1of2.zip -d /tmp/db_1201
[oracle@dbstandby db_1201]$ unzip /tmp/linuxamd64_12c_database_2of2.zip -d /tmp/db_1201
===============================
3.Create new ORACLE_HOME for 12c
===============================
[root@dbstandby ~]# mkdir /u02
[root@dbstandby ~]# chown -R oracle:oinstall /u02
[root@dbstandby ~]# chmod -R 775 /u02
[root@dbstandby ~]# su - oracle
[oracle@dbstandby ~]$ mkdir -p /u02/app/oracle/12.1.0/12cR1
[oracle@dbstandby 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@dbstandby response]$ pwd
/tmp/db_1201/database/response
[oracle@dbstandby 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@dbstandby 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@dbstandby response]$ export ORACLE_HOME=/u02/app/oracle/12.1.0/12cR1
[oracle@dbstandby database]$ ls
install response rpm runInstaller sshsetup stage welcome.html
[oracle@dbstandby ~]$ /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 see the process running as:
[root@dbstandby ~]# ps -ef | grep oui
oracle 2308 2299 20 05:51 pts/0 00:00:01 /tmp/db_1201/database/install/.oui -silent -responseFile /tmp/db_1201/database/response/db_12c_install.rsp -J-Doracle.install.setup.workDir=/tmp/db_1201/database/response
Note: We can do the tail on the log file while OUI is running in silent mode:
[oracle@dbstandby ~]$ 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
Successfully Setup Software.
[oracle@dbstandby ~]$ su -
Password:
[root@dbstandby ~]# /u02/app/oracle/12.1.0/12cR1/root.sh
Check /u02/app/oracle/12.1.0/12cR1/install/root_dbstandby.localdomain_2014-04-26_08-23-34.log for the output of root script
[root@dbstandby ~]# cat /u02/app/oracle/12.1.0/12cR1/install/root_dbstandby.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@dbstandby ~]#
=================================
6. Modify environmental variables
=================================
Note: Modify the ORACLE_HOME value to new ORACLE_HOME
[oracle@dbstandby ~]$ 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=dbstandby
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"
====================================
7. Modify /etc/oratab file manually
====================================
Note: Since on Physical Standby we do not run DBUA, so we need to manually modify this file
[oracle@dbstandby ~]$ cat /etc/oratab
dbstandby:/u02/app/oracle/12.1.0/12cR1:N
=================================================
8.Copy listener and tnsnames to new ORACLE_HOME
=================================================
[oracle@dbstandby ~]$ cp /u01/app/oracle/11.2.0/11gR24/network/admin/listener.ora /u02/app/oracle/12.1.0/12cR1/network/admin
[oracle@dbstandby ~]$ cp /u01/app/oracle/11.2.0/11gR24/network/admin/tnsnames.ora /u02/app/oracle/12.1.0/12cR1/network/admin
[oracle@dbstandby ~]$ 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@dbstandby ~]$ 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@dbstandby ~]$ cd /u02/app/oracle/12.1.0/12cR1/bin
[oracle@dbstandby 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/dbstandby/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbstandby.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/dbstandby/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbstandby.localdomain)(PORT=1521)))
Services Summary...
Service "dbstandby" has 1 instance(s).
Instance "dbstandby", status READY, has 1 handler(s) for this service...
Service "dbstandbyXDB" has 1 instance(s).
Instance "dbstandby", status READY, has 1 handler(s) for this service...
The command completed successfully
==============================================
9. Copy init.ora & pwd file to new ORACLE_HOME
==============================================
[oracle@dbstandby admin]$ mv /u01/app/oracle/11.2.0/11gR24/dbs/spfilestandby.ora $ORACLE_HOME/dbs/
[oracle@dbstandby admin]$ mv /u01/app/oracle/11.2.0/11gR24/dbs/orapwdstandby $ORACLE_HOME/dbs/
======================================
10. Start Standby from new ORACLE_HOME
======================================
SQL*Plus: Release 12.1.0.1.0 Production on Sun Apr 27 06:37:24 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 801701888 bytes
Fixed Size 2293496 bytes
Variable Size 268435720 bytes
Database Buffers 524288000 bytes
Redo Buffers 6684672 bytes
SQL> alter database mount;
Database altered.
============================
11. Start Redo Apply Process
=============================
SQL> alter system set log_archive_dest_state_2='enable' scope=both;
System altered.
SQL> alter database recover managed standby database disconnect from session;
Database altered.
===================================
12. Monitor the Redo Apply Process
===================================
[root@dbstandby ~]# ps -ef | grep mrp
oracle 8324 1 26 06:39 ? 00:00:01 ora_mrp0_dbstandby
Note: When Media Recovery start at standby, MRP background process starts.
Alert.log file
RFS[5]: Opened log for thread 1 sequence 114 dbid 863520319 branch 826799617
RFS[6]: Opened log for thread 1 sequence 116 dbid 863520319 branch 826799617
Sun Apr 27 06:49:48 2014
Archived Log entry 109 added for thread 1 sequence 114 rlc 826799617 ID 0x3377fe3f dest 2:
Sun Apr 27 06:49:51 2014
Archived Log entry 110 added for thread 1 sequence 116 rlc 826799617 ID 0x3377fe3f dest 2:
RFS[6]: Opened log for thread 1 sequence 118 dbid 863520319 branch 826799617
RFS[5]: Opened log for thread 1 sequence 117 dbid 863520319 branch 826799617
Note: Run the below on Production to check the sequence#
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/arch
Oldest online log sequence 200
Next log sequence to archive 202
Current log sequence 202
on standby
Media Recovery Waiting for thread 1 sequence 202 (in transit)
Sun Apr 27 07:17:30 2014
Recovery of Online Redo Log: Thread 1 Group 4 Seq 202 Reading mem 0
Mem# 0: /u01/app/oracle/dbdata/dbstandby/standlog1.log
SQL> select process,status from v$managed_standby;
PROCESS STATUS
--------- ------------
ARCH CONNECTED
ARCH CONNECTED
ARCH CLOSING
ARCH CONNECTED
RFS IDLE
RFS IDLE
RFS IDLE
MRP0 APPLYING_LOG
RFS IDLE
!!!ALL CAUGHT UP !!!
============================================
13. Open Physical Standby and verify upgrade
============================================
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Database altered.
SQL> ALTER DATABASE OPEN READ ONLY;
Database altered.
SQL> select instance_name,version,status from v$instance;
INSTANCE_NAME VERSION STATUS
---------------- ----------------- ------------
dbstandby 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
SQL>select comp_name,version,status from dba_registry;
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) : 'dbstandby.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 'dbstandby'
## [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