Re: Question on ORA-12154

Hi,

a common error is to forget the domain in the tnsnames.ora (mydb. = or mydb.mydomain.com = should work)

oli

On Tuesday 23 January 2001 20:25, William_Rogge_at_voltek.com wrote:
> I have a 7.3.4 UNIX instance of oracle and an 8.1 PC instance.
> Through tnsping, I can verify I can locate both instances.
> When I start sqlplus on the PC, I am unable to connect to any database
> instance other than the on the PC. TNS always returns the error
> 'ORA-12154; TNS:could not resolve service name'.
>
> My conception was that if the service could be TNSPING'ed it should be
> accessible.
>
> Who knows, it may be the way I am composing the host string. I have tried
> simply the TNS name, and fully qualified name but neither works.
>
> Any assistance would be greatly appreciated.

-- 
---

Oliver Artelt, System- und Datenbankadministration
---------------------------------------------------------------
  cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
   email: oli@cubeoffice.de # web: http://www.cubeoffice.de
---------------------------------------------------------------