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 -> Multiple instances of Oracle 9i for Linux

Multiple instances of Oracle 9i for Linux

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 23 Jul 2002 15:30:11 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7026826CF@lnewton.leeds.lfs.co.uk>


Have you tried starting the listener as the Oracle user instead of the database user ?
For example, you have users ELO and TELO and ORA9i.

Ora9i is where you have installed Oracle, so login (or su - ORA9i) and 'cd bin'. Now lsnrctl start and see what happens.

Cheers,
Norman.



Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com

-------------------------------------

-----Original Message-----
From: lkostov_at_myrealbox.com (Latchezar Kostov) [mailto:lkostov_at_myrealbox.com]
Posted At: Tuesday, July 23, 2002 10:12 AM Posted To: server
Conversation: Multiple instances of Oracle 9i for Linux Subject: Multiple instances of Oracle 9i for Linux

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 - 09:30:11 CDT

Original text of this message

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