|
Home > Archive > Tools for Oracle database > December 2005 > Obtaining Oracle Licence/Installed Products
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Obtaining Oracle Licence/Installed Products
|
|
| andrasv1@comcast.net 2005-12-19, 8:23 pm |
| Greetings:
I have been placed in charge of looking for a unified command for UNIX
to ennumerate all of the versions of Oracle database as well as the
options/softwares that are associated with it. We have a variety of
Oracle versions and was wondering if there is a simple command or
script that can be run to get the information into a file that I can
use.
I have heard of two methods:
1. Using the inspdver script/command.
2. Ennumerating the unix.rgs file with a script.
Can anybody provide any insight on how I can find this information for
versions of Oracle ranging from 7-10. If there are multiple types of
commands or scripts, any help would be GREATLY appreciated!!!
Regards,
Andras Vancsa
| |
| Daniel 2005-12-20, 3:23 am |
| Try querying v$version.
Daniel
| |
| G Quesnel 2005-12-20, 1:23 pm |
| For a complete list of all Oracle components installed, you can use the
lsinventory command of OPatch;
opatch lsinventory -detail >my.log
The draw back here is that OPatch must be installed (required to
install the security patches), and you would need to set your
ORACLE_HOME as per the oratab ?
| |
| G Quesnel 2005-12-20, 1:23 pm |
| I forgot ...
To get which components are installed in databases >= 9i,
Select comp_name, version from dba_registry;
|
|
|
|
|