解决Memory Based Planner 64-bit AIX request出错的问题

  从生产系统clone EBS到测试环境后，用户测试ASCP的时候报错。报错来源于一个请求：Memory Based Planner 64-bit AIX 。以前记得遇到过类似的问题，好像是process数量不足导致，在metalink上也可以查到这个案例。但这次不是这个原因。花了一个下午的时间找metalink没有得到满意的答案。最后从64-bit Planner Platform设置手册找到了答案。先看看请求日志的记录：

 

APP-MRP-22130: Cannot connect to database

Cause: The current routine cannot connect to the database.

Action: Contact your system administrator or customer support representative.

ORACLE error 1012 in FDPCLS

Cause: FDPCLS failed due to ORA-01012: not logged on.

The SQL statement being executed at the time of the error was: and was executed from
the file .
/u01/appldev/devappl/msc/11.5.0/bin/MSCNWA64.exe
程序 退出时出现状态 1


+---------------------------------------------------------------------------+
未请求任何完成选项。


未打印输出文件，因为：
已禁用此报表的打印选项。

+---------------------------------------------------------------------------+
APP-FND-01388: 无法读取例程 &ROUTINE 中配置文件选项 CONC_OUTFILE 的值。
已完成并发请求
当前的系统时间为 07-05-2009 20:04:21

 

 

1. In unix/linux, run SQL file $MSC_TOP/patch/115/sql/upd_64ex.sql as the APPS user.
2. Set profile MSC: 64-bit Planner Platform  = AIX 64-bit
3. Download ora9204.tar from this document using the link below.
   1. Copy the tar file ora9204.tar to $MSO_TOP/bin
   2. Untar the file using
      tar -xvf ora9204.tar
4. Set the following environment variables in $APPL_TOP env file
   1. APS64_USE_EXPORT=Yes
   2. APS64_ORACLE_HOME=$MSO_TOP/bin/ora9204

                                                        i.      Using $MSO_TOP is fine, unless you encounter failure – Cannot connect to database, If received, then try the literal path to $MSO_TOP

                                                      ii.      The log file should show the correct path to the directory

5. After changing the env file, please bounce the concurrent managers.
6. If Memory Based Planner log file shows plan fails with ORA-01012 unable to connect to database
   OR Signal 11 immediately after launching, THEN:
   1. Set the variable APS64_USE_EXPORT=No
   2. Bounce the concurrent managers and retry.
7. IF the plan still fails, THEN please see the following issues/solutions which may help to run the programs successfully

                                                        i.      IF AIX users encounter any out of memory error occurs when running the plan,
THEN AIX platform may also require the use of parameters listed in

                                                      ii.      AIX users may also encounter failure to load program described in

--我主要设置了环境变量，也就是步骤4。另外设置APS64_USE_EXPORT=No。