In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-25 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)05/31 Report--
Editor to share with you how to report an error in a new instance of Oracle 11g R2 RAC dbca. I believe most people don't know much about it, so share this article for your reference. I hope you will learn a lot after reading this article. Let's learn about it together.
I asked http://bbs.51cto.com/thread-1167548-1.html about this oracle problem on the forum, and finally found a way to solve it, and then recorded it on my blog.
Environment: CentOS6.5 64-bit, Oracle 11g R2 11.2.0.1.0
Phenomenon: in the oracle rac production environment, there is already an instance in normal use, and there is a need to build another instance.
In the process of creating a new instance, the final step is as follows:
[Thread-829] [2015-09-09 11 DatabaseImpl.createStopDep:3579] [DatabaseImpl.createStopDep:3579] stop dependencies = hard (intermediate:ora.asm,shutdown:ora.DG_DATA.dg)
[Thread-829] [2015-09-09 11 InstanceStepOPS.executeImpl:952] PRCR-1006: Failed to add resource ora.proxy.db for null
PRCR-1071: Failed to register or update resource ora.proxy.db
CRS-2566: User 'oracle' does not have sufficient permissions to operate on resource' ora.LISTENER.lsnr', which is part of the dependency specification.
[Thread-829] [2015-09-09 11 BasicStep.configureSettings:304] messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@30394ffa
[Thread-829] [2015-09-09 11 BasicStep.configureSettings:304] messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@30394ffa
Oracle.sysman.assistants.util.step.StepExecutionException: PRCR-1006: Failed to add resource ora.proxy.db for null
PRCR-1071: Failed to register or update resource ora.proxy.db
CRS-2566: User 'oracle' does not have sufficient permissions to operate on resource' ora.LISTENER.lsnr', which is part of the dependency specification.
At oracle.sysman.assistants.dbca.backend.InstanceStepOPS.executeImpl (InstanceStepOPS.java:953)
At oracle.sysman.assistants.util.step.BasicStep.execute (BasicStep.java:210)
At oracle.sysman.assistants.util.step.BasicStep.callStep (BasicStep.java:251)
At oracle.sysman.assistants.dbca.backend.DBEntryStep.executeImpl (DBEntryStep.java:229)
At oracle.sysman.assistants.util.step.BasicStep.execute (BasicStep.java:210)
At oracle.sysman.assistants.util.step.Step.execute (Step.java:140)
At oracle.sysman.assistants.util.step.StepContext$ModeRunner.run (StepContext.java:2667)
At java.lang.Thread.run (Thread.java:595)
Solution:
1. Try to manually register the database resource with the oracle user, srvctl add database-d proxy-o $ORACLE_HOME, indicating that Server pool has been registered.
two。 Delete using root users, crsctl delete serverpool ora.proxy
3. Manually register the database resource using the oracle user, srvctl add database-d proxy-o $ORACLE_HOME
4. The above execution result indicates the permission problem, so check the error resource details, crsctl stat res ora.LISTENER.lsnr-p
5. Use root user to manually modify resource permissions, crsctl modify resource "ora.LISTENER.lsnr"-attr "ACL='owner:grid:rwx,pgrp:oinstall:r-x,other::r--'"
The following is a screenshot of the resolution process:
Finally, the problem is solved. The cause of the problem should be that you don't pay attention to the user during the operation and use root to operate the related operations of grid.
The above is all the contents of the article "how to report an error in a new instance of Oracle 11g R2 RAC dbca". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.