Prerequisites

The prerequisites are as follows:

1. The database user must have the following configured:
   • CREATE SESSION
   • SELECT ON SYS.V_$PARAMETER

   For example,

   create user testdbuser identified by password123
   /
   grant create session to testdbuser
   /
   grant select on sys.v_$parameter to testdbuser
   /
   

2. The tnsnames.ora file must have a SID and SERVICE name TNS entry.