PC811, create repository content 时出错

初级会员 注册时间: 2008-12-22 06:23:03 文章: 2 离线

OS:redhat as5, db: oracle 10g r2, informatica 811 for linux,
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...........

中级会员 注册时间: 2008-08-13 04:02:03 文章: 28 离线

DataBase error: ORA-01483: invalid length for DATE or NUMBER bind variable Database driver error...

初级会员 注册时间: 2008-12-22 06:23:03 文章: 2 离线

后来已解决了，设置了nls_lang,以及oracle nls data 的可读可执行权限后，可以了