Value Chain Planning

ORACLE SOLUTION: COMPLETE, OPEN, MODULAR AND INTEGRATED

Advanced Planning Command Center Advanced Supply Chain Planning Collaborative Planning Demand Management Demand Signal Repository Global Order Promising Inventory Optimization Predictive Trade Planning and Optimization Production Scheduling Rapid Planning Real-Time Sales and Operations Planning Service Parts Planning Strategic Network Optimization Value Chain Planning for JD Edwards EnterpriseOne Customers (PDF)

oafm, forms and oacore not starting up -- PRESISENCE

oafm, forms and oacore not starting up after IP adress change of the R12 and Oracle Applications Server

Error Message
06/20/08-19:12:59 :: adoafmctl.sh version 120.6.12000000.2

06/20/08-19:12:59 :: adoafmctl.sh: starting OPMN if it is not running
opmnctl: opmn is already running.
06/20/08-19:12:59 :: adoafmctl.sh: Starting OPMN managed OAFM OC4J instance
opmnctl: starting opmn managed processes...
===========================================================
opmn id=eit.enrichit.com:6210
0 of 1 processes started.
ias-instance id=VIS_eit.eit.enrichit.com
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------------
ias-component/process-type/process-set:
OC4J/oafm/default_group/
Error
--> Process (index=1,uid=1675454223,pid=29758)
failed to start a managed process after the maximum retry limit
Log:
/u02/oracle/VIS/inst/apps/VIS_eit/logs/ora/10.1.3/opmn/OC4J~oafm~default_group~1

06/20/08-19:13:29 :: adoafmctl.sh: exiting with status 204
06/20/08-19:36:14 :: adopmnctl.sh version 120.4.12000000.3

06/20/08-19:36:14 :: adopmnctl.sh: Checking the status of Oracle Process Manager (OPMN)

Processes in Instance: VIS_eit.eit.enrichit.com---------------+--------------+--------+---------+---------
ias-component process-type pid status
---------------+--------------+--------+---------+---------
OC4J oafm N/A Down
OC4J forms N/A Down
OC4J oacore N/A Down
HTTP_Server HTTP_Server 29416 Alive

Cause
The OC4J lock files contains the IP adress, after the ip adress change the lock files includes the wrong Ip adress which caused the OJ4J to fail

Solution
1 - open a new shell and set your apps environment

2 - cd $ADMIN_SCRIPTS_HOME

3 - adopmnctl.sh stop

4 - check if it is really down: ps -ef grep grep opm

5 - delete the following:

