stopdb not working

[Marco Santerre]

Hi everyone,

Using SG A.11.13 and SGeSAP B.03.06 on a two node clusters where the DB and CI is split on both nodes on two different packages.
Well, ever since we upgraded to Oracle 9.2.0 from 8.1.7.4, the stopdb function from sap.functions has stopped functionning. We know that the PATH is correct but for some reason, the command (which is su - ${SIDADM} -c "stopdb") cannot be found and returns a 1 as returncode therefore not stopping the base but instead killing all processes when unmounting the file systems. Though the app is down at the time we usually do maintenance, it is still a problem for me cause I feel the package should do this. It was working fine at 8.1.7.4.
So my question is : Is this because 9.2.0 is not supported with SGeSAP B.03.06 or is it because I missed something when the Oracle upgrade was done?

[Chris Wilshaw]

Does running the stopdb command work from the command line when running as your $SIDADM user? If so, use the which or whence commands to find the location of the utility, and add the full path into your su command.

[Jeff Schussele]

Hi Marco,

I'd supply the full path to the stopdb script as a first step. Sounds like it can't find it.

Rgds,
Jeff

[Marco Santerre]

Unfortunately Chris, no I can't run the command because this is my Production environment and I'm not allowed to actually stop the DB in the middle of the day ;)

Jeff, I also thought it would be something with the PATH or very similar. And the command is exactly what I have given you and it does come from the standard sap.functions scripts stop_db.

Though we have made potential progress. And probably resolve the issue. Apparently, falling back from a couple of Support package on SAP, the Basis people put back the old versions of BR tools and startdb and stopdb. Though SG doesn't seem to have a problem with the startdb, it seems to do have one with the stopdb.

[Michael Schulte zur Sur]

Hi Marco,

stopdb or stop_db?
Have you looked with find for the script?

greetings,

Michael

[Marco Santerre]

Hi Michael,

stopdb is the script that is being invoked to stop the db. stop_db is the name of the function in sap.functions that is called when you run the cmhaltpkg on the db package of a SAP application.