Installing Oracle Data Integrator (ODI)

Introduction

Oracle Data Integrator delivers unique next-generation Extract Load and Transform (E-LT) technology that improves performance, reduces data integration costs, even across heterogeneous systems. Oracle Data Integrator offers the productivity of a declarative design approach, as well as the benefits of an active integration platform for seamless batch and real-time integration. In addition, hot-pluggable Knowledge Modules provide modularity, flexibility, and extensibility. Use Oracle Data Integrator together with Oracle Data Profiling and Data Quality for advanced data governance capabilities. Use Oracle Data Integrator together with Oracle SOA Suite to enable service-oriented data integration and management that gives companies even greater flexibility for their data services.

You can explore more on this product at OTN : http://www.oracle.com/technology/software/index.html

Downloading the software

You can down the ODI software from OTN : http://www.oracle.com/technology/software/products/odi/index.html

We are going to see here the installation of ODI 10.1.3.4.0 on Linux x86.

Install Pre-reqs

For installing and configuring ODI, you need to have a SOA 10.1.3 basic installation. When I mean basic installation, it should have a web server and a OC4J container. Basically ODI is going to provide some WAR file which we are going to deploy in OC4J container provided by SOA. So SOA installation is not actually a pre-requisite, but a requisite. You can carry out SOA installation even after installing ODI.

Installing ODI

Once you download the software unzip the same and go to the unziped directory. But inside this directory you wont be able to see runInstaller. Navigate to setup/Linux/Disk1/install directory. Here you will find runInstallation. Follow the below screens to install ODI.

./runInstaller -invPtrLoc $HOME/odi/oraInventory/oraInst.loc

1

Here you can select first option which will install all the components.

2

Again here select the complete installation.

3

Select the ORACLE_HOME name and path that you want to give

41

Provide the repository port and scheduler port. This option you will see only if you are going for all options along with ODI as select on screen 1 above.

Finally you will see the summary screen. Click on install.

At the end of install it will ask you to run root.sh script as a root user. Once run, installation completes and you can exit the isntaller.

Add the following environment variables for the user who has installed Oracle Data Integrator:

  • ODI_JAVA_HOME=<ODI_HOME>/jre/1.4.2
  • TS_QUALITY=<ODI_HOME>/oracledq/quality_server/tsq11r5s/Software
  • LD_LIBRARY_PATH=<ODI_HOME>/oracledq/quality_server/tsq11r5s/Software/bin

Installing SOA

You can check the SOA installation using my previous post Installing SOA 10g (10.1.3.4) – Fusion Middleware

The only change required in that installation is on the screen 3)

Screen 3) select “J2EE Server, Web Server and SOA Suite” for complete installation.

Instead of selecting “J2EE Server, Web Server and SOA Suite”, please select “J2EE Server and Web Server” as we want only the basic install.

After installing SOA next step comes the deployment part. Following below steps for deploying each application of ODI in SOA.

Deploying ODI Applications

Once the SOA installation completes, login to SOA Enterprise Manager

http://hostname.domain:http_port/em/

in my case its

http://rws60076rems.us.oracle.com:7777/em/

When you login as oc4jadmin in EM you will see home as a default container on the home page. This is the container we are going to use for deploying out ODI applications.

5

Deploying MetaData Navigator

  • To install metadata navigator copy oracledimn.war from software dump to the SOA deployment directory.
  • oracledimn.war will be present in <software dump dir>/setup/Manual
  • Copy this file to SOA_ORACLE_HOME/j2ee/home/applications directory
  • Login to SOA EM console and click on home (oc4j instance)
  • go to Applications tab

6

  • Click on Deploy button

On the deployment page under the Archive section select the second dropdown “Archive is already present on the server where Application Server Control is running.” and give the location of server as applications/oracledimn.war

7

  • Click on Next
  • Give the application name and the context for the same. This can be any thing that you want, but should be distinct  from other applications.

8

  • Click on Next and then click on Deploy.
  • Once deployed click on “Return” button, you will be able to see the application under home oc4j instnace.
  • You can click on the application -> on next page, click on the module name and on the next page click on the icon “Test Web Module”. You should be able to open the application.

In my case the URL was http://rws60076rems.us.oracle.com:7777/oracledimn

