Contents
What is the difference between 10g and 11g database?
Compared with Oracle 10g, the later version of Oracle 11g offers more simplified, automated, and advanced memory management tools and features. Oracle 11g offers invisible indexes, table partitioning, virtual columns, and the capability of redefining tables with materialized view logs even while the users are online.
How do I upgrade from Oracle 9i to 11g?
Upgrade from 9i to 11g
- The following is a real scenario for upgrading a 9.2.0.8 DB to 11.2.0.1.0 version on Redhat 4.7 in 28 Step.
- Required packges for installing 11g software: This for RHCL 4.7.
- Note ID: 429825.1.
- ———-
- Step 3: Save a script for Deprecated CONNECT Role:
- ———-
- Step 5: Upgrade the TIMEZONE version.
What is the major difference between 10g and 11g RAC?
What is the major difference between 10g and 11g RAC? Well, there is not much difference between 10g and 11gR (1) RAC. But there is a significant difference in 11gR2. From 11gR2(onwards) its completed HA stack managing and providing the following resources as like the other cluster software like VCS etc.
What is difference between 11g and 12c?
Oracle 12c is just upgraded version of the Oracle 11g with some new features like cloud support and pluggable database, kind of like master slave architecture….Difference between Oracle 11g and Oracle 12c.
| Sr. No. | 4. |
|---|---|
| Key | Cloud support |
| Oracle 11g | Oracle 11g doesn’t have cloud services |
| Oracle 12c | It provides Oracle cloud services. |
How to upgrade Oracle Database 10g to 11g?
Upgrade Oracle Database 10g to 11g Manual Upgrade Copyright (c) 1982, 2007, Oracle. All Rights Reserved. . . –> SYSTEM table space is adequate for the upgrade. …. AUTO EXTEND additional space required: 247 MB –> UN DOTBS1 table space is adequate for the upgrade.
How much space is needed for a 10g database?
AUTO EXTEND additional space required: 443 MB –> SYS AUX table space is adequate for the upgrade. …. AUTO EXTEND additional space required: 175 MB –> TEMP table space is adequate for the upgrade. …. AUTO EXTEND additional space required: 41 MB
How to set environment variables to Oracle Database 11g?
2.2 Set your environment variables to Oracle Database 11g Release 1 (11.1) : export PATH=$ORACLE_HOME/bin:$PATH:. Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to an idle instance. ORACLE instance started. Database mounted.
Where can I download Oracle 11g for SAP?
For the SAP we have to download Oracle 11g from SAP service marketplace. Download the latest version from SMP. Check the Memory , swap and Disk Space. SYSAUX and SYSTEM table-space should have minimum 200 MB free space. Check the oracle home directory’s OS level permission.