Stan Brown wrote:
> In <1161265886.154141.76120_at_m73g2000cwd.googlegroups.com> "sybrandb" <sybrandb_at_gmail.com> writes:
>
>
>
>> On Oct 19, 3:13 pm, Stan Brown <s..._at_panix.com> wrote:
>>> I'm in the process of upgrading a number of computers to newer/faster/more
>>> reliable hardware. One of these has an Oracle instance on it. I need this
>>> instance to talk to an Oracle 7 instance on another machine, so I need to
>>> keep the 9.01 Oracle instance on one of the machines being upgraded. This
>>> machine however will have a different hostname, than the one it replaces.
>>> This is running under Linux.
>
>> For an answer you should provide an error number. Crystal balls have
>> worn out here.
>
>
> ORA-12154: TNS:could not resolve service name
>
> BTW, beither machine is naed debian, something I should have clarified in
> my first post.
>
>
well the tnsnames seems to thing that you have wv.com and fas.com as
domain names, my guess is that one of them will be your default domain
in sqlnet.ora and that you are just using the first part of the name to
connect. try the fully qualified name (and indeed picking a domain and
sticking with it).
--
Niall Litchfield
Oracle DBA
http://www.orawin.info/services/
Received on Thu Oct 19 2006 - 13:37:27 CDT
