ITPUB论坛－专业的IT技术社区

登录 注册
ITPUB论坛－专业的IT技术社区»论坛 › ≡ 企业信息化 ≡ › Oracle ERP › ASCP的问题
12
返回列表 发新帖
楼主: 大神无量111
收藏 | 打印 上一主题 下一主题

ASCP的问题

[复制链接]
大神无量111
论坛徽章:
0
11#
 楼主| 发表于 2015-12-22 15:11 | 只看该作者
额，不好意思耽误您的时间，万分感谢您的回复。
一直在running的进程有以下几个：
基于内存的快照、快照监控程序、快照删除工作流程、基于内存的快照工作流程。其中，基于内存的快照工作流程和快照删除工作流程这两个进程有多个，有一部分一直在运行中，另一部分一直在等待的状态。系统的版本是R12.2.4，服务器是Linux，硬件的参数不是十分清楚。计划选项的截图我不知道怎么在回复中添加就保存到附件了。进程的日志也在附件中。
请求我是在下午的时候提交的，第二天早上去查看依旧卡在那里，由于还有其他的请求需要运行，就把这个请求手动取消了。 万分感谢您的解答。
快照删除工作流程.txt (2.45 MB, 下载次数: 3) 快照监控程序.txt (23 Bytes, 下载次数: 2) 基于内存的快照工作流程.txt (91.31 KB, 下载次数: 0) 基于内存的快照.txt (97.37 KB, 下载次数: 1)

使用道具 举报

回复
大神无量111
论坛徽章:
0
12#
 楼主| 发表于 2015-12-22 15:15 | 只看该作者
greencha 发表于 2015-12-22 14:21
您要具体的说明, 一直在running 的program name 是什么program log 停在什么讯息上, 能抓下来的话最好上传上 ...

快照监控程序个没有导出来。日志如下：
高级供应链计划: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

MSCMON: 快照监控程序
+---------------------------------------------------------------------------+

当前的系统时间为 15-12-2015 14:25:40

+---------------------------------------------------------------------------+


===================================================================
调试模式：禁用
输出至终端：否
变元方法：数据库取记录
跟踪模式：禁用

===================================================================
变元 1 (PLAN_ID) = 21
变元 2 (REQUEST_ID) = 530188
变元 3 (IN_IPC) = eng21_mon_0
变元 4 (OUT_IPC) = eng21_snp_530188
变元 5 (SNAPSHOT_MODE) = 1
变元 6 (SNAP_STATIC_ENTITIES) = 1

===================================================================
plan_id:21 plan_type:1 planning_engine_type:1

Setting up flat file directories: Checking for DIR: /u01/test/app/fs_ne/inst/TEST_test/logs/appl/conc/out/data21/
        Directory is already there or can not be opened

Setting up flat file directories: Checking for mbpinput and mbpoutput directories
        mbp input/output directory existing.. check it out

mbp flat file dir /u01/test/app/fs_ne/inst/TEST_test/logs/appl/conc/out/data21/
Use DBMS_PIPE to do inter process communications

DELETE /*+ CHOOSE */ FROM msc_snapshot_tasks
WHERE plan_id=lan_id
AND rownum <= 99999999
AND -1 = -1.已从 msc_snapshot_tasks 中删除                                                 73    0:00
CONCURRENT MSC MSCSDW "PLAN_ID=21" "SNAP_STATIC_ENTITIES=1" "SNAPSHOT_MODE=1" "MON_REQUEST_ID=530189"
已启动 处理程序 的并发请求 530190
配置文件选项 'MRP_RETAIN_DATES_WTIN_CAL_BOUNDARY' 的值为 Y
SELECT  TO_NUMBER(TO_CHAR(MIN(calendar_date),'j')),
TO_NUMBER(TO_CHAR(MAX(calendar_date),'j'))
FROM    msc_calendar_dates
WHERE   calendar_code = :calendar_code
AND    seq_num IS NOT NULL
AND     to_number(to_char(calendar_date, 'J')) >=
           to_number(to_char(sysdate, 'J')) - :cal_hist_days