rm -fr $INST_TOP/ora/10.1.3/j2ee/oacore/persistence/*
rm -fr $INST_TOP/ora/10.1.3/j2ee/oafm/persistence/*
rm -fr $INST_TOP/ora/10.1.3/j2ee/forms/persistence/*

6 - adopmnctl.sh start

7 - check if the issue has been resolved: adapcctl.sh status

06/20/08-19:36:14 :: adopmnctl.sh: exiting with status 0
[oramgr@eit scripts]$ adopmnctl.sh status
You are running adopmnctl.sh version 120.4.12000000.3
Checking status of OPMN managed processes...

Processes in Instance: VIS_eit.eit.enrichit.com
---------------+--------------+--------+---------+---------
ias-component process-type pid status
---------------+--------------+--------+---------+---------
OC4J oafm N/A Init
OC4J forms N/A Alive
OC4J oacore N/A Alive
HTTP_Server HTTP_Server 5012 Alive
adopmnctl.sh: exiting with status 0
adopmnctl.sh: check the logfile /u02/oracle/VIS/inst/apps/VIS_eit/logs/appl/admin/log/adopmnctl.txt for more information ...

Queries to Check Versions

Simple Queries to retrieve the Version Information

Oracle Applications Version

SQL> select RELEASE_NAME from fnd_product_groups;

 Oracle Database Version

• SQL> select * from v$version;

• SQL> select * from v$version where banner like ‘Oracle%’; 

• Version information can also be checked from Installed Products from the Oracle Universal Installer. 

  It will tell you what products is installed on the machine and also its version information. 

  The installer is located at $ORACLE_HOME/bin/runInstaller  

•  Connect to sqlplus as sysdba it will give you the database version 

Operating System 32/64 Bit?

• In Solaris Systems

/usr/bin/isainfo -kv

• In Linux Systems

uname -m

Important Tables for Conc Mgrs, FND, and AD/Patches

Below are some Important Tables for Concurrent Managers, FND,  and AD/Patches

 

Concurrent Manager

FND_CONCURRENT_QUEUES
FND_CONCURRENT_PROGRAMS
FND_CONCURRENT_REQUESTS
FND_CONCURRENT_PROCESSES
FND_CONCURRENT_QUEUE_SIZE

 

FND

FND_APPL_TOPS
FND_LOGINS
FND_USER
FND_DM_NODES
FND_TNS_ALIASES
FND_NODES
FND_RESPONSIBILITY
FND_DATABASES
FND_UNSUCCESSFUL_LOGINS
FND_LANGUAGES
FND_APPLICATION
FND_PROFILE_OPTION_VALUES

 

 AD / Patches

AD_APPLIED_PATCHES
AD_PATCH_DRIVERS
AD_BUGS
AD_INSTALL_PROCESSES
AD_SESSIONS
AD_APPL_TOPS

****************************************************************************************

Profile Options in Oracle Apps

Below are some useful Profile Options for an Apps DBA

Applications Help Web Agent
Applications Servlet Agent
Applications Web Agent
Concurrent: Active Request Limit
Concurrent: Hold Requests
Concurrent: Multiple Time Zones
Concurrent: Report Access Level
Concurrent: Report Copies
Concurrent: Request priority
Database Instance
Enable Security Group
FND: Debug Log Filename
FND: Debug Log Level
Forms Runtime Parameters
Gateway User ID
ICX: Discoverer Launcher
ICX: Forms Launcher
ICX: Report Launcher
ICX: Limit Connect
ICX: Limit time
ICX: Session Timeout
MO Operating Unit
Node Trust Level
RRA: Delete Temporary Files
RRA: Enabled
RRA: Service Prefix
RRA: Maximum Transfer Size
Self Service Personal Home Page Mode
Sign-On: Audit Level
Signon Password Failure Limit
Signon Password Hard to Guess
Signon Password Length
Signon Password No Reuse
Site Name
Socket Listener Port
TCF: Host
TCF: Port
TWO TASK
Viewer: Text

****************************************************************************************

Query to check Profile Options at all levels

Values of a profile option

• It is sometimes hard to know where a profile option is set. A user might have a profile option set, an application, responsibility, and these might result in unexpected results. 

• The following prompts for the profile name that a user sees. 
• You could also query for the internal profile code instead by using the column a.profile_option_name instead.

select
b.user_profile_option_name "Long Name"
, a.profile_option_name "Short Name"
, decode(to_char(c.level_id),'10001','Site'
,'10002','Application'
,'10003','Responsibility'
,'10004','User'
,'Unknown') "Level"
, decode(to_char(c.level_id),'10001','Site'
,'10002',nvl(h.application_short_name,to_char(c.level_value))
,'10003',nvl(g.responsibility_name,to_char(c.level_value))
,'10004',nvl(e.user_name,to_char(c.level_value))
,'Unknown') "Level Value"
, c.PROFILE_OPTION_VALUE "Profile Value"
, c.profile_option_id "Profile ID"
, to_char(c.LAST_UPDATE_DATE,'DD-MON-YYYY HH24:MI') "Updated Date"
, nvl(d.user_name,to_char(c.last_updated_by)) "Updated By"
from
apps.fnd_profile_options a
, apps.FND_PROFILE_OPTIONS_VL b
, apps.FND_PROFILE_OPTION_VALUES c
, apps.FND_USER d
, apps.FND_USER e
, apps.FND_RESPONSIBILITY_VL g
, apps.FND_APPLICATION h
where
--a.application_id = nvl(401, a.application_id)
--and a.profile_option_name = nvl('INV', a.profile_option_name)
b.user_profile_option_name like '&ProfileName' -- 'AFLOG_ENABLED'
and a.profile_option_name = b.profile_option_name
and a.profile_option_id = c.profile_option_id
and a.application_id = c.application_id
and c.last_updated_by = d.user_id (+)
and c.level_value = e.user_id (+)
and c.level_value = g.responsibility_id (+)
and c.level_value = h.application_id (+)
order by
b.user_profile_option_name, c.level_id,
decode(to_char(c.level_id),'10001','Site'
,'10002',nvl(h.application_short_name,to_char(c.level_value))
,'10003',nvl(g.responsibility_name,to_char(c.level_value))
,'10004',nvl(e.user_name,to_char(c.level_value))
,'Unknown');


******************************************************************************************

Changing Oracle Apps user password for Oracle E-Business Suite R12 Application.

We can follow the below steps  for changing or resetting Oracle Application user password:

Step 1: Login with 'sysadmin' user into Oracle E-Business Suite frontend page.

Step 2: In the Oracle Applications Home Page go to Navigator section, select the User Management responsibility

Step 3: Click the User Management Responsibility, under User Management, click Users

Step 4: In the Oracle User Management of page, we find lot of search options available for use, we can use % also to find the name of the Oracle Application user. If you now the employee id than you can directly enter here.

Let us say we want to change password for Employee id 'E0111' ,than I will enter 'EO111' in the place where User Name is present

Step 5: Search the user
After entering the User Name, click Go

We can see the details as specified below:
Last Name First Name Email User Name Status Create User Reset Password Update

Step 6: Reset the password
Click the Reset Password tab and Choose Enter Manually option of resetting the password. Now, we can enter the password and confirm the password and Click Submit.

Step 7: Verify and inform the User
After resetting or changing the password, we can verify  by logging from the Oracle E-Business Suite front end page.

Let us say we have reset the password of 'E0111' to welcome123,than we can login successfully and inform the user for the change.


*******************************************************************************************