Re: Listener Question

Not really resolved, though, is it? Use of the "SID" descriptor is deprecated, and is intended for non-8i databases only. Since you are reportedly using purely 8i on all machines, "SERVICE=" should work, and the reasons why it isn't in one case have not yet been discovered or dealt with.

What you have discovered is a quick-fix workaround. Which is fine if that is all you are after, and at least you can get on and do some work; but if you actually want to genuinely resolve the issue, you'll need to dig deeper.

Regards
HJR "stinky" <stankonia_at_stunkitystunk.org> wrote in message news:3CD0909A.30309_at_stunkitystunk.org...
> 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 - 21:37:58 CDT