Skip to Main Content

Oracle Forms

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.

Unable to connect Oracle Forms and Reports 12c (12.2.1.4) and Oracle Database 12c

PrathameshPitaleJan 20 2020 — edited Jan 20 2020

Hi,

I am new to Oracle Forms 12c.

I Recently installed oracle forms and reports 12c (12.2.1.4) on Windows 10. Installation went smooth and I am able to open Oracle forms 12c (12.2.1.4) Builder. My 12c database is Up, and i able to connect using SQL Developer, Command line.

I am facing Issue while connecting with database in "Connect" window in oracle forms for compilation.

When I enter connection string for 12c in connect window, I face three issues.

1. when I Enter :

Username = system

password = mypassword

database=orcl

Oracle forms goes in non responding stage and I have to kill It after waiting 15 minutes.

err3.png

2. When I Enter

Username = system

password = mypassword

database=192.168.1.107:1521/orcl

I receive an BLANK Error modal dialog

err1.png

3. When I Enter

Username = system

password = mypassword

database=192.168.1.107

I Receive an Error ORA-12504, TNS:Listener was not given the SERVICE_NAME in CONNECT_DATA.

err2.png

I am able to connect to 11g Express edition database using Oracle Forms 12c.

Username = system

password = mypassword

database=192.168.1.105:1521/xe

I found that You have to add entries in tnsnames.ora of oracle forms, but still I am unable to connect to database through oracle forms 12c.

Please guide me.

This post has been answered by Sarah QA on Jan 20 2020
Jump to Answer

Comments

Processing

Post Details

Added on Jan 20 2020
2 comments
3,942 views