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 …
Category: Hints and Tips
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 …
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 …
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 …
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 …