Checking the installed components in $ORACLE_HOME

227538

Hi,

How do I check what all components in the $ORACLE_HOME in oracle 10g installation on AIX. I am in the process of upgrading the production database from 9i to 10G. I want to make sure whether all the required components are installed or not, before proceeding with upgrade. I donot have any database in the current home. I have only ORACLE_HOME.

Thanks and regards
Suresh

damorgan

What do you mean by installed components? Define your terms.

Just guessing what you really want is this:

col comp_name format a40


SELECT comp_name, version, status

FROM dba_registry;

But this is just a wild guess and has nothing to do with $ORACLE_HOME.

602725

Hi,

Use this query to check for components and their status.

select comp_name,status,version from dba_registry;

Regards,
Nagesh

227538

Hi,

Thanks for your reply.
I know how to check installed components when there is a database.

Ex:

If you don't choose to install oracle text component, respective util**.sql file does not get created in the $ORACLE_HOME/rdbms/admin directory when you install the oracle home. So, if my earliar version of database(9.2.0.5) has oracle text component, that particular component will not be upgraded as there is no util**.sql file available in the oracle_home when we run catupgr**.sql to upgrade the database to latest version(10.2.0.3). As I don't want to run in to problems during the production upgrade, I want to make sure all the existing util**.sql files are present in the $ORACLE_HOME.

I hope I have explained clearly.

Thanks and regards
Suresh

damorgan

I know of no way to get the files but instruct Oracle to not create the component.

227538

Hi,

I got the way to do it.

I have to look in $ORA_BASE/oraInventory/logs/installActions******.log after the installation.

I can see at the end of file:

INFO: Current Inventory:
Independent Products:
Oracle Installation Products 2.2.0.18.0
Java Runtime Environment 1.1.8.3.0
Java Runtime Environment 1.3.1.0.0a
Oracle Universal Installer 2.2.0.18.0
Oracle Home: Home920
This Oracle Home has not been changed in this session.
Oracle Home: Home920b
This Oracle Home has not been changed in this session.
Oracle Home: owb92
This Oracle Home has not been changed in this session.
Oracle Home: OraWF920
This Oracle Home has not been changed in this session.
Oracle Home: ora920
This Oracle Home has not been changed in this session.
Oracle Home: OEMAgent
This Oracle Home has not been changed in this session.
Oracle Home: HTMLDB
This Oracle Home has not been changed in this session.
Oracle Home: OUIHome1
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Products 10.2.0.1.0
Sun JDK extensions 10.1.2.0.0
Sun JDK 1.4.2.0.5
Java Runtime Environment 1.4.2.0.0
regexp 2.1.9.0.0
SSL Required Support Files for InstantClient 10.2.0.1.0
Enterprise Manager Repository DB 10.2.0.1.0
Oracle Net Required Support Files 10.2.0.1.0
Enterprise Manager Agent DB 10.2.0.1.0
Enterprise Manager Common Files 10.2.0.1.0
Bali Share 1.1.18.0.0
Oracle Display Fonts 9.0.2.0.0
Oracle Extended Windowing Toolkit 3.4.38.0.0
*****************************
*****************************


Thanks
Suresh