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:
- When there is a client calling, it gives the database-name, and the
dispatcher then knows where he has to direct the request
- 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