|
|
|
Below you will find commonly asked questions about various
component Version in Oracle Applications & way to find them which might be
helpful in Apps DBA Job. Most of these are for Unix / Linux.
Q: How to find OUI version ?
OUI stands for Oracle Universal Installer. In order to find Installer version you
have to execute ./runInstaller -help ( From OUI location)
You will get output like
Oracle Universal Installer, Version 10.1.0.4.0 Production
Copyright (C) 1999, 2005, Oracle. All rights reserved.
That means OUI version in above case is 10.1.0.4
OUI location is $ORACLE_HOME/oui/bin
Q: How to find Database version ?
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
Q: How to find Oracle Workflow Cartridge Release Version ?
Log in to the database as the owf_mgr user and issue
select wf_core.translate('WF_VERSION') from dual;
Q: How to find opatch Version ?
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
|
Previous Page
|
Next Page
|
|
|
|
|