X

Welcome to All Things Warehouse Builder

  • June 25, 2013

Oracle Database 12c

David Allan
Architect

Exciting day today as Oracle Database 12c is released. You can find lots of information on the release on OTN here. With this release comes another milestone on Oracle's Data Integration roadmap - OWB is no longer shipped with the database. You will notice that the OWB documentation is no longer included with the Oracle Database documentation, you can compare and contrast the 11.2 and 12.1 documentation below.

OWB 11gR2 is still supported with Oracle Database 12c, you will need 11.2.0.3 plus at least CP2 which has been certified with Oracle Database 12c. The 11.2.0.4 release will wrapper this into one install.

Join the discussion

Comments ( 8 )
  • David Tuesday, June 25, 2013

    For anyone giving it a try, it's CP2 plus 13976111.

    Cheers

    David


  • Ray Hachem Wednesday, August 21, 2013

    This entry in your blog tends to suggest that 11.2.0.x will be the terminal release of OWB. What is the expected migration path for current users of OWB as we start thinking of moving into the 12c world? Will another product take the place of OWB?


  • guest Wednesday, August 21, 2013

    Hi Ray

    That's correct, 11.2.0.x is the terminal release, we are continuing with the roadmap and have been busy enhancing and building ODI 12c. The ODI 12c release is a good on ramp for OWB customers.

    You can find various road map and strategy documents on OTN;

    Statement of direction....

    http://www.oracle.com/us/products/middleware/data-integration/odi-statement-of-direction-1922235.pdf

    Presentation from OOW last year...

    http://www.oracle.com/openworld/lad-en/session-presentations/middleware/19963-enok-1437706.pdf

    Cheers

    David


  • Nishant Jain Sunday, March 1, 2015

    Hi David,

    As per information available on http://docs.oracle.com/cd/E11882_01/owb.112/e10582/intro_sources_targets.htm#WBDOD10501

    OWB is not supported by Oracle 12c. However, in your blog its look like that it does. Could you please advise what is the current status.

    Regards

    Nishant Jain


  • Nishant Jain Sunday, March 1, 2015

    Hi David,

    As per URL http://docs.oracle.com/cd/E11882_01/owb.112/e10582/intro_sources_targets.htm#WBDOD10501 . It is not mentioned that OWB is supported by Oracle 12c database. However, your blog mention that it does.

    could you please confirm whether OWB supported on Oracle 12c?

    Regards

    Nishant


  • David Monday, March 2, 2015

    Hi Nishant

    Yes it is supported the patches mentioned in the blog were released in order to support OWB on 12c database. OWB is no longer shipped in the database like in 12c, but can be installed into it.

    Cheers

    David


  • Greg Wednesday, March 4, 2015

    David,

    In your last comment, you mention installing OWB into a 12c database.

    I'm seeing information on how to upgrade an existing 11.2.0.4 database to 12c and update OWB, but I'm not seeing information on how to install a fresh 12c instance and then install the OWB 11.2.0.4 components into that database. Do you have any links or information to get me headed in the right direction?

    Thanks,

    Greg


  • David Tuesday, March 17, 2015

    Hi Greg

    The best information I think is actually in the readme which is not exactly obvious. See the read me for the CPs for example here is an extract from patch 17558955.

    8.2 Part 2 - Instructions on how to use OWB with the 12.1 pluggable RDBMS feature. OWB on a pluggable RDBMS operates the same as multi-instance/one OWB_HOME configuration.

    ODI-EE license license is required to use this functionality.

    8.2.1 Initial installation

    - For a given container database (cdb), there can be 1..n pluggable databases (pdb) installed in it. Each of these pdb databases exist on their own and will have their own

    service name.

    - Every pdb will be running it's own runtime service, and they will need their own properties files and log directories.

    - Connection to the pdb instance is in host:port:<pdb_name> (not the container db)

    - Each pdb must be configured before the next one is installed.

    - Follow support note (How To Clean Up The OWBSYS Repository In OWB 11g After An Upgrade Or Installation Failure (Doc ID 1332043.1) ) to seed & install the OWB

    repository within a pdb instance.

    - To configure the multi-instance, the following steps must be executed.

    - Stop the OWB runtime server

    sqlplus OWBSYS/<OWBSYS_PASSWORD>@<pdb_name>

    @?/owb/rtp/sql/stop_server.sql

    @?/owb/rtp/sql/setup_rt_for_multi_instances.sql <pdb_name>

    - Start the OWB runtime server

    sqlplus OWBSYS/<OWBSYS_PASSWORD>@<pdb_name>

    @?/owb/rtp/sql/start_server.sql

    - Install workflow in pdb instance (if needed)

    Before trying to install workflow on a RDBMS 12c database, the following change needs to be made.

    Modify $ORACLE_HOME/network/admin/sqlnet.ora

    # Add the following line

    SQLNET.ALLOWED_LOGON_VERSION = 8

    After the installation of the workflow schema has completed, this value can be removed from the sqlnet.ora file.

    Cheers

    David


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha
Oracle

Integrated Cloud Applications & Platform Services