Upgrading your Oracle database
Upgrading your Oracle database
The new version of Client Management requires new tablespaces; you must therefore upgrade your database as explained in the next topics.
- Upgrading the Oracle tablespaces for version 10.1 and earlier
- Upgrading the Oracle tablespaces for version 11.x
Upgrading the Oracle tablespaces for version 10.1 and later
If you are upgrading from version 10.1 or earlier to 12.x you first need to upgrade your database by executing the support/database/oracle/dbtablespaces_1010_1100.oracle.sql and support/database/oracle/dbtablespaces_1170_1200.oracle.sql scripts of the downloaded archive. Proceed as follows:
- Copy the files support/database/oracle/dbtablespaces_1010_1100.oracle.sql and support/database/oracle/dbtablespaces_1170_1200.oracle.sql to the temp directory of the machine on which the CM database is installed.
- Open both scripts in a text editor and replace the placeholder &1 with the path to the tablespaces subdirectory (for example, Oracle/OraData/BmcClientManagement ), &2 with the name of the Oracle account with which you connect to the CM database , and &3 with the corresponding password.
Launch the database tool of your choice and log on with the following parameters:
System_Password
The password to the Oracle system.
Net_Service_Name
The name of the Oracle service.
- Launch the support/database/oracle/dbtablespaces_1010_1100.oracle.sql script.
- Launch the support/database/oracle/dbtablespaces_1170_1200.oracle.sql script.
The tablespaces are now upgraded and you can continue with the master server upgrade.
Upgrading the Oracle tablespaces for version 11.1 and later
If you are upgrading from version 11.1 or later, you first need to upgrade your database by executing the support/database/oracle/dbtablespaces_1170_1200.oracle.sql script of the downloaded archive. Proceed as follows:
- Copy the file support/database/oracle/dbtablespaces_1170_1200.oracle.sql to the temp directory of the machine on which the CM database is installed.
- Open the script in a text editor and replace the placeholder &1 with the path to the tablespaces subdirectory (for example, Oracle/OraData/BmcClientManagement ), &2 with the name of the name of the Oracle account with which you connect to the CM database , and &3 with the corresponding password.
Launch the database tool of your choice and log on with the following parameters:
System_Password
The password to the Oracle system.
Net_Service_Name
The name of the Oracle service.
- Launch the support/database/oracle/dbtablespaces_1170_1200.oracle.sql script.
The tablespaces are now upgraded and you can continue with the master server upgrade.