3 Installing the Oracle Database Companion CD Software

3.2.1 Copying Oracle Database Software to Hard Disk

Instead of installing from the Oracle Database Companion CD products DVD, you can copy the contents of the DVD to a hard drive and install from there. This might be easier if you plan to install many instances of the Oracle Database Companion CD products on your network, or if the computers where you want to install the products do not have DVD drives.

To copy the contents of the installation media to a hard disk:

1. Create a directory on your hard drive. For example:

   c:\install\companion
   
   

2. Copy the contents of the installation media to the directory that you just created.

3. After you have copied all of the required installation files, you can install the Oracle Database Companion CD products.

3.2.2 Installing from a Remote DVD Drive

If the computer where you want to install the Oracle Database Companion CD products does not have a DVD drive, you can perform the installation from a remote DVD drive. Check the following points:

• On the Remote Computer, Share the DVD Drive

• On the Local Computer, Map the DVD Drive

3.2.3 Installing on Remote Computers Through Remote Access Software

If you want to install and run the Oracle Database Companion CD products on a remote computer (that is, the remote computer has the hard drive and will run these components), but you do not have physical access to the computer, you still can perform the installation on the remote computer if it is running remote access software such as VNC or Symantec pcAnywhere. You also need the remote access software running on your local computer.

You can install the Oracle Database Companion CD products on the remote computer in one of two ways:

• If you have copied the contents of the Oracle Database Companion CD products DVD to a hard drive, you can install from the hard drive.

• You can insert the DVD into a drive on your local computer, and install from the DVD.

3.3.1 Recommended Preinstallation Task for Oracle HTML DB

Before you install Oracle HTML DB, back up the Oracle database in that you plan to use for the installation. You can use Oracle Database Recovery Manager, which is included the Oracle Database installation, to perform the backup.

3.3.2 Oracle Home Location for Oracle HTML DB and Oracle HTTP Server

When you install the Oracle HTML DB installation type, you can install either Oracle HTML DB or Oracle HTTP Server, or both Oracle HTML DB and Oracle HTTP Server.

Oracle home locations for these two products are as follows:

• Oracle HTML DB: You must install Oracle HTML DB into an Oracle home that contains Oracle HTTP Server. In a new installation, you will install Oracle HTML DB into the same home as Oracle HTTP Server. If Oracle HTTP Server already is installed, you can install Oracle HTML DB into the Oracle home where Oracle HTTP Server is installed.

• Oracle HTTP Server: You must install Oracle HTTP Server in a new Oracle home. You can install Oracle HTTP Server more than once on the same system, as long as each installation uses a separate Oracle home directory.

3.3.3 Procedure for Installing Oracle HTML DB and Oracle HTTP Server

This section explains how to install Oracle HTML DB using either of the following scenarios:

• Installing both a new Oracle HTML DB and Oracle HTTP Server: Oracle Universal Installer creates an Oracle HTTP Server home in which to install Oracle HTML DB.

• Installing Oracle HTML DB into an existing Oracle HTTP Server home: You can either install a new Oracle HTML DB or upgrade an existing HTML DB into an existing Oracle HTTP Server home.

To install Oracle HTML DB and Oracle HTTP Server:

1. Log on as a member of the Administrators group to the computer on which to install Oracle components.

   If you are installing on a Primary Domain Controller (PDC) or a Backup Domain Controller (BDC), log on as a member of the Domain Administrators group.

2. Make sure that the Oracle database that you plan to use for Oracle HTML DB is accessible and running.

   You can use the Windows Services utility, located either in the Windows Control Panel or from the Administrative Tools menu (under Start and then Programs), to check that the Oracle database service is running. In the Services listing, names of Oracle databases are preceded with OracleService. Right-click the name of the database service you want and from the drop-down menu, choose Start.

3. Delete the ORACLE_HOME environment variable (from the System Control Panel) if it exists.

   Refer to your Microsoft online help for more information about deleting environment variables.

   Note:

   The ORACLE_HOME environment variable is automatically set in the registry. Manually setting this variable prevents installation.

