Hi,
first of all, I will like to thank to
Ed Lewis <ELewis_at_rbmg.com>,
Mike D Cross <crossmd_at_mh.uk.sbphrd.com>,
"David J. DeWolfe" <sxdjd_at_java.sois.alaska.edu>
They gave me the hint to configure the listener statically and start/stop
the listeners when booting/halting the machine.
So I have folling listener configuration in /etc/listener.ora:
-----------------------------------------------------------------
ORA7 = (ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=IPC)
(KEY=test7)
)
(ADDRESS=
(PROTOCOL=tcp)
(HOST=prozid1)
(PORT=1521)
)
)
ORA8 = (ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=IPC)
(KEY=test8)
)
(ADDRESS=
(PROTOCOL=tcp)
(HOST=prozid1)
(PORT=1522)
)
)
SID_LIST_ORA7 =
(SID_DESC=
(SID_NAME=test7)
(ORACLE_HOME=/binaries/oracle/7.3.4)
)
SID_LIST_ORA8 =
(SID_DESC=
(SID_NAME=test8)
(ORACLE_HOME=/binaries/oracle/8.0.4)
)
---------------------------------------------------------------------
the hostname of the cluster member is prozid1. The hostname of the
service differs from this and is for client access only. So each
Oracle-DB-Service has its own ip-address and hostname.
An Oracle-DB-Service can have many database running. They share the same
filedomains (we are not using OFA).
At first I configured only a Oracle8 listener on both machines. But with
this version I get problems accessing an Oracle7-DB from the clients.
Error messages about dont getting any shared memory. Im using Oracle 7.3.4
and Oracle 8.0.4.
I hope, my informations will give you a hint to configure Oracle DBs in a
cluster environment.
Bye
Bernd Patolla
\\|//
(o o)
---ooO-(-)-Ooo----------------------------------------------------------
Email : Bernd.Patolla_at_bs.ch Bernd Patolla
Phone : (++41) 61 267 6536 Zentrale Informatik Basel-Stadt
Fax : (++41) 61 264 8000 Postfach CH 4003 Basel
X400 : c=ch;a=admin;p=bs;o=fd;ou1=zid;cn=Bernd Patolla
Received on Fri Aug 21 1998 - 08:38:30 NZST