Re: Novell to Win2k

From: Bill Van Dyk <trash_at_christian-horizons.org>
Date: Thu, 13 May 2004 09:04:20 -0400
Message-ID: <40A37254.40602@christian-horizons.org>

I have corrected the tnsnames file to... Actually, I just noticed that it is not "tnsnames.ora" but "listener.ora" which has the setting below (sorry).

  (SID_DESC =
    (SID_NAME = DEVL)
    (ORACLE_HOME = VOL8:ORANW734) Vol8:oranw734\database is the actual location of the database files. I tried both
vol8:oranw734
and
vol8:oranw734\database

Then I tried:

load exp userid=system/manager_at_devl

I still get:

Oracle error 12154
TNS could not resolve service name.

If I type

TNSping devl
from my workstation, I get positive results.

I feel like I'm learning a lot, but not quite the right thing yet.

Jim Kennedy wrote:

>>Should I correct the line in TNSnames to refer to vol8, even though it
>>warns me about messing up SQL*Net configuration? Thanks again. Still
>>trying....
>>
>>
>>
>>
>Correct the tnsnames file.
>Jim
>
>
Received on Thu May 13 2004 - 08:04:20 CDT