Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle configuration for multiple instances
argosy22_at_my-deja.com wrote:
>
> Hi all,
>
> I am having a problem setting up Oracle to
> run two instances: a 734 instance, and an
> 805 instance. Running on unix - Sun 2.6.
> Each runs 2 databases, a JUNK database, and
> another one that we develop with. So,
> 4 databases running on 2 instances.
>
> There are two different ORACLE_HOMEs, one for
> 734, and one for 805. The .profile for unix user
> oracle has been configured to favor 805.
> So, all paths point to 805 directories.
>
> After reading the newsgroups, I only start
> the 805 listener. The status indicates that all
> four services are started.
>
> If I start the databases as user oracle,
> using dbstart, they all start alright.
>
> However, what I can't do is login to the 734
> databases. The only way that I can get into
> the 734 databases is to log onto Unix as a
> user with the 734 paths in their .profile and:
>
> export ORACLE_SID=JUNK
> (the scott/tiger 734 database)
>
> sqlplus
> username: scott
> password: tiger
>
> I cannot use: sqlplus scott/tiger_at_JUNK
>
> So, the problem seems to be in setting up
> the listener correctly.
>
> The interesting thing about the listener is that
> status will show four service handlers. However,
> if I stop the listener, and then run the status
> command, I get error messages for only 2
> databases.
>
> So far, I have identified five files that
> would potentially need to be modified:
>
> in /apps/oracle/product/805/network/admin
>
> listener.ora
> tnsnames.ora
>
> in /apps/oracle/product/734/network/admin
>
> listener.ora
> tnsnames.ora
>
> /var/opt/oracle/oratab
> - all databases added here.
>
On the server the listener.ora must look like:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dbview)(PORT = 1521)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) )
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc) (ORACLE_HOME = /netsite/database/u01/OraHome1) (PROGRAM = extproc)
(GLOBAL_DBNAME = pbvSysDB) (ORACLE_HOME = /netsite/database/u01/OraHome1) (SID_NAME = pbvSysDB)
(GLOBAL_DBNAME = pbvDB) (ORACLE_HOME = /netsite/database/u01/OraHome1) (SID_NAME = pbvDB)
and on the client site you need to have two entries in the tnsnames.ora, differing only in the SERVICE_NAME field (here: pbvDB and pbvSysDB).
Works good.
Uwe
-- Uwe Schneider - WEB.DE AG - Amalienbadstr. 41 - 76227 Karlsruhe Forschung & Entwicklung - Tel. (+49) 721 94329 832 "In a world without walls and fences, who needs windows and gates?"Received on Tue Aug 15 2000 - 09:37:59 CDT