1. What is FNDCPASS?
FNDCPASS is a utility for changing the password of user,system and oracle.
USER (sysadmin and all apps related users passwords):
FNDCPASS apps/apps 0 Y system/manager USER SYSADMIN oracle
SYSTEM (apps,applsys & applsyspub users):
FNDCPASS apps/apps 0 Y system/manager SYSTEM applsys oracle
ORACLE (All 256 modules passwords will be change):
FNDCPASS apps/apps 0 Y system/manager ORACLE INV INV
2. What is 0 & Y in FNDCPASS, FNDLOAD or WFLOAD ?
0 & Y are flags for FND Executable like FNDCPASS & FNDLOAD where
'0' is request id (request ID 0 is assigned to request ID's which are not submitted via Submit Concurrent Request Form).
'Y' indicates the method of invocation. i.e. it is directly invoked from the command-line not from the Submit Request Form.
3. Difference between apps, applsys and applsyspub?
Apps: is a schema which does not contain any tables of itself. We can say APPS is the shared runtime schema for all E-Business Suite products. It contains all the synonyms of all the table in Oracle apps. But it also contains packages, functions, procedures. The default password is apps.
Applsys schema contains all the tables required for administarative purpose. The default password is apps. All the technical products, database objects are consolidated into a single schema called Applsys.
Applsyspub schema is responsible for password checking. The default password is pub. Applsyspub is used for authentication by having read only views.
4. Where apps password location in oracle apps 11i?
In 11i you might have seen couple of files had apps password without encrypted form.
*) IAS_TOP/Apache/modplsql/cfg/wdbsvr.app
(Mod plsql Configuration File)
*) ORACLE_HOME/reports60/server/CGIcmd.dat
(Reports Configuration File)
5.File Which is having applsyspub & Guest user password.
$FND_TOP/secure/SID.dbc
FNDCPASS is a utility for changing the password of user,system and oracle.
USER (sysadmin and all apps related users passwords):
FNDCPASS apps/apps 0 Y system/manager USER SYSADMIN oracle
SYSTEM (apps,applsys & applsyspub users):
FNDCPASS apps/apps 0 Y system/manager SYSTEM applsys oracle
ORACLE (All 256 modules passwords will be change):
FNDCPASS apps/apps 0 Y system/manager ORACLE INV INV
2. What is 0 & Y in FNDCPASS, FNDLOAD or WFLOAD ?
0 & Y are flags for FND Executable like FNDCPASS & FNDLOAD where
'0' is request id (request ID 0 is assigned to request ID's which are not submitted via Submit Concurrent Request Form).
'Y' indicates the method of invocation. i.e. it is directly invoked from the command-line not from the Submit Request Form.
3. Difference between apps, applsys and applsyspub?
Apps: is a schema which does not contain any tables of itself. We can say APPS is the shared runtime schema for all E-Business Suite products. It contains all the synonyms of all the table in Oracle apps. But it also contains packages, functions, procedures. The default password is apps.
Applsys schema contains all the tables required for administarative purpose. The default password is apps. All the technical products, database objects are consolidated into a single schema called Applsys.
Applsyspub schema is responsible for password checking. The default password is pub. Applsyspub is used for authentication by having read only views.
4. Where apps password location in oracle apps 11i?
In 11i you might have seen couple of files had apps password without encrypted form.
*) IAS_TOP/Apache/modplsql/cfg/wdbsvr.app
(Mod plsql Configuration File)
*) ORACLE_HOME/reports60/server/CGIcmd.dat
(Reports Configuration File)
5.File Which is having applsyspub & Guest user password.
$FND_TOP/secure/SID.dbc
No comments:
Post a Comment