R3trans -d not connecting after HANA DB recovery

[Former Member]

Dear HANA Experts, We have BI production server with SID-BIP & BI Quality server with SID-BIQ. HANA databse's SID for BIP system is HAP HANA databse's SID for BIQsystem is HAQ HAP's hostname - ajihanaprd HAQ's hostname - ajihanatst HAP instance number is 00 HAQ instance number is 01 We did HANA DB recovery : We restored HAP's backup on HAQ Recovery was successful without any issue. As per standard step, Now I need to run following command. hdbuserstore -u adm set default : I have tried following combination of above commands, but nothing worked (R3trans -d gives error 0012). Since its bit urgent, so it would be great if you can help me to fix this issue as earliest as possible. On Windows Application Server Host Logged in with user biqadm cd usr/sap/BIQ/hdbclient And executed following commands. Command using HAQ & SYSTEM hdbuserstore -u HAQadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SYSTEM HIThana4us hdbuserstore -u SAPServiceHAQ SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SYSTEM HIThana4us Command using HAQ & system hdbuserstore -u HAQadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 system HIThana4us hdbuserstore -u SAPServiceHAQ SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 system HIThana4us Command using HAQ & SAPBIP hdbuserstore -u HAQadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SAPBIP ajinomoto hdbuserstore -u SAPServiceHAQ SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SAPBIP ajinomoto Command using HAQ & sapbip hdbuserstore -u HAQadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 sapbip ajinomoto hdbuserstore -u SAPServiceHAQ SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 sapbip ajinomoto Command using haq & SYSTEM hdbuserstore -u haqadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SYSTEM HIThana4us hdbuserstore -u SAPServicehaq SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SYSTEM HIThana4us Command using haq & system hdbuserstore -u haqadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 system HIThana4us hdbuserstore -u SAPServicehaq SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 system HIThana4us Command using haq & SAPBIP hdbuserstore -u haqadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SAPBIP ajinomoto hdbuserstore -u SAPServicehaq SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SAPBIP ajinomoto Command using haq & sapbip hdbuserstore -u haqadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 sapbip ajinomoto hdbuserstore -u SAPServicehaq SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 sapbip ajinomoto Command using BIQ & SYSTEM hdbuserstore -u BIQadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SYSTEM HIThana4us hdbuserstore -u SAPServiceBIQ SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SYSTEM HIThana4us Command using BIQ & system hdbuserstore -u BIQadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 system HIThana4us hdbuserstore -u SAPServiceBIQ SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 system HIThana4us Command using BIQ & SAPBIP hdbuserstore -u BIQadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SAPBIP ajinomoto hdbuserstore -u SAPServiceBIQ SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SAPBIP ajinomoto Command using BIQ & sapbip hdbuserstore -u BIQadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 sapbip ajinomoto hdbuserstore -u SAPServiceBIQ SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 sapbip ajinomoto Command using biq & SYSTEM hdbuserstore -u biqadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SYSTEM HIThana4us hdbuserstore -u SAPServicebiq SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SYSTEM HIThana4us Command using biq & system hdbuserstore -u biqadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 system HIThana4us hdbuserstore -u SAPServicebiq SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 system HIThana4us Command using biq & SAPBIP hdbuserstore -u biqadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SAPBIP ajinomoto hdbuserstore -u SAPServicebiq SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SAPBIP ajinomoto Command using biq & sapbip hdbuserstore -u biqadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 sapbip ajinomoto hdbuserstore -u SAPServicebiq SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 sapbip ajinomoto Regards, Sunil Maurya

[Former Member · Accepted solution]

Hi,

I have fixed the issue.

Actually there was not an issue, I did the typing mistake while executing the command.

I did everything right, only mistake was - while executing hdbuserstore command instead of 30115 I typed 30015.

After I executed the command with 30115 everything worked fine.

Regards,

Sunil Maurya

[Former Member]

Sorry,

My message was not properly formatted so attaching it as a text file in proper format.

Regards,

Sunil Maurya

hdbrestore issue on scn.txt.zip

[Former Member]

It seems I executed the commands successfully, but Application server is not able to connect to HANA Database.

Do we need to execute any script after restoring one HANA DB on to another HANA DB ?

I mean any command/script for renaming production schema or SID to Quality Schema/SID.

Regards,

Sunil Maurya