在备机上运行问题求助！

显示全部楼层 · 2005-10-30 17:05:33

aix5.2+HACMP5.1双机运行ORACLE ERP 11i生产系统。备机上还运行测试系统和DEMO系统。
主机名：P690 ； IP=128.2.1.101 (服务地址)
备机名：P670 ； IP=128.2.1.103
SID=PROD
生产系统在主机上运行正常，从客户端能登陆到ORACLE电子商务套件。
切换到备机上后，所有服务正常启动，但是不能登陆到ORACLE电子商务套件。
查看各种日志后发现：（注意粗体字）
在主机上时oracle监听日志:/oracle/prodenv/proddb/9.2.0/network/admin/prod.log:

TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.5.0 - Production on 12-JAN-2
005 10:49:26
Copyright (c) 1991, 2002, Oracle Corporation.All rights reserved.
System parameter file is /oracle/prodenv/proddb/9.2.0/network/admin/PROD_sbwerp/
listener.ora
Log messages written to /oracle/prodenv/proddb/9.2.0/network/admin/prod.log
Trace information written to /oracle/prodenv/proddb/9.2.0/network/admin/prod.trc
Trace level is currently 0
Started with pid=1036288
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCPROD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=loopback)(PORT=1521)))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
12-JAN-2005 10:49:28 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=p690)(USER=oraprod))(C
OMMAND=status)(ARGUMENTS=64)(SERVICE=PROD)(VERSION=153093376)) * status * 0
12-JAN-2005 10:49:50 * (CONNECT_DATA=(SERVICE_NAME=PROD)(INSTANCE_NAME=PROD)(CID
=(PROGRAM=)(HOST=p690)(USER=applprod))) * (ADDRESS=(PROTOCOL=tcp)(HOST=128.2.1.1
01)(PORT=52431)) * establish * PROD * 0

在备机上时oracle监听日志:/oracle/prodenv/proddb/9.2.0/network/admin/prod.log:
TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.5.0 - Production on 12-JAN-2
005 09:19:41
Copyright (c) 1991, 2002, Oracle Corporation.All rights reserved.
System parameter file is /oracle/prodenv/proddb/9.2.0/network/admin/PROD_sbwerp/
listener.ora
Log messages written to /oracle/prodenv/proddb/9.2.0/network/admin/prod.log
Trace information written to /oracle/prodenv/proddb/9.2.0/network/admin/prod.trc
Trace level is currently 0
Started with pid=958590
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCPROD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=128.2.1.101)(PORT=1521))
)
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
12-JAN-2005 09:19:41 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=p670)(USER=oraprod))(C
OMMAND=status)(ARGUMENTS=64)(SERVICE=PROD)(VERSION=153093376)) * status * 0
12-JAN-2005 09:20:15 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=p670)(USER=oraprod))(C
OMMAND=status)(ARGUMENTS=64)(SERVICE=PROD)(VERSION=153093376)) * status * 0
12-JAN-2005 09:24:52 * (CONNECT_DATA=(SERVICE_NAME=PROD)(INSTANCE_NAME=PROD)(CID
=(PROGRAM=)(HOST=p670)(USER=applprod))) * (ADDRESS=(PROTOCOL=tcp)(HOST=128.2.1.1
03)(PORT=47082)) * establish * PROD * 0

也就是备机启动ERP后，虽然监听程序监听128.2.1.101，但是应用程序却使用128.2.1.103和数据库通讯。

千问 · 2005-10-30 17:05:33

erp应用层也可以有备份机的形式？

千问 · 2005-10-30 17:05:33

你的备机本身有跑应用吗？如果是这样的话，最好在切换时先将备机上的应用停下来，将主机上的也应用切过来运行。看这样行不行？

千问 · 2005-10-30 17:05:33

备机跑ERP的测试系统，先停测试系统，然后切换，也不行。
/oracle/prodenv/prodora/iAS/Apache/Apache/logs/error_log错误信息：
[Mon Jan 17 10:07:38 2005] [error] [client 128.2.1.103] client denied by server
configuration: /oracle/prodenv/prodcomn/portal/PROD_sbwerp/oprocmgr-service
[Mon Jan 17 10:08:26 2005] [error] OPM:Can not find one alive process
[Mon Jan 17 10:08:26 2005] [error] [client 128.2.6.83] File does not exist: /oa_
servlets/AppsLogin

千问 · 2005-10-30 17:05:33

你是用hacmp来切换吧？确保切换后，备机的ip以及与host必须与主机一致，或者应用层的有关hostname的全部用ip来代替

千问 · 2005-10-30 17:05:33

HOSTS和IP没问题，把应用层的HOSTNAME改成IP太麻烦了吧！