MySQL Database Utilities

 

MySQL Utilities Cheatsheets, for MySQL DBAs

 

 

Advertisements
Posted in DBA-RAC-Exadata Tools

AppsDBA Blog

 

Oracle GoldenGate Interview Questions/FAQs http://satya-dba.blogspot.com/2012/10/goldengate-interview-questions-faqs.html
Oracle Data Guard Interview Questions/FAQs http://satya-dba.blogspot.com/2012/10/dataguard-interview-questions-faqs.html
Oracle Export/Import – Data Pump Interview Questions/FAQs http://satya-dba.blogspot.com/2012/10/exportimport-data-pump-interview.html
Oracle Performance related interview Questions/FAQs http://satya-dba.blogspot.com/2012/10/oracle-performance-related-interview.html
Oracle ASM Interview Questions/FAQs http://satya-dba.blogspot.com/2012/10/oracle-asm-interview-questions-faqs.html
Oracle RMAN Interview Questions/FAQs http://satya-dba.blogspot.com/2012/10/oracle-rman-interview-questions-faqs.html
Oracle PL/SQL Interview Questions/FAQs http://satya-dba.blogspot.com/2012/10/oracle-plsql-interview-questionsfaqs.html
UNIX Interview Questions/FAQs for Oracle DBAs http://satya-dba.blogspot.com/2012/10/unix-interview-questions-for-oracle-dbas.html
Oracle DBA Interview Questions/FAQs – Part1 http://satya-dba.blogspot.com/2012/10/oracle-dba-interview-questions-faqs.html
Oracle DBA Interview Questions/FAQs – Part2 http://satya-dba.blogspot.com/2012/10/oracle-dba-interview-questionsfaqs.html
Oracle DBA Interview Questions/FAQs – Part3 http://satya-dba.blogspot.com/2012/10/dba-oracle-interview-questions-faqs.html
Oracle DBA Interview Questions/FAQs – Part4 http://satya-dba.blogspot.com/2012/10/oracle-dba-interview-questions-faqs_22.html

 

 

 

Posted in DBA-RAC-Exadata Tools | Tagged , , , , , , , | 6 Comments

Apache Cassandra Blog

Cassandra Database http://satya-cassandra.blogspot.com/2013/02/cassandra-distributed-database-dbms.html

 

Cassandra New Features http://satya-cassandra.blogspot.com/2013/03/cassandra-new-features-in-apache.html

 

Cassandra cli (Command Line Interface) http://satya-cassandra.blogspot.com/2013/03/apache-cassandra-cli-cassandra-cli.html

 

Cassandra Terms/Abbreviations http://satya-cassandra.blogspot.com/2013/03/cassandra-terms-abbreviations.html

 

List of NoSQL Databases http://satya-cassandra.blogspot.com/2013/03/list-of-nosql-databases-list-nosql.html

 

Apache Cassandra nodetool http://satya-cassandra.blogspot.com/2013/03/nodetool-cassandra-node-tool.html

 

CQL (Cassandra Query Language)

 

Posted in BigData | Tagged , , , , , , , , | Leave a comment

cluvfy commands

cluvfy commands

CLUVFY: Cluster Verification Utility

