Configuring Oracle Database and Oracle Net Services for Oracle DCE Integration
Configuring Oracle DCE Integration 10-11
1. Verify that these lines are in the initialization parameter file:
REMOTE_OS_AUTHENT=FALSE
OS_AUTHENT_PREFIX=""
2. Verify that the initialization parameter file does not have a multi-threaded
server (MTS) entry for DCE. For example, an entry such as the following is not
permitted:
mts_dispatchers="(PROTOCOL=dce)(DISPATCHERS=3)"
3. Ensure that you are logged on as a member of the DBA group. Restart the
database instance for the changes to take effect.
4. At the SQL*Plus prompt, define users. Before doing so, decide whether you are,
or ever will be, operating in a multi-cell DCE environment in which you let
Oracle access across cell boundaries. The way you define users depends on
whether they are connecting within a single cell or across cell boundaries.
Local Cell:
If users are connecting within a local cell, use the following format:
SQL> CREATE USER server_principal IDENTIFIED EXTERNALLY;
SQL> GRANT CREATE SESSION TO server_principal;
For example:
SQL> CREATE USER oracle IDENTIFIED EXTERNALLY;
SQL> GRANT CREATE SESSION TO oracle;
The entire CELL_NAME/SERVER_PRINCIPAL string must be 30 characters or
less (this is an Oracle Database restriction—not a restriction of the DCE adapter).
For example:
SQL> CREATE USER "CELL1/ORACLE" IDENTIFIED EXTERNALLY;
SQL> GRANT CREATE SESSION TO "CELL1/ORACLE";
Multiple Cells:
Note: The MTS_DISPATCHERS initialization parameter is obsolete
in 10g Release 1 (10.1). See Oracle Database Upgrade Guide for further
details.
To Next Page
Loading...