Installing Lightweight Designer

  • To install lightweight designer copy oracledilwd.war from software dump to the SOA deployment directory.
  • oracledimn.war will be present in <software dump dir>/setup/Manual
  • Copy this file to SOA_ORACLE_HOME/j2ee/home/applications directory
  • Login to SOA EM console and click on home (oc4j instance)
  • go to Applications tab
  • Click on Deploy button

On the deployment page under the Archive section select the second dropdown “Archive is already present on the server where Application Server Control is running.” and give the location of server as applications/oracledilwd.war

9

  • Click on Next
  • Give the application name and the context for the same. This can be any thing that you want, but should be distinct  from other applications.

10

  • Click on Next and then click on Deploy.
  • Once deployed click on “Return” button, you will be able to see the application under home oc4j instnace.
  • You can click on the application -> on next page, click on the module name and on the next page click on the icon “Test Web Module”. You should be able to open the application.

In my case the URL was http://rws60076rems.us.oracle.com:7777/oracledilwd


Configure the repository connections for Lightweight Desiginer

Configuring the Datasources for OC4J

You can configure the data-sources either from the frontend using SOA EM or from the backend by updating data-sources.xml file present in $SOA_ORACLE_HOME/j2ee/home/config directory.

You can make following entry in data-sources.xml file to configure the datasource.


<span class="x24">  <managed-data-source name="Test_datasource"
    connection-pool-name="</span><span class="x24">Test_pool</span><span class="x24">"
    jndi-name="jdbc/test_datasource"/>

  <connection-pool name="</span><span class="x24">Test_pool</span><span class="x24">">
    <connection-factory factory-class="oracle.jdbc.pool.OracleDataSource"
      user="system"
      password="sys123"
      url="jdbc:oracle:thin:@//rws60066rems:1617/prod4fmw">
    </connection-factory>
  </connection-pool>
</span>

Installing the Oracle Data Integrator Public Web Services

This component can be deployed in any web service container normally a Java application server.
It is provided as a Axis2 Archive File.

So to deploy this application you need to first have the Axis application either installed on your host or deplyoed as a J2EE application in your SOA OC4J instance. In this case I am just going to deploy the Axis application in my SOA instnace and then use that application to deploy Oracle Data Integrator Public Web Services.

You can download Axis application from Apache.org site : http://ws.apache.org/axis2/download.cgi

Download the latest version and unzip the same on your linux host. After unzipping you will get axis2.war

  • To install axis2 application, copy axis2.war from axis dump to the SOA deployment directory.
  • Copy axis2.war to SOA_ORACLE_HOME/j2ee/home/applications directory
  • Login to SOA EM console and click on home (oc4j instance)
  • go to Applications tab
  • Click on Deploy button

11

  • Click on Next
  • Give the application name and the context for the same. This can be any thing that you want, but should be distinct  from other applications.

12

  • Click on Next and then click on Deploy.
  • Once deployed click on “Return” button, you will be able to see the application under home oc4j instnace.
  • You can click on the application -> on next page, click on the module name and on the next page click on the icon “Test Web Module”. You should be able to open the application.

In my case the URL was http://rws60076rems.us.oracle.com:7777/axis2


  • Now we can install Oracle Data Integrator Public Web Services which is provided as Axis2 Archive File.
  • First ftp the odi-public-ws.aar file to your windows box as you have to browse in the Axis application and give the file
  • The .aar will be present under <ODI dump Directory>/oracledi/tools/web_services
  • On the Axis applicaiton http://rws60076rems.us.oracle.com:7777/axis2 click on home link and then click on Administration link.
  • login as admin/axis2
  • On the left side of the page under “Tools” you will see “Upload Service”
  • Browse the .aar file you ftped to your windows box and click on upload

You will see the message “File odi-public-ws.aar successfully uploaded”

After deploying these application next and the last thing that is remaining is creating the repository.

Oracle Data Integrator Repositories