cluvfy [-help] or cluvfy -h
cluvfy stage {-pre|-post} stage_name stage_specific_options [-verbose]
cluvfy stage -post hwos -n node_list [-verbose]
./runcluvfy.sh stage -post hwos -n node1,node2 -verbose
cluvfy stage -pre cfs -n node_list [-verbose]
cluvfy stage -post cfs -n node_list [-verbose]
cluvfy stage -pre crsinst -n node_list [-c ocr_location] [-r {10gR1|10gR2|11gR1|11gR2}] [-q voting_disk] [-osdba osdba_group]
[-orainv orainventory_group] [-verbose]
cluvfy stage -pre crsinst -n node1,node2,node3
./runcluvfy.sh stage -pre crsinst -n all -verbose
cluvfy stage -post crsinst -n node_list [-verbose]
cluvfy stage -pre dbinst -n node_list [-r {10gR1|10gR2|11gR1|11gR2}] [-osdba osdba_group] [-orainv orainventory_group] [-verbose]
cluvfy stage -pre dbcfg -n node_list -d oracle_home [-verbose]
====================================
cluvfy comp component_name component_specific_options [-verbose]
cluvfy comp nodereach -n node_list [-srcnode node] [-verbose]
cluvfy comp nodecon -n node_list [-i interface_list] [-verbose]
cluvfy comp nodecon -n node1,node2,node3 –i eth0 -verbose
cluvfy comp nodeapp [-n node_list] [-verbose]
cluvfy comp peer [-refnode node] -n node_list [-r {10gR1|10gR2|11gR1|11gR2}] [-orainv orainventory_group] [-osdba osdba_group] [-verbose]
cluvfy comp peer -n node1,node2 -r 10gR2 -verbose
cluvfy comp crs [-n node_list] [-verbose]
cluvfy comp cfs [-n node_list] -f file_system [-verbose]
cluvfy comp cfs -f /oradbshare –n all -verbose
cluvfy comp ocr [-n node_list] [-verbose]
cluvfy comp clu -n node_list -verbose
cluvfy comp clumgr [-n node_list] [-verbose]
cluvfy comp sys [-n node_list] -p {crs|database} [-r {10gR1|10gR2|11gR1|11gR2}] [-osdba osdba_group] [-orainv orainventory_group] [-verbose]
cluvfy comp sys -n node1,node2 -p crs -verbose
cluvfy comp admprv [-n node_list] [-verbose] |-o user_equiv [-sshonly] |-o crs_inst [-orainv orainventory_group] |-o db_inst [-orainv orainventory_group] [-osdba osdba_group] |-o db_config -d oracle_home
cluvfy comp ssa [-n node_list] [-s storageID_list] [-verbose]
cluvfy comp space [-n node_list] -l storage_location -z disk_space{B|K|M|G} [-verbose]
cluvfy comp space -n all -l /home/dbadmin/products –z 2G -verbose
Posted in DBA-RAC-Exadata Tools | Tagged , , , | Leave a comment

Apache Hadoop Blog

Apache Hadoop means http://satya-hadoop.blogspot.com/2013/03/what-is-hadoop-nosql-bigdata-database.html

Apache Hadoop Terms/Abbreviations/Acronyms/Glossary http://satya-hadoop.blogspot.com/2013/03/apache-hadoop-terms-abbreviations.html

Hadoop Training in India (Bangalore/Hyderabad) with contact information http://satya-hadoop.blogspot.com/2013/03/hadoop-training-institutes-in-india.html

Hadoop Commercial Distributions http://satya-hadoop.blogspot.com/2013/04/hadoop-distributions-apache-cloudera.html

Hadoop Commands http://satya-hadoop.blogspot.com/2013/04/hadoop-commands-command-line-interface.html

Different Versions  of Hadoop http://satya-hadoop.blogspot.com/2013/04/apache-hadoop-versions-alpha-beta-hadoop.html

Hadoop Certifications http://satya-hadoop.blogspot.com/2013/04/hadoop-certifications-cloudera.html

Hadoop New Features
HDFS (Hadoop Distributed File System)
MapReduce
Hadoop Interview Questions

List of NoSQL Databases http://satya-cassandra.blogspot.com/2013/03/list-of-nosql-databases-list-nosql.html

Posted in BigData | Tagged , , , , , , , , , , | 3 Comments

DBA Blog

What’s New in Oracle 9i Release 1/2 http://satya-dba.blogspot.com/2009/01/whats-new-in-9i.html
9irel1 9irel2

What’s New in Oracle 10g Release 1/2 http://satya-dba.blogspot.com/2009/01/whats-new-in-10g.html
10grel1 10grel2

What’s New in Oracle 11g Release 1 http://satya-dba.blogspot.com/2009/01/whats-new-in-11g.html
11grel

What’s New in Oracle 11g Release 2 http://satya-dba.blogspot.com/2009/09/whats-new-in-11g-release-2.html
11grel2

What’s New in Oracle 12c Release 1 http://satya-dba.blogspot.com/2012/10/new-features-in-oracle-database-12c.html

Oracle 12c http://satya-dba.blogspot.com/2011/07/oracle12c.html

What’s New in Oracle 12c Release 2 http://satya-dba.blogspot.com/2016/10/new-features-in-oracle-12c-release-2.html

Oracle Solaris 11 http://satya-dba.blogspot.com/2011/12/oracle-solaris-11-cloud-os.html

Startup/Shutdown of Oracle databases http://satya-dba.blogspot.com/2009/01/startupshutdown-options.html

RDA in Oracle http://satya-dba.blogspot.com/2009/01/oracle-remote-diagnostic-agent-rda-rda.html

NID utility in Oracle http://satya-dba.blogspot.com/2009/01/nid-utility.html

RMAN (Recovery Manager) in Oracle http://satya-dba.blogspot.com/2009/01/rman-was-first-introduced-in-oracle8.html
rman_commands

