Upgrade MAXDB 7.8

[Former Member]

Hi All,

We are working on the DB upgrade from MAXDB 7.7 to 7.8 in our landscape, and all went well with the upgrade tool. Version and Client got upgraded successfully as well

Landscape : RHEL 6, MAXDB 7.8 (upgraded from 7.7) - ECC 6 with EHP4

Also a  post activities I have also logged into the sidadm and sqdadm users in the system. But after that when I try to start SAP, its not comming up ( Actually there is a problem with the DB and its not coming up). Its stating that

Checking ADA db Database

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

ERR 11311  IPC      idfile: 'UserProfileContainer(stat)' open error, No such file or directory

Database is not available via R3trans

Running /usr/sap/SID/SYS/exe/run/startdb

Trying to start database ...

Log file: /home/sidadm/startdb.log

Database already running

/usr/sap/SID/SYS/exe/run/startdb completed successfully

When I try with R3trans -d - ( Return code is 0012) and below is the logs as well

ETW000  [     dev trc,00000]  INFO : SQLOPT= -I 0 -t 0 -S SAPR3                                         17  0.005219

4 ETW000  [     dev trc,00000]  Try to connect (DEFAULT) on connection 0 ...                              35  0.005254

4 ETW000  [    dbsdbsql,00000]  *** ERROR => Connect to database failed, rc = -10709 (Connection failed (RTE:[1] cannot cr

eate communication semaphore))

4 ETW000                                                                                                1300  0.006554

4 ETW000  [     dev trc,00000]   -> SetSapdbCA(errcode=4294956587)                                        10  0.006564

4 ETW000  [     dev trc,00000]   -> freeConnection(con_hdl=0)                                             12  0.006576

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0x3956500, size=608 (1162224 bytes allocated))             36  0.006612

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0x39524b0, size=1936 (1160272 bytes allocated))            28  0.006640

4 ETW000  [     dev trc,00000]  } DbSlSdbConnect(rc=99)                                                    9  0.006649

4 ETW000  [    dblink  ,00433]  ***LOG BY2=>sql error -10709 performing CON [dblink#4 @ 433]              23  0.006672

4 ETW000  [    dblink  ,00433]  ***LOG BY0=>Connection failed (RTE:[1] cannot create communication semaphore) [dblink#4 @

433]

Action taken :

I have replaced the DBENV.SH files in the home directory of sidadm as per the note - 1066891

Also gone through the note - 1353266 () section 3 and 3 points, exactly matched my problem and hence I have done the same, by removing the LD_LIBRARY_PATH and placing the DBENV.SH

3. UNIX/Linux
If you entered the path for SQLDBC, that is, <INDEP_PROG_PATH>/lib[/lib64] (for example, /sapdb/programs/lib) *manually* in the environment of the user <sid>adm and/or sqd<sid> for one of the variables LD_LIBRARY_PATH, SHLIB_PATH, or LIBPATH when using SAP Kernel 640_EX2, remove this entry and install the DBENV files (.dbenv) that are provided with SAP Note 1066891 instead.
Otherwise, in the environment variables mentioned above, this *old* path for SQLDBC will lead to the following database connection error in the dev traces and/or the file trans.log (during the connection test using R3trans -d) because the SQLDBC of the legacy installation is used instead of the new SQLDBC of the isolated client installation CL_<SAPSID> after you upgrade to MaxDB Version 7.8:
  ERROR => Connect to database failed, rc = -10709
  (Connection failed (RTE:cannot create communication semaphore))

Let me know if anyone has any suggestion / comments about it

Regards

Vijay

[former_member229109]

Hello,

Please check the SAP Note No. 1727986.

What SAP kernel version do you have on your system?

Post output of "sdbregview -l" command, run it on application server.

Did you create SAP message where this issue was reported?

Regards, Natalia Khlopina