Description:
We are in the process of upgrading from CAGEN 8.0 to 8.5 and I am unable to get the Build Tool to recognize Oracle 12c. I have gone over some of the documentation and I am a bit confused as to whether Oracle 12c is supported. I changed the name of the ORASQL11.lib to ORASQL12.lib but I still get the same error. I get the following message:
--- Found TIORADDL.EXE
Database maintenance started
IEFSIGNAL:FAIL
IEFDB Error: Database Install Failed
C:\Program Files (x86)\CA\Gen85\Gen>
Can you please confirm that Oracle 12c client/database is supported?
Resolution:
The TIORADDL.EXE can be rebuilt with Oracle 12c 32 bit client.
If you are using VS2010, the directory you need is C:\Program Files (x86)\CA\Gen85\Gen\VS100
For VS2012, the directory is C:\Program Files (x86)\CA\Gen85\Gen\VS110
1. Open a DOS window and change directory to the correct directory depending on the version of VS you are using.
2. Make sure Oracle_Home is set correctly to the Oracle 12c 32 bit client directory.
3. Run "mkdbs.bat ORACLE12".
Now your TIORADDL.EXE should not fail in the Build Tool.
<OR>
Manually use SQLPLUS to run and install the DDL.