http://www.mydwbi.com/posts/list/3.page JForum - http://www.jforum.net repository service可以启动，接着在informatica的adminconsole中 actions->create contents时出错了，
log信息如下：
DataBase error: ORA-01483: invalid length for DATE or NUMBER bind variable Database driver error... Function Name : Execute SQL Stmt : INSERT INTO OPB_ATTR ( OBJECT_TYPE_ID, ATTR_ID, ATTR_SIBLING, ATTR_CHILD, ATTR_DATATYPE, ATTR_TYPE, ATTR_NAME, ATTR_VALUE, ATTR_COMMENT, ATTR_SCOPE, BITFLAGS, VARIABLE_PREFIX, REPVERSION, CATEGORY) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Oracle Fatal Error Database driver error... Function Name : Execute SQL Stmt : INSERT INTO OPB_ATTR ( OBJECT_TYPE_ID, ATTR_ID, ATTR_SIBLING, ATTR_CHILD, ATTR_DATATYPE, ATTR_TYPE, ATTR_NAME, ATTR_VALUE, ATTR_COMMENT, ATTR_SCOPE, BITFLAGS, VARIABLE_PREFIX, REPVERSION, CATEGORY) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Oracle Fatal Error.

DataBase error: Error inserting repository object attribute information.

An error has occurred while creating contents. Dropping repository tables...

因为oracle db server 和informatica server 安装在一台机器上，所以没有安装oracle的client了，db是在oracle用户下安装的，informatica是在infa用户下安装，oracle用户属于oinstall 组， infa 属于finstall组，下面给出infa用户下的环境变量相关参数：
export INFA_HOME=/infa
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10\.2\.0/db_1
export ORACLE_SID=poporcl
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/infa/server:$ORACLE_HOME/lib
export LC_CTYPE=en_US.UTF8
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin::$INFA_HOME/server/bin
#DISPLAY=192.168.1.21:0
#export DISPLAY
export LANG=en_US.utf8
export LC_ALL=en_US.utf8
export TNS_ADMIN=$ORACLE_HOME/network/admin
#export NLS_LANG=American_America.UTF8
unset USERNAME


下面是oracle用户下的环境变量相关参数：
# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10\.2\.0/db_1
export ORACLE_SID=poporcl
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LC_CTYPE=en_US.UTF-8
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
#export NLS_LANG='SIMPLIFIED CHINESE_CHINA.UTF8'
export NLS_LANG=American_America.UTF8
unset USERNAME

请高手不吝指教一下，困扰了好几天了，帮帮忙，thanks in advance.... iORZ...........
]]> http://www.mydwbi.com/posts/preList/503/2801.page http://www.mydwbi.com/posts/preList/503/2801.page GMT
]]> http://www.mydwbi.com/posts/preList/503/2808.page http://www.mydwbi.com/posts/preList/503/2808.page GMT http://www.mydwbi.com/posts/preList/503/2819.page http://www.mydwbi.com/posts/preList/503/2819.page GMT