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 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

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 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

2012 http://satya-dba.blogspot.com/2009/04/december-21-2012.html

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

Top10 largest databases http://satya-dba.blogspot.com/2009/02/top-10.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 http://satya-exadata.blogspot.com/2013/01/wait-events-in-exadata-wait-events.html
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 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 , , , , , , , , , , , , , , , , | 1 Comment

srvctl commands

srvctl commands

SRVCTL:
srvctl command target [options]
commands: enable|disable|start|stop|relocate|status|add|remove|
modify|getenv|setenv|unsetenv|config
targets: database/db|instance/inst|service/serv|nodeapps|asm|listener
targets: database/db|instance/inst|service/serv|nodeapps|asm|listener |diskgroup|home|ons|eons|filesystem|gns|oc4j|scan|scan_listener |srvpool|server|VIP                 — From 11gR2
srvctl -help or srvctl -v
srvctl -V — prints version
 srvctl version: 10.2.0.0.0 (or) srvctl version: 11.2.0.1.0
srvctl -h — print usage
srvctl status service –h
Database:


srvctl add database -d db_name -o ORACLE_HOME [-m domain_name][-p spfile] [-A name|ip/netmask]
[-r {PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY}]
[-s start_options] [-n db_name] [-y {AUTOMATIC|MANUAL}]
srvctl add database -d prod -o /u01/oracle/product/102/prod
srvctl remove database -d db_name [-f]
srvctl remove database -d prod
srvctl start database -d db_name [-o start_options] [-c connect_str|-q]
srvctl start database -d db_name [-o open]
srvctl start database -d db_name -o nomount
srvctl start database -d db_name -o mount
srvctl start db -d prod
srvctl start database -d apps -o open
srvctl stop database -d db_name [-o stop_options] [-c connect_str|-q]
srvctl stop database -d db_name [-o normal]
srvctl stop database -d db_name -o transactional
srvctl stop database -d db_name -o immediate
srvctl stop database -d db_name -o abort
srvctl stop db -d crm -o immediate
srvctl status database -d db_name [-f] [-v] [-S level]
srvctl status database -d db_name -v service_name
srvctl status database -d hrms
srvctl enable database -d db_name
srvctl enable database -d vis
srvctl disable database -d db_name
srvctl disable db -d vis
srvctl config database
srvctl config database -d db_name [-a] [-t]
srvctl config database
srvctl config database -d HYD -a
srvctl modify database -d db_name [-n db_name] [-o ORACLE_HOME] [-m domain_name] [-p spfile]
[-r {PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY}] [-s start_options] [-y {AUTOMATIC|MANUAL}]
srvctl modify database -d hrms -r physical_standby
srvctl modify db -d RAC -p /u03/oradata/RAC/spfileRAC.ora — moves p file
srvctl modify database –d HYD –o /u01/app/oracle/product/11.1/db –s open
srvctl getenv database -d db_name [-t name_list]
srvctl getenv database -d prod
srvctl setenv database -d db_name {-t name=val[,name=val,...]|-T name=val}
srvctl setenv database –d HYD –t “TNS_ADMIN=/u01/app/oracle/product/11.1/asm/network/admin”
srvctl setenv db -d prod -t LANG=en
srvctl unsetenv database -d db_name [-t name_list]
srvctl unsetenv database -d prod -t CLASSPATHIn 11g Release 2, some command’s syntax has been changed:
srvctl add database -d db_unique_name -o ORACLE_HOME [-x node_name] [-m domain_name] [-p spfile] [-r {PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY}] [-s start_options] [-t stop_options] [-n db_name] [-y {AUTOMATIC|MANUAL}] [-g server_pool_list] [-a "diskgroup_list"]
srvctl add database -d prod -o /u01/oracle/product/112/prod -m foo.com -p +dg1/prod/spfileprod.ora -r PRIMARY -s open -t normal -n db2 -y AUTOMATIC -g svrpool1,svrpool2 -a “dg1,dg2″srvctl remove database -d db_unique_name [-f] [-y] [-v]
srvctl remove database -d prod -y

srvctl stop database -d db_unique_name [-o stop_options] [-f]
srvctl stop database -d dev -f

srvctl status database -d db_unique_name [-f] [-v]
srvctl status db -d sat -v

srvctl enable database -d db_unique_name [-n node_name]
srvctl enable database -d vis -n lnx01

srvctl disable database -d db_unique_name [-n node_name]
srvctl disable db -d vis -n lnx03

srvctl config database [-d db_unique_name [-a]]
srvctl config db -d db_erp -a

srvctl modify database -d db_unique_name [-n db_name] [-o ORACLE_HOME] [-u oracle_user] [-m domain] [-p spfile] [-r {PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY}] [-s start_options] [-t stop_options] [-y {AUTOMATIC|MANUAL}] [-g "server_pool_list"] [-a "diskgroup_list"|-z]
srvctl modify db -d prod -r logical_standby
srvctl modify database -d racTest -a “SYSFILES,LOGS,OLTP”

