verify user with role UMX|APPS Schema Connect

Set Up Necessary Oracle E-Business Suite Users

Set up a necessary Oracle E-Business Suite user with role UMX|APPS Schema Connect. Refer to Section 2.1.3 Set Up Necessary Oracle E-Business Suite Users in My Oracle Support Knowledge Document 974949.1, titled Oracle E-Business Suite Software Development Kit for Java Readme.

After setting up the user, logon locally to Oracle E-Business Suite as the user with role UMX|Apps Schema Connect.

http://.:/OA_HTML/AppsLocalLogin.jsp

If this user has just been created, you will be prompted on logon to Oracle E-Business Suite to reset the password. Reset the password.

Verify that you can successfully logon locally with the new password as the user with role UMX|Apps Schema Connect.

Solution:

SQL> desc wf_user_roles

 Name                                      Null?    Type

 ----------------------------------------- -------- ----------------------------

 USER_NAME                                 NOT NULL VARCHAR2(320)

 ROLE_NAME                                 NOT NULL VARCHAR2(320)

 USER_ORIG_SYSTEM                                   VARCHAR2(30)

 USER_ORIG_SYSTEM_ID                                NUMBER

 ROLE_ORIG_SYSTEM                                   VARCHAR2(30)

 ROLE_ORIG_SYSTEM_ID                                NUMBER

 START_DATE                                         DATE

 EXPIRATION_DATE                                    DATE

 ASSIGNMENT_TYPE                                    VARCHAR2(1)

 PARENT_ORIG_SYSTEM                                 VARCHAR2(30)

 PARENT_ORIG_SYSTEM_ID                              NUMBER

 PARTITION_ID                                       NUMBER

 ASSIGNMENT_REASON                                  VARCHAR2(4000)

SQL> select USER_NAME,ROLE_NAME from wf_user_roles where USER_NAME='EBSADMIN';

USER_NAME

--------------------------------------------------------------------------------

ROLE_NAME

--------------------------------------------------------------------------------

EBSADMIN

EBSADMIN

EBSADMIN

FND_RESP0:20419

EBSADMIN

FND_RESP1:20420

USER_NAME

--------------------------------------------------------------------------------

ROLE_NAME

--------------------------------------------------------------------------------

EBSADMIN

FND_RESP|FND|APPLICATION_DEVELOPER|STANDARD

EBSADMIN

FND_RESP|FND|APPLICATION_DIAGNOSTICS|STANDARD

EBSADMIN

FND_RESP|SYSADMIN|SYSTEM_ADMINISTRATOR|STANDARD

USER_NAME

--------------------------------------------------------------------------------

ROLE_NAME

--------------------------------------------------------------------------------

EBSADMIN

UMX|APPS_SCHEMA_CONNECT

EBSADMIN

UMX|ODF_DIAGNOSTICS_SUPER_USER_ROLE


If the 'Apps Schema Connect Role' role is not present in the wf_user_roles for the ASADMIN user, then run the 'Workflow Directory Services User/Role Validation' concurrent program to grant the role.

ORA-20002: 3825: Error '-24033 - ORA-24033: no recipients for message' encountered during execution of Rule function 'WF_RULE.ERROR_RULE'

ORA-20002: 3825: Error '-24033 - ORA-24033: no recipients for message' encountered during execution of Rule function 'WF_RULE.ERROR_RULE' for event 'oracle.apps.fnd.cp.gsc.SvcComponent.stop' with key 'SVC:29-APR-2015'. FUNCTION_NAME=WF_EVENT_OJMSTEXT_QH.enqueue()
Error:
When we try to start/stop the Worflow mailer it shows this error,

ORA-20002: 3825: Error '-24033 - ORA-24033: no recipients for message' encountered during execution of Rule function 'WF_RULE.ERROR_RULE' for event 'oracle.apps.fnd.cp.gsc.SvcComponent.stop' with key 'SVC:29-APR-2015'. FUNCTION_NAME=WF_EVENT_OJMSTEXT_QH.enqueue()

