My Oracle Support Banner

Oracle Sharding Service Creation failed with PRKO-3163 (Doc ID 2674148.1)

Last updated on AUGUST 24, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 19.1 BETA to 20.1 Preview [Release 19 to 20.0]
Information in this document applies to any platform.

Goal

Creating global service in sharding database failed with the following errors:

GDSCTL> add service -service <service name> -role primary
GSM Warnings:
primary_shardgroup shard1:ORA-45540: Call to SRVCTL failed with status 1, errors: PRKO-3163 : Options \'-update\', \'-preferred\', \'-available\', \'-serverpool\' and \'-cardinality\' cannot be used to add service <service name> for single instance database shard1
.
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 1850
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 1786
ORA-06512: at line 1 (ngsmoci_execute)
primary_shardgroup shard2:ORA-45540: Call to SRVCTL failed with status 1, errors: PRKO-3163 : Options \'-update\', \'-preferred\', \'-available\', \'-serverpool\' and \'-cardinality\' cannot be used to add service <service name> for single instance database shard2
.
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 1850
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 1786
ORA-06512: at line 1 (ngsmoci_execute)

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.