CRS-09118: Grid Infrastructure Management Repository connection error

How to Resolve CRS-09118: Grid Infrastructure Management Repository connection error 12cR2 RAC


crsctl query catlog
CRS-09118: Grid Infrastructure Management Repository connection error

The crsctl Utility is not able to comunicate with Management database

checking repository database configuration

$ srvctl config mgmtdb
Database unique name: _mgmtdb
Database name:
Oracle home:
Oracle user: oracle
Spfile: +DATA_MGMT/_MGMTDB/PARAMETERFILE/spfile.269.946921407
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Type: Management
PDB name: GIMR_DSCREP_10
PDB service: GIMR_DSCREP_10

Cluster name: RAC01
Database instance: -MGMTDB

check if PDB service is registered with MGMTLSNR

lsnrctl status MGMTLSNR | grep -i GIMR_DSCREP_10

As you can see the Service is not registered with Listener

checking repository database for PDB service existance

Login in management database and execute following queries

$ export ORACLE_HOME=/u01/app/12.2.0.2/grid
$ export PATH=$PATH:$ORACLE_HOME/bin
$ export ORACLE_SID=-MGMTDB
$ sqlplus "/as sysdba"

SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL>
SQL> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 GIMR_DSCREP_10                 MOUNTED

SQL> alter session set container=GIMR_DSCREP_10;
Session altered.
SQL> select name from dba_services;
NAME
----------------------------------------------------------------
gimr_dscrep_10

-- As you can see Service is Present

Let's start the Service

SQL> exec dbms_service.start_service('gimr_dscrep_10')

$ lsnrctl status MGMTLSNR | grep -i GIMR_DSCREP_10

Service "gimr_dscrep_10" has 1 instance(s).

Now the listener is listining for gimr_dscrep_10 Service and Connection is successfull




No comments:

Post a Comment