Dispatcher not starting

[arya_biswas]

Hi Guys,

I'm facing an issue.

I have restored a system by db restoring.

Now the SAP is getting up properly but dispatcher is not starting.

dpmon=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

Already ran cleanipc and ipcrm -s but no luck. Everything seems to be all right but dispatcher is not working.

System details -

OS -Linux

DB -Oracle 11.2

SAP -7.20 (NW)

Please Guide.

[arya_biswas · Accepted solution]

Hi Guys,

Many thanks for your valuable inputs.

Actually i found later that the case was different. Here is the case and the simple resolution.

Case :

Post refresh we had an initial issue with sapstartsrv program. For two three attempts startsap was getting hang while starting sapstartsrv. So to get back in promt we used ctrl+c.

Then after checking with profile parameters we found an incorrect entry and fixed it. Then startsap was executing properly but dispathcer was not running.

The DB was up.

SAP was up.

even R3trans -d was also giving 0000.

Then  we checked all the above things and every-ting seems to be all right.

Solution :

After running cleanipc and ipcrm we were in a notion that every process was killed. But we were wrong. Went to root user with sudo and ran ps -ef that given us the entire picture. The sapstartsrv program was still running. Killing them resolved the issue.

Then drilling down the exact issue we found the below over linux forum -

    Ctrl+C: politely ask the process to shut down now

    Ctrl+\: mercilessly kill the process that is currently in the foreground

Thus everytime ctrl+c could not kill the entire process.If we had used ctrl+\ then this would never happen. Anyway it was bit scary but very good learning.

Thanks everybody. Good Luck all.

//Arya

[Former Member]

Now the SAP is getting up properly but dispatcher is not starting. 

If I understood it correctly, Database is up but not SAP?

Execute R3trans -dx and then paste the error lines of trans.log.

Paste the error lines from dev_w0 as well.

Did you perform the post restore activities as mentioned in homogenous system copy guide?

Regards,

Nick Loy

[Former Member]

This message was moderated.

[former_member186895]

Hi,

database is running?

Restore of database was from different sid to another sid?

If yes then please check database schema name.

which database you are using?

Thanks

Ramesh

[Former Member]

Hi

check any db_user has locked

select username,account_status from dba_users;

all user must be unlocked

check R3trans -d that is =  0

check all trace files

Regards

[former_member188883]

Hi Arya,

Please attach following logs

1) R3trans -d

2) dev_w0

3) dev_ms

Regards,

Deepak Kori