Oracle RAC GDSCTL Commands

GDSCTL - Global Data Services (GDS)

gdsctl 
gdsctl @script_file_name

GDSCTL > help start
GDSCTL > start -h

GDSCTL > create catalog -database db_name -user user_name/password
GDSCTL > create catalog -database GSMTST -user c##gsm_admin/gsmadmin;

GDSCTL > add gsm -gsm gsm_name -listener listener_port -catalog catalogdb_name
GDSCTL > add gsm -gsm GSM1 -listener 1522 -catalog GSMTST -pwd gsmcatuser # Create listener
GDSCTL > add gsm -gsm gsm1 -catalog 127.0.0.1:1521:db1
GDSCTL > add database -connect edu400:1521/db01.apac.example.com -region APAC -gdspool hr_pool
GDSCTL > add database -connect edc007:1521/db14.east.example.com -region east -gdspool hr -pwd secret
GDSCTL > add region –region region_list
GDSCTL > add region -region EMCA, APAC
GDSCTL > add brokerconfig -connect HRTST -region EMCA -gdspool hr_pool -pwd gsmuser # Add TNS entry @GSM_home
GDSCTL > add brokerconfig -connect gsm02.training.com:1521/oltp_de -pwd password -gdspool sales -region germany"
$ gdsctl add gdspool -gdspool hr -catalog mygdscatlog
GDSCTL > add gdspool -dbpool database_pool_list [-users user_list]
GDSCTL > add service -gdspool hr -service emp_report1 -preferred_all
GDSCTL > add service -gdspool sales -service gsales_rw -role primary -preferred_all -failovertype SELECT -failovermethod BASIC -failoverretry 5 -failoverdelay 3 -locality LOCAL_ONLY -region_failover

GDSCTL > connect admin/pass@catalog
GDSCTL > connect c##gsm_admin/gsmadmin@GSMTST # Connect to gsmcatuser on catalog

GDSCTL > start gsm -gsm GSM1 # Start listener
GDSCTL > stop gsm -gsm GSM1 # Stop listener
GDSCTL > start service -service gsales_rw
GDSCTL > start service -service emp_report1 -gdspool hr
GDSCTL > stop service -service gsales_ro

GDSCTL > modify gsm -gsm GSM1 -listener 1522 -catalog GSMTST -pwd gsmcatuser # Modify listener
GDSCTL > modify catalog -oldpwd oldpassword -newpwd newpassword
GDSCTL > modify database -database oltp_ch1 -region switzerland

GDSCTL > config database # To check all the changes at region, pool, service and database level
GDSCTL > config
GDSCTL > config region

GDSCTL > services

GDSCTL > remove region -region EMCA
GDSCTL > remove brokerconfig
GDSCTL > remove brokerconfig -gdspool 
GDSCTL > remove service -service gsales_rw
GDSCTL > remove gdspool -gdspool sales

GDSCTL > synchronize brokerconfig -gdspool

GDSCTL > export catalog file_name_with_full_path
GDSCTL > import catalog file_name_with_full_path


Related Oracle RAC Articles: