Saturday, October 5, 2013

Connect to a Pluggable Database from JDeveloper

I've been puzzling over the dearth of results about a simple problem, once the pluggable database has been created.  How do you connect to it from your web application?

I use JDeveloper, and after some "experimentation", I believe I stumbled on the answer.  Take a look at the configuration in the screen shot


The connection information looks identical to how i connect to the CDB.  But, instead of using the SID, I'm using the Service Name field.  The Service name starts with the pluggable database' SID.  In this case my pluggable database is pdsmall.  dachshund.com is my database domain.

Woof!

Tuesday, October 1, 2013

SQL*Plus Commands

From Oracle's 12c documentation, a helpful listing of useful SQL commands: http://docs.oracle.com/cd/E16655_01/server.121/e17322/sqlqraa001.htm#sthref1564

Many Thanks Inspires My Own Blog

I've worked in web development for the better part of a decade.  In large part, it's due to the charity of others who spent time with me or, via the internet, presented the impossible understandable.  I owe a deep sense of gratitude and thanks.  So this blog begins with a link to another blog that helped me out.  

I'm trying to install Oracle 12c database on a Debian machine.  This post deals with a 12c but on Ubuntu.  It bailed me out of two days of wayward progress.  Thanks GOP:  http://gemsofprogramming.wordpress.com/2013/09/19/installing-oracle-12c-on-ubuntu-12-04-64-bit-a-hard-journey-but-its-worth-it/#comment-90

Woof