4. Insert the Oracle Database installation media and navigate to the companion directory. Alternatively, navigate to the directory where you downloaded or copied the installation files.

   Use the same installation media to install Oracle Database on all supported Windows platforms.

5. Double-click setup.exe to start Oracle Universal Installer.

6. In the Welcome window click Next.

7. In the Select a Product to Install window, choose Oracle HTML DB and click Next.

8. In the Select Installation Type window, select one of the following choices and then click Next.

   • Oracle HTML DB and Oracle HTTP Server: Select this option to install a new Oracle HTML DB and Oracle HTTP Server into a new Oracle home.

   • Oracle HTML DB only: Select this option to install a new Oracle HTML DB into an existing Oracle HTTP Server home, or to upgrade an existing Oracle HTML DB installation.

9. In the Specify Home Details window, enter the following:

   • Name: If you chose Oracle HTML DB and Oracle HTTP Server in the previous step, enter a new Oracle home. If you chose Oracle HTML DB only, select the name of the existing Oracle HTTP Server home that Oracle HTML DB will use.

   • Path: Enter the directory location for the Oracle home that you specified under Name. Do not enter a directory path that has spaces. After you enter a correct directory path, Oracle Universal Installer creates a new directory for you.

   See also:

   "Identifying the Oracle Home Directory Location" for information on finding the Oracle home. Select each home and search for Apache Standalone. Oracle HTTP Server is listed as Apache Standalone in the Specify Home Details window.

10. Click Next.

11. In the Available Product Components window, select the additional components you would like to have installed as part of Oracle HTML DB, and then click Next.

12. In the Product-specific Prerequisite Checks window, check for and correct any errors that may have occurred while Oracle Universal Installer was checking your system.

13. Click Next.

14. In the Specify HTML DB Database Details window, enter the information required to configure Oracle HTML DB.

    • Hostname

      Specify the host name of the system where the database is installed. If the host name is the local host, enter the name of the computer (for example, myserver.us.mycompany.com), not localhost.

    • Port

      Specify the TCP/IP port number for the Oracle Net listener on the database system. The default port number is 1521. To find the current port number for your Oracle Database installation, check its tnsnames.ora file, which by default is located in ORACLE_BASE\ORACLE_HOME\network\admin.

    • Database Service Name

      Specify the database service name for the database where you want to install the Oracle HTML DB database objects, for example, sales. (You can find the database service names in the tnsnames.ora file.) Alternatively, you can enter the domain name, which is usually the same as the global database name, for example, sales.us.mycompany.com.

      To configure Oracle HTML DB, you must install the Oracle HTML DB database objects in an Oracle database. The database that you choose must be a release 9.2.0.3 or later database. If you plan to use the 10g release of Oracle HTTP Server, Oracle Universal Installer automatically creates a database access descriptor (DAD) in the mod_plsql configuration file and directory aliases in the Oracle HTTP Server configuration file httpd.conf, based on the information you enter during installation. However, if you plan to use a release 9i Release 2 of Oracle HTTP Server, you need to create these settings manually by using procedure described in the postinstallation steps in Chapter 4.

    • TABLESPACE Name

      Enter the name of the tablespace where you want to load the Oracle HTML DB database objects, or accept the default (SYSAUX).

    • SYS Password

      Specify the password for the SYS user in the database.

    • HTML DB Password

      Specify the password that you want to use for the Oracle HTML DB schemas (users). These schemas are created in the database during the installation.

      After the installation, you can use this password to connect to Oracle HTML DB as the administrative user. The password that you specify is also used for the HTMLDB_PUBLIC_USER schema, which is used by mod_plsql to connect to the database, and for the FLOWS_010600 and FLOWS_FILES schemas.

    • Confirm HTML DB Password

      Enter the password again to verify that you have specified it correctly.

