• About Me

    Maxwell Miranda
    Oracle DBA Consultant.
  • Category

  • Archives

  • My Blog Calendar

    November 2010
    M T W T F S S
    « Oct   Mar »
  • RSS Oracle Feeds

    • Can't access database after power outage
      I could access the database before the power outage. From what I've read, it is a problem with the environment variables, but they are correct. Not sure what else to add. C:\Documents and Settings\konoca>sqlplus / as sysdba SQL*Plus: Release - Production on Wed Feb 21 09:17:08 2018 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERR […]
    • Problems with RESET DATABASE
      Recently I wanted to do RESET DATABASE. Oracle documentation suggests the following commands connect target / startup force nomount reset database to incarnation 2 run { set until time "date time" restore controlfile from autobackup alter database mount restore database recover database } alter database open resetlogs In this view my db has given e […]
  • Advertisements

11g: New Components

Following are new components which are available when installing Oracle 11g:

Oracle Application Express (APEX): APEX is a rapid application development tool for developing database centric web-based applications. In Oracle 11g, it is highly enhanced and available in the Oracle database CD.

Oracle SQL Developer: Oracle SQL Developer is a graphical tool for examining database objects and issuing SQL commands. It is automatically installed, if you create a template-based database.

Oracle Real Application Testing: Oracle Real Application Testing option is automatically installed with the Enterprise Edition installation. This option includes two solutions to test the effect of the system changes on the real-world applications: Database Reply and SQL Performance Analyzer. Both of those solutions will be discussed in later sections.

o Oracle Configuration Manager (OCM): OCM is an optional component and it collects information about software configuration in the Oracle home directories and uploads it to the Oracle configuration repository.

o Oracle Warehouse Builder: it is a business intelligence (BI) design tool and is automatically installed as part of the Oracle database software.

o Oracle Database Vault: Oracle Database Vault component enables you to secure business data even from DBAs. In Oracle 11g, it is a component available during installation and to install it, you must select the Custom installation option.

o Oracle Shadow Copy Service: When you install Oracle 11g on Windows 2003 servers, a service named as Volume Shadow Copy Service (VSS) is installed. This service is an infrastructure that enables the users to create snapshots called shadow copies.


Database Files layout

Recommendation to store the files of the
database system on different physical disks. In this example, the control file
is mirrored twice:



Contents of



Online redo log
files from the first and third group (Set A)



Online redo log
files from the second and fourth group (Set B)



Mirrored online
redo log files from the first and third group (Set A)



Mirrored online
redo log files from the second and fourth group (Set B)



Database files,
mirror of the control file



Database files,
mirror of the control file



Other database
files in sapdata3 up to
sapdata<n>, each on separate disks when

For performance reasons, it is recommended to distribute the online redo log groups to four disks