Actually we are using default Derby DB in WCC 11.4.
But we want to use Oracle DB instead of Derby.
Can we change WCC DB to oracle without reinstalling?
Thanks in advanced
Please refer to this Community post:
North Texas AutoSys User Group Meeting - Derby To Oracle Conversion for WCC
Let us know if you're unable to access the document or above post for any reason.
Some additional notes:
How To Convert a WCC 11.3.x DB to Oracle: https://support.ca.com/us/knowledge-base-articles.TEC1989556.html How to recreate the WCC Schema objects for Oracle: https://support.ca.com/us/knowledge-base-articles.TEC1139224.html
I've solved this problem.
Many thanks for your help.
Thanks for your reply and i've a problem applied wcc_config command to change DB password.
It has successfully done but encountered below issue.
@tomcat32-resource  ERROR #UnlockDatasource #CAnnot get database connection java.sql.SQLException: ORA-01017:
invalid userna,e/passwordL logon denied.
I confirmed DB user and password are correct.
Should i change the passwd to java environment also ?
Regards, WoonGyo Han
It appears the Oracle user password specified with wcc_config is incorrect. Is it Oracle 12c? Does the password have any special characters?
Thanks & Regards,
Retrieving data ...