Version

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

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

All,

 

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:

instance-info.jpeg

 

 

 


 

 

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 “instance_info.sh” (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 “./instance_info.sh”

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

 

 

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

 

 

 

 

cheers,

OraclePitStop.

Advertisements
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.

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

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

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