This article provides a workflow for using the Repository Tools (repotools) that is available in IBM® Rational® Collaborative Design Management applications to back up and restore an Oracle database. The Design Management Software Verification Test (SVT) team uses this process to prepare for benchmark testing, so they can ensure that the data is consistent between testing cycles.
You need the following to do the backup:
- Knowledge of Design Manager installation and configuration process
- Knowledge of IBM® WebSphere® Application Server
- Knowledge of Oracle databases
- Administrator rights to the applications and the computers where the applications are installed
The workflow provided here runs on Microsoft Windows 2008R2 Server 64-bit computers, and all paths and commands are for a Windows operating system.
The Repository Tools (repotools) application provides a way to manage an IBM® Rational® Jazz™ repository database. It was originally intended for migrating databases, but you can also use this tool to back up and restore any of the databases defined in the IBM® Rational® Design Management teamserver.properties file.
For more information about repotools commands, see the link to the Rational Application Developer Information Center, cited in the Resources section.
You will use the following applications in this process:
- IBM Rational Design Manager Version 3.0.1
- IBM® WebSphere® Application Server Version 184.108.40.206
- Oracle 11g database
Steps that this article covers
This article covers the following steps:
- Stopping the WebSphere Application Server, backing up the server directory in the Design Management directory
- Running repotools to export the Oracle databases
- Uninstalling the existing Design Management server and server extension, and then cleaning up all directories
- Uninstalling the .war files on the WebSphere Application Server, and cleaning up all directories
- Deleting the Oracle databases and creating new databases
- Installing the newer version of Design Manager and restoring the server directory
- Running repotools to restore the Oracle databases
- Configuring and deploying Design Manager on the WebSphere Application Server (not covered in detail)
- Running repotools to reindex the databases
- Running the provision command for Design Manager installed on the WebSphere Application Server
- Requesting a server restart
Backing up directories and databases
- Stop the IBM WebSphere Application Server that the Design Manager installation is running on.
- On the IBM WebSphere host computer, click Start > All Programs > IBM WebSphere > Application Server > Profiles > AppSrv01 > Stop the Server. (See Figure 1.)
Figure 1. Stopping the WebSphere Application Server
- Copy the entire
serverdirectory in the Design Management directory to a temporary location.
- Using the command prompt, go to the /IBM/DesignManagement/server directory and enter the following command: 2
repotools-jts.bat –export tofile=C:\temp\dbexport.tar
This process can take from several minutes up to several hours, depending on the size of the Oracle database that you are backing up.
Uninstall Design Manager and clean up the WebSphere Application Server
- Start IBM Installation Manager, and uninstall Design Management Server and IBM Rational Software Architect Design Manager Server Extension.
- Browse to the installed directory and delete the DesignManagement folder.
- Delete the
.warfiles on the WebSphere Application Server.
- Start the WebSphere Application Server. (See Figure 1.)
- After the server starts, open the administrative console and log in as the administrator.
- Under Welcome, select Applications > Application Types > WebSphere Enterprise Applications.
- From the list of applications, select the following variable names:
- Click Stop.
If a red X appears beside the file names in the Application Status column, select the three applications again, and click Uninstall. (See Figure 2.)
Figure 2. Uninstalling the .war files from the application server
- After the applications are deleted, click Save and log out of the Administrative console.
- Stop the WebSphere Application server. (See Figure 1)
- Delete the _war directories in the application server directory:
- Using Windows Explorer, browse to the following directory:
C:\Program Files\IBM\WebSphere\AppServer\profiles\AppSrv01\temp\<hostname> Node01\server1
- Locate and delete the following three directories that are shown in Figure 3:
- Using Windows Explorer, browse to the following directory:
Figure 3. Deleting the _war directories
Delete the Oracle databases
After you uninstall the .war files from the application server, you must delete an old database and create a new one. During this step, you need access to the database host computer.
- On the computer that hosts the Oracle databases, start the Oracle Database Configuration Assistant.
- On the Welcome screen, click Next, and then click Delete a Database.
- Select the database to delete.
- Repeat this process for the second database. (See Figure 4.)
Figure 4. Delete Oracle databases
- Create two new databases:
- Launch the Oracle Database Configuration Assistant again, select Create a Database, and click Next.
- Select the General Purpose or Transaction Processing template, and click Next.
- Enter the new global database name and SID name. Both names must be identical to the first database that you deleted.
- Click Next. (See Figure 5.)
Figure 5. Enter a database name
- For the database credentials (Screen should read Step 5 of 12 in title bar), select Use the Same Administrative Password for All Accounts, and provide the same password as the original database.(See Figure 6. below)
Figure 6. Database credentials
- Click Next four more times until you advance to the Initialization Parameters page (The Screen should read Step 9 of 11 in the title bar, as Figure 7 shows.)
- On the Initialization Parameters page, click the Memory tab, set the memory to about 20% (based on a 64-bit computer with 16 GB of RAM).
- On the Sizing tab, set the processes to
- On the Character Sets tab, review the list of character sets, and select UTF8 Universal Character Set. Then set the national character set to UTF8. (See Figure 7.)
- Click Finish.
Figure 7. Setting the UTF8 character set
Create the Oracle database table spaces
- Log in to the first database that you created by selecting Start > All Programs > Oracle-Oardb11g_home1 > Database-Control <database name>
- On the login screen, log in as
SYSand connect as
SYSDBA, and then click Login.
- Under the Server tab, click Storage > Tablespaces, and then click Create.
- Enter the same name for the table space that you originally had (usually the same as the database name, with a suffix of _tbs). For example:
- Click Use bigfile tablespace, and then click Add. (See Figure 8.)
Figure 8. Create a table space
- On the Add Datafile page, add the file name in this format:
- Add the file directory path.
- Change the file size to 1GB.
- Click Automatically extend datafile when full (AUTOEXTEND), and set it to 100 KB increment. (See Figure 9.)
Figure 9. Table space size settings
- Click Continue.
- Click ShowSQL; your screen should look like the following example:
CREATE BIGFILE TABLESPACE "DM30DB1_TBS" DATAFILE 'C:\oracle_tbs\DM30DB1_tbs.dbf' SIZE 1G AUTOEXTEND ON NEXT 100K MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
- Click OK. to finish creating the table spaces.
Create users and set their privileges
- Go back to the main database instance page and click Database Instance: dbname in the upper left.
- Click the Server tab.
- Click Security > Users, and then click Create.
- Enter a name for the user in this format: dbname_user (example:
- Enter and confirm your password.
- Click the radio button to change the default table space to the table space that you just created (in this example: DM40M5_TBS), as Figure 10 shows.
Figure 10. Setting the table space to the user name
- Under the Modify System Privileges tab, move all of the available system privileges to the selected system privileges, and then click OK. (See Figure 11)
Figure 11. Setting privileges for the user
- Click Show SQL. The first line should look similar to this example:
CREATE USER "DM30DB2_USER" PROFILE "DEFAULT" IDENTIFIED BY "*******"
DEFAULT TABLESPACE "DM30DB2_TBS" ACCOUNT UNLOCK
- Click Return.
- To create the user, click OK, and then click Log Out.
- Log in as the user that you just created (
DM40M5_useras Normal) to make sure that you can connect.
Repeat the process for the second database.
Install Design Manager by using IBM Installation Manager
To install the Design Management Server and the IBM Rational Software Architect Design Manager Server Extension:
- Start IBM Installation Manager and click Install.
- Select both the Design Management Server and the IBM Rational Software Architect Design Manager Server Extension (select the same version that you just uninstalled).
- If you agree to the terms, accept the license agreement, and then click Next.
Because you are installing Design Management onto WebSphere Application Server, do not install the Apache Tomcat application.
- Accept all of the default settings and continue with the installation.
- After the process finishes, exit the application.
Configure Design Management on the WebSphere Application Server and restore the databases
This article is based on the assumption that you are familiar the configuration of Design Management on the WebSphere Application Server, so it does not provide those steps.
- Because you have installed the same version of Design Manager, you can copy the
serverdirectory that you copied in step 3 of the "Back up the directories and database" section to the new installation directory for Design Management.
After you have copied the directory, do not run
jts/setup to configure the database server.
- Restore the Oracle database by using the repotools utility.
- At a command prompt, browse to the
IBM/DesignManagement/server/. Directory, enter the following command, which is also shown in the screen segment in Figure 12:
repotools-jts.bat –import fromFile=C:\temp\dbexport.tar
Figure 12. Repotools import command
Importing can take from several minutes up to several hours, depending on the database size that you originally backed up.
- After the process is finished, close the command prompt.
Now you can configure and deploy Design Management on the WebSphere Application Server. This article does not provide details for that process, because each setup process is different.
After this process is finished, do not run
jts/setup as an administrator. You do not want to overwrite the database setup.
Reindex the Oracle database and restart the WebSphere Application Server
To reindex the Oracle databases by using the repotools utility and then restart the WebSphere Application Server, follow these steps:
Using the Administrative console, you must change the version for the JDBC driver to run the indexing command.
- To open the WebSphere Application Server "Environment Entries" page from the WebSphere Application Server administrative console, click Servers > Server Types > WebSphere application servers > your app server > Java and Process management > Process definition > Environment Entries.
- Locate the variable called ORACLE_JDBC_DRIVER_FILE. The variable name might differ, but the path should point to the ojdbc6.jar file.
- Change the path to point to the ojdbc14.jar file, save your changes, and exit.
- Restart the WebSphere Application Server.
- Using a command prompt, browse to the IBM/DesignManagement/server/ directory, and reindex the database by entering the following command:
repotools-jts.bat –reindex all
Reindexing could take from several minutes up to several hours, depending on the size of the databases.
- After the process is finished, change the Java Database Connection (JDBC) driver back to this version:
- Repeat step 2 above, and change the path so that it picks up the ojdbc6.jar file.
- Save and restart the WebSphere Application Server.
Do not run
jts/setup on the new instances of Design Management and Oracle databases that you installed.
- Run the provision command in the browser to create a log of all of the installed plug-ins. Example:
- Stop the WebSphere Application Server.
- Run Server Reset for the Jazz Team Server by using the following command in a web browser:
After you run this command, you should see a Request Server Reset button, as shown in Figure 13.
Figure 13. Request Server Reset button
- Click Request Server Reset.
- Log out of the WebSphere Application Server, and then stop and restart the server.
You should now be able to log in to the projects that you had before.
- For more information about the commands for the repotools utility:
- See the Rational Application Developer Information Center.
- Check the IBM Rational Collaborative Design Management information center, where you can search for repotools, and explore the featured help topics. Information is also available on configuring the Design Management Server.
- Visit the Rational software area on developerWorks for technical resources and best practices for Rational Software Delivery Platform products.
- Subscribe to the developerWorks weekly email newsletter, and choose the topics to follow.
- Stay current with developerWorks technical events and webcasts focused on a variety of IBM products and IT industry topics.
- Improve your skills. Check the Rational training and certification catalog, which includes many types of courses on a wide range of topics. You can take some of them anywhere, any time, and many of the Getting Started ones are free.
Get products and technologies
- Download a free trial version of Rational software.
- Evaluate other IBM software in the way that suits you best: Download it for a trial, try it online, use it in a cloud environment, or spend a few hours in the SOA Sandbox learning how to implement service-oriented architecture efficiently.
- Join the Rational software forums to ask questions and participate in discussions.
- Get social about thought leadership. Join the Rational community to share your Rational software expertise and get connected with your peers.
- Ask and answer questions and increase your expertise when you get involved in the Rational forums, cafés, and wikis.
- Rate or review Rational software. It's quick and easy.
- Share your knowledge and help others who use Rational software by writing a developerWorks article. Find out what makes a good developerWorks article and how to proceed.
- Follow Rational software on Facebook, Twitter (@ibmrational), and YouTube, and add your comments and requests.