Home > IT Answers > Oracle > How to Connect Oracle Forms to Oracle Database
Zt
5 pts.
 How to Connect Oracle Forms to Oracle Database
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



Software/Hardware used:
ASKED: February 21, 2011  1:12 PM
UPDATED: June 6, 2012  9:19 AM
RELATED QUESTIONS
Answer Wiki:
Hi there, 1.Please check tnsnames.ora file for syntax errors and should in the directory $ORACLE_HOMEnetworkadmintnsnames.ora. 2. Set LD_LIBRARY_PATH, SQLPATH and TNS_ADMIN to point to ORACLE_DIRECTORY Rooparish
Last Wiki Answer Submitted:  March 6, 2011  12:04 am  by  Rm1   20 pts.
All Answer Wiki Contributors:  Rm1   20 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Have you defined a connection entry in your TNSNAMES.ORA file ?
Can you post it ?

carlosdl
 63,535 pts.
 

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.

orangehat
 1,445 pts.
 

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

Subhendu Sen
 22,035 pts.
 

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.

Mr. SEA
 130 pts.
 

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

Kasra
 10 pts.