We are having some DB connectibvity problem in HP BSM 9.23. I am getting the below error from the logs:
ERROR - Failed to connect to DB: dbType=(ORACLE Server); hostName=xx.xxx.xxx.com; dbName=HPBSM_RTSM_HISTORY; userName=HPBSM_RTSM_HISTORY; server=xxx.xxx.xx.com; sid=pwd2omc2; port=1521
com.mercury.infra.utils.exceptions.MNoSuchElementException: Failed to borrow object from pool: dbType=(ORACLE Server); hostName=xxx.xxx.xx.com; dbName=HPBSM_RTSM_HISTORY;
I have checked with DB team and they confirmed that there is some issue with SID "pwd2omc2". Now they are askig us to change SID "pwd2omc" in HP BSM. I need your advice whether its enough to change the SID only in "Connect to DB configuration wizard"? or should I need to change it in some other area?
Please assist me.