Re: Oracle7 & Oracle8 on the same server

From: Mareike Ernst <ernst_at_sipri.se>
Date: Fri, 18 Feb 2000 21:15:45 +0100
Message-ID: <38ADA871.835F2888@sipri.se>

Fred,

One can use just listener if one wants... ..well I did and it works :)
However I am using the same oracle user for both dbs and use a little switching logic - I guess otherwise it might not work.

This is what my listener.ora looks like...

# LISTENER.ORA Configuration File:/opt2/v8i/network/admin/listener.ora # Generated by Oracle Net8 Assistant

SAVE_CONFIG_ON_STOP_LISTENER1 = TRUE CONNECT_TIMEOUT_LISTENER1 = 30 LISTENER1 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myhost.mydomain)(PORT = 1521))
(PROTOCOL_STACK =

        (PRESENTATION = TTC)
        (SESSION = NS)
      )

    )
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(PROTOCOL_STACK =

        (PRESENTATION = TTC)
        (SESSION = NS)
      )

  )

SID_LIST_LISTENER1 =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt2/v8i)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = IRSIS)
(ORACLE_HOME = /opt2/v8i)
(SID_NAME = IRSIS)

    )
    (SID_DESC =
(GLOBAL_DBNAME = SIPRI)
(ORACLE_HOME = /opt/oracle7/app/oracle/product/7.3.2)
(SID_NAME = SIPRI)

    )
  )

--
/cheers

Mareike,
the magician_at_sipri.se

(..."Any sufficiently advanced technology is indistinguishable from magic"

• Arthur C Clarke --)

Received on Fri Feb 18 2000 - 14:15:45 CST