SAP system backup restore

[Former Member]

Environment: HP -UX Oracle 11g

I performed a system restore on PI dual stack system using backup restore method

I created the control file from source system DB is up and running listener is up and running as well but the SAP application is not able to make connection with the DB

I am attaching the Trans.log file and the result of startsap command on console:

Help is appreciated-

------------------------------

startsap

Checking <SID> Database

Database is not available via R3trans

-------------------------------------------

Trying to start <SID> database ...

Log file: /home/<SID>adm/startdb.log

Starting Startup Agent sapstartsrv

OK

Instance Service on host <hostname> started

-------------------------------------------

starting SAP Instance SCS12

Startup-Log is written to /home/<SID>adm/startsap_SCS12.log

-------------------------------------------

/usr/sap/<SID>/SCS12/exe/sapcontrol -prot NI_HTTP -nr 12 -function Start

Instance on host <hostname> started

Starting Startup Agent sapstartsrv

OK

Instance Service on host <hostname> started

-------------------------------------------

starting SAP Instance ASCS11

Startup-Log is written to /home/<SID>adm/startsap_ASCS11.log

-------------------------------------------

/usr/sap/<SID>/ASCS11/exe/sapcontrol -prot NI_HTTP -nr 11 -function Start

Instance on host <hostname> started

Starting Startup Agent sapstartsrv

OK

Instance Service on host <hostname> started

-------------------------------------------

starting SAP Instance DVEBMGS10

Startup-Log is written to /home/<SID>adm/startsap_DVEBMGS10.log

-------------------------------------------

/usr/sap/<SID>/DVEBMGS10/exe/sapcontrol -prot NI_HTTP -nr 10 -function Start

Instance on host <hostname> started

---------------------------------

<hostname>:<SID>adm 28> R3trans -d

This is R3trans version 6.24 (release 721 - 26.09.13 - 20:13:07 ).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE                          --- dbs_ora_tnsname = '<SID>'"

R3trans finished (0012).

--------------------------------

After reviewing trans.log do I have to do SSFS configuration

---------------------------------

Regards,

APS

XQA_Trans.txt.zip

[former_member207186 · Accepted solution]

Hi,

The provided log shows that ORA-01034 issue was encountered. Regarding this you can check the SAP Note 491174 - "Composite SAP note for ORA-01034" for troubleshooting.

Regards,

Bíborka

[Former Member · Accepted solution]

Dear Biborka,

Thanks for the reply I have resolved the issue by changing the secure store password for both ABAP and JAVA stack and then updating the same in the SSFS configuration files.

Thanks