Script to update "REMOTE_ORACLE_JDBC_URL" and database connection configuration in RSA Governance & Lifecycle
Last Modified: 2024-05-07
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

 

Related Articles

Trending Articles

Don't see what you're looking for?