KEMBAR78
Patching | PDF
Scribd
Upload
29 views2 pages

Patching

The document outlines the steps for patching an Oracle database, including downloading the patch, checking and upgrading the OPatch utility, taking backups, and applying the PSU patch. It details commands for checking prerequisites, applying the patch, and executing post-installation scripts. Finally, it includes instructions for verifying the patch application and starting the database.

Uploaded by

Poreddy Sandeepreddy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
29 views2 pages

Patching

The document outlines the steps for patching an Oracle database, including downloading the patch, checking and upgrading the OPatch utility, taking backups, and applying the PSU patch. It details commands for checking prerequisites, applying the patch, and executing post-installation scripts. Finally, it includes instructions for verifying the patch application and starting the database.

Uploaded by

Poreddy Sandeepreddy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 2

Patching:

---------

1) download the patch and opatch utility from oracle support.


2) check current version, if it dostn match the upgrade the Opatch Utility.
-Need to rename the old OpatchUtility and need to upgrade with new opatch
-opactch will be available in OracleHome.
3)take Tar backupof OracleHome.
4)shutdown Db and Listerner.
5) before applying patch take the patchConflicts
6)apply the PSU patch in ORACLE_HOME.
7) execute the post installation script .(datapatch)
8) start Db
9)check dba_registry_sqlpatch

export PATH=/oracle/app/product/12c/dbhome/bin:/oracle/app/product/12c/dbhome/
OPatch:$PATH

-opatch version

-If its nomatch rename to Opatch_date[mv Opatch Opatch_Date]


copy[cp -pr p6...] the p6 file to dbhome and unzip

-check version again [opatch version it will matches]


-select name,open_mode,log_mode,database_role from v$database;
-shut immediate;

-tar backup=
-du -sh dbhome
-cd ../
-[tar -cvpf /path/tar_backup_oh_date/oh_tar.tar ./dbhome] [shuld immpliment comment
not from the dbhome(1step back) i.e 12c]

-unzip patch file p3


- cd 3.
-export PATH=/oracle/app/product/12c/dbhome/bin:/oracle/app/product/12c/dbhome/
OPatch:$PATH
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
opatch prereq CheckSystemSpace -ph ./
opatch prereq CheckActiveFilesAndExecutables -ph ./
opatch prereq CheckApplicable -ph ./
opatch prereq CheckComponents -ph ./

opatch apply

opatch lspatches
opatch lsinv

SQL> Connect / as sysdba


SQL> startup
SQL> quit
cd $ORACLE_HOME/OPatch{-Goto Dbhome and cd OPatch - ls -lrt *data* [datapatch]

./datapatch -verbose {registering the applied patch}

}
./datapatch -sanity_checks (optional)
./datapatch -verbose
connect to sql:
desc dba_registry_sqlpatch;
select patch_id,status,description,action_time from dba_registry_sqlpatch;

export PATH=/oracle/app/product/12c/dbhome/bin:/oracle/app/product/12c/dbhome/
OPatch:$PATH

opatch version

cp -pr p6880880_122010_Linux-x86-64.zip /oracle/app/product/12c/dbhome

du -sh dbhome

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

You might also like