Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Multiple instances of Oracle 9i for Linux
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.
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