IBM Support

Update the oracle home path & DB initialization file path form back end level

How To


Summary

Update the oracle home path & DB initialization file path form back end level

Objective

login to mysql -u root panaces

?1.Updating oracle home path command
?select do9icc_dbname,do9icc_dbsid,do9icc_sidPort,do9icc_orahome from dataset_oracle9i_commonconfig where do9icc_sidIPaddress='192.168.10.26'

?update dataset_oracle9i_commonconfig set do9icc_orahome='/oracle/EBP/121_64' where do9icc_dbsid ='EBP';

?2. updating DB initialization file path
?select do9icc_dbname,do9icc_dbsid,do9icc_sidPort,do9icc_orahome,do9icc_initfiletype,do9icc_initfilepath from dataset_oracle9i_commonconfig where do9icc_sidIPaddress='10.100.101.86';

?3.update dataset_oracle9i_commonconfig set do9icc_initfilepath='/oracle/EBP/121_64/dbs/' where do9icc_dbsid ='EBP';

[{"Business Unit":{"code":"BU051","label":"N\/A"},"Product":{"code":"SUPPORT","label":"IBM Worldwide Support"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB33","label":"N\/A"}}]

Document Information

Modified date:
02 November 2020

UID

ibm10745249

Page Feedback