Space Manager with LiveReorg 9.2 - Installation Guide

When Upgrading Oracle

If you plan to upgrade from one version of Oracle Database to another, uninstall QSA first. After the new Oracle database is installed, reinstall the server and the QSA agent.

When upgrading Oracle

1. Uninstall the Server Agent.
   1. From the Space Manager main menu, select Tools | Admin | Quest Server Agent | Manage Quest Server Agent Installation.
   2. Select Remove Quest Server Agent and complete the Server Agent Installer wizard. See Uninstall the Server Agent for more information.
2. Upgrade Oracle Database.
3. Reinstall server components.
   1. Return to Space Manager and from the main menu select Tools | Admin | Reinstall Space Manager Server Objects. This recreates all the Space Manager views and triggers the installation of the Server Agent.
   2. When installation of the server components is finished, the Server Agent Installer opens and prompts you to install the agent.
4. Install the Server Agent. This ensures that the correct Oracle libraries are used when you upgrade Space Manager. See Install or Upgrade Server Agent on UNIX or Linux for more information.

Uninstall Server Components

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

1. Run the Space Manager client and connect to the target database as the DBA that installed server components.

2. 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.

3. If the uninstall program detects scripts that are being executed by QSA, you must cancel the uninstall. You can finish the uninstall after script execution is complete.
4. If the uninstall program determines that one or more scripts are scheduled to run, a message displays the date and time for the first script and asks if you want to continue the uninstall:
   • If you want to continue and are sure that the uninstall process will finish before the first script runs, click Yes.
   • If you want to cancel the uninstall, click No.
5. Once verifications are complete, a confirmation message explains that all Space Manager objects will be removed from the server. Click Yes. The SQL Exec dialog displays the uninstall progress and status.
6. After server components are uninstalled, the QSA Installer displays so that you can remove the agent. See Uninstall the Server Agent for more information.

Uninstall Server Agent

The Server Agent must be uninstalled individually from each database for which it is installed. It must be uninstalled by the user that installed it.

Note: If you used the QSA Installer or the manual install method to install the agent, use the same method to uninstall it.

Uninstall QSA from UNIX or Linux

This section describes how to uninstall QSA from an Oracle database on a UNIX or Linux server with the QSA Installer. You can use the QSA Installer if you have both SSH and SFTP access to the database server. If you do not have both, you must use a manual procedure. See "Manually Uninstall Server Agent from UNIX or Linux" in the Space Manager Installation Guide for more information.

To uninstall the agent from UNIX or Linux

1. Run the Space Manager client and connect to the target database as the DBA that installed QSA.

   Note: After uninstalling the server components, the Server Agent Installer automatically opens to the Log on page. Skip ahead to step 4.

2. To run the QSA Installer, select Tools | Admin | Quest Server Agent | Manage Quest Server Agent.
3. In the Select Installation Type window, select Remove Quest Server Agent, and then click Next.
4. In the Log on to Server window, enter the user name and password for the UNIX or Linux account that installed the agent. Enter the host server name if it is not displayed. Click Next.
5. In the Uninstall Quest Server Agent window, click Remove.
6. In the Installation Finished window, click Finish to exit the QSA Installer.

7. If you did not uninstall QSA as root, log into the server as root and run the ROOT_UNINSTALL.SH script as follows. Use SID for the target database.

   # /tmp/root_uninstall.sh SID

Uninstall QSA from Windows

This section describes how to uninstall the Server Agent from a local or remote Windows server.

Note: The agent must be running when you uninstall it from a Windows server. You can start the agent from the Windows Services window, or run QSAStart.cmd in the \bin folder under the agent install folder (<installation path>\Quest Server Agent\<ORACLE_SID>\bin).

To manually uninstall the Server Agent from Windows, see "Manually Uninstall Server Agent from Windows" in the Space Manager Installation Guide.

Local Windows Server

To uninstall QSA from a local Windows server, you can run the Server Agent Installer from the Space Manager application.

To uninstall QSA from a local Windows server

1. Run the Space Manager client and connect to the target database as the DBA that installed QSA.

   Note: After uninstalling server components, the Server Agent Installer automatically opens. Skip ahead to step 3.

2. To run the QSA Installer, select Tools | Admin | Quest Server Agent | Manage Quest Server Agent.

3. In the Select Installation Type window, select Remove Quest Server Agent, and then click Next.
4. In the Uninstall Quest Server Agent window, click Remove.
5. In the Installation Finished window, click Finish to exit the QSA Installer.

Remote Windows Server

To uninstall QSA from a remote Windows server, you must copy the Server Agent Installer from the Space Manager application directory to the Windows server. (Installing QSA on the remote Windows server also required copying the Server Agent Installer to the Windows server.)

To copy the QSA Installer to remote Windows server

1. Navigate to the Space Manager application directory:
   • In Windows Explorer, navigate to: C:\Program Files\Quest Software\Space Manager <version number>
2. Open the QuestServerAgent folder and copy QSA_version_build-QSASetup.exe to the Windows server.

To uninstall QSA from a remote Windows server

1. Log in to the remote Windows server as a member of the Windows Administrators Group.
2. After copying the Server Agent installer (QSA_version_build-QSASetup.exe) to the Windows server, double-click QSA_version_build-QSASetup.exe to run it.
3. Follow the instructions in the previous section, “To uninstall QSA from a local Windows server” beginning with step 3.

Uninstall Space Manager Client

This section describes how to uninstall the Space Manager client.

To uninstall the Space Manager client

1. Exit from all applications, including the Space Manager client.
2. Uninstall Space Manager using your Windows add/remove programs feature.
   • For example, in Windows 7, select Control Panel | Programs | Programs and Features | Uninstall a program.
3. Select Space Manager and then click Uninstall.
4. This removes all Space Manager files, folders, and registry keys from your system.