FRA (Flash/Fast Recovery Area) in Oracle http://satya-dba.blogspot.com/2009/02/flash-recovery-area.html

Recyclebin in Oracle http://satya-dba.blogspot.com/2009/02/recycle-bin.html

Flashback in Oracle http://satya-dba.blogspot.com/2009/02/flashback.html

Flashback Query in Oracle http://satya-dba.blogspot.com/2009/02/flashback-query-oracle-flashback-query.html

Profiles in Oracle http://satya-dba.blogspot.com/2009/02/profiles.html

Data Dictionary views in Oracle http://satya-dba.blogspot.com/2009/02/data-dictionary-views.html

Data Dictionary views Vs V$views in Oracle http://satya-dba.blogspot.com/2009/02/views.html

Auditing in Oracle http://satya-dba.blogspot.com/2009/05/auditing-in-oracle.html

Export & Import in Oracle http://satya-dba.blogspot.com/2009/05/export-import.html
exp imp

Datapump Export Import in Oracle http://satya-dba.blogspot.com/2009/05/datapump.html
expdp impdp

Datapump in Oracle http://satya-dba.blogspot.com/2009/06/datapump-in-oracle.html

SQL*Loader in Oracle http://satya-dba.blogspot.com/2009/06/sqlloader.html

Temporary Tablespace in Oracle http://satya-dba.blogspot.com/2009/07/temporary-tablespace-in-oracle.html

Temporary Tablespace groups in Oracle http://satya-dba.blogspot.com/2009/07/temporary-tablespace-group.html

Materialized views in Oracle http://satya-dba.blogspot.com/2009/07/materialized-views-oracle.html

Partitioning in Oracle http://satya-dba.blogspot.com/2009/07/partitioning-in-oracle.html
list_partitioning range_partitioning hash_partitioning composite_partitioning

Rollback Segments in Oracle http://satya-dba.blogspot.com/2009/08/rollback-segments-in-oracle.html

Statspack in Oracle http://satya-dba.blogspot.com/2009/08/statspack-in-oracle.html

Background Processes in Oracle http://satya-dba.blogspot.com/2009/08/background-processes-in-oracle.html

Undo Tablespace in Oracle http://satya-dba.blogspot.com/2009/09/undo-tablespace-undo-management.html
undo_advisor

Password file in Oracle http://satya-dba.blogspot.com/2009/11/password-file-in-oracle.html

lsnrctl commands in Oracle http://satya-dba.blogspot.com/2010/01/lsnrctl-commands.html

emctl commands in Oracle http://satya-dba.blogspot.com/2010/01/emctl-commands.html

TTS (Transportable Tablespaces) in Oracle http://satya-dba.blogspot.com/2010/01/oracle-transportable-tablespaces-tts.html

asmcmd in Oracle http://satya-dba.blogspot.com/2010/02/asmcmd-10g-11g.html
lsct lsdg mkalias mkdir rm rmalias cp md_backup md_restore lsdsk remap startup shutdown dsset dsget lsop mkusr lsusr rmusr mkgrp lsgrp rmgrp grpmod groups chmod chown mkdg chdg dropdg chkdg mount umount offline online rebal iostat setattr lsattr mktmpl lstmpl chtmpl rmtmpl volcreate volinfo voldelete voldisable volenable volresize volset volstat

ASM in Oracle http://satya-dba.blogspot.com/2010/03/automatic-storage-management-asm-10g.html
asm_instance asm_diskgroups startup shutdown CREATE_DISKGROUP listing_diskgroups DROP_DISKGROUP ALTER_DISKGROUP ADD_DISK listing_disks listing_client_dbs DROP_DISK RESIZE ONLINE OFFLINE MOUNT DISMOUNT SET_ATTRIBUTE listing_attributes REBALANCE IO_statistics ADD_DIRECTORY RENAME_DIRECTORY DROP_DIRECTORY DROP_FILE ADD_ALIAS RENAME_ALIAS DELETE_ALIAS ADD_TEMPLATE ALTER_TEMPLATE listing_templates DROP_TEMPLATE CHECK ADD_USERGROUP listing_ASM_usergroups DROP_USERGROUP MODIFY_USERGROUP ADD_USER listing_ASM_users listing_ASM_usergroups_members DROP_USER SET_PERMISSION SET_OWNERSHIP ADD_VOLUME listing_volume listing_volume_statistics DROP_VOLUME RESIZE_VOLUME DISABLE_VOLUME ENABLE_VOLUME MODIFY_VOLUME listing_current_operations

