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
Here you can select first option which will install all the components.
Again here select the complete installation.
Select the ORACLE_HOME name and path that you want to give
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.
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
- 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
- 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.
- 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
- 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.
- 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
- 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.
- 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:
- Creating repository storage spaces
- Creating the master repository
- Connecting to the master repository
- Creating a work repository
- 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.
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
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
Once the connection is successful, click on OK and connect to master repository using SUPERVISOR/SUNOPSIS
You will see following big window
4) Creating a work repository
On the above screen click on 5th icon on the bottom left corner of screen.
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.
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.
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
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.
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)
Persistent Storage Solutions 
Hey AWESOME blog, added to my top 5 favorites 😀
Thanks 🙂
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
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
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
Thanks a lot.
Install procedure works fine. I am looking for very basic demos. Cheers.
Big Regard from meeeeee…. ^.^ help me a lot
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
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
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
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
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
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
This was VERY useful, thank you very much for this simple and easy to follow tutorial!!
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)
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.
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
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.
Very good post to cover installation of ODI.
Atul Kumar
http://onlineappsdba.com/index.php/2009/09/07/oracle-data-integrator-odisunopsis-architecture-installation-overview/
Hi Atul,
Thanks !! 🙂
Regards,
Advait Deo
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..
Hi….
Great work…This has helped a lot to many and will help many more…..
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
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.
I got it. need to go to topology manager –> file –> change password to change SUPERVISOR Password
Thanks,
Satish.
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”
I was able to solve the problem. It is only a right issue with the execute file “unzip”
thanks raghu!
How can we load and write LOB data to FILE through ODI
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
Ty for the Help. You´ve helped a lot!
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