Stop Sybase ASE – Linux

If you want to shutdown backup server also, make sure too shut it down first, as you will not be able to login to isql if you shutdown main server first.

Login to isql to shudown the ASE database and issue command “shutdown”

Then you can shutdown the ASE database instance.

You can opt to kill the processes (For example: If you dont have password to login to isql). But this is not the most safer way. Please use this option only if you are not able to login to isql.

Dont use -9 option. This might not allow uncommited DB transactions to rool back in a proper way.

 

Delete user – Sybase ASE

Use the below commands to delete users form Sybase ASE database (For example when activating super admin user SAP*)

Make sure you are logged in with user syb<sid> while connecting to isql.

User correct schema for SAP (SAPSR3 in this case).

 

Reset SAPSA/SA password – Sybase ASE

In case you forgot the passwords for Sybase ASE users SA or SAPSA, these can be reset using below steps.

I have use the steps from below SAP Notes:

2228120 – How to reset sapsa password – SAP ASE for Business Suite and SAP BW

1796540 – SYB: Password changes with sybctrl

1. Login with syb<sid>. Ensure that database is shutdown. You can check this with showserver.
   
2. Change current directory to the install path. Make a copy of RUN_<SID> file.
3. Edit the RUN_<SID> file and make following entries.
   
4. Start your ASE server by executing the RUN_<SID> file on command line –> a new password will be printed into terminal screen follow the last system database online information. It will look like below screen:Note: This new and temporary password is *only* printed on the terminal screen, it is not output to the errorlog. *Do not close* this session for now until we changed the sapsa password on next steps. Once the session is killed/closed, the password will no longer be valid.
5. Now you can login to isql to reset the SA and SAPSA passwords.
   
6. You can test now if the passwrod change has worked.
   
7. Now the passwords are changed it is required to update the securestore of the application server to use the right passwords.
   
8. Propogate the changes using sybctrl command (tool availalbe in the kernel directory of application server)
9. Check connectivity again
   

 

 

2277965 – DUMP DATABASE appears to hang – SAP ASE