Shulou(Shulou.com)06/01 Report--

Oracle database upgrade (documentation)

Document directory:

1. Backup ORACLE_BASE (as a DBA, don't forget to back up no matter what you do)

2. Upgrade Opatch (① / opt/Disk1/runInstaller graphical installation; ② silent installation)

3. Upgrade the database (① DBUA graphic installation; ② manual installation)

1. Backup ORACLE_BASE (as a DBA, don't forget to back up no matter what you do)

A) stop all processes of the single instance database (stopping all processes for a single instance installation)

Emctl stop dbconsole-stop EM

Isqlplusctl stop

Lsnrctl stop-stop listening

Conn / as sysdba

Shutdown immediate-closed database

Export ORACLE_SID=+ASM

Sqlplus / nolog

Conn / as sysdba

Shutdown immediate-close ASM instance (automatic storage management instance)

Root users execute:

# $ORACLE_HOME/bin/crsctl stop crs-close the ASM,oracle cluster synchronization service daemon

B) Cold backup data

Backup: tar-zcvf bk.tar.gz $ORACLE_BASE/-- packaged and compressed

Restore: tar-zxvf bk.tar.gz-C $ORACLE_BASE/-- the specified directory is restored by line

2. Upgrade Opatch (① / opt/Disk1/runInstaller graphical installation; ② silent installation)

What we are taking here is a graphical installation, but we will not introduce silent installation for the time being.

Upgrade Opatch

Oracle users execute:

Unzip p6810189_10204_Linux-x86.zip-unzipped package

Export DISPLAY=192.168.1.25:0.0-Xmanger remote Desktop installation

/ opt/Disk1/runInstaller-enter the graphical interface to install

Graphical interface omission: note that yes is provided here: whether to directly overwrite the ORACLE_HOME upgrade

Root users execute:

/ opt/oraInventory/orainstRoot.sh

/ opt/oracle/product/10.2.0/db_1/root.sh

3. Upgrade the database (① DBUA graphic installation; ② manual installation)

We are taking the graphical installation here, not introducing the manual installation for the time being.

3-1) Oracle users execute:

Set up the system environment

Export ORACLE_SID=test

Export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1

Export PATH=/usr/sbin:$PATH

Export PATH=$ORACLE_HOME/bin:$PATH

Lsnrctl start-enable monitoring

Export DISPLAY=192.168.1.25:0.0

Dbua-graphic upgrade (if there is a problem with the drawing, please do not perform dbua in the / home/oracle directory)

Graphical interface omission: it should be noted that it is provided here: 1, whether to move the data file during the upgrade process; 2, whether the upgrade process is automatically cold standby, and form a script to restore

Dbua will finally generate an upgrade report, which will be displayed if there is a failed option, and evaluate the success of the upgrade.

3-2) if oracle recovery manager catalog is used

$rman catalog username/password@alias

RMAN > UPGRADE CATALOG

3-3) Fault handling and upgrade inspection

Sys@TEST > shutdown immediate

Sys@TEST > startup upgradesys@TEST > @? / rdbms/admin/catupgrd.sql-re-upgrade to solve version and status problems sys@TEST > @? / rdbms/admin/utlu102i.sql-collect upgrade information Note: catupgrd.sql; utlu102i.sql executes sys@TEST > shutdown immediate;sys@TEST > startup under startup upgrade

Sys@TEST > @? / rdbms/admin/utlrp.sql-recompile invalid pl/sql packages

Upgrade component verification

Select comp_name, version, status from sys.dba_registry

COMP_NAME VERSION STATUS -Oracle Database Catalog Views 10.2.0.4.0 VALIDOracle Database Packages and Types 10.2.0.4.0 VALIDOracle Workspace Manager 10.2.0.4.3 VALIDJServer JAVA Virtual Machine 10.2.0.4.0 VALIDOracle XDK 10.2.0.4.0 VALIDOracle Database Java Packages 10.2.0.4.0 VALIDOracle Expression Filter 10.2.0.4.0 VALIDOracle Data Mining 10.2.0.4.0 VALIDOracle Text 10.2.0.4.0 VALIDOracle XML Database 10.2.0.4.0 VALIDOracle Rule Manager 10.2.0.4.0 VALIDOracle interMedia 10.2. 0.4.0 VALIDOLAP Analytic Workspace 10.2.0.4.0 VALIDOracle OLAP API 10.2.0.4.0 VALIDOLAP Catalog 10.2.0.4.0 VALIDSpatial 10.2.0.4.0 VALIDOracle Enterprise Manager 10.2.0.4.0 VALIDSQL > select * from utl_recomp_errors No rows selected

3-4) EM updates

Emca-upgrade db-Update the EM database here our upgrade work has been completed!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.