AND     exception_set_id = :exception_set_id
AND     sr_instance_id = :instance_id

SELECT TO_CHAR(calendar_date, 'j')
FROM   msc_calendar_dates
WHERE  calendar_code = :calendar_code
AND    sr_instance_id = :instance_id
AND    to_number(to_char(calendar_date, 'j')) >=
           to_number(to_char(sysdate, 'J')) - :cal_hist_days
AND    exception_set_id = :exception_set_id
AND seq_num IS NOT NULL
ORDER BY calendar_date

..选择 Calendar                                                             0:00
GEN-PROFILE VALUE (PROFILE=MSC_FIRM_INTRANSIT_PO_IN_RECEIVING) (VALUE=Y)
Profile MSC_DEF_PROJ_SUP_EXCESS not set
配置文件选项 'MSC_USE_FIFO_PEGGING' 的值为 N
Profile MSO_USE_COLLECTIONS_START_TIME not set
Setting Lot Based Job Profile to Yes
..选择  apps instance profiles                                                   1    0:00
success in  get cutoff buckets
配置文件选项 'MSO_LP_ALGORITHM' 的值为 0
配置文件选项 'MSO_MAX_DAYS_LATE' 的值为 5
WarehouseCapacity:enforce_wrh_cpty=2
Profile MSC_USE_SCO_DATE is set to No.
Calculated curr_date from msc_plan_buckets:2457372
配置文件选项 'MRP_RETAIN_DATES_WTIN_CAL_BOUNDARY' 的值为 Y
SELECT  TO_NUMBER(TO_CHAR(MIN(week_start_date),'j')),
TO_NUMBER(TO_CHAR(MAX(week_start_date),'j'))
FROM    msc_cal_week_start_dates
WHERE   calendar_code = :calendar_code
AND     to_number(to_char(week_start_date, 'J')) >=
           to_number(to_char(sysdate, 'J')) - :cal_hist_days
AND     exception_set_id = :exception_set_id
AND     sr_instance_id = :instance_id

SELECT TO_CHAR(week_start_date, 'j')
FROM   msc_cal_week_start_dates
WHERE  calendar_code = :calendar_code
AND    sr_instance_id = :instance_id
AND    to_number(to_char(week_start_date, 'j')) >=
           to_number(to_char(sysdate, 'J')) - :cal_hist_days
AND    exception_set_id = :exception_set_id
  ORDER BY week_start_date

..选择 Calendar                                                             0:00
配置文件选项 'MRP_RETAIN_DATES_WTIN_CAL_BOUNDARY' 的值为 Y
SELECT  TO_NUMBER(TO_CHAR(MIN(period_start_date),'j')),
TO_NUMBER(TO_CHAR(MAX(period_start_date),'j'))
FROM    msc_period_start_dates
WHERE   calendar_code = :calendar_code
AND     to_number(to_char(period_start_date, 'J')) >=
           to_number(to_char(sysdate, 'J')) - :cal_hist_days
AND     exception_set_id = :exception_set_id
AND     sr_instance_id = :instance_id

SELECT TO_CHAR(period_start_date, 'j')
FROM   msc_period_start_dates
WHERE  calendar_code = :calendar_code
AND    sr_instance_id = :instance_id
AND    to_number(to_char(period_start_date, 'j')) >=
           to_number(to_char(sysdate, 'J')) - :cal_hist_days
AND    exception_set_id = :exception_set_id
  ORDER BY period_start_date

..选择 Calendar                                                             0:00
APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

APP-MRP-22066: check_bounds：变元 'index' 的无效 '-4' 值

原因：一个指定变元的无效值传送至当前例行程序。

措施：请与客户支持代表联系。

..选择 org parameters                                                            1    0:00
..选择 ds subset designators                                                          0:00
.已完成 Flush Flat Files                                                    0:00
MSC_ASCP_IGNORE_CMRO_EAM_WO profile_val set to : 1

