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.
Can you ping the machine?
Can you TNSPING the listener?
What are the values of ORACLE_SID and ORACLE_HOME environment variables?
What is in your listener.ora, sqlnet.ora, and tnsnames.ora?
What are you using as the Host name when you try to log on?
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Oct 19 2006 - 11:14:42 CDT
