Tuesday, October 25, 2011

Installation and Configuring of Oracle Data Integrator on Linux

Hi,
There are lot of ETL tools available in the market like Informatica,Datastage...Here is one from Oracle,This tool is called ODI(Oracle Data Integrator) which is the ELT(Estraction Loading and Transformation) tool as per Oracle concepts.

Below are few steps for Installation and Configuration of ODI:

Below I'm describing the steps which I've followed to installed the Oracle Data Integrator(ODI)11g version 11.0.1.5.0 on linux platform,The Detailed step along with the installation Roadmap is given below:

Installation Roadmap:
The following tasks provide a brief description of the Oracle Data Integrator Installation Procedure, including a description of the installable components, pre and post-installation tasks, and process flow. This tasks are can be said as the Installation Roadmap.

Task1: Complete the installation planning requirements
Prior to installation you must prepare your system environment for installation. Review the general installation requirements for Oracle Fusion Middleware, as well as any specific configuration requirements for Oracle Data Integrator.

Task2:Pre-requistics Software should be installed.

1)Install and configure an Oracle Database
Refer previous posts of mine:

2)Install Oracle WebLogic Server:

Weblogic pre-installation steps:
Check the below Certification matrix wls.xls to check the supported Weblogic server for
Various Operating system.For our operating system RHEL 5.3 the supported
Weblogic server software is 10.3.

SQL> select name from v$database;

NAME
---------
FMWDB

SQL> select status from v$instance;

STATUS
------------
OPEN
SQL> show parameter processes
SQL> alter system set processes=1000 scope=spfile;
SQL> shutdown immediate
SQL> startup
SQL> show parameter processes

export FMW_HOME=$ORACLE_BASE/product/FMW

[root@testnode1FMW /]# mkdir -p Middleware/SOASuite11gR1
[root@testnode1FMW /]# chown oracle:oinstall /Middleware/SOASuite11gR1/
[root@testnode1FMW /]# chmod -R 755 /Middleware/SOASuite11gR1/

We have to create Middleware home directory for installation FUSION MIDDLEWARE COMPONENTS in this particular by granting the ownership to the ‘oracle’ user with all the required privileges.

Once your database is ready, we can install the next step, the WebLogic server.
When you are ready to install, complete the following.

I granted all the ownership to the oracle user and permission where the executable of weblogic software is present.I launched the installation on vm server

#xserver +
#xclock
=>This shoud display time,Use GUI mode for installing weblogic so that you can see the dispaly cleary..

,We have entered the Fusion Middlware Home path which has all the ownership and permission so that ‘oracle’ user can install weblogic server here.

Enter the common path like: /Middleware/

In step5 Make uninformed to ‘yes’ and proceed..

Choose Typical installation and proceed...

click next...
proceed...

3) Install Oracle Repository Creation Utility (RCU)

Note: The Oracle Repository Creation Utility (RCU) allows us to create and load a Master Repository and a Work Repository in a single database schema. RCU supports only the Oracle, Microsoft SQL Server and DB2 Databases. RCU only supports a single schema containing both the Master Repository and one Work Repository. Other technologies and configurations are supported by manually creating the repositories using the Oracle Data Integrator Studio after the installation phase.

Useful pre-requistics steps:


[oracle@testnode1FMW admin]$ hostname
testnode1FMW.apac.bosch.com
[oracle@testnode1FMW admin]$ tnsping fmwdb

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 29-JUL-2011 18:26:23

Copyright (c) 1997, 2009, Oracle. All rights reserved.

Used parameter files:
/u01/app//product/11.2.0/dbhome_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = fmwdb.apac.bosch.com)))
TNS-12541: TNS:no listener
[oracle@testnode1FMW admin]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 29-JUL-2011 18:26:30

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Starting /u01/app//product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app//product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/diag/tnslsnr/testnode1FMW/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testnode1FMW.apac.bosch.com)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 29-JUL-2011 18:26:32
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app//product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/diag/tnslsnr/testnode1FMW/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testnode1FMW.apac.bosch.com)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@testnode1FMW admin]$ tnsping fmwdb

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 29-JUL-2011 18:26:40