There are two types of repositories:

  • Master Repository: Data structure containing information on the topology of the company’s IT
    resources, on security and on version management of projects and data models. This
    repository is stored on a relational database accessible in client/server mode from the different
    Oracle Data Integrator modules.
    In general, you need only one master repository.
  • Work Repository: Data structure containing information on data models, projects, and their
    use. This repository is stored on a relational database accessible in client/server mode from
    the different Oracle Data Integrator modules.
    Several work repositories can be designated with several master repositories if necessary.
    However, a work repository can be linked with only one master repository for version
    management purposes.

The steps to follow to create repositories are detailed below:

  1. Creating repository storage spaces
  2. Creating the master repository
  3. Connecting to the master repository
  4. Creating a work repository
  5. Connecting to the Work repository

1) Creating repository storage spaces

This involves creating 2 schemas in the database, one for master repository and one for work repository. Use the following commands to create repository in Oracle database

Master Repository:

create user master_rep identified by welcome1 default tablespace users temporary tablespace temp;

grant connect, resource to master_rep;

Work Repository:

create user work_rep identified by welcome1 default tablespace users temporary tablespace temp;

grant connect, resource to work_rep;

2) Creating the master repository

Navigate to the installation directory of ODI and go to oracledi/bin directory

run repcreate.sh

Master repository creation wizard will open. Enter the details for Driver, URL, User and password. Below image shows the same. For selecting driver and URL you have a button in front of the field, click on that and then select the same. For URL details fill in the appropriate JDBC URL info corresponding to your database.

Choose the technology as Oracle if you are using Oracle database.

ID:  A specific ID for the new repository, rather than the default 0. This will affect imports and exports between repositories.

13

As soon as you click on OK, it will create all the objects in database schema – master_rep.

After the objects are created in repository, you will get the message “Repository Creation successful. Do you want to quite Oracle Data Integrator wizard?”.

Click on OK.

3) Connecting to the master repository

After creating master repository, next we have to create a work repository. For that we have to connect to master repository first.

For connecting to master repository use topology.sh script present in oracledi/bin directory. Following screen will open

21

Click on the New icon just in front of dropdown to configure the master repository to connect to.

Oracle Data Integrator Connection:

  • Login name: A generic alias (for example: Repository:
  • User: SUPERVISOR (use capitals)
  • Password: SUNOPSIS (use capitals)

DBMS Connection (Master Repository):

  • User: User id / login of the owner of the tables you have created for the master repository
  • Password: This user’s password
  • Drivers’ List: choose the driver required to connect to the DBMS supporting the master
  • repository you have just created
  • URL: The complete path of the data server hosting the repository. For more information,
  • refer to the section JDBC URL Sample

The example of values in my case is as shown below. Please TEST the connection before clicking on OK

31

Once the connection is successful, click on OK and connect to master repository using SUPERVISOR/SUNOPSIS

You will see following big window

42

4) Creating a work repository

On the above screen click on 5th icon on the bottom left corner of screen.

51

Right click on work repository and select “Insert Work Repository”

In the connection window, complete the following parameters:

  • Name: Type the name for your work repository connection.
  • Technology: Choose the technology of the server to host your work repository.
  • User: User id / login of the owner of the tables you are going to create and host of the work repository.
  • Password: This user’s password.
  • Tab JDBC -> JDBC Driver: The driver required for the connection to the DBMS to host the work repository.
  • Tab JDBC -> URL JDBC: The complete path of the data server to host the work repository.

61

71

Always check the connection using TEST button and once successful then only click on OK.

Once you click on OK it will ask for the ID, Type and Name.

  • ID: give a unique number to your repository, from 1 to 998 included.
  • Name: give a unique name to your work repository (for example: work).
  • Type: Choose “Development” in the list.

81

Click on OK and it will create all the objects in Work repository.

After creating work repository you can then exit the topology.sh GUI.

5) Connecting to the Work repository

For connecting to work repository, you have to use desiginer.sh script present in same directory oracledi/bin

91

Again click on new icon just in front of dropdown.

Oracle Data Integrator Connection:

  • Login name: A generic alias (for example: Repository)
  • User: SUPERVISOR (in capitals)
  • Password: SUNOPSIS (in capitals)

DBMS connection (Master Repository):

  • User: User id/login of the owner of the tables you have created for the master repository (not the work repository)
  • Password: This user’s password.
  • List of drivers: choose the driver required to connect to the DBMS hosting the master repository you have just created.
  • URL: The complete path for the data server hosting the master repository.