15. Click Next.

16. In the Summary window, check the list of products that will be installed, and click Install.

17. When the installation completes, click Exit and then click Yes to exit from Oracle Universal Installer.

18. Optionally, delete the OraInstalldate_time directory if you want to remove the temporary files that were created during the installation process. The OraInstalldate_time directory holds about 45 MB of files. This directory is created in the location set by the TEMP environment variable setting.

    Restarting your computer also removes the OraInstalldate_time directory.

3.4.1 Oracle Home Location for the Oracle Database 10g Products

You need to install Oracle Database 10g Products in an existing Oracle Database 10g release 2 (10.2) Oracle home. These products are:

• Oracle JDBC Development Drivers

• Oracle SQLJ

• Database Examples

• Oracle Text Knowledge Base

• JAccelerator (NCOMP)

• Intermedia Image Accelerator

• Oracle Workflow

3.4.2 Procedure for Installing Oracle Database 10g Products

In brief, you first run Oracle Universal Installer to install the Oracle Database 10g Products. Afterwards, you configure Oracle Workflow server before you install the Oracle Workflow middle tier components.

To install Oracle Database 10g Products:

1. Log on as a member of the Administrators group to the computer on which to install Oracle components.

   If you are installing on a Primary Domain Controller (PDC) or a Backup Domain Controller (BDC), log on as a member of the Domain Administrators group.

2. Make sure that the Oracle database that you plan to use for Oracle Workflow is accessible and running.

   You can use the Windows Services utility, located either in the Windows Control Panel or from the Administrative Tools menu (under Start and then Programs), to check that Oracle Database is running. Names of Oracle databases are preceded with OracleService. Right-click the name of the service and from the menu, choose Start.

3. Delete the ORACLE_HOME environment variable (from the System Control Panel) if it exists.

   Refer to your Microsoft online help for more information about deleting environment variables.

   Note:

   The ORACLE_HOME environment variable is automatically set in the registry. Manually setting this variable prevents installation.

4. Insert the Oracle Database installation media and navigate to the companion directory. Alternatively, navigate to the directory where you downloaded or copied the installation files.

   Use the same installation media to install Oracle Database on all supported Windows platforms.

5. Double-click setup.exe to start Oracle Universal Installer.

6. In the Welcome window click Next.

7. In the Select a Product to Install window, choose Oracle Database 10g Products and click Next.

8. In the Specify Home Details window, do the following:

   1. Name: Verify that the Oracle home specified is the Oracle Database Oracle home. (The default Oracle home is offered.)

   2. Path: Enter the directory location of the Oracle Database Oracle home where you want to install the Oracle home files. (The directory of the default Oracle home is offered.) Do not enter a directory path that has spaces. After you enter a correct directory path, Oracle Universal Installer creates a new directory for you.

      See also:

      "Identifying the Oracle Home Directory Location" for information on finding the correct Oracle home

9. Click Next.

10. In the Product-specific Prerequisite Checks window, check for and correct any errors that may have occurred when Oracle Universal Installer checked your system.

11. Click Next.

12. In the Summary window, check the list of products that will be installed, and click Install.

13. When the installation completes, click Exit and then click Yes to exit from Oracle Universal Installer.

14. Optionally, delete the OraInstalldate_time directory if you want to remove the temporary files that were created during the installation process. The OraInstalldate_time directory holds about 45 MB of files. This directory is created in the location set by the TEMP environment variable setting.

    Restarting your computer also removes the OraInstalldate_time directory.

15. Restart Oracle HTTP Server. For example:

    ORACLE_BASE\ORACLE_HOME\opmn\bin\opmnctl restartproc ias-component=HTTP_Server
    

    See Also:

    "Starting, Stopping, or Restarting Oracle HTTP Server"

3.4.3 Preparing Oracle Workflow Server for the Oracle Workflow Middle Tier Installation

