Category: Hints and Tips

#odtug, BI, cloud, conference, cool stuff, Data Migration, Database, Databases, HCM, HFM, Hints and Tips, Hyperion, Implementation, kscope14, OBIA, OBIEE, Oracle, PLSQL, SQL, technology, virtualization

Let The Games Begin! – #Kscope14

We kicked off KScope 14 with a great Community Service event with the Nature Consortium.  If you saw my tweet earlier, we HANDLED that Himalayan Blackberry.  I’ve got some of that stuff or a very close relative growing in my back yard, so I felt really good pulling that stuff out.  Not to be beat …

#odtug, ACE, ACEA, concurrent program, E-Business Suite, EBS, EBS 11i, Hints and Tip, Hints and Tips, hobby, Implementation, LINUX, Oracle, request set, Shell Script, support, technology, UNIX

Using Shell Scripts as Concurrent Programs in EBS

Using Shell Scripts as Concurrent Programs in EBS Recently, I started looking at way to address a scheduling problem when moving files associated with our business partners. We currently have a three step process: Schedule a Concurrent Program to produce a file Set up a cronjob to schedule a shell script to move and archive …

Batch file, CLI, Discoverer, Hints and Tips, hobby, Hyperion, Monitor, Oracle, Services, Windows, Windows Services

Monitoring Windows Services – The quick and dirty way

You’ve probably heard me mention that I don’t like for my users to be my “system unavailable” alerts.  I want to know as soon as, if not before, they do.  The challenge is how to monitor these service states (Discoverer, Hyperion, Informatica, and Glassfish) on Windows boxes in the absence of some tool I have …

Database, DBA, dbcapoeira, EBS, Error, Hints and Tip, Hints and Tips, Java, JDK, JRE, SQLDev

Installing SQL Dev 4.0 (JRE 1.6 and JDK 1.7)

I’m in an environment where our 11i version of EBS (I know we need to upgrade) still requires JRE 1.6 to open Oracle Forms.  Being an SQL Developer fan (listen to my podcast here), I decided to download and install SQL Dev 4.0.  Anyone that’s been following this knows that the latest release requires JDK …

12C, CDB, Containers, Database, Databases, DBA, Hints and Tips, ORA-01033, Oracle, PDB, Pluggable Databases, script, SQL, SQLDev, startup, Startup Script

Use Start-up Script to Modify State of your Pluggable Database to Open Read Write in SQL Developer 4.0 EA3 (ORA-01033)

I’m playing around with Oracle’s SQL Developer 4 EA3 and Database 12c.  Using SQL Dev, I quickly created a Pluggable Database (PDB). I try to open it, and I get this (ORA-01033). Then I remember reading that the Pluggable Databases don’t open automatically when the database services are started.  Well that sucks because now I …