Copyright (c) 1997, 2009, Oracle. All rights reserved.

Used parameter files:
/u01/app//product/11.2.0/dbhome_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = fmwdb.apac.bosch.com)))
OK (30 msec)

2) Please do below step in Database side,If you are installing all the Oracle Fusion Middleware products,For SOA installation alone setting open_cursors=300,but as we are installating all the Oracle Fusion middleware products we need to set open_cursors=1000.

Conn “/as sysdba” in Database.

SQL> alter system set open_cursors=1000;

System altered.

SQL> show parameter open_cursors

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
open_cursors integer 1000

Now it is time to set up the database schema.
Note: If we have installed SOA 11g before and you are not upgrading, you must drop your existing database schema before reinstalling or create a second schema for this installation. We cannot reuse an existing schema.

Configure Schema using RCU
Now create the new schema.

Give the ownership and permission to ‘oracle’ user to run the repository creation utility.

[root@testnode1FMW /]# chown oracle:oinstall /Reposit_create_soft/
[root@testnode1FMW /]# chmod -R 755 /Reposit_create_soft/


[root@testnode1FMW Reposit_create_soft]# su - oracle
[oracle@testnode1FMW ~]$ pwd
/home/oracle
[oracle@testnode1FMW ~]$ cd /Reposit_create_soft/
[oracle@testnode1FMW Reposit_create_soft]$ ls -altr
total 389240
-rwxr-xr-x 1 root root 398173821 Jul 26 18:53 ofm_rcu_linux_11.1.1.5.0_disk1_1of1.zip
drwxr-xr-x 2 oracle oinstall 4096 Jul 27 10:36 .
drwxr-xr-x 37 root root 4096 Jul 28 10:26 ..
[oracle@testnode1FMW Reposit_create_soft]$ unzip ofm_rcu_linux_11.1.1.5.0_disk1_1of1.zip

[oracle@testnode1FMW /]$ cd Reposit_create_soft/
[oracle@testnode1FMW Reposit_create_soft]$ ls -altr
total 389244
drwxr-xr-x 32 oracle oinstall 4096 Apr 26 05:04 rcuHome
-rwxr-xr-x 1 root root 398173821 Jul 26 18:53 ofm_rcu_linux_11.1.1.5.0_disk1_1of1.zip
drwxr-xr-x 37 root root 4096 Jul 28 10:26 ..
drwxr-xr-x 3 oracle oinstall 4096 Jul 28 11:41 .
[oracle@testnode1FMW Reposit_create_soft]$ cd rcuHome/
[oracle@testnode1FMW rcuHome]$ ls
assistants common inventory jdk lib nls oraInst.loc plsql rcu relnotes sqlplus xdk
BC4J css javavm jlib modules oracleRoot.sh owm portal rdbms root.sh srvm
bin instantclient jdbc ldap network oracore perl precomp readme.htm sqlj util
[oracle@testnode1FMW rcuHome]$ cd bin

Go to path ‘/Reposit_create_soft_/rcuHome/bin’ as seen in the screenshot.

$ export Display

On Linux(UNIX):
./rcu

Step 4: Install Oracle Data Integrator 11g
Run Oracle Universal Installer (OUI) to install Oracle Data Integrator 11g. The Oracle Universal Installer automates many of the ODI installation and configuration tasks.

