EBS R12加入应用节点报错 RC-40201: Unable to connect to Database SRMG -1

最新推荐文章于 2024-12-29 17:40:42 发布

转载最新推荐文章于 2024-12-29 17:40:42 发布 · 318 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://yq.aliyun.com/articles/382194

文章标签：

#java #网络 #数据库

本文记录了在Oracle EBS R12.1.3环境下，尝试添加第二个应用节点时遇到的问题及错误日志详情。在执行adclonectx.pl addnode命令时，出现无法连接到数据库SRMG的错误RC-40201，具体表现为JDBC连接失败。

Oracle EBS R12.1.3 , Oracle 11.2.0.1

数据库为单机
应用为双节点

目标： APP节点1已经正常运行，现在需要加入APP节点2，在实施： $ perl adclonectx.pl addnode contextfile= 的时候报错。详细log如下：
getConnection() -->
sDbHost : nktsh
sDbDomain : huawei.com
sDbPort : 1521
sDbSid : SRMG
sDbUser : APPS
Trying to connect using SID...
getConnectionUsingSID() -->
JDBC URL: jdbc:oracle:thin:@nktsh.huawei.com:1521:SRMG
Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=nktsh.huawei.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=SRMG)))
Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=nktsh.huawei.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=SRMG.huawei.com)))
Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
Connection could not be obtained; returning null

-------------------ADX Database Utility Finished---------------
StackTrace:
java.lang.Exception: Cant connect to database using DBUtil
at oracle.apps.ad.context.CloneContext.checkDatabaseConnection(CloneContext.java:3745)
at oracle.apps.ad.context.CloneContext.checkDBPort(CloneContext.java:3678)
at oracle.apps.ad.context.CloneContext.preserveOldPortSettings(CloneContext.java:3398)
at oracle.apps.ad.context.CloneContext.promptForPortPool(CloneContext.java:3534)
at oracle.apps.ad.context.CloneContext.doClone(CloneContext.java:616)
at oracle.apps.ad.context.CloneContext.main(CloneContext.java:5196)

RC-40201: Unable to connect to Database SRMG.

本文转自ITPUB博客tolywang的博客，原文链接：EBS R12加入应用节点报错 RC-40201: Unable to connect to Database SRMG -1 ，如需转载请自行联系原博主。