SUM stuck at MAIN_SHDPREPUT/PARDISTPRE_SHD

[Cinu]

Hi,

We are in the process of updating EHP7 from EHP6 using SUM1.0SP12. During Preprocessing phase- 'MAIN_SHDPREPUT/PARDISTPRE_SHD' we got stuck with following error.

    

now R3trans -d returns 12.

 

Now we can connect to shadow instance-02 but not to our R/3 instance. Trans log says kernel 721 mismatch with DBSL libraries.

Kindly suggest.

Regards,

Cinu

[Cinu · Accepted solution]

Hi,

Here I have attached logs.

Regards,

Cinu

trans.log.txt.zip

SQLSTMTSTD.OUT.txt.zip

[Reagan · Accepted solution]

4 ETW000  [dlux.c      ,00000]  *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/DEV/SYS/exe/run:/usr/sap/DEV/SUM/abap/exe/dboraslib.so") FAILED

4 ETW000                          "/usr/sap/DEV/SYS/exe/run:/usr/sap/DEV/SUM/abap/exe/dboraslib.so: cannot open shared object file: No such file or directory"

Is that file present at the OS level?

ls -la /usr/sap/DEV/SUM/abap/exe/dboraslib.so

ls -la /usr/sap/DEV/SYS/exe/run/dboraslib.so

Cheers

RB

[Cinu · Accepted solution]

Hi Reagan,

dboraslib.so file is present in both locations.

Regards,

Cinu

[Reagan · Accepted solution]

Hello Cinu

If the files are present then check whether they have the right ownership/permissions.

Check if all the kernel files are on the same patch level by running the below command

sapcontrol -nr 00 -function GetVersionInfo

Run ldd dboraslib.so and provide the output

Also check or provide the SQLSTMTSTD.SAV file (Not the one you have attached) to see if it contains more information.

What is the version of the Oracle Client?

cd /oracle/client/11x_64/instantclient

./genezi -v

RB

[Sriram2009 · Accepted solution]

Hi Cinu

1. In which Kernel & DBSL  release ?

2. Could you check this SAP KBA 's

1860519 - SAP fails to connect to the database

1901033 - "R3trans -d" returns no connect possible: "maybe someone set invalid values for DIR_LIBRAR...

BR

SS

[Cinu · Accepted solution]

Hi Reagan,

Good Day,

  

Log file and output for ldd dboraslib.so have attached.

I tried to check kernel files patch level, it gives info for instance 00 and it is 721 patch 201.  Kernel patch level in instance 02 (shadow) shows 742 patch 28. 

Kindly suggest,

Cinu.

ldd dboraslib.txt.zip

SQLSTMTSTD.SAV.txt.zip

[Cinu]

Hi ,

I have changed password for SYSTEM user, SAPSR3 and SAPSR3SHD without special character. Restarted SAP and executed SUM with supplying SYSTEM password in SUM as in SAP note. Unfortunately it failed at same phase and log says same............

Anything I missed in this process... I can connect DB with all the 3 above users using new password.

Regards,

Cinu

[Sriram2009]

Hi Cinu

You have to restart the SUM tool from the beginning. for  that you have to reset the existing SUM.

once again copy the new SUM tool on \usr\sap\ folder start the fresh one.

BR

SS

[Cinu]

Hi sriram,

We have restarted SUM with single system option. We have succeeded in EHP upgrade in test system. Thank you all for your support.

Cinu.....

[Cinu]

Hi,

log attached,

1 ETQ000 ==================================================

1 ETQ399 Executing SQL script '../var/DDXTTSPC.XQL'.

2 ETQ399 Connecting to database 'ORA'.

3EETQ008 Error message: DBSL error 99 (db code -1): Connect failed

4EETQ399 1 [ dbsloci.c,15927]: Connecting as SAPSR3SHD/<pwd>@DEV on connection 0 (nls 0) ... (dbsl 721 231014, UNICODE[2])

4EETQ399 1 [   dboci.c, 4205]:    OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:

4EETQ399 1 [   dboci.c, 4208]:    ORA-01017: invalid username/password; logon denied                                                                           

4EETQ399 1 [   dboci.c, 4990]: OCISessionBegin(con=0, svc=f682f0, srv=f692c8='DEV'): start session of usr=f784a0='SAPSR3SHD', rc=1017

4EETQ399 1 [   dboci.c, 5025]: OCIHandleFree(con=0, svc=f682f0): Free session hdl usr=f784a0

4EETQ399 1 [   dboci.c, 4826]: OCIServerDetach(stale(2) con=0, svc=f682f0): Server srv=f692c8='DEV' detached

4EETQ399 1 [   dboci.c, 4554]: rc=1017 -> Trying to reattach to server 'DEV'

4EETQ399 1 [   dboci.c, 4734]: OCIServerAttach(con=0, svc=f682f0) srv=f692c8 attached to 'DEV'

4EETQ399 1 [   dboci.c, 4205]:    OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:

4EETQ399 1 [   dboci.c, 4208]:    ORA-01017: invalid username/password; logon denied                                                                           

4EETQ399 1 [   dboci.c, 4990]: OCISessionBegin(con=0, svc=f682f0, srv=f692c8='DEV'): start session of usr=f784a0='SAPSR3SHD', rc=1017

4EETQ399 1 [   dboci.c, 5025]: OCIHandleFree(con=0, svc=f682f0): Free session hdl usr=f784a0

4EETQ399 1 [   dboci.c, 4565]: OCIHandleFree(con=0): Service handle svc=f682f0 freed.

