Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Upgrading Oracle 11.2.0.1.0 to 11.2.0.3.0     - Oracle through the alarm log view and inspect the main library, physical and snapshot standby database (Database)

- CentOS yum source as the default setting methods in DVD (Linux)

- Ubuntu install Eclipse for C / C ++ and related configuration (Linux)

- Learning C ++ Standard Template Library and data structures (Programming)

- VNC configuration detailed analysis under Linux (Linux)

- Ubuntu installed racing game Speed Dreams 2.1 (Linux)

- Source code compiled by the installation program under Linux (Linux)

- Java how to achieve bubble sort the problem Arraylist (Programming)

- Install Java 8 on Ubuntu using PPA (Linux)

- Linux reserves the rest of the file to delete several (Linux)

- Ubuntu users install the Download Manager software Xdman 5.0 (Linux)

- Build your own Web server under Ubuntu Linux system (Server)

- JavaScript Advanced Programming notes event capture and event bubbling (Programming)

- Android memory optimization of the disk cache (Linux)

- Linux SSH remote connection service slow Solutions (Linux)

- iostat command Detailed (Linux)

- C ++ constant definition (Programming)

- In-depth understanding of PHP ini configuration (Server)

- 127.0.0.1 and localhost difference (Server)

- Linux disk virtualization (Linux)

 
         
  Upgrading Oracle 11.2.0.1.0 to 11.2.0.3.0
     
  Add Date : 2017-01-08      
         
         
         
  View DB version

[Oracle @ RedHat6 ~] $ sqlplus / as sysdba

SQL * Plus: Release 11.2.0.1.0 Production on Fri Dec 6 21:12:32 2013

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 208769024 bytes
Fixed Size 2211928 bytes
Variable Size 125833128 bytes
Database Buffers 75497472 bytes
Redo Buffers 5226496 bytes
Database mounted.
Database opened.
SQL> select * from v $ version;

BANNER
-------------------------------------------------- ------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL / SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

1. Unzip patch and merge

11.2.0.3 patch package a total of seven different roles of seven documents refer to the following link

http://blog.csdn.net/tianlesoftware/article/details/6818770

Upgrading the database software only needs to extract the first and second file can be as follows

p10404530_112030_Linux-x86-64_1of7.zip

p10404530_112030_Linux-x86-64_2of7.zip

[Oracle @ redhat6 11204_patch_1] $ unzip /opt/oracle11gR2/p10404530_112030_Linux-x86-64_1of7.zip
[Oracle @ redhat6 11204_patch] $ unzip /opt/oracle11gR2/p10404530_112030_Linux-x86-64_2of7.zip

Directory under the appropriate copy files to a second unpacked first unpacked

[Oracle @ redhat6 Components] $

/ U01 / 11204_patch / database / stage / Components

[Oracle @ redhat6 Components] $ cp -R * / u01 / 11204_patch_1 / database / stage / Components /

Main Step 2. Upgrade
a. Back up the database (for an upgrade fails, you can recover)
b. Run patchset, oracle software upgrade
c. Prepare a new ORACLE_HOME
d. Run the script or upgrade an instance dbua
Version information and invalid objects after e. Check Upgrade
2.1 Close and oracle-related services
lsnrctl stop
shutdown immediate
emctl stop dbconsole
DB Backup 2.2 directory back up the following major
ORACLE_HOME / dbs
ORACLE_HOME / network / admin
ORACLE_HOME / hostname_dbname
ORACLE_HOME / oc4j / j2ee / OC4J_DBConsole_hostname_dbname
2.3 Upgrading Oracle software

[Oracle @ redhat6 ~] $ cd / u01 / 11204_patch_1 / database /
[Oracle @ redhat6 database] $ ls
doc install readme.html response rpm runInstaller sshsetup stage welcome.html

[Oracle @ redhat6 database] ./ runInstaller

When the installation is completed, the root user implementation of some two and root.sh scripts orainstRoot.sh

2.4 11.2.0.1 files under ORACLE_HOME ORACLE_HOME under the new copy, the operation is as follows

