Apps DBA Workshop

I was facing  Issues on Oracle Enterprise Manager cloud control agent with Error "UPLOAD_SYSTEM Threshold (UploadMaxNumberXML: 5000) exceeded with 5698 files)" for command "emctl status agent" I tried to stop/start agent but failed to communicate with OMS Server. This Issue occurred because of incorrect configuration of open files. You need to properly configure the value for open files. I encountered this Issue on Oracle Solaris 10 OS. This Issue can also be encountered on other unix/linux flavour . Output for command "emctl status agent": [oemagent@oradb01][/oem/OEMAGENT/agent/agent_inst/bin]# ./emctl status agent Oracle Enterprise Manager Cloud Control 12c Release 2 Copyright (c) 1996, 2012 Oracle Corporation. All rights reserved. --------------------------------------------------------------- Agent Version : 12.1.0.2.0 OMS Version : (unknown) Protocol Version : 12.1.0.1.0 Agent Home : /oem/OEMAGENT/agent/agent_inst Agent B...

I received  an Incident from one of our customer that they are not able to apply patch on 10.1.2 ( Developer) Oracle Home for their recently cloned EBS R12 Instance. The command "opatch lsinventory is working fine when trying to apply the actual patch then its failing for "MISSING_COMPONENT : oracle.developer.reports.core, 10.1.2.3.0". Though component is included in the Inventory. Output from opatch lsinventory command: [oradev@TESTERP[/oradev]# opatch lsinventory Oracle Interim Patch Installer version 1.0.0.0.57 Copyright (c) 2007 Oracle Corporation. All Rights Reserved.. We recommend you refer to the OPatch documentation under OPatch/docs for usage reference. We also recommend using the latest OPatch version. For the latest OPatch version and other support related issues, please refer to document 293369.1 which is viewable from metalink.oracle.com Oracle Home : /oradev/R12_app/apps/tech_st/10.1.2 Oracle Home Inventory : /oradev/R12_app/apps/tech_st/...

 Oracle Solaris 11 is one of the well known operating system and due to its powerful compute capacities, there are many customers who are still using it. This blogpost will help you for performing Oracle EBS 12.2 Installation OS pre-requisites in simple two steps. As a part of preparation just we need to install the two pakcages and the OS will be ready for Kickking off the Oracle E-Business suite application. 1 - solaris-desktop 2 - oracle-ebs-server-R12-preinstall These packages will be installed using the Oracle Solairs repository, so there should be a valid package repository available that is needed for installing the packages. Installation of solaris-desktop package: root@ijr-svp-ebsdb1:~# pkg install solaris-desktop Packages to install: 337 Mediators to change: 1 Services to change: 17 Create boot environment: No Create backup boot environment: No DOWNLOAD PKGS FILES XFER (MB) ...