Home » SQL & PL/SQL » SQL & PL/SQL » -1247467259ORA-12154:TNS:Could not resolved service name
-1247467259ORA-12154:TNS:Could not resolved service name [message #198523] Tue, 17 October 2006 08:54 Go to next message
Messages: 1
Registered: October 2006
Location: Cape town, South Africa
Junior Member
Hi All

We have a system developed with Oracle 8i & Visual Basic 6. Its been installed in user's pc, but now they have change their pc's. Now, when they run that system they are getting the error: -214746725ORA -12154:TNS:Could not resolve service name.

We tried to resolve this by uninstalling the Oracle, and re-install Oracle again in their PC's. But the Problem is still there.

Can somebody ps help me. I need to resolve this soon.

thank you Smile
Re: -1247467259ORA-12154:TNS:Could not resolved service name [message #198565 is a reply to message #198523] Tue, 17 October 2006 12:32 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Ahh... CT.

The PC may have one or more tnsnames.ora files on it depending on how many Oracle products you have installed. The tnsnames.ora file is the usual mechanism for resolving the network address of the database you are trying to connect to. From a DOS window - do a "tnsping <database name>". You should get a similar error to the ORA-12154. It'll should also tell you the path to the tnsnames file it's using. Copy a working version of the tnsnames.ora file from another PC to the problem one and try again. The sqlnet.ora settings (in the same directory) can also have an impact - especially NAMES.DEFAULT_DOMAIN

Determining which tnsnames.ora file gets used can be a long description...
Previous Topic: Trying to Use Foreign Key with Single Field in a Multiple Field Primary Key
Next Topic: passing a variable in sub query
Goto Forum:

Current Time: Mon Oct 24 02:13:15 CDT 2016

Total time taken to generate the page: 0.10737 seconds