Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Oracle Forms Call Reports (REP-501 Unable to connect to the specified database)

TiangJan 23 2024

Scenario:
Access Forms Applcation Page using user1/password@devdb successful. Then Login Page using credential that store in table example: userid = appuser1
password = oracle1234!

With those credential success login to the application and try to call reports from the page

Output as below:

Open the trace log:

rwservlet-diagnostic.log

rwEng0-diagnostic.log

the tnsnames.ora is pointing correctly.
$DOMAIN_HOME/config/fmwconfig/tnsnames.ora

The forms able to connect and login using user and password that store in table but when try to call reports its failed to connect database.

This doesn't happen in old environment which forms 12c and database 12c.

After upgrade to database 19c, this was happened.

Any recommended solution?

Thanks.

This post has been answered by Tiang on Jan 30 2024
Jump to Answer
Comments
Post Details
Added on Jan 23 2024
5 comments
123 views