Creating the Shard Catalog
Connect to the catalog database server via SSH and create the catalog database using GDSCTL.
[oracle@gsmcat ~]$ export ORACLE_HOME=/u01/app/oracle/product/19.3.0/ gsmhome_1
[oracle@gsmcat ~]$ export ORACLE_BASE=/u01/app/oracle [oracle@gsmcat ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@gsmcat ~]$ gdsctl
GDSCTL> create shardcatalog -database gsmcat.mycompany.mydomain:1521/ gsmcatdb -region region1 -user gsm_admin/Oracle123 -agent_port 8080 -agent_password oracle -chunks 12
Here, gsmcat.mycompany.mydomain is a catalog database server hostname, 1521 is a listener port number, and gsmcatdb is a catalog database service name.
We are planning to use the CREATE SHARD method to add shards to the configuration, which requires the following two additional parameters to be defined while creating a shardcatalog. These parameters are required for Remote Scheduler Agent registration.
•\ –agent_password specifies the password that will be used by the Remote Scheduler Agent to register with the shard catalog.
•\ –agent_port specifies the port number that the agent uses to create an XDB connection to the shard catalog. The default for this parameter is 8080.
Make sure after creating the catalog database that the listener has registered the HTTP endpoint.
[oracle@gsmcat ~]$ lsnrctl status
…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gsmcat.mycompany.mydomain)
(PORT=8080))(Presentation=HTTP)(Session=RAW))
Creating the Global Service Manager
Create the GSM using gdsctl add and start gsm and name it mygsm.
GDSCTL> add gsm -gsm mygsm -catalog gsmcat.mycompany.mydomain:1521/ gsmcatdb -region region1
“gsmcatuser” password:
GSM successfully added
GDSCTL> start gsm -gsm mygsm
GDSCTL> config gsm -gsm mygsm
Name: mygsm
Endpoint 1: (ADDRESS=(HOST=gsmcat.mycompany.mydomain)(PORT=1522)
(PROTOCOL=tcp))
Local ONS port: 6123
Remote ONS port: 6234
ORACLE_HOME path: /u01/app/oracle/product/19.3.0/gsmhome_1
GSM Host name: gsmcat.mycompany.mydomain
Region: region1
Buddy
Setting Up a TNS Entry on the Catalog
Add a TNS entry of the GDS catalog database under the GSM home’s tnsnames.ora file.
/u01/app/oracle/product/19.3.0/gsmhome_1/network/admin/tnsnames.ora
GSMCATDB =
(DESCRIPTION =
(address = (protocol = tcp)(host = gsmcat)(port = 1521)
(CONNECT_DATA =
(SERVICE_NAME = gsmcatdb)
)
)