How to divert the connection of apps to a test database ?

[ng_7]

Hi, my Oracle Application version is 11.5.7 and Database is 8.1.7.
I 've done the database cloning, the details step please refer to attachment. The Test Database is successfully mounted and open but somehow the the connection of apps is to my Production database instead on test database.

[Oviwan]

Hey

have you created a second entry in your tnsnames.ora to the test DB or is there only a entry for your production database?

listener seems to run.

Regards

[ng_7]

thanks for your reply, i have 2 tnsnames.ora, 1 for prod and 1 for test, and the tnsnames.ora for test already change SID to point to TEST, is there other anything i have to set ?

[Oviwan]

check this about cloning applications environments

http://www.dbspecialists.com/presentations/cloning.html

[Patti Johnson]

Did you change the APPS.env to point to the new test database? What is the value of TWO_TASK?

[ng_7]

tamcoapp:/home/appltest# env |grep TWO_TASK
TWO_TASK=TEST
tamcoapp:/home/appltest# env |grep APPL.ENV
APPLFENV=TEST_tamcoapp.env

is point to test already