ODI - Creating a Repository in a 12c Pluggable Database
Posted
by David Allan
on Oracle Blogs
See other posts from Oracle Blogs
or by David Allan
Published on Tue, 2 Jul 2013 15:42:11 +0000
Indexed on
2013/07/02
17:10 UTC
Read the original article
Hit count: 521
/ODI Technical Feature Overviews
To install ODI 11g into an Oracle 12c pluggable database, one way is to connect using a TNS string to the pluggable database service that is executing. For example when I installed my master repository, I used a JDBC URL such as;
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=mydbserver)(PORT=1522)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PDBORA12.US.ORACLE.COM)))
I used the above approach rather than the host:port:sid which is a common mechanism many users use to quickly get up and going.
Below you can see the repository creation wizard in action, I used the 11g release and simply installed the master and work repository into my pluggable database.
Be wise with your repository IDs, I simply used the default, but you should be aware that these are key in larger deployments. The database in 12c has much more tighter control on users and resources, so just getting the user creating with sufficient resource on tablespaces etc in 12c was a little more work. Once you have the repositories up and running, then the fun starts using the 12c features. More to come.
© Oracle Blogs or respective owner