Saturday, August 23, 2008

Maintenance mode in Apps

When we want to apply a patch in 11i, we first need to put the system in maintenance mode or else the patch will fail and error out. Enabling the maintenance mode feature shuts down the Workflow Business Events System and sets up function security so that no Oracle Applications functions are available to users. Also it ensures optimal performance and reduces downtime when applying a patch.

Here is how we do it->

Run adadmin>Change Maintenance mode>Enable Maintenance mode

And after applying the patch disable it.

Run adadmin>Change Maintenance mode>Disable Maintenance mode

Update Snasphot in apps

Snapshot is a view of the system at specific time. In apps, Patch Wizard uses Global snapshot to determine which patches have been applied to the system and Autopatch uses APPL_TOP snapshot to determine what patches have been applied to that APPL_TOP. Snapshot actually records the list of files,file versions and bug fixes. Both snapshot are views, they are created once during installation and then updated during patching. APPL_TOP snapshot information is stored in the AD_SNAPSHOTS, AD_SNAPSHOT_FILES, and AD_SNAPSHOT_BUGFIXES tables

How to update snapshot?(like after upgrade)

Run adadmin>select Maintain Application files>Maintain Snaphot information>Update current snapshot.

Note that when we update the APPL_TOP snapshot, the Global snapshot is updated at the same time.Also from AD.I the default functionality of checking for prereq patches has been disabled. You can turn on prereq checking by adding options=prereq to the AutoPatch start command.

 

Friday, August 22, 2008

Adsplice in Oracle Apps 11i

In oracle apps, Adsplice is an ad utility which is used to add off-cycle products to oracle apps i.e. products released between maintenance packs.
IDownload the product patch which contains information about the new product,adplice control file and other associated files. Go through the readme and apply pre-reqs if any. Now for using adsplice there is a control file newprods.txt. A typical newprods.txt  looks like->
product=zsa
base_product_top=*APPL_TOP*
oracle_schema=zsa
sizing_factor=100
main_tspace=ZSAD
index_tspace=ZSAX
temp_tspace=TEMP
default_tspace=ZSAD
If we are using OFA tablespace model then we need to change the last 4 parameters else for OATM it is optional.
One can then copy it in $APPL_TOP/admin and run adsplice from applmgr user and follow the prompts.Then we can verify that product is correctly spliced or not using adutconf.sql (AD Configuration report). We need to logout and login again so that the new environment is set.We can then verify that new <PROD>_TOP environment variable is set and  need to apply the patches for newly added product

Wednesday, August 20, 2008

How to find version in Oracle Apps 11i

-->To find apps version

select release_name from apps.fnd_product_groups;

If your are on11i then output will be like 11.5.10 or 11.5.10.2

-->To find Apache/Webserver version

login to web tier as owner of application(applmgr)

$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version

-->To find a file version

adident Header <filename>

-->to find database version

sqlplus

connect / as sysdba

The top most line shows the oracle database version

-->to find forms version

f60gen

-->to find reports version

r60gen

-->to find workflow version

select text from WF_RESOURCES where name= ‘WF_VERSION’;

--To find OA Framework version

http://hostname:port/OA_HTML/OAInfo.jsp

or

adident Header $OA_HTML/OA.jsp

adident Header $FND_TOP/html/OA.jsp

Note:both versions from above command should be same

The following conversion chart can be used to identify the version

OA.jsp Version OA Framework Version

115.61 11.5.10.5RUP 5473858
115.60 11.5.10.4RUP 4676589
115.58 11.5.10.3RUP 4334965 / 5125546
115.56 5.10
115.36 5.7
115.27 5.6

--To find Jinitior version
$OA_HTML/bin/appsweb.cfg
locate the following line
jinit_ver_name=Version=1,3,1,18

--To find if the system is multi-org enabled

select multi_org_flag from fnd_product_groups

--To find if system is multilingual

select multi_lingual_flag from fnd_product_groups

--To find MRC is implemented or not

select multi_currency_flag from fnd_product_groups


Friday, August 15, 2008

How to Compile Apps Schema

This option is used to compile invalid objects in the apps schema(s). Invalid objects are those who have missing definition in the database or can be caused by applying a patch.

To get a listing of invalid objects->

select count(*) from dba_objects where status='INVALID';

To Compile invalid objects->Run adadmin>Goto Compile/Reload Applications Database Entities>compile apps schema

It actually calls adcompsc.pls

To compile the invalid objects in database without using adadmin-run either of these >@$ORACLE_HOME/rdbms/admin/utlrp.sql as sysdba OR

$ORACLE_HOME/rdbms/admin/utlrcmp.sql as sysdba

Also you can compile the objects manually->

alter view <name> compile; (compile view)

alter package<name> compile; (package specification)

alter package<name> compile body; (package body)

Thursday, August 14, 2008

Log file location in Apps

Apps Patch log files(patch log,worker logs,.lgi files) location

$APPL_TOP/admin/<sid>/log

Autoconfig log file location->

$APPL_TOP/admin/<context_name>/log

Database alert log location->

$ORACLE_HOME/admin/<CONTEXT_NAME>/log/bdump/alert<SID>.log

Database trace file location->

$ORACLE_HOME/admin/<CONTEXT_NAME>/log/udump

Concurrent request log file location->

$APPLCSF/$APPLLOG/l<requestid>.log

Concurrent request output file location->

$APPLCSF/$APPLOUT/o<requestid>.out

Concurrent Manager log file location->

$APPLCSF/$APPLLOG/*.mgr

Apache log file location (error.log and access.log)->

$IAS_ORACLE_HOME/Apache/Apache/logs

Sunday, August 3, 2008

How to Change Apps password in oracle apps

Oracle provides a utility called FNDCPASS to change apps password,schema passwords,user passwords in Oracle Apps. There are a few points to remember->APPS and APPLSYS passwords are always same.Changing applsys password will automatically change the apps password. 

How to change apps password->

  • Stop Application Services
  • FNDCPASS apps/<apsppassword> 0 Y system/<systempassword> SYSTEM APPLSYS <newappspassword>
  • eg->FNDCPASS apps/apps123 0 Y system/manager123 SYSTEM APPLSYS APPS321
  • Start Application Services
Please note that in oracle Apps 11i, when changing apps password it is important to run autoconfig to propagate the change across the application or you will need change the apps password in following files manually if it exists.
1. $IAS_ORACLE_HOME\Apache\modplsql\cfg\wdbsvr.app file
2. $ORACLE_HOME/reports60/server/CGIcmd.dat

However, in oracle Apps R12.1, we do NOT need to run autoconfig after  changing apps password. Also, plz note in R12.1, apps password is NOT saved in any files on file system.


How to change an application schema password->
FNDCPASS apps/<appspassword> 0 Y system/<systempassword> ORACLE <SCHEMANAME> <newschamepassword>
eg->FNDCPASS apps/apps123 0 Y system/manager123 ORACLE GL GL123

How to change all application schema passwords at once. This feature is available from 11i.ATG_PF.H Rollup 3. Also there is a one off patch-4745998 for this feature->
FNDCPASS apps/<appspassword> 0 Y system/<systempassword> ALLORACLE <newschamepassword>
eg->FNDCPASS apps/apps123 0 Y system/manager123 ALLORACLE schemapass123

How to change an application user(front-end) password->
FNDCPASS apps/<appspassword> 0 Y system/<systempassword> USER <username> <newuserpassword>
eg->FNDCPASS apps/apps123 0 Y system/manager123 USER ANMGUPTA ANMGUPTA123.