Category: GI and RAC

Oracle Real Application Clusters Component Showing “OPTION OFF”  

After Oracle database migrated from Non-RAC to RAC environment, the oracle component “Oracle Real Application Clusters” shows “OPTION OFF”.

SQL>  select COMP_NAME, VERSION,STATUS,SCHEMA from dba_registry;

COMP_NAME                                VERSION                        STATUS                                       SCHEMA
---------------------------------------- ------------------------------ -------------------------------------------- --------------------
...
..
.
Oracle Database Catalog Views            12.1.0.2.0                     VALID                                        SYS
Oracle Database Packages and Types       12.1.0.2.0                     VALID                                        SYS
JServer JAVA Virtual Machine             12.1.0.2.0                     VALID                                        SYS
Oracle XDK                               12.1.0.2.0                     VALID                                        SYS
Oracle Database Java Packages            12.1.0.2.0                     VALID                                        SYS
OLAP Analytic Workspace                  12.1.0.2.0                     VALID                                        SYS
Oracle OLAP API                          12.1.0.2.0                     VALID                                        SYS
Oracle Real Application Clusters         12.1.0.2.0                     OPTION OFF                                        SYS

15 rows selected.

SOLUTION

Verify Real Application Clusters enabled at binary level

$ ar -t $ORACLE_HOME/rdbms/lib/libknlopt.a|grep kcsm.o
kcsm.o

Returning “kcsm.o” indicates RAC binary has been enabled.

run script to recreate RAC associated views and validates rac registry 

SQL> @?/rdbms/admin/catclust.sql

Verify the component status by executing the query on dba_registry

SQL>  select COMP_NAME, VERSION,STATUS,SCHEMA from dba_registry;

COMP_NAME                                VERSION                        STATUS                                       SCHEMA
---------------------------------------- ------------------------------ -------------------------------------------- --------------------
...
..
.
Oracle Database Catalog Views            12.1.0.2.0                     VALID                                        SYS
Oracle Database Packages and Types       12.1.0.2.0                     VALID                                        SYS
JServer JAVA Virtual Machine             12.1.0.2.0                     VALID                                        SYS
Oracle XDK                               12.1.0.2.0                     VALID                                        SYS
Oracle Database Java Packages            12.1.0.2.0                     VALID                                        SYS
OLAP Analytic Workspace                  12.1.0.2.0                     VALID                                        SYS
Oracle OLAP API                          12.1.0.2.0                     VALID                                        SYS
Oracle Real Application Clusters         12.1.0.2.0                     VALID                                        SYS

15 rows selected.

Failed to Start Listener with TNS-01192 Error

In 19c GI environment, local listeners failed to start up with following errors:

[grid@racnode1 $ srvctl start listener -node racnode1
PRCR-1013 : Failed to start resource ora.LISTENER.lsnr
PRCR-1064 : Failed to start resource ora.LISTENER.lsnr on node racnode1
CRS-5016: Process "/u01/app/19.0.0.0/grid/bin/lsnrctl" spawned by agent "ORAAGENT" for action "start" failed: details at "(:CLSN00010:)" in "/u01/app/grid/diag/crs/racnode1/crs/trace/crsd_oraagent_grid.trc"
CRS-5016: Process "/u01/app/19.0.0.0/grid/bin/lsnrctl" spawned by agent "ORAAGENT" for action "start" failed: details at "(:CLSN00010:)" in "/u01/app/grid/diag/crs/racnode1/crs/trace/crsd_oraagent_grid.trc"
CRS-2674: Start of 'ora.LISTENER.lsnr' on 'racnode1' failed

Further check “crsd_oraagent_grid.trc” with following errors:

Starting /u01/app/19.0.0.0/grid/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/app/19.0.0.0/grid/network/admin/listener.ora
Log messages written to /u01/app/grid/diag/tnslsnr/racnode1/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
TNS-01192: Missing SID_LIST_ value left of equation for SID description in LISTENER.ORA

Listener failed to start. See the error message(s) above...

Subscribe to get access

Read more of this content when you subscribe today.

Sorry! This product is not available for purchase at this time.

How to Create Password File on ASM diskgroup

1) Make sure compatible.asm at least 12.1.

SQL> SELECT NAME,VALUE,GROUP_NUMBER FROM V$ASM_ATTRIBUTE where name like '%compatible%'

