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=

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.

$ srvctl status instance -d TESTDB -i TESTDB4 -f
Instance TESTDB4  is disabled on node racnode4
Instance TESTDB4  is not running on node racnode4

How to Restrict Parallel Server Processes Running on Specific Oracle RAC Nodes

For this SQL, I want all the parallel processes running on this node or those nodes only.

All Oracle DBA knows, by default, the parallel server processes spawned to execute a SQL statement can operate on any or all Oracle RAC nodes in the cluster.

For big indexes rebuilding , a client wants all the parallel server processes running on specific node(s).

There are two easy ways to achieve this without bouncing database required.

Subscribe to get access

Read more of this content when you subscribe today.

“PRVF-4037 : CRS is not installed on any of the nodes” when installing 11.2 RAC in 19c Grid Infrastructure

While installing Oracle Database 11.2.0.4 RAC in 19c GI, the following errors occur:

INFO: Verification Result for Node:racnode1
WARNING: Result values are not available for this verification task
INFO: Error Message:PRVF-4037 : CRS is not installed on any of the nodes
INFO: Cause: Could not identify a CRS installation on any node.
INFO: Action: Ensure that CRS is installed on all the nodes participating in the operation.
INFO: ***
INFO: Node Application Existence: This test checks the existence of Node Applications on the system.
INFO: Severity:CRITICAL
INFO: OverallStatus:OPERATION_FAILED
INFO: -----------------------------------------------

Subscribe to get access

Read more of this content when you subscribe today.

Then rerun the installation successfully.

[oracle@racnode1 ~]$ /tmp/database/runInstaller -silent -responseFile /home/oracle/11204_install_rac.rsp -showProgress 
...
..
.
………………………………………….. 9% Done.
Prepare successful.
Copy files in progress.
………………………………………….. 15% Done.
………………………………………….. 20% Done.
………………………………………….. 25% Done.
………………………………………….. 30% Done.
………………………………………….. 36% Done.
………………………………………….. 41% Done.
………………………………………….. 46% Done.
………………………………………….. 51% Done.
………………………………………….. 56% Done.
Copy files successful.
……….
Link binaries in progress.
Link binaries successful.
………………………………………….. 77% Done.
Setup files in progress.
………………………………………….. 94% Done.
Setup files successful.