Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

we are getting error "REP-501: The specified database cannot be connected" using Forms "Run report o

Giriraj BahediyaJan 20 2020 — edited Jan 23 2020

Hi All,

We are facing "REP-501: The specified database cannot be connected" while generating the report from Oracle forms "Run Report Object".

Oracle forms/reports version - 12.2.1.3

Oracle DB version - 12.2.0.1

These report were working fine the same DB version 12.2.0.1 with compatible parameter set to "12.1" but for same compatible is not working.

Thanks

Giriraj Bahediya

@"Michael Ferrante-Oracle"

Comments

Suresh Sangaran-Oracle

You can find many reasons for RRO with reports seeing REP-501. Few checkpoints to verify.

1. Can you run the report using rwservlet or rwclient by passing same username/password@connect_string used by your Forms?

2. If your username is in upper case, try setting FORMS_USERNAME_CASESENSITIVE =1 in your .env file.

3. Try with simpler passwords

Thanks  - Suresh

Giriraj Bahediya

Thanks Suresh for your reply.

We are using simple password. This seems this issue is related to Oracle DB compatible version changed from 12.1.0.2 to 12.2.0.1.

Please help to resolve this.

Thanks

Giriraj

Have you tried point 1, 2. If that did not help I would suggest to open an Support Service Request for detailed analysis.

- Suresh

1 - 3

Post Details

Added on Jan 20 2020
3 comments
645 views