After you have installed Oracle Workflow server, you need to configure it before you install the Oracle Workflow middle tier components. You use Oracle Workflow Configuration Assistant to configure Oracle Workflow. The following steps explain how to run Oracle Workflow Configuration Assistant by using its graphic user interface.

To prepare Oracle Workflow server for the Oracle Workflow middle tier components:

1. Make sure that the Oracle database that you plan to use for Oracle Workflow is accessible and running.

   You can use the Windows Services utility, located either in the Windows Control Panel or from the Administrative Tools menu (under Start and then Programs), to check that Oracle Database is running. Names of Oracle databases are preceded with OracleService. Right-click the name of the service and from the menu, choose Start.

2. From the Start menu, choose Programs, then Oracle - HOME_NAME, then Configuration and Migration Tools, then Workflow Configuration Assistant.

3. In the Welcome to Oracle Workflow Configuration Assistant window, enter the following information:

   • Install Option - Select either Server Only or Add Language.

     If you choose the Server Only option, Workflow Configuration Assistant installs Oracle Workflow into the Oracle database.

     Note:

     To upgrade to Oracle Workflow release 2.6.4, make sure that the existing Oracle Workflow server is release 2.6.2 or higher.

     If you chose the Add Language installation option, select the language abbreviation for the language that you want to add. You must install Oracle Workflow before you can add a language.

     See Also:

     Oracle Database Globalization Support Guide for a list of language abbreviations used by Oracle database

   • Workflow Account - Enter the name that you want to use for the Oracle Workflow database account or accept the default name, typically owf_mgr.

     The default tablespace for this account is USERS and the temporary tablespace is TEMP. You can change the tablespace if necessary.

     Note:

     If you are upgrading an existing installation of Oracle Workflow, enter the name and password for the existing Oracle Workflow database account.

   • Workflow Password - Enter a password for the Oracle Workflow account.

   • SYS Password - Enter the password for the SYS account of the Oracle Database installation on the system. The password is mandatory for Oracle Workflow Server installations but not if you are adding a language.

   • TNS Connect Descriptor - The database connect string in TNS format:

     (DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =
     host_name)(PORT = port_number))) (CONNECT_DATA = (SERVICE_NAME =
     database_service_name)))
     
     

     The connect string is stored in the tnsnames.ora file, which in a default installation is located in ORACLE_BASE\ORACLE_HOME\network\admin. An easy way to find the connect string in a single-line format is to run the tnsping command at a command prompt, output the results into a text file, and then copy and paste the connect string into the TNS Connect Descriptor box. For example, to get the connect string for a server named mau, you could enter:

     c:\> tnsping mau > tns.txt
     
     

4. If you want to integrate Oracle Internet Directory as the directory repository for Oracle Workflow, select the Enter LDAP Parameters check box and then select Get LDAP Values to display the Workflow LDAP Parameters window.

   Note:

   If you are upgrading an existing Oracle Workflow installation in which you already implemented Oracle Internet Directory integration, you must re-enter the Lightweight Directory Access Protocol (LDAP) values here to preserve the Oracle Internet Directory integration during the upgrade.

   Enter the following LDAP server information for the LDAP directory to which you want to connect and click OK. After the installation, you can update these values if necessary in the Global Workflow preferences Web page.

   See Also:

   Setting Up Oracle Workflow" section in the Oracle Workflow Administrator's Guide for more information

   • LDAP Host Name - Enter the host on which the Lightweight Directory Access Protocol (LDAP) directory is installed.

   • LDAP Non-SSL Port - Enter the port number that the host uses. This port must not be a Secure Sockets Layer (SSL) port.

   • LDAP Admin Username- Enter the username used to connect to the LDAP server. This username must have write privileges and is required to bind to the LDAP directory. For example:

     cn=orcladmin
     
     

   • LDAP Admin Password - Enter the Oracle Internet Directory password for the LDAP user account. LDAP password values are masked as asterisks in the display and are stored in encrypted form.

   • Changelog DN - Enter the LDAP node where change log files are located. For example:

     cn=changelog
     
     

   • User Base - Enter the LDAP node under which user records can be found. For example:

     cn=Base, cn=OracleSchemaVersion
     
     

     Note:

     After setting up integration with Oracle Internet Directory during installation, you must use the WF_LDAP APIs to synchronize the Oracle Workflow directory service with Oracle Internet Directory. For instructions, see Oracle Workflow Administrator's Guide.

