Re: Multiple instances of Oracle 9i for Linux

From: Enkidu Utnapishtim <utnapishtim43NOSPAM_at_hotmail.com>
Date: Tue, 23 Jul 2002 16:41:04 GMT
Message-ID: <3D3D8720.4020004@hotmail.com>

Latchezar,

What you need (I think ... without seeing your listener.ora, you might already do this) to do is to place both SIDs under the same SID_LIST entry in your listener.ora file ... something like:

SID_LIST_LISTENER =
   (SID_LIST =

     (SID_DESC =
       (GLOBAL_DBNAME = ELO)
       (ORACLE_HOME = /somepath)
       (SID_NAME = ELO)
     )
     (SID_DESC =
       (GLOBAL_DBNAME = TELO)
       (ORACLE_HOME = /somepath)
       (SID_NAME = TELO)
     )

   )

Since you said the listener only starts for the listener associated with ORACLE_SID, I think you might have assigned two listeners instead of just one ... something like:

SID_LIST_ELO =
   (SID_LIST =

     (SID_DESC =
       (GLOBAL_DBNAME = ELO)
       (ORACLE_HOME = /somepath)
       (SID_NAME = ELO)
     )

   )

SID_LIST_TELO =
   (SID_LIST =

     (SID_DESC =
       (GLOBAL_DBNAME = TELO)
       (ORACLE_HOME = /somepath)
       (SID_NAME = TELO)
     )

   )

This is a very common "error" when reading the doc set and encountering confusing Net8 terminology. I put "error" in quotes for a reason. Technically, it's not an error ... there is nothing (other than extra resource use) to prevent you from having multiple listeners (as long as you remember to have them listening on different ports ... which is set in the DESCRIPTION entry, usually earlier in your listener.ora).

If I am way off base in guessing what you're asking for, please include a copy of your listener.ora and the output of a 'lsnrctl services' command.

BTW, technically, you don't even need these entries. Databases from 8i and up are supposed to automatically register with the active listener when the database starts up. That's why I'm not sure I'm understanding your question clearly (a very common occurance as I get older <g>).

HTH,
Roger Crowley - DBA - LearningFramework

Latchezar Kostov wrote:
> Hello I was installing Oracle 9i on Mandrake 8.1 and I must run two
> instances of database with different SID. I configure it and I could
> connect to database from sqlplus on the server but I have problem with
> configuration of the listener. I made new listener.ora and
> tnsnames.ora and when I run the listener it work but only for the
> instance which SID is in the $ORACLE_SID of the user running the
> lsnrctl start. The other don't work. As example when I run lsnrctl
> start from user oracle who have $ORACLE_SID=ELO, only the instance for
> SID=ELO work. The other with SID=TELO don't work and vice versa when I
> run it from user toracle who have $ORACLE_SID=TELO.
> Could you give to me some advice or better to send to me a working
> configurations file to could see there where is my mistake.
>
> Latchezar Kostov
Received on Tue Jul 23 2002 - 11:41:04 CDT