constrained_mode: 0 eamcmro_factor: 1
配置文件选项 'MSO_USE_SHIFT_TIMES_IN_LEAD_TIME_SCHEDULING' 的值为 Y
add_pld_pending_loads: task id 2 inserted  
add_pld_pending_loads: task id 3 inserted  
add_pld_pending_loads: task id 4 inserted  
add_pld_pending_loads0: task id 5 NOT inserted  
add_pld_pending_loads: task id 6 inserted  
add_pld_pending_loads: task id 7 inserted  
add_pld_pending_loads: task id 8 inserted  
add_pld_pending_loads: task id 9 inserted  
add_pld_pending_loads: task id 10 inserted  
add_pld_pending_loads: task id 11 inserted  
add_pld_pending_loads: task id 12 inserted  
add_pld_pending_loads: task id 13 inserted  
add_pld_pending_loads: task id 14 inserted  
add_pld_pending_loads: task id 15 inserted  
add_pld_pending_loads: task id 16 inserted  
add_pld_pending_loads4: task id 17 NOT inserted  
add_pld_pending_loads: task id 18 inserted  
add_pld_pending_loads: task id 19 inserted  
add_pld_pending_loads: task id 20 inserted  
add_pld_pending_loads: task id 21 inserted  
add_pld_pending_loads: task id 22 inserted  
add_pld_pending_loads: task id 23 inserted  
add_pld_pending_loads: task id 24 inserted  
add_pld_pending_loads: task id 25 inserted  
add_pld_pending_loads: task id 26 inserted  
add_pld_pending_loads: task id 27 inserted  
add_pld_pending_loads: task id 28 inserted  
add_pld_pending_loads1: task id 29 NOT inserted  
add_pld_pending_loads1: task id 30 NOT inserted  
add_pld_pending_loads1: task id 31 NOT inserted  
add_pld_pending_loads1: task id 32 NOT inserted  
add_pld_pending_loads: task id 33 inserted  
add_pld_pending_loads: task id 34 inserted  
add_pld_pending_loads1: task id 35 NOT inserted  
add_pld_pending_loads: task id 36 inserted  
add_pld_pending_loads: task id 37 inserted  
add_pld_pending_loads: task id 38 inserted  
add_pld_pending_loads: task id 39 inserted  
add_pld_pending_loads1: task id 40 NOT inserted  
add_pld_pending_loads1: task id 41 NOT inserted  
add_pld_pending_loads: task id 42 inserted  
add_pld_pending_loads: task id 43 inserted  
add_pld_pending_loads: task id 44 inserted  
add_pld_pending_loads: task id 45 inserted  
add_pld_pending_loads1: task id 46 NOT inserted  
add_pld_pending_loads1: task id 47 NOT inserted  
add_pld_pending_loads1: task id 48 NOT inserted  
add_pld_pending_loads: task id 49 inserted  
add_pld_pending_loads1: task id 50 NOT inserted  
add_pld_pending_loads: task id 51 inserted  
add_pld_pending_loads1: task id 52 NOT inserted  
add_pld_pending_loads1: task id 53 NOT inserted  
add_pld_pending_loads: task id 54 inserted  
add_pld_pending_loads: task id 55 inserted  
add_pld_pending_loads: task id 56 inserted  
add_pld_pending_loads: task id 57 inserted  
add_pld_pending_loads1: task id 58 NOT inserted  
add_pld_pending_loads: task id 59 inserted  
add_pld_pending_loads: task id 60 inserted  
add_pld_pending_loads1: task id 61 NOT inserted  
add_pld_pending_loads: task id 62 inserted  
add_pld_pending_loads: task id 63 inserted  
add_pld_pending_loads: task id 64 inserted  
add_pld_pending_loads: task id 65 inserted  
add_pld_pending_loads: task id 66 inserted  
add_pld_pending_loads: task id 67 inserted  
add_pld_pending_loads1: task id 68 NOT inserted  
add_pld_pending_loads1: task id 69 NOT inserted  
add_pld_pending_loads1: task id 70 NOT inserted  
add_pld_pending_loads1: task id 71 NOT inserted  
add_pld_pending_loads1: task id 72 NOT inserted  
add_pld_pending_loads1: task id 73 NOT inserted  
add_pld_pending_loads1: task id 74 NOT inserted  
add_pld_pending_loads1: task id 75 NOT inserted  
add_pld_pending_loads1: task id 76 NOT inserted  
add_pld_pending_loads1: task id 77 NOT inserted  
add_pld_pending_loads1: task id 78 NOT inserted  
add_pld_pending_loads: task id 79 inserted  
add_pld_pending_loads: task id 80 inserted  
add_pld_pending_loads: task id 81 inserted  
add_pld_pending_loads1: task id 82 NOT inserted  
add_pld_pending_loads1: task id 83 NOT inserted  
add_pld_pending_loads1: task id 84 NOT inserted  
add_pld_pending_loads1: task id 85 NOT inserted  
add_pld_pending_loads1: task id 86 NOT inserted  
add_pld_pending_loads: task id 87 inserted  
add_pld_pending_loads: task id 88 inserted  
add_pld_pending_loads: task id 89 inserted  
add_pld_pending_loads1: task id 90 NOT inserted  
add_pld_pending_loads1: task id 91 NOT inserted  
add_pld_pending_loads: task id 92 inserted  
add_pld_pending_loads1: task id 93 NOT inserted  
add_pld_pending_loads1: task id 94 NOT inserted  
add_pld_pending_loads: task id 95 inserted  
add_pld_pending_loads1: task id 96 NOT inserted  
add_pld_pending_loads: task id 97 inserted  
add_pld_pending_loads: task id 98 inserted  
add_pld_pending_loads: task id 99 inserted  
add_pld_pending_loads: task id 100 inserted  
add_pld_pending_loads: task id 101 inserted  
add_pld_pending_loads: task id 102 inserted  
add_pld_pending_loads: task id 103 inserted  
add_pld_pending_loads: task id 104 inserted  
add_pld_pending_loads1: task id 105 NOT inserted  
add_pld_pending_loads1: task id 106 NOT inserted  
add_pld_pending_loads1: task id 107 NOT inserted  
add_pld_pending_loads1: task id 108 NOT inserted  
add_pld_pending_loads1: task id 109 NOT inserted  
add_pld_pending_loads: task id 110 inserted  
add_pld_pending_loads: task id 111 inserted  
add_pld_pending_loads1: task id 112 NOT inserted  
add_pld_pending_loads9: task id 113 NOT inserted  
add_pld_pending_loads1: task id 114 NOT inserted  
add_pld_pending_loads0: task id 115 NOT inserted  
add_pld_pending_loads0: task id 116 NOT inserted  
add_pld_pending_loads0: task id 117 NOT inserted  
add_pld_pending_loads0: task id 118 NOT inserted  
add_pld_pending_loads0: task id 119 NOT inserted  
add_pld_pending_loads0: task id 120 NOT inserted  
add_pld_pending_loads9: task id 121 NOT inserted  
add_pld_pending_loads9: task id 122 NOT inserted  
add_pld_pending_loads: task id 123 inserted  
add_pld_pending_loads9: task id 124 NOT inserted  
add_pld_pending_loads0: task id 125 NOT inserted  
add_pld_pending_loads9: task id 126 NOT inserted  
add_pld_pending_loads9a: task id 127 NOT inserted  
add_pld_pending_loads: task id 128 inserted  
add_pld_pending_loads: task id 129 inserted  
add_pld_pending_loads0: task id 130 NOT inserted  
add_pld_pending_loads0: task id 131 NOT inserted  
add_pld_pending_loads0: task id 132 NOT inserted  
add_pld_pending_loads0: task id 133 NOT inserted  
add_pld_pending_loads0: task id 134 NOT inserted  
add_pld_pending_loads0: task id 135 NOT inserted  
add_pld_pending_loads0: task id 136 NOT inserted  
add_pld_pending_loads0: task id 137 NOT inserted  
add_pld_pending_loads1: task id 138 NOT inserted  
add_pld_pending_loads1: task id 139 NOT inserted  
add_pld_pending_loads1: task id 140 NOT inserted  
add_pld_pending_loads1: task id 141 NOT inserted  
add_pld_pending_loads1: task id 142 NOT inserted  
add_pld_pending_loads0: task id 143 NOT inserted  
add_pld_pending_loads0: task id 144 NOT inserted  
add_pld_pending_loads: task id 145 inserted  
add_pld_pending_loads: task id 146 inserted  
add_pld_pending_loads0: task id 147 NOT inserted  
add_pld_pending_loads0: task id 148 NOT inserted  
add_pld_pending_loads0: task id 149 NOT inserted  
add_pld_pending_loads1: task id 150 NOT inserted  
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530191) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530192) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530193) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530194) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530195) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530196) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530197) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530198) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530199) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530200) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530201) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530202) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530203) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530204) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530205) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530206) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530207) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530208) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530210) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530212) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530214) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530216) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530218) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530220) (PROCESS=E_WORKERS)
CONCURRENT MSC MSCNSW "PLAN_ID=21"                     "SNAPSHOT_WORKER=1" "MON_PNAME=eng21_mon_0" "MON_REQUEST_ID=530189"                          "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
GEN-LAUNCHED REQUEST (REQUEST_ID=530222) (PROCESS=E_WORKERS)
Direct load status N
file  1 not written or load not completed
file  2 not written or load not completed
file  3 not written or load not completed
file  4 not written or load not completed
file  6 not written or load not completed
file  7 not written or load not completed
file  8 not written or load not completed
file  9 not written or load not completed
file  10 not written or load not completed
file  11 not written or load not completed
file  12 not written or load not completed
file  13 not written or load not completed
file  14 not written or load not completed
file  15 not written or load not completed
file  16 not written or load not completed
file  18 not written or load not completed
file  19 not written or load not completed
file  20 not written or load not completed
file  21 not written or load not completed
file  22 not written or load not completed
file  23 not written or load not completed
file  24 not written or load not completed
file  25 not written or load not completed
file  26 not written or load not completed
file  27 not written or load not completed
file  28 not written or load not completed
file  33 not written or load not completed
file  34 not written or load not completed
file  36 not written or load not completed
file  37 not written or load not completed
file  38 not written or load not completed
file  39 not written or load not completed
file  42 not written or load not completed
file  43 not written or load not completed
file  44 not written or load not completed
file  45 not written or load not completed
file  49 not written or load not completed
file  51 not written or load not completed
file  54 not written or load not completed
file  55 not written or load not completed
file  56 not written or load not completed
file  57 not written or load not completed
file  59 not written or load not completed
file  60 not written or load not completed
file  62 not written or load not completed
file  63 not written or load not completed
file  64 not written or load not completed
file  65 not written or load not completed
file  66 not written or load not completed
file  67 not written or load not completed
file  79 not written or load not completed
file  80 not written or load not completed
file  81 not written or load not completed
file  87 not written or load not completed
file  88 not written or load not completed
file  89 not written or load not completed
file  92 not written or load not completed
file  95 not written or load not completed
file  97 not written or load not completed
file  98 not written or load not completed
file  99 not written or load not completed
file  100 not written or load not completed
file  101 not written or load not completed
file  102 not written or load not completed
file  103 not written or load not completed
file  104 not written or load not completed
file  110 not written or load not completed
file  111 not written or load not completed
file  123 not written or load not completed
file  128 not written or load not completed
file  129 not written or load not completed
file  145 not written or load not completed
file  146 not written or load not completed
status:0
file  1 not written or load not completed
file  2 not written or load not completed
file  3 not written or load not completed
file  4 not written or load not completed
file  6 not written or load not completed
file  7 not written or load not completed
file  8 not written or load not completed
file  9 not written or load not completed
file  10 not written or load not completed
file  11 not written or load not completed
file  12 not written or load not completed
file  13 not written or load not completed
file  14 not written or load not completed
file  15 not written or load not completed
file  16 not written or load not completed
file  18 not written or load not completed
file  19 not written or load not completed
file  20 not written or load not completed
file  21 not written or load not completed
file  22 not written or load not completed
file  23 not written or load not completed
file  24 not written or load not completed
file  25 not written or load not completed
file  26 not written or load not completed
file  27 not written or load not completed
file  28 not written or load not completed
file  33 not written or load not completed
file  34 not written or load not completed
file  36 not written or load not completed
file  37 not written or load not completed
file  38 not written or load not completed
file  39 not written or load not completed
file  42 not written or load not completed
file  43 not written or load not completed
file  44 not written or load not completed
file  45 not written or load not completed
file  49 not written or load not completed
file  51 not written or load not completed
file  54 not written or load not completed
file  55 not written or load not completed
file  56 not written or load not completed
file  57 not written or load not completed
file  59 not written or load not completed
file  60 not written or load not completed
file  62 not written or load not completed
file  63 not written or load not completed
file  64 not written or load not completed
file  65 not written or load not completed
file  66 not written or load not completed
file  67 not written or load not completed
file  79 not written or load not completed
file  80 not written or load not completed
file  81 not written or load not completed
file  87 not written or load not completed
file  88 not written or load not completed
file  89 not written or load not completed
file  92 not written or load not completed
file  95 not written or load not completed
file  97 not written or load not completed
file  98 not written or load not completed
file  99 not written or load not completed
file  100 not written or load not completed
file  101 not written or load not completed
file  102 not written or load not completed
file  103 not written or load not completed
file  104 not written or load not completed
file  110 not written or load not completed
file  111 not written or load not completed
file  123 not written or load not completed
file  128 not written or load not completed
file  129 not written or load not completed
file  145 not written or load not completed
file  146 not written or load not completed
status:0
file  1 not written or load not completed
file  2 not written or load not completed
file  3 not written or load not completed
file  4 not written or load not completed
file  6 not written or load not completed
file  7 not written or load not completed
file  8 not written or load not completed
file  9 not written or load not completed
file  10 not written or load not completed
file  11 not written or load not completed
file  12 not written or load not completed
file  13 not written or load not completed
file  14 not written or load not completed
file  15 not written or load not completed
file  16 not written or load not completed
file  18 not written or load not completed
file  19 not written or load not completed
file  20 not written or load not completed
file  21 not written or load not completed
file  22 not written or load not completed
file  23 not written or load not completed
file  24 not written or load not completed
file  25 not written or load not completed
file  26 not written or load not completed
file  27 not written or load not completed
file  28 not written or load not completed
file  33 not written or load not completed
file  34 not written or load not completed
file  36 not written or load not completed
file  37 not written or load not completed
file  38 not written or load not completed
file  39 not written or load not completed
file  42 not written or load not completed
file  43 not written or load not completed
file  44 not written or load not completed
file  45 not written or load not completed
file  49 not written or load not completed
file  51 not written or load not completed
file  54 not written or load not completed
file  55 not written or load not completed
file  56 not written or load not completed
file  57 not written or load not completed
file  59 not written or load not completed
file  60 not written or load not completed
file  62 not written or load not completed
file  63 not written or load not completed
file  64 not written or load not completed
file  65 not written or load not completed
file  66 not written or load not completed
file  67 not written or load not completed
file  79 not written or load not completed
file  80 not written or load not completed
file  81 not written or load not completed
file  87 not written or load not completed
file  88 not written or load not completed
file  89 not written or load not completed
file  92 not written or load not completed
file  95 not written or load not completed
file  97 not written or load not completed
file  98 not written or load not completed
file  99 not written or load not completed
file  100 not written or load not completed
file  101 not written or load not completed
file  102 not written or load not completed
file  103 not written or load not completed
file  104 not written or load not completed
file  110 not written or load not completed
file  111 not written or load not completed
file  123 not written or load not completed
file  128 not written or load not completed
file  129 not written or load not completed
file  145 not written or load not completed
file  146 not written or load not completed
status:0
CONCURRENT MSC MSCPLD "CTRL_FILE=/u01/test/app/fs_ne/inst/TEST_test/logs/appl/conc/out/data21/mbpoutput/MSLD_ITEMS.ctl" "DATA_FILE=/u01/test/app/fs_ne/inst/TEST_test/logs/appl/conc/out/data21/mbpoutput/MSLD_ITEMS.dat" "DISCARD_FILE=/u01/test/app/fs_ne/inst/TEST_test/logs/appl/conc/out/data21/mbpoutput/MSLD_ITEMS.dis" "BAD_FILE=/u01/test/app/fs_ne/inst/TEST_test/logs/appl/conc/out/data21/mbpoutput/MSLD_ITEMS.bad"
已启动 SQL*LOAD 的并发请求 530241
file  2 not written or load not completed
file  3 not written or load not completed
file  4 not written or load not completed
file  6 not written or load not completed
file  7 not written or load not completed
file  8 not written or load not completed
file  9 not written or load not completed
file  10 not written or load not completed
file  11 not written or load not completed
file  12 not written or load not completed
file  13 not written or load not completed
file  14 not written or load not completed
file  15 not written or load not completed
file  16 not written or load not completed
file  18 not written or load not completed
file  19 not written or load not completed
file  20 not written or load not completed
file  21 not written or load not completed
file  22 not written or load not completed
file  23 not written or load not completed
file  24 not written or load not completed
file  25 not written or load not completed
file  26 not written or load not completed
file  27 not written or load not completed
file  28 not written or load not completed
file  33 not written or load not completed
file  34 not written or load not completed
file  36 not written or load not completed
file  37 not written or load not completed
file  38 not written or load not completed
file  39 not written or load not completed
file  42 not written or load not completed
file  43 not written or load not completed
file  44 not written or load not completed
file  45 not written or load not completed
file  49 not written or load not completed
file  51 not written or load not completed
file  54 not written or load not completed
file  55 not written or load not completed
file  56 not written or load not completed
file  57 not written or load not completed
file  59 not written or load not completed
file  60 not written or load not completed
file  62 not written or load not completed
file  63 not written or load not completed
file  64 not written or load not completed
file  65 not written or load not completed
file  66 not written or load not completed
file  67 not written or load not completed
file  79 not written or load not completed
file  80 not written or load not completed
file  81 not written or load not completed
file  87 not written or load not completed
file  88 not written or load not completed
file  89 not written or load not completed
file  92 not written or load not completed
file  95 not written or load not completed
file  97 not written or load not completed
file  98 not written or load not completed
file  99 not written or load not completed
file  100 not written or load not completed
file  101 not written or load not completed
file  102 not written or load not completed
file  103 not written or load not completed
file  104 not written or load not completed
file  110 not written or load not completed
file  111 not written or load not completed
file  123 not written or load not completed
file  128 not written or load not completed
file  129 not written or load not completed
file  145 not written or load not completed
file  146 not written or load not completed
status:0
file  2 not written or load not completed
file  3 not written or load not completed
file  4 not written or load not completed
file  6 not written or load not completed
file  7 not written or load not completed
file  8 not written or load not completed
file  9 not written or load not completed
file  10 not written or load not completed
file  11 not written or load not completed
file  12 not written or load not completed
file  13 not written or load not completed
file  14 not written or load not completed
file  15 not written or load not completed
file  16 not written or load not completed
file  18 not written or load not completed
file  19 not written or load not completed
file  20 not written or load not completed
file  21 not written or load not completed
file  22 not written or load not completed
file  23 not written or load not completed
file  24 not written or load not completed
file  25 not written or load not completed
file  26 not written or load not completed
file  27 not written or load not completed
file  28 not written or load not completed
file  33 not written or load not completed
file  34 not written or load not completed
file  36 not written or load not completed
file  37 not written or load not completed
file  38 not written or load not completed
file  39 not written or load not completed
file  42 not written or load not completed
file  43 not written or load not completed
file  44 not written or load not completed
file  45 not written or load not completed
file  49 not written or load not completed
file  51 not written or load not completed
file  54 not written or load not completed
file  55 not written or load not completed
file  56 not written or load not completed
file  57 not written or load not completed
file  59 not written or load not completed
file  60 not written or load not completed
file  62 not written or load not completed
file  63 not written or load not completed
file  64 not written or load not completed
file  65 not written or load not completed
file  66 not written or load not completed
file  67 not written or load not completed
file  79 not written or load not completed
file  80 not written or load not completed
file  81 not written or load not completed
file  87 not written or load not completed
file  88 not written or load not completed
file  89 not written or load not completed
file  92 not written or load not completed
file  95 not written or load not completed
file  97 not written or load not completed
file  98 not written or load not completed
file  99 not written or load not completed
file  100 not written or load not completed
file  101 not written or load not completed
file  102 not written or load not completed
file  103 not written or load not completed
file  104 not written or load not completed
file  110 not written or load not completed
file  111 not written or load not completed
file  123 not written or load not completed
file  128 not written or load not completed
file  129 not written or load not completed
file  145 not written or load not completed
file  146 not written or load not completed
status:0
后面就是重复上面的file  XXX not written or load not completed

