Q1. To check the database version?

A. Logon to SQLPLUS as sysdba :

SQL> SELECT * FROM v$version;

BANNER
----------------------------------------------------------------
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 Linux: Version 9.2.0.7.0 - Production
NLSRTL Version 9.2.0.7.0 - Production

Q2. Check the installed component of Oracle Application Server and their Versions.

A. Logon to SQLPLUS as sysdba

SQL> SELECT COMP_NAME,VERSION,STATUS,SCHEMA FROM dba_registry;

COMP_NAME VERSION STATUS SCHEMA
------------------------------ ------------------------------ ----------- ------------------------------
Oracle9i Catalog Views 9.2.0.7.0 VALID SYS
Oracle9i Packages and Types 9.2.0.7.0 VALID SYS
Oracle Workspace Manager 9.2.0.1.0 VALID WMSYS
JServer JAVA Virtual Machine 9.2.0.7.0 VALID SYS
Oracle XDK for Java 9.2.0.9.0 VALID SYS
Oracle9i Java Packages 9.2.0.7.0 VALID SYS
Oracle interMedia 9.2.0.7.0 VALID SYS
Spatial 9.2.0.7.0 VALID MDSYS
Oracle Text 9.2.0.7.0 VALID SYS
Oracle XML Database 9.2.0.7.0 VALID XDB
Oracle Data Mining 9.2.0.7.0 VALID ODM

COMP_NAME VERSION STATUS SCHEMA
------------------------------ ------------------------------ ----------- ------------------------------
OLAP Analytic Workspace 9.2.0.7.0 UPGRADED SYS
Oracle OLAP API 9.2.0.7.0 UPGRADED SYS
OLAP Catalog 9.2.0.7.0 VALID OLAPSYS

14 rows selected.

Q3. How to checkthe Oracle Application Server Version?

A. Login to Mid Tier OS user and check the following :

[mid@oas04 install ~]$ cat $ORACLE_HOME/config/ias.properties | grep Version
Version=9.0.4.2.0

=> also login to database and check the mid tier components:

SQL> select * from ias_versions;

COMPONENT_NAME ID VERSION
-------------------------------------------------- ------------------------------ ------------------------------------------------------------------------------------------
Metadata Repository Container mrc 9.0.4.0.0
Oracle Ultrasearch ultrasearch 9.0.4
Oracle9i workflow workflow 2.6.3
Oracle9iAS Discoverer discoverer 5.1.0.0.0
Oracle9iAS Independent Platform ip 9.0.4.0.0
Oracle9iAS Internet Directory oid OID 9.0.4.0.0
Oracle9iAS Portal portal 9.0.4.3.0
Oracle9iAS Single Sign-On sso 9.0.4.0.99
Oracle9iAS Syndication Server syndication 9.0.4
Oracle9iAS UDDI uddi 9.0.4
Oracle9iAS Wireless wireless 9.0.4.2.0

11 rows selected.

Q4. How to find the Oracle Portal Version?

A. Login to SQLPLUS as portal user or as sysdba:

SQL> select version from portal.wwc_version$;

VERSION
------------------------------------------------------------------------------------------
9.0.4.3.0

Q5. How to detemine the Oracle Single Sign On Version?

A. Login to SQLPLUS as sysdba and check the following query:

SQL> select version from orasso.wwc_version$;

VERSION
------------------------------------------------------------------------------------------
9.0.4.3.0

Q6. To check the Oracle Internet Directory Version?

A. Login to Infra Tier OS user:

[infra@oas04 install]$ $ORACLE_HOME/bin/oidldapd -version

oidldapd: Release 9.0.4.3.0 - Production on Thu Sep 3 21:50:32 2009

(c) Copyright 2001 Oracle Corporation. All rights reserved.

=> At database level :

SQL> select attrval from ods.ds_attrstore where entryid = 1 and attrname = 'orcldirectoryversion';

ATTRVAL
----------------------------------------
OID 9.0.4.3.0

Q7. How do know the Ports?

A. Check the following to know the ports:

[infra@oas04 install]cat $ORACLE_HOME/install/portlist.ini

posted by Jaswinder Singh @ 5:15 AM

1 Comments:

At Saturday, December 19, 2009, 4GB SD Karte said…

You can use COM+ and MTS components to access Oracle 7, Oracle 8, Oracle 8i, and Oracle 9i database servers. They can access Oracle database servers on Microsoft Windows NT, Windows 2000, UNIX, and other operating systems. They can access Oracle Workgroup Servers, Oracle Enterprise Servers, and Oracle Parallel Servers.