global data consolidation - aioug · learn the capabilities of gds - 12c global data consolidation...
TRANSCRIPT
Learn the capabilities of GDS - 12c
Global Data Consolidation
Author & Presenter
Nassyam Basha
Oracle ACE Director
Oracle Certified Master 11g
Co-Author of Data Guard 11gR2
Co-Founder of Oraworld Team.
MOSC Certified Guru
OTN Super Hero
Blogger www.oracle-ckpt.com
Writer @Oracle, Toad world, UKOUG
Linkedin: /nassyambasha
Twitter @oracle_ckpt
At Pythian since 2013
Pythian is a global IT services company that specializes
in designing, implementing, and managing systems that
directly contribute to revenue and business success. We
help companies adopt disruptive technologies to advance
innovation and increase agility. Our highly skilled
technical teams work as an integrated extension of our
clients’ organizations to deliver continuous transformation
and uninterrupted operational excellence.
ABOUT PYTHIAN
Top 5% talent worldwide
9 Oracle ACEs
4 Oracle ACE Directors
18 years in business
400+ employees
270+ customers worldwide
HIGHLIGHTS• Traditional services
• Fundamentals of Global Data Services
• Components of Global services framework
• GDS Limitations
• Installation of GSM
• Configuration of GDS
• GDS Administration
• Service Failover Test
LOCAL SERVICE – BACK TO BASICSSQL> exec dbms_service.create_service(service_name=>'HR',network_name=>'CONHR');
SQL> exec dbms_service.start_service(service_name=>'HR');
CONHR =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ORA-C1.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME=CONHR)
)
)
[oracle@ORA-C1 admin]$ sqlplus system/oracle@conhr
...
..
SQL> select username,sid,serial#,status,service_name from v$session where service_name='HR';
USERNAME SID SERIAL# STATUS SERVICE_NAME
---------- ---------- ---------- -------- ------------
SYSTEM 30 52569 ACTIVE HR
SQL>
LOCAL SERVICE – EXAMPLE
LOCAL SERVICES – CONS WITH END TO END
• No Service Load Balancing
• No Service High Availability
• Forget centralized workload management
DA
TA
CE
NT
ER
-1 D
ATA
CE
NT
ER
2
DATA GUARD DATA GUARD DATA GUARD
DATA GUARDGOLDEN GATE
STORAGE MIRRORINGDATA GUARD
LOCAL STANDBY RAC
SINGLE INSTANCE
ADG
SINGLE
INSTANCE
ADG
ADG
RAC RAC (IDLE)
WHY GDS?OE, HR, FIN, COBOL, AE Services CRYSTAL, NVISION, BI Publisher
PSQuery, RAT, Monitor, SQR
CRYSTAL, NVISION, BI Publisher
PSGG, RAT, FINRW, AFSRW
CRYSTAL, NVISION, BI Publisher OE, HR, FIN, COBOL, AE Services
WHAT GDS CAN DO?
• GDS uses distributed framework to centralizes Configuration
Maintenance
Monitoring the GDS configuration
Enables load balancing
Failover for services defined by GDS
Measures network latency
Can manage Local or Geographical data centers
Can be managed with EM12c/13c
GDS ARCHITECTURE
GDS FRAMEWORK & LIMITATIONS
Physical
Components
Logical Components
GSM Configuration
GDS Catalog GDS Pools
GDSCTL(Utility) GDS Regions
Notification servers Global Service
300 Database instances
1000 Global services
20 GDS pools
10 GDS regions
5 GSMs per Region
1000 Mid-tier connection Pool
GDS USERS AND ROLES
GDS Catalog database GDS Target (ex: Primary)
Unlock GSMCATUSER GSMUSER unlock
Change password of GSMCATUSER Change password of GSMUSER
Create GSMADM user
Grant GSADMIN_ROLE to GSMADM
GSM/GDS
• Catalog database can accommodate only one configuration
• Recommends 3 GSMs per Region
• 12.1.0.2 Supports both administrator and policy based databases.
• EM 12.1.0.5 with additional plug-in supported to manage GSM and
fully operated from 13c.
• Highly recommended to have RAC or Data Guard for catalog
database.
• Catalog can be hosted either in RMAN or EM repository server.
• GSM gathers performance metrics from Targets.
GDS VS. DATABASE
• License of either Active Data Guard or Golden Gate
• Must be Enterprise Edition
• Database version should be >= 12.1
• GDS Supports Stand alone, RAC, Exadata
• Either CDB or non-CDB
• No matter heterogeneous or non-heterogeneous platforms
• Support of 3rd party replications
• GDS version should be same or higher than catalog database
• Instances to be start with SPFILE.
DATA CENTER 2DATA CENTER 1
Replica DB
ORACLE GLOBAL DATA SERVICES
Active Data GuardPRIMARY OR
MASTER
Data Guard
LOAD BALANCING
Order Entry &
Reporting
REPORTING
SERVICE
ORDER
ENTRY
SERVICE
Replica
DATA CENTER 2DATA CENTER 1
Replica DB
ORACLE GLOBAL DATA SERVICES
Active Data GuardPRIMARY OR
MASTER
Data Guard
LOAD BALANCING WITH ADG
Order Entry &
Reporting
REPORTING
SERVICE
ORDER
ENTRY
SERVICE
Bi-Repl
GSM FAILURE
Buddy Region
(DESCRIPTION=
(FAILOVER=on)
(ADDRESS_LIST=
(LOAD_BALANCE=ON)
(ADDRESS=(HOST=ORA-C1.localdomain)(PORT=1521)(PROTOCOL=TCP))
)
(ADDRESS_LIST=
(LOAD_BALANCE=ON)
(ADDRESS=(HOST=ORA-C2.localdomain)(PORT=1521)(PROTOCOL=TCP))
)
(ADDRESS_LIST=
(LOAD_BALANCE=ON)
(ADDRESS=(HOST=ORA-X1.localdomain)(PORT=1521)(PROTOCOL=TCP))
)
(CONNECT_DATA=
(SERVICE_NAME=app_engine.psfin.oradbcloud)
(REGION=WESTCAN)))
DATA GUARD WITH GDS
RW
SRV
RPT
SRV
DATA GUARD
DATA GUARD WITH GDS
RW
SRV
RPT
SRV
DATA GUARD
GLOBAL DATA SERVICES
GDS
DATA GUARD WITH GDS
APP ENGINE NVISION RPT
DATA GUARD
GLOBAL DATA SERVICES
GDS
SERVICE FAILOVER - GDS
PRIMARY ACTIVE STANDBY
DATA GUARD
GLOBAL DATA SERVICES
APP ENGINE
NVISION RPT
GDS
ARTICLES• ABC's of Global Data Services - 12c
– http://www.toadworld.com/platforms/oracle/w/wiki/11516.abc-s-of-global-data-services-12c
• Installing, configuring and getting started with GDS - 12c
– http://www.toadworld.com/platforms/oracle/w/wiki/11518.installing-configuring-and-getting-
started-with-gds-12c
• Integrating Global Service Manager (GSM) and Managing Global Data Services (GDS) with EM
Cloud Control 13c
– http://www.ukoug.org/what-we-offer/library/integrating-global-service-manager-gsm-and-
managing-global-data-services-gds-with-em-cloud-control-13c/
• Managing Global Data Services and Failover Test - GDS 12c
– http://www.toadworld.com/platforms/oracle/w/wiki/11581.managing-global-data-services-and-
failover-test-gds-12c
• GSM endpoint not found in GSM.ora
– http://www.oracle-ckpt.com/gsm-endpoint-not-found-in-gsm-ora/GSM endpoint not found in
GSM.ora
• GSM endpoint not found in GSM.ora
– http://www.oracle-ckpt.com/gsm-vs-rac-database-type-vs-patchset
