Monday, June 29, 2009

How to find the versions of the following TechStack Components

How to find the versions of the following TechStack Components

Oracle9i Application Server Release 1 Enterprise Edition
Oracle HTTP Server Patch
Oracle Developer 6i Patchset
Oracle Portal
Oracle Login Server
Oracle Discoverer
Oracle Java Server Pages (OJSP)

The following are the steps to find out the versions of the Techstack Components for Oracle Applications :
1. Oracle Developer 6i Patchset
Login to E-Business Suite and choose a forms based responsibility - then do Help-About Oracle Applications.This will show the E-Business Suite Release and the Oracle Developer 6i Patchset level.


2. Application Server version and patchset level (9iAS)
General Configuration Questions

--------------------------------
What versions of Oracle HTTP Server and Apache were shipped with Oracle E-Business Suite Release 11i?


To verify which version of Oracle HTTP Server (Apache) which has been installed, issue the following command:

$APACHE_TOP/Apache/bin/httpd* -version
For a comprehensive summary of all Oracle HTTP Server and Apache versionsdelivered with all Oracle products, Everything YouWanted to Know About The Apache-Based OHS Version.

3. Oracle Portal
begin

execute immediate 'select fnd_oracle_schema.getouvalue(''PORTAL'') from
dual' into portal_user;
begin
execute immediate 'select user_name from fnd_user where user_name like
upper('''portal_user''')'
into portal_user_name;
if portal_user is not null then
execute immediate 'select version from 'portal_user'.wwc_version$'
into portal_ver;check_message := ' [PASS] Your Applications database containsPortal version: 'portal_ver;
dbms_output.put_line(check_message);
end if;
exception
when no_data_found then
null;
end;
exception
when others then
null ;
end;

4. Oracle Login Server
begin
execute immediate 'select fnd_oracle_schema.getouvalue(''LOGINSERVER'') from
dual' into sso_user;
begin
execute immediate 'select user_name from fnd_user where user_name like
upper('''sso_user''')' into
sso_user_name;
if sso_user is not null then
execute immediate 'select version from 'sso_user'.wwc_version$' into
sso_ver;
check_message := ' [PASS] Your Applications database contains Login
Server version: 'sso_ver;
dbms_output.put_line(check_message);
end if;
exception
when no_data_found then
null;
end;
exception
when others then
null ;end;

5. Oracle Discoverer
Again, from the same note -Get the value of %s_disco_ver_comma%Check the applications context file for the variable %s_disco_ver_comma%.


6. Oracle JSP version
Log on to your HTTP Server node, and change to the OA_HTML directory. Using a text editor, create a file called test.jsp with only the following line: <%= application.getAttribute("oracle.jsp.versionNumber") %>


Access this JSP from a web browser, using the URL: http://[your web server]:[your port]/OA_HTML/test.jsp

No comments: