| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12154 : TNS: could not reslove service name
% oerr ora 12154
12154, 00000, "TNS:could not resolve service name"
// *Cause: The service name specified is not defined correctly in the // TNSNAMES.ORA file. // *Action: Make the following checks and correct the error: // - Verify that a TNSNAMES.ORA file exists and is in the proper // place and accessible. See the operating system specific manual // for details on the required name and location. // - Check to see that the service name exists in one of the // TNSNAMES.ORA files and add it if necessary. // - Make sure there are no syntax errors in the file. // Particularly look for unmatched parentheses or stray characters. // Any error in a TNSNAMES.ORA file makes it unusable. See // Chapter 4 in the SQL*Net V2 Administrator's Guide. If // possible, regenerate the configuration files using the // Oracle Network Manager.
It more than likely has nothing to do with the software you have installed. More likely you need to check one of the above-mentioned *Action:'s...
On 14 Jan 2000 08:46:45 GMT, "Emmanuel" <zouzou_at_yahoo.com> wrote:
>Or maybe the listener on the server is not started.
>
>Sybrand Bakker <postmaster_at_sybrandb.demon.nl> a écrit dans l'article
><947835406.24005.0.pluto.d4ee154e_at_news.demon.nl>...
>> Should be an incorrect tnsnames.ora on the client and nothing more.
>>
>> Hth,
>>
>> --
>> Sybrand Bakker, Oracle DBA
>> Narayana Mahankali <nmahankali_at_acm.org> wrote in message
>> news:387EC831.CD07BA05_at_acm.org...
>> > hi ,
>> > i was trying to logon to server containing Oracle 8i from a
>client
>> > machine containing 8.0.5 client software. i was getting the following
>> > error.
>> >
>> > " ORA : 12154 : TNS: Could not resolve the service name"
>> >
>> > I checked the host name and the instance name. they were correct.
>> >
>> > Can someone tell me as to what the problem might be and how i'm
>> > supposed to configure the client system. do i need to reinstall client
>> > 8.1.5 s/w on that machine?
>> >
>> > -roopa.
>> >
>> >
>> >
>> >
>> >
>>
>>
>>
--
Sean Dillon
Oracle Corporation
sdillon_at_us.oracle.com
Reston, VA.
 |
 |