Configure an Oracle Wallet with RAC within
The configuration and setup of the Oracle Wallet in is a two-step process. You add descriptors first, then you register the wallet. In the cases of Oracle RAC, your descriptors must enumerate the list of RAC instances that comprise your RAC cluster.
Oracle Wallet prerequisites:
The Oracle wallet location must be accessible from all nodes of the RAC cluster.
Using a shared location is encouraged for maintainability.
An example storage location can be: An Oracle ACFS file system that is mounted on each node or an NFS share accessible to each node. The mount point of the shared location must be the same on each node.
If the wallet is not in a shared location, it must be in an identically duplicate location on each node of the RAC cluster. The full contents of the wallet must also be duplicated on each node of the RAC cluster.
To configure Oracle Wallet with RAC in :
- On the left, click Workloads > Oracle and then click RAC databases.
- Click on the Database name of the RAC you want to configure and view the details.
Copy the Scan name, Service name, and Port.
To view the details of the RAC from the CLI, run nboraadm -list_rac_dbs.
- Copy the RAC instance names of the discovered instances.
To view the RAC instance names of the discovered instances from the CLI, run nboraadm -list_rac_instances.
- Create the connect descriptors for insertion into wallet using the information that is gathered in step 2 and step 3.
Example connect descriptors:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=<INSERT SCAN NAME>)(PORT=<Port number>)) (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<INSERT SERVICE NAME>) (INSTANCE_NAME=<INSERT INSTANCE 1 NAME>)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=<INSERT SCAN NAME>)(PORT=<INSERT PORT>)) (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<INSERT SERVICE NAME>) (INSTANCE_NAME=<INSERT INSTANCE 2 NAME>)))
You must create connect descriptors for each of the RAC instances in the wallet.
- Add the connect descriptors with the Oracle
MKSTOREutility. The descriptors are case-sensitive and must match exactly to what is in .mkstore -wrl /db/orac183/wallet/ -CreateCredential '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=exampleScanName.veritas.com) (PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED) (SERVICE_NAME=orac183.veritas.com)(INSTANCE_NAME=orac1831)))' testUser testPassword
mkstore -wrl /db/orac183/wallet/ -CreateCredential '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=exampleScanName.veritas.com) (PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED) (SERVICE_NAME=orac183.veritas.com)(INSTANCE_NAME=orac1832)))' testUser testPassword
- Register the RAC with the wallet path in using the web UI.
To register the RAC with the wallet path from the CLI, run nboraadm -register_rac_db.
If the RAC is registered for the first time from discovery, you need to include the dbid. From the CLI, run nboraadm -register_rac_db -rac_db_unique_name.
- (Optional) If you get an error when you attempt to register the RAC, review the error message. Compare the descriptors in the error message with what you generated in step 4 and what you inserted into your Oracle wallet.
More Information