使用道具 举报

回复
大神无量111
论坛徽章:
0
13#
 楼主| 发表于 2015-12-22 15:26 | 只看该作者
greencha 发表于 2015-12-22 15:05
若是 memory based snapshot 的效能问题
多半有些patch要再apply
若您有metalink 帐号, 可以依您的使用版 ...

恩 好的，我去试试看。万分感谢您的解答。

使用道具 举报

回复
greencha
论坛徽章:
1
ITPUB 11周年纪念徽章 日期:2012-10-09 18:07:31
14#
发表于 2015-12-22 15:26 | 只看该作者
1.OK, 12.2.4 算是比较新的ERP版本了, (最新是12.2.5)
  但VCP (ASCP), 也应更新到 12.2.4.1 比较匹配
2.从Plan Option来看, 没有启用到MSO模组,
  这要从License Manager去开启, 才能用到进阶功能
3.我猜目前ERP和ASCP安装在同一部机器上吧?
  若从来没有RUN过ASCP, 建议先做一次relink动作,
  能安装 12.2.4 的硬体, 我猜应该是64bit不会错的,
  建议您打开64bit模式
4.能够安装到 12.2.4, 表示应该和Oracle还有合约吧?
  这类问题, 您也可以问您的实施顾问, 或者在metalink上Log SR
  这应该比ITPUB有效率?!(也不一定, 但至少他是有义务帮您)

