search

freddenis / oracle-scripts

Cool scripts for Oracle I use in my everyday life
GNU General Public License v3.0
95 stars 56 forks source link

On the Service Output Table add Pluggable Database Column #11

Closed ghost closed 2 years ago

ghost commented 4 years ago

For rac-status.sh script:

Add Column PDB to display Pluggable Database for Service and if you filter Output on ServiceName also show DB Name for each column.

|CDB|PDB|Service|Nodes.....

freddenis commented 4 years ago

Hi,

rac-status is based on information from CRS/GI. CRS/GI has no knowledge about what is a PBD so this cannot be done as of now.

But ... GI 20c is supposed to include this as a new feature so as soon as GI 20c is available, I will have a look to implement this.

Regards,

Fred

freddenis commented 2 years ago

For rac-status.sh script:

Add Column PDB to display Pluggable Database for Service and if you filter Output on ServiceName also show DB Name for each column.

|CDB|PDB|Service|Nodes.....

This has been implemented.