How to Connect Oracle Forms to Oracle Database

5 pts.
Oracle 10g
Oracle 10g connectivity
Oracle Developer
Oracle Developer 10g
Oracle Forms 10g
I installed oracle 10g personal edition and oracle developer 10g suit in same machine (windows xp sp 3). Every thing working fine, but when connecting forms to oracle database then error message appears Ora-12154 TNS: could not resolve the connect identifier specified. How to solve this problem.

Thanks and regards,



Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi there,

1.Please check tnsnames.ora file for syntax errors and should in the directory $ORACLE_HOME\network\admin\tnsnames.ora.


Discuss This Question: 6  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    Have you defined a connection entry in your TNSNAMES.ORA file ? Can you post it ?
    85,885 pointsBadges:
  • orangehat
    Verify which are using, don't assume it's using the one you think it is. Some programs use the last tnsnames.ora installed (for example maestro uses the ORACLE_HOME for last installed Oracle when running windows 7). You may need to update the tnsnames.ora for both installs.
    2,130 pointsBadges:
  • Subhendu Sen
    To fix the ORA 12154 error.... 1. Check the instance or database name is being typed in correctly. It is sometimes also referred to as the connect string of the database 2. Check the tns names.ora file to validate that the instance name has been entered correctly 3. If everything is okay ! in tnsnames.ora, validate that the domain name entry in sqlnet.ora is not conflicting with the full database name resolution 4. If it not works, try delete and recreate the entry to eliminate any character or control character issues NOTES: If t entry u r looking for in tnsnames.ora is missing, try using the SQL*Net Easy configuration utility One more checking, if u connect to internet and ur tnsnames.ora is set to computer name or some other ip address then also it will give u the same error. Please modify tnsnames.ora with correct IP address
    142,370 pointsBadges:
  • Mr. SEA
    check you TNSNames.ora file, it must be located in Oracle Home Directory>Netowrks>admin. Check Data Source entry, if there is a server name then replace that server name by server IP. Check service name default is ORCL, if you have changed during installation so, change this with that name what you have given at installation.
    130 pointsBadges:
  • Featured Member: Orangehat - ITKE Community Blog
    [...] How to connect Oracle Forms to Oracle Database [...]
    0 pointsBadges:
  • Kasra
    i installed oracle 11g ana oracle maestro.and in maestro i created a database .when i connect to the database maestro show Ora-12154 TNS:.please help me to connect to oracle database
    10 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: