星期二 十月 29, 2013

Multiple Java EE Agents on Single Managed Server

A default JEE agent is created when you create domain, which is named as OracleDIAgent.

1. In Studio, duplicate the agent, change its name to genAgent, change the web application context to genagent.
2: Go to datasource of genAgent, drop all datasources.
3: Generate server template. put the jar file under odi\common\templates\wls
4: Deploy this template by update the existing domain. Bring up the config.cmd, choose update existing domain.
5: Update the domain using the template that just generated.
Go through the Configuration wizard. (I did not modify anything or configure anything here).
6: The wizard will give information says the deployment was successful.
7: Bring up the admin server and ODI_server1. 

星期三 一月 16, 2013

Workaround When you fail to create repository on MySQL database(UTF8)

 

Suppose your mysql database is utf8 charset, it may fail to create ODI repository on it.

There is a workaround:

in my.ini, add next 3 lines:
innodb_large_prefix=true
innodb_file_format=barracuda
innodb_file_per_table=true

星期一 十月 08, 2012

monitor multiple work repositories in ODI11g EM

when you create a domain, by default it will let you specify master/work repository information.

This work repository is automatically configured and be directly monitored in EM

But your master repository may contain multiple work repositories, how to let EM monitor all them.

1)these work repositories must have been registered in your master repository

2)in weblogic console, generate generic data source for every work repository, eg: jdbc/mySecondWork

3)in odiconsole, create new repository connection for the every work repository, master jndi information is jdbc/odiMasterRepository by default

OK, now you can see the work repository status is configured.

Btw, there is a bug when the work repository is execution type.

星期五 九月 14, 2012

How to deecode your ODI encoded password in SDK

Someone asked me he want to use SDK to create ODI repository, but latest 11g API in SDK use plain password parameter. But he don't want to use plain text for security reason. So he want to transfer an encoded password, then decode it inside his code. He ask me whether there is a way. 

After some investigating, I find com.sunopsis.dwg.DwgObject class has a static method snpsDecypher(String), it can satisfy his requirement. But seems this method is deprecated, I am trying to find the new replaced method. 

About

Oracle Blogs Admin-Oracle

Search

Categories
Archives
« 四月 2014
星期日星期一星期二星期三星期四星期五星期六
  
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
   
       
今天