ERP ECC 6.0 without EHP to EHP 7 + Unicode - DBSL Version missmatch

[DieterLorenz]

Environment: ERP ECC 6.0, latest 721ex Kernel, Oracle 11.2.4, Linux Suse 11 SP2

Hello together,

after copy the kernel to SUM test the DB connectivity, get an error from R3trans . Get the Kernel 742_28 and test 742_30 non Unicode the result was the same error:

4 ETW000 ./R3trans version 6.25 (release 742 - 11.02.15 - 14:06:42).

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time   : 11.03.2015 - 12:15:02

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: ./R3trans -d

4 ETW000  trace at level 2 opened for a given file pointer

4 ETW000  [     dev trc,00000]  Wed Mar 11 12:15:02 2015                                                 120  0.000120

4 ETW000  [     dev trc,00000]  db_con_init called                                                        32  0.000152

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): usage of ssfs switched off (rsdb/ssfs_connect=0)

4 ETW000                                                                                                  51  0.000203

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  14  0.000217

4 ETW000  [     dev trc,00000]  create_con (con_name=R/3)                                                  9  0.000226

4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/PSB/SYS/exe/run/dboraslib.so' ...            56  0.000282

4 ETW000  [     dev trc,00000]  DlLoadLib() success: dlopen("/usr/sap/PSB/SYS/exe/run/dboraslib.so"), hdl 0, count 1, addr 0x1696ea0

4 ETW000                                                                                               17375  0.017657

4 ETW000  [     dev trc,00000]  Library '/usr/sap/PSB/SYS/exe/run/dboraslib.so' loaded                    33  0.017690

4 ETW000  [     dev trc,00000]  function DbSlExpFuns loaded from library /usr/sap/PSB/SYS/exe/run/dboraslib.so

4 ETW000                                                                                                  27  0.017717

4 ETW000  [dbcon.c     ,00000]  *** ERROR => Version mismatch between executable (742.06) and DBSL shared library (721.02)

4 ETW000                                                                                                 198  0.017915

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/PSB/SYS/exe/run') or dbms_type ('ORA')"

Copy new tp, lib_dbsl, R3trans in the SUM Kernel directory start test again with R3trans -d. This solved the problem not !

Can anybody help ? Thanks a lot

[Former Member · Accepted solution]

Hi Dieter,

Did you solved this issue.

for me also same issue during Ehp7 upgrade and im stuck up here.

Please share the solution if you already solved.

thanks

[DieterLorenz · Accepted solution]

Hello,

no, the customer wanted to have EHP 6 this works without ssfs. Contact the SAP Support.

[DieterLorenz · Accepted solution]

Found this note http://service.sap.com/sap/support/notes/1904826

[Former Member]

Hi Dieter,

AS from the error log i can see that the issue with wrong DBSL library extracted,

4 ETW000  [     dev trc,00000]  DlLoadLib() success: dlopen("/usr/sap/PSB/SYS/exe/run/dboraslib.so"), hdl 0, count 1, addr 0x1696ea0
4 ETW000                                                                                               17375  0.017657
4 ETW000  [     dev trc,00000]  Library '/usr/sap/PSB/SYS/exe/run/dboraslib.so' loaded                    33  0.017690
4 ETW000  [     dev trc,00000]  function DbSlExpFuns loaded from library /usr/sap/PSB/SYS/exe/run/dboraslib.so
4 ETW000                                                                                                  27  0.017717
4 ETW000  [dbcon.c     ,00000]  *** ERROR => Version mismatch between executable (742.06) and DBSL shared library (721.02)
4 ETW000                                                                                                 198  0.017915
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/PSB/SYS/exe/run') or dbms_type ('ORA')"

So request you to get the latest DBSL library files from Service marketplace and extract in your exe directory /usr/sap/PSB/SYS/exe/run/.

Also all the files under exe directtory should be same like in path mentioned earlier by serhat

/usr/sap/PSB/SYS/exe/run/

/sapmnt/PSB/exe

&

/usr/sap/PSB/DVM*<Instance Nr>/exe

Do let us know once you do that.

Regards,

Ram

[DieterLorenz]

SAP System is running. R3trans -d, R3trans -X and brconnect are running fine.

If I start SUM:

4 ETW000 TRACE-INFO: 98:  [dbsloci.c   ,00000]  *** ERROR => CONNECT failed with SQL error '1017'	14  0.150589
4 ETW000 TRACE-INFO: 99:  [	dev trc,00000]  -->oci_get_errmsg (con=0, rc=1017)	7  0.150596
4 ETW000 TRACE-INFO: 100:  [	dev trc,00000]	OCIErrorGet() -> SQL error code: 1017	7  0.150603
4 ETW000 TRACE-INFO: 101:  [	dev trc,00000]  ORA-01017: invalid username/password; logon denied

