开始学习R12 OAF开发喽-解决数据库联接问题

最近想好好搞一下R12 OAF开发，没办法，再不搞就OUT了。

之前搞的11i OAF 也差不多都忘光了，惭愧啊！重头再来吧！

装Jdeveloper, 配置DB，结果发现在run project时总报FNDSECURITY_APPL_SERVER_ID的错，一看肯定是DBC file 里的APPL_SERVER_ID 不对，于是从相应的DB里查正确的ID：

SELECT node_name, server_id  FROM fnd_nodes
SELECT server_id, server_address FROM fnd_application_servers

把这里面的server id 试了一轮，我勒了个去，全不行

(更正： fnd_nodes里的server id 是正确的，汗。。。)

于是查资料，执行下列语句 （无回车）：

java oracle.apps.fnd.security.AdminAppServer apps/  ADD

SECURE_PATH="/export/home/rcd463"

GWYUID=applsyspub/pub

FNDNAM=APPS

APPS_JDBC_DRIVER_TYPE=THIN

GUEST_USER_PWD=guest/guest

DB_HOST=

DB_PORT=1526

DB_NAME=

里面的secure_path 是我可读写的目录，正确的目录$FND_TOP/secure 我没写权限，没办法

文件生成后，把里面的 server id 搞出来一试，没问题了。

用下列语句测试：

java oracle.apps.fnd.security.AdminAppServer apps/ STATUS DBC=/export/home/rcd463/.dbc

可验证DBC 的正确性。

另如何验证GUEST 的密码：

The GUEST password in the context file $APPL_TOP/admin/_.xml

If the context file one was incorrect, we would have had to correct it and rerun AutoConfig, otherwise we would have had to just adjust the .dbc file and restart the app.

To confirm which password was correct, we ran the following SQL as user “apps”:

SELECT fnd_web_sec.validate_login('GUEST', 'ORACLE') FROM dual;

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10359218/viewspace-707205/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10359218/viewspace-707205/