今天作EBS数据库从10.2.0.5升级到11.2.0.2的测试,升级后执行autoconfig的时候遇到
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
adcrobj.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
SP2-0152: ORACLE may not be functioning properly
adcrobj.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
AutoConfig could not successfully execute the following scripts:
Directory: /appsutil/install/
afdbprf.sh INSTE8_PRF 1
AutoConfig could not successfully execute the following scripts:
Directory:/appsutil/install/
adcrobj.sh INSTE8_APPLY 1
AutoConfig is exiting with status 2
Directory: /appsutil/install/
afdbprf.sh INSTE8_PRF 1
AutoConfig could not successfully execute the following scripts:
Directory:/appsutil/install/
adcrobj.sh INSTE8_APPLY 1
AutoConfig is exiting with status 2
The environment variable ORA_TZFILE is set while at 11gR2 this should not be set.
The $ORACLE_HOME/appsutil/template/ad8idbux.env is from the wrong version (ad8idbux.env 120.8)
The wrong file includes the following:
ORA_TZFILE="$ORACLE_HOME/oracore/zoneinfo/timezlrg.dat"
export ORA_TZFILE
While for 11gr2 it should be:
if test "%s_database%" = "db112" ; then
ORA_TZFILE=""
else
ORA_TZFILE="$ORACLE_HOME/oracore/zoneinfo/timezlrg.dat"
fi
export ORA_TZFILE
metalink上的解决办法:
The $ORACLE_HOME/appsutil/template/ad8idbux.env is from the wrong version (ad8idbux.env 120.8)
The wrong file includes the following:
ORA_TZFILE="$ORACLE_HOME/oracore/zoneinfo/timezlrg.dat"
export ORA_TZFILE
While for 11gr2 it should be:
if test "%s_database%" = "db112" ; then
ORA_TZFILE=""
else
ORA_TZFILE="$ORACLE_HOME/oracore/zoneinfo/timezlrg.dat"
fi
export ORA_TZFILE
metalink上的解决办法:
To implement the solution, please execute the following steps:
1 - Be sure to have a valid backup
2 - review Note 1058763.1 - Interoperability Notes EBS R12 with Database 11gR2
3 - Install missing patch 7651166 - R12.TXK.B.delta.2
由于只是升级数据库 还没升级到12.1.*,所以尝试修改$ORACLE_HOME/appsutil/template/ad8idbux.env,auotoconfig过了,目前在测试是否可行。
1 - Be sure to have a valid backup
2 - review Note 1058763.1 - Interoperability Notes EBS R12 with Database 11gR2
3 - Install missing patch 7651166 - R12.TXK.B.delta.2
由于只是升级数据库 还没升级到12.1.*,所以尝试修改$ORACLE_HOME/appsutil/template/ad8idbux.env,auotoconfig过了,目前在测试是否可行。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11289933/viewspace-751719/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11289933/viewspace-751719/