Solution:

To resolve the issue try restarting the components

1. Workflow Mailer Service

2. Workflow Document Web Services 

3. Workflow Agent Listener Service

Navigation to restart the components

Login as SYSADMIN --> System Administrator --> Oracle Application Manager --> Workflow 

Click on "Notification Mailer" --> Click "Workflow Mailer Services" Under Container Column --> Select "Workflow Mailer Services" --> Select "Start" --> "Go" button --> Ok

Similary do the same for "Workflow Document Web Services" and "Workflow Agent Listener Service"

Now the workflow mailer will be Started/Stopped

Verify registration using OAM Console "out of space in CodeCache for adapters"

 Verify registration using OAM Console

Logon to the OAM Console

http://.:/oamconsole

Verify that the following artifacts are visible now in the OAM Console, under Launch Pad:.

• Application Security (tab) > Click on the 'Agents' icon > Search for {Identifier for your WebGate}
• Application Security (tab) > Click on 'Host Identifiers' (in the 'Access Manager' region) > Search for {Identifier for your WebGate}
• Application Security (tab) > Click on 'Application Domains' (in the 'Access Manager' region) > Search for {Identifier for your WebGate}

If any one see "out of space in CodeCache for adapters" error below is the solution.

Solution:

On your oam_domain location:


/apps/oemora/Oracle/Middleware/user_projects/domains/oam_domain/bin/setDomainEnv.sh


set USER_MEM_ARGS=-XX:ReservedCodeCacheSize=128M -Xms2048M -Xmx2048M -XX:PermSize=256M -XX:MaxPermSize=512M -XX:+UseParallelGC -XX:+UseParallelOldGC -verbose:gc -XX:+PrintGCDetails -XX:-PrintGCDateStamps -Xloggc:/temp/gc/wls_pre_sizing_jms.log

OAM Webgate 11g EditHttpConf tool

While I was working on  OAM (Oracle Access Manager) 11g, trying to get the Webgate agent to install over OHS (Oracle HTTP Server) I came across this odd error:

[oemora@lnxdbtst > /apps/oemora/Oracle/Middleware/Oracle_OAMWebGate1/webgate/ohs/tools/setup/InstallTools]$ ./EditHttpConf \

> -w /apps/oemora/Oracle/Middleware/Oracle_WT1/instances/instance8/config/OHS/ohs1 \

> -oh /apps/oemora/Oracle/Middleware/Oracle_OAMWebGate1

./EditHttpConf: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory

Obviously, the webgate installer doesn't set up the environment for you.  In this case, there's a missing shared library named "libclntsh.so.11.1".  In my environment, there were several instances of that library.  I got random obscure errors, ranging from "unable to run "Ob*", to wrong ELFCLASS.  In the end, I had help from fellow colleagues, but long story short, I needed to reference the shared library in the OHS_HOME directory- in my case it is/u01/middleware/ohs_home/lib, so I needed to run this command:

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$WL_HOME/Oracle_WT1/lib

In doing so, I finally got it to run correctly:

[oemora@lnxdbtst > /apps/oemora/Oracle/Middleware/Oracle_OAMWebGate1/webgate/ohs/tools/setup/InstallTools]$ ./EditHttpConf \

> -w /apps/oemora/Oracle/Middleware/Oracle_WT1/instances/instance8/config/OHS/ohs1 \

> -oh /apps/oemora/Oracle/Middleware/Oracle_OAMWebGate1

The web server configuration file was successfully updated

/apps/oemora/Oracle/Middleware/Oracle_WT1/instances/instance8/config/OHS/ohs1/httpd.conf has been backed up as /apps/oemora/Oracle/Middleware/Oracle_WT1/instances/instance8/config/OHS/ohs1/httpd.conf.ORIG

[oemora@lnxdbtst > /apps/oemora/Oracle/Middleware/Oracle_OAMWebGate1/webgate/ohs/tools/setup/InstallTools]$