Yesterday I tested migration of one of the oracle forms 10g release 1 application’s database from Oracle 10g Release 1 to Oracle 11g.

Everything ran smooth and I was able to run my forms and do transaction and so on.

But the problem started when I tried to run reports. When ever I try running any report, it failed and gave me error that it unable to connect to the database.

I was scratching my head where exactly I am going wrong.

When my forms server can connect the database with same setting from conf file then why report server is giving error.

After checking the log and trace file I got following:

REP-501: Unable to connect to the specified database.
[2008/9/27 2:38:28:240] Debug 50103 (JobManager:notifyWaitingJobs): Master job 76257 notify its duplicated jobs.
[2008/9/27 2:38:28:240] Debug 50103 (JobManager:updateJobStatus): Finished updating job: 76257
[2008/9/27 2:38:28:240] State 56004 (EngineInfo:setState): Engine rwEng-0 state is: Ready
[2008/9/27 2:38:28:240] Exception 501 (): Unable to connect to the specified database.
exception oracle.reports.RWException {
oracle.reports.RWError[] errorChain={struct oracle.reports.RWError {
int errorCode=501,
java.lang.String errorString=”Unable to connect to the specified database.”,
java.lang.String moduleName=”REP”
}}
}

I don’t remember setting any other database setting for the reports.

After 4-5 hours of doing my investigation and going around in googling, checking trace and log files again and again.

At last I got to know following fact:

By default, Username and Password are passed to Reports from Forms are in upper case

Bang I was knocked off……………..

Later I found two solutions given by Oracle for this problem as follows:

Solution 1

For forms 10g release 1 or less
Disable Password Case Sensitivity in Oracle 11g
set the SEC_CASE_SENSITIVE_LOGON initialization parameter to FALSE and restart the database.

Solution 2
For forms 10g release 1 ( with Patch 4399342) or above
Add the variable: FORMS_USERNAME_CASESENSITIVE = 1, in application environment file
([ORACLE_HOME/forms/server/default.env] or any custom envFile)

I went for solution 1 as my forms and reports are in 10g Release 1 (without Patch 4399342)

That was great relief and was my time to sleep.

So wished the Good Morning to my Laptop and went for slumber!