Oracle^® Solaris Cluster Data Service for Oracle Database Guide

How to Enable Support for Multithreaded Model in Oracle Databse 12c

In Oracle Database 12c, the multithreaded Oracle model (enables Oracle processes to run as operating system threads in separate address spaces) was introduced and can be enabled using the init parameter threaded_execution as documented within:

Database Reference: 1.281 THREADED_EXECUTION.

To fully support that, an environment variable needs to be set.

1. Using the SUNW.oracle_server RT, type:

   ---

   Note -  The SUNW.oracle_server RT provides the ability to provide environment variables using the User_env extension property.

   ---

   -bash-4.4$ echo "ORA_SERVER_THREAD_ENABLED=false" >> ${ORACLE_HOME}/dbs/user_env 
   root:~# clrs set -p User_env=${ORACLE_HOME}/dbs/user_env <oracle_DB_resource>

2. Using the SUNW.scalable_rac_server_proxy RT.

   No changes are required.

3. If Oracle Grid Infrastructure for Cluster is also used for a single instance DB or RAC, set the init parameter threaded_execution=true.
   1. Stop the DB.

      root:~# clrs disable <oracle_DB_resource>[If an Oracle Solaris Cluster DB resource has already been created]
      -bash-4.4$ srvctl stop database -d <db_unique_name>

   2. Start the DB using srvctl and set threaded_execution=true.

      -bash-4.4$ srvctl start database -d <db_unique_name>
      SQL> alter system set threaded_execution=true scope=spfile; 
      -bash-4.4$ srvctl setenv database -d <db_unique_name> -env ORA_SERVER_THREAD_ENABLED=false

   3. Stop, then start the DB using srvctl.

      -bash-4.4$ srvctl stop database -d <db_unique_name>
          -bash-4.4$ srvctl start database -d <db_unique_name>
          root:~# clrs enable <oracle_DB_resource> [If an Oracle Solaris Cluster DB resource has already been created]