Go to main content
1/13
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Changes in This Release for Oracle Database Global Data Services Concepts and Administration Guide
Changes in Oracle Database 12
c
Release 2 (12.2.0.1)
New Features
1
Introduction to Global Data Services
1.1
Introduction to Global Data Services
1.2
Global Data Services Architecture
1.2.1
Global Data Services Pool
1.2.2
Global Data Services Region
1.2.3
Global Service Manager
1.2.4
Global Data Services Catalog
1.2.5
Oracle Notification Service Servers
1.3
Overview of Global Services
1.3.1
Global Service Attributes
1.3.2
Global Services in an Oracle RAC Database
1.3.3
Global Services in an Oracle Data Guard Broker Configuration
1.3.4
Database Placement of a Global Service
1.3.5
Replication Lag and Global Services
1.3.6
Global Services and Distributed Transaction Processing
1.3.7
Global Services in Multitenant Architecture
1.4
Global Connection Load Balancing
1.4.1
Client-Side Load Balancing
1.4.2
Server-Side Load Balancing
1.4.3
Region Affinity for Global Services
1.4.3.1
Any-Region Affinity
1.4.3.2
Affinity to a Local Region
1.4.3.3
Affinity to a Local Region with Interregion Failover
1.5
Global Run-Time Connection Load Balancing
1.5.1
Affinity
1.5.2
Disk I/O and CPU Thresholds
1.6
Global Services Failover
1.7
Global Service Manager Process Suite Architecture
1.8
Global Data Services Use Cases
1.8.1
Load Balancing for Replicated Databases
1.8.2
Service Failover for Replicated Databases
1.8.3
Region Affinity in Oracle GoldenGate Multi-Master
1.8.4
Load Balancing in Oracle GoldenGate Multi-Master
1.8.5
Balancing Oracle Active Data Guard and Oracle GoldenGate Reader Farms
2
Configuring the Global Data Services Framework
2.1
Planning an Installation
2.2
What You Need to Know About Installing a Global Service Manager
2.3
Installing a Global Service Manager
2.4
What You Need to Know About Upgrading Global Data Services
2.5
Upgrading Global Data Services
2.6
Using GDSCTL
2.6.1
Operational Notes
2.6.2
GDSCTL Command Syntax and Objects
2.6.3
GDSCTL Connections
2.7
What You Need to Know About Creating the Global Data Services Catalog
2.8
Creating the Global Data Services Catalog
2.9
Adding a Global Service Manager to the Global Data Services Catalog
2.10
Connecting to the Global Data Services Catalog
2.11
What You Need to Know About Adding a Global Data Services Pool
2.12
Adding a Global Data Services Pool
2.13
What You Need to Know About Adding a Global Data Services Region
2.14
Adding a Global Data Services Region
2.15
Adding a Database to a Global Data Services Pool
2.15.1
Valid Node Checking for Registration
2.16
Adding a Service to a Global Data Services Pool
2.17
Starting a Global Service
2.18
Database Client Configuration
2.19
What You Need to Know About Exporting the GDS Catalog Data for Logical Backups
2.19.1
Exporting the GDS Catalog Data for Logical Backups
2.19.2
Restoring Logical Backup of the GDS Catalog into the Same Catalog Database
2.19.3
Restoring Logical Backup of the GDS Catalog into a new Catalog Database
2.20
Changing the GSMCATUSER Password
3
Administering Global Data Services Configurations
3.1
Overview of Global Data Services Administration
3.2
Managing Database Pools
3.2.1
Adding Oracle Data Guard Broker Managed Databases to a Database Pool
3.3
Managing Global Services
3.3.1
Creating a Global Service
3.3.2
Starting a Global Service
3.3.3
Stopping a Global Service
3.3.4
Disabling a Global Service
3.3.5
Enabling a Global Service
3.3.6
Modifying Global Service Attributes
3.3.7
Deleting a Global Service
4
Troubleshooting Global Data Services
4.1
Troubleshooting Oracle Error Codes
4.1.1
ORA-01045: user GSMADMIN_INTERNAL lacks CREATE SESSION privilege; logon denied
4.1.2
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
4.1.3
ORA-12516: TNS:listener could not find available handler with matching protocol stack
4.1.4
ORA-12541: TNS:no listener
4.1.5
GSM-45034: Connection to GDS catalog is not established
4.1.6
GSM-45054: GSM error or NET-40006: unable to start GSM
4.2
Solutions for General Issues
4.2.1
Connecting to GDS Configuration Databases When No Global Service Managers Are Running
4.2.2
Connecting to Catalog Databases When No Global Service Managers Are Running
4.3
Obtaining the Running Status of Global Data Services Components
4.4
Viewing Static Configuration Information for Global Data Services Components
4.5
Enabling and Disabling Tracing on a Global Service Manager
4.6
Using Global Service Manager Log and Trace Files
4.7
Using SYS_CONTEXT Parameters in a GDS Environment
A
GDSCTL Commands Used For Oracle Sharding
B
GDSCTL Commands Used For Global Data Services
C
Global Data Services Control Utility (GDSCTL) Command Reference
C.1
add brokerconfig
C.2
add credential
C.3
add database
C.4
add file
C.5
add gdspool
C.6
add gsm
C.7
add invitednode (add invitedsubnet)
C.8
add region
C.9
add service
C.10
add shard
C.11
add shardgroup
C.12
add shardspace
C.13
config
C.14
config chunks
C.15
config credential
C.16
config database
C.17
config file
C.18
config gdspool
C.19
config gsm
C.20
config region
C.21
config sdb
C.22
config service
C.23
config shard
C.24
config shardgroup
C.25
config shardspace
C.26
config vncr
C.27
configure
C.28
connect
C.29
create catalog
C.30
create gdscatalog
C.31
create shard
C.32
create shardcatalog
C.33
databases
C.34
delete catalog
C.35
deploy
C.36
disable service
C.37
enable service
C.38
exit
C.39
export catalog
C.40
help
C.41
import catalog
C.42
modify catalog
C.43
modify credential
C.44
modify database
C.45
modify file
C.46
modify gdspool
C.47
modify gsm
C.48
modify region
C.49
modify service
C.50
modify shard
C.51
modify shardgroup
C.52
modify shardspace
C.53
move chunk
C.54
quit
C.55
recover shard
C.56
relocate service
C.57
remove brokerconfig
C.58
remove credential
C.59
remove database
C.60
remove file
C.61
remove gdspool
C.62
remove gsm
C.63
remove invitednode (remove invitedsubnet)
C.64
remove region
C.65
remove service
C.66
remove shard
C.67
remove shardgroup
C.68
remove shardspace
C.69
services
C.70
set gsm
C.71
set inbound_connect_level
C.72
set inbound_connect_timeout
C.73
set log_level
C.74
set log_status
C.75
set outbound_connect_level
C.76
set outbound_connect_timeout
C.77
set trace_level
C.78
set trc_level
C.79
show ddl
C.80
split chunk
C.81
sql
C.82
start gsm
C.83
start observer
C.84
start service
C.85
status
C.86
status database
C.87
status gsm
C.88
status service
C.89
stop gsm
C.90
stop service
C.91
sync brokerconfig (synchronize brokerconfig)
C.92
sync database (synchronize database)
C.93
validate catalog
C.94
validate
Glossary
Index
Scripting on this page enhances content navigation, but does not change the content in any way.