Set up Oracle to use client authentication.
- Set the following global database server configuration
options:
- Set os_authent_prefix to the value OPS$.
- Set remote_os_authent to the value TRUE.
- Create Oracle database users so the user can use both external
and database authentication methods. Example syntax:
CREATE USER OPS$<user> IDENTIFIED BY <dbpassword> DEFAULT
TABLESPACE <tablespace> TEMPORARY TABLESPACE <temp-tablespace>
QUOTA UNLIMITED ON <tablespace>;
GRANT CONNECT, RESOURCE TO OPS$<user>;
- Ensure you have the Oracle JDBC Type-2 Driver in addition
to the standard Oracle JDBC Type-4 Driver. For Oracle
10g this should be contained in the file ojdbc14.zip.
For Oracle 11g this should be contained in the file ojdbc16.zip
- Enable trusted authentication when installing the product. Provide a username with the OPS$ prefix
when asked for database credentials in the product installer.