Instance:


srvctl add instance –d db_name –i inst_name -n node_name
srvctl add instance -d prod -i prod01 -n linux01
srvctl remove instance –d db_name –i inst_name [-f]
srvctl remove instance -d prod -i prod01
srvctl start instance -d db_name -i inst_names [-o start_options] [-c connect_str|-q]
srvctl start instance –d db_name –i inst_names [-o open]
srvctl start instance –d db_name –i inst_names -o nomount
srvctl start instance –d db_name –i inst_names -o mount
srvctl start instance –d dev -i dev2
srvctl stop instance -d db_name -i inst_names [-o stop_options] [-c connect_str|-q]
srvctl stop instance –d db_name –i inst_names [-o normal]
srvctl stop instance –d db_name –i inst_names -o transactional
srvctl stop instance –d db_name –i inst_names -o immediate
srvctl stop instance –d db_name –i inst_names -o abort
srvctl stop inst –d vis -i vis
srvctl status instance –d db_name –i inst_names [-f] [-v] [-S level]
srvctl status inst –d racdb -i racdb2
srvctl enable instance –d db_name –i inst_names
srvctl enable instance -d prod -i “prod1,prod2″
srvctl disable instance –d db_name –i inst_names
srvctl disable inst -d prod -i “prod1,prod3″
srvctl modify instance -d db_name -i inst_name {-s asm_inst_name|-r} — set dependency of instance to ASM
srvctl modify instance -d db_name -i inst_name -n node_name — move the instance
srvctl modify instance -d db_name -i inst_name -r — remove the instance
srvctl getenv instance –d db_name –i inst_name [-t name_list]
srvctl setenv instance –d db_name [–i inst_name] {-t “name=val[,name=val,...]” | -T “name=val”}
srvctl unsetenv instance –d db_name [–i inst_name] [-t name_list]In 11g Release 2, some command’s syntax has been changed:
srvctl start instance -d db_unique_name {-n node_name -i “instance_name_list”} [-o start_options]
srvctl start instance -d prod -n node2
srvctl start inst -d prod -i “prod2,prod3″srvctl stop instance -d db_unique_name {[-n node_name]|[-i "instance_name_list"]} [-o stop_options] [-f]
srvctl stop inst -d prod -n node1
srvctl stop instance -d prod -i prod1

srvctl status instance -d db_unique_name {-n node_name | -i “instance_name_list”} [-f] [-v]
srvctl status instance -d prod -i “prod1,prod2″ -v

srvctl modify instance -d db_unique_name -i instance_name {-n node_name|-z}
srvctl modify instance -d prod -i prod1 -n mynode
srvctl modify inst -d prod -i prod1 -z

Service:


srvctl add service -d db_name -s service_name -r pref_insts [-a avail_insts] [-P TAF_policy]
srvctl add service -d db_name -s service_name -u {-r “new_pref_inst” | -a “new_avail_inst”}
srvctl add service -d RAC -s PRD -r RAC01,RAC02 -a RAC03,RAC04
srvctl add serv -d CRM -s CRM -r CRM1 -a CRM3 -P basic
srvctl remove service -d db_name -s service_name [-i inst_name] [-f]
srvctl remove serv -d dev -s sales
srvctl remove service -d dev -s sales -i dev01,dev02
srvctl start service -d db_name [-s service_names [-i inst_name]] [-o start_options]
srvctl start service -d db_name -s service_names [-o open]
srvctl start service -d db_name -s service_names -o nomount
srvctl start service -d db_name -s service_names -o mount
srvctl start serv -d dwh -s dwh
srvctl stop service -d db_name [-s service_names [-i inst_name]] [-f]
srvctl stop serv -d dwh -s dwh
srvctl status service -d db_name [-s service_names] [-f] [-v] [-S level]
srvctl status service -d dev -s dev
srvctl enable service -d db_name -s service_names [–i inst_name]
srvctl enable service -d apps -s apps1
srvctl disable service -d db_name -s service_names [–i inst_name]
srvctl disable serv -d dev -s dev -i dev1
srvctl config service -d db_name [-s service_name] [-a] [-S level]
srvctl config service -d db_name -a — -a shows TAF configuration
srvctl config service -d TEST -s test PREF:TST1 AVAIL:TST2
srvctl modify service -d db_name -s service_name -i old_inst_name -t new_inst_name [-f]
srvctl modify service -d db_name -s service_name -i avail_inst_name -r [-f]
srvctl modify service -d db_name -s service_name -n -i preferred_list [-a available_list] [-f]
srvctl modify service -d db_name -s service_name -i old_inst_name -a avail_inst -P TAF_policy
srvctl modify serv -d PROD -s DWH -n -i I1,I2,I3,I4 -a I5,I6
srvctl relocate service -d db_name -s service_name –i old_inst_name -t target_inst [-f]
srvctl getenv service -d db_name -s service_name -t name_list
srvctl setenv service -d db_name [-s service_name] {-t “name=val[,name=val,...]” | -T “name=val”}
srvctl unsetenv service -d db_name -s service_name -t name_list
In 11g Release 2, some command’s syntax has been changed:
srvctl add service -d db_unique_name -s service_name [-l [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-y {AUTOMATIC|MANUAL}] [-q {true|false}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}][-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}][-z failover_retries] [-w failover_delay]
srvctl add service -d rac -s rac1 -q TRUE -m BASIC -e SELECT -z 180 -w 5 -j LONGsrvctl add service -d db_unique_name -s service_name -u {-r preferred_list | -a available_list}srvctl add service -d db_unique_name -s service_name
-g server_pool [-c {UNIFORM|SINGLETON}] [-k network_number]
[-l [PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY]
[-y {AUTOMATIC|MANUAL}] [-q {TRUE|FALSE}] [-j {SHORT|LONG}]
[-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}]
[-m {NONE|BASIC}] [-P {BASIC|NONE|PRECONNECT}] [-x {TRUE|FALSE}]
[-z failover_retries] [-w failover_delay]

