Dispatcher Not Starting after Restart

[Former Member]

Hi All,

After restarting sap dispatcher is not coming up kindly find attached log.

any help appreciated...

Regards,

Videesh

DEV_DISP0.txt.zip

WP_0.txt.zip

[Former Member]

Hi All,

We have restored db after that it started working fine.

Thanks for your responses.

Regards,

Videesh

[former_member182657]

Hi Videesh,

Kindly close the thread.

Regards,

Gaurav

[Former Member]

Hello Videesh,

Please attach the dispatcher logs as well.

Thanks

-Rishabh

[former_member182657]

Hi Videesh,

Log is fine now,could you please start the instance again and share the dev_w0 log file.

Regards,

Gaurav

[Former Member]

Dear Gaurav,

Please find the dev_wp0 log.

Regards,

Videesh

dev_w0.txt.zip

[former_member182657]

Hi Videesh,

Could you re share the results for R3trans -d and post the trans.log file as well.

Regards,

Gaurav

[Former Member]

Hi Gaurav,

PFA latest trans log.

r3trans_1.txt.zip

[former_member185239]

Hi Videesh,

You need to set the SSFS

dev trc,00000]  RSecSSFs: SSFS-4215: Data file "/usr/sap/MEQ/SYS/global/security/rsecssfs/data/SSFS_MEQ.DAT" exists, but does not contain the requested entry [/bas/741_REL/src/krn/rsec/rsecssfs.c 4393]

4 ETW000                                                                                                  65  0.157048

4 ETW000  [     dev trc,00000]  RSecSSFs: SSFS-4218: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage [/bas/741_REL/src/krn/rsec/rsecssfs.c 4403]

4 ETW000                                                                                                  43  0.157091

4 ETW000  [     dev trc,00000]  RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 1 (message: SSFS-4218: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage <-- SSFS-4215: Data file "/usr/sap/MEQ/SYS/global/security/rsecssfs/data/SSFS_MEQ.DAT" exists, but does not contain the requested entry) [/bas/741_REL/src/krn/rsec/rsecssfs.c 1220]

Also do add the environment variable

At the end of the file add lines :

setenv RSEC_SSFS_DATAPATH /usr/sap/$SAPSYSTEMNAME/SYS/global/security/rsecssfs/data

setenv RSEC_SSFS_KEYPATH /usr/sap/$SAPSYSTEMNAME/SYS/global/security/rsecssfs/key

setenv rsdb_ssfs_connect 1

Logoff and logon again and check if parameters are activated

Remove the oracle parameter from the spfile<DBSID>.ora

OS_AUTHENT_PREFIX and REMOTE_OS_AUTHENT .

Then try to take a restart of the system.

With Regards

Ashutosh

[Former Member]

Hi Ashutosh,

Thanks for your response,

All the the required environments were already defined and also executed rsecssfx as per the link you have provided and still the same issue continues.

Regards,

Videesh

[divyanshu_srivastava3]

Do R3trans -d and share the results.

[divyanshu_srivastava3]

Have you just upgraded your kernel ?

If yes, are you sure you have used SAPEXEDB of your OS and not the one from windows ?

[Former Member]

Hi Divyanshu,

Thanks for your reply, PFA for trans log

and we have upgraded kernel after the issue raises, and we have selected correct kernel for solaris machine.

Regards,

Videesh

R3trans.txt.zip

[divyanshu_srivastava3]

That is why I am asking you to check again.

You kernel and it's DBSL seems incorrect for your release.

Let me check the logs.

[divyanshu_srivastava3]

Logs look OK.. May be you can check the kernel again

Also, check below notes

662644 - Composite SAP Note: ORA-00942

Stop SAP and then Db and take a server reboot

Regards,

[Former Member]

Hi Divyanshu,

Followed sap note you recommended but no luck.

Regards,

Videesh

[former_member182657]

Hi,

Please follow SAP Note 662644 - Composite SAP Note: ORA-00942

Thanks

Gaurav

[Former Member]

Hi Gaurav,

Thanks For your response,

I've followed steps in the refered note but still the issue continues.

Regards,

Videesh