All posts by Masroof Ahmad

Migrating Non ASM DB to ASM DB

This is a sample document showing how to migrate Non ASM DB to ASM DB 1 create the ASM instance 2.Create the required  DISK groups according to  the needs DB name DEVEL SQL> select file_name from dba_data_files; FILE_NAME ——————————————————————————– /oracle/DEVEL/system01.dbf /oracle/DEVEL/undotbs01.dbf /oracle/DEVEL/sysaux01.dbf /oracle/DEVEL/users01.dbf /oracle/DEVEL/example01.dbf SQL> select name from v$controlfile; NAME ——————————————————————————– /oracle/DEVEL/control01.ctl SQL> select MEMBER […]

Read More

Duplicating the DB from PRODUCTION to DEVELOPMENT using RMAN

The topic is related to creating a duplicated copy of  DB from production  to Development  using rman. The below steps are applicapable in 9i,10g and 11g.In 11g there are some new methods for creating duplicate DB  which I will be covering  in coming topics The database names used here database names: Primary Database SID:       PROD  server […]

Read More

Oracle Launches SOA Governance 11g : Enterprise Repository, Service Registry, SOA management with EM and Web Services Manager

Oracle has released Oracle SOA Governance 11g(component of Fusion Middleware)  which consists of following sub components Oracle Enterprise Repository (single source of truth for SOA assets) Oracle Service Registry (UDDI v3 compliant registry) Oracle Enterprise Manager Pack Plus for SOA (pack to monitor runtime services) Oracle Web Services Manager (tool to secure web services) For press release about […]

Read More

opatch, adpatch and now “smart update” (BSU) to apply weblogic patches

For Oracle Apps DBA its mandatory to know about opatch (utility to apply database patch) and adpatch (utility to apply apps patch) but if you are planning to upgrade your skills to Oracle Fusion Middleware 11g then think about learning new patching tool “Smart Update” (BSU). Smart Update (BSU – BEA Smart Update) – is a utility (java […]

Read More

Documents to install Oracle Apps (E-Business) R12 on Windows / Linux / Solaris

This post is from our Oracle Apps DBA Online Training [Weekend batches only for USD 699 from Home] here , next batch starting on 28th Feb 2010.  In this post I am going to cover Oracle Apps R12 Installation with link to Oracle Standard Document, Metalink Notes and link to sites including common installation issues . Oracle Apps R12 Installation […]

Read More

Oracle buys Amberpoint : SOA Governance and Management software

Oracle on Feb 8, 2010 announced that it has agreed to acquire AmberPoint , SOA Management, Business Transaction Management and run-time Governance software.  Acquisition is expected to extend Oracle’s leadership in Fusion Middleware and provide customers with advanced capabilities in SOA Governance and SOA management.  Amberpoint is among leaders in SOA Management mainly to enforce policies that […]

Read More

Reader’s Question : Cloning : can I copy Middle Tier while services are up (Hot Backup) ?

This post covers reader’s question around Cloning in Oracle Apps R12/11i : I want to clone my production instance without shutting down Application Tier and Database Tier. As per Metalink note 230672.1 “Cloning Oracle Applications 11i with Rapid Clone”, I have to shutdown Application Tier and Database Tier. For Database I can use RMAN for hot backup but […]

Read More

How to integrate WebLogic with Oracle Internet Directory for Login : Authentication

This post is from our Oracle WebLogic training for Administrators/DBA’s which covers step by step instructions on “How to integrate Oracle WebLogic Server with OID (Oracle Internet Directory) for user Login/Authentication” By Default Oracle WebLogic Server uses security realm with name “myrealm” that uses embedded LDAP server (two default users WebLogic & OracleSystemUser) that acts as data store […]

Read More

Overview of Securing Web Services in Fusion Middleware 11g (SOA / ADF / WebCenter)

This post covers basic concepts around securing web services in Fusion Middleware 11g. If you are administrator or developer, working on Fusion Middleware (and developing/managing web services) then you may find this post useful (This post covers conceptual points around web services security. For detailed steps and advanced topics stay tuned to this blog) 1) WebServices in […]

Read More

Reader’s Question : Autoconfig : What is difference between adautoconfig.sh, adautocfg.sh and adconfig.sh

Here is one of Reader’s Question around Autoconfig in Oracle Apps 11i/R12 “What is difference between adautoconfig.sh, adautocfg.sh and adconfig.sh ?” To those who are new to Oracle Applications , using AutoConfig you can reconfigure your Oracle E-Business Suite configuration from values mentioned in $CONTEXT_FILE  . To know more about Autoconfig click here  or read chapter 5 from Oracle […]

Read More