Unable To 'add Service... -pdbname' to GDS catalog database Due To ORA-01031: Insufficient Privileges (Doc ID 2712913.1)

Last updated on APRIL 17, 2023

Applies to:

Goal

You were trying to setup a global data service for your primary and ADG physical standby 19c databases.

You did the following to create the GDS configuration.

add gsm -gsm gsm1 -listener <port#> -catalog <catalog db host>:1521:GDSCAT
start gsm -gsm gsm1
add gdspool -gdspool reporting

add database -connect <primary cdb host>:1521/<primary cdb service>.world -gdspool reporting
add database -connect <standby cdb host>:1521/<standby cdb service>.world -gdspool reporting

You can add this service:

add service -gdspool reporting -service rpt_svc -preferred_all

But after starting that service and connecting to it that connects to the container DB. You want the service to connect to the standby PDB. So you tried adding -pdbname option as below:

GDSCTL> add service -gdspool reporting -service pdb_rpt -preferred_all -pdbname <standby pdb db_unique_name>
GSM Warnings:
cs18vx:ORA-01031: insufficient privileges
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 1850
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 1634
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 606
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 1610
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 1813
ORA-06512: at line 1 (ngsmoci_execute)

Solution

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