Updating init ora

The DBUA can be started directly from the Oracle Universal Installer (OUI) or separately after the software installation is complete. SQL The Database Upgrade Assistant (DBUA) is a GUI tool that guides the user through the whole upgrade process, including all the steps listed in the manual upgrade process.Alternatively you may which to perform a manual upgrade which involves the following steps: An alternative to these upgrade methods is to use the export and import utilities (exp/imp or expdp/impdp). WARNING: -- EM Database Control Repository exists in the database. Direct downgrade of EM Database Control is not supported. 11g Upgrade Guide for instructions to save the EM data prior to upgrade. These recommended settings are listed in the sections below.

Whenever you start an Oracle instance, Oracle reads its initialization parameters from either the file or from the server parameter file, The "$ORACLE_HOME/rdbms/admin/utlu111i.sql" script performs pre-update validation checks on an existing instance. The script checks a number of areas to make sure the instance is suitable for upgrade including: @utlu111Oracle Database 11.1 Pre-Upgrade Information Tool . ********************************************************************** Update Parameters: [Update Oracle Database 11.1 or spfile] ********************************************************************** WARNING: -- "sga_target" needs to be increased to at least 336 MB . ********************************************************************** Obsolete/Deprecated Parameters: [Update Oracle Database 11.1 or spfile] ********************************************************************** -- "core_dump_dest" replaced by "diagnostic_dest" . edit and with the values you want for the NLS parameters !! Total System Global Area 2,0724E 10 bytes Fixed Size 3158000 bytes Variable Size 3070230544 bytes Database Buffers 1,7645E 10 bytes Redo Buffers 5230592 bytes Database mounted. When you sign in to comment, IBM will provide your email, first name and last name to DISQUS.

Leave a Reply