NaturalOracle DataGaurd tutorial Series Coming Soon!! Natural
For Any queries, please mail us at support@funoracleapps.com

How to install/configure Oracle EBS R12.2 on Multiple Server/Nodes (Database and Application Separately)

No comments

In this post I am going to share how to install Oracle EBS R12.2 on multiple nodes. Which means Database on one server and Application on one server.


I am using Oracle Virtual Box and configured 2 servers, one for Database and one for Application.

Virtual Server/Machine Details

Database Node
Memory: 6 GB
Harddisk: 200 GB
Hostname: fundb.lab
IP: 192.168.56.80
OSuser: oracle
Stage Area has been created separately on nodes and is non shared

Application Node


Memory: 7 GB

Harddisk: 270 GB
Hostname: funapp.lab
IP: 192.168.56.81
OSuser: applmgr
Stage Area has been created separately on nodes and is non shared

 Please perform all the pre-reqs on both nodes as described in earlier post.

1) user creation
2) rpm installation and limits configuration
3) oraInst.loc

Refer https://www.funoracleapps.com/2017/02/installing-oracle-apps-r122-step-by.html for steps by step pre-installation method setup.

Also make sure hostname are pingable from each other. This can be achieved by putting the entries in /etc/hosts file.

Once both the servers are ready to installation. Please follow below steps

1) Kick-off rapidwiz on Database node first. We need to give all information for our db node and apps node. Once the installation on DB node completes, our database and listener would be ready.
























2) There would be a configuration file created on DB node ($ORACLE_HOME/appsutil/conf_.txt). Please copy it to application node as it would be needed during installation. 

3) Now we need to kickoff rapidwiz on application node.




Please provide the path of configuration file copied in step 2.











This completes our installation of EBS on 2 nodes.



No comments :

Post a Comment

Workflow Services are not Running or Starting in R12 Oracle Apps

1 comment
Oracle Workflow Services in Oracle Applications are encountering problems.The workflow components are not starting when I was trying to start up the services from front end web-form using system administrator responsibility.These services appear with a Target value of 1 and an Actual value of 0. Even I tried from Concurrent>Manager>Administer form but still these were not starting.

 Workflow components was not coming  Up and  showing as below


 Target - 1 Actual - 0


Workflow service Components and there shotnames.

Workflow Agent Listener Service - WFALSNRSVC
Workflow Mailer Service - WFMLRSVC
Workflow Document Web Services Service - WFWSSVC

 We can find the same using below query as well.

Workflow Agent Listener Service:

SQL> select CONCURRENT_QUEUE_NAME from  apps.fnd_concurrent_queues_tl where USER_CONCURRENT_QUEUE_NAME='Workflow Agent Listener Service';

CONCURRENT_QUEUE_NAME
------------------------------
WFALSNRSVC


Workflow Mailer Service:

SQL> select CONCURRENT_QUEUE_NAME from  apps.fnd_concurrent_queues_tl where USER_CONCURRENT_QUEUE_NAME='Workflow Mailer Service';

CONCURRENT_QUEUE_NAME
------------------------------
WFMLRSVC


Workflow Document Web Services Service:

SQL> select CONCURRENT_QUEUE_NAME from  apps.fnd_concurrent_queues_tl where USER_CONCURRENT_QUEUE_NAME='Workflow Document Web Services Service';

CONCURRENT_QUEUE_NAME
------------------------------
WFWSSVC



Now to fix the issue we will follow below steps

1) Make the the processes value zero for these services.

UPDATE  fnd_concurrent_queues
SET running_processes = 0, max_processes = 0
where concurrent_queue_name in ('WFWSSVC','WFALSNRSVC','WFMLRSVC'); 

3 rows updated.

2) Update Control codes with NULL

UPDATE  fnd_concurrent_queues
SET control_code = NULL
WHERE concurrent_queue_name in ('WFWSSVC','WFALSNRSVC','WFMLRSVC')
AND control_code not in ('E', 'R', 'X')
AND control_code IS NOT NULL; 

0 rows updated.

3) Make Target node as Null option

UPDATE  fnd_concurrent_queues
SET target_node = null
where concurrent_queue_name in ('WFWSSVC','WFALSNRSVC','WFMLRSVC'); 

3 rows updated.

4) Commit

SQL>commit;

Commit complete.

5) Check Workflow Concurrent Managers

Wait for few minutes, the Internal concurrent manager will bring up services automatically.
We can check the components status using following SQL statements.

SQL> select control_code,running_processes,MAX_PROCESSES from fnd_concurrent_queues where concurrent_queue_name='WFALSNRSVC';

