Skip to Content

Stop/start sap ASE command line (part of S/4HANA trial )

We are testing S/4HANA trial and it contains sap ASE(which is running now).
I need to do some configurations on os level and before that I always write application start/stop scripts, standard sap stuff like like abap, hana and etc stop fine but I don't know how to stop sap ASE (sybase) - some google posts suggested launch isql and enter password but I don't want to include plain password in my stop script.

How do I stop sap ASE on S/4HANA using command line having linux root authority ?

Thanks
Vilius M.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Jun 27, 2019 at 05:45 PM

    Hi,

    Look at:

    http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc35823.1600/doc/html/san1334282765219.html

    The sequence when not using the deprecated stopsap/startsap command would include starting the BS server first then the main server. Using the startserver utility.

    http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc35823.1600/doc/html/san1334282765219.html

    1. Sign in as Sybase user syb<sid>adm

    2. Change to installation directory $SYBASE/$SYBASE_ASE_install

    3. ./startserver -f RUN_yourdbnamehere and RUN_yourdbnamehere_back

    I would also use nohup with '&' to provent server from shut when logged out or disconnect perhaps.

    Hope this helps.

    Regards,

    Johan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 28, 2019 at 06:31 AM

    Hi Vilius,

    Please try to use environment variables.
    For examples,
    1.for environment variable

    export pwd=sybase

    isql -Usa -P$pwd -SASE1 -X <<END

    shutdown
    go

    END

    If you can use SecureStore of SAP at the environment, isql uses secure store key with -k option too.

    Regards,

    Jongun

    Add a comment
    10|10000 characters needed characters exceeded

    • It would be better to use the isql command like this:

      pwd=`cat .my_secret_password_file`
      isql -Usa -SASE1 -X <<END
      $pwd
      shutdown
      go
      END

      So that the password doesn't show up in ps command output to other users on the box.

      Also, the normal shutdown command waits for currently executing statements to finish before shutting down. If somebody is in the middle of a long running select, they would effectively block shutdown. If this is a problem for you, you can add the "with nowait" option to the shutdown command (kills currently running statements before shutting down).

      Make sure to run 'chmod go-rwx .my_secret_password_file' (change 'group' & 'other' to subtract read, write, and execute priv) to prevent other people from seeing it.

  • Posted on Jul 03, 2019 at 02:40 PM

    Log in as SAP administrator (<sid>adm ) and use sybctrl to strat and stop ASE in an SAP ABAP system:

    sybctrl --help usage: sybctrl [<options>] The following options are possible:
    start : start database.
    stop : stop database.
    ...

    HTH
    Tilman

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 04, 2019 at 01:41 PM

    Hi Vilius,

    In case of shared libraries and the s-bit is set you may get a connection error with sybctrl. Please check SAP Note

    https://launchpad.support.sap.com/#/notes/2719763

    you should use sybxctrl instead of sybctrl which it is described in the SAP Note

    su - <sid>adm

    sybxctrl stop

    sybxctrl start

    This should work fine and should only stop the SAP ASE database

    hope this helps.

    Kind Regards

    Ali Özcan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.