How to Set Up Oracle Database Permissions

Perform this procedure on both nodes.

1. Enable access for the Oracle user and password to be used for fault monitoring.

   Use the Oracle authentication method to grant to the oracle user authority on the v_$sysstat view, v_$archive_dest view, and v_$database view.

   phys-X# sqlplus "/ as sysdba" sql> grant connect, resource to oracle identified by passwd; sql> alter user oracle default tablespace system quota 1m on system; sql> grant select on v_$sysstat to oracle; sql> grant select on v_$archive_dest to oracle;sql> grant select on v_$database to oracle; sql> grant create session to oracle; sql> grant create table to oracle; sql> exit; #

2. Configure NET8 for the Sun Cluster software.

   1. Set the following entries in the default /oracle/oracle/product/10.2.0/network/admin/listener.ora file.

      HOST = oracle-lh POST = 1521

   2. Set the same entries in the default /oracle/oracle/product/10.2.0/network/admin/tnsnames.ora file.

      ---

      Note –

      The values that you set in the listener.ora file and in the tnsnames.ora file must be the same.

      ---