Upgrade Oracle 10g from 10.2.0.1 to 10.2.0.4 (Single Instance)
Before database upgrade it is recommanded to backup the PRODUCTION database.
1. Stop all services of oracle
[oracle@ittestdb ~]$ echo $ORACLE_BASE/u01/app/oracle
[oracle@ittestdb ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/10.2.0/db_1
[oracle@ittestdb ~]$ echo $ORACLE_SID orcl
[oracle@ittestdb ~]$
[oracle@ittestdb ~]$ emctl stop dbconsole
TZ set to Asia/Baghdad
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.http://ittestdb.amardhaka.com:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control …
… Stopped.
[oracle@ittestdb ~]$ isqlplusctl stopiSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Stopping iSQL*Plus …
iSQL*Plus stopped.
[oracle@ittestdb ~]$
[oracle@ittestdb ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/10.2.0/db_1
[oracle@ittestdb ~]$ echo $ORACLE_SID orcl
[oracle@ittestdb ~]$
[oracle@ittestdb ~]$ emctl stop dbconsole
TZ set to Asia/Baghdad
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.http://ittestdb.amardhaka.com:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control …
… Stopped.
[oracle@ittestdb ~]$ isqlplusctl stopiSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Stopping iSQL*Plus …
iSQL*Plus stopped.
[oracle@ittestdb ~]$
[oracle@ittestdb ~]$ lsnrctl stop
LSNRCTL for Linux: Version 10.2.0.1.0 – Production on 08-FEB-2010 13:17:18
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully
[oracle@ittestdb ~]$ sqlplus “/as sysdba”
The command completed successfully
[oracle@ittestdb ~]$ sqlplus “/as sysdba”
SQL*Plus: Release 10.2.0.1.0 – Production on Mon Feb 8 13:17:29 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, OLAP and Data Mining options
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, OLAP and Data Mining options
[oracle@ittestdb ~]$ ps -ef|grep oracleroot 13754 32094 0 13:13 pts/1 00:00:00 su – oracle
oracle 13755 13754 0 13:13 pts/1 00:00:00 -bash
oracle 14525 13755 0 13:18 pts/1 00:00:00 ps -ef
oracle 14526 13755 0 13:18 pts/1 00:00:00 grep oracle
[oracle@ittestdb ~]$
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, OLAP and Data Mining options
[oracle@ittestdb ~]$ ps -ef|grep oracleroot 13754 32094 0 13:13 pts/1 00:00:00 su – oracle
oracle 13755 13754 0 13:13 pts/1 00:00:00 -bash
oracle 14525 13755 0 13:18 pts/1 00:00:00 ps -ef
oracle 14526 13755 0 13:18 pts/1 00:00:00 grep oracle
[oracle@ittestdb ~]$
Step 2: Install the Database Patch Set
[oracle@ittestdb ~]$ export DISPLAY=10.13.5.95:0.0
[oracle@ittestdb ~]$ /u01/stage/patch/Disk1/runInstaller
Starting Oracle Universal Installer…
[oracle@ittestdb ~]$ /u01/stage/patch/Disk1/runInstaller
Starting Oracle Universal Installer…
Checking installer requirements…
Checking
operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4,
redhat-5, UnitedLinux-1.0, asianux-1, asianux-2 or asianux-3
Passed
Passed
All installer requirements met.
Preparing
to launch Oracle Universal Installer from
/tmp/OraInstall2010-02-08_01-22-19PM. Please wait …[oracle@ittestdb ~]$
Oracle Universal Installer, Version 10.2.0.4.0 Production
Copyright (C) 1999, 2008, Oracle. All rights reserved.
Copyright (C) 1999, 2008, Oracle. All rights reserved.
[oracle@ittestdb ~]$
Step 3 : Upgrade Database
[oracle@ittestdb ~]$ ps -ef|grep oracle
root 13754 32094 0 13:13 pts/1 00:00:00 su – oracle
oracle 13755 13754 0 13:13 pts/1 00:00:00 -bash
oracle 18304 13755 0 13:28 pts/1 00:00:00 ps -ef
oracle 18305 13755 0 13:28 pts/1 00:00:00 grep oracle
[oracle@ittestdb ~]$ sqlplus “/as sysdba”
root 13754 32094 0 13:13 pts/1 00:00:00 su – oracle
oracle 13755 13754 0 13:13 pts/1 00:00:00 -bash
oracle 18304 13755 0 13:28 pts/1 00:00:00 ps -ef
oracle 18305 13755 0 13:28 pts/1 00:00:00 grep oracle
[oracle@ittestdb ~]$ sqlplus “/as sysdba”
SQL*Plus: Release 10.2.0.4.0 – Production on Mon Feb 8 13:28:53 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> STARTUP UPGRADE
ORACLE instance started.
ORACLE instance started.
Total System Global Area 1224736768 bytes
Fixed Size 1267188 bytes
Variable Size 318769676 bytes
Database Buffers 889192448 bytes
Redo Buffers 15507456 bytes
Database mounted.
Database opened.
SQL>
Fixed Size 1267188 bytes
Variable Size 318769676 bytes
Database Buffers 889192448 bytes
Redo Buffers 15507456 bytes
Database mounted.
Database opened.
SQL>
SQL> STARTUP UPGRADEORACLE instance started.
Total System Global Area 1224736768 bytes
Fixed Size 1267188 bytes
Variable Size 318769676 bytes
Database Buffers 889192448 bytes
Redo Buffers 15507456 bytes
Database mounted.
Database opened.
SQL> SPOOL /u01/stage/patch/Disk1/upgrade_info.log SQL> @?/rdbms/admin/utlu102i.sql
Oracle Database 10.2 Upgrade Information Utility 02-08-2010 13:30:50
.
**********************************************************************
Database:
**********************************************************************
–> name: ORCL
–> version: 10.2.0.1.0
–> compatible: 10.2.0.1.0
–> blocksize: 8192
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
–> SYSTEM tablespace is adequate for the upgrade.
…. minimum required size: 488 MB
…. AUTOEXTEND additional space required: 8 MB
–> UNDOTBS1 tablespace is adequate for the upgrade.
…. minimum required size: 400 MB
…. AUTOEXTEND additional space required: 370 MB
–> SYSAUX tablespace is adequate for the upgrade.
…. minimum required size: 246 MB
…. AUTOEXTEND additional space required: 16 MB
–> TEMP tablespace is adequate for the upgrade.
…. minimum required size: 58 MB
…. AUTOEXTEND additional space required: 38 MB
–> EXAMPLE tablespace is adequate for the upgrade.
…. minimum required size: 69 MB
.
**********************************************************************
Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
– No update parameter changes are required.
.
**********************************************************************
Renamed Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
– No renamed parameters found. No changes are required.
.
**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
– No obsolete parameters found. No changes are required
.
**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
–> Oracle Catalog Views [upgrade] VALID
–> Oracle Packages and Types [upgrade] VALID
–> JServer JAVA Virtual Machine [upgrade] VALID
–> Oracle XDK for Java [upgrade] VALID
–> Oracle Java Packages [upgrade] VALID
–> Oracle Text [upgrade] VALID
–> Oracle XML Database [upgrade] VALID
–> Oracle Workspace Manager [upgrade] VALID
–> Oracle Data Mining [upgrade] VALID
–> OLAP Analytic Workspace [upgrade] VALID
–> OLAP Catalog [upgrade] VALID
–> Oracle OLAP API [upgrade] VALID
–> Oracle interMedia [upgrade] VALID
–> Spatial [upgrade] VALID
–> Expression Filter [upgrade] VALID
–> EM Repository [upgrade] VALID
–> Rule Manager [upgrade] VALID
.
Fixed Size 1267188 bytes
Variable Size 318769676 bytes
Database Buffers 889192448 bytes
Redo Buffers 15507456 bytes
Database mounted.
Database opened.
SQL> SPOOL /u01/stage/patch/Disk1/upgrade_info.log SQL> @?/rdbms/admin/utlu102i.sql
Oracle Database 10.2 Upgrade Information Utility 02-08-2010 13:30:50
.
**********************************************************************
Database:
**********************************************************************
–> name: ORCL
–> version: 10.2.0.1.0
–> compatible: 10.2.0.1.0
–> blocksize: 8192
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
–> SYSTEM tablespace is adequate for the upgrade.
…. minimum required size: 488 MB
…. AUTOEXTEND additional space required: 8 MB
–> UNDOTBS1 tablespace is adequate for the upgrade.
…. minimum required size: 400 MB
…. AUTOEXTEND additional space required: 370 MB
–> SYSAUX tablespace is adequate for the upgrade.
…. minimum required size: 246 MB
…. AUTOEXTEND additional space required: 16 MB
–> TEMP tablespace is adequate for the upgrade.
…. minimum required size: 58 MB
…. AUTOEXTEND additional space required: 38 MB
–> EXAMPLE tablespace is adequate for the upgrade.
…. minimum required size: 69 MB
.
**********************************************************************
Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
– No update parameter changes are required.
.
**********************************************************************
Renamed Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
– No renamed parameters found. No changes are required.
.
**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
– No obsolete parameters found. No changes are required
.
**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
–> Oracle Catalog Views [upgrade] VALID
–> Oracle Packages and Types [upgrade] VALID
–> JServer JAVA Virtual Machine [upgrade] VALID
–> Oracle XDK for Java [upgrade] VALID
–> Oracle Java Packages [upgrade] VALID
–> Oracle Text [upgrade] VALID
–> Oracle XML Database [upgrade] VALID
–> Oracle Workspace Manager [upgrade] VALID
–> Oracle Data Mining [upgrade] VALID
–> OLAP Analytic Workspace [upgrade] VALID
–> OLAP Catalog [upgrade] VALID
–> Oracle OLAP API [upgrade] VALID
–> Oracle interMedia [upgrade] VALID
–> Spatial [upgrade] VALID
–> Expression Filter [upgrade] VALID
–> EM Repository [upgrade] VALID
–> Rule Manager [upgrade] VALID
.
PL/SQL procedure successfully completed.
SQL> SPOOL OFF;
SQL> SPOOL /u01/stage/patch/Disk1/patch.log
SQL> @?/rdbms/admin/catupgrd.sql
……………………………………………
…………………………..
177 PROCEDURE selectTablespace( tsname IN varchar2 );
178
179 — This procedure informs this package that the caller intends to do
180 — point-in-time recovery on the specified tablespace. This procedure must
181 — be called once for each tablespace in the recovery set.
182 — It alter selected tablespace read only, also checks datafiles in the
183 — selected tablespace.
184 –
185 — Input parameters:
186 – tsname
187 – The tablespace name.
188 –
189 — Exceptions:
190 – WRONG_ORDER (ORA-29301)
191 – wrong dbms_pitr package functions/procedure order.
192 – WRONG_TSNAME (ORA-29304)
193 – select tablespace does not exist
194 – NOT_READ_ONLY (ORA-29305)
195 – cannot alter the tablespace read only
196 – FILE_OFFLINE (ORA-29306)
197 – datafile is not online
178
179 — This procedure informs this package that the caller intends to do
180 — point-in-time recovery on the specified tablespace. This procedure must
181 — be called once for each tablespace in the recovery set.
182 — It alter selected tablespace read only, also checks datafiles in the
183 — selected tablespace.
184 –
185 — Input parameters:
186 – tsname
187 – The tablespace name.
188 –
189 — Exceptions:
190 – WRONG_ORDER (ORA-29301)
191 – wrong dbms_pitr package functions/procedure order.
192 – WRONG_TSNAME (ORA-29304)
193 – select tablespace does not exist
194 – NOT_READ_ONLY (ORA-29305)
195 – cannot alter the tablespace read only
196 – FILE_OFFLINE (ORA-29306)
197 – datafile is not online
SQL>
SQL>
SQL>
SQL> SPOOL OFF
SQL>
SQL>
SQL> SPOOL OFF
SQL> SHUTDOWN IMMEDIATE
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP
ORACLE instance started.
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP
ORACLE instance started.
Total System Global Area 1224736768 bytes
Fixed Size 1267188 bytes
Variable Size 335546892 bytes
Database Buffers 872415232 bytes
Redo Buffers 15507456 bytes
Database mounted.
Database opened.
SQL>
Fixed Size 1267188 bytes
Variable Size 335546892 bytes
Database Buffers 872415232 bytes
Redo Buffers 15507456 bytes
Database mounted.
Database opened.
SQL>
To compile invalid objects
SQL> @?/rdbms/admin/utlrp.sql
……………………………..
…………………………………
TIMESTAMP
——————————————————————————–
COMP_TIMESTAMP UTLRP_END 2010-02-08 15:02:23
DOC> The following query reports the number of objects that have compiled
DOC> with errors (objects that compile with errors have status set to 3 in
DOC> obj$). If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#
OBJECTS WITH ERRORS
——————-
0
DOC> The following query reports the number of errors caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC>#
ERRORS DURING RECOMPILATION
—————————
0
SQL>
SQL> select comp_name, version, status from sys.dba_registry;
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
Oracle Workspace Manager 10.2.0.4.3 VALID
JServer JAVA Virtual Machine 10.2.0.4.0 VALID
Oracle XDK 10.2.0.4.0 VALID
Oracle Database Java Packages 10.2.0.4.0 VALID
Oracle Expression Filter 10.2.0.4.0 VALID
Oracle Data Mining 10.2.0.4.0 VALID
Oracle Text 10.2.0.4.0 VALID
Oracle XML Database 10.2.0.4.0 VALID
Oracle Rule Manager 10.2.0.4.0 VALID
Oracle interMedia 10.2.0.4.0 VALID
OLAP Analytic Workspace 10.2.0.4.0 VALID
Oracle OLAP API 10.2.0.4.0 VALID
OLAP Catalog 10.2.0.4.0 VALID
Spatial 10.2.0.4.0 VALID
Oracle Enterprise Manager 10.2.0.4.0 VALID
SQL>exit
Now Start other services (listener, EM, iSQLPlus…)
No comments:
Post a Comment