:Create ODI_HOME directory and grant ‘oracle’ user ownership
Create the ‘ODI_HOME’ directory.and Grant the ownership and permission to ‘oracle’ user for accessing ‘ODI_HOME’ directory.
[root@testnode1FMW Middleware]# cd /Middleware/
[root@testnode1FMW Middleware]# ls
JDev11g SOASuite11gR1
[root@testnode1FMW Middleware]# mkdir ODI_HOME
[root@testnode1FMW Middleware]# chown oracle:oinstall /Middleware/ODI_HOME/
[root@testnode1FMW Middleware]# chmod -R 755 /Middleware/ODI_HOME/
[root@testnode1FMW Middleware]# ls
JDev11g ODI_HOME SOASuite11gR1
[root@testnode1FMW Middleware]# ls -altr
total 24
drwxr-xr-x 37 root root 4096 Jul 28 10:26 ..
drwxr-x--- 13 oracle oinstall 4096 Aug 1 14:45 SOASuite11gR1
drwxr-xr-x 2 oracle oinstall 4096 Aug 2 18:24 JDev11g
drwxr-xr-x 2 oracle oinstall 4096 Aug 3 12:56 ODI_HOME
drwxr-xr-x 5 root root 4096 Aug 3 12:56 .
[oracle@testnode1FMW common]$ cd
[oracle@testnode1FMW ~]$ cd /ODI_11gsoft/
[oracle@testnode1FMW ODI_11gsoft]$ ls -altr
total 1887820
drwxrwxr-x 3 root root 4096 Apr 23 09:27 Disk2
drwxr-xr-x 5 root root 4096 Apr 30 03:14 Disk1
drwxr-xr-x 37 root root 4096 Jul 28 10:26 ..
-rw-r--r-- 1 root root 1931212170 Aug 4 11:44 ofm_odi_generic_11.1.1.5.0_disk1_1of1.zip
drwxr-xr-x 4 oracle oinstall 4096 Aug 4 14:29 .
[oracle@testnode1FMW ODI_11gsoft]$ su
Password:
[root@testnode1FMW ODI_11gsoft]# unzip ofm_odi_linux_11.1.1.5.0_32_disk1_1of1.zip

Verify the JDK home before launching the installation:

Our JDK home = /Middleware/SOASuite11gR1/jdk160_24

Granting ‘oracle’ user ownership and permission:

[root@testnode1FMW ~]# cd /ODI_11gsoft/
[root@testnode1FMW ODI_11gsoft]# ls -altr
total 1887820
drwxrwxr-x 3 root root 4096 Apr 23 09:27 Disk2
drwxr-xr-x 5 root root 4096 Apr 30 03:14 Disk1
drwxr-xr-x 37 root root 4096 Jul 28 10:26 ..
-rw-r--r-- 1 root root 1931212170 Aug 4 11:44 ofm_odi_generic_11.1.1.5.0 _disk1_1of1.zip
drwxr-xr-x 4 oracle oinstall 4096 Aug 4 14:29 .
[root@testnode1FMW ODI_11gsoft]# chown -R oracle:oinstall /ODI_11gsoft/Disk1
[root@testnode1FMW ODI_11gsoft]# chown -R oracle:oinstall /ODI_11gsoft/Disk2
[root@testnode1FMW ODI_11gsoft]# ls -altr
total 1887820
drwxrwxr-x 3 oracle oinstall 4096 Apr 23 09:27 Disk2
drwxr-xr-x 5 oracle oinstall 4096 Apr 30 03:14 Disk1


Login as ‘oracle’ user for launching the ODI 11g installation.

- Download the Oracle Data Integrator 11g and start the installer.
- Note: JDK home = /Middleware/SOASuite11gR1/jdk160_24


Click Next

- ODI step 2 : Select the ODI components to install. ODI Studio is the main component.


Select the components which you want…Select All for complete installations..
Click Next


Click Next

Note: An Application server should already be installed,We had installed Weblogic server in the same path.

Click Next

Select the Configure Repositories option, to configure the ODI Studio and the Stand Alone Agent with an existing Master and Work repositories pair.

Provide the Database Connection information
Enter User:DEV_ODI_REPO =>User used for odi metadata repository in Database ‘FMWDB’

Pass:welcome123

Click Next

Create the SUPERVISOR password
ODI Pass:welcome123

Click Next


Note: If we are installing agent we can provide the installation information as Agent=ODI_AGENT and Port:20910(Default port)=>This is the port which Agent will be listening…


Select the WorkRepository created with RCU

I created one response file in /home/oracle directory to review installation steps later


Click Install to install ODI 11g


Our ODI 11g installation and Configuration is successful

Click Next


I created the configuration file to refer later.


Click OK
Click Finish….


Hope it helps...

Happy ODI learning

1 comment:

  1. Hi,
    I do agree with all the ideas you have presented in your post. They’re really convincing and will certainly work. Still, the posts are very short for newbies.but have good information. Oracle EBS training
    Thank you.

    ReplyDelete