How to fix the Oracle error PRCS-01062: Failed to determine whether server pool {0} has any parents or children?

In this post, you’ll learn more about the Oracle ErrorPRCS-01062: Failed to determine whether server pool {0} has any parents or children with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PRCS-01062: Failed to determine whether server pool {0} has any parents or children

Reason for the Error PRCS-01062: Failed to determine whether server pool {0} has any parents or children

Cause: Failed to find parents or children of the given server pool. A likely cause is that current user may not have permissions to query profile of given server pool or profiles of other server pools whose PARENT_POOLS attribute contains this server pool name.

How to fix the Error PRCS-01062: Failed to determine whether server pool {0} has any parents or children ?

You can fix this error in Oracle by following the below steps

Action: If lack of permissions is the cause of this failure, then use ‘srvctl config serverpool -a’ command to find the current owner of the server pool and retry the query as that owner user. Otherwise, contact Oracle Support Services.