Work Repository:

  • Work repository name: The name you gave your work repository in the previous step(WORK in this example). You can display the list of work repositories available in your master repository by clicking on the button to the right of this field.

101

Once you click on OK, you will see the previous screen with

Login Name : work

User : SUPERVISOR

Password : SUNOPSIS

Click on OK and you will be connected to work repository.

This completes all the step for ODI installation and configuration, including the repository creation.

Hope this helps !!

References :

Oracle® Data Integrator Installation Guide, 10g Release 3 (10.1.3) – Installation docs (PDF Format)

About these ads

38 thoughts on “Installing Oracle Data Integrator (ODI)

  1. Trying to start the Demo env in ODI after installing it and installing hsql DB. Getting the following error which is preventing me from going further.
    Can you please advice on this ?
    ————————————–

    A JDK is required to execute Web Services with OracleDI. You are currently using
    a JRE.
    OracleDI: Starting Demo Repository Server (en) …
    [Server@9931f5]: [Thread[main,5,main]]: checkRunning(false) entered
    [Server@9931f5]: [Thread[main,5,main]]: checkRunning(false) exited
    [Server@9931f5]: Startup sequence initiated from main() method
    [Server@9931f5]: Loaded properties from [G:\OraHome_1\oracledi\bin\server.proper
    ties]
    [Server@9931f5]: Initiating startup sequence…
    [Server@9931f5]: Server socket opened successfully in 12 ms.
    [Server@9931f5]: [Thread[HSQLDB Server @9931f5,5,main]]: Database [index=0db=fil
    e:../demo/hsql/demo_repository_en, alias=] did not open: org.hsqldb.HsqlExceptio
    n: The database is already in use by another process: org.hsqldb.LockFile@5bab42
    b9[file =G:\OraHome_1\oracledi\demo\hsql\demo_repository_en.lck, exists=false, l
    ocked=false, valid=false, ]: java.io.FileNotFoundException: G:\OraHome_1\oracled
    i\demo\hsql\demo_repository_en.lck (Access is denied)
    [Server@9931f5]: [Thread[HSQLDB Server @9931f5,5,main]]: run()/openDatabases():

    [Server@9931f5]: Startup sequence completed in 166 ms.
    [Server@9931f5]: 2009-02-02 08:38:53.738 HSQLDB server 1.7.3 is online
    [Server@9931f5]: To close normally, connect and execute SHUTDOWN SQL
    [Server@9931f5]: From command line, use [Ctrl]+[C] to abort abruptly

  2. Hi,

    I am not sure exactly on which step you are stuck. Could you please let me know which script you are trying to run.
    In case you are creating repository using repcreate.sh script then make sure that you set following environment variables before you run the script.

    Add the following environment variables for the user who has installed Oracle Data Integrator:

    * ODI_JAVA_HOME=/jre/1.4.2
    * TS_QUALITY=/oracledq/quality_server/tsq11r5s/Software
    * LD_LIBRARY_PATH=/oracledq/quality_server/tsq11r5s/Software/bin

    Hope this helps !!

    Regards,

    Advait Deo

  3. Hi Advait,

    I have installed ODI on Windows Vista after downloading it from the Oracle website. Installation was successful, however, when I try to run the demo
    ETL project provided, I get errors. I even installed hsql database, but dont know if it was right.

    I get struck when Starting Data Integrator as mentioned below
    ——————–
    Starting the Demonstration Environment
    Oracle Data Integrator provides the databases that contain the data used in these examples as well as the initial repository. Before looking at the different examples, you must do this first:
    Select Start Menu > Programs > Oracle Data Integrator > Examples, then select Start Demo
    Environment. This starts the Repository database server as well as the source and target databases.
    —————————————-
    When I do this, I see the error messages as above.

    Also, I tried creating the repo manually in oracle after creating 2 user ids for master and worker repos.
    I was able to create the master repository, but had issues in creating the worker repository , got an java.io.FileNotFoundException: .\snps_login_security.xml (Access is denied)

    Please advice. I need urgent help, can ping you online if it would be ok.

    Thanks

  4. I installed ODI and when tried to connect to the Master repository I got this messge, java.io.FileNotFoundException: .\snps_login_security.xml

    Can you help please

  5. Hi,

    Please let me know which command you are using to connect to master repository. This file is usually present in ODI_HOME/oracledi/bin directory.

    Also make sure that following variables are set.

    export ODI_JAVA_HOME=ODI_HOME/jre/1.4.2
    export TS_QUALITY=ODI_HOME/oracledq/quality_server/tsq11r0s/Software
    export LD_LIBRARY_PATH=ODI_HOME/oracledq/quality_server/tsq11r0s/Software/bin

    Regards,

    Advait Deo

    • Hi Advait,

      First of all thank you very much for the step by step installation procedure.

      I installed ODI and when tried to connect to the Master repository I got this messge, java.io.FileNotFoundException: .\snps_login_security.xml.

      I have all the three variables set as you recommended and also I can see the file in my ODI_HOME/oracledi/bin directory. But still facing the same problem. Am I missing something.

      I have oracle 10g enterprise edition.10.2.0.3.0,and odi version 10.1.3.5.0. OS is windows vista.

      Looking forward to your suggestion. Thanks again.

      Vinil

  6. Hi Vinil, I never tried the installation of ODI on vista. However snps_login_security.xml file should be present in ODI_HOME/Oracledi/bin directory. Please search the ODI home directory for this file and if found try to place it at the correct location. In the mean while I will check if I can get some information about this.
    Thanks for visiting the blog.

    Regards,

    Advait Deo

    • Advait,

      I checked and the file is there in the correct location. I also disabled windows firewall, but still getting the same error.

      Vinil

      • Hi Vinil,
        I too got the same error. Are you able to solve this. If you get the solution, could you please post the solution here.

        I guess the error might be due to the security permissions in Windows vista.

        Regards,
        Sri

  7. Hi,

    First of all, AWESOME info!!

    I have deployed the metadata navigator. everything works great except the flow maps and the data lineage links in the navigator.

    the following message is displayed when i try to view the flow maps after selecting a model and a project and leaving the rest of the fields with default selections.

    “There is a problem with the page you are trying to reach and it cannot be displayed.”

    this is the same error message when the web page ur trying to access is not available (generally).

    and when i try to view a data lineage my model is not listed in the drop down. However, i can view my models in the models link.

    i hope u have any idea as to what could be wrong. Please help me fix it.

    Thanks

  8. Hello,

    update on my doubt in the previous post.

    I created a package and this resulted in my models showing up in the drop down list in data lineage.

    But i still cannot view the data lineage or the flow map reports and both give the same error that says

    http 500 : internal server error.

    How do i fix this.

    Thanks

  9. Hi all,

    I was trying to configure ODI with database and was almost done, but in the final step of creating of work repository I got the following error:

    java.sql.SQLException: ORA-02264: name already used by an existing constraint

    Details:
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
    at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:633)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1086)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984)
    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3057)
    at com.sunopsis.sql.SnpsQuery.executeUpdate(SnpsQuery.java)
    at com.sunopsis.dwg.xml.DwgXmlSession.execute(DwgXmlSession.java)
    at com.sunopsis.repository.manager.RepositoryManager.a(RepositoryManager.java)
    at com.sunopsis.repository.manager.RepositoryManager.a(RepositoryManager.java)
    at com.sunopsis.repository.manager.RepositoryManager.designerRepositoryCreation(RepositoryManager.java)
    at com.sunopsis.repository.manager.RepositoryManager.a(RepositoryManager.java)
    at com.sunopsis.graphical.frame.a.kb.cz(kb.java)
    at com.sunopsis.graphical.frame.bo.cC(bo.java)
    at com.sunopsis.graphical.frame.a.kb.cC(kb.java)
    at com.sunopsis.graphical.frame.bo.bH(bo.java)
    at com.sunopsis.graphical.frame.bn.q(bn.java)
    at com.sunopsis.graphical.frame.bn.t(bn.java)
    at com.sunopsis.graphical.frame.bn.f(bn.java)
    at com.sunopsis.graphical.frame.bn.z(bn.java)
    at com.sunopsis.graphical.frame.bn.c(bn.java)
    at com.sunopsis.graphical.frame.w.actionPerformed(w.java)
    at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Window.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)

    I appreciate if anyone can help me out…Thnks

  10. This was really useful…
    But i was stuck at one place…

    I deployed the metadata navigator. At the last step when i click on test web module, it prompted for user name and password.

    I gave username as “SUPERVISOR” and password as “SUNOPSIS”. But in the next page it errored out with the following error…

    Sorry, an error occurs during page loading
    The error message is :

    socket creation error
    You could retry or logout.

    Error detail
    Exception type :
    class java.sql.SQLException
    Exception message :
    socket creation error
    Exception Stack Trace :
    java.sql.SQLException: socket creation error
    at org.hsqldb.jdbc.jdbcUtil.sqlException(jdbcUtil.java:67)
    at org.hsqldb.jdbc.jdbcConnection.(jdbcConnection.java:2451)
    at org.hsqldb.jdbcDriver.getConnection(jdbcDriver.java:188)
    at org.hsqldb.jdbcDriver.connect(jdbcDriver.java:166)
    at com.sunopsis.sql.SnpsConnection.u(SnpsConnection.java)
    at com.sunopsis.sql.SnpsConnection.c(SnpsConnection.java)
    at com.sunopsis.sql.k.run(k.java)

  11. hi,

    the information you posted over here is so helpful. I have few doubts that is

    1. how to have multiple agents?

    i have created only one master repository and one work repository. do i need to have more than one work repository in order to have more than one agent . Please let me know and i also like to know how to setup load balancing.

    my environment:
    ———————-
    source 2 node rac
    target single node where odi has been setup
    operating system: linux
    oracle: 10.2.0.3 ( target and source both are oracle)

    Appreciate your quick response
    Best Regards,
    Sk.

  12. Hi

    We are just installed ODI and soon we are going with prod, please suggest me what are all things we have to take care of monitoring and at the same time i need to provided reports any specific reports like how much data as gone to target ?

    Regards
    Sai

  13. For all the people who are getting this following error
    java.io.FileNotFoundException: .\snps_login_security.xml

    Make sure you have both Read and Write Permissions to orcaledi directory.

    Most cases this error will occur if the user don’t have permission to save the entered details into snps_login_security.xml file.

    Thanks
    Raghu

    • Hi

      i am installing odi on vista, after giving the master repository details i am getting error
      “java.io.FileNotFoundException: .\snps_login_work.xml(Access denied)”.

      Pls help me in resolving this issue.

      thanks,
      Sateesh.

  14. For comment 10 — You get this problem when you dont have write permission to snps_login_security.xml file. What ever information you enter about master repository connection, it gets stored here first, so that when you come next time, you dont need to enter it again.

    Once you have write permission to this file you will not have any problem..

  15. Hello

    I’m using ODI 11g and SOA suite 11g with weblogic.

    In the login page of Light Weight Designer I’m getting a warning >> “Warning : While trying to lookup jdbc/ORACLE_MASTER in java:comp/env.”

    Can someone please help me on this issue

    Thanks
    Mevin

  16. Hi,
    can you please tell me how to change the password for SUPERVISOR. default is SUNOPSIS but i want to change it to new password. please let me know how to do that.

    Regards,
    satish.

  17. I am trying to install Oracle Data Integrator in Linux, but when I run the installer, I get this problem:

    “Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-11-16_10-41-13PM. Please wait …sh: /home/workx/Documents/Downloads/CD_10.1.3.5.0_LINUX/setup/Linux/Disk1/install/unzip: Permission denied”

  18. Hi,

    I have selected complete and installed ODI and then created master/work repositorys
    now i selected only the ODI client, installed .. so at this time i am not able to connect to repository.i m getting error message.i have given repository SID as my server SID and master repository is same as that of my system SID.. i m getting error message

  19. Erro in install ODI

    Iniciando Oracle Universal Installer…

    Verificando requisitos do Installer…

    Verificando a versão do sistema operacional: deve ser redhat-3 or redhat-4
    Falha <<<<

    Encerrando o Oracle Universal Installer; o log para esta sessão pode ser encontrado em /u01/app/oracle/oraInventory/logs/installActions2010-12-01_08-24-04PM.log

  20. Pingback: Data Server Hosting | Web Hosting Information and Tips

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s