Oracle Database 12c

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.

Comments:

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

Cheers
David

Posted by David on June 25, 2013 at 03:52 PM PDT #

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?

Posted by Ray Hachem on August 21, 2013 at 12:24 PM PDT #

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

Posted by guest on August 21, 2013 at 01:39 PM PDT #

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

Posted by Nishant Jain on March 01, 2015 at 02:41 PM PST #

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

Posted by Nishant Jain on March 01, 2015 at 02:44 PM PST #

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

Posted by David on March 02, 2015 at 09:17 AM PST #

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

Posted by Greg on March 04, 2015 at 03:04 PM PST #

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

Posted by David on March 17, 2015 at 11:59 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

ETL, CDC, Real-Time DI and Data Quality for the Oracle Database from the inside.

Search

Archives
« April 2015
SunMonTueWedThuFriSat
   
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
  
       
Today