Oracle 12c - Das umfassende Handbuch

28.2

Eine GDS-Umgebung aufsetzen

679

Der Client verbindet sich also nicht mehr direkt auf den Datenbank-Server, son-

dern zum GSM-Listener mit dem GSM-Servicenamen. Der GSM leitet Verbin-

dungsanfragen an das entsprechende Ziel innerhalb des Pools und unter

Berücksichtigung des Workloads weiter.

Der Connect String sähe dann in unserem Beispiel wie folgt aus:

/opt/oracle/product/12.1.0/gsm/bin/tnslsnr ifile=/opt/oracle/product/12.1.0/

dbhome_1/network/admin/gsm.ora MITP_LOK SNLSM:7aa50000 -inherit -mode gsm

$ lsnrctl status MITP_LOK

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 22-APR-2014 16:13:55

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(HOST=serv7.dbexperts.com)(PORT=1531)

(PROTOCOL=tcp))(CONNECT_DATA=(SERVICE_NAME=GDS$CATALOG.oradbcloud)))

STATUS of the LISTENER

------------------------

Alias MITP_LOK

Version TNSLSNR for Linux: Version 12.1.0.1.0 – Production

Start Date 22-APR-2014 16:12:31

Uptime 0 days 0 hr. 1 min. 23 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /opt/oracle/product/12.1.0/dbhome_1/network/admin/

gsm.ora

Listener Log File /opt/oracle/diag/gsm/serv7/mitp_lok/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=serv7.dbexperts.com)(PORT=1531)))

Services Summary...

Service "GDS$CATALOG.oradbcloud" has 1 instance(s).

Instance "GSM", status READY, has 4 handler(s) for this service...

Service "_MONITOR" has 1 instance(s).

Instance "MITP_LOK", status READY, has 1 handler(s) for this service...

Service "_PINGER" has 1 instance(s).

Instance "MITP_LOK", status READY, has 1 handler(s) for this service...

Service "MITP_SRV" has 1 instance(s).

Instance "MITP_LOK", status READY, has 1 handler(s) for this service...

The command completed successfully

Listing 28.1: Der GSM-Listener

Hinweis

Aus Gründen der Ausfallsicherheit wird empfohlen, in jeder Region mindestens

drei GSM-Server zu starten.

Kapitel 28

Global Data Services (GDS)

680

Der Parameter »REGION« ist optional, solange es nur eine Region in der GDS-

Konfiguration gibt.

(DESCRIPTION=

(FAILOVER=on)

(ADDRESS_LIST=

(LOAD_BALANCE=ON)

(ADDRESS=(host=serv7.dbexperts.com)(port=1531))

(ADDRESS=(host=serv8.dbexperts.com)(port=1531))

(ADDRESS=(host=serv9.dbexperts.com)(port=1531)))

(CONNECT_DATA=

(SERVICE_NAME=mitp_srv)

(REGION=germany)))

Listing 28.2: Beispiel für einen Client Connect String in einer GDS-Konfiguration