Unable to specify Oracle Home during the Vontu upgrade.

Products

• Data Loss Prevention Enforce

Issue/Introduction

While attempting the vontu v.9.0 to v.9.01 upgrade, the upgrade wizard requests the ORACLE_HOME path.  After the path is supplied and the Next button is clicked, the path field blanks out and the upgrader fails to advance.  Subsequent attempts failed to advance the wizard.

Typically, the platform is Linux and the database is on a seperate server, but there is a potential that it can happen with other configurations.

Resolution

This issue may be the result of permissions assigned to the OS user attempting to upgrade.  If the OS user does not have read and write privileges to the ORACLE_HOME directory (in its entirety) then this need to be granted.

If this is a single-tiered environment, the ORACLE_HOME is where the Oracle RDBMS has been installed, typically: /opt/oracle/product/10.2.0/db_1

In a multi-tiered environment, where the update is being executed on a server apart from the Database server, the ORACLE_HOME is where the Oracle client has been installed, typically: /opt/oracle/product/10.2.0/client  or /opt/oracle/product/10.2.0

To change permissions, log into linux as root and do the following:

> chmod 755 -R /opt/oracle/product/10.2.0/

Test by logging into linux as the account that "owns" Vontu and try creating a file in the Oracle home directory.