NAME                                     VALUE                                                                  GROUP_NUMBER
---------------------------------------- ---------------------------------------------------------------------- ------------
compatible.asm                           19.0.0.0.0                                                                        1
compatible.rdbms                         11.2.0.4                                                                          1
compatible.advm                          19.0.0.0                                                                          1
compatible.asm                           19.0.0.0.0                                                                        2
compatible.rdbms                         11.2.0.4.0                                                                        2
compatible.advm                          19.0.0.0.0                                                                        2

6 rows selected.

2) Create password by using ‘pwcreate’.

ASMCMD> pwcreate --dbuniquename TESTDB '+datac1/TESTDB/password/pwdtestdb'
Enter password: *********
ASMCMD>

3) Verify the password by :

$ crsctl stat res ora.testdb.db -f | grep PWFILE
PWFILE=+DATAC1/TESTDB/PASSWORD/pwdtestdb

For 11.2, there is no support for this feature.

$ crsctl stat res ora.testdb.db -f | grep PWFILE
PWFILE=

Please note:

Create new password file. Need after database and instances are added into CRS by ‘srvctl add database’ and ‘srvctl add instance’. Otherwise the following errors will occur:

OPW-00021: Failed to retrieve DB password file location from the CRS resource
ASMCMD-9454: could not create new password file

ASMCMD> pwcreate –dbuniquename RAC19DBA +DATA Enter password: **

What Ports are Used by Oracle ONS Resource

$ crsctl stat res ora.ons -p

NAME=ora.ons
TYPE=ora.ons.type
ACL=owner:grid:rwx,pgrp:oinstall:r-x,other::r--
ACTIONS=
ACTION_SCRIPT=
ACTION_TIMEOUT=60
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
ALLOW_PUBLISH=
ALLOW_PUBLISH_NODES=1
ALLOW_UNSECURE_SUBSCRIBER=yes
AUTO_START=always
CHECK_INTERVAL=60
CHECK_TIMEOUT=0
CLEAN_TIMEOUT=60
CSS_CRITICAL=no
DEBUG_COMP=
DEBUG_FILE=
DELETE_TIMEOUT=60
DESCRIPTION=Oracle ONS resource
EM_PORT=2016
ENABLED=1
GEN_LAST_STARTED=racnode1_1626153918
GEN_ORACLE_CONFIG_HOME=
GEN_ORACLE_CONFIG_HOME@SERVERNAME(racnode1)=/u01/app/19.0.0.0/grid
GEN_ORACLE_CONFIG_HOME@SERVERNAME(racnode2)=/u01/app/19.0.0.0/grid
GEN_ORACLE_CONFIG_HOME@SERVERNAME(racnode3)=/u01/app/19.0.0.0/grid
GEN_ORACLE_CONFIG_HOME@SERVERNAME(racnode4)=/u01/app/19.0.0.0/grid
IGNORE_TARGET_ON_FAILURE=no
INSTANCE_FAILOVER=1
INTERMEDIATE_TIMEOUT=0
LOAD=1
LOCAL_PORT=6100
LOGGING_LEVEL=1
LOG_COMP=
LOG_FILE=
MEMBER_ID=0
MODIFY_TIMEOUT=60
NLS_LANG=
OFFLINE_CHECK_INTERVAL=0
ONS_CLIENTCLUSTER_NAME=
REMOTE_HOSTS=
REMOTE_PORT=6200
RESOURCE_GROUP=
RESTART_ATTEMPTS=3
RESTART_DELAY=0
SCRIPT_TIMEOUT=60
SERVER_CATEGORY=ora.hub.category
START_CONCURRENCY=0
START_DEPENDENCIES=hard(ora.net1.network) pullup(ora.net1.network)
START_TIMEOUT=300
STOP_CONCURRENCY=0
STOP_DEPENDENCIES=hard(intermediate:ora.net1.network)
STOP_TIMEOUT=300
TARGET_DEFAULT=default
TYPE_VERSION=2.1
UPTIME_THRESHOLD=1d
USER_WORKLOAD=no
USE_EVM=true
USE_SSL=1
USR_ORA_ENV=
WORKLOAD_CPU=0
WORKLOAD_CPU_CAP=0
WORKLOAD_MEMORY_MAX=0
WORKLOAD_MEMORY_TARGET=0

How to Know RAC Instance Disabled ?

The client RAC database has 4 nodes, but due to the resource and load reasons, two of the 4 instances were disabled by the following command :

$ srvctl disable instance -db TESTDB -instance TESTDB2, TESTDB4

But after a period of time, the client forgot which instances have been disabled exactly.

Here is the right way to report a RAC instance is disabled or not.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe