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 MoreDuplicating 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 MoreOracle 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 Moreopatch, 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 MoreDocuments 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 MoreOracle 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 MoreReader’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 MoreHow 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 MoreOverview 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 MoreReader’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