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

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

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上的解决办法：

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过了，目前在测试是否可行。

ITPub博客

Autoconfig On Db Tier Fails With Error - SP2-1503

最新文章