User`s guide

3. On the Files Wizard page, select the InstallOracleCollectionUserAccount.sh file.
4. Run the job as root. If desired, select the option of storing results on the VCM Collector.
5. Select the machine(s) on which to create the Oracle Collection User account.
6. Select to run the remote command now. As the remote command is running, the following actions will
be performed:
a. Action will be run with root privileges (for example, Setuid – RunHigh).
b. If the local user does not exist, a non-privileged OS user account will be created and the
password will be locked.
c. Switch or "su" to the ORACLE_SOFTWARE_OWNER_ACCOUNT that was provided.
d. Connect to the Oracle database using the sqlplus binary.
e. Create the Oracle OS-authenticated User account if it does not exist.
f. Grant the Oracle OS-authenticated User account the SELECT_CATALOG role (privilege
necessary for accessing data dictionary views and packages).
g. If the option was chosen to store results in a local directory, the job status (success or failure)
will be returned here.
If you no longer want to collect from an Oracle database, you can remove access to the Oracle database.
Removing Access to the Oracle Database
To remove access to the Oracle database, follow these steps:
1. Edit the Uninstall Oracle Collection User Account remote command in Console > UNIX Remote
Commands > Oracle Account Setup. Click the Uninstall Oracle Collection User Account remote
command, and then click Edit. The Remote Commands wizard appears.
2. Review the default values for the remote command and edit them with the correct values for your
environment. Example values are shown here.
a. Enters the ORACLE_SID (Oracle instance)
b. Enter the ORACLE_HOME (path).
c. Enters the ORACLE_COLLECTION_USER_ACCOUNT that should be removed.
d. Either enter the ORACLE_SOFTWARE_OWNER_ACCOUNT. If left blank, VCM will attempt
to derive it by determining the owner of the ORACLE_HOME directory.
3. In the Files wizard page, select the UninstallOracleCollectionUserAccount.sh file.
4. Run the job as root. If desired, select the option of storing results on the VCM Collector.
5. Select the machine(s) on which to remove the Oracle account.
6. Select to run the remote command now. As the remote command is running, the following actions will
be performed:
a. Action will be run with root privileges (for example, Setuid - RunHigh)
b. The non-privileged OS user account will be deleted.
c. Switch or "su" to the ORACLE_SOFTWARE_OWNER_ACCOUNT that was provided.
d. Connect to the Oracle database using the sqlplus binary.
e. The Oracle OS-authenticated account will be removed for Oracle database.
Getting Started with VCM
VMware, Inc. 127