R12 form socket模式登录报错：APP-FND-01542

http://blog.youkuaiyun.com/li7080301/article/details/22040747中提到修改form socket模式

在以socket模式登录时，我们有时会遇到APP-FND-01542无法访问数据库的错误。下面给出几种解决该错误的方法

方法一：

按照Oracle官方文档上的解决方法

修改$CONTEXT_FILE中

<appserverid_authentication oa_var="s_appserverid_authentication">SECURE</appserverid_authentication>

为

<appserverid_authentication oa_var="s_appserverid_authentication">OFF</appserverid_authentication>

相关参数的解释如下：

Application Server Security Authentication can take one of the following values {ON, OFF, SECURE}.
OFF - Server security is not checked. Any application server machine can access the database.
ON - Some level of trust is required to access the database. Either the Application Server is registered with the database or the module and version ID are known to be trusted.
SECURE - Full trust is required for access to the database. Only registered Application Server machines and trusted code modules may connect.

修改完，运行autoconfig

参考：How To Access Forms Directly In Oracle Applications R12 (文档 ID 552301.1)

方法二：

使用下面命令修改

java oracle.apps.fnd.security.AdminAppServer apps/apps AUTHENTICATION OFF DBC=$FND_SECURE/TEST.dbc

java oracle.apps.fnd.security.AdminAppServer apps/apps AUTHENTICATION ON DBC=$FND_SECURE/TEST.dbc

java oracle.apps.fnd.security.AdminAppServer apps/apps AUTHENTICATION SECURE DBC=$FND_SECURE/TEST.dbc

方法三：

直接修改fnd_nodes表中node_name为AUTHENTICATION中server_id的值

update fnd_nodes set server_id='OFF' where node_name='AUTHENTICATION'

 

总结：上述三种方法究其根本都是在修改fnd_nodes表