Autoconfig On Db Tier Fails With Error - SP2-1503
今天作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:
afdbprf.sh INSTE8_PRF 1
AutoConfig could not successfully execute the following scripts:
Directory:
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 - 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 - R12.TXK.B.delta.2
由於只是升級資料庫 還沒升級到12.1.*,所以嘗試修改$ORACLE_HOME/appsutil/template/ad8idbux.env,auotoconfig過了,目前在測試是否可行。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/11289933/viewspace-751719/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Just rapid clone data on DB tier in Oracle EBSAPIOracle
- 【故障處理】Bug : ASM FAILS WITH CHECKRESOURCE ERROR ERROR CODE = 139ASMAIError
- DB error due to HP-UX Error:23ErrorUX
- SQLPLUS Fails With SP2-1503 SP2-0152 After New 11.2 Installation解決SQLAI
- ERROR: Could not delete DB checkpoint for REPLICATErrordelete
- DataPump Export (EXPDP) Fails With Error LPX-216 Invalid CharacterExportAIError
- "DROP USER" fails with error: ORA-00942 and ORA-00604 (一)AIError
- "DROP USER" fails with error: ORA-00942 and ORA-00604 (二)AIError
- DB2 backup fails with SQL2079N return code 30DB2AISQL
- Agent Startup Fails When the Repository DB Does Not Support TZ of Agent-332131.1AI
- Fails to Start: PMON (ospid: nnnn): terminating the instance due to error 481AIError
- EM GC11.1.0.1 Agent Startup on AIX Fails with Error: nmectl_validate_1386861.1GCAIError
- adcfgclone.pl appsTier fails with error AC-50207GCAPPAIError
- Agent Install Fails with Error 'OUI-25031' Due to Environment Settings_380507.1AIErrorUI
- Oracle Database Fails to Start with Error ORA-12547 [ID 1307075.1]OracleDatabaseAIError
- Tier 1 Capital 一級資本API
- ERROR: failed to establish dependency between database db_name and diskgroupErrorAIDatabase
- 10.2.0.2 RAC DB ">>> ERROR IN KQLMBIVG SEE LCK TRACE FILEError
- $FND_TOP/bin/txkrun.pl -script=DeployForms-c4ws Fails with Fatal ErrorORMAIError
- OMS CA:10.2.0.1.0 GC Install Fails with "Error processing emkey-353131.1GCAIError
- DUMP-CX_SY_OPEN_SQL_DB-DBSQL_DUPLICATE_KEY_ERRORSQLError
- XDMCP connection failsAI
- EBS R12中中間層(Middle Tier)及應用層指令碼(單獨開啟各服務指令碼)-DB層指令碼
- ndo2db: mysql_error: ‘Unknown column ‘importance’ in ‘field list”MySqlErrorImport
- Oracle Appliactions 11i concepts(五) - Autoconfig(1)OracleAPP
- 12c CC:Installing 12c Fails With Error 'Unable to continue with the in_1554180.1AIError
- FNDCPASS修改apps密碼需要關閉CM及autoconfigAPP密碼
- Fails to Join the Cluster as CRSD and EVMD are in INTERMEDIATE StateAI
- BULK COLLECT FAILS WITH ORA-04030AI
- MySQL案例02:ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGESMySqlError
- DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001DB2SQLError
- 【RMAN】Run Allocate Channel For Maintenance From Script FailsAINaN
- EXPDP Fails With ORA-04031 ("streams pool", ...)AI
- 什麼?比 MySQL 價效比更高的 TiDB Cloud Serverless Tier 來了?MySqlTiDBCloudServer
- Nginx配置max_fails fail_timeoutNginxAI
- ASM disk group mount fails with ORA-15036ASMAI
- Clusterware Fails to Start With 'clssnmLocalJoinEvent: takeov Ocssd.log_845573.1AICSS
- Drop Table Fails With ORA-600 [15264]AI