SID and Java Instance ID related dilema during System Copy

[One_Idea]

Hello,

I am in a dilema while stuck with an issue that may be some of you have come across at one point.

MS SQL 2005 and Win2k3

HISTORY:

There is a system PRD - Production. - SAP SID PRD - DB SID - PRD
There is a system QAS - Test - SAP SID QAS - DB SID - QAS

Now, trying to create another Test system - QA1, which is a copy of QAS - SAP SID QA1 and DB SID - QAS

Here, please note that DB SID is QAS because there was a DB Backup (with detach and Java export method) and I am trying to create a system QA1, using DB of QAS.

Now, there is a 'non-conventional' procedure that can be used by adding the schema in DB and move all tables to added schema. That would make the DB useful for QA1 after attaching, but the DB SID will still remain QAS.

I am able to get to the point where I got the ABAP stack up and running (please note: this is WITHOUT using SAPInst) by changing OS mappings and SIDs.

The questions I have is with Java stack. Java stack is still down primarily because of Instance ID that usually gets generated in a conventional SAPInst way. My system is dual stack and without Java the system cannot be considered as fully functional. So, I was wondering if anyone has come across this situation where I want to know how do I generate/configure Java instance ID, so that I can logon to Configtool and make any necessary changes.

I hope people doing system copies with MS SQL might have been exposed to the scenario above and could guide me on how to do get the system up and running with Java stack.

Any help is highly appreciated.

Thanks,

Shival

[yatinbhatt]

Shival,

As you mentioned that QA1 is a newly created test system and DBSID is QAS, fine. How did you get the J2EE instance without using SAPinst ??

What is the J2EE schema on the DB side ?

Thanks
Yatin

[One_Idea]

Hi Yatin,

On the DB side Java schema is SAPQA1DB. I got the J2EE instance along with the copy of the whole directory structure usr\sap\QAS and then making changes in the configurations as required for ABAP side.

There was a copy previously done by someone else in the same way and now I am having to sort of follow the path. I got upto the point where ABAP is working but Java is giving issues.

Shival

[yatinbhatt]

Shival,

This is a bigger mess than I thought. So you mean, your DBSID is QAS, ABAP is accessed with qas schema name and your J2EE is SAPQA1DB ?

Secondly, why you are saying that you thing the issue is with instance ID and you are not able to login to the configtool ? Can you please clarify some more things you are have gone through ?

Did you change J2EE admin schema name ?

Because technically when you copied over the file system from QAS, and also copied over the DB then you should not have instance ID differences.

If you can describe what all you have done so far, then it would give better idea, if you wish.

I am getting closer getting the scenario, and will be able to help you get pass thru this issue. Please answer all my question.

Thanks
Yatin

[One_Idea]

Hi Yatin,

ABAP schema is also changed to qa1 by some script from DB side.
Basically, I am given a DB dump with DB SID as QAS. The schemas are changed for QA1, i.e. qa1 and SAPQA1DB.
The DB is attached now with MS SQL 2005. DB is working fine as the ABAP stack is also working fine.

Following is how I got to get ABAP working:
Changed all QAS entries with QA1
Changed all souce HOST SERVER entries with that of target HOST SERVER
Install services using sapstartsrv.exe
ABAP is working at this stage
On Java side:
Changed all properties at OS level to that of SID and Host mappings.
You are right about the instance ID differences. They are the same, there is no difference. And I am trying to make it work that way but seems something is still missing.

I appreciate your prompt response.

Shival