Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to configure ODI for server and client correct?

s_sApr 17 2013 — edited Apr 19 2013
Hi forum,

this is my first post and i hope you guys can help me out ...
i
am new to ODI and WLS and in my case ODI need to run on a server where a couple of clients can connect to, work on the same project with their own workspaces and accounts.
The database will be located on the same server.
As far as i understood, i need to install the the ODI Java EE type (not the standalone type) with a WLS ?!

iI already nstalled

JDK 6u41 (x64),
ODI 11g (11.1.1.6, generic),
Oracle DB 11g R2 enterprise and
WebLogic 11g (10.3.6, generic)

on the Server and now i am trying to connect to the ODI repositories from a client with an ODI standalone installation.
I am now trying to insert a Data Source into the physical agemt (not even sure if i need to do this in my case).
Following these instructions (http://docs.oracle.com/cd/E17904_01/integrate.1111/e12643/setup_topology.htm#CHDHJBAD) i get an ODI-26029 error.

Below are some configuration information of the software i installed.

h3. ODI
-----
Installation:
Installationtype: full
Oracle home directory: Oracle_ODI1
Agent name: odi_agent
Agent port: 1987

Repositories/connection:
Master repository user = odim
Work repository user = odiw
Work repository name = WORKREP1
JDBC connection string = jdbc:oracle:thin:@localhost:1521:orcl
*odim and odiw have been created manually with grant options on connect and resource

Physical agent (with no datasource defined):
Name = OracleDIAgent
Host = localhost
Webapplicationcontext = oraclediagent
Port = 8001
Protocol = http

Physical data server:
Name = oracle_db_11gr2
User = odiw
JDBC connection string = jdbc:oracle:thin:@localhost:1521:orcl

Physical schema:
Schema (schema) = ODIW
Schema (work schema) = ODIW
Context = aMIS_dev
Logical schema = oracle_db_11gr2

Logiacal schema
Context = aMIS_dev
Physical schema = oracle_db_11gr2.ODIW

Context:
Name = aMIS_dev
Logical agent = OracleDIAgent
Physical agent = OracleDIAgent
Logical schema = oracle_db_11gr2
Physical schema = oracle_db_11gr2.ODIW

Logical schema:
Name = oracle_db_11gr2
Context = aMIS_dev
Physical schema = oracle_db_11gr2.ODIW

Logical agent
Name = OracleDIAgent
Context = aMIS_dev
Physical Agent = OracleDIAgent


h3. Oracle DB 11g R2
-----
Installation
Global database name = orcl.otera.local
SID = orcl


h3. WebLogic 11g:
-----
+1. generate new basic WebLogic Server domain+
Domainname = ODI-DOMAIN
Admin name = weblogic
Admin server name = AdminServer
Listening port = 7001
Managed server name = odi_server1
Managed server port = 8001

+2. extend an existing WebLogic domain+
Choose extension source: ODI - Agent, ODI - Agent Libraries, Oracle JRF
Window: Configure JDBC compontent schema:
Driver = Oracle's Driver (Thin) for Instance connection; Versions: 9.0.1 and higher
Schema owner = odim
DBMS/Service = orcl
Hostname = localhost
Port = 1521
Client name = LocalODIMachine
Listening address of the accountmanager = localhost
Listening port of the accountmanager = 5556



Really hope you guys can help me quick.

Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details