srvctl add service -d db_unique_name -s service_name -r preferred_list [-a available_list] [-P {BASIC|NONE|PRECONNECT}]
[-l [PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY]
[-y {AUTOMATIC|MANUAL}] [-q {TRUE|FALSE}] [-j {SHORT|LONG}]
[-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}]
[-m {NONE|BASIC}] [-x {TRUE|FALSE}] [-z failover_retries] [-w failover_delay]
srvctl add serv -d dev -s sales -r dev01,dev02 -a dev03 -P PRECONNECT

srvctl start service -d db_unique_name [-s “service_name_list” [-n node_name | -i instance_name]] [-o start_options]
srvctl start serv -d dev -s dev
srvctl start service -d dev -s dev -i dev2

srvctl stop service -d db_unique_name [-s "service_name_list"] [-n node_name | -i instance_name] [-f]
srvctl stop service -d dev -s dev
srvctl stop serv -d dev -s dev -i dev2

srvctl status service -d db_unique_name [-s "service_name_list"] [-f] [-v]
srvctl status service -d dev -s dev -v

srvctl enable service -d db_unique_name -s “service_name_list” [-i instance_name | -n node_name]
srvctl enable service -d dev -s dev
srvctl enable serv -d dev -s dev -i dev1

srvctl disable service -d db_unique_name -s “service_name_list” [-i instance_name | -n node_name]
srvctl disable service -d dev -s “dev,marketing”
srvctl disable serv -d dev -s dev -i dev1

srvctl config service -d db_unique_name [-s service_name] [-a]
srvctl config service -d dev -s dev

srvctl modify service -d db_unique_name -s service_name
[-c {UNIFORM|SINGLETON}] [-P {BASIC|PRECONNECT|NONE}]
[-l {[PRIMARY]|[PHYSICAL_STANDBY]|[LOGICAL_STANDBY]|[SNAPSHOT_STANDBY]} [-q {TRUE|FALSE}] [-x {TRUE|FALSE}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}] [-z failover_retries] [-w failover_delay] [-y {AUTOMATIC|MANUAL}]
srvctl modify service -d db_unique_name -s service_name -i old_instance_name -t new_instance_name [-f]
srvctl modify service -d db_unique_name -s service_name -i avail_inst_name -r [-f]
srvctl modify service -d db_unique_name -s service_name -n -i preferred_list [-a available_list] [-f]
srvctl modify service -d dev -s dev -i dev1 -t dev2
srvctl modify serv -d dev -s dev -i dev1 -r
srvctl modify service -d dev -s dev -n -i dev1 -a dev2

srvctl relocate service -d db_unique_name -s service_name {-c source_node -n target_node|-i old_instance_name -t new_instance_name} [-f]
srvctl relocate service -d dev -s dev -i dev1 -t dev3

Nodeapps:


