Re: 2 instances looking at the same database

> 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 - 16:50:12 CEST