{"id":6122,"date":"2015-11-10T17:02:37","date_gmt":"2015-11-10T16:02:37","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/"},"modified":"2022-12-23T16:58:50","modified_gmt":"2022-12-23T15:58:50","slug":"oracle-dba-essentials-workshop-patchset-11-2-0-4-available","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/","title":{"rendered":"Oracle DBA Essentials Workshop &#8211; Patchset 11.2.0.4 Available"},"content":{"rendered":"<p>We have Upgrade our Environment <a href=\"https:\/\/www.dbi-services.com\/trainings\/oracle-dba-essentials-workshop\/\">Oracle DBA Essentials Workshop<\/a> of release 11.2.0.3 to 11.2.0.4. From now on, you can operates the various subjects on the new release.<\/p>\n<p>In this article, I present you the procedure to be followed for the upgrade of your database:<\/p>\n<ul>\n<li>Update DMK to the version 14-10<\/li>\n<li>Upgrade database<\/li>\n<li>Install Oracle Patchset 11.2.0.4 and PSU<\/li>\n<\/ul>\n<h2>Update DMK 14-10<\/h2>\n<p>The first step it&#8217;s update Data Management Kit, included dmk_sql. We need to Download, Unzip and configured Patch DMK.<\/p>\n<p>Unzip DMK-14-10-1 and resourcing:<br \/>\n<code><br \/>\noracle@srvora01:\/u00\/app\/oracle\/local\/ [rdbms11203] tar xvzf dmk-14-10.1-unix.tar.gz<br \/>\noracle@srvora01:\/u00\/app\/oracle\/local\/ [rdbms11203] cd dmk\/bin\/<br \/>\noracle@srvora01:\/u00\/app\/oracle\/local\/dmk\/bin\/ [rdbms11203] echo $SHELL<br \/>\n\/bin\/bash<br \/>\noracle@srvora01:\/u00\/app\/oracle\/local\/dmk\/bin\/[rdbms11203]. .\/dmk.bash<br \/>\n<\/code><\/p>\n<p>Configure new DMK:<br \/>\n<code><br \/>\noracle@srvora01:\/u00\/app\/oracle\/local\/ [rdbms11203] cd dmk<br \/>\noracle@srvora01:\/u00\/app\/oracle\/local\/dmk\/ [rdbms11203] cd etc\/<br \/>\noracle@srvora01:\/u00\/app\/oracle\/local\/dmk\/etc\/ [rdbms11203] cp dmk.conf dmk.conf.20150210.yan<br \/>\noracle@srvora01:\/u00\/app\/oracle\/local\/dmk\/etc\/ [rdbms11203] cp dmk.conf.unix dmk.conf<br \/>\n<\/code><\/p>\n<p>We make a difference of parameter with the Old and New DMK version:<br \/>\n<code><br \/>\noracle@srvora01:\/u00\/app\/oracle\/local\/dmk\/etc\/ [rdbms11203] diff dmk.conf dmk.conf.20150210.yan<br \/>\n1c1<br \/>\n# $Id: dmk.conf.unix 703 2012-06-19 06:34:59Z jew $<br \/>\n20,21c20,21<br \/>\n&lt; alias::sqh::novar_noforce::\"rlwrap.`uname` -i sqlplus '\/ as sysdba' ${DMK_EXEC_SQL_SCRIPT}\"::<br \/>\nalias::sqh::novar_noforce::\"rlwrap.`uname` -i sqlplus '\/ as sysdba'\"::<br \/>\n&gt; alias::sq::novar_noforce::\"sqlplus '\/ as sysdba'\"::<br \/>\n26c26<br \/>\nalias::rmanc::novar_noforce::\"if [ -f ${DMK_ORA_ADMIN_SID}\/etc\/rman.cfg ]; then . ${DMK_ORA_ADMIN_SID}\/etc\/rman.cfg; if [ $catalog != \"nocatalog\" ]; then catalog=\"catalog=${catalog}\"; fi; else catalog=nocatalog; fi; rlwrap.`uname` -i rman target=\/ ${catalog};\"::<br \/>\n43c43,44<br \/>\nvar::PS1::=::nooption::'${LOGNAME}@${HostName}:${PWD}\/ [${ORACLE_SID}] '::#prompt<br \/>\n&gt; var::PATH::+::begin::\"${ORACLE_HOME}\/bin:${ORACLE_HOME}\/ctx\/bin:${ORACLE_HOME}\/OPatch\"::<br \/>\n62,63d62<br \/>\n&lt;<br \/>\n&lt; # The dmk-run.ksh option --columns works only for BASH shell<br \/>\n67d65<br \/>\n&lt;<br \/>\n82,86d79<br \/>\n&lt; var::DMK_LINUX_AWK::=::nooption::\"\/bin\/awk\"::<br \/>\n&lt; var::DMK_SUNOS_AWK::=::nooption::\"awk\"::<br \/>\n&lt; var::DMK_SOLARIS_AWK::=::nooption::\"awk\"::<br \/>\n&lt; var::DMK_HPUX_AWK::=::nooption::\"awk\"::<br \/>\n&lt; var::DMK_AIX_AWK::=::nooption::\"awk\"::<br \/>\n88,94d80<br \/>\n&lt; #### NEW in DMK release 2014<br \/>\n&lt; alias::lspdb::novar_noforce::'${PERL_EXEC} ${DMK_HOME}\/lib\/lspdb.pl'::<br \/>\n&lt; var::PS1::=::nowarn::'${LOGNAME}@${HostName}:${PWD}\/ [${ORACLE_SID}${DMK_SID_PDB}] '::#prompt PS1<br \/>\n&lt; alias::sqh::novar_noforce::\"rlwrap.`uname` -i sqlplus '\/ as sysdba' ${DMK_EXEC_SQL_SCRIPT}\"::<br \/>\n&lt; alias::sq::novar_noforce::\"sqlplus '\/ as sysdba' ${DMK_EXEC_SQL_SCRIPT}\"::<br \/>\n&lt; var::PATH::+::begin::\"${ORACLE_HOME}\/perl\/bin:${ORACLE_HOME}\/bin:${ORACLE_HOME}\/ctx\/bin:${ORACLE_HOME}\/OPatch\"::<br \/>\n&lt; var::NLS_DATE_FORMAT::=::nooption::\"DD-MON-YYYY HH24:MI:SS\"::<br \/>\n108c94,96<br \/>\n[WSDBA1]<br \/>\n&gt; var::ORACLE_UNQNAME::=::nooption::\"WSDBA1_SITE1\"::<br \/>\n111d98<br \/>\n&lt; #var::DMK_EXEC_SQL_SCRIPT::=::nowarn::\"@\/\"::<br \/>\n125,127d111<br \/>\n&lt; # Example Grid Infrastructure to enable the DMK pluggable database(s) feature<br \/>\n&lt; #[CDBUTF8]<br \/>\n&lt; #var::DMK_ORA12C_PDBS::=::nowarn::\"SALESPDB,HRPDB\"::<br \/>\n<\/code><\/p>\n<p>Update dmk_sql:<br \/>\n<code><br \/>\nAdd WSDBA1 config :<br \/>\noracle@srvora01:\/u00\/app\/oracle\/local\/dmk\/etc\/ [rdbms11203] tail -30 dmk.conf<br \/>\n.....<br \/>\n[WSDBA1]<br \/>\nvar::ORACLE_UNQNAME::=::nooption::\"WSDBA1_SITE1\"::<br \/>\n.....<br \/>\noracle@srvora01:\/u00\/app\/oracle\/local\/ [rdbms11203] mv dmk_sql dmk_sql.to.del_yan<br \/>\noracle@srvora01:\/u00\/app\/oracle\/local\/ [rdbms11203] tar xvzf dmk_sql-14-10.tar.gz<br \/>\noracle@srvora01:\/u00\/app\/ [rdbms11204] echo $DMK_SQL<br \/>\n\/u00\/app\/oracle\/local\/dmk_sql<br \/>\noracle@srvora01:\/u00\/app\/ [rdbms11204] sql<br \/>\noracle@srvora01:\/u00\/app\/oracle\/local\/dmk_sql\/ [rdbms11204]<br \/>\n<\/code><\/p>\n<h2 class=\"brush: sql; gutter: true; first-line: 1\">Installation Binaries 11.2.0.4 and PSU<\/h2>\n<p>Unzip the different packages of binaries 11.2.0.4:<br \/>\n<code><br \/>\noracle@srvora01:\/u00\/app\/oracle\/software\/ [rdbms11203] unzip p13390677_112040_Linux-x86-64_1of7.zip<br \/>\noracle@srvora01:\/u00\/app\/oracle\/software\/ [rdbms11203] unzip p13390677_112040_Linux-x86-64_2of7.zip<br \/>\n<\/code><\/p>\n<p>Empty the old Oracle environment:<br \/>\n<code><br \/>\noracle@srvora01:\/u00\/app\/oracle\/software\/database\/ [rdbms11203] env | grep ORACLE<br \/>\nORACLE_SID=rdbms11203<br \/>\nORACLE_BASE=\/u00\/app\/oracle<br \/>\nPS1=${LOGNAME}@${HostName}:${PWD}\/ [${ORACLE_SID}${DMK_SID_PDB}]<br \/>\nORACLE_HOME=\/u00\/app\/oracle\/product\/11.2.0\/db_3_0<br \/>\n<\/code><\/p>\n<p>Unset the Oracle home and export the perl Path. Then we launch the run-installer:<br \/>\n<code><br \/>\noracle@srvora01:\/u00\/app\/oracle\/software\/database\/ [rdbms11203] unset ORACLE_HOME<br \/>\noracle@srvora01:\/u00\/app\/oracle\/software\/database\/ [rdbms11203] echo $PATH<br \/>\n\/u00\/app\/oracle\/product\/11.2.0\/db_3_0\/perl\/bin:\/u00\/app\/oracle\/product\/11.2.0\/db_3_0\/bin:\/u00\/app\/oracle\/product\/11.2.0\/db_3_0\/ctx\/bin:\/u00\/app\/oracle\/product\/11.2.0\/db_3_0\/OPatch:\/u00\/app\/oracle\/product\/11.2.0\/db_3_0\/bin:\/u00\/app\/oracle\/product\/11.2.0\/db_3_0\/ctx\/bin:\/u00\/app\/oracle\/product\/11.2.0\/db_3_0\/OPatch:\/usr\/lib64\/qt-3.3\/bin:\/usr\/local\/bin:\/bin:\/usr\/bin:\/usr\/local\/sbin:\/usr\/sbin:\/sbin:\/home\/oracle\/bin:\/u00\/app\/oracle\/local\/dmk_dbbackup\/bin:\/u00\/app\/oracle\/local\/dmk\/bin:\/u00\/app\/oracle\/local\/dmk_ha\/bin:\/u00\/app\/oracle\/local\/dmk_dbcreate\/bin<br \/>\noracle@srvora01:\/u00\/app\/oracle\/software\/database\/ [rdbms11203] export PATH=\/usr\/lib64\/qt-3.3\/bin:\/usr\/local\/bin:\/bin:\/usr\/bin:\/usr\/local\/sbin:\/usr\/sbin:\/sbin:\/home\/oracle\/bin:\/u00\/app\/oracle\/local\/dmk_dbbackup\/bin:\/u00\/app\/oracle\/local\/dmk\/bin:\/u00\/app\/oracle\/local\/dmk_ha\/bin:\/u00\/app\/oracle\/local\/dmk_dbcreate\/bin<br \/>\noracle@srvora01:\/u00\/app\/oracle\/software\/database\/ [rdbms11203] echo $LD_LIBRARY_PATH<br \/>\n\/u00\/app\/oracle\/product\/11.2.0\/db_3_0\/lib:\/u00\/app\/oracle\/product\/11.2.0\/db_3_0\/lib32<br \/>\noracle@srvora01:\/u00\/app\/oracle\/software\/database\/ [rdbms11203] export LD_LIBRARY_PATH=\/u00\/app\/oracle\/product\/11.2.0\/db_3_0\/lib32<br \/>\noracle@srvora01:\/u00\/app\/oracle\/software\/database\/ [rdbms11203] .\/runInstaller<br \/>\n<\/code><\/p>\n<p>Step by Step of the GUI:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/3.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4879 size-medium\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/3.jpg\" alt=\"3\" width=\"300\" height=\"232\"><\/a><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4878 size-medium\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2.jpg\" alt=\"2\" width=\"300\" height=\"232\"><\/a><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/4.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4880 size-medium\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/4.jpg\" alt=\"4\" width=\"300\" height=\"233\"><\/a><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4877 size-medium\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1.jpg\" alt=\"1\" width=\"300\" height=\"223\"><\/a><\/p>\n<p>Execute the script root.sh:<br \/>\n<code><br \/>\n[root@srvora01 oracle]# \/u00\/app\/oracle\/product\/11.2.0.4_ee\/db_1\/root.sh<br \/>\nPerforming root user operation for Oracle 11g<br \/>\nThe following environment variables are set as:<br \/>\nORACLE_OWNER= oracle<br \/>\nORACLE_HOME= \/u00\/app\/oracle\/product\/11.2.0.4_ee\/db_1<br \/>\nEnter the full pathname of the local bin directory: [\/usr\/local\/bin]:<br \/>\nThe contents of \"dbhome\" have not changed. No need to overwrite.<br \/>\nThe contents of \"oraenv\" have not changed. No need to overwrite.<br \/>\nThe contents of \"coraenv\" have not changed. No need to overwrite.<br \/>\nEntries will be added to the \/etc\/oratab file as needed by<br \/>\nDatabase Configuration Assistant when a database is created<br \/>\nFinished running generic part of root script.<br \/>\nNow product-specific root actions will be performed.<br \/>\nFinished product-specific root actions.<br \/>\n<\/code><\/p>\n<p>Configure the DMK and the new ORACLE_HOME in the \/etc\/oratab file:<br \/>\n<code><br \/>\noracle@srvora01:\/home\/oracle\/ [rdbms11203] vio<br \/>\nrdbms11203:\/u00\/app\/oracle\/product\/11.2.0\/db_3_0:D<br \/>\nrdbms11204:\/u00\/app\/oracle\/product\/11.2.0.4_ee\/db_1:D<br \/>\nWSDBA1:\/u00\/app\/oracle\/product\/11.2.0\/db_3_0:Y<br \/>\nSource the profile if ORACLE_SID still empty :<br \/>\noracle@srvora01:\/home\/oracle\/ [rdbms11203] . ~\/.bash_profile<br \/>\nDummy:<br \/>\n------<br \/>\nDummy : rdbms11203(11.2.0\/db_3_0)<br \/>\nDummy : rdbms11204(11.2.0.4_ee\/db_1)<br \/>\nDatabase(s):<br \/>\n------------<br \/>\nOpen\/(No)Mount : WSDBA1(11.2.0\/db_3_0)<br \/>\nListener(s):<br \/>\n------------<br \/>\nStarted : EXTPROC_LSNR(11.2.0\/db_3_0) LISTENER(11.2.0\/db_3_0)<br \/>\noracle@srvora01:\/home\/oracle\/ [rdbms11203] rdbms11204<br \/>\noracle@srvora01:\/home\/oracle\/ [rdbms11204] cdh<br \/>\noracle@srvora01:\/u00\/app\/oracle\/product\/11.2.0.4_ee\/db_1\/ [rdbms11204]<br \/>\n<\/code><\/p>\n<p>Remove archive log from the database WSDBA1:<br \/>\n<code><br \/>\noracle@srvora01:\/u00\/app\/oracle\/product\/11.2.0.4_ee\/db_1\/ [WSDBA1] rmanc<br \/>\n---<br \/>\nRecovery Manager: Release 11.2.0.3.0 - Production on Fri Feb 20 15:27:41 2015<br \/>\n---<br \/>\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates. All rights reserved.<br \/>\n---<br \/>\nconnected to target database: WSDBA1 (DBID=2437526025)<br \/>\nusing target database control file instead of recovery catalog<br \/>\n---<br \/>\nRMAN&gt; delete noprompt force archivelog all;<br \/>\n---<br \/>\nSQL&gt; shutdown immediate;<br \/>\nDatabase closed.<br \/>\nDatabase dismounted.<br \/>\nORACLE instance shut down.<br \/>\n---<br \/>\nSQL&gt; startup mount;<br \/>\nORACLE instance started.<br \/>\n---<br \/>\nTotal System Global Area 1068937216 bytes<br \/>\nFixed Size 2235208 bytes<br \/>\nVariable Size 599786680 bytes<br \/>\nDatabase Buffers 461373440 bytes<br \/>\nRedo Buffers 5541888 bytes<br \/>\nDatabase mounted.<br \/>\nSQL&gt; alter database noarchivelog;<br \/>\n---<br \/>\nDatabase altered.<br \/>\n---<br \/>\nSQL&gt; alter database open;<br \/>\n---<br \/>\nDatabase altered.<br \/>\n<\/code><\/p>\n<p>Oracle Patch Update:<br \/>\n<code><br \/>\nunzip p6880880_112000_Linux-x86-64.zip<br \/>\noracle@srvora01:\/u00\/app\/oracle\/product\/11.2.0.4_ee\/db_1\/ [WSDBA1] mv OPatch\/ OPatch.old<br \/>\nmv \/u00\/app\/oracle\/software\/OPatch\/ \/u00\/app\/oracle\/product\/11.2.0.4_ee\/db_1\/<br \/>\n---<br \/>\nInstall the patch according to README.html<br \/>\n---<br \/>\nCheck the log file :<br \/>\noracle@srvora01:\/u00\/app\/oracle\/software\/19877440\/ [rdbms11204] vi \/u00\/app\/oracle\/product\/11.2.0.4_ee\/db_1\/cfgtoollogs\/opatch\/19877440_Feb_20_2015_15_34_10\/apply2015-02-20_15-34-10PM_1.log<br \/>\n<\/code><\/p>\n<h2>Upgrade Patchset 11.2.0.4 for WSDBA1<\/h2>\n<p>You can see the <a href=\"http:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e23633\/upgrade.htm#UPGRD12404\">Oracle Documentation for the Upgrade<\/a>. We need to execute the script <em>@utlu112i.sql for<\/em> the pre-upgrade. It performs a simple verification of the major database components prior to running a database and dictionary upgrade.<br \/>\n<code><br \/>\noracle@srvora01:\/u00\/app\/oracle\/product\/11.2.0.4_ee\/db_1\/rdbms\/admin\/ [WSDBA1] ls utlu*<br \/>\nutlu112i.sql utlu112s.sql utlu112x.sql utluiobj.sql utlurl.sql utlusts.sql<br \/>\n---<br \/>\noracle@srvora01:\/u00\/app\/oracle\/product\/11.2.0.4_ee\/db_1\/rdbms\/admin\/ [WSDBA1] sq<br \/>\n---<br \/>\nSQL*Plus: Release 11.2.0.3.0 Production on Fri Feb 20 13:57:08 2015<br \/>\n---<br \/>\nCopyright (c) 1982, 2011, Oracle. All rights reserved.<br \/>\n---<br \/>\nConnected to:<br \/>\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<br \/>\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options<br \/>\n---<br \/>\nSQL&gt; spool upgrde_info.log<br \/>\nSQL&gt; @utlu112i.sql<br \/>\nOracle Database 11.2 Pre-Upgrade Information Tool 02-20-2015 13:57:26<br \/>\nScript Version: 11.2.0.4.0 Build: 001<br \/>\n---<br \/>\n**********************************************************************<br \/>\nDatabase:<br \/>\n**********************************************************************<br \/>\n--&gt; name: WSDBA1<br \/>\n--&gt; version: 11.2.0.3.0<br \/>\n--&gt; compatible: 11.2.0.0.0<br \/>\n--&gt; blocksize: 8192<br \/>\n--&gt; platform: Linux x86 64-bit<br \/>\n--&gt; timezone file: V14<br \/>\n.<br \/>\n**********************************************************************<br \/>\nTablespaces: [make adjustments in the current environment]<br \/>\n**********************************************************************<br \/>\n--&gt; SYSTEM tablespace is adequate for the upgrade.<br \/>\n.... minimum required size: 531 MB<br \/>\n--&gt; SYSAUX tablespace is adequate for the upgrade.<br \/>\n.... minimum required size: 142 MB<br \/>\nWARNING: --&gt; TEMP tablespace is not large enough for the upgrade.<br \/>\n.... currently allocated size: 20 MB<br \/>\n.... minimum required size: 60 MB<br \/>\n.... increase current size by: 40 MB<br \/>\n.... tablespace is NOT AUTOEXTEND ENABLED.<br \/>\nWARNING: --&gt; UNDOTBS1 tablespace is not large enough for the upgrade.<br \/>\n.... currently allocated size: 200 MB<br \/>\n.... minimum required size: 400 MB<br \/>\n.... increase current size by: 200 MB<br \/>\n.... tablespace is NOT AUTOEXTEND ENABLED.<br \/>\n.<br \/>\n**********************************************************************<br \/>\nFlashback: OFF<br \/>\n**********************************************************************<br \/>\n**********************************************************************<br \/>\nUpdate Parameters: [Update Oracle Database 11.2 init.ora or spfile]<br \/>\nNote: Pre-upgrade tool was run on a lower version 64-bit database.<br \/>\n**********************************************************************<br \/>\n--&gt; If Target Oracle is 32-Bit, refer here for Update Parameters:<br \/>\n-- No update parameter changes are required.<br \/>\n.<br \/>\n--&gt; If Target Oracle is 64-Bit, refer here for Update Parameters:<br \/>\n-- No update parameter changes are required.<br \/>\n.<br \/>\n**********************************************************************<br \/>\nRenamed Parameters: [Update Oracle Database 11.2 init.ora or spfile]<br \/>\n**********************************************************************<br \/>\n-- No renamed parameters found. No changes are required.<br \/>\n.<br \/>\n**********************************************************************<br \/>\nObsolete\/Deprecated Parameters: [Update Oracle Database 11.2 init.ora or spfile]<br \/>\n**********************************************************************<br \/>\n-- No obsolete parameters found. No changes are required<br \/>\n.<br \/>\n**********************************************************************<br \/>\nComponents: [The following database components will be upgraded or installed]<br \/>\n**********************************************************************<br \/>\n--&gt; Oracle Catalog Views [upgrade] VALID<br \/>\n--&gt; Oracle Packages and Types [upgrade] VALID<br \/>\n--&gt; Oracle Workspace Manager [upgrade] VALID<br \/>\n.<br \/>\n**********************************************************************<br \/>\nRecommendations<br \/>\n**********************************************************************<br \/>\nOracle recommends gathering dictionary statistics prior to<br \/>\nupgrading the database.<br \/>\nTo gather dictionary statistics execute the following command<br \/>\nwhile connected as SYSDBA:<br \/>\n.<br \/>\nEXECUTE dbms_stats.gather_dictionary_stats;<br \/>\n.<br \/>\n**********************************************************************<br \/>\nOracle recommends reviewing any defined events prior to upgrading.<br \/>\n.<br \/>\nTo view existing non-default events execute the following commands<br \/>\nwhile connected AS SYSDBA:<br \/>\nEvents:<br \/>\nSELECT (translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2<br \/>\nWHERE UPPER(name) ='EVENT' AND isdefault='FALSE'<br \/>\n.<br \/>\nTrace Events:<br \/>\nSELECT (translate(value,chr(13)||chr(10),' ')) from sys.v$parameter2<br \/>\nWHERE UPPER(name) = '_TRACE_EVENTS' AND isdefault='FALSE'<br \/>\n.<br \/>\nChanges will need to be made in the init.ora or spfile.<br \/>\n**********************************************************************<br \/>\nSQL&gt; spool off<br \/>\n<\/code><\/p>\n<p>Resizing the information perquisite of differents tablespaces :<br \/>\n<code><br \/>\nSQL&gt; select name, bytes\/1024\/1024 from v$datafile;<br \/>\nNAME BYTES\/1024\/1024<br \/>\n------------------------------------------------------------ ---------------<br \/>\n\/u01\/oradata\/WSDBA1\/system01WSDBA1.dbf 1024<br \/>\n\/u01\/oradata\/WSDBA1\/sysaux01WSDBA1.dbf 600<br \/>\n\/u01\/oradata\/WSDBA1\/undotbs01WSDBA1.dbf 200<br \/>\n\/u01\/oradata\/WSDBA1\/tools01WSDBA1.dbf 100<br \/>\n\/u01\/oradata\/WSDBA1\/users01WSDBA1.dbf 500<br \/>\n\/u01\/oradata\/WSDBA1\/example01WSDBA1.dbf 500<br \/>\n.<br \/>\nSQL&gt; select name, bytes\/1024\/1024 from v$tempfile;<br \/>\n.<br \/>\nNAME BYTES\/1024\/1024<br \/>\n------------------------------------------------------------ ---------------<br \/>\n\/u01\/oradata\/WSDBA1\/temp01WSDBA1.dbf 60<br \/>\n.<br \/>\nSQL&gt; set feed on<br \/>\nSQL&gt; alter database tempfile '\/u01\/oradata\/WSDBA1\/temp01WSDBA1.dbf' resize 60M;<br \/>\nSQL&gt; alter database datafile '\/u01\/oradata\/WSDBA1\/undotbs01WSDBA1.dbf' resize 400M;<br \/>\n<\/code><\/p>\n<p>Execute the script <em>@utlu112i.sql<\/em> for the Pre-Upgrade:<br \/>\n<code><br \/>\nSQL&gt; @utlu112i.sql<br \/>\nOracle Database 11.2 Pre-Upgrade Information Tool 02-20-2015 14:01:32<br \/>\nScript Version: 11.2.0.4.0 Build: 001<br \/>\n.<br \/>\n**********************************************************************<br \/>\nDatabase:<br \/>\n**********************************************************************<br \/>\n--&gt; name: WSDBA1<br \/>\n--&gt; version: 11.2.0.3.0<br \/>\n--&gt; compatible: 11.2.0.0.0<br \/>\n--&gt; blocksize: 8192<br \/>\n--&gt; platform: Linux x86 64-bit<br \/>\n--&gt; timezone file: V14<br \/>\n.<br \/>\n**********************************************************************<br \/>\nTablespaces: [make adjustments in the current environment]<br \/>\n**********************************************************************<br \/>\n--&gt; SYSTEM tablespace is adequate for the upgrade.<br \/>\n.... minimum required size: 531 MB<br \/>\n--&gt; SYSAUX tablespace is adequate for the upgrade.<br \/>\n.... minimum required size: 142 MB<br \/>\n--&gt; TEMP tablespace is adequate for the upgrade.<br \/>\n.... minimum required size: 60 MB<br \/>\n--&gt; UNDOTBS1 tablespace is adequate for the upgrade.<br \/>\n.... minimum required size: 400 MB<br \/>\n.<br \/>\n**********************************************************************<br \/>\nFlashback: OFF<br \/>\n**********************************************************************<br \/>\n**********************************************************************<br \/>\nUpdate Parameters: [Update Oracle Database 11.2 init.ora or spfile]<br \/>\nNote: Pre-upgrade tool was run on a lower version 64-bit database.<br \/>\n**********************************************************************<br \/>\n--&gt; If Target Oracle is 32-Bit, refer here for Update Parameters:<br \/>\n-- No update parameter changes are required.<br \/>\n.<br \/>\n--&gt; If Target Oracle is 64-Bit, refer here for Update Parameters:<br \/>\n-- No update parameter changes are required.<br \/>\n.<br \/>\n**********************************************************************<br \/>\nRenamed Parameters: [Update Oracle Database 11.2 init.ora or spfile]<br \/>\n**********************************************************************<br \/>\n-- No renamed parameters found. No changes are required.<br \/>\n.<br \/>\n**********************************************************************<br \/>\nObsolete\/Deprecated Parameters: [Update Oracle Database 11.2 init.ora or spfile]<br \/>\n**********************************************************************<br \/>\n-- No obsolete parameters found. No changes are required<br \/>\n.<br \/>\n**********************************************************************<br \/>\nComponents: [The following database components will be upgraded or installed]<br \/>\n**********************************************************************<br \/>\n--&gt; Oracle Catalog Views [upgrade] VALID<br \/>\n--&gt; Oracle Packages and Types [upgrade] VALID<br \/>\n--&gt; Oracle Workspace Manager [upgrade] VALID<br \/>\n.<br \/>\n**********************************************************************<br \/>\nRecommendations<br \/>\n**********************************************************************<br \/>\nOracle recommends gathering dictionary statistics prior to<br \/>\nupgrading the database.<br \/>\nTo gather dictionary statistics execute the following command<br \/>\nwhile connected as SYSDBA:<br \/>\n.<br \/>\nEXECUTE dbms_stats.gather_dictionary_stats;<br \/>\n.<br \/>\n**********************************************************************<br \/>\nOracle recommends reviewing any defined events prior to upgrading.<br \/>\n.<br \/>\nTo view existing non-default events execute the following commands<br \/>\nwhile connected AS SYSDBA:<br \/>\nEvents:<br \/>\nSELECT (translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2<br \/>\nWHERE UPPER(name) ='EVENT' AND isdefault='FALSE'<br \/>\n.<br \/>\nTrace Events:<br \/>\nSELECT (translate(value,chr(13)||chr(10),' ')) from sys.v$parameter2<br \/>\nWHERE UPPER(name) = '_TRACE_EVENTS' AND isdefault='FALSE'<br \/>\n.<br \/>\nChanges will need to be made in the init.ora or spfile.<br \/>\n**********************************************************************<br \/>\nSQL&gt; EXECUTE dbms_stats.gather_dictionary_stats;<br \/>\nSQL&gt; SELECT (translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2<br \/>\nWHERE UPPER(name) ='EVENT' AND isdefault='FALSE' 2 ;<br \/>\nSQL&gt; set feed on<br \/>\nSQL&gt; SELECT (translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2<br \/>\nWHERE UPPER(name) ='EVENT' AND isdefault='FALSE'<br \/>\n2 3 ;<br \/>\n.<br \/>\nno rows selected<br \/>\n.<br \/>\nSQL&gt; SELECT (translate(value,chr(13)||chr(10),' ')) from sys.v$parameter2<br \/>\nWHERE UPPER(name) = '_TRACE_EVENTS' AND isdefault='FALSE'<br \/>\n2 3 ;<br \/>\n.<br \/>\nno rows selected<br \/>\n<\/code><\/p>\n<p>Shutdown the Database and change the location of the ORACLE_HOME:<br \/>\n<code><br \/>\nSQL&gt; shutdown immediate;<br \/>\nDatabase closed.<br \/>\nDatabase dismounted.<br \/>\nORACLE instance shut down.<br \/>\nSQL&gt; exit<br \/>\n.<br \/>\noracle@srvora01:\/u00\/app\/oracle\/product\/11.2.0.4_ee\/db_1\/rdbms\/admin\/ [WSDBA1] vio<br \/>\noracle@srvora01:\/u00\/app\/oracle\/product\/11.2.0.4_ee\/db_1\/rdbms\/admin\/ [WSDBA1] grep WSDBA1 \/etc\/oratab<br \/>\nWSDBA1:\/u00\/app\/oracle\/product\/11.2.0.4_ee\/db_1:Y<br \/>\noracle@srvora01:\/u00\/app\/oracle\/product\/11.2.0.4_ee\/db_1\/rdbms\/admin\/ [WSDBA1] . dmk.bash<br \/>\noracle@srvora01:\/u00\/app\/oracle\/product\/11.2.0.4_ee\/db_1\/rdbms\/admin\/ [rdbms11203] WSDBA1<br \/>\noracle@srvora01:\/u00\/app\/oracle\/product\/11.2.0.4_ee\/db_1\/dbs\/ [WSDBA1] ln -s \/u00\/app\/oracle\/admin\/WSDBA1\/pfile\/orapwWSDBA1<br \/>\noracle@srvora01:\/u00\/app\/oracle\/product\/11.2.0\/db_3_0\/dbs\/ [WSDBA1] mv orapwWSDBA1 \/u00\/app\/oracle\/product\/11.2.0.4_ee\/db_1\/dbs\/<br \/>\noracle@srvora01:\/u00\/app\/oracle\/product\/11.2.0.4_ee\/db_1\/dbs\/ [WSDBA1] sq<br \/>\nSQL*Plus: Release 11.2.0.4.0 Production on Fri Feb 20 14:07:54 2015<br \/>\n.<br \/>\nCopyright (c) 1982, 2013, Oracle. All rights reserved.<br \/>\n.<br \/>\nConnected to an idle instance.<br \/>\n<\/code><\/p>\n<p>Launch the Database in the mode startup upgrade:<br \/>\n<code><br \/>\nSQL&gt; startup upgrade<br \/>\nORACLE instance started.<br \/>\n.<br \/>\nTotal System Global Area 1068937216 bytes<br \/>\nFixed Size 2260088 bytes<br \/>\nVariable Size 734004104 bytes<br \/>\nDatabase Buffers 327155712 bytes<br \/>\nRedo Buffers 5517312 bytes<br \/>\nDatabase mounted.<br \/>\nDatabase opened.<br \/>\nSQL&gt; exit<br \/>\nDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production<br \/>\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options<br \/>\n<\/code><\/p>\n<p>Launch the script <em>@catupgrd.sql<\/em>:<br \/>\n<code><br \/>\noracle@srvora01:\/u00\/app\/oracle\/product\/11.2.0.4_ee\/db_1\/dbs\/ [WSDBA1] cd ..<br \/>\n.<br \/>\noracle@srvora01:\/u00\/app\/oracle\/product\/11.2.0.4_ee\/db_1\/ [WSDBA1] cd rdbms\/admin\/<br \/>\n.<br \/>\noracle@srvora01:\/u00\/app\/oracle\/product\/11.2.0.4_ee\/db_1\/rdbms\/admin\/ [WSDBA1] sq<br \/>\n.<br \/>\nSQL*Plus: Release 11.2.0.4.0 Production on Fri Feb 20 14:08:14 2015<br \/>\n.<br \/>\nCopyright (c) 1982, 2013, Oracle. All rights reserved.<br \/>\n.<br \/>\nConnected to:<br \/>\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production<br \/>\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options<br \/>\n.<br \/>\nSQL&gt; !ls catup*<br \/>\ncatupend.sql catupgrd.sql catupprc.sql catuppst.sql catupses.sql catupshd.sql catupstr.sql<br \/>\n.<br \/>\nSQL&gt; @catupgrd.sql<br \/>\n<\/code><\/p>\n<p>When it is finished executed scripts <em>@utul112s.sql<\/em>, <em>@catuppst.sql <\/em>and <em>@utlrp<\/em> :<br \/>\n<code><br \/>\nSQL&gt; startup<br \/>\nORACLE instance started.<br \/>\n.<br \/>\nTotal System Global Area 1068937216 bytes<br \/>\nFixed Size 2260088 bytes<br \/>\nVariable Size 734004104 bytes<br \/>\nDatabase Buffers 327155712 bytes<br \/>\nRedo Buffers 5517312 bytes<br \/>\nDatabase mounted.<br \/>\nDatabase opened.<br \/>\n.<br \/>\nSQL&gt; !ls utlu112*<br \/>\nutlu112i.sql utlu112s.sql utlu112x.sql<br \/>\nSQL&gt; @utlu112s.sql<br \/>\nSQL&gt; @catuppst.sql<br \/>\nSQL&gt; @utlrp<br \/>\n<\/code><\/p>\n<p>Start the post Installer for the PSU:<br \/>\n<code><br \/>\noracle@srvora01:\/u00\/app\/oracle\/software\/19877440\/ [WSDBA1] sq<br \/>\nSQL*Plus: Release 11.2.0.4.0 Production on Fri Feb 20 15:51:59 2015<br \/>\nCopyright (c) 1982, 2013, Oracle. All rights reserved.<br \/>\n.<br \/>\nConnected to:<br \/>\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production<br \/>\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options<br \/>\n.<br \/>\nSQL&gt; @postinstall.sql<br \/>\nPL\/SQL procedure successfully completed.<br \/>\nFunction created.<br \/>\n.....<br \/>\n.....<br \/>\n.....<br \/>\n20-FEB-15 03.46.36.204840 PM<br \/>\nUPGRADE SERVER<br \/>\n11.2.0.4.0<br \/>\nUpgraded from 11.2.0.3.0<br \/>\n.<br \/>\n6 rows selected.<br \/>\n.<br \/>\nSQL&gt; @utlrp.sql<br \/>\n<\/code><\/p>\n<p>When the Upgrade are successfully, we can repeat the training environment of the ORA-DBA-Essantials:<br \/>\n<code><br \/>\noracle@srvora01:\/u00\/app\/oracle\/local\/ORA-DBA-Essentials\/ [WSDBA1]<br \/>\n<\/code><\/p>\n<p>The last step is for the Oratab file, we need to delete the old environment :<br \/>\n<code><br \/>\n# Multiple entries with the same $ORACLE_SID are not allowed.<br \/>\n#<br \/>\n#<br \/>\n#rdbms11203:\/u00\/app\/oracle\/product\/11.2.0.3\/db_1:D<br \/>\nrdbms11204:\/u00\/app\/oracle\/product\/11.2.0.4_ee\/db_1:D<br \/>\n<\/code><\/p>\n<p>Now we have&nbsp;our Environment Oracle DBA Essentials Workshop to the release 11.2.0.4:<br \/>\n<code><br \/>\nSQL&gt; select * from v$version;<br \/>\n.<br \/>\nBANNER<br \/>\n--------------------------------------------------------------------------------<br \/>\nOracle Database 11g Enterprise Edition Release&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <strong>11.2.0.4.0<\/strong> - 64bit Production<br \/>\nPL\/SQL Release&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<strong>11.2.0.4.0<\/strong> - Production<br \/>\nCORE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<strong>11.2.0.4.0<\/strong> - Production<br \/>\nTNS for Linux: Version&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<strong>11.2.0.4.0<\/strong> - Production<br \/>\nNLSRTL Version&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<strong>11.2.0.4.0<\/strong> - Production<br \/>\n.<br \/>\n.<br \/>\nSQL&gt; SELECT version FROM product_component_version WHERE product like '%Database%';<br \/>\n.<br \/>\nVERSION<br \/>\n------------<br \/>\n<strong>11.2.0.4.0<\/strong><br \/>\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We have Upgrade our Environment Oracle DBA Essentials Workshop of release 11.2.0.3 to 11.2.0.4. From now on, you can operates the various subjects on the new release. In this article, I present you the procedure to be followed for the upgrade of your database: Update DMK to the version 14-10 Upgrade database Install Oracle Patchset [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":6127,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[326,23,559,17,572,416],"type_dbi":[],"class_list":["post-6122","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-binary","tag-dba","tag-dmk","tag-oracle-11g","tag-patch","tag-psu"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Oracle DBA Essentials Workshop - Patchset 11.2.0.4 Available - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle DBA Essentials Workshop - Patchset 11.2.0.4 Available\" \/>\n<meta property=\"og:description\" content=\"We have Upgrade our Environment Oracle DBA Essentials Workshop of release 11.2.0.3 to 11.2.0.4. From now on, you can operates the various subjects on the new release. In this article, I present you the procedure to be followed for the upgrade of your database: Update DMK to the version 14-10 Upgrade database Install Oracle Patchset [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-11-10T16:02:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-23T15:58:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"556\" \/>\n\t<meta property=\"og:image:height\" content=\"413\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle DBA Essentials Workshop &#8211; Patchset 11.2.0.4 Available\",\"datePublished\":\"2015-11-10T16:02:37+00:00\",\"dateModified\":\"2022-12-23T15:58:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/\"},\"wordCount\":319,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1-1.jpg\",\"keywords\":[\"Binary\",\"DBA\",\"DMK\",\"Oracle 11g\",\"patch\",\"PSU\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/\",\"name\":\"Oracle DBA Essentials Workshop - Patchset 11.2.0.4 Available - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1-1.jpg\",\"datePublished\":\"2015-11-10T16:02:37+00:00\",\"dateModified\":\"2022-12-23T15:58:50+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1-1.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1-1.jpg\",\"width\":556,\"height\":413},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle DBA Essentials Workshop &#8211; Patchset 11.2.0.4 Available\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle DBA Essentials Workshop - Patchset 11.2.0.4 Available - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/","og_locale":"en_US","og_type":"article","og_title":"Oracle DBA Essentials Workshop - Patchset 11.2.0.4 Available","og_description":"We have Upgrade our Environment Oracle DBA Essentials Workshop of release 11.2.0.3 to 11.2.0.4. From now on, you can operates the various subjects on the new release. In this article, I present you the procedure to be followed for the upgrade of your database: Update DMK to the version 14-10 Upgrade database Install Oracle Patchset [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/","og_site_name":"dbi Blog","article_published_time":"2015-11-10T16:02:37+00:00","article_modified_time":"2022-12-23T15:58:50+00:00","og_image":[{"width":556,"height":413,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1-1.jpg","type":"image\/jpeg"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle DBA Essentials Workshop &#8211; Patchset 11.2.0.4 Available","datePublished":"2015-11-10T16:02:37+00:00","dateModified":"2022-12-23T15:58:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/"},"wordCount":319,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1-1.jpg","keywords":["Binary","DBA","DMK","Oracle 11g","patch","PSU"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/","name":"Oracle DBA Essentials Workshop - Patchset 11.2.0.4 Available - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1-1.jpg","datePublished":"2015-11-10T16:02:37+00:00","dateModified":"2022-12-23T15:58:50+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1-1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1-1.jpg","width":556,"height":413},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-dba-essentials-workshop-patchset-11-2-0-4-available\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle DBA Essentials Workshop &#8211; Patchset 11.2.0.4 Available"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6122","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=6122"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6122\/revisions"}],"predecessor-version":[{"id":21269,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6122\/revisions\/21269"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/6127"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=6122"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=6122"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=6122"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=6122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}