Re: Oracle8/ODBC connect problem

From: PhilC <news_at_macostech.com>
Date: 2 Sep 2001 13:58:04 -0700
Message-ID: <2c42efef.0109021258.383f0a52@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] Received on Sun Sep 02 2001 - 15:58:04 CDT