Tag: public thread

Oracle RAC Database Private Thread

One of our RAC database has a private thread for some reason by a DBA playing around.

SQL> select thread#, enabled from v$thread;

  THREAD# ENABLED
---------- --------
         1 PUBLIC
         2 PUBLIC
         3 PRIVATE

SOLUTION

  1. Check spfile with thread 3 included.
  2. Add redo log groups for thread 3.
  3. Add undo tablespace for threda 3.
    CREATE SMALLFILE UNDO TABLESPACE UNDOTBS3 DATAFILE ‘+DATA2’ SIZE 512M AUTOEXTEND ON NEXT 5120K MAXSIZE 32767M;
  4. Disable thread 3.

    SQL> Alter database disable public thread 3;
  5. Enable thread 3.

    SQL> Alter database enable public thread 3;
  6. Check thread 3 changes to PUBLIC.

    SQL> select thread#, enabled from v$thread;

    THREAD# ENABLED
    ———- ——–
    1 PUBLIC
    2 PUBLIC
    3 PUBLIC