Tag: 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