DBA Views


Comments

Post a Comment

Popular posts from this blog

Troubleshooting EBS login page issue in R12.2:

Troubleshooting EBS login page issue in R12.2: ------------------------------------------------------------------------------------------------------------------- 1. If the login page doesn't comes up then we have to focus on the varios logs present under $LOG_HOME directory. In case of EBS 12.2(as it is the latest release), 1) OHS (apache) failure If OHS is not running or not responding, one would see a message as below. If OHS is not running then there will not be any messages in any EBS log file for this request. Firefox: “The connection was reset” Steps to take Check OHS has started OK adapcctl.sh status adapcctl.sh stop adapcctl.sh start 2 OACore JVM process not available If the OACore JVM is not running or not reachable, then one will likely see the following message in the browser: Failure of server APACHE bridge: No backend server available for connection: timed out after 10 seconds or idempotent set to OFF or method not idempotent. There could be two reas...
Read more

Goldengate basics and Bounce

Goldengate basics, Components, and Bounce: --------------------------------------------------------- GoldenGate enables us to extract and replicate data across a variety of topologies as shown  the diagram below as well as the  exchange and manipulation of data at the transactional level between a variety of database  platforms like Oracle, DB2, SQL Server, Ingres, MySQL etc. It can support a number of different business requirements like: Business Continuity and High Availablity Data migrations and upgrades Decision Support Systems and Data Warehousing Data integration and consolidation  -- Let us know look at the differents components and processes that make up a typical GoldenGate  configuration on Oracle. Manager The Manager process must be running on both the source as well as target systems before the  Extract or Replicat process can be started and performs a number of functions including  monitoring and starting other Gol...
Read more

Useful Metalink Doc id for Oracle Apps and Core DBA

Useful Metalink Doc id for Oracle Apps and Core DBA : ============================================= R11i / R12: Component Version In Oracle Applications (Doc ID 1327288.1) How to Replace Oracle Logo with Company Logo on Applications 11i Sign-On Screen (Doc ID 119319.1) How To Set Concurrent Program To Run Exclusively From A Custom Manager (Doc ID 2268941.1) How to Create a Custom Concurrent Manager (Doc ID 170524.1) Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (Doc ID 1383621.1) How to Recover from a Lost or Deleted Datafile with Different Scenarios (Doc ID 198640.1) How To Change Log Archive Destination While the Database Is Open When the Archive Destination Is Full (Doc ID 160446.1) 12.2 E-Business Suite Applications DBA Steps To Create, Update or Rebuild The Central Inventory For Oracle Applications (Doc ID 1588609.1) E-Business Suite - ADOP Basic Usage Training Videos [Video] (Doc ID 2103131.1) How to Change IP Address in an Oracle Applicatio...
Read more