ITPub博客

首页 > 数据库 > Oracle > Service Created From root Login gives PRKO-2017 Upon Removal (文档 ID 833349.1)

Service Created From root Login gives PRKO-2017 Upon Removal (文档 ID 833349.1)

原创 Oracle 作者:ilovepicnic 时间:2015-07-14 10:42:30 0 删除 编辑

In this Document
  Symptoms
  Cause
  Solution
     Scalability RAC Community
  References


Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.5 - Release: 10.1 to 10.2
Information in this document applies to any platform.

Symptoms

You have incorrectly created a CRS resource service as root user using the following command:

#./srvctl add service -d orcl -s test123 -r orcl1
PRKH-1001 : HASContext Internal Error


Though it gives error, the command places entries into OCR as seen by crs_stat command output:

# ./crs_stat | grep -i test123
NAME=ora.orcl.test123.cs
NAME=ora.orcl.test123.orcl1.srv


Now when you try to remove the service in order to properly re-enter, you get the following error:

#srvctl remove service -d orcl -s test123
PRKO-2017 : Service test123 does not exist for database orcl

Cause

This issue is discussed in unpublished Bug 5881091.

In 11g and higher, the command will check the user permissions to ensure the SRVCTL and Oracle binaries are owned by the same user, and not root.

Note that for users other than root and Oracle binary owner, this issue is not seen and we see the following message:

$ srvctl add service -d orcl -s orcltest -r orcl1,orcl2
PRKH-1014 : Current user oracle123 is not the same as oracle owner oracle.



Also in 11g this bug is fixed and you will get the error message when you try to add the service as
root user:

# ./srvctl add service -d orcl -s test123 -r orcl1
PRKH-1014 : Current user root is not the same as oracle owner oracle of oracle home /oracle/asm/product/11.1.0/db_1.




Solution

This is fixed in 11.1 and higher

To remove the service, you will need to reinitialize the OCR and add all of the resources back again.

Please refer to Note 399482.1 How to recreate OCR/Voting disk accidentally deleted for details. 

Scalability RAC Community

To discuss this topic further with Oracle experts and industry peers, we encourage you to review, join or start a discussion in the My Oracle Support Scalability RAC Community.

References

NOTE:399482.1 - How to Recreate OCR/Voting Disk Accidentally Deleted


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/30204651/viewspace-1732533/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2015-04-13

  • 博文量
    42
  • 访问量
    92849