Set SAPSR3 Passwort with brconnect, sql and ssfs new.

Upgrade Kernel of the SAP Instance and renew tp and R3trans

The path

/usr/sap/PSB/SYS/exe/run/

/sapmnt/PSB/exe

are the same.

I have no ideas

[Former Member]

Hallo Dieter,

Try this and be sure if the PW you gave is correct indeed:

oraSID > sqlplus SAPSR3/PASSWORT

Gruß.

Serhat

[DieterLorenz]

sqlplus SAPSR3/PASSWORT works fine !

SUM use already the OPS$User

4 ETW000 TRACE-INFO: 26:  [

dev trc,00000]  Logon as OPS$-user to get SAPSR3's password

On the old System with OPS$ Login, test sqlplus / in oracle user context and can login.

With the ssfs mechanis this does not work and reports:

ERROR:

ORA-01017: invalid username/password; logon denied

I cannot belive !

[Former Member]

Hallo Dieter,

It seems that you have not identical files under those paths:

/usr/sap/PSB/SYS/exe/run/   und

/sapmnt/PSB/exe/  .

Stop all running instances and upgrade processes and delete the files under /usr/sap/PSB/SYS/exe/run/ . Then copy all of the files from

sapmnt/PSB/exe/   and paste under  /usr/sap/PSB/SYS/exe/run/ . Start the instance(s) and try again.

That command would also be executed:

cleanipc <SystemNummer> remove

Regards,

Serhat

[DieterLorenz]

The Kernel is synchron.

R3trans is working, Brtools also.

Now had the problem, hat is rsdb_ssfs_connect = 0 if I login als sidadm user. But I edit the .sapenv.sh .sapenv.csh .profile .bashrc .login profile and set the rsdb_ssfs_connect = 1.

Strange ...

sapcontrol -nr 01 -function GetEnvironment also

rsdb_ssfs_connect = 0

[Former Member]

Hi Dieter,

As I understand your kernel problem is over, right? If so, please share the solution.

For the SSFS, I had created a document before :

You can have a look at there.

I think (Hinweis 1639578) you should have parameter rsdb_ssfs_connect with value "1" in DEFAULT.PFL file.

Check your profile files (.*env*sh files) once again, both under /home/SIDadm and oraSID home.

That command would work:

grep -i ssfs .*env*sh

Kind regards,

Serhat

[DieterLorenz]

Thanks Serhat,

the grep was very helpfull. But he always wants do connect with OPS$

Oracle parameter is: REMOTE_OS_AUTHENT = false

Logon as OPS$-user to get SAPSR3's password

C  Connecting as /@PSB on connection 0 (nls 0) ... (dbsl 721 231014, non-unicode)

C  OCIServerAttach(con=0, svc=x58bd1d8) srv=x58be5b0 attached to 'PSB'

C     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:

C     ORA-01017: invalid username/password; logon denied            

[former_member182034]

hi Dieter,

Just execute below command with required parameters and above issue will be resolved

brconnect -u system/<password> -f chpass -o <sapowner> -p <password>

If you still face issue then follow the instruction of below SAP note.

1576837 - ORA-01017: invalid username/password;

Regards,

[Former Member]

Hi Dieter,

Please check also these 2 important notes about the subject:

1622837 - Secure connection of AS ABAP to Oracle via SSFS

1639578 - SSFS as password storage for primary database connect

For the error "ORA-01017: invalid username/password; logon denied" , update those user(s)' passwords with that command. Connect to your db as admin:

1-oraSID: sqlplus / as sysdba

2-SQL> alter user <USERNAME> identified by <PASSWORD> account unlock;

Then try the password whether it works or not:

3-oraSID: sqlplus <USERNAME>/<PASSWORD>

Regards,

Serhat

[ricardocarrega_filho]

Thanks a lot for your suggestion, Serhat! It helped me.

Regards,

Ricardo

[manumohandas82]

Hi Dieter ,

Dont think this is the issue .

Either you are executing R3trans from the wrong directory ( as you might be in the middle of the upgrade ) or your kernel version is not right ?

Why are you trying R3trans now ? Did the SUM upgrade stop ?

Thanks ,

Manu

[manumohandas82]

Hi Dieter ,

Please provide more details  on what stage of the upgrade you are in  .

Is your source system unicode or non unicode ?

Thanks ,

Manu

[DieterLorenz]

Hello,

my source system is non unicode. Find out, that are secure store are mandatory because kernel 740 cannot connect to OPS$ User. Checked the documentation

Find error in DBBCONNCHK.LOG in SUM/log

Change the Oracle System to SSFS and kick the OPS$ User out of the database.