#srvctl add nodeapps -n node_name -o ORACLE_HOME -A name|ip/netmask[/if1[|if2|...]]
#srvctl add nodeapps -n lnx02 -o $ORACLE_HOME -A 192.168.0.151/255.255.0.0/eth0
#srvctl remove nodeapps -n node_names [-f]
#srvctl start nodeapps -n node_name     — Starts GSD, VIP, listener & ONS
#srvctl stop nodeapps -n node_name [-r] — Stops GSD, VIP, listener & ONS
#srvctl status nodeapps -n node_name
#srvctl config nodeapps -n node_name [-a] [-g] [-o] [-s] [-l]
-a Display VIP configuration
-g Display GSD configuration
-s Display ONS daemon configuration
-l Display listener configuration
#srvctl modify nodeapps -n node_name [-A new_vip_address]
#srvctl modify nodeapps -n lnx06 -A 10.50.99.43/255.255.252.0/eth0
#srvctl getenv nodeapps -n node_name [-t name_list]
#srvctl setenv nodeapps -n node_name {-t “name=val[,name=val,...]“|-T “name=val”}
#srvctl setenv nodeapps –n adcracdbq3 –t “TNS_ADMIN=/u01/app/oracle/product/11.1/asm/network/admin”
#srvctl unsetenv nodeapps -n node_name [-t name_list]
In 11g Release 2, some command’s syntax has been changed:
srvctl add nodeapps -n node_name -A {name|ip}/netmask[/if1[|if2|...]] [-m multicast_ip_address] [-p multicast_port_number] [-l ons_local_port] [-r ons_remote-port] [-t host[:port][,host[:port],…]] [-v]
srvctl add nodeapps -S subnet/netmask[/if1[|if2|...]] [-d dhcp_server_type] [-m multicast_ip_address] [-p multicast_port_number] [-l ons_local_port] [-r ons_remote-port] [-t host[:port][,host[:port],…]] [-v]
#srvctl add nodeapps -n devnode1 -A 1.2.3.4/255.255.255.0srvctl remove nodeapps [-f] [-y] [-v]
srvctl remove nodeappssrvctl start nodeapps [-n node_name] [-v]
srvctl start nodeapps

srvctl stop nodeapps [-n node_name] [-r] [-v]
srvctl stop nodeapps

srvctl status nodeapps

srvctl enable nodeapps [-g] [-v]
srvctl enable nodeapps -g -v

srvctl disable nodeapps [-g] [-v]
srvctl disable nodeapps -g -v

srvctl config nodeapps [-a] [-g] [-s] [-e]
srvctl config nodeapps -a -g -s -e

