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 MoreThe 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 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 MoreFor 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 MoreThis 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 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 MoreThis 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 MoreThis 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 MoreThis 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 MoreHere 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