11G Apps password:
================
QUESTION:
========
What all files need to be changed after changing the Apps Password
Answer-1:
========
1. $ORACLE_HOME/listener/cfg/wdbsvr.app file.
$IAS_ORACLE_HOME\Apache\modplsql\cfg\wdbsvr.app file
2. Workflow Notification Mailer - $FND_TOP/resource/wfmail.cfg
3. The concurrrent manager start script.
4. $OA_HTML/bin/appsweb.cfg
5. $AD_TOP/admin/template/CGIcmd.dat
6. invoke Autoconfig to implement the above changes.
Answer:2
=========
After changing the Apps password using FNDCPASS....Just change the apps password in CONTEXT FILE and then run Autoconfig....It will change the Apps password in All the COnfiguration Files...no need to chang it manually in Configuration files....
wdbsvr.app ( $IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app)
Use FNDCPASS to change the apps password
change in the location wdbsvr.app ($IAS_ORACLE_HOME/Apache/modplsql/conf)
Then bounce the CM and also change in any custome location like
startup and shut down script
Error:
======
I am facing problems to start middle-tier processes by using the script adstrtal.sh located in $COMMON_TOP/admin/scipts/<CONTEXT_NAME>
Some services are started but lots of failed to start giving the error
ERROR : Timed out: Interrupted Exception
oracle@machine1 PROD_machine1]$./adstrtal.sh apps/apps
Solution:
==========
Try to increase the tick ATTRIBUTE in the parameter file for dispatchersthis is core dba scenario n i guess for apps also it is the same
ex:DISPACTHERS=(PRO=TCP)(TICK=20)(SESSION=50)
Question:
=========
How to check the number of session/concurent user connected to Apps instance.pls answer ?
Answer?
========
1.FND_LOGINS and u can see in OAM for forms sessions.
2.select * from fnd_user
where user_id in (select user_id from icx_sessions where last_connect > sysdate -1/24)
That will show, the users who are connected from last One Hour
(1) For Details Explanation go through this Meta Link Document 295206.1
(2) For Relationship between FND_LOGINS and ICX_SESSIONS go through this Metalink Document 358823.1
Question:
==========
To know about the system module information?
Ans:
=====
Run adutconf.sql
R12:
====
To know the password in R12
SQL> select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME='GUEST';
ENCRYPTED_FOUNDATION_PASSWORD
--------------------------------------------------------------------------------
7E0F593AB3A582A9333805E6712A1C15B0A54922665998306D080885A24CE20F
SQL> create FUNCTION apps.decrypt_get_pwd(in_chr_key IN VARCHAR2,in_chr_encrypted_pin IN VARCHAR2)
RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';
/ 2 3
Function created.
SQL> SELECT apps.decrypt_get_pwd('GUEST/ORACLE','7E0F593AB3A582A9333805E6712A1C15B0A54922665998306D080885A24CE20F') from dual;
APPS.DECRYPT_GET_PWD('GUEST/ORACLE','7E0F593AB3A582A9333805E6712A1C15B0A54922665
--------------------------------------------------------------------------------
APPS
================
QUESTION:
========
What all files need to be changed after changing the Apps Password
Answer-1:
========
1. $ORACLE_HOME/listener/cfg/wdbsvr.app file.
$IAS_ORACLE_HOME\Apache\modplsql\cfg\wdbsvr.app file
2. Workflow Notification Mailer - $FND_TOP/resource/wfmail.cfg
3. The concurrrent manager start script.
4. $OA_HTML/bin/appsweb.cfg
5. $AD_TOP/admin/template/CGIcmd.dat
6. invoke Autoconfig to implement the above changes.
Answer:2
=========
After changing the Apps password using FNDCPASS....Just change the apps password in CONTEXT FILE and then run Autoconfig....It will change the Apps password in All the COnfiguration Files...no need to chang it manually in Configuration files....
wdbsvr.app ( $IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app)
Use FNDCPASS to change the apps password
change in the location wdbsvr.app ($IAS_ORACLE_HOME/Apache/modplsql/conf)
Then bounce the CM and also change in any custome location like
startup and shut down script
Error:
======
I am facing problems to start middle-tier processes by using the script adstrtal.sh located in $COMMON_TOP/admin/scipts/<CONTEXT_NAME>
Some services are started but lots of failed to start giving the error
ERROR : Timed out: Interrupted Exception
oracle@machine1 PROD_machine1]$./adstrtal.sh apps/apps
Solution:
==========
Try to increase the tick ATTRIBUTE in the parameter file for dispatchersthis is core dba scenario n i guess for apps also it is the same
ex:DISPACTHERS=(PRO=TCP)(TICK=20)(SESSION=50)
Question:
=========
How to check the number of session/concurent user connected to Apps instance.pls answer ?
Answer?
========
1.FND_LOGINS and u can see in OAM for forms sessions.
2.select * from fnd_user
where user_id in (select user_id from icx_sessions where last_connect > sysdate -1/24)
That will show, the users who are connected from last One Hour
(1) For Details Explanation go through this Meta Link Document 295206.1
(2) For Relationship between FND_LOGINS and ICX_SESSIONS go through this Metalink Document 358823.1
Question:
==========
To know about the system module information?
Ans:
=====
Run adutconf.sql
R12:
====
To know the password in R12
SQL> select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME='GUEST';
ENCRYPTED_FOUNDATION_PASSWORD
--------------------------------------------------------------------------------
7E0F593AB3A582A9333805E6712A1C15B0A54922665998306D080885A24CE20F
SQL> create FUNCTION apps.decrypt_get_pwd(in_chr_key IN VARCHAR2,in_chr_encrypted_pin IN VARCHAR2)
RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';
/ 2 3
Function created.
SQL> SELECT apps.decrypt_get_pwd('GUEST/ORACLE','7E0F593AB3A582A9333805E6712A1C15B0A54922665998306D080885A24CE20F') from dual;
APPS.DECRYPT_GET_PWD('GUEST/ORACLE','7E0F593AB3A582A9333805E6712A1C15B0A54922665
--------------------------------------------------------------------------------
APPS
No comments:
Post a Comment