I recently inherited an Oracle database running on Solaris. This database was patched to 18.104.22.168 from 22.214.171.124 this past summer. After the last patch was installed it appears that our developers are having problems with CLOB data being updated. The developers put updated data in their app and save it, but the old data is returned. Do we need to change the NLS or database character set or is this another problem? I have done some research, but have yet to find a solution. Any help would be greatly appreciated.
I have never seen this happen with the application of a patchset. Did something else application-related change at the same time? Are there any errors reported in Oracle trace files (udump or bdump) or in any application logs? This appears to be an application issue. If this had been a database upgrade, i.e., Oracle9i to 10g, then I would not be as surprised to see results like this. I would recommend opening a TAR with Oracle Support so their analysts can help you resolve this problem.
Dig Deeper on Oracle E-Business Suite
Can I use /var/opt/oracle/oratab to specify listener information?
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ...
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error:
"Error in invoking target install of makefile /opt/oracle/...../*.mk."