Thursday, March 17, 2022

Cluster Commands

Cluster Commands:

How to get a master node:
[root@oraclenode1 ~]# oclumon manage -get master
Master = oraclenode1

How to get a cluster name:
[oracle@oraclenode1 admin]$ cemutlo -n
orcl-clu

[oracle@oraclenode1 admin]$ olsnodes -c
orcl-clu

How to get scan details:
[oracle@oraclenode1 admin]$  srvctl config scan
SCAN name: orclscan, Network: 1
Subnet IPv4: 10.38.4.0/255.255.252.0/ens192, static
Subnet IPv6:
SCAN 1 IPv4 VIP: 10.38.4.126
SCAN VIP is enabled.
SCAN 2 IPv4 VIP: 10.38.4.154
SCAN VIP is enabled.
SCAN 3 IPv4 VIP: 10.38.4.162
SCAN VIP is enabled.

Create Password file inside DISK Group:
orapwd file='+DATA/TESTDB/PASSWORD/orapwTESTDB' dbuniquename='TESTDB'

Add password details to cluster database:
srvctl modify database -d TESTDB -pwfile '+DATA/TESTDB/PASSWORD/orapwTESTDB'

Regards,
Mallik

No comments:

Post a Comment

Automation Script | Archivelog Generation Hourly Monitoring

1. List out all the running databases and pic one database where we want to monitore the archive log generation from last 1 month. [oracle@o...