5. If you do not want to integrate with Oracle Internet Directory, leave the Enter LDAP Parameters check box blank.

6. To enter configuration parameters for the seeded Java-based notification mailer service component Workflow Notification Mailer, select the Enter Mailer Parameters check box and then select Get Mailer Values to display the Workflow Mailer Parameters. Enter values for the following parameters and then click OK.

   • Inbound EMail Account: Server Name:

     • Server Name - Enter the name of the inbound IMAP mail server.

     • Username - Enter the username of the mail account where the notification mailer receives e-mail messages.

     • Password - Enter the password of the mail account specified in the Username parameter.

   • Outbound EMmail Account - Enter the name of the outbound SMTP mail server.

   • EMail Processing:

     • Processed Folder - Enter the name of the mail folder in the inbound e-mail account where the notification mailer places successfully processed notification messages.

     • Discard Folder - Enter the name of the mail folder in the inbound e-mail account where the notification mailer places incoming messages that are not recognized as notification messages.

   • Message Generation: HTML Agent:

     • HTML Agent - The HTML Agent is the base URL that identifies the Web agent defined for Oracle Workflow in Oracle HTTP Server. The notification mailer uses this URL to support e-mail notifications with HTML attachments. By default, this parameter is set to the following placeholder value:

       http://localhost.com/pls/wf 
       
       

       If you have already installed Oracle HTTP Server, replace localhost.com with the server and TCP/IP port number on which the Web listener accepts requests. Otherwise, leave this parameter set to the placeholder value. In this case you must set this parameter in the notification mailer configuration wizard in Oracle Workflow Manager after you complete the Oracle HTTP Server and Oracle Workflow installations.

       See Also:

       "Setting Up Oracle Workflow" in Oracle Workflow Administrator's Guide

     • Reply-to Address - Enter the address of the e-mail account that receives incoming messages, to which notification responses should be sent.

   After the initial installation, you can update the notification mailer configuration values if necessary in the Oracle Workflow Manager. You can also update the HTML agent value for Oracle Workflow in the Global Workflow preferences Web page.

   See Also:

   "Setting Up Oracle Workflow" in Oracle Workflow Administrator's Guide and Oracle Workflow Manager online help for more information

7. To change the tablespace assigned to the Oracle Workflow database account, select the Change Tablespace check box, then select an existing tablespace from the list of values.

8. Choose Submit to begin the configuration or choose Quit to exit Workflow Configuration Assistant without performing the configuration.

9. When the configuration is complete, a confirmation window appears. Click OK.

   You can check the status of the configuration by reviewing the ORACLE_BASE\ORACLE_HOME\wf\install\workflow.log file.

If you want to add additional languages to Oracle Workflow, rerun Oracle Workflow Configuration Assistant with the Add Language install option.

Do not rerun Oracle Workflow Configuration Assistant with the Server Only install option to add additional Oracle Workflow schemas, because only one Oracle Workflow schema is allowed in each Oracle home. If you attempt this, the configuration assistant will succeed, but you may encounter errors later on in the Oracle Workflow middle tier services.

If you need to recreate the Oracle Workflow schema, first drop the existing schema and deinstall Oracle Workflow. Then follow the instructions in this chapter to reinstall Oracle Workflow and create a new Oracle Workflow schema using the Oracle Workflow Configuration Assistant.

3.5.1 Oracle Home Location for Oracle Database 10g Companion Products

When you install Oracle Database 10g Companion Products, you can install either Oracle HTTP Server, Oracle Workflow middle tier components, or both Oracle HTTP Server and Oracle Workflow middle tier components.

