Install server components after installing the Space Manager client. Install server components for each database you want to manage with Space Manager.
Upgrade the server components after upgrading the Space Manager client.
Use the same DBA account to install server components and the Server Agent. See Space Manager User Requirements for more information.
To install (or upgrade) server objects
When the Connect dialog displays, connect to the database using the Oracle DBA account chosen to install the server components and the Server Agent.
Note: For more information about creating a connection, see Connect to Databases.
When the Create Space Manager with LiveReorg Objects dialog opens, specify an owner and tablespace for the components. See the following for more information.
|Owner||If this is a first-time installation, specify the installation DBA. By default, the field displays the connecting user. To use a different DBA, enter the user name in the Owner field. After you click OK, a password prompt displays.|
Select a tablespace for Space Manager objects. The tablespace must have a standard name and free space equal to or greater than the amount for Expected Allocation. For an upgrade, it must also have enough free space for copies of existing Space Manager tables (created for recovery purposes and dropped when an upgrade is complete).
Objects are upgraded in their current tablespace. If you select a different tablespace, objects are upgraded in that tablespace and dropped from the current tablespace.
Verify the recommended space allocation for Space Manager objects. The recommendations allow for one year of growth in statistics tables.
Note: Use the following guidelines for determining space allocation: small for up to 100 GB, medium for up to 500 GB, etc.
|Allocation to use||Select a space allocation for Space Manager objects. The recommended allocation is entered by default.|
|Expected allocation||Verify the expected space allocation for Space Manager objects. This corresponds to the Allocation to use value.|
Install Space Manager Demonstration Data
If you want to install demonstration data after server components are installed, select this checkbox. Demonstration data requires 20 MB or 24 MB of disk space, depending on your database block size.
Note: If the Recycle Bin contains many objects, the Create Space Manager with LiveReorg Objects window might require a long time to display. To avoid this problem, empty the recycle bin before you begin the installation.
Click OK. The installation progress displays in the Executing Create dialog. To cancel installation, click Cancel.
Note: In some cases, Space Manager may try to allocate more than the expected allocation. It does this when a tablespace has a large minimum extent size or is locally managed and uses uniform extent allocation. In either case, installation may fail. If it does, click OK to clear the installation error. Begin installation again and select a larger tablespace for Space Manager objects.
The Install/Refresh Demonstration Data window displays if you are installing demonstration data. See the next step.
To install demonstration data, click Install in the Install/Refresh Demonstration Data window. It is recommended that you use the default demonstration user name, tablespace names, and datafile names. A password is not required. If you specify different directories for demonstration datafiles, the directories must already exist.
When demonstration data installation is finished, two “success” messages display. Click OK. The Server Agent Installer displays so that you can install (or upgrade) QSA. See Install or Upgrade Server Agent on UNIX or Linux for more information.
For more information about installing and upgrading Space Manager, the Server Agent, and server objects, see the Space Manager Installation Guide at Quest Software Technical Documentation .
The Reinstall Space Manager Server Objects function can be used to install or upgrade Space Manager server components for a database whenever needed. This function is designed for use when you need to rebuild existing components. It is also designed for use after you upgrade to a new version of Oracle. Reinstalling server components updates them for the new version of Oracle.
Note: The Reinstall Space Manager Server Objects function updates server components without affecting data stored in the Space Manager repository. All statistics and stored scripts are preserved.
To reinstall server objects
The Remove Space Manager Server Objects function can be used to uninstall server components from a database whenever needed. This function drops all Space Manager objects from a database, including statistics tables and script tables. It also drops the demonstration data.
Note: Datafiles for demonstration data tablespaces must be removed from the server manually.
Server components must be uninstalled by the DBA that installed them. They must be removed individually from each database in which they are installed.
Normally, demonstration data is automatically removed along with server components. However, the data is not removed when demonstration tablespaces contain objects that are not owned by the demonstration user. To ensure that demonstration data is removed, relocate non-demonstration objects before you uninstall the server components.
After demonstration data is uninstalled, manually delete the demonstration datafiles, SPCDEMO01_nn.dbf and SPCDEMO02_nn.dbf.
To uninstall (remove) server objects and demonstration data
To uninstall server components, select Tools | Admin | Remove Space Manager Server Objects. If demonstration data is installed, it is removed along with server components.
Note: After server components and QSA are uninstalled, manually delete demonstration datafiles, SPCDEMO01_nn.dbf and SPCDEMO02_nn.dbf.
The QSA Server Agent is a script execution engine that Space Manager uses to run scripts, such as reorganization, repair, and statistics-collection scripts, from the database server on a scheduled basis. The agent must be used to run live reorganization scripts and scripts that use FastCopy, FSCopy, or parallel agent processes. Scripts are automatically run by the agent when they are scheduled and stored in the Space Manager repository.
You can stop and start QSA from the Space Manager Tools menu or the Script/Job Monitor window. See Start or Stop QSA Server Agent.
To view information about the currently installed QSA Server Agent, select a database connection in the Explorer tree-list. Then click About QSA in the QSA Status panel.
Note: For detailed information about installing or uninstalling QSA (using the QSA Installer or the manual method), specifying QSA user privileges, or specifying QSA parameters, see the Space Manager with LiveReorg Installation Guide.
You can use the QSA Server Agent Installer to install, upgrade, and uninstall the QSA Server Agent for Oracle® databases on UNIX®, Linux®, and Windows® servers.
You can also use the QSA Installer to specify values for QSA parameters. Values are first specified when you install QSA. However, you can modify parameter values, if necessary, after installation by opening the QSA Installer.
To open the QSA Server Agent Installer
In the Select Installation Type window, select from the following:
Note: If the QSA Server Agent is not installed, the QSA Installer skips this window and displays the pages necessary for installation.
|QSA Installer Option||Description|
|Upgrade QSA Server Agent||Select to upgrade to a new version of the Quest Server Agent.|
|Remove Quest Server Agent||Select to uninstall the Quest Server Agent.|
|Configure Quest Server Agent||Select to specify Quest Server Agent parameter values.|
For more information about the QSA Installer, see the following:
Note: You can also run the QSA Installer from the Space Manager application folder. To run the QSA Installer, double click QSAInstall.exe.