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.

Database

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.
Ie., 6.0.8.24.1
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$;

VERSION
——————————————————————————–
3.0.9.8.1


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

cheers,

OraclePitStop

Advertisements

Make a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

11 Responses to “Versions of components in Oracle Apps”

RSS Feed for OraclePitStop – Lets share some knowledge Comments RSS Feed

Thanks for the info you are maintaining. Very useful !

Hi Mateen,

Thanks for your comment. Please do suggest us if you are looking for a specific topic.

cheers,
OraclePitStop Team

Nice page

%IAS_ORACLE_HOME%\Apache\Apache\apache.exe
Please add the command to know the version in
SOLARIS. apache.exe is not available.

Madhu,

Thanks for pointing it out, my bad.
You can use $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v on any Unix flavour OS to get the apache version.

cheers,
OraclePitStop.

Thanks for the information. CAn you tell me how to find OUI version?

Vimal,

You can find it from the oraparam.ini file under oui directory.

cheers,
Ram.

Very nice information.

How to find the Developer 6i Version in unix/linux.

There is no file with name like Ifrun60* in Linux.

DEV 6i version can be found as follows;

– cd $ORACLE_HOME/bin (8.0.6)
– f60run help=y | grep -i version

Cheers,
Madan

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

Raj,

I had updated the blog with a recent post which will provide all your required information on Linux/Unix. Heres the link -> https://oraclepitstop.wordpress.com/2007/12/11/script-to-gather-instance-information/

cheers,
Ram.


Where's The Comment Form?

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

%d bloggers like this: