In my previous post (How To Create An Oracle Cloud Instance) I showed you create your first Oracle Cloud DB instance. Now that the instance is there the question is, how to connect to it?Let's say you want to connect using SQL Developer to start creating objects and inserting data. First you need to enable… Continue reading How To Connect To The Oracle Cloud DB Instance?
In my previous post (Thinking on trying the Oracle Cloud? My 30 day experience) I showed you how to subscribe to the Oracle Cloud and how to get to the main dashboard. From here we are going to click on the Create Instance button.After that you are going to be prompted on what kind if… Continue reading How To Create An Oracle Cloud Instance
Although I already had some exposure to the Oracle Cloud (thanks to other Oracle ACEs that put an awesome workshop last year at Collaborate 2017) , I decided to sign up for a free 30 day ($300 dollars credit) and test the Cloud out.The sing up process was kind of weird. You first go to… Continue reading Thinking on trying the Oracle Cloud? My 30 day experience.
Oracle’s documentation recommends to execute actualize_all inorder to purge old editions in the DB accumulated during previous patchingcycles.There’s a problem with EBS version 12.2.4 that when running adopphase=actualize_all you get an ORA-04045 errors duringrecompilation/revalidation of .You can try to manually recompile objects but all of them failwith the same error. This is documented under bug… Continue reading ORA-04045 When Running ADOP PHASE=ACTUALIZE_ALL
I got an error during an TXK patch in a 12.2 EBS instance. This happened while executing file xdotmgen.ldt.Error: FAILED: file xdotmgen.ldt on worker 1 for product fnd username APPS.Uploading from the data file....Uploading from staging tables Error during uploading. ORA-00600: internal error code, arguments: , [0x13C88677A0], , , , , , , , , ,… Continue reading TXK patch failing with ORA-600
I recently had an issue with an OEM agent 126.96.36.199 version running on Solaris. Looks like there’s a Java related bug which causes the agent to consume high amounts of CPU in the box. But the interesting part is this only happens when Listeners are being monitored. If you blackout the Listener targets this stops.If… Continue reading OEM 12c Agent Crashing on Solaris
If you have an issue to find an agent using a patch plan from OEM 13c, then you are likely facing a bug.Oracle explains the rationale in the MOS Id 2240307.1.You need to apply patch 25604219 in order to fix this issue. After this you can search your agent and add it to the patch… Continue reading OEM 13c – Unable to find agent in a patch plan
Amazon released a note late last year about Amazon’s RDS is now supporting Oracle Enterprise Manager Agents.Amazon RDS supports agent version 12 (188.8.131.52), 13R1 and 13R2 (184.108.40.206).You can use this to monitor your DB instances running on Amazon’s RDB but there are some limitations, like the fact you cannot execute jobs against those targets.See below… Continue reading OEM 13c and Amazon’s RDS
Here’s a list of some useful emctl commands to manage your OEM 13c agent.Get the status of the agent:$ emctl status agentOracle Enterprise Manager Cloud Control 13c Release 2Copyright (c) 1996, 2016 Oracle Corporation. All rights reserved.---------------------------------------------------------------Agent Version : 220.127.116.11.0OMS Version : 18.104.22.168.0Protocol Version : 22.214.171.124.0...Last Reload : (none)Last successful upload : 2018-05-15 09:04:32Last attempted… Continue reading OEM 13C Useful EMCTL Agent Commands
Looks like this is my first post about Oracle EBS. Yeah, looks like now I’m more on the dark side of the force.This is the time for ETCC. ETCC is a set of 2 scripts. One is going to check the recommended patches for the DB stack and the other one is going to check… Continue reading Oracle EBS 12.2 EBS Technology Codelevel Checker ETCC