Oracle 11g R2 Upgrade 112010 to 112040

Direct upgrades are for version

11.1.0.7
11.2..0.2
above are direct upgrade to 12.1.0.1

rest need patches to be applied first

Direct upgrade 

1 )Inplace upgrade will have same oracle home, this is more error prone
2)Outplace upgrade have : different oracle home, this is preffered

Upgrade using DBUA or Manual

Indirect Upgrade

Migrate using datapump utility
Transportable space
Golden Gate replication
=============================================================



date
11.2.0.1 to 11.2.0.4 using outerplace method

cat /etc/oracle-release
uname -r
uname -p

cat /etc/oratab
primedb:/u01/app/oracle/product/11.2.0/dbhome_1:N

look at oraInst.loc file

primedb :/u01/app/oracle/product/11.2.0/dbHome_1/oraInst.loc
this contain oracle inventory group name
inventory_loc=/u01/app/oraInventory
inst_group=oinstall

cat /u01/app/oracle/product/11.2.0/dbHome_1/oraInst.loc
this contain all previously installed locations


ps -ef|grep -i smon

. oraen
primedb

lsnrctl status
look for listener version

emctl status dbconsole

connect to databae

sqlplus / as sysdba

SQL>select instance_name, host_name, version, status fromv$instance;

SQL>select comp_name,version, status from dba_registry ORDER BY status;

exit

download and house software in /software/downloads/

ls -lh /software/downloads/db_112040_diskk1.zip
        unzip db_112040_diskk1.zip
        unzip db_112040_diskk2.zip

CREATE NEW ORACLE HOME

mkdir -p /u01/app/oracle/product/11.2.0/dbHome_2

cd  /u01/app/oracle/product/11.2.0/

ll



cd /software/downloads/db_112040

cd database
database]$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbHome_2

 ./runInstaller
 next
skipsoftare updates

Install database softare only

single Instance Installation Only

English

Enterprize edition
select option oracle partioning,and disable
net
oracle Base=/u01/app/oracle
Software location=/u01/app/oracle/product/11.2.0/dbHome_2
next
dba
oper
next
ignore waring if swap
save response file

filename /u01/app/oracle/dbinstall_112040.rsp

start Installation
run root installer
/u01/app/oracle/product/11.2.0/dbHome_2/root.sh

open another termininal connect as root user

cd /u01/app/oracle/product/11.2.0/dbHome_2/
./root.sh
y
y

RETURN ORACLE INSTALLER AND CLICK OK

completed installing database software


STARTING DATABASE UPGRADE ASSISTANT

CD /u01/app/oracle/product/11.2.0/dbHome_2/bin/dbua &
or just

/u01/app/oracle/product/11.2.0/dbHome_2/bin/dbua &

DBUA BEGINS

NET
SELECT DATABASE NAME (primedb)

NEXT

LOOK FOR WARNING AND
1)warning related to Network ACL
2)warning related to database statistics
3)related to event intialazation parameter


ignore and continue with uprgade


YES

DBUA  will  RECOMPILE INVALED OBJECT
select degree eqall to 4


CHECK TO  UPGRADE TIMEZONE


CHECK T0 SELECT BACKUP

CREATE FOLDER FOR DATABASE BACKUP AND POINT
/u02/app/oradata/primedb/backup
open another window
mkdir -p /u02/app/oradata/primedb/backup

PROCEED NEXT STEP

chose not to Move data base files during upgrade option

NEXT
configure fra

database upgrade summary report will be displayed

DBUA will start database upgrade





database upgrade is complete

close database upgrade assistant

check database backup performed
ls -lh  /u02/app/oradata/primedb/backup/




look at cat /etc/oratab
primedb:/u01/app/oracle/product/11.4.0/dbhome_1:N
it should point to new oracle home

look at inventory.xml file should contains entries for both oracle home
cd
cat /u01/app/oraInvetory/contentsXML/inventory.xml

should contains inventory for 11.2.0.1 and 11.2.0.4

cat /u01/app/oracle/product/11.2.0/dbHome_1/oraInst.loc


copy from old oracle home to new oracle home


COPY LISTENER.ORA  FROM OLDER ORACLE HOME TO NEW ORACLE HOME
cp /u01/app/oracle/product/11.2.0/dbHome_1/network/admin/listener.ora
/u01/app/oracle/product/11.2.0/dbHome_2/network/admin/listener.ora

COPY TNSNAMES..ORA  FROM OLDER ORACLE HOME TO NEW ORACLE HOME
cp /u01/app/oracle/product/11.2.0/dbHome_1/network/admin/tnsnames.ora
/u01/app/oracle/product/11.2.0/dbHome_2/network/admin/tnsnames.ora


ps -ef|grep -i smon

SET UP ORACLE
. oraenv
.
echo $ORACLE_HOME
it should point to dbhome2

lsnrctl stop

lsnnrctl status

check listener version

it should run from new  oracle home

check status of  enterprize manager console

emctl status dbconsole

connect to database


sqlpllus / as sysdba
select


SQL>select instance_name, host_name, version, status fromv$instance;

SQL>
SQL>select comp_name,version, status from dba_registry;
SQL>select comp_name,version, status from dba_registry where status <>'VALID';
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';


EXIT;
=========================================================================
DEISTAL OLD VERSION OF SOFTWARE AFTER SATISHFACTION

cd /u01/app/oracle/product/11.2.0/dbHome_1/deinstall

./deinstall
y

.oraenv
primedb
lsnrctl status
lsnrctl start
lsnrctl status
emctl status dbconsole
sqlplus / as sysdab
SQL>select name,open_mode from v$database;
SQL>select instance_name,host_name, version, status from v$instance;