Multiple databases

Hello,

I'm pretty frustrated about oracle - I'm sure that there is a solution for my problem, but the manuals are not willing to tell me.

So: We're running Oracle 7.1.2 on a DEC-machine. We would like to have two COMPLETELY separated databases - they don't have to interact, and I don't mind whether they share the same instance (I suppose it's not possible) or not. I just would like to have the situation like:

1. When there is a client calling, it gives the database-name, and the dispatcher then knows where he has to direct the request
2. When I'm connecting with SQL*PLUS / or SQL*DBA, I think I should give the right connect string (user/passwd_at_DB1 or user/passwd_at_DB2), and get then connected to the right SGA.

I have same clues, but nothing works. I wonder if I have to give both SIDs in the /etc/oratab - file, but - when I look at the dbstart - procedure, I get the feeling that not much will happen. They will still set one environment-variable, start an instance, and then overwerite the variable and try to start the other instance. I can't start two instances at the moment. Do I have to set the TWO_TASK - variable ? I don't think so, because the Manual does only say that this setes the default connect-string.

I also read the news-mail from Vikram Goel from yesterday, but sorry: it didn't really help me. I hope I'm specific enough.

Thanx in advance,
Ulf Received on Tue Apr 02 1996 - 00:00:00 CEST