Wednesday, June 01, 2011

How to find the versions of technology stack components?

To find out the versions of Forms, iAS, Framework, JDK, OJSP, Database, etc. for oracle support review, you have to execute the following commands: -

On Application Tier
$ADPERLPRG $FND_TOP/patch/115/bin/ \
-script=$FND_TOP/patch/115/bin/ -txktop=$APPLTMP \
-contextfile=$CONTEXT_FILE \
-appspass=apps \

On Database Tier

-script=$ORACLE_HOME/appsutil/bin/ -txktop=$ORACLE_HOME/appsutil/temp

To generate the report in text format, the parameter "-reporttype=text" needs to be passed to the above commands. For example:

outfile=$ORACLE_HOME/appsutil/temp/Report_DB_Inventory.html -reporttype=text
Once the command executes successfully, it should generate the report file in the location specified for "outfile" parameter in above script

Sukhwinder Singh

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.