Database Software

Hi all,

The database is two nodes RAC. It is on window 2003 servers. The version is 10.2.0.3. My question is related to THREAD. I used dbca created a database. After the database was created I queried v$thread and they were two threads and both have status “OPEN” and enabled “PUBLIC”. I was trying to change one of the threads to PRIVATE. Here was I did.

1) I shut down instance 2 in the second node.
2) In the first node I run “alter database disable thread 2;”. The status become “CLOSED” and enabled become “DISABLED” for thread 2.
3) I tried “ALTER DATABASE ENABLE PRIVATE THREAD 2;”. it did not work.
4) I ran “ALTER DATABASE ENABLE PUBLIC THREAD 2;”. The enabled become “PUBLIC” but status still stay in “CLOSED”.

My questions are (without recreating redo logs):

How do I change a thread from a public to a private or from a private to public?

How to change status from “CLOSED” to “OPEN”?

Thanks a lot for your help,

Shirley