4EETQ399 0 [ dbsloci.c,15943]: CONNECT failed with SQL error '1017'

Regards,

CinU

[former_member182657]

Hi Cinu,

You could refer SAP Note  1870519 - Oracle Database Vault and SAP Shadow User (SAP<SID>SHD)

Hope this will also help you.

Regards,

[Cinu]

Hi,

SUM ended up with same error. Does the special character in the password affect the SUM process?

[former_member182657]

Yes try to set password without special char

Regards,

[former_member182657]

Also re share the log DDXTTSPC.LOG.

Regards,

[Sriram2009]

Hi

Reset the SUM Tool and start it's once again fresh

BR

[Cinu]

Hi,

I am trying to reset password of SYSTEM user and SAPSR3SHD with out special char and restart SUM.

Thanks,

Cinu

[former_member182657]

Hi Cinu,

Above SAP note recommended by SS would surely help you,if still facing the issue kindly share updated logs DDXTTSPC.LOG

Regards,

[Former Member]

Hi Cinu,

Version mismatch seems to me like your kernel version and R3trans version in kernel directory are different.

Please replace your R3trans exe same like kernel version and I believe the issue should be fixed.

else paste the below logs:

/usr/sap/DEV/SUM/abap/log/DDXTTSPC.LOG

and

/usr/sap/DEV/SUM/abap/log/EXSTATE01.LOG

Regards,

Nikhil

[Cinu]

Hi,

Now both instances 00 & 02 are up. But still SUM ended up with same error.

Log DDXTTSPC.LOG attached.

Regards

Cinu

DDXTTSPC.txt.zip

[Sriram2009]

Hi Cinu

Could you check the SAP KBA for the error message "ORA-01017: invalid username/password; logon denied "

2067086 - ORA-01017 during SAP Upgrade

BR

SS

[Cinu]

Hi Sriram,

I followed 2067086 - ORA-01017 during SAP Upgrade note and tried connecting oracle using SPASR3SHD and SYSTEM and connected with same password.

We are using SUM1.0 SP12 and "changing the password in the SUM tool to the same password set at oracle level' could not be done here.

Regards,

Cinu.

[Reagan]

Hello Cinu

I faced this issue once during a Java upgrade. I changed the password of the shadow schema to the one used by the SYSTEM user using BR*Tools and it helped.

If there are some special characters in the password then SUM might throw this error.

Have you tried this?

RB

[Cinu]

Hi Reagan,

We do have special char-' $ ' in password. I have changed shadow schema password to the SYSTEM user. Let me start SUM once again & will update.

Thank you so much for your help.

Regards,

Cinu

[Cinu]

Hi,

Selinux file is not existing.

When I check trans.log it says version mismatch between kernel and shared library. 

  

[former_member182657]

Hi Cinu,

SELINUX is not a file,it's related with OS.Could you share the output result for command

sestatus

If result enforcing try to maintain selinux under file /etc/selinux/config and change it to DISABLED or PERMISSIVE.

Regards,

[Sriram2009]

Hi Cinu

I thing your kernel version are not correct,  because the log show two different, better you can download the kernel & DBSL patch  version 7.21 from SMP. and apply and check the upgrade.

BR

[Cinu]

Hi Sriram,

I have changed to dboraslib.so - version 721 and now R3trans -d returns 000. I tried to start instance 00 and it shows started. but I can't connect it from GUI.  Also SUM ended up in same error again.

I think we missed some parameters at initial stage. Looking for valuable suggestions.

[Sriram2009]

Hi

After change the file have you restart the system? once do the full restart and then try, before that check the right ownership & permissions

BR

SS

[Cinu]

Hi,

Not yet restarted. Ownership is correct. Let me restart and will update.

Regards,

Cinu

[former_member182657]

Hi Cinu,

Could you check with SELINUX for the system,should be permissive only.Also make sure system firewall is in disabled mode.In addition to it you could analyze the issue by following SAP Note   403004 - Database connect using R3trans fails

Regards,

[Former Member]

Check env user variables. make sure DIR_LIBRARY contain path of dboraslib.so

and check if dboraslib.so exist in sum/abap/exe with sidadm access if not try to copy this lib from sapmnt/SID/exe and paste in sum/abap/exe/

with sidadm rights.

Hope this help

Christopher Arias

[Cinu]

Hi,

dboraslib.so exists in both locations with sufficient permissions.

[Former Member]

ERROR => Couldn't load library '/usr/sap/DEV/SYS/exe/run:/usr/sap/DEV/SUM/abap/exe/dboraslib.so

check if the file dboraslib.so, is present in sum/abap/exe and at the /sapmnt/<SID>/exe locations?

[Cinu]

Hi,

Here I have attached trans.log and SQLSTMTSTD.OUT logs.

My DIR_LIBRARY = /usr/sap/DEV/SYS/exe/run and dbms_type=ORA.

Yes i did R3trans -d as SIDADM.

Regards,

Cinu

[Sriram2009]

Hi Cinu

Have you attached the log? No log file?

BR

[ashish_vikas]

Attachments are missing.

Regards,

Ashish

[Sriram2009]

Hi Cinu

1.  Could you check the user id - SIDADM variable as mention below

DIR_LIBRARY=/usr/sap/SCC/SYS/exe/run

dbms_type=ORA

2. Are you executing the R3trans -d on SIDADM user id ?

BR

SS

[ashish_vikas]

please share trans.log of main instance & SQLSTMTSTD.OUT from SUM.

Regadrs,

Ashish