Script to display Oracle Apps 11i Related Information (Instance & Midtier Version/release)

Posted on December 11, 2007. Filed under: Scripts, Version | Tags: , , , |



Its been quite sometime since i updated this blog. But here iam with a post (shell script) which will get you most of the required information in one screen on Unix/Linux OS. So, What to expect from the script, :




1. Versions of all mid tier components

2. Information on nodes attached to the instance and other instance related information.




Below is a sample output of the script:







This script doesnt require any password, infact this script accesses the database by using the hardcorded apps password 🙂


Instructions to download and use the script


Click here instance_infosh1.doc

Save the file as “” (or any name you wish with .sh extension) instead of “instance_infosh1.doc”

Upload the file under any location onto your mid tier.

Execute the script as “./”

Note: This script has to be executed as the applmgr user.



For gathering information of components in Windows, follow this link.







Read Full Post | Make a Comment ( 6 so far )

Versions of components in Oracle Apps

Posted on April 18, 2007. Filed under: Scripts, Version |

How to find versions of oracle components associated with Oracle Apps in Windows Environment

Many times we find ourselves in a situation where we just couldnt get the steps to ascertain the versions of components associated with our instance, be it on Unix/Windows. I had listed the steps below to ascertain the version for each component. All the steps can be used in both Unix/Windows environment , except for Developer6i version. We also have a shell script which will give all this information in a table format which was not tested till now on a Windows environment. If interested put a comment, we will write the script in a post.


Connect as apps user;
<you should be getting the banner with oracle version information>. Alternatively you can also execute
Select * from v$version;

Apps Version

Connect as apps user
select release_name from apps.fnd_product_Groups;

Apache/iAS Version

%IAS_ORACLE_HOME%\Apache\Apache\apache.exe -version

Developer 6i PatchSet

cd %ORACLE_HOME% (806 Oracle Home)
cd bin
Ifrun60.exe help=yAbove command will pop-up a window simillar to this

Forms PatchSet WindowThumbrule : Subtract the fourth integer by 9 to get the patchset level.
Fourth integer => 24
Dev6i PS => 24-9 = 15

Discoverer 4i Version

cd %APPL_TOP%\admin
grep -I s_disco_ver_comma *<sid>*xml

Jinitiator Version

cd %APPL_TOP%\admin
grep -i s_jinit_ver_dot *<sid>*xml

JDK/Java Version

java -version

OJSP Version

cd %OA_HTML%
echo “<%= application.getAttribute(“oracle.jsp.versionNumber”) %>” > test.jspLaunch Browser and enter urlhttp://<hostname>.<domain>:port/OA_HTML/test.jsp

JDBC Version

http://<hostname&gt;.<domain>:port/OA_HTML/jsp/fnd/aoljtest.jspLook for String ” JDBC driver version” under Connection String

OA Framework Version

Option 1http://<hostname&gt;.<domain>:port/OA_HTML/OAInfo.jspOption 2adident Header %FND_TOP%/html/OA.jsp
adident Header %OA_HTML%/OA.jsp
Note: OA.jsp should be of the same version in both the places

AD PatchSet Level

Connect as apps user
select patch_level from fnd_product_installations where patch_level like ‘%AD%’;Note: above sql can be used to identify any modules patchset level by replacing AD with the module name eg., BNE

Portal Version

select fnd_oracle_schema.getouvalue(‘PORTAL’) from dual;FND_ORACLE_SCHEMA.GETOUVALUE(‘PORTAL’)
PORTAL30 <= to retrieve the portal userselect version from PORTAL30.wwc_version$;


For gathering version information on Unix Flavours click this linkDo you have a better way of finding the version. Feel free to comment.



Read Full Post | Make a Comment ( 11 so far )

Liked it here?
Why not try sites on the blogroll...