Oracle 11gR2 RAC 11.2.0.4 fully automated 11.2.0.4.20170418 psu steps,

Source: Internet
Author: User

Oracle 11gR2 RAC 11.2.0.4 fully automated 11.2.0.4.20170418 psu steps,

 

(The environment of patch p6880880_112000_Linux-x86-64.zip and p25476126_112040_Linux-x86-64.zip are put in/soft directory,

Grid and oracle users have read and write permissions on the/soft directory, and only the root user can perform the whole process.

 

Database Version

11.2.0.4

PSU

11.2.0.4.20170418

GI installation directory

/U01/app/11.2.0/grid

DB installation directory

/U01/app/oracle/product/11.2.0/dbhome_1

Note: The following operations are performed by the root user at two nodes:


1. Replace OPatch

Su-root

Export GRID_HOME =/u01/app/11.2.0/grid

Export ORACLE_HOME =/u01/app/oracle/product/11.2.0/dbhome_1

# Replacing opatch of grid

Cd $ GRID_HOME; mv OPatch. 'date + % Y % m % d'

Unzip/soft/p6880880_112000_Linux-x86-64.zip-d $ GRID_HOME

Chown-R grid: oinstall $ GRID_HOME/OPatch

# Replacing the opatch of the database

Cd $ ORACLE_HOME; mv OPatch. 'date + % Y % m % d'

Unzip/soft/p6880880_112000_Linux-x86-64.zip-d $ ORACLE_HOME

Chown-R oracle: oinstall $ ORACLE_HOME/OPatch

 

2. Verify opatch replacement:

Su-grid-c '$ ORACLE_HOME/OPatch/opatch version'

OPatch Version: 11.2.0.3.12

OPatch succeeded.


Su-oracle-c '$ ORACLE_HOME/OPatch/opatch version'

OPatch Version: 11.2.0.3.12

OPatch succeeded.

 

3. Unzip the patch to the/soft directory:

Su-grid-c 'CD/soft; unzip p25476126_112040_Linux-x86-64.zip'


4. conflict check

Su-grid-c '$ ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail-phBaseDir/soft/25476126-oh $ ORACLE_HOME'

Su-oracle-c '$ ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail-phBaseDir/soft/25476126-oh $ ORACLE_HOME'


5. Generate the ocm. rsp File

Su-grid-c 'CD/soft; $ ORACLE_HOME/OPatch/ocm/bin/emocmrsp-no_banner'


6. Start automatic PSU

Run the following command as the root user:

/U01/app/11.2.0/grid/OPatch/opatch auto/soft/25476126-ocmrf/soft/ocm. rsp

# -- Note: If the dbca database is created, the above script will simultaneously Add the grid and database to PSU. If the new RAC database is not created, only the grid psu will be installed, the database requires additional commands to be labeled with psu.

-- Run the database psu command:

/U01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch auto/soft/25476126-oh/u01/app/oracle/product/11.2.0/dbhome_1-ocmrf/soft/ ocm. rsp

 

7. Verify the PSU installation result:

Su-grid-c '$ ORACLE_HOME/OPatch/opatch lsinv'

Su-oracle-c '$ ORACLE_HOME/OPatch/opatch lsinv'


# -- If RAC is newly installed and the database has not yet been created, the following operations are not required.


8. Run the script and apply psu.
Su-oracle-c 'sqlplus/as sysdb' <EOF
@? /Rdbms/admin/catbundle. SQL psu apply
EOF


9. Execute the utlrp script
Su-oracle-c 'sqlplus/as sysdb' <EOF
@? /Rdbms/admin/utlrp. SQL
EOF


10. Verify the psu Application

Su-oracle-c 'sqlplus/as sysdb' <EOF

Set line 150
Col ACTION_TIME for a30
Col ACTION for a8
Col NAMESPACE for a8
Col VERSION for a10
Col BUNDLE_SERIES for a5
Col COMMENTS for a20

Select * from dba_registry_history;
EOF

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.