oracle:oradv1>:/u01/app/oracle/product/10.2.0.1/db_1/bin=>export ORACLE_SID=oradv1
Database Name : oradv1
oracle:oradv1>:/u01/app/oracle/product/10.2.0.1/db_1/bin=>./sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 21 18:54:29 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Step1 : backup database before upgrading to 10.2.0.4 version.
You can perform whole database backups with the database mounted or open. To perform a whole database backup from the RMAN prompt the BACKUP DATABASE command can be used.
oracle:oradv1>:/u01/app/oracle/product/10.2.0.1/db_1/bin=>./rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Mon Mar 21 18:55:50 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORADV1 (DBID=1466539554)
RMAN> backup database format '/tmp/oradv1_t%t_s%s_p%p';
Starting backup at 21-MAR-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=150 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=+DATA1/oradv1/datafile/system.274.746390127
input datafile fno=00002 name=+DATA1/oradv1/datafile/undotbs1.275.746390145
input datafile fno=00003 name=+DATA1/oradv1/datafile/sysaux.276.746390157
input datafile fno=00004 name=+DATA1/oradv1/datafile/users.278.746390167
channel ORA_DISK_1: starting piece 1 at 21-MAR-11
channel ORA_DISK_1: finished piece 1 at 21-MAR-11
piece handle=/tmp/oradv1_t746391546_s3_p1 tag=TAG20110321T185906 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:26
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 21-MAR-11
channel ORA_DISK_1: finished piece 1 at 21-MAR-11
piece handle=/tmp/oradv1_t746391572_s4_p1 tag=TAG20110321T185906 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 21-MAR-11
Step2)Shut down all process running on current oracle home.
Step3)Apply oracle 10.2.0.4 patchset.
oracle:oradv1>:/u01/soft/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
All installer requirements met.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-03-21_07-03-18PM. Please wait ...*oralab*<oracle:oradv1>:/u01/soft/Disk1=>Oracle Universal Installer, Version 10.2.0.4.0 Production
Copyright (C) 1999, 2008, Oracle. All rights reserved
Running Oracle10 root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/10.2.0.1/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
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.sh script.
Now product-specific root actions will be performed.
oracle:oradv1>:/u01/app/oracle/product/10.2.0.1/db_1/bin=>./dbua &
[1] 14708
oracle:oradv1>:/u01/app/oracle/product/10.2.0.1/db_1/bin=>./sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Mar 21 19:50:18 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
db_name string oradv1
db_unique_name string oradv1
SQL> show parameter compatible;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 10.2.0.4.0
Identifying Invalid Objects
--------------------------------
To identify all of the invalid objects , run the following query,
SQL> select owner,object_name,object_type from dba_objects where
2 status='INVALID';
no rows selected
No comments:
Post a Comment