developers

    Forum Stats

  • 3,874,045 Users
  • 2,266,667 Discussions
  • 7,911,702 Comments

Discussions

Checking the installed components in $ORACLE_HOME

227538
227538 Member Posts: 6
edited May 21, 2008 2:15PM in Database Installation
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

Comments

  • damorgan
    damorgan Member Posts: 14,464 Bronze Crown
    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
    602725 Member Posts: 249
    Hi,

    Use this query to check for components and their status.

    select comp_name,status,version from dba_registry;

    Regards,
    Nagesh
  • 227538
    227538 Member Posts: 6
    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
    damorgan Member Posts: 14,464 Bronze Crown
    I know of no way to get the files but instruct Oracle to not create the component.
  • 227538
    227538 Member Posts: 6
    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
This discussion has been closed.
developers