IGS_学习笔记03_Integrated SOA Gateway设定配置(案例)

20150506 Created By BaoXinjian

一、摘要


在Web服务调用的时候,需要有一个应用数据库用户来连接EBS数据库,因此需要创建一个具备一定权限的用户,而为了简化设置的麻烦,

Oracle提供了一个内建的用户 ASADMIN ,只要启用它并重置密码就可以了。

另外一种方法是新建一个用户后进行授权,这种方法需要的步骤稍微多一点,再次就不做描述。

如果ISG的前提设置没有完成,在后面为集成接口 Generate WSDL 的时候就会报出如下的错误:

复制代码
[fnd.soa.provider.DBConnection.getJDBCConnection]:Error in getting db connection.java.sql.SQLException: 
ORA-01017: invalid username/password; logon denied <MSG_TEXT>An error occurred for port: SOAProvider:Provider processor failed to initialize:
oracle.webservices.provider.ProviderException: DbConnectionError: Error in getting db connection.
ORA-01017: invalid username/password; logon denied.</MSG_TEXT>
or

java.sql.SQLException: ORA
-20001: The Applications user, ASADMIN is not authorized to access the database.
ORA-06512: at "APPS.APP_EXCEPTION", line 72ORA-06512: at "APPS.FND_SECURITY_PKG", line 522ORA-06512: at line 1
复制代码

 

二、锁定统计信息


1. 启用账户ASADMIN,并修改密码,指定相应权限

 (1). 修改账户密码

(2). 指定相应的橘色Apps Schema Connect Role

 

2. 测试用户ASADMIN是否有效,密码是否正确

select fnd_web_sec.validate_login('ASADMIN','welcome') from dual;

 

3. 在数据库中确定用户ASADMIN拥有角色'UMX|APPS_SCHEMA_CONNECT

select substr(user_name, 1, 30) name, substr(role_name, 1, 30) role
from wf_local_user_roles
where ->user_name='ASADMIN'

如果在user manager中已经付给角色,但是并未显示在数据库表中,请使用以下并发程序更新workflow role

 

4. 运行TXK deployment Script来安装SOAAppsAdapter如下

$FND_TOP/bin/txkrun.pl -script=CfgOC4JApp -applicationname=pcapps -oracleinternal=Yes -oc4jpass=welcome -runautoconfig=No

 

5. 运行autoconfig.

$ADMIN_SCRIPTS_HOME/adautocfg.sh

 

6. 确定以下文件是正确配置data-sources.xml

vi $INST_TOP/ora/10.1.3/j2ee/oafm/application-deployments/default/AppsSOAAdapter/oc4j-ra.xml

查看dataSource Name和xADatasourceName是否有问题

复制代码
--oc4j-ra.xml that is shipped with pcapps.rar has the below content:
<connector-factory location="eis/Apps/apps1" connector-name="Oracle Applications Adapter">
<config-property name="xADataSourceName" value="jdbc/Apps1DataSource"/>
<config-property name="dataSourceName" value=""/>
<connection-pooling use="none">
</connection-pooling>
<security-config use="none">
</security-config>
</connector-factory>

--But for SOA Provider to work this needs to be manually modified to
<connector-factory location="/eis/apps/adapter" connector-name="Oracle Applications Adapter">
<config-property name="xADataSourceName" value=""/>
<config-property name="dataSourceName" value="jdbc/AppsDs"/>
<connection-pooling use="none">
</connection-pooling>
<security-config use="none">
</security-config>
</connector-factory>
复制代码

 

7. 重置ASADMIN和OC4JADMIN在中间服务中配置文件的密码

vi $ORA_CONFIG_HOME/10.1.3/j2ee/oafm/config/system-jazn-data.xml

 确定密码是否正确配置,如否,请重置密码

复制代码
1. 确定oc4jadmin的密码是否要重围为welcome
<
user> <name>oc4jadmin</name> <display-name>OC4J Administrator</display-name> <guid>E55B5680462911E5BF5E3320A25D92D0</guid> <description>OC4J Administrator</description> <credentials>!welcome</credentials> </user> 2.确定asadmin的密码是否要重置为welcome
<
user> <name>ASADMIN</name> <display-name>Default Apps SOA User</display-name> <guid>E55B7D91462911E5BF5E3320A25D92D0</guid> <description>Used by SOAProvider for DB connection</description> <credentials>!welcome</credentials> </user>
复制代码

 重启oafm container ($ADMIN_SCRIPTS_HOME/adoafmctl.sh)

 

8. Restart the appsTier.

$ADMIN_SCRIPTS_HOME/adstpall.sh apps/apps
$ADMIN_SCRIPTS_HOME/adstrtal.sh apps/apps

 

三、删除统计信息


1. 终于跳过错误,可以查收WSDL

2. Deploy WSDL也无问题

 

Thanks and Regards

posted on   东方瀚海  阅读(505)  评论(0编辑  收藏  举报

点击右上角即可分享
微信分享提示