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 …

11gR2, Database, dbcapoeira, ORA-54013, Oracle, Rant, SQLDev, Table Export, Vent, Virtual Columns

Virtual Columns, Table Export, and Forums: A Love Hate Relationship (SQL Error: ORA-54013: INSERT operation disallowed on virtual columns)

Ok, so kind of a weird title, but let me explain. I believe that when you post to a forum, you are either seeking knowledge or sharing it.  I was on the SQLDev forum a few days ago, and someone posted what can be perceived as an error when exporting a table. Here is what …

Hints and Tip, Hyperion, Implementation, Oracle

Hyperion Implementation is Difficult

You would not believe the number of times I’ve heard that.  Every conference and product demo I went to.  This was a common sentiment.  To be honest, it is, but not impossible.  By following some simple yet important considerations, you can have a successful Hyperion implementation. Define Requirements Why are we doing this and what …

#odtug, board of directors, EPM, kscope, OBIEE 11g, Oracle

Service: ODTUG Board of Directors (#ODTUG) Voting 10/9 – 10/29

Greetings ODTUG Family: I wanted to officially wait until October before putting this out.  A great thing happened at Oracle Open World 2013.  I was nominated for the Board of Directors of ODTUG.  This is a great chance to serve, and I am humbled yet excited about the opportunity, therefore I am asking for your …

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 …

oow13, Open World, Oracle

Oracle Open World 2013 Day One (Saturday)

Been so inspired by all the new connections and reconnections.  Great to meet you Yuri (sp), Vanessa, Dan and others.  Good to see you again +ORACLENERD , +Bobby Curtis , +Galo Balda-Andrade , #dbakevlar,  +Tim Gorman , +Kent Graziano , #monty_odtug, +Lauren Prezby , +Crystal Walton   et al.  Today was a good day!  Got into San Francisco in good fashion, and had the opportunity to share …

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 …

Discoverer, EBS, Oracle, Reporting

Discoverer – Complex Folders Part 2

A couple of days late, but here is the how to guide for creating Complex Folders in Discoverer.  This post assumes knowledge of the Discoverer Administrator Tool. First we need to add the desired folders to a Business Area and Join the folders on the appropriate columns: Once you have created the Join, you need …