How to Connect Oracle Forms to Oracle Database

5 pts.
Tags:
Oracle 10g
Oracle 10g connectivity
Oracle Developer 10g
Oracle Developer Suite
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,

Hassan

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.
2. Set LD_LIBRARY_PATH, SQLPATH and TNS_ADMIN to point to ORACLE_DIRECTORY

Rooparish

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Have you defined a connection entry in your TNSNAMES.ORA file ? Can you post it ?
    69,045 pointsBadges:
    report
  • orangehat
    Verify which tnsnames.you 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.
    1,540 pointsBadges:
    report
  • 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
    27,780 pointsBadges:
    report
  • 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:
    report
  • Zt
    [...] How to connect Oracle Forms to Oracle Database [...]
    0 pointsBadges:
    report
  • 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:
    report

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following