Oracle home locations for these two products are as follows:

• Oracle Workflow middle tier components: You must install Oracle Workflow middle tier components into a new Oracle home. In a new installation, you will install Oracle Workflow middle tier components into the same home as Oracle HTTP Server. If Oracle HTTP Server already is installed, you can install Oracle Workflow middle tier components into the Oracle home where Oracle HTTP Server is installed.

• Oracle HTTP Server: You must install Oracle HTTP Server in a new Oracle home. You can install Oracle HTTP Server more than once on the same system, as long as each installation uses a separate Oracle home directory.

3.5.2 Procedure for Installing Oracle Database 10g Companion CD Products

To install Oracle Database 10g Companion CD Products:

1. Make sure that you have first installed Oracle Workflow server from the Oracle Database 10g Products installation type and run Workflow Configuration Assistant to configure Oracle Workflow.

2. Log on as a member of the Administrators group to the computer on which to install Oracle components.

   If you are installing on a Primary Domain Controller (PDC) or a Backup Domain Controller (BDC), log on as a member of the Domain Administrators group.

3. Delete the ORACLE_HOME environment variable if it exists. Refer to your Microsoft online help for more information about deleting environment variables.

   Note:

   The ORACLE_HOME environment variable is automatically set in the registry. Manually setting this variable prevents installation

4. Insert the Oracle Database installation media and navigate to the companion directory. Alternatively, navigate to the directory where you downloaded or copied the installation files.

   Use the same installation media to install Oracle Database on all supported Windows platforms.

5. Double-click setup.exe to start Oracle Universal Installer.

6. In the Welcome window click Next.

7. In the Select a Product to Install window, choose Oracle Database 10g Companion Products and click Next.

8. In the Specify Home Details window, do the following:

   1. Name: Enter a name for the new Oracle home. You can install the Oracle Database Companion Products into a new Oracle home, or you can install Oracle Workflow middle tier only into an existing Oracle HTTP Server Oracle home. You cannot install the Oracle Database Companion Products into an existing Oracle Database home.

   2. Path: Enter the directory location for the Oracle home. If the directory does not exist, then Oracle Universal Installer creates it for you. Do not enter a directory path that has spaces. After you enter a correct directory path, Oracle Universal Installer creates a new directory for you.

      See also:

      "Identifying the Oracle Home Directory Location" for information on finding the correct Oracle home.

9. Click Next.

10. In the Available Product Components window, select from the following products and then click Next:

    • Apache Standalone (this option installs Oracle HTTP Server)

    • Oracle Workflow Middle Tier

    Note:

    If you are installing Oracle Workflow middle tier in a new Oracle home, you must choose Oracle HTTP Server.

11. In the Product-specific Prerequisite Checks window, check for and correct any errors that may have occurred while Oracle Universal Installer was checking your system.

    If you are installing Oracle Workflow middle tier only into an existing Oracle HTTP Server home, you may need to manually verify the prerequisite check to confirm the selected Oracle home.

12. Click Next.

13. In the Oracle Workflow Middle Tier Configuration window, specify the configuration settings needed for the Oracle Workflow middle tier.

    To configure the Oracle Workflow middle tier, you must create a database access descriptor (DAD) in the mod_plsql configuration files and directory aliases in the Oracle HTTP Server configuration file. The Oracle Universal Installer completes these tasks for you using the information that you specify in this step.

    Enter the following information:

    • Workflow Schema

      Specify the user name (schema name) that you used when installing the Oracle Workflow server database objects in the database. The default user name is owf_mgr.

    • DB Hostname

      Specify the host name of the system where the database is installed. If the host name is the local host, enter the name of the computer, for example, myserver.us.mycompany.com, not localhost.

    • Port Number

      Specify the TCP/IP port number for the Oracle Net listener on the database system. The default port number is 1521. You can find this information in the Oracle database's tnsnames.ora file. In a default installation, this file is located in ORACLE_BASE\ORACLE_HOME\network\admin.

    • Oracle SID

      Specify the database instance identifier (SID) for the database where you installed the Oracle Workflow server database objects.

