Oracle 11gR2 RAC 11.2.0.4 fully automated 11.2.0.4.20170418 psu steps,

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