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

Giriraj Bahediya

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

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/[email protected]_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

Suresh Sangaran-Oracle

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

- Suresh