14. In the Oracle Workflow Middle Tier Configuration window, enter a password for the Oracle Workflow schema you created in the previous step, and then click Next.

15. In the Oracle Apache Installation window, enter the following information required to configure Oracle Workflow middle tier and click Next.

    • Enter Password

      Specify the password for the Workflow user (typically OWF_MGR) that you specified on the previous window. This password is used for the mod_plsql database access descriptor.

    • Confirm Password

      Enter the password again to verify that you have specified it correctly.

16. In the Summary window, check the list of products that will be installed, and click Install.

17. In the End of Installation window, make a note of the URLs that Oracle HTTP Server will use.

    Note:

    These URLs are also listed in the ORACLE_BASE\ORACLE_HOME\Apache\Apache\setupinfo.txt file.

18. Click Exit and click Yes to exit from the Oracle Universal Installer.

19. Optionally, delete the OraInstalldate_time directory if you want to remove the temporary files that were created during the installation process. The OraInstalldate_time directory holds about 45 MB of files. This directory is created in the location set by the TEMP environment variable setting.

    Restarting your computer also removes the OraInstalldate_time directory.

20. Restart Oracle HTTP Server. For example:

    ORACLE_BASE\ORACLE_HOME\opmn\bin\opmnctl restartproc ias-component=HTTP_Server
    

    See Also:

    "Starting, Stopping, or Restarting Oracle HTTP Server"

3.6.1 Removing Oracle HTML DB from Oracle Database

After you have successfully deinstalled Oracle HTML DB using the Oracle Universal Installer, you can remove Oracle HTML DB from the database. Be aware that following these instructions will render inoperable any previous version of HTML DB you may have installed on your system.

1. Connect to the database as a privileged user, such as SYS or SYSTEM, for example:

   c:\> sqlplus sys/SYS_password as sysdba
   
   

2. Execute the following commands:

   SQL> ALTER SESSION SET current_schema = FLOWS_010600;
   SQL> EXEC wwv_flow_upgrade.drop_public_synonyms;
   SQL> ALTER SESSION SET current_schema = SYSTEM;
   SQL> DROP USER FLOWS_010600 CASCADE;
   SQL> DROP USER flows_files CASCADE;
   SQL> DROP USER htmldb_public_user CASCADE;
   
   

3.6.2 Removing Oracle Workflow

To remove Oracle Workflow:

1. Use Oracle Universal Installer to deinstall Oracle Workflow server or the Oracle Workflow middle tier components.

   See Also:

   "Removing Oracle Database Products and Oracle Database Companion CD Products"

2. Drop the Oracle Workflow schema from the database.

   Log in to the database as the SYS user:

   c:\> sqlplus sys/SYS_password as sysdba
   
   

   Enter the following DROP USER command. For example, if the Oracle Workflow schema is named owf_mgr, you would enter:

   SQL> drop user owf_mgr cascade
   

3.6.3 Removing Oracle Database Products and Oracle Database Companion CD Products

The following steps describe how to use Oracle Universal Installer to remove Oracle software:

Stop the Oracle HTTP Server and Oracle Process Manager and Notification services.

1. From the Start menu, select Programs, then Oracle - HOME_NAME, then Oracle Installation Products, then Universal Installer.

2. When the Welcome window appears, click Deinstall Products.

   The Inventory window appears, listing all of the Oracle homes on the system and the products installed in each Oracle home.

3. In the Inventory window, select the Oracle home and the Oracle products that you want to remove.

4. To delete specific products, select them in the tree window.

5. Click Remove.

   A confirmation window appears asking you to confirm that you want to deinstall the products and their dependent components.

6. Click Yes.

   A progress indicator appears as the software is removed.