C RUNNING_PROCESSES MAX_PROCESSES
- ----------------- -------------
                  1             1

SQL> select control_code,running_processes,MAX_PROCESSES from fnd_concurrent_queues where concurrent_queue_name='WFALSNRSVC';

C RUNNING_PROCESSES MAX_PROCESSES
- ----------------- -------------
                  1             1

SQL> select control_code,running_processes,MAX_PROCESSES from fnd_concurrent_queues where concurrent_queue_name='WFWSSVC';

C RUNNING_PROCESSES MAX_PROCESSES
- ----------------- -------------
                  1             1

1 comment :

Post a Comment

How to un-link a FND_USER from from SSO in EBS R12

No comments

If we want to unlink any Oracle application user from SSO then we can use below script.



Run the EBS  script

$FND_TOP/patch/115/sql/fndssouu.sql USER_NAME

Apart from setting the FND_USER.USER_GUID value to NULL, this script also flushes the workflow entity cache for the user.

No comments :

Post a Comment

Understanding and Creating Custom Template file for Autoconfig in Oracle Apps R12

No comments


When Autoconfig is executed in EBS/Oracle Apps it creates various configuration files which are created from the template files.
Some time we might need to find the template file associated with these conf file to customize these templates and avoid autoconfig to use the default ones.

Below are the few important points to be remembered.


  • The AutoConfig template file cannot be customized if the "LOCK" keyword appears in the template file.
  • AutoConfig ignores custom template files that are marked with "LOCK”.
  • Customization of Template File must be done on both Patch & Run File system.

How to Determine the Auto Config template file which you want to customize.


Apps Tier: /bin/adtmplreport.sh contextfile=target=

DB Tier: /appsutil/bin/adtmplreport.sh contextfile= target=

Example:

$AD_TOP/bin/adtmplreport.sh contextfile=/u01/TEST/fs1/inst/apps/TEST_funoracleapps/appl/admin/TEST_funoracleapps.xml target=/u01/TEST/fs1/FMW_Home/webtier/instances/EBS_web_TEST_OHS1/config/OHS/EBS_web_TEST/security2.conf

It will generate a log file with required information on configuration file and template file like below


TEMPLATE FILE   : /u01/TEST/fs1/EBSapps/appl/fnd/12.0.0/admin/template/security2_conf_FMW.tmp
TARGET FILE     : /u01/TEST/fs1/FMW_Home/webtier/instances/EBS_web_TEST_OHS1/config/OHS/EBS_web_TEST/security2.conf


Create Custom Template file

  • Create folder custom in location where template file resides.
  • Copy template file in custom folder and make the required changes. 
  • Verify using adchkcfg script that custom template will change files as you expect them to be.
  • Now whenever Autoconfig will run it will pick custom template file only.

No comments :

Post a Comment

Query to check session details in Oracle Database

No comments
We can use below query to check the session details.

Query:


select s.ECID ,s.inst_id, s.SID,s.SERIAL#,p.spid,s.status,s.machine, s.ACTION, s.MODULE, s.TERMINAL,s.sql_id,s.last_call_et,s.event, s.client_info,s.PLSQL_SUBPROGRAM_ID,s.PROGRAM,s.client_identifier
, ( SELECT max( substr( sql_text , 1, 40 )) FROM gv$sql sq WHERE sq.sql_id = s.sql_id ) AS sql_text
, ( SELECT object_name FROM dba_procedures WHERE object_id = plsql_entry_object_id AND subprogram_id = 0) AS plsql_entry_object
, ( SELECT procedure_name FROM dba_procedures WHERE object_id = plsql_entry_object_id AND subprogram_id = plsql_entry_subprogram_id) AS plsql_entry_subprogram
, ( SELECT object_name FROM dba_procedures WHERE object_id = plsql_object_id AND subprogram_id = 0) AS plsql_entry_object
, ( SELECT procedure_name FROM dba_procedures WHERE object_id = plsql_object_id AND subprogram_id = PLSQL_SUBPROGRAM_ID) AS plsql_entry_subprogram
, 'alter system kill session ' || '''' || s.SID || ',' || s.serial# ||',@'|| s.inst_id||''''|| ' immediate;' kill_session
from gv$session s ,gv$process p
where
--client_identifier like '%HIMANSHU.SINGH%'
--s.ecid like '%ZnHWOPoUDWbG%'
-- sid=4361
--p.spid='1196'
--s.program like '%ICM%'
and p.addr=s.paddr
and p.inst_id = s.inst_id
;


Note: Un-comment the condition which ever is required.

No comments :

Post a Comment