General
cancel
Showing results for 
Search instead for 
Did you mean: 

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

ng_7
Regular Advisor

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

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.
5 REPLIES
Oviwan
Honored Contributor

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

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
Regular Advisor

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

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
Honored Contributor

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

check this about cloning applications environments

http://www.dbspecialists.com/presentations/cloning.html
Patti Johnson
Respected Contributor

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

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

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

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