Fresh installation of SAP NW 7.4 SR2 with ASE not working after first reboot of server

[Former Member]

Hello everyone,

i installed new installation of SAP NetWaver 7.4 SR2 ABAP stack with ASE database on Linux enviroment. Everything was OK after installation, i made the basic configuration (STC01 > SAP_BASIS_SETUP_INITIAL_CONFIG), but after first reboot of server SAP does not start.

My enviroment:

UNIX/LINUX - Red Hat Enterprise Linux Server release 6.8 (Santiago)

8x vCPU, 8GB RAM, 8GB SWAP

sapbw01:mbwadm 33> dataserver -v

Adaptive Server Enterprise/15.7/EBF 25127 SMP SP136 /P/x86_64/Enterprise Linux/ase157sp136x/3955/64-bit/FBO/Mon Oct 19 19:12:00 2015

In logs i found this error messages:

/usr/sap/MBW/DVEBMGS00/work/dev_disp

Mon Aug 29 21:20:47 2016

CCMS: AlMsUpload successful for /usr/sap/MBW/DVEBMGS00/log/ALMTTREE (1205 MTEs).

CCMS: start to initalize 3.X shared alert area (first segment).

DpCheckPreemptionTicker: created thread for DpPremptionTicker

DpMBufHwIdSet: set Hardware-ID

***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c   1179]

MBUF state ACTIVE

DpMBufTypeMod: MBUF component UP (event=MBUF_DPEVT_UP)

DpMsgProcess: 1 server in MBUF

DpMsCheckServices()

DpMsgProcess: MBUF state is MBUF_ACTIVE

DpMBufReset: state = MBUF_PREPARED

Mon Aug 29 21:20:54 2016

*** ERROR => DpHdlDeadWp: W0 (pid 12346) died (severity=0, status=65280) [dpxxwp.c     1362]

DpTraceWpStatus: child (pid=12346) exited with exit code 255

DpWpRecoverMutex: recover resources of W0 (pid = 12346)

********** SERVER SNAPSHOT 1 (Reason: Workprocess 0 died)

/usr/sap/MBW/DVEBMGS00/work/dev_w0

M Mon Aug 29 21:20:48 2016

M  ThInit: running on host sapbw01

I  MtxInit: 0 0 0

M  calling db_connect ...

B  Loading DB library '/usr/sap/MBW/DVEBMGS00/exe/dbsybslib.so' ...

B  Library '/usr/sap/MBW/DVEBMGS00/exe/dbsybslib.so' loaded

B  Version of '/usr/sap/MBW/DVEBMGS00/exe/dbsybslib.so' is "742.06", patchlevel (0.25)

C  trace file set

C  Callback functions for dynamic profile parameter registered

B  read_con_info_ssfs(): DBSL supports extended connect protocol

B   ==> connect info for default DB will be read from ssfs

C  load of SQLLEN8 SYB library libsybdrvodb8.so successful.

C  dbs/syb/fetchArraySize: 1000

C  database is local: connect_timeout: 3

C  lib_dbsl 742 10/21/2014 16:59:00

C  connection unquiesced

C  dbsybslib.dll patch info

C    SAP patchlevel  0

C    SAP patchno  28

C    Last SYBASE DBSL patchlevel 0

C    Last SYBASE DBSL patchno         25

C    Last SYBASE DBSL patchcomment SYB:  stat stack overflow (2080663)

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 4723]

C  (30294) [HY000] [SAP][ASE ODBC Driver]There is no server listening at sapbw01:4901.

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 4723]

C  (30012) [08001] [SAP][ASE ODBC Driver]Client unable to establish a connection

C  syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART

C  Connection 0 failed using DRIVER={Adaptive Server Enterprise};server=sapbw01;port=4901;uid=SAPSR3;db=MBW;pwd=xxxxxxxxxxx;TextSize=2147483647;FetchArraySize=1000;ReleaseLocksOnCursorC

lose=1;DynamicPrepare=1;UseCursor=2;homogeneousbatch=1;charset=utf8;EncryptPassword=1;EnableLOBLocator=0;app=R3D000 00 comm rd ODBC;logintimeout=3;ProtocolCapture=cap_w0_comm_rd;supress

tdscontroltokens=1;SuppressRowFormat=1;SuppressParamFormat=1;

C

B  ***LOG BV3=> severe db error 30012; work process is stopped [dbsh         1247]

B  ***LOG BY2=> sql error 30012  performing CON [dblink       573]

B  ***LOG BY0=> [ASE Error SQL30294:HY000][SAP][ASE ODBC Driver]There is no server listening at sapbw01:4901.[ASE Error SQL30012:08001][SAP][ASE ODBC Driver]Client unable to establish a

connection [dblink       573]

M  ***LOG R19=> ThDbConnect, db_connect ( DB-Connect 000256) [thDatabase.c 79]

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: db_connect (step TH_INIT, thRc ERROR-DB-CONNECT_ERROR, action STOP_WP, level 1) [thxxhead.c   2392]

M

Thanks for any help.

Best regards

Martin Sagan

[isaias_freitas · Accepted solution]

Hello Martin,

The dev_w0 trace file that you have shared shows:

B  ***LOG BY2=> sql error 30012  performing CON [dblink       573]
B  ***LOG BY0=> [ASE Error SQL30294:HY000][SAP][ASE ODBC Driver]There is no server listening at sapbw01:4901.[ASE Error SQL30012:08001][SAP][ASE ODBC Driver]Client unable to establish a
connection [dblink        573]

This indicates that the work process was unable to connect to the database.

The possible reasons I can think of at this moment are:

• The database is not (fully) started;
• DNS issue (SAP server cannot resolve the IP address of the DB server);
• Firewall (or something else) blocking the connection to the DB server at the port 4901.

Regards,

Isaías

[Former Member · Accepted solution]

Hello Isaías,

database is installed on the same server as the SAP system, firewall is off, nslookup on hostname looks fine. I used typical installation > SAP NetWeaver 7.4 Support Release 2 > SAP ASE > SAP Systems > Application Server ABAP > Standard system

I am new in SAP ASE database, is there any linux command for check status of database? or something for start / stop/ restart?

I think there is probably a problem with the database too.

Best regards,

Martin

[isaias_freitas · Accepted solution]

Hello Martin,

I'm not an ASE expert .

I'm checking with a colleague to see if he can take a look at this thread.

Best regards,

Isaías

[former_member254782 · Accepted solution]

Hello Martin,

You can run the startsap or stardb, that should work.

Also please check the ASE error log probably for your ASE under:

/sybase/MBW/ASE-15_0/install/MBW.log

Also please try to connect in the ASE using isql:

isql -SSID -Usapsa

Your case: isql -SMBW -Usapsa

You may need to add -X in the end, if you has ecrypted password configured, the user password will be asked.

Best Regards,

Pedro

[Former Member · Accepted solution]

Thanks a lot Pedro,

it was easy, just I run command startdb before using command /usr/sap/hostctrl/exe/sapcontrol -nr 00 -function StartSystem

The database is does not start automaticly after start of OS.

Best regards

Martin