how to fix crsctl displays duplicate entries for db/instance?
Hi all,
I am curious if anyone has come across the below situation and if they have a better fix - or more information on the situation. I included my fix below, but it involves needing to remove a database from the cluster.
I recently discovered an odd situation where some of my databases are showing duplicate entries. (see below)
This first command identifies how many entries each SID has and the second is a more complete set of output for one of the culprits:
$ORACLE_HOME/bin/crsctl stat res -f -w "((TYPE = ora.database.type) AND (TARGET_SERVER = server01 ))"| egrep -i 'GEN_USR_ORA_INST_NAME=|DB_UNIQUE_NAME='|cut -f2 -d= |sort | uniq --count | sort -u