Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » ORA-12154:TNS:could not resolve service name
ORA-12154:TNS:could not resolve service name [message #234174] Mon, 30 April 2007 05:30 Go to next message
Messages: 50
Registered: April 2007
Location: Chennai
hi experts,
i have just installed oracle 9i developer suite in my windows xp..when i opened forms builder and tried to connect to the database..i am getting the following error,

ORA-12154:TNS:could not resolve service name

when i give tnsping datbasename in command prompt i am getting the following error..

C:\Documents and Settings\Administrator>tnsping sit

TNS Ping Utility for 32-bit Windows: Version - Production on 30-APR-20
07 14:10:51

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:

TNS-03505: Failed to resolve name

sit is my database name
please help me out to solve this problem ..
thanks in advance
Re: ORA-12154:TNS:could not resolve service name [message #234762 is a reply to message #234174] Thu, 03 May 2007 02:23 Go to previous message
Messages: 180
Registered: January 2006
Location: Pakistan
Senior Member

My dear friend it is Oracle Networking question and it is not the right forum for it. But i m telling u the solution, Please do not continue it on this Applicatin Server forum, ok don't mind please.


U would have to configure alias name in TNSNAMES.ORA file and in SQLNET.ORA tells oracle that what the method Oracle using to connect to database like TNSNAMES, ONAMES, HOSTNAME etc. ok just make an alias in tnsnames.ora file and test it with

tnsping aliasname

Zeeshan Ali AWan
Previous Topic: How to - Question about running App server on Linux
Next Topic: Error running report from Form
Goto Forum:

Current Time: Wed Oct 26 01:11:45 CDT 2016

Total time taken to generate the page: 0.07793 seconds