on 01-03-2008 7:21 AM
Hi,
A Very Happy New Year to all !!
We want to refresh our Test system database with Production data.
ECC 6.0 ABAP + JAVA system.
We will be using Backup-Restore method (BRTOOLS) for the same.
However, the problem is, our Production schema for ABAP and JAVA are SAPMI3 and SAPMI3DB resp. and that for Test are SAPMI2 and SAPMI2DB.
After the database refresh, the schema of Test server will be changed to that of Producion.
We can make the necessary changes for ABAP schema (ops$), however, would like to know, what changes (If any) are to be made for Java schema.
Request your suggetions.
Regards,
Kiran Pol
Hi Kiran
The JAVA schema can be set in the configtool -> secure store -> jdbc/pool/<SID>/User
However i am not fully sure, if you have to change it, i think the information is stored in the database already, so it will be already fine when you do a backup/restore.
Do the test and prod system have the same instance numbers? Otherwise you will have the additional struggle with the ports. For example the dispatchers http/https ports.
Don't forget to change the sidadm env variable dbs_ora_schema as well.
Best regards, Michael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.