使用道具 举报

回复
大神无量111
论坛徽章:
0
15#
 楼主| 发表于 2015-12-22 15:41 | 只看该作者
greencha 发表于 2015-12-22 15:26
1.OK, 12.2.4 算是比较新的ERP版本了, (最新是12.2.5)
  但VCP (ASCP), 也应更新到 12.2.4.1 比较匹配
2. ...

您好，万分感谢您的解答。 您说的这个relink的动作具体是指的什么，我有点不是很明白。

使用道具 举报

回复
greencha
论坛徽章:
1
ITPUB 11周年纪念徽章 日期:2012-10-09 18:07:31
16#
发表于 2015-12-22 15:45 | 只看该作者
relink 这个问题 您可以找您的DBA
用 adadmin 处理

使用道具 举报

回复
大神无量111
论坛徽章:
0
17#
 楼主| 发表于 2015-12-22 15:46 | 只看该作者
greencha 发表于 2015-12-22 15:45
relink 这个问题 您可以找您的DBA
用 adadmin 处理

嗯嗯 好的。 万分感谢。

使用道具 举报

回复

12
返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

TOP技术积分榜 社区积分榜 徽章 团队 统计 知识索引树 积分竞拍 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档
  ChinaUnix | ChinaUnix博客 | ChinaUnix论坛
CopyRight 1999-2011 itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有　联系我们 未成年人举报专区　
京ICP备16024965号-8 　北京市公安局海淀分局网监中心备案编号：11010802021510　广播电视节目制作经营许可证：编号（京）字第1149号   
快速回复 返回顶部 返回列表