Re: Multiple databases
Date: 1996/04/02
Message-ID: <4jr0hm$ftf_at_oceanie.shom.fr>#1/1
Ulf Leser <leser_at_mpimg-berlin-dahlem.mpg.de> wrote:
>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
- Your clients (who don't establish UNIX connections one the database server) just need to set TWO_TASK variable and connect to the server. Of course, the need to have a complete Oracle environment on their client machine (with sql*net at least)
- People who can connect on the server have two solutions: they can connect to the database directly or through a sqlnet adaptator (like tcp/ip). In the former case, the set ONLY ORACLE_SID to the correct value, in the latter they set TWO_TASK to the correct value (they can also set ORACLE_SID, but value is overriden). Of course everybody need to have a correct Oracle environment...
Hope this helps
Email me if it is not clear enough.
Laurent CITTON (citton_at_shom.fr)
EPSHOM
13 rue du Chatellier
BP 426
39275 BREST cedex
France Received on Tue Apr 02 1996 - 00:00:00 CEST