Database - RAC/Scalability (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center