How to check different version in Oracle Apps R12



                                     Check Application Version 
 
1) Database Version

SQL> desc v$version
 Name                                      Null?    Type
 -------------- --- ----------
 BANNER                                             VARCHAR2(80)

SQL> select banner from v$version;

BANNER
---------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE    11.1.0.7.0      Production
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production

2) Application Release.
 
SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME
-----------------
12.1.1




3)  Web Server/Apache or Application Server in Apps 11i/R12
 
A. Log in as Application user, set environment variable and run below query$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version

[appl201@prdcl201 bin]$ httpd -version
Server version: Oracle-Application-Server-10g/10.1.3.4.0 Oracle-HTTP-Server
Server built:   Jul  7 2008 14:58:00
[appl201@prdcl201 bin]$ pwd
/patches/applprod/apps/tech_st/10.1.3/Apache/Apache/bin

4A)  Forms & Report version (aka developer 6i) in 11i
A. 
Log in as Application user, set environment variable and run below query
$ORACLE_HOME/bin/f60run | grep Version | grep Forms
output like
Forms 6.0 (Forms Runtime) Version 6.0.8.25.2 (Production)
Check fourth character in version 25 which means Forms 6i patchset 16 (25-9)
.
4B)  Forms & Report version in R12
A. Log in as Application user, set environment variable and run below query
$ORACLE_HOME/bin/rwrun | grep Release
Output should be like
[appl201@prdcl201 bin]$  rwrun | grep Release
REP-0503: You did not specify the name of a report.
Report Builder: Release 10.1.2.3.0 - Production on Tue Jul 19 10:36:21 2011
[appl201@prdcl201 bin]$ pwd
/patches/applprod/apps/tech_st/10.1.2/bin

5) OracleJinitiator in11i/R12/12i
A.
 Log in as Application user, set environment variable and run below query
[appl201@prdcl201 bin]$ grep jinit_ver_comma $CONTEXT_FILE
         <jinit_ver_comma oa_var="s_jinit_ver_comma">1.6.0_07</jinit_ver_comma>
 
6) RED HAT RELEASE

[appl201@prdcl201 bin]$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.4 (Tikanga)

7) JAVA PLUGIN
 
[appl201@prdcl201 bin]$ grep plugin $CONTEXT_FILE
         <!- JDK plugins ->
         <sun_plugin_ver oa_var="s_sun_plugin_ver">1.6.0_07</sun_plugin_ver>
         <sun_plugin_type oa_var="s_sun_plugin_type">jdk</sun_plugin_type>

8) APPLICATION SERVER VERSION
 
[appl201@prdcl201 12.0.0]$ cat $ORACLE_HOME/config/ias.properties | grep Version
Version=10.1.2.3.0

9) OC4J(Oracle Container for J2EE)
 
[appl201@prdcl201 home]$ java -jar oc4j.jar -version
Oracle Application Server Containers for J2EE 10g (10.1.2.3.0) (build 080228.2305.2133)
[appl201@prdcl201 home]$ pwd
/patches/applprod/apps/tech_st/10.1.2/j2ee/home


1.Q: How to find Database version ?

Ans:SQL> select * from v$version;
The command returns the release information, such as the following:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
PL/SQL Release 9.2.0.7.0 - Production
CORE 9.2.0.7.0 Production
TNS for 32-bit Windows: Version 9.2.0.7.0 - Production
NLSRTL Version 9.2.0.7.0 - Production


2.Q: How to find Oracle Workflow Cartridge Release Version ?

Ans:Log in to the database as the owf_mgr user and issue
select wf_core.translate(\'WF_VERSION\') from dual;


3.Q: How to find opatch Version ?

Ans:opatch is utility to apply database patch , In order to find opatch version execute
\"$ORACLE_HOME/OPatch/opatch version\"
You should see output like OPatch Version: 1.0.0.0.52
which means your opatch version is 1.0.0.0.52


4.Q How to Discoverer Version installed with Apps ?

Ans:Discoverer with Apps installed in ORACLE_HOME same as 806 is usually 3i or 4i.
To find Version login to Application Tier & go to $ORACLE_HOME/discwb4/bin and execute

strings dis4ws | grep -i \'discoverer version\'

You should see output like
Discoverer Version:Session 4.1.47.09.00
Which means you are on discoverer 4i version 4.1.47.09


5. Q. How to find Version of Apps 11i ?

Ans:Run following SQL from apps user ;
SQL> select RELEASE_NAME from fnd_product_groups;
You should see output like
RELEASE_NAME
-----------------------
11.5.10.2
Which means you are on Apps Version 11.5.10.2


6.Q. How to find Workflow Version embedded in Apps 11i ?

Ans:Run following SQL from apps user ;
SQL>select TEXT from WF_RESOURCES where NAME=\'WF_VERSION\';

You should see output like
TEXT
----------------------
2.6.0
Which means you are on Workflow Version 2.6.0

You can also use script wfver.sql in FND_TOP/sql to find version of workflow in Apps.


7.Q: How to find version of JDK Installed on Apps ?

Ans:There might be multiple JDK installed on Operating System .
Like JDK 1.3.1, 1.4.2 or 1.5 but in order to find which Version of JDK your Apps is using
Open your Context File $SID_$HOSTNAME.xml under $APPL_TOP/admin and look for variable
JDK_TOP oa_var=\"s_jdktop\" what
so ever value assigned against that parameter go to that directory & cd bin & execute command
./java -version
so lets assume entry above is /usr/jdk then cd /usr/jdk/bin & ./java -version , you will see output like

java version \"1.4.2_10\"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_10-b03)
Java HotSpot(TM) Client VM (build 1.4.2_10-b03, mixed mode)
Which means you are using JDK 1.4.2 in Oracle Applications 11i.  




 

No comments:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...