I have oracle database server. One core application developed in java. We run that application on JBOSS Server . We are running currently 2 instances.
We have 2 server machines A and B. B is disaster recovery setup for Server A. Oracle DB is at server C.
On 13 August 2015 IT team changed server A date time format. Core application raised Oracle Error.Not a valid month. We run application on DR server its running fine.
Now I checked code lines where the exception occurred, everywhere systimestamp keyword is used.
As core application is running on DR server, application is calling oracle procedure. I am not understanding why if it is an just oracle procedure, if called from Server B no error , and called from Server A oracle raising error. We have reverted all changes done related to Server A date time formatted machine and set date format as required.
Still we are facing same issue.
Please guide me.