Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

upgrade oracle from10g to 11g prerequest and postrequest


Oracle 10g database is upgrade to oracle 11g database.This upgrade support from 10.2.0.4.0 to 11.1.0.6.0 version only.
Step -1
Pre Request
1. Check the database version.
SQL> select * from v$version;
BANNER
—————————————————————-
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – Prod
PL/SQL Release 10.2.0.4.0 – Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 – Production
NLSRTL Version 10.2.0.4.0 – Production

2. Check the packages validity.
SQL> select comp_name, version, status from sys.dba_registry;
COMP_NAME VERSION STATUS
———————————————– ———— ——
Oracle Database Catalog Views 10.2.0.4.0 VALID
Oracle Database Packages and Types 10.2.0.4.0 VALID
2 rows selected.

3. Check whether objects are valid
SQL> select object_name,status from dba_objects
where status='INVALID';
no rows selected.


4. Check whether any datafile is in backup mode
SQL> select * from v$backup where status='ACTIVE';
FILE# STATUS CHANGE# TIME
--------- ---------------- ------------------
1 NOT ACTIVE 0
2 NOT ACTIVE 0
3 NOT ACTIVE 0

5.check whether any datafiles is in recovery state
SQL> select * from v$recover_file;
no rows selected.

5. Stop the listener
lsnrctl> stop listener

Step -2
1)create 11g directory and new 11g bash profile and set it.

mkdir -p /u01/app/oracle/product/11.1.0/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=ten.localdomain; export ORACLE_HOSTNAME
ORACLE_UNQNAME=DB11G; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME
ORACLE_SID=DB11G; export ORACLE_SID
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

2)no need to shutdown 10.2.0.4.0 db

3)install 11gr1 using other terminal
database]$./runInstaller

4) go to 10.2.0.4.0 terminal
[oracle@teng ~]$ . .10g_profile
[oracle@teng ~]$ export ORACLE_SID=kfc
[oracle@teng ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Aug 11 10:52:45 2016

4.1)This utlu111i.sql script check the database and list requirements to upgrade.
SQL> spool db10g

SQL> @/u01/app/oracle/product/11.1.0/db_1/rdbms/admin/utlu111i.sql

SQL> spool off


4.2) create pfile in $ORACLE_HOME/dbs location

SQL>create pfile='/u01/app/oracle/product/11.1.0/db_1/dbs/initkfc.ora' from spfile;

4.3) Edit the parameter in pfile with upgrade requirements
     change this background_dump_dest='/home/oracle/kfc/admin/bdump' to
                diagnostic_dest='/home/oracle/kfc/admin/diag/'
                 remove cdump and udump

5. Shut 10.2.0.4.0  the database and services (stop css if using asm) for Upgrade
SQL> shutdown immediate ;
Database closed.
Database dismounted.
ORACLE instance shut down.

TO UPGRADE
1. run a new 11g bash profile and set it.
. .bash_profile


2. Start the database with Upgrade option (if using asm start asm instance and css)
sqlplus sys/*** as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on Tue Apr 27 09:50:25 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to an idle instance.

SQL> startup upgrade;
ORACLE instance started.
Total System Global Area 534462464 bytes
Fixed Size 2146112 bytes
Variable Size 150995136 bytes
Database Buffers 377487360 bytes
Redo Buffers 3833856 bytes
Database mounted.
Database opened.


3. Run this script for database upgradataion
SQL> @?/rdbms/admin/catupgrd.sql

POST UPGRADE REQUEST

1. Check status of database components
SQL> select comp_name,version, status from dba_registry
COMP_NAME VERSION STATUS
---------------------------------------- ------------------------------ ---------------
Oracle Enterprise Manager 11.1.0.6.0 VALID
OLAP Catalog 11.1.0.6.0 VALID


2. Check for invalid objects
SQL> select count(*) from dba_objects where status like 'INVALID';
COUNT(*)
----------
0

3.Run this script to verify the database upgrade
@?/rdbms/admin/utlu111s.sql


4. Restart the database normally and start the listener.
SQL> shut immediate

lsnrctl> start listener

SQL> startup




Comments

Popular posts from this blog

PostgreSQL Pgbadger Installation On Linux

PostgreSQL pgBadger

How to configure Replication Manager (repmgr) ?

Postgresql Database Tutorial android app

PostgreSQL Sequence