Applying oracle 8.1.7.4 patch

[shirly]

Hi,
I will be applying the oracle 8.1.7.4 patch onto my database. When I did the 8.1.7 installation I had the primary oracle group as oinstall but then changed it back to dba. Does it need to be changed back to oinstall to apply the patch?

[sambavan]

It depends on how you performed the changes. It will be v.helpful if you tell us the OS.

Sam

[shirly]

It is a 32bit Sun Sparc operating system.

[sambavan]

Can you also let us know what are the steps that you performed to change the group privileges:

        1. Did you change the privileges in the /etc/group?

        2. Did you change the inventory privileges at
             /var/opt/oracle/oraInst.loc
        
        3. Did you just recursivly change the Oracle directory group?

        4. Did you change the oraInventory group privileges too?

Note: Out of curiosity, why did you on first place change the group?

-Sam

[shirly]

The installation guide said the primary oracle group should be oinstall, which is why I changed it.

/var/opt/oracle/oraInst.loc remains as dba group
oraIventory directory remains as dba group

I recursively changed group to dba under oracle home.

[sambavan]

Then its cool. You are set to roll. Also check whether you were able to connect to the instance as "sys/password@instance as sysdba". Becaus it is a problem on 9i if you don't have the group sysdba during install. But in your case if you are successful, then you may proceed with the upgrade.

Hope this will help you.

Sam

[shirly]

Thanks for your help!