keropmarine.blogg.se - Oracle 10g to 11g upgrade

#Oracle 10g to 11g upgrade install
#Oracle 10g to 11g upgrade manual
#Oracle 10g to 11g upgrade Patch
#Oracle 10g to 11g upgrade upgrade

The command prompt window only appears if you perform a new installation (under a different user), or if the ORACLE_HOME and are not set.

#Oracle 10g to 11g upgrade install

If a command prompt window appears, specify the drive letter of the local disk where you want to install the Oracle software, and the. Start the Oracle Universal Installer (OUI) by double-clicking the file sapserver.cmd. Otherwise, the Oracle Universal Installer cannot perform installation prerequisite checks. Make sure that you have enough space for the Oracle inventory and that you have full access to the directories (inventory, installation location, temp directory). For more information about identifying and installing the correct Oracle database software version, see SAP note 1431799.

#Oracle 10g to 11g upgrade Patch

Installing the Oracle 11g Server SoftwareĪs of now Oracle 11.2.0.3 is Oracle database patch sets are full installations of the Oracle database software.

Need 5- to 7 GB free space on new oracle directory (where software going to install).

Stop the SAP Instances and services(don’t stop oracle services).

Check the oracle home directory’s OS level permission.

SYSAUX and SYSTEM table-space should have minimum 200 MB free space.

Check the Memory, swap and Disk Space.

Existing data base should be highest patch level (oracle 10g 10.2.0.5.0) (OPatch not mandatory).

For the SAP we have to download Oracle 11g from SAP service marketplace. We have to install 11g home as a separate ORACLE_HOME in parallel to 10g Oracle Home and follow the steps to upgrade.

#Oracle 10g to 11g upgrade upgrade

We cannot do patch upgrade kind of things since 11g is not a patch set of Oracle. Impdp directory=DATA_PUMP_DIR full=y dumpfile=export.dmp logfile=import.This blog is step by step guide to upgrade Oracle 10g to Oracle 11g. Note: If you have co-existing oracle home/version on development server, please make sure switching to Oracle 11g environment, which will assure to use data pump at 11g version to import data. Step 5: Import full database to target 11g database Step 4: Grant IMPORT_FULL_DATABASE system privilege to user SYSTEM of target 11g database Step 3: Copy dumpfile over network to development server

Step 2: Export full database of source 10g databaseĮxpdp directory=DATA_PUMP_DIR full=y dumpfile=export.dmp logfile=export.log

Editing generated script to remove entries for SYSTEM, USERS tablespaces.

Using the Generate_Create_Tablespaces.sql to generate tablespace script.

Step 1: Pre-create tablespaces on target 11g database After that, we followed the following steps to move data from 10g database to newly created 11g database. With this approach, we first installed Oracle 11g software on development server and created empty database by using provided standard template New_Database.dbt, which could be found at $ORACLE_HOME/assistants/dbca/templates.

We want to keep original production databases unchanged anyway for safety reason.

We want to set up identical testing databases on development server first.

The reasons we decided using this method are:

#Oracle 10g to 11g upgrade manual

Manual Upgrade (Oracle provided scripts)īesides benefits mentioned in above upgrade document, I’m thinking we are beneficial from using export/import approach.

As described in “ Oracle Database Upgrade Guide 11g Release 1 (11.1)“, there are three upgrade methods offered while you want to upgrade database from 10g to 11g.