Script to update "REMOTE_ORACLE_JDBC_URL" and database connection configuration in RSA Governance & Lifecycle
2 years ago
Article Number
000072166
Applies To

 

  • SecurID Governance & Lifecycle 7.5.2
  • RSA Governance & Lifecycle 8.0
Issue
Updating database connection configuration require performing changes in all files (domain.xml, setDeployEnv.sh, and Aveksa_System.cfg)
 
Resolution
Using attached script changeJDBCUrl.sh, You can change database connection configuration with the below steps instead of updating all mentioned files.
1. Copy attached Script changeJDBCUrl.sh to the SON Node server
2.Change file Permissions and Ownership using the below commands
chmod a+x changeJDBCUrl.sh

chown oracle:oinstall changeJDBCUrl.sh

3. Execute the file using the below command 
sh changeJDBCUrl.sh
Note: You will be promoted to enter the below details
Provide Valid DB IP address or hostname (*mandatory): 
Provide port number [1555]: 
Provide Oracle Service Name [AVDB]: 
4. Restart the server to bring the changes into effect

 
Notes
Original files copied to backup folder: /tmp/aveksa/backupConfig
oracle@acm-vapp:/tmp/aveksa/backupConfig> ll
total 168
-rwxr-xr-x 1 oracle oinstall  11182 Apr 23 21:37 Aveksa_System_20240423_213713.cfg
-rw-r--r-- 1 oracle oinstall 150546 Apr 23 21:37 domain_20240423_213713.xml
-rwxr-x--- 1 oracle oinstall   1449 Apr 23 21:37 setDeployEnv_20240423_213713.sh