RMAN (Recovery Manager) Commands in Oracle http://satya-dba.blogspot.com/2010/04/rman-commands.html
rman_exe connect create_catalog drop_catalog resync_catalog upgrade_catalog import_catalog register unregister grant revoke reset_database startup shutdown alter_database show configure set backup list report change crosscheck sql restore recover delete drop_database duplicate switch catalog allocate release_channel blockrecover advise_failure repair_failure validate spool run create_script print_script replace_script execute_script delete_script flashback_database transportable_tablespace convert exit_quit send host

Statistics in Oracle http://satya-dba.blogspot.com/2010/06/oracle-database-statistics-rbo-cbo.html

SQL Prompt in Oracle http://satya-dba.blogspot.com/2010/08/setting-sql-prompt-in-oracle.html

dgmgrl (Data Guard monitoring) utility in Oracle http://satya-dba.blogspot.com/2010/09/dgmgrl-utility-tool-executable.html

adrci commands in Oracle http://satya-dba.blogspot.com/2010/10/adrci-commands-tool-utility.html

oracleasm in Oracle http://satya-dba.blogspot.com/2011/11/oracleasm-oracle-asm.html

ggsci Oracle GoldenGate http://satya-dba.blogspot.com/2012/02/ggsci-goldengate-command-interpreter.html

emca in Oracle http://satya-dba.blogspot.com/2012/03/emca-enterprise-manager-configuration.html

emcli in Oracle http://satya-dba.blogspot.com/2012/04/emcli-enterprise-manager-command-line.html

Snapshot Standby Databases in Oracle http://satya-dba.blogspot.com/2012/06/snapshot-standby-databases-oracle.html

Logical Standby Databases in Oracle http://satya-dba.blogspot.com/2012/06/logical-standby-databases-oracle.html

Physical Standby Databases in Oracle http://satya-dba.blogspot.com/2012/06/physical-standby-databases-oracle.html

Block Change Tracking in Oracle http://satya-dba.blogspot.com/2012/06/block-change-tracking-file-oracle.html

RMAN Incremental Backups in Oracle http://satya-dba.blogspot.com/2012/07/rman-incremental-backups-level-0-level1.html

Wait events in Oracle http://satya-dba.blogspot.com/2012/10/wait-events-in-oracle-wait-events.html

Managing Oracle Partitions (operations) http://satya-dba.blogspot.com/2013/02/managing-oracle-partitions-add-drop.html

Indexes on Oracle Partitions http://satya-dba.blogspot.com/2013/02/local-global-indexes-on-partitions.html

Oracle Materialized View Log http://satya-dba.blogspot.com/2013/02/oracle-materialized-view-log.html

Oracle Golden Gate (OGG) Log Dump Utility Commands

 

Oracle RAC Blog http://satya-racdba.blogspot.com

Oracle Exadata Blog http://satya-exadata.blogspot.com

Oracle AppsDBA Blog http://satya-appsdba.blogspot.com

Apache Cassandra Blog http://satya-cassandra.blogspot.com

Oracle Certifications http://satya-dba.blogspot.com/2008/12/oracle-certification_24.html

Oracle10g Dumps http://satya-dba.blogspot.com/2008/12/10g-dba-dumps.html

Database of life http://satya-dba.blogspot.com/2009/01/database-of-life.html

First day in IDRBT http://satya-dba.blogspot.com/2009/01/first-day-in-job-idrbt.html

Databases in this world http://satya-dba.blogspot.com/2009/06/databases-in-world.html

 

Oracle GoldenGate Interview Questions/FAQs http://satya-dba.blogspot.com/2012/10/goldengate-interview-questions-faqs.html

Oracle Data Guard Interview Questions/FAQs http://satya-dba.blogspot.com/2012/10/dataguard-interview-questions-faqs.html

Oracle Export/Import – Data Pump Interview Questions/FAQs http://satya-dba.blogspot.com/2012/10/exportimport-data-pump-interview.html

Oracle Performance related interview Questions/FAQs http://satya-dba.blogspot.com/2012/10/oracle-performance-related-interview.html

Oracle ASM Interview Questions/FAQs http://satya-dba.blogspot.com/2012/10/oracle-asm-interview-questions-faqs.html

Oracle RMAN Interview Questions/FAQs http://satya-dba.blogspot.com/2012/10/oracle-rman-interview-questions-faqs.html

