Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle configuration for multiple instances

Re: Oracle configuration for multiple instances

From: Uwe Schneider <us_at_webde-ag.de>
Date: Tue, 15 Aug 2000 16:37:59 +0200
Message-ID: <399955C7.DB326007@webde-ag.de>

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)

    )
    (SID_DESC =
      (GLOBAL_DBNAME = pbvSysDB)
      (ORACLE_HOME = /netsite/database/u01/OraHome1)
      (SID_NAME = pbvSysDB)

    )
    (SID_DESC =
      (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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US