grid: Error: Could not get parameter sid from registry

  

[root@node1xxxxxxxxxx ~]# dbaascli database list
DBAAS CLI version 19.1.1.1.0
Executing command database list
Retrieving dbs..
grid: Error: Could not get parameter sid from registry
An error occured during module execution.
Please refer to the log file for more information.
[root@node1xxxxxxxxxx ~]# 


[root@node1xxxxxxxxxx ~]# /var/opt/oracle/dbaascli/dbaascli database list
DBAAS CLI version 19.1.1.1.0
Executing command database list
Retrieving dbs..
.-------------------------------------------------------------------.
| Database List |
+----------+-----+------+------+--------+--------+------------------+
| DB Name | CPU | PGA | SGA | DATA | FRA | Nodelist |
+----------+-----+------+------+--------+--------+------------------+
| XXX122C2 | 28 | 4 GB | 5 GB | 304 GB | 85 GB | node1xxxxxxxxxx |
| | | | | | | node2xxxxxxxxxx |
+----------+-----+------+------+--------+--------+------------------+
| XXX121 | 28 | 4 GB | 5 GB | 0 GB | 0 GB | node1xxxxxxxxxx |
| | | | | | | node2xxxxxxxxxx |
+----------+-----+------+------+--------+--------+------------------+
| XXXX11 | 28 | 4 GB | 5 GB | 42 GB | 149 GB | node1xxxxxxxxxx |
| | | | | | | node2xxxxxxxxxx |
+----------+-----+------+------+--------+--------+------------------+
| XXXX111 | 28 | 4 GB | 5 GB | 0 GB | 0 GB | node2xxxxxxxxxx |
'----------+-----+------+------+--------+--------+------------------'
.---------------------------------------------------------------.
| Cluster Information |
+--------------------+-----------------------+------------------+
| Total CPU per Node | Total Memory per Node | Total Nodes |
+--------------------+-----------------------+------------------+
| 28 | 176 GB | node1xxxxxxxxxx |
| | | node2xxxxxxxxxx |
'--------------------+-----------------------+------------------' 


 Please add "sid=+ASM3" into /var/opt/oracle/creg/grid/grid.ini on node node1xxxxxxxxxx 
 
[root@node1xxxxxxxxxx ~]#   cat /var/opt/oracle/creg/grid/grid.ini
#################################################################
# This file is automatically generated by database as a service #
#                                                               #
# Do not edit contents in this file, Thanks!                    #
#                                                               #
#################################################################
acfs_oh_dir=/u02/app_acfs
acfs_scratch_dir=/scratch/acfsc2_dg1
acfs_vol_dir=/var/opt/oracle/dbaas_acfs
dbname=+ASM
exacm_gen1=yes
grid_wallet_loc=/u02/app/oracle/admin/grid/grid_wallet
oracle_home=/u01/app/12.2.0.1/grid
patch_level_ok=1
psu_patched=1
sid=+ASM3
status=enabled
version=12201
[root@node1xxxxxxxxxx ~]#
 
 
 
 [root@node1xxxxxxxxxx ~]# /var/opt/oracle/dbaascli/dbaascli database list
DBAAS CLI version 19.1.1.1.0
Executing command database list
Retrieving dbs..
.-------------------------------------------------------------------.
|                           Database List                           |
+----------+-----+------+------+--------+--------+------------------+
| DB Name  | CPU | PGA  | SGA  | DATA   | FRA    | Nodelist         |
+----------+-----+------+------+--------+--------+------------------+
| XXX122C2 |  28 | 4 GB | 5 GB | 304 GB | 85 GB  | node1xxxxxxxxxx |
|          |     |      |      |        |        | node2xxxxxxxxxx |
+----------+-----+------+------+--------+--------+------------------+
| XXX121  |  28 | 4 GB | 5 GB | 0 GB   | 0 GB   | node1xxxxxxxxxx |
|          |     |      |      |        |        | node2xxxxxxxxxx |
+----------+-----+------+------+--------+--------+------------------+
| XXXX11   |  28 | 4 GB | 5 GB | 42 GB  | 149 GB | node1xxxxxxxxxx |
|          |     |      |      |        |        | node2xxxxxxxxxx |
+----------+-----+------+------+--------+--------+------------------+
| XXXX111    |  28 | 4 GB | 5 GB | 0 GB   | 0 GB   | node2xxxxxxxxxx |
'----------+-----+------+------+--------+--------+------------------'
.---------------------------------------------------------------.
|                      Cluster Information                      |
+--------------------+-----------------------+------------------+
| Total CPU per Node | Total Memory per Node | Total Nodes      |
+--------------------+-----------------------+------------------+
|                 28 | 176 GB                | node1xxxxxxxxxx |
|                    |                       | node2xxxxxxxxxx |
'--------------------+-----------------------+------------------'

Oracle Exadata - dcli

This is cheat sheet for Exadata command.

Exadata host inventory:

cat x6.txt 
excc01 
excc02 
excc03 
excc04 


#This command is get status of OEM agent:
dcli -l oracle -g ~/x6.txt '/u01/app/agent13/agent_inst/bin/emctl status agent'

#Loop in shell -  to get load in all server:
date; for i in {1..4} ; do ssh root@excc0${i} -i id_rsa.pub -C "hostname; uptime" ; done