Oracle PL/SQL Interview Questions/FAQs http://satya-dba.blogspot.com/2012/10/oracle-plsql-interview-questionsfaqs.html

UNIX Interview Questions/FAQs for Oracle DBAs http://satya-dba.blogspot.com/2012/10/unix-interview-questions-for-oracle-dbas.html

Oracle DBA Interview Questions/FAQs – Part1 http://satya-dba.blogspot.com/2012/10/oracle-dba-interview-questions-faqs.html

Oracle DBA Interview Questions/FAQs – Part2 http://satya-dba.blogspot.com/2012/10/oracle-dba-interview-questionsfaqs.html

Oracle DBA Interview Questions/FAQs – Part3 http://satya-dba.blogspot.com/2012/10/dba-oracle-interview-questions-faqs.html

Oracle DBA Interview Questions/FAQs – Part4 http://satya-dba.blogspot.com/2012/10/oracle-dba-interview-questions-faqs_22.html

 

Oracle RAC Interview Questions Part1 http://satya-racdba.blogspot.com/2012/10/oracle-rac-interview-questions-faqs.html

Oracle RAC Interview Questions Part2 http://satya-racdba.blogspot.com/2013/01/oracle-rac-interview-questionsfaqs.html

Oracle RAC Interview Questions Part3 http://satya-racdba.blogspot.com/2013/02/rac-dba-interview-questions-faqs-part3.html

 

Oracle Exadata Interview Questions http://satya-exadata.blogspot.com/2012/10/exadata-interview-questions-faqs-oracle.html

Posted in DBA-RAC-Exadata Tools | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 3 Comments

Exadata Blog

Oracle Exadata cellcli commands http://satya-exadata.blogspot.com/2011/07/cellclicommandsexadata.html

 

Oracle Exadata dcli commands http://satya-exadata.blogspot.com/2011/08/dclicommandsexadata.html
Oracle Exadata Terms http://satya-exadata.blogspot.com/2011/12/exadata-terms-ehcc-ilom-pdu.html
Full Half Quarter Racks in Oracle Exadata http://satya-exadata.blogspot.com/2011/12/full-half-quarter-racks-differences.html
Oracle Exadata X3 http://satya-exadata.blogspot.com/2012/10/oracle-exadata-x3.html
Oracle Exadata Interview Questions http://satya-exadata.blogspot.com/2012/10/exadata-interview-questions-faqs-oracle.html
Oracle Exadata Wait Events
Oracle Exadata IPMI tool http://satya-exadata.blogspot.com/2013/02/ipmitool-oracle-exadata-ipmi-tool.html
Oracle Exadata Statistics http://satya-exadata.blogspot.com/2013/02/exadata-statistics-oracle-exadata.html

 

Oracle GoldenGate Interview Questions/FAQs http://satya-dba.blogspot.com/2012/10/goldengate-interview-questions-faqs.html
Oracle Data Guard Interview Questions/FAQs http://satya-dba.blogspot.com/2012/10/dataguard-interview-questions-faqs.html
Oracle Export/Import – Data Pump Interview Questions/FAQs http://satya-dba.blogspot.com/2012/10/exportimport-data-pump-interview.html
Oracle Performance related interview Questions/FAQs http://satya-dba.blogspot.com/2012/10/oracle-performance-related-interview.html
Oracle ASM Interview Questions/FAQs http://satya-dba.blogspot.com/2012/10/oracle-asm-interview-questions-faqs.html
Oracle RMAN Interview Questions/FAQs http://satya-dba.blogspot.com/2012/10/oracle-rman-interview-questions-faqs.html
Oracle PL/SQL Interview Questions/FAQs http://satya-dba.blogspot.com/2012/10/oracle-plsql-interview-questionsfaqs.html
UNIX Interview Questions/FAQs for Oracle Database Adminstrators (DBAs)
Oracle DBA Interview Questions/FAQs – Part1 http://satya-dba.blogspot.com/2012/10/oracle-dba-interview-questions-faqs.html
Oracle DBA Interview Questions/FAQs – Part2 http://satya-dba.blogspot.com/2012/10/oracle-dba-interview-questionsfaqs.html
Oracle DBA Interview Questions/FAQs – Part3 http://satya-dba.blogspot.com/2012/10/dba-oracle-interview-questions-faqs.html
Oracle DBA Interview Questions/FAQs – Part4 http://satya-dba.blogspot.com/2012/10/oracle-dba-interview-questions-faqs_22.html

 

Posted in DBA-RAC-Exadata Tools | Tagged , , , , , , , , , , , , , , , , | 1 Comment