Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

disable thread

RobeenApr 28 2018 — edited May 1 2018

Oracle 11.2.0.4

RHEL 6

Hi Team,

i am getting error after restoring a database which was [reviously RAC.

SQL> alter database disable thread 2;

alter database disable thread 2

*

ERROR at line 1:

ORA-01615: instance CI2 (thread 2) is mounted - cannot disable

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

   THREAD# STATUS ENABLED

---------- ------ --------

         2 OPEN   PRIVATE

SQL> select * from v$Log;

How can I make thread 2 as public thread?

Regards,

Joe

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 27 2018
Added on Apr 28 2018
2 comments
2,281 views