Category: Databases

#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 …

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 …

12C, BI, conference, Databases, dbcapoeira, EBS, oow13, Oracle, SQLDev, Troubleshooting

Oracle Open World 2013 – Wrap up (#OOW13)

So if you know anything about me, you will know that I am always amp’d up when it’s time for Oracle Open World.  This year was quite a different experience for me.  In previous years, I found myself running all across the Conference Complex attending session after session.  This year however, I took a different …

Data Migration, Database Copy, Databases, DBA, dbcapoeira, Migration, MSSQL migration, Oracle, SQL, SQLDev, SQLDev Cart

Story by a non-DBA: Database Migration with SQLDev EA1 v4.0

It’s been a while, but this 20 minutes turned 8 hour project was a lot of fun.  It just kept getting better and better.  Today boy and girls, I’m gonna take you through my process of migrating a MSSQL database to Oracle.  Let get stated. So, before we had Oracle EBS 11i (2008), there was …