![]() ![]() > TEMP tablespace is adequate for the upgrade. SQL> alter database datafile '/u01/oradata/WSDBA1/undotbs01WSDBA1.dbf' resize 400M SQL> alter database tempfile '/u01/oradata/WSDBA1/temp01WSDBA1.dbf' resize 60M SQL> select name, bytes/1024/1024 from v$tempfile SQL> select name, bytes/1024/1024 from v$datafile Resizing the information perquisite of differents tablespaces : WHERE UPPER(name) = '_TRACE_EVENTS' AND isdefault='FALSE'Ĭhanges will need to be made in the init.ora or spfile. SELECT (translate(value,chr(13)||chr(10),' ')) from sys.v$parameter2 ![]() WHERE UPPER(name) ='EVENT' AND isdefault='FALSE' SELECT (translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2 To view existing non-default events execute the following commands Oracle recommends reviewing any defined events prior to upgrading. To gather dictionary statistics execute the following commandĮXECUTE dbms_stats.gather_dictionary_stats Oracle recommends gathering dictionary statistics prior to > If Target Oracle is 64-Bit, refer here for Update Parameters: No update parameter changes are required. > If Target Oracle is 32-Bit, refer here for Update Parameters: Note: Pre-upgrade tool was run on a lower version 64-bit database. WARNING: -> UNDOTBS1 tablespace is not large enough for the upgrade. WARNING: -> TEMP tablespace is not large enough for the upgrade. > SYSAUX tablespace is adequate for the upgrade. > SYSTEM tablespace is adequate for the upgrade. With the Partitioning, OLAP, Data Mining and Real Application Testing options Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production Utlu112i.sql utlu112s.sql utlu112x.sql utluiobj.sql utlurl.sql utlusts.sql It performs a simple verification of the major database components prior to running a database and dictionary upgrade. We need to execute the script for the pre-upgrade. You can see the Oracle Documentation for the Upgrade. Total System Global Area 1068937216 bytes ![]() alias::sq::novar_noforce::"sqlplus '/ as sysdba'"::Īlias::rmanc::novar_noforce::"if [ -f $/OPatch":: We make a difference of parameter with the Old and New DMK version: :/u00/app/oracle/local/dmk/etc/ diff dmk.conf bin/bash :/u00/app/oracle/local/dmk/bin/./dmk.bashĬonfigure new DMK: :/u00/app/oracle/local/ cd dmk :/u00/app/oracle/local/dmk/ cd etc/ :/u00/app/oracle/local/dmk/etc/ cp dmk.conf :/u00/app/oracle/local/dmk/etc/ cp dmk.conf Unzip DMK-14-10-1 and resourcing: :/u00/app/oracle/local/ tar xvzf :/u00/app/oracle/local/ cd dmk/bin/ :/u00/app/oracle/local/dmk/bin/ echo $SHELL We need to Download, Unzip and configured Patch DMK. The first step it’s update Data Management Kit, included dmk_sql. Install Oracle Patchset 11.2.0.4 and PSU.In this article, I present you the procedure to be followed for the upgrade of your database: From now on, you can operates the various subjects on the new release. We have Upgrade our Environment Oracle DBA Essentials Workshop of release 11.2.0.3 to 11.2.0.4. ![]()
0 Comments
Leave a Reply. |