Re: ORA-12154: TNS: error

From: Craig Oakland <dotacion_at_my.kidney.yahoo.com>
Date: Mon, 18 Oct 1999 15:48:32 -0700
Message-ID: <7ug7hp$rgq@gap.cco.caltech.edu>

Don't attempt to edit the tns file yerself, unless you save a backup. If you have SQL Net Easy Configuration application, use it. Depending on version, it should be located in Start/Programs/Oracle/Oracle for NT.

You will need to know the database instance name, and the server name OR the IP address. See the dba for these if you do not know them.

Once you exit Easy Config, your tns file will have been updated.

Michael Toepfer <michael.toepfer_at_unh.edu> wrote in message news:380B2858.338BE17B_at_unh.edu...
: Hi,
:
: I'm trying to access an oracle database from one NT server to another
: and have received this error message when trying to log onto oracle:
:
:
: SQL*Plus: Release 3.3.4.0.0 - Production on Mon Oct 18 08:10:50 1999
:
: Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
:
: ERROR: ORA-12154: TNS:could not resolve service name
:
:
: I have searched Microsoft's technet database and it states that this is
: an error message when running the
:
: "sqlopen function in a visual basic procedure while several workbooks
: are open in Excel."
:
: Since I have neither Excel or visual basic installed on this machine it
: seems unlikely to be the problem.
:
: Has anyone seen this problem before or have any ideas as to the cause.
:
: Thanks for any help you can give me.
:
:
:
Received on Mon Oct 18 1999 - 17:48:32 CDT