How To Connect To The Oracle Cloud DB Instance?

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?

Thinking on trying the Oracle Cloud? My 30 day experience.

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.

ORA-04045 When Running ADOP PHASE=ACTUALIZE_ALL

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

TXK patch failing with ORA-600

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: [17273], [0x13C88677A0], [0], [7], [], [], [], [], [], [], [],… Continue reading TXK patch failing with ORA-600

OEM 13c and Amazon’s RDS

Amazon released a note late last year about Amazon’s RDS is now supporting Oracle Enterprise Manager Agents.Amazon RDS supports agent version 12 (12.1.0.5), 13R1 and 13R2 (13.2.0.0).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

OEM 13C Useful EMCTL Agent Commands

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          : 13.2.0.0.0OMS Version            : 13.2.0.0.0Protocol Version       : 12.1.0.1.0...Last Reload            : (none)Last successful upload                       : 2018-05-15 09:04:32Last attempted… Continue reading OEM 13C Useful EMCTL Agent Commands