Re: 2 instances looking at the same database

Ya beauty. This is exactly the answer I was looking for. Now that you have spelt it out for me, I realise that perhaps with enough lateral thinking I could have worked this out myself. Sometimes you get too close to the problem and go off on a tangent.

On a final note, is it possible to rename an instance ? Is it as simple as changing the oratab, init{SID}.ora ( and contents ) ?

Thanks again.

"rob" <rob_at_dsdelft.nl> wrote in message news:9h7j34$1e2$1_at_news.tudelft.nl...
>
> > Sounds like it may be a solution. Is it possible to rename an instance ?
> > Would this be an easier alternative ?
>
> Oracle Parallel Server is not something you install to do a few days of
> testing.
>
> If I understand you correctly you can't change the connect string to the
> database of the application you want to test. The easiest way to get
 around
> this would be to create a second entry in the tnsnames.ora on the client
> like this:
>
> TEST1.WORLD =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = orcl)
> )
> )
> TEST2.WORLD =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = orcl)
> )
> )
>
> Both entries point to the same database.
> sqlplus username/password_at_test1
> and
> sqlplus username/password_at_test2
> will connect to the same database.
>
> This way you don't have to change anything on the server.
>
> HTH
> Rob.
>
>
>
>
Received on Mon Jun 25 2001 - 17:10:34 CEST