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
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"
$ 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
---------- ------------------------------ ---------- ----------
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
----------------------------------------------------------------
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