srvctl modify nodeapps [-n node_name -A new_vip_address] [-S subnet/netmask[/if1[|if2|...]] [-m multicast_ip_address] [-p multicast_port_number] [-e eons_listen_port] [-l ons_local_port] [-r ons_remote_port] [-t host[:port][,host:port,...]] [-v]
srvctl modify nodeapps -n mynode1 -A 100.200.300.40/255.255.255.0/eth0

srvctl getenv nodeapps [-a] [-g] [-s] [-e] [-t "name_list"] [-v]
srvctl getenv nodeapps -a

srvctl setenv nodeapps {-t “name=val[,name=val][...]” | -T “name=val”} [-v]
srvctl setenv nodeapps -T “CLASSPATH=/usr/local/jdk/jre/rt.jar” -v

srvctl unsetenv nodeapps -t “name_list” [-v]
srvctl unsetenv nodeapps -t “test_var1,test_var2″

ASM:


srvctl add asm -n node_name -i asminstance -o ORACLE_HOME [-p spfile]
srvctl remove asm -n node_name [-i asminstance] [-f]
srvctl remove asm -n db6
srvctl start asm -n node_name [-i asminstance] [-o start_options] [-c connect_str|-q]
srvctl start asm -n node_name [-i asminstance] [-o open]
srvctl start asm -n node_name [-i asminstance] -o nomount
srvctl start asm -n node_name [-i asminstance] -o mount
srvctl start asm -n linux01
srvctl stop asm -n node_name [-i asminstance] [-o stop_options] [-c connect_str|-q]
srvctl stop asm -n node_name [-i asminstance] [-o normal]
srvctl stop asm -n node_name [-i asminstance] -o transactional
srvctl stop asm -n node_name [-i asminstance] -o immediate
srvctl stop asm -n node_name [-i asminstance]-o abort
srvctl stop asm -n racnode1
srvctl stop asm -n devnode1 -i +asm1
srvctl status asm -n node_name
srvctl status asm -n racnode1
srvctl enable asm -n node_name [-i asminstance]
srvctl enable asm -n lnx03 -i +asm3
srvctl disable asm -n node_name [-i asminstance]
srvctl disable asm -n lnx02 -i +asm2
srvctl config asm -n node_name
srvctl config asm -n lnx08
srvctl modify asm -n node_name -i asminstance [-o ORACLE_HOME] [-p spfile]
srvctl modify asm –n rac6 -i +asm6 –o /u01/app/oracle/product/11.1/asmIn 11g Release 2, some command’s syntax has been changed:
srvctl add asm [-l lsnr_name] [-p spfile] [-d asm_diskstring]
srvctl add asm
srvctl add asm -l LISTENERASM -p +dg_data/spfile.orasrvctl remove asm [-f]
srvctl remove asm -f

srvctl start asm [-n node_name] [-o start_options]
srvctl start asm -n devnode1

srvctl stop asm [-n node_name] [-o stop_options] [-f]
srvctl stop asm -n devnode1 -f

srvctl status asm [-n node_name] [-a]
srvctl status asm -n devnode1 -a

srvctl enable asm [-n node_name]
srvctl enable asm -n devnode1

srvctl disable asm [-n node_name]
srvctl disable asm -n devnode1

srvctl config asm [-a]
srvctl config asm -a

srvctl modify asm [-l lsnr_name] [-p spfile] [-d asm_diskstring]
srvctl modify asm [-n node_name] [-l listener_name] [-d asm_diskstring] [-p spfile_path_name]
srvctl modify asm -l lsnr1

srvctl getenv asm [-t name[, ...]]
srvctl getenv asm

srvctl setenv asm {-t “name=val [,...]” | -T “name=value”}
srvctl setenv asm -t LANG=en

srvctl unsetenv asm -t “name[, ...]“
srvctl unsetenv asm -t CLASSPATH


Listener:


srvctl add listener -n node_name -o ORACLE_HOME [-l listener_name]
– 11gR1 command
srvctl remove listener -n node_name [-l listener_name] — 11gR1 command
srvctl start listener -n node_name [-l listener_names]
srvctl start listener -n node1
srvctl stop listener -n node_name [-l listener_names]
srvctl stop listener -n node1srvctl status listener [-n node_name] [-l listener_names] — 11gR1 command
srvctl status listener -n node2
srvctl config listener -n node_namesrvctl modify listener -n node_name [-l listener_names] -o ORACLE_HOME               — 11gR1 command
srvctl modify listener -n racdb4 -o /u01/app/oracle/product/11.1/asm -l “LISTENER_RACDB4″In 11g Release 2, some command’s syntax has been changed:
srvctl add listener [-l lsnr_name] [-s] [-p “[TCP:]port[, ...][/IPC:key][/NMP:pipe_name][/TCPS:s_port] [/SDP:port]“] [-k network_number] [-o ORACLE_HOME]
srvctl add listener -l LISTENERASM -p “TCP:1522″ -o $ORACLE_HOME
srvctl add listener -l listener112 -p 1341 -o /ora/ora112

srvctl remove listener [-l lsnr_name|-a] [-f]
srvctl remove listener -l lsnr01

srvctl stop listener [-n node_name] [-l lsnr_name] [-f]

srvctl enable listener [-l lsnr_name] [-n node_name]
srvctl enable listener -l listener_dev -n node5

srvctl disable listener [-l lsnr_name] [-n node_name]
srvctl disable listener -l listener_dev -n node5

srvctl config listener [-l lsnr_name] [-a]
srvctl config listener

srvctl modify listener [-l listener_name] [-o oracle_home] [-u user_name] [-p “[TCP:]port_list[/IPC:key][/NMP:pipe_name][/TCPS:s_port][/SDP:port]“] [-k network_number]
srvctl modify listener -n node1 -p “TCP:1521,1522″

srvctl getenv listener [-l lsnr_name] [-t name[, ...]]
srvctl getenv listener

srvctl setenv listener [-l lsnr_name] {-t “name=val [,...]” | -T “name=value”}
srvctl setenv listener -t LANG=en

srvctl unsetenv listener [-l lsnr_name] -t “name[, ...]“
srvctl unsetenv listener -t “TNS_ADMIN”

New srvctl commands in 11g Release 2

Diskgroup:


srvctl remove diskgroup -g diskgroup_name [-n node_list] [-f]
srvctl remove diskgroup -g DG1 -f

srvctl start diskgroup -g diskgroup_name [-n node_list]
srvctl start diskgroup -g diskgroup1 -n node1,node2

srvctl stop diskgroup -g diskgroup_name [-n node_list] [-f]
srvctl stop diskgroup -g ASM_FRA_DG
srvctl stop diskgroup -g dg1 -n node1,node2 -f

srvctl status diskgroup -g diskgroup_name [-n node_list] [-a]
srvctl status diskgroup -g dg_data -n node1,node2 -a

srvctl enable diskgroup -g diskgroup_name [-n node_list]
srvctl enable diskgroup -g diskgroup1 -n node1,node2

srvctl disable diskgroup -g diskgroup_name [-n node_list]
srvctl disable diskgroup -g dg_fra -n node1, node2

Home:


srvctl start home -o ORACLE_HOME -s state_file [-n node_name]
srvctl start home -o /u01/app/oracle/product/11.2.0/db_1 -s ~/state.txt

srvctl stop home -o ORACLE_HOME -s state_file [-t stop_options] [-n node_name] [-f]
srvctl stop home -o /u01/app/oracle/product/11.2.0/db_1 -s ~/state.txt

srvctl status home -o ORACLE_HOME -s state_file [-n node_name]
srvctl status home -o /u01/app/oracle/product/11.2.0/db_1 -s ~/state.txt

ONS (Oracle Notification Service) :


srvctl add ons [-l ons-local-port] [-r ons-remote-port] [-t host[:port][,host[:port]…]] [-v]
srvctl add ons -l 6200

srvctl remove ons [-f] [-v]
srvctl remove ons -f

srvctl start ons [-v]
srvctl start ons -v

srvctl stop ons [-v]
srvctl stop ons -v

srvctl status ons

srvctl enable ons [-v]
srvctl enable ons

srvctl disable ons [-v]
srvctl disable ons

srvctl config ons

srvctl modify ons [-l ons-local-port] [-r ons-remote-port] [-t host[:port][,host[:port]…]] [-v]
srvctl modify ons

EONS:


srvctl add eons [-p portnum] [-m multicast-ip-address] [-e eons-listen-port] [-v]
#srvctl add eons -p 2018

srvctl remove eons [-f] [-v]
srvctl remove eons -f

srvctl start eons [-v]
srvctl start eons

srvctl stop eons [-f] [-v]
srvctl stop eons -f

srvctl status eons

srvctl enable eons [-v]
srvctl enable eons

srvctl disable eons [-v]
srvctl disable eons

srvctl config eons

srvctl modify eons [-m multicast_ip_address] [-p multicast_port_number] [-e eons_listen_port] [-v]
srvctl modify eons -p 2018

FileSystem:


srvctl add filesystem -d volume_device -v volume_name -g diskgroup_name [-m mountpoint_path] [-u user_name]
srvctl add filesystem -d /dev/asm/d1volume1 -v VOLUME1 -d RAC_DATA -m /oracle/cluster1/acfs1

srvctl remove filesystem -d volume_device_name [-f]
srvctl remove filesystem -d /dev/asm/racvol1

srvctl start filesystem -d volume_device_name [-n node_name]
srvctl start filesystem -d /dev/asm/racvol3

srvctl stop filesystem -d volume_device_name [-n node_name] [-f]
srvctl stop filesystem -d /dev/asm/racvol1 -f

srvctl status filesystem -d volume_device_name
srvctl status filesystem -d /dev/asm/racvol2

srvctl enable filesystem -d volume_device_name
srvctl enable filesystem -d /dev/asm/racvol9

srvctl disable filesystem -d volume_device_name
srvctl disable filesystem -d /dev/asm/racvol1

srvctl config filesystem -d volume_device_path

srvctl modify filesystem -d volume_device_name -u user_name
srvctl modify filesystem -d /dev/asm/racvol1 -u sysadmin

SrvPool:


srvctl add srvpool -g server_pool [-i importance] [-l min_size] [-u max_size] [-n node_list] [-f]
srvctl add srvpool -g SP1 -i 1 -l 3 -u 7 -n node1,node2

srvctl remove srvpool -g server_pool
srvctl remove srvpool -g srvpool1

srvctl status srvpool [-g server_pool] [-a]
srvctl status srvpool -g srvpool2 -a

srvctl config srvpool [-g server_pool]
srvctl config srvpool -g dbpool

srvctl modify srvpool -g server_pool [-i importance] [-l min_size] [-u max_size] [-n node_name_list] [-f]
srvctl modify srvpool -g srvpool4 -i 0 -l 2 -u 4 -n node3, node4

Server:


srvctl status server -n “server_name_list” [-a]
srvctl status server -n server11 -a

srvctl relocate server -n “server_name_list” -g server_pool_name [-f]
srvctl relocate server -n “linux1, linux2″ -g sp2

Scan (Single Client Access Name):


srvctl add scan -n scan_name [-k network_number] [-S subnet/netmask[/if1[|if2|...]]]
#srvctl add scan -n scan.mycluster.example.com

srvctl remove scan [-f]
srvctl remove scan -f

srvctl start scan [-i ordinal_number] [-n node_name]
srvctl start scan -i 1 -n node1

srvctl stop scan [-i ordinal_number] [-f]
srvctl stop scan -i 1

srvctl status scan [-i ordinal_number]
srvctl status scan -i 1

srvctl enable scan [-i ordinal_number]
srvctl enable scan -i 1

srvctl disable scan [-i ordinal_number]
srvctl disable scan -i 3

srvctl config scan [-i ordinal_number]
srvctl config scan -i 2

srvctl modify scan -n scan_name
srvctl modify scan -n scan1

srvctl relocate scan -i ordinal_number [-n node_name]
srvctl relocate scan -i 2 -n node2

ordinal_number=1,2,3

Scan_listener:


srvctl add scan_listener [-l lsnr_name_prefix] [-s] [-p “[TCP:]port_list[/IPC:key][/NMP:pipe_name][/TCPS:s_port] [/SDP:port]“]
#srvctl add scan_listener -l myscanlistener

srvctl remove scan_listener [-f]
srvctl remove scan_listener -f

srvctl start scan_listener [-n node_name] [-i ordinal_number]
srvctl start scan_listener -i 1

srvctl stop scan_listener [-i ordinal_number] [-f]
srvctl stop scan_listener -i 3

srvctl status scan_listener [-i ordinal_number]
srvctl status scan_listener -i 1

srvctl enable scan_listener [-i ordinal_number]
srvctl enable scan_listener -i 2

srvctl disable scan_listener [-i ordinal_number]
srvctl disable scan_listener -i 1

srvctl config scan_listener [-i ordinal_number]
srvctl config scan_listener -i 3

srvctl modify scan_listener {-p [TCP:]port[/IPC:key][/NMP:pipe_name] [/TCPS:s_port][/SDP:port] | -u }
srvctl modify scan_listener -u

srvctl relocate scan_listener -i ordinal_number [-n node_name]
srvctl relocate scan_listener -i 1

ordinal_number=1,2,3

GNS (Grid Naming Service):


srvctl add gns -i ip_address -d domain
srvctl add gns -i 192.124.16.96 -d cluster.mycompany.com

srvctl remove gns [-f]
srvctl remove gns

srvctl start gns [-l log_level] [-n node_name]
srvctl start gns

srvctl stop gns [-n node_name [-v] [-f]
srvctl stop gns

srvctl status gns [-n node_name]
srvctl status gns

srvctl enable gns [-n node_name]
srvctl enable gns

srvctl disable gns [-n node_name]
srvctl disable gns -n devnode2

srvctl config gns [-a] [-d] [-k] [-m] [-n node_name] [-p] [-s] [-V] [-q name] [-l] [-v]
srvctl config gns -n lnx03

srvctl modify gns [-i ip_address] [-d domain]
srvctl modify gns -i 192.000.000.007

srvctl relocate gns [-n node_name]
srvctl relocate gns -n node2

VIP (Virtual Internet Protocol):


srvctl add vip -n node_name -A {name|ip}/netmask[/if1[if2|...]] [-k network_number] [-v]
#srvctl add vip -n node96 -A 192.124.16.96/255.255.255.0 -k 2

srvctl remove vip -i “vip_name_list” [-f] [-y] [-v]
srvctl remove vip -i “vip1,vip2,vip3″ -f -y -v

srvctl start vip {-n node_name|-i vip_name} [-v]
srvctl start vip -i dev1-vip -v

srvctl stop vip {-n node_name|-i vip_name} [-r] [-v]
srvctl stop vip -n node1 -v

srvctl status vip {-n node_name|-i vip_name}
srvctl status vip -i node1-vip

srvctl enable vip -i vip_name [-v]
srvctl enable vip -i prod-vip -v

srvctl disable vip -i vip_name [-v]
srvctl disable vip -i vip3 -v

srvctl config vip {-n node_name|-i vip_name}
srvctl config vip -n devnode2

srvctl getenv vip -i vip_name [-t "name_list"] [-v]
srvctl getenv vip -i node1-vip

srvctl setenv vip -i vip_name {-t “name=val[,name=val,...]” | -T “name=val”}
srvctl setenv vip -i dev1-vip -t LANG=en

srvctl unsetenv vip -i vip_name -t “name_list” [-v]
srvctl unsetenv vip -i myvip -t CLASSPATH

OC4J (Oracle Container for Java):


srvctl add oc4j [-v]
srvctl add oc4j

srvctl remove oc4j [-f] [-v]
srvctl remove oc4j

srvctl start ocj4 [-v]
srvctl start ocj4 -v

srvctl stop oc4j [-f] [-v]
srvctl stop oc4j -f -v

srvctl status oc4j [-n node_name]
srvctl status oc4j -n lnx01

srvctl enable oc4j [-n node_name] [-v]
srvctl enable oc4j -n dev3

srvctl disable oc4j [-n node_name] [-v]
srvctl disable oc4j -n dev1

srvctl config oc4j

srvctl modify oc4j -p oc4j_rmi_port [-v]
srvctl modify oc4j -p 5385

srvctl relocate oc4j [-n node_name] [-v]
srvctl relocate oc4j -n lxn06 -v

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

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

AppsDBA Blog

Oracle AppsDBA (E-Business Suite) Architecture Interview Questions/FAQs http://satya-appsdba.blogspot.com/2013/01/oracle-apps-dba-interview-questions-faqs.html
Oracle AppsDBA (E-Business Suite) Patching Interview Questions/FAQs Part1 http://satya-appsdba.blogspot.com/2013/01/oracle-apps-dba-patching-interview.html
Oracle AppsDBA (E-Business Suite) Patching Interview Questions/FAQs Part2 http://satya-appsdba.blogspot.com/2013/03/oracle-appsdba-patching-interview.html
Oracle AppsDBA (E-Business Suite) Cloning Interview Questions/FAQs http://satya-appsdba.blogspot.com/2013/01/apps-dba-cloning-interview-questions.html
Oracle AppsDBA (E-Business Suite) AD utilities Interview Questions/FAQs Part1 http://satya-appsdba.blogspot.com/2013/01/apps-dba-adutilities-interview.html
Oracle AppsDBA (E-Business Suite) AD utilities Interview Questions/FAQs Part2
Oracle AppsDBA (E-Business Suite) RDBMS Interview Questions/FAQs http://satya-appsdba.blogspot.com/2013/02/appsdba-rdbms-interview-questionsfaqs.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 , , , , , , , | 6 Comments

RAC Blog

srvctl commands in Oracle RAC http://satya-racdba.blogspot.com/2009/12/srvctl-commands.html

crsctl commands in Oracle RAC http://satya-racdba.blogspot.com/2010/01/crsctl-commands.html

crs_stat commands in Oracle RAC http://satya-racdba.blogspot.com/2010/01/crsstat-commands.html

srvconfig commands in Oracle RAC http://satya-racdba.blogspot.com/2010/01/srvconfig-commands.html

crs_profile crs_register crs_unregister crs_setperm crs_getperm crs_start crs_stop crs_relocate commands in Oracle RAC

http://satya-racdba.blogspot.com/2010/01/crsprofile-crsregister-crsunregister.html

ocrcheck commands in Oracle RAC http://satya-racdba.blogspot.com/2010/01/ocrcheck-commands.html

ocrdump commands in Oracle RAC http://satya-racdba.blogspot.com/2010/01/ocrdump-commands.html

ocrconfig commands in Oracle RAC http://satya-racdba.blogspot.com/2010/01/ocrconfig-commands.html

oifcfg commands in Oracle RAC http://satya-racdba.blogspot.com/2010/01/oifcfg-commands.html

olsnodes commands in Oracle RAC http://satya-racdba.blogspot.com/2010/01/olsnodes-commands.html

onsctl commands in Oracle RAC http://satya-racdba.blogspot.com/2010/01/onsctl-commands.html

cluvfy commands in Oracle RAC http://satya-racdba.blogspot.com/2010/01/cluvfy-cluvfy-help-or-cluvfy-h-cluvfy.html

gsdctl commands in Oracle RAC http://satya-racdba.blogspot.com/2010/01/gsdctl-commands.html

clscfg commands in Oracle RAC http://satya-racdba.blogspot.com/2010/01/clscfg-commands.html

racgons commands in Oracle RAC http://satya-racdba.blogspot.com/2010/01/racgons-commands.html

diagcollection.pl commands in Oracle RAC http://satya-racdba.blogspot.com/2010/01/diagcollectionpl-commands.html

Oracle 9i/10g/11g new features in Oracle RAC http://satya-racdba.blogspot.com/2010/07/new-features-in-9i-10g-11g-rac.html

RAID http://satya-racdba.blogspot.com/2010/09/raid-510-raid-01-standalone-cluster.html

RAC Background processes in Oracle RAC http://satya-racdba.blogspot.com/2012/03/background-processes-in-rac.html

RACOne in Oracle RAC http://satya-racdba.blogspot.com/2012/05/racone-omotion-rac-racone.html

Virtual IP (VIP) in Oracle RAC http://satya-racdba.blogspot.com/2012/07/virtual-ip-vip-address-rac-oracle.html

Init parameters in Oracle RAC http://satya-racdba.blogspot.com/2012/09/init-parameters-in-oracle-rac.html

SCAN in Oracle RAC http://satya-racdba.blogspot.com/2012/09/scan-in-oracle-rac-11g-r2.html
gns

Raccheck in Oracle RAC http://satya-racdba.blogspot.com/2012/09/raccheck-oracle-rac-check.html

Wait Events in Oracle RAC http://satya-racdba.blogspot.com/2012/10/wait-events-in-oracle-rac-wait-events.html

Oracle RAC 12c new features http://satya-racdba.blogspot.com/2012/10/new-features-in-oracle-rac-12c.html

O2CB commands in Oracle RAC http://satya-racdba.blogspot.com/2013/02/oracle-rac-o2cb-ocfs2-commands.html

Oracle RAC Certification http://satya-racdba.blogspot.com/2009/10/real-application-clusters-rac.html

Oracle 10g RAC Dumps http://satya-racdba.blogspot.com/2010/07/oracle-10g-rac-1z0-048-dumps.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 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 , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 2 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