| ORA-12154:TNS:could not resolve service name [message #234174] |
Mon, 30 April 2007 05:30  |
karthick2809
Messages: 50
Registered: April 2007
Location: Chennai
|
Member |
|
|
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 9.0.1.3.1 - Production on 30-APR-20
07 14:10:51
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
C:\OraHome1\network\admin\sqlnet.ora
C:\OraHome1\network\admin\tnsnames.ora
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  |
zeshanali76
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.
Solution:
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
zesh@inbox.com
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
