Re: Oracle8/ODBC connect problem

"PhilC" <news_at_macostech.com> wrote in message news:2c42efef.0109021258.383f0a52_at_posting.google.com...
> I am. I removed the actual IP's from the posting for security reasons.
>
> Here is the LISTNER.ORA file from the system I can't connect to ... any
ideas?
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = system01)(PORT = 1521))
> )
> )
> (DESCRIPTION =
> (PROTOCOL_STACK =
> (PRESENTATION = GIOP)
> (SESSION = RAW)
> )
> (ADDRESS = (PROTOCOL = TCP)(HOST = system01)(PORT = 2481))
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /u01/app/oracle/product/8.1.5)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = dummy)
> (ORACLE_HOME = /u01/app/oracle/product/8.1.5)
> (SID_NAME = dummy)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = webdb.world)
> (ORACLE_HOME = /u01/app/oracle/product/8.1.5)
> (SID_NAME = webdb)
> )
> )
>
> Thanks!
>
> "zhefeng" <zhefeng_at_163.net> wrote in message
news:<9msllh$48m$1_at_news.cz.js.cn>...
> > try to change you servername to ip address,maybe it will work!
> > PhilC <news_at_macostech.com> wrote in message
> > news:2c42efef.0109011703.6136c05a_at_posting.google.com...
> > > I'm trying to use Oracle8 and ODBC to connect to two Oracle Database.
> > > I can connect to ONE, but NOT THE OTHER ... why!? I think this may
> > > have to do with the SERVICE_NAME - see below! (Yes I know about the
> > > different PORTs)
> [removed]

You can not have service_name in tnsnames.ora and sid_name in listener.ora: they need to match.
Please refrain from crossposting next time.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Sun Sep 02 2001 - 16:50:03 CDT