星期三 一月 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.

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
31
  
       
今天