[Oracle @ redhat6 dbs] $ pwd
/u01/app/oracle/product/11.2.0/db_1/dbs
[Oracle @ redhat6 dbs] $ cp * /u01/app/oracle/product/11.2.0.3/db_1/dbs/
[Oracle @ redhat6 admin] $ pwd
/u01/app/oracle/product/11.2.0/db_1/network/admin
[Oracle @ redhat6 admin] $ cp -R * /u01/app/oracle/product/11.2.0.3/db_1/network/admin/

2.5 modify the oracle profile

[Oracle @ redhat6 ~] $ cat .bash_profile | grep ORACLE_HOME
ORACLE_HOME = $ ORACLE_BASE / product / 11.2.0.3 / db_1
export ORACLE_HOME
PATH = $ ORACLE_HOME / bin: $ PATH
LD_LIBRARY_PATH = $ ORACLE_HOME / lib: / lib: / usr / lib
CLASSPATH = $ ORACLE_HOME / jlib: $ ORACLE_HOME / rdbms / jlib
[Oracle @ redhat6 ~] $ cat / etc / oratab
#

 

# This file is used by ORACLE utilities. It is created by root.sh
# And updated by the Database Configuration Assistant when creating
# A database.

# A colon, ':', is used as the field terminator A new line terminates.
# The entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
# $ ORACLE_SID: $ ORACLE_HOME ::
#
# The first and second fields are the system identifier and home
# Directory of the database respectively. The third filed indicates
# To the dbstart utility that the database should, "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ ORACLE_SID are not allowed.
#
#
hjj: /u01/app/oracle/product/11.2.0.3/db_1: Y
2.6 start sqlplus under the new ORACLE_HOME and AS SYSDBA privileges landing

SQL> SPOOL upgrade_info.log

SQL> @ / u01 / app / oracle / product / 11.2.0.3 / db_1 / rdbms / admin / utlu112i.sql

SQL> SPOOL OFF


2.7 Close the database restart the database

SQL> shutdown immediate

SQL> starup upgrade - must upgrade

[Oracle @ redhat6 ~] $ sqlplus / as sysdba

SQL * Plus: Release 11.2.0.3.0 Production on Sun Dec 8 03:16:38 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from v $ version;

BANNER
-------------------------------------------------- ------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL / SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

SQL> select status from v $ instance;

STATUS
------------
OPEN MIGRATE

- Compile invalid objects

SQL> @ / u01 / app / oracle / product / 11.2.0.3 / db_1 / rdbms / admin / utlrp.sql

- Perform the upgrade script

SQL> @ / u01 / app / oracle / product / 11.2.0.3 / db_1 / rdbms / admin / catupgrd.sql

After the implementation will automatically shutdown immediate, and the implementation of a long time

[Oracle @ redhat6 ~] $ sqlplus / as sysdba

SQL * Plus: Release 11.2.0.3.0 Production on Sun Dec 8 04:13:52 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 208769024 bytes
Fixed Size 2226936 bytes
Variable Size 142607624 bytes
Database Buffers 58720256 bytes
Redo Buffers 5214208 bytes
Database mounted.
Database opened.
SQL> select status from v $ instance;

STATUS
------------
     
         
         
         
  More:      
 
- The array of C language (Programming)
- TeamCity continuous integration in the Linux installation (Linux)
- quotacheck command file can not be created aquota.user and aquota.group solutions (Linux)
- A new method for Linux hidden files (Linux)
- Those functions under Linux you do not know the df command (Linux)
- How to install Kernel 4.0.2 on CentOS 7 (Linux)
- Puppet 3.5 Source package Installation and Configuration (Server)
- Fedora network set up simple (Linux)
- Linux character device - user mode and kernel mode data transfer data (Linux)
- Linux Study of --CentOS create local yum repository (Linux)
- No password on Oracle and MySQL login (Database)
- Debian 7.8 system installation and configuration process (Linux)
- KUbuntu / Ubuntu 14.04 (downgrade) installed SVN 1.7 (Linux)
- MySQL + Heartbeat + DRBD deployment architecture (Server)
- Analysis of C ++ exception mechanism (Programming)
- MyCAT separate read and write to achieve MySQL Practice (Database)
- JavaScript function definition mode (Programming)
- See Linux kernel, CPU, memory, and various versions of the command module and means (Linux)
- Mac OS X system setup Google Go language development environment configuration tool Sublime Text 2 (Linux)
- RedHat / CentOS ext4 partition can not be formatted large supplementary ext4 formatting (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.