Oracle Sharding Workshop
In this interactive section, we will present detailed instructions and real-life scenarios showcasing the implementation of Oracle Sharding with GDS. This practical approach will equip you with the necessary tools and commands to apply sharding techniques in your own environments. At the end of this section, you will have the opportunity to validate the methodology, ensuring the completeness of your setup.
You will need five servers to set up a lab environment.
•\ gsmcat: Shard catalog database (gsmcatdb) and shard director
•\ prsh01: Primary shard database server
•\ prsh02: Primary shard database server
•\ stsh01: Standby read-only shard database server for prsh01
•\ stsh02: Standby read-only shard database server for prsh02
Configuration Steps
Install the Oracle Database 19c (19.3) database software on all database and catalog servers.
Note While writing this chapter, the bug that interferes with shard registration on the agent is still not corrected in Oracle Database 19c (19.17). If you have the Oracle Database 19c (19.17) RDBM software on the catalog server and you try to register a shard server with the agent, you may get the following error:
[oracle@prsh01 bin]$ schagent -registerdatabase gsmcat. mycompany.mydomain 8080
Agent Registration Password ? *******
Failed to get agent Registration Info from db: DB agent registration version is not supported for this agent
If you downgrade the catalog server software to 19.03, then the registration will be successful.
So, keep Oracle Database 19c (19.3) on all servers until the bug is corrected.
Installing the GSM Software
On gsmcat, we are choosing to co-locate the shard director software on the same host, which requires installing the 19c GSM software on a separate Oracle home. Here are the steps for installing the GSM software:
\ 1.\ Download the GSM software for your platform from http:// www.oracle.com/technetwork/database/enterprise-edition/ downloads/index.html.
\ 2.\ Under the Oracle Database 19c (19.3) – Enterprise Edition section, click See All.
\ 3.\ Download the GSM software (LINUX.X64_193000_gsm.zip) and place it on the GSM server under the /u01/install directory.
\ 4.\ Unzip the GSM media and run runInstaller.
[oracle@gsmcat install]$ cd gsm/
[oracle@gsmcat gsm]$ ./runInstaller
When prompted, fill in the following fields:
•\ Oracle base: /u01/app/oracle
•\ Sofware location: /u01/app/oracle/product/19.3.0/gsmhome_1
When you see a pop-up window, connect to the server via SSH and run the requested .sh scripts via the root user. Then return to the installation and click OK.
[root@gsmcat ~]# /u01/app/oracle/product/19.3.0/gsmhome_1/root.sh