Re: Listener Question

"stinky" <stankonia_at_stunkitystunk.org> wrote in message news:3CCF6082.3000709_at_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)
> )
> )
>

First, there's absolutely no reason to have a SID_LIST in any 8.1 listener.ora file. 8i instances register themselves with the Listener. All that's needed is the 'ADDRESS' bit. This seems to be a message which is taking a very long time to filter through the general Oracle community.

>
> SQLNET.ORA
>
> NAMES.DIRECTORY_PATH= (TNSNAMES)
>
>
> TNSNAMES.ORA (same in both cases....extraneous stuff excised)
>

I wish you hadn't excised anything. It's impossible to diagnose anything if you strip out bits you *think* are extraneous, when in fact they might not be. I also wish you'd posted both tnsnames.oras and let us work out for ourselves whether they are the same in both cases.

> STINKY817 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = my.ip.add.ress)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = stinky817.world)
> )
> )
>

So STINKY817.world is the name of the database running on a Windows 2000 box at home. And you can connect to it fine using a Unix session from work, but you cannot connect locally at home when using a session on the same Windows 2000 box that the server is running on? Is that correct?

Please re-post both tnsnames.oras without editing anything.

Regards
HJR
>
> 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 - 23:13:54 CDT