Oracle error ORA-12154 problem Solved

Question

First of all, thank you for your help, here it is
I installed Oracle9i in one directory and Forms & Reports in another... both installations went well; the connection to SQLPLUS works without problems, but the connection to Forms (with the same user/password and database) gives the following error:
"ORA-12154 the symbolic address could not be resolved"
even though I have updated the tnsnames.ora file...
Thank you very much for your help.

aymen · Accepted Answer

you have a tnsnames.ora file in the folder where you installed developer 9i, you need to add the same lines that are in the tnsnames file in the directory where you installed oracle 9i (this is generally located under oracle9i
etwork\adm	nsnames.ora)

François · Answer

It is possible that your setup includes two different installations of Oracle clients. In this case, applications may use either of the installations. Thus, SQL+ may use the configuration of installation 1, which is correct, while Forms uses the configuration of installation 2, which is incorrect.
Search for the tnsnames.ora file on the partition where you install your programs. If you find this file in 2 different trees, then make sure that both files are identical or uninstall the version of the Oracle clients that you are not using.
For your information, the software specifies in the registry which installation of the Oracle clients they are using. However, I cannot help you with which keys to check.

François

Reda · Answer

Well, here it is, I have the same problem.
I just installed Oracle 10g on a G: partition of my PC and Oracle developer (forms, reports) on another E: partition.
From forms, I can't connect to the database.
I looked a bit further in the tnsnames.ora and I admit that I don't understand anything.

G:\oracle\product\10.0.1.0\Db_1\Network\Admin.
In this directory, there are several tnsnames05043012AM1154.bak
with other different numbers.
Thank you for responding.
Rida

sparxnekk · Answer

check ups :

- listeners ??
- hosts files ??

if everything is local, meaning on the same machine, there is a chance that it is just a listener problem.
It is also important to check the environment variables.

(furthermore, be careful, there are several places to put the tnsnames...)

gene__ · Answer

Hello,

I just solved a similar problem... When deploying Apache Tomcat I was getting ORA-12154 and my TNSnames.ora was perfect.

The issue came from my *.properties Java files that define the properties of my databases. I had put the name of the Oracle database instance in a comment at the end of the line, and you shouldn't do that!

I had:

VALKYRIAN.db.user.name=VALORABD1
VALKYRIAN.db.user.password=testpwd # For DEVE

... but it should be:

VALKYRIAN.db.user.name=VALORABD1
# For DEVE
VALKYRIAN.db.user.password=testpwd

There you go...

Gene__

kiatou · Answer

I set everything to localhost and checked my environment variables but still nothing. Help me solve my problem.

ajmi · Answer

@aymen: Thank you very much Aymen for your solution, it helped me a lot.

tufi · Answer

This is certainly the most common Oracle error.  For more information on how to resolve it:  http://turfybot.free.fr/oracle/11g/errors/ORA-12154.html

Oracle error ORA-12154 problem

8 réponses

How to get the character µ on the android keyboard.

Texture issues in enshrouded

Access issue to my "contact me" profile

Windows spotlight is not working.

My tv turns off and then on again repeatedly?

Executable from a python file

Pay in 4 installments cdiscount

The alt gr key is not working on my keyboard.

Code 80072efe how to get windows update working again

Video in ".3gp" format