My Oracle Support Banner

Global Service Manager Catalog Creation Throws Error GSM-45029 ora-1422 (Doc ID 2488286.1)

Last updated on FEBRUARY 01, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Goal

When trying to create catalog from gdsctl, it throws the below error:

$ gdsctl
GDSCTL: Version 12.1.0.2.0 - Production on Tue Oct 02 13:58:15 EDT 2018

Copyright (c) 2011, 2014, Oracle. All rights reserved.

Welcome to GDSCTL, type "help" for information.

Current GSM is set to GSMORA
GDSCTL>create catalog -database <db_name> -user gsm_admin
"gsm_admin" password:
GSM-45029: SQL error
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_CLOUDADMIN", line 1722
ORA-06512: at line 1

GDSCTL>add gsm -gsm <gsm name> -listener 1521 -catalog <connect identifier for the GDS catalog database>
"gsmcatuser" password:
GSM-45029: SQL error
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_UTILITY", line 786
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_CLOUDADMIN", line 1229
ORA-06512: at line 1

GDSCTL>start gsm -gsm <gsm name>
GSM-45054: GSM error
NET-40002: GSM endpoint not found in GSM.ora
GDSCTL>set gsm -gsm <gsm_name>
GDSCTL>start gsm -gsm <gsm_name>
GSM-45054: GSM error
NET-40002: GSM endpoint not found in GSM.ora
GDSCTL>services
 

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.