Procedure - apply patches to sybase 1. Download the software from the SAP Service Marketplace 2.
Prepare the upgrade 3. Update the ASE software 4. Perform post-upgrade tasks 5.
Update the ODBC and JDBC drivers 6. Restart the SAP system Recommendation: Perform a file system backup of the ASE software directory (: sybase ) before you update the software. Download the software from the SAP Service Marketplace Download the latest software patch from the SAP Service Marketplace.
On 10 th of April 2018, SAP Security Patch Day saw the release of 10 Security Notes. Additionally, there were 2 updates to previously released security notes. Additionally, there were 2 updates to previously released security notes.
A) Open the SAP Software Download Center at b) Choose 'Support Packages and Patches' - 'Browse our Download Catalog'. C) Choose 'Sybase Products' - 'Sybase ASE FOR BUSINESS SUITE' - 'Sybase ASE 15.7 FOR BUS. Choose your platform and 'Downloads'. D) Unpack the software package to a local temporay directory. File ASE157SPxxx.SAR contains the ASE server software (xx is a two or three-digit number and refers to the current ASE patch level). File DBCLNT157SPxxx.SAR contains the ODBC and JDBC drivers.
Since the ASE installation has to be performed as the ASE software owner syb, it is recommended that you unpack the file as user syb. Copy the downloaded files to a temporary directory. Unpack the file ASE157SPxxx.SAR using the command: SAPCAR -xvf ASE157SPxxx.SAR Do not unpack the file DBCLNT157SPxxx.SAR. Preparation for the upgrade a) Perform a file system backup fo the software installation directory%SYBASE% (: sybase ).
B) Check the database version before the update. Log on to the operating system with user syb.
Open an administrator cmd shell and type: sqlsrvr.exe -sbssav sqlsrvr.exe -version Make a note of the current version for later comparison. Recommendation: Unlock the 'sa' account in ASE before you start the ASE upgrade. Log in to ASE using the account 'sapsso' with isql and execute the command: splocklogin 'sa','unlock' c) Stop the SAP system and the ASE server; use user adm.
Shut down the SAP system and the ASE server using the SAP Management Console. Alternatively, shut down the ASE server by stopping the services Sybase BCKServer BS and Sybase SQLServer. Use the Task Manager to check if the processes sqlsrvr.exe and bcksrvr.exe owned by user syb have stopped running. The ASE server must be offline during the update. Also none of the utilities (for example 'isql') must be in use.
Otherwise files would be locked by the running database processes. Update the ASE software You can use either the command line installer 'setupConsole.exe' or the graphical ASE installer. A) Using the command line installer Download the file dbsrvrespupdate.txt which is attached to this note.
Put it into the temporary directory where you unpacked the ASE Software. As user syb open an administrator command shell, switch to the temporary directory. Call the executable setupConsole.exe with the following parameters (the command must be entered on one line at the command prompt):. SetupConsole.exe -f: dbsrvrespupdate.txt -i silent -DUSERINSTALLDIR=: sybase -DAGREETOSYBASELICENSE=true Replace with your SAP System ID, replace with the drive where your ASE software is installed. Replace and as it applies to your system (the temporary folder with installable ASE software is located).
When the install process has finshed, check the installer log file ASESuite.log which is located in directory%SYBASE% log. B) Using the GUI installer As user syb open an administrator command shell, switch to the temporary directory. Call the executable setupConsole.exe with the following parameters (the command must be entered on one line at the command prompt):. Setup.exe -DINSTALLUSERPROFILE=USER -DDONOTCREATESHORTCUT=TRUE -DREGISTERUNINSTALLERWINDOWS=FALSE In the installer GUI window, select the Sybase home directory: sybase for the update and click 'Next'. Confirm that you want to perform the installation in an existing directory. Select 'Yes' when you are asked if you want to update the product.
If installing ASE 15.7 SP100 and higher the GUI install displays a dialog box 'Choose Update Adaptive Server'. Do not choose this option. Click 'Next' until the GUI procedure finishes. Depending on the upgrade history of the installation, the ASE installer might not display the dialog box asking whether you want to update the product. Instead a dialog box is displayed asking whether you want to install 'Typical', 'Full' or 'Custom'. Choose custom mode and mark the check boxes as follows:. In the Adaptive Server Enterprise feature group uncheck 'Additional ASE language modules' (unless you do need any additional language support).
In the 'Open Client' feature group choose DB client (leave all other checkboxes unchecked). Set the checkbox for the jConnect feature. In the feature group 'sysam License Utilities' uncheck 'SySam License Server'. In the feature group 'Sybase Control Center' set the checkbox for 'Remote Command and Control Agent for Adaptive Server'.
Leave all other checkboxes in the group unchecked. In the 'License Type' screen choose 'Install Licensed Copy'. Agree to the license terms in the following screen.
Choose product edition 'Enterprise Edition' and License Type 'Unknown'. Do not configure email alerts and click 'Next'. In the 'Configure new servers' dialog, leave everything unchecked and select 'Next'. If a dialog box 'Remember passwords after connecting to servers' is displayed, select the option suitable to your business needs. We recommend you to choose 'Disable'. When the install process has finished, check the installer log file ASESuite.log which is located in directory%SYBASE% log.
Perform post upgrade tasks a) Restart the ASE server. Start the services Sybase BCKServer BS and Sybase SQLServer. Review the ASE error log file for correct execution (open the file: sybase ASE-150 install.log). If the ASE Job Scheduler was not disabled before you performed the upgrade, you may see an error message similar to the one below in the ASE error log: kernel Initializing Job Scheduler Task kernel Installed Job Scheduler sequencer code version 0.29 - 29 tokens server Error: 11031, Severity: 16, State: 1 server Execution of rule checkjscstate failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate dbo.checkjscstate. Kernel JS: Exception 3602 raised.
Kernel JS: jsexcute got the Exception You can ignore this error at this point. B) Log on to the operating system with user syb, connect to ASE with isql and temporarily unlock user 'sa'. Splocklogin 'sa', 'unlock' c) Execute the Sybase installation scripts. After the installation of the software, execute the following scripts that adapt ASE system catalog tables. Log in as user 'syb' and switch to directory: sybase ASE-150 Run the script 'instmstr': isql -X -Usa -S -iinstmstr -o Check for errors. Check: sybase ASE-150 install.log for errors. Repeat these steps for the following scripts:.
instcomm. instmsgs.ebf.
installjsdb. installdbextend. installdbccdb (optional, necessary only if you configured the dbcc database) d) Execute the script 'sybupdatedb.TXT' which is attached to this note. Copy the script to a temporary directory (e.g. The temporary directory to which you copied the Sybase software package).
Change to that directory and execute the script: $isql -X -Usa -S -e -i sybupdatedb.TXT -o sybupdout.txt Review the generated output file for correct execution. For more information on the script, see SAP Note 1602547. E) Restart the job scheduler.
Log in to ASE with isql with the Sybase account 'sapsa' and execute the command: spconfigure 'enable job scheduler', 1 exec sybmgmtdb.spsjobcontrol ', 'startjs' f) Lock user 'sa' again. Log in to ASE with isql with the Sybase account 'sapsso' and execute the command: splocklogin 'sa', 'lock' g) Remove the newly installed sample client library applications according to SAP Note 1598817 (optional).
Update of the ODBC and JDBC drivers The SAP system does not have to be stopped when you copy the new ODBC and JDBC software to the global directory. A) Log in as user adm. B) Perform a file system backup of the directory: usr sap SYS global syb NTAMD64 c) Copy the file DBCLNT157SPxxx.SAR to the directory: usr sap SYS global syb NTAMD64 d) Unpack the DBCLNT157SPxxx.SAR file using the command:: usr sap SYS global syb NTAMD64 $SAPCAR -xvf DBCLNT157SPxxx.SAR With DBCLNT157SP050. SAR, the driver name was changed from jconn3d.jar to jconn3.jar, and jconn4d.jar to jconn4.jar, respectively. Update the JDBC driver and reconfigure your Java stack to use this JDBC driver with the changed name, see SAP Note 867976.
Restart the SAP system Log in as user adm and restart the SAP system through the SAP Management Console. Thanks Shrikant 1 Likes 1.