Maybe someone can give me a tip about team testing on different database instances (staging).
Our staging environment:
DEV1 - Database instance for developement
PRE1 - Database instance for integration tests (pre-production)
PRO1 - Database instance for production
We think it might be good to enable the QCTO on all 3 instances. So I can test on DEV1 and also run the same test-case on PRE1.
So I thougt about installing a new repository instance:
REP1 - Database instance for repository
On REP1 I installed the QCTO repository and db-links to DEV1, PRE1, PRO1.
On DEV1, PRE1, PRO1 i created public synonyms to the QCTO objects on REP1.
Now I start QCTO and when connecting on DEV1 or PRE1 or PRO1, following QCTO error appears:
ORA-00604: error occurred at recursive SQL level 1
ORA-00900: invalid SQL statement
(of course it would work when i directly connect to REP1, but thats not what i want)
Actually I dont want to store a repository (with kind of “productive” test-cases) on a developement instance.
This is a problem. We’re in a small environment. Usually our developement team is developing pl/sql code on DEV1. Of course they should also test on DEV1.
On some times, the complete PRO1 database will be copied to DEV1 (kind of initializing).
Does anyone have an idea?