Re: Listener Question

okay, I resolved the problem. I modified the TNSNAMES.ORA file in the windows environment to look like:

STINKY817.world =
 (DESCRIPTION =
   (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = my.ip.add.ress)(PORT = 1521))    )
   (CONNECT_DATA =
  (SID = stinky81)
   )
 )

For some reason, SQL*PLUS and PL/SQL Developer then allowed me to access my ORacle database on my home machine. It appears they had a problem with the SERVICE_NAME parameter, whereas SQL*PLUS on the Unix box didn't.

Go figure. At any rate it was a good learning experience.

Thanks for the help guys.

stinky wrote:

> Here's my LISTENER.ORA:
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = my.ip.add.ress)(PORT = 1521))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /u01/app/oracle/product/8.1.7)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = stinky817.world)
> (ORACLE_HOME = /u01/app/oracle/product/8.1.7)
> (SID_NAME = stinky817)
> )
> )
>
>
> SQLNET.ORA
>
> NAMES.DIRECTORY_PATH= (TNSNAMES)
>
>
> TNSNAMES.ORA (same in both cases....extraneous stuff excised)
>
> STINKY817 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = my.ip.add.ress)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = stinky817.world)
> )
> )
>
>
> Thanks!
>
> P.S. I noticed in my $ORACLE_HOME/network/admin directory the
> following files:
>
> listener02042811PM4228.bak
> sqlnet02042811PM4228.bak
> tnsnames02042811PM4228.bak
>
> There are several others. Are these files written there because I
> connected to the database remotely from work? If so, is there
> anyway I can route these to a different directory?
>
>
>
> Howard J. Rogers wrote:
>
>> You'll need to post a copy of your listener.ora, your tnsnames.ora
>> (both the
>> one you say works and the one you say doesn't) and a copy of your
>> sqlnet.ora
>> before any meaningful reply can be given. The IP address is irrelevant,
>> because the issue is not one of connectivity to the Listener, but of
>> what
>> the Listener is listening out for, compared with what you are
>> requesting to
>> connect to.
>>
>> Regards
>> HJR
>>
>>
>> "stinky" <stankonia_at_stunkitystunk.org> wrote in message
>> news:3CCF3B47.1030702_at_stunkitystunk.org...
>>
>>> I have Oracle Enterprise Edition installed on a PC at home. I run the
>>> listener and am able to connect from work. Well, that is....I can
>>> connect from work when I'm on a unix box. When I try to connect from
>>> the Windows environment (2000), it doesn't work....even though the
>>> TNSNAMES.ORA file is the same in both cases.
>>>
>>> I'm getting a ORA-12514 (Listener could not resolve SERVICE_NAME),
>>> which
>>> I know can't be right since I'm able to connect from the unix box.
>>> Obviously, my LISTENER.ORA file is set up correctly at home. I
>>>
>>>
>>> Why do you think I'm unable to connect from the Windows
>>> environment? Do
>>> you think it's a difference between the IP stacks?
>>>
>>> By the way, my company has both my Windows PC and Unix box under
>>> 172.16.x.x addresses.
>>>
>>
>>
>
>
Received on Wed May 01 2002 - 20:04:26 CDT