R3trans Connected to DBMS = ORACLE --- dbs_ora_tnsname = 'ECX' --- SYSTEM =

[Former Member]

Hi there,

I just did Oracle database refresh of our Sandbox (ECX) from Production (ECP), when try to issue the R3trans -d command, and inside the trans.log I see the following entries;

4 ETW000 Connected to DBMS = ORACLE --- dbs_ora_tnsname = 'ECX' --- *SYSTEM = 'ECP'.*

I have already created the new control for ECX and Recovered the database and I am able to start up the database without any problem. I am just concerned about the SYSTEM = ECP value. Where is this valued coming from? Any one has any idea?

Any help much appreciated .

Thanks in Advance

Kumar

[Former Member]

I was able to resolve this issue after bring up the SAP and running the SE06 --> System copy Migrations.

Thanks all for your responses.

[former_member906139]

Hello Sir,

Thanks for update!!!

Regards,

Abhay

[former_member906139]

Hello,

You are able to start DB. Hence please check the DB name by connecting to sqlplus.

select name from V$database;

This should be ECX in your case.

Regards,

Abhay

[Former Member]

did you include the SID change command in sql script while creating the controlfiles ?

For eg.

Replace all occurences of string <source_SAPsid> by <SAPsid> in each line where <source_SAPsid> appears

:g/DPR/s/DPR/DQ2/g

where DPR was production and DQ2 was QA in our case