Re: Listener Question

From: stinky <stankonia_at_stunkitystunk.org>
Date: Tue, 30 Apr 2002 23:26:58 -0400
Message-ID: <3CCF6082.3000709@stunkitystunk.org>

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 Tue Apr 30 2002 - 22:26:58 CDT