Wednesday 6 May 2015

ORA-01619: thread 1 is mounted by another instance

The following problem may appear when patching the Oracle Grid Infrastructure:

If so, the solution for the problem is the following. You need to find out which node of the RAC is failing to startup. Once you have found out, you need to run the following command on that node (probably in nomount/mount state, locally direct on the specific instance):

alter system set thread=4 scope=spfile sid=’orcl4';

The thread parameter should be one of the available threads in the cluster. You can find that information from the following query:

SQL> select thread#, sequence#, status from v$log;

Then you should  shutdown the instance and retry:

[oracle@dbnodt1 ~]$ srvctl start database -d dbtiso

5 comments:

  1. Dank für diesen nützlichen Artikel, wieder wie dies für diesen Artikel warten. apotheke

    ReplyDelete
  2. hello... How does alter system would work when the db is refused to open ?
    We are finding solution to open a db.. But your solution is to open a db first !!!!

    ReplyDelete
    Replies
    1. Sorry but could you please clearify your question more?

      Delete
  3. This comment has been removed by the author.

    ReplyDelete
  4. A very delightful article that you have shared here.Accredited DBA Your blog is a valuable and engaging article for us, and also I will share it with my companions who need this info. Thankful to you for sharing an article like this.

    ReplyDelete