Case 2: Downgrading Dependent Software

Use

Database instances already exist that refer to a higher software version. You want to downgrade the software used exclusively by the database instance (dependent software).

Procedure

Delete the registration of existing database instances before the downgrade.

?     If you want to perform the downgrade at build level only, there will be no incompatibilities between the database instances of the higher version and the software of the lower version you want to install. Proceed as follows for each individual database instance:

Procedure

Command

Call Database Manager CLI as the DBM operator and connect to the database instance.

dbmcli –d <database_name> -u <dbm_operator>,<dbm_operator_password>

Delete the database instance registration.

db_drop WITHOUTFILES

Exit Database Manager CLI.

exit | release | quit |bye

Uninstall at least the database kernel and the required software component(s) with the higher version.

sdbuninst –package "Database Kernel" [, <package_name2>…]

Install the required installation profile with the lower version (for OLTP database instances Server at least, for liveCache database instances APO liveCache).

 If you are installing the software in SAP systems, it is important to carry out the step below.

sdbinst –profile Server | "APO LiveCache" [, <inst_profile2>…]

Register the database instance again. Enter the name and DBM operator of the old database instance, plus the path of the newly-installed lower software version.

Unix/Linux:

<dependent_path>\bin
\dbmcli –s –R <dependent_path> db_create <database_name> <dbm_operator>,<dbm_operator_password>

Microsoft Windows:

"<dependent_path>\pgm
\dbmcli" –s –R "<dependent_path>" db_create <database_name> <dbm_operator>,<dbm_operator_password>

?     If the downgrade is in connection with a change of version (minor or major release, see also: Version Notation) of the database software, proceed as follows:

Procedure

Command

Call Database Manager CLI as the DBM operator and connect to the database instance.

dbmcli -d <database_name> -u <dbm_user>,<password>

Delete the database instance.

db_drop

Exit Database Manager CLI.

exit | release | quit |bye

Uninstall at least the database kernel and the required software component(s) with the higher version.

sdbuninst –package "Database Kernel" [, <package_name2>…]

Install the required installation profile with the lower version (for OLTP database instances Server at least, for liveCache database instances APO liveCache).

 If you are installing the software in SAP systems, it is important to carry out the step below.

sdbinst –profile Server | "APO LiveCache" [, <inst_profile2>…]

Start Database Manager GUI. Use the Installation Wizard to create a new database instance using the parameter file from a backup.

Choose Instance  ®  Install.
Follow the instructions for creating a database instance
. For the new database instance, specify the database administrator saved in the parameter file of the backup .

Exit Database Manager GUI.

Choose File ® Exit.

If you use this procedure in SAP systems, do not accept the system defaults. Instead, specify the following settings:

<group>

For target versions 7.5.00 or higher: sdba

For all previous database versions: sapsys

<owner>

For target versions 7.5.00 or higher always: sdb

For all previous database versions:

?     For OLTP database instances: sqdsid

?     For liveCache database instances: sidadm

<independent_data_path>

UNIX/Linux: /sapdb/data

Microsoft Windows: <drive>:\sapdb\data

<independent_program_path>

UNIX/Linux: /sapdb/programs

Microsoft Windows: <drive>:\sapdb\programs

<dependent_path>

UNIX/Linux: /sapdb/<SID>/db

Microsoft Windows: <drive>:\sapdb\<SID>\db