Question: How to determine products installed after Database created?
After a database is created with n products (like Java,Intermedia,XML,...) is there a data dictionary view
that is like v$version which specifes the products installed ?
If yes for Oracle 8i and Oracle 9i ....
[Usefull especially when maintaining a DB that someone else created]
jmodic - Super Moderator is correct, davey23uk answered my question;
DBA_REGISTRY works for Oracle 9i
What about Oracle 8i ?
Last edited by CMT; 09-23-2004 at 07:15 AM.
i do believe dba_registry might hold what you are after or v$option
v$option is a good choice, but it show only products installed inside the db, and do not show installation´s date. To know dates, and/or about other products, IF anyone remove them, OUI make some log files (in C:\Program files\Oracle\Inventory\logs , or something like it), file names are made of the install dates, and inside each file you will find (here im my example I installed Oracle docs in a Portuguese-language machine, so the user messages are in Portuguese, but the principle is the same for anyone ):
A versão do Installer é 18.104.22.168.0a
*** Resumo Página***
ShowSummary = SHOW_SUMMARY_PAGE = true
Origem : E:\stage\products.jar
Oracle Home : D:\O9IR2 (9iR2_home)
Tipo de Instalação : Personalizar
Idiomas do Produto
Requisitos de Espaço
D:\ Exigido 803MB (inclui 223MB temporário) : Disponível 2.45GB
C:\ Exigido 2KB : Disponível 2.54GB
Novas Instalações (1 produto)
Oracle9i Database Documentation for Microsoft Windows 22.214.171.124.0
*** Instalar Página***
You get the dates from DBA_CATALOG. The original poster asked for any dictionary view holding that information and davey23uk gave him a very concise and accurate answer.
Originally posted by JChiappa
v$option is a good choice, but it show only products installed inside the db, and do not show installation´s date. To know dates, and/or about other products....
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
hmm..how abt PRODUCT_COMPONENT_VERSION ??
Click Here to Expand Forum to Full Width