Exadata has the following utilitities which facilitates centralized management across an Oracle Exadata System Software realm
dcli
cellcli
dbmcli
=> dcli :utility runs commands on multiple compute nodes and cells in parallel threads
=> cellcli :The Cell Control Command-Line Interface (CellCLI) utility is the command-line administration tool for Oracle Exadata Storage Server.
=> dbcli :utility is the command-line administration tool for configuring database servers,
dcli examples:
Assume dbs_group file contains compute nodes & cell_group file contains cell servers
cat dbs_group
db1comp0101.yg.com
db1comp0102.yg.com
db1comp0103.yg.com
db1comp0104.yg.com
db1comp0105.yg.com
db1comp0106.yg.com
db1comp0107.yg.com
db1comp0108.yg.com
cat cell_group
cell1server0101.yg.com
cell1server0102.yg.com
cell1server0103.yg.com
cell1server0104.yg.com
cell1server0105.yg.com
cell1server0106.yg.com
cell1server0107.yg.com
cell1server0108.yg.com
cell1server0109.yg.com
cell1server0110.yg.com
cell1server0111.yg.com
cell1server0112.yg.com
cell1server0113.yg.com
cell1server0114.yg.com
1. to run a command in all compute nodes
dcli -g <group_file> -l <user> <command>
dcli -g dbs_group -l oracle df -h
2. to run a command in all cell servers ( assume oracle has ssh key set for cellmonitor account)
dcli -g <group_file> -l <user> <command>
dcli -g cell_group -l cellmonitor cellcli -e list griddisk
3. to copy a file from one compute node to all computes
dcli -g dbs_group -l oracle -f <filename> -d <target_location>
dcli -g dbs_group -l oracle -f /tmp/p27681568_180000_Linux-x86-64.zip -d /u01/app/oracle/patch/
4. unzip the files
dcli -l oragrid -g dbs_group unzip -oq -d <target_directory> <patch_file>
dcli -l oragrid -g dbs_group unzip -oq -d /u01/app/oracle/patch/ /u01/app/oracle/patch/p27681568_180000_Linux-x86-64.zip
Dear Friends, The content in this blog are purely based on my own opinion ,it is not reflecting any of my current or previous employers materials or official documents. All my posts here are not warranted to be free of errors. Please use at your own risk and after thorough testing in your environment. If you feel that i am violating any of the company's policies or documents, kindly mail me at jeyaseelan.hi@gmail.com,I am happy to take out those content from this blog.
Subscribe to:
Post Comments (Atom)
-
We may not be able to disable the logtransport when the database is in maximum availabilty mode. We may get the below error DGMGRL...
-
Error Messages: We may get the following error messages while doing ASM operations ORA-15137: The ASM cluster is in rolling patch state....
-
MIRA - Multi Instance Redo Apply - 12cR2 onwards/18C With Oracle 12c Release 2, We can enable Multi Instance Redo apply ( MIR...
No comments:
Post a Comment