Enable DDL auditing in 11GR2 Database:

Found intresting audit parameter in 11Gr2, enable_ddl_logging will allow the tracking of all ddl's in the alert log using the following:

Enable it by using the below command.

ALTER SYSTEM SET enable_ddl_logging=TRUE

All the DDL commands executed against the database will be recorded in the alert<SID>.log

More details of the DDL of the command executed can be found in the XML file in the alert directory

RMAN DUPLICATE DATABASE WITHOUT CONNECTING TO TARGET DATABASE

Have come across a requirement to clone a database using RMAN from from PROD to TEST in the same server

The only way you can clone a database from PROD to TEST (Different SID) in the same server is using RMAN duplicate command.

Usually RMAN duplicate command uses auxilary database and connect to target(PROD) database while creating the TEST.

We have a new feature in 11GR2, Which allows to clone using RMAN duplicate command without connecting to source PROD database.

It will only access the backup piecies and clones database.

This method works in cloning the database in the same server or different server

Source : PROD
Target : TEST

Steps:

1) Copy the Oracle home from source PROD to target TEST and create the parameter file for TEST database

2) Copy the backupsets to TEST server (If the clone is in the same server, This step is not required)

3)If you are cloning the database in the same server as PROD,Modify the below two parameters in the TEST (target instance),

This step is very importent step to mention the different directory structure for TEST datafiles if you are restoring on the same server as PROD.

db_file_name_convert=('/oradata/PROD' '/oradata/TEST')
log_file_name_convert=('/oradata/PROD' '/oradata/TEST')

4) Start the TEST Instance (This is called as auxilarary database)
$ sqlplus "/ as sysdba"
SQL> startup nomount;

5) Run the RMAN duplicate command from
rman auxiliary /
RMAN> DUPLICATE DATABASE TO NEWDB BACKUP LOCATION '/RMAN_Backup_Location/';

Fusion Applications Installation FAQ - I

=> Why Oracle Fusion Applications?

Designed from the ground up using the latest technology advances and incorporating the best practices gathered from Oracle's thousands of customers, Oracle Fusion Applications are 100 percent open-standards-based business applications that set a new standard for the way we innovate, work, and adopt technology. Built on a set of unique design principles, only Oracle Fusion Applications set a new standard for business.

Oracle Fusion Applications are a complete, standards-based platform.
Oracle Fusion Applications also provide a flexible approach to adoption and deployment.
Oracle Fusion Applications application and process leadership give you the “best-of-the-best” combination.

=> What ar ethe different version of the Fusion Applications Available now?

The base (First) Version of Fusion Applications is
Oracle Fusion Applications 11g (11.1.1.5.1)  -
Oracle Fusion Applications 11g (11.1.2.0.0)  - RUP1
Oracle Fusion Applications 11g (11.1.3.0.0)  - RUP2
Oracle Fusion Applications 11g (11.1.4.0.0)  - RUP3 (Latest)
=> You can directly install any version or upgrade to that version, i.e IN order to install RUP3, We dont require the base version to be installed first.
 Directly RUP3 can downloaded and installed.

=> How big is it?
The software size is approx 50GB

=> What are the different components of Fusion Applications ?

Fusion Applications is combination of two families

1)IDM Family
2)Fusion Applications Family

1) Identity Management (IDM) for Fusion Applications involves installation of the following:

• Oracle Database 11g R2
• JDK (JRockit 64-bit)
• Oracle WebLogic Server
• Oracle Fusion Middleware Web Tier (Oracle HTTP Server)
• Oracle Fusion Middleware SOA Suite
• Oracle Identity Management (OID and OVD)
• Oracle Identity and Access Management (OIM and OAM)
• Oracle Access Manager WebGate

2) Fusion Applications installation of the following:

• Oracle Database 11g R2
• JDK (JRockit 64-bit)
• Oracle WebLogic Server
• Oracle Fusion Middleware Web Tier (Oracle HTTP Server)
• All the modules of Fusion Applications deployed as Weblogic Domains
  - The numbers of managed/applications servers depends on the number of modules chosen to install, This number can go as high as 60+

...watch this space for more updates on Fusion Applications

Fusion Applications (FA) Installation

Have completed Fusion Applications Installations, 

Watch this space for more information on Fusion Applicatins Installation and Administration........

Below are the logn screens of Fusion Applications

Oracle EM 12C Grid Installation

Have recently Installed Oracle EM 12C Grid on Linux x86_64.

EM 12C Grid contains weblogic and JDK , It is installed automatically along with the EM (If you have not already installed weblogic separetely)

Installing Database 11G (11GR1 or 11GR2) is a pre-requisite for installing EM 12c.

Modify the recomended parameters (these will shown while installing) for better performence of EM.

Below are the high level steps:

1) Install Oracle database 11G ( Have installed 11GR2)
2) Remove the EM schema components (SYSMAN) from the database, Using the below command.

$<ORACLE_HOME>/bin/emca -deconfig dbcontrol db -repos drop -SYS_PWD <sys pasword> -SYSMAN_PWD <sysman password>
 3) Install EM 12c by running runinstaller.

Login to EM 12c :

https://exmaple.oracle:7801/em
Login using User ID sysman and password chosen during the install

https://exmaple.oracle.com:7102/console
Login using User ID sysman and password chosen during the install

How To start EM Grid Control follow the steps below:

1. Start the listener
2. Start the database
3. Start OMS11g using the command <EM OMS Oracle Home>/bin/emctl.sh start oms -all
5. Go to the WLS Console and start the EM Domain (if not already started)

Find the below step by step screen shots of EM Installation ....