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
Dank für diesen nützlichen Artikel, wieder wie dies für diesen Artikel warten. apotheke
ReplyDeletehello... How does alter system would work when the db is refused to open ?
ReplyDeleteWe are finding solution to open a db.. But your solution is to open a db first !!!!
Sorry but could you please clearify your question more?
DeleteThis comment has been removed by the author.
ReplyDeleteA 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