修复错误事物处理

检查
select * from mtl_material_transactions where organization_id =109 and costed_flag = 'E'

修复
1.
update mtl_material_transactions
set costed_flag = NULL,
request_id = 0,
program_application_id = 0,
program_id = 0,
program_update_date = null,
error_code = null,
error_explanation = null,
transaction_group_id = null
where organization_id =
and costed_flag = 'E'

2.停’成本管理器’,然后重新启动.
3.回答:成本管理器能否成功运行至完成?
4.如果可以,则证明你原来备份的TRANSACTIONS数据有问题,需要清理一下,再重新走一次.
5.如果不可以,则证明你的管理器有问题.

!!别滥用

单IP单端口监听多实例配置

# tnsnames.ora Network Configuration File: $ORACLE_HOME/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

N1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.179.133)(PORT = 1521))
)

(CONNECT_DATA =
(SERVICE_NAME = N1)
)
)

N2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.179.133)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = N2)
)
)

LISTENER_N1 =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

LISTENER_N2 =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.179.133)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME =MODOSE)
(PRESENTATION = http://HRService)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

# listener.ora Network Configuration File: $ORACLE_HOME/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.179.133)(PORT = 1521))
)
)
)

ADR_BASE_LISTENER = /path/to/apptop

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /path/to/oracle/home)
(PROGRAM = extproc)
)

(SID_DESC =
(GLOBAL DBNAME = N1)
(ORACLE_HOME = /path/to/oracle/home)
(SID_NAME = N1)
)

(SID_DESC =
(GLOBAL DBNAME = N2)
(ORACLE_HOME = /path/to/oracle/home)
(SID_NAME = N2)
)
)