Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Novell to Win2k
The full text of the settings in vol5:oranw734\network\admin is:
NW_DEVL.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (COMMUNITY = spx.world) (PROTOCOL = SPX) (SERVICE = NWSERVER_DEVL) )
The solution apparently is this (from the console command prompt in Novell):
load exp userid=contact/password_at_nw_devl.world
I don't know why I never hit upon the "nw_devl.world" term before. Still doesn't seem "obvious" to me, but I'll take it. Thanks all for helpful hints and clues.
Bill Van Dyk wrote:
> 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 - 09:35:55 CDT
![]() |
![]() |