This chapter covers the following topics:
After completing the tasks in Chapter 1 and Chapter 2, follow these general steps to install the Companion CD products:
Consider the following issues:
Installing in interactive mode or in silent or noninteractive mode: The instructions in this chapter are written for interactive installations. If you prefer to perform the installation in silent mode noninteractive mode using response files—for example, if your site requires multiple installations—read Appendix A, "Installing Oracle Database Companion CD Using Response Files" for more information.
Installing in a Different Language: See "Installing and Using Oracle Components in Different Languages" for language considerations.
Use the procedures under "Accessing the Installation Software" if you install the software from a hard drive or install remotely.
Follow the steps in these sections to complete the installation, depending on the products you want to install:
"Installing Oracle HTML DB and Oracle HTTP Server"
You must install Oracle HTML DB in an Oracle HTTP Server home. If a current Oracle HTTP Server has not been installed yet, the installation process enables you to install both of these products.
"Installing Oracle Database 10g Products"
If you plan to use Oracle Workflow server, which is included in the Oracle Database 10g products, you must complete the steps under "Preparing Oracle Workflow Server for the Oracle Workflow Middle Tier Installation" before installing the Oracle Workflow middle tier components. The Oracle Workflow middle tier components are available with the Oracle Database 10g Companion Products.
"Installing Oracle Database 10g Companion Products"
This section explains how to install Oracle Workflow middle tier components.
The Oracle Database software is available on DVD. Do not use Oracle Universal Installer from an earlier release to install components from this release.
If you install the Oracle Database Companion CD products using any of the following scenarios, follow the procedures in this section before continuing to the installation instructions.
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:
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:
The remote DVD drive must allow shared access. To set this up, perform these steps on the remote computer that has the DVD drive:
Log in to the remote computer as an Administrator user.
Start Windows Explorer.
Right-click the DVD drive letter and choose Sharing (or Sharing and Security).
Click the Sharing tab and do the following:
Select Share this folder.
In Share name, give it a share name such as dvd
. Use this name when you map the DVD drive on the local computer. Under "On the Local Computer, Map the DVD Drive" see Step d under Step 1.
Click Permissions. You need at least "read" permission for the user who accesses it to install Oracle Database.
Click OK when you are finished.
Insert the Oracle Database installation media into the DVD drive.
Perform these steps on the local computer to map a remote DVD drive and to run Oracle Universal Installer from the mapped drive:
Start Windows Explorer on the local computer.
From the Tools menu, select Map Network Drive to display the Map Network Drive dialog.
Select a drive letter to use for the remote DVD drive.
In Folder, enter the location of the remote DVD drive using the following format:
\\remote_hostname\share_name
where:
remote_hostname
is the name of the remote computer with the DVD drive.
share_name
is the share name that you entered in Step 4 of the previous procedure. For example
\\computer2\dvd
If you connect to the remote computer as a different user, Click different user name, and enter the username.
Click Finish.
Run Oracle Universal Installer from the mapped DVD drive.
To install and run the Oracle Database Companion CD products on a remote computer (that is, the remote computer has the hard drive and runs these components), and 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.
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.
The steps that you must complete are:
Ensure that the remote access software is installed and running on the remote and local computers.
Share the hard drive that contains the Oracle Database Companion CD products DVD.
On the remote computer, map a drive letter to the shared hard drive. You would use the remote access software to do this on the remote computer.
Through the remote access software, run Oracle Universal Installer on the remote computer. You access Oracle Universal Installer from the shared hard drive.
You can insert the DVD into a drive on your local computer, and install from the DVD. This is similar to the scenario described in "Installing from a Remote DVD Drive".
The steps that you must complete are:
Ensure that the remote access software is installed and running on the remote and local computers.
On the local computer, share the DVD drive.
On the remote computer, map a drive letter to the shared DVD drive. You would use the remote access software to do this on the remote computer.
These steps are described in "Installing on Remote Computers from a Remote DVD Drive".
Through the remote access software, run Oracle Universal Installer on the remote computer. You access Oracle Universal Installer from the shared DVD drive.
This section covers the following topics:
Oracle Home Location for Oracle HTML DB and Oracle HTTP Server
Procedure for Installing Oracle HTML DB and Oracle HTTP Server
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.
See Also:
Oracle Database Backup and Recovery BasicsWhen 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, install Oracle HTML DB into the same home as Oracle HTTP Server. If Oracle HTTP Server 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 on the same system, if each installation uses a separate Oracle home directory.
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:
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.
Ensure 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.
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:
TheORACLE_HOME
environment variable is automatically set in the registry. Manually setting this variable prevents installation.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.
Double-click setup.exe
to start Oracle Universal Installer.
In the Welcome window click Next.
In the Select a Product to Install window, choose Oracle HTML DB and click Next.
In the Select Installation Type window, select a following choice 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.
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 uses.
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.Click Next.
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.
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.
Click Next.
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 must 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 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.
Click Next.
In the Summary window, check the list of products that has to be installed, and click Install.
When the installation completes, click Exit and then click Yes to exit from Oracle Universal Installer.
Optionally, delete the OraInstall
date_time
directory to remove the temporary files that were created during the installation process. The OraInstall
date_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 OraInstall
date_time
directory.
See Also:
Chapter 4, "Oracle Database Companion CD Postinstallation Tasks" for information on tasks that you must complete after you have installed the Oracle HTML DB and Oracle HTTP Server
"Installing and Configuring Oracle HTML DB on a Remote Oracle Database" to install additional Oracle HTML DB instances in a remote Oracle database
This section covers the following topics:
You must install Oracle Database 10g Products in an existing Oracle Database 10g release 2 (10.2) Oracle home. These products are:
Before you install Oracle Database 10g Products into an existing Oracle home, you must identify the location of this Oracle home. If you do not know the path of the Oracle home directory, you can check it using Oracle Universal Installer.
To check the path of the Oracle home directory:
From the Start menu, choose Programs, then Oracle - HOME_NAME, then Oracle Installation Products, then Universal Installer.
When the Welcome window appears, click Installed Products.
The Inventory window appears, listing all of the Oracle homes on the system and the products installed in each Oracle home.
In the Inventory window, expand each Oracle home and locate Oracle Database 10.2.0.1.0.
Click Close and then Cancel to exit Oracle Universal Installer.
Have the Oracle home name available when you begin installing Oracle Database 10g Products, described next.
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:
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.
Ensure 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.
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:
TheORACLE_HOME
environment variable is automatically set in the registry. Manually setting this variable prevents installation.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.
Double-click setup.exe
to start Oracle Universal Installer.
In the Welcome window click Next.
In the Select a Product to Install window, choose Oracle Database 10g Products and click Next.
In the Specify Home Details window, do the following:
Name: Verify that the Oracle home specified is the Oracle Database Oracle home. (The default Oracle home is offered.)
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 homeClick Next.
In the Product-specific Prerequisite Checks window, check for and correct any errors that may have occurred when Oracle Universal Installer checked your system.
Click Next.
In the Summary window, check the list of products has to be installed, and click Install.
When the installation completes, click Exit and then click Yes to exit from Oracle Universal Installer.
Optionally, delete the OraInstall
date_time
directory to remove the temporary files that were created during the installation process. The OraInstall
date_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 OraInstall
date_time
directory.
Restart Oracle HTTP Server. For example:
ORACLE_BASE\ORACLE_HOME\opmn\bin\opmnctl restartproc ias-component=HTTP_Server
After you have installed Oracle Workflow server, you must 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.
See Also:
"Running Oracle Workflow Configuration Assistant in Noninteractive Mode" for information on running Oracle Workflow Configuration Assistant in noninteractive mode.To prepare Oracle Workflow server for the Oracle Workflow middle tier components:
Ensure 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.
From the Start menu, choose Programs, then Oracle - HOME_NAME, then Configuration and Migration Tools, then Workflow Configuration Assistant.
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, ensure 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 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 databaseWorkflow Account - Enter the name 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
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 implemented Oracle Internet Directory integration, you must reenter 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 informationLDAP 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
If you do not want to integrate with Oracle Internet Directory, leave the Enter LDAP Parameters check box blank.
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 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 GuideReply-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 informationTo 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.
Choose Submit to begin the configuration or choose Quit to exit Workflow Configuration Assistant without performing the configuration.
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 it, the configuration assistant succeeds, but you may encounter errors later on in the Oracle Workflow middle tier services.
If you re-create the Oracle Workflow schema, first drop the existing schema and uninstall 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.
See Also:
Chapter 4, "Oracle Database Companion CD Postinstallation Tasks" for tasks that you must complete after you have installed Oracle Workflow serverThis section covers the following topics:
Oracle Home Location for Oracle Database 10g Companion Products
Procedure for Installing Oracle Database 10g Companion CD 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, install Oracle Workflow middle tier components into the same home as Oracle HTTP Server. If Oracle HTTP Server 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 on the same system, if each installation uses a separate Oracle home directory.
To install Oracle Database 10g Companion CD Products:
Ensure 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.
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.
Delete the ORACLE_HOME
environment variable if it exists. Refer to your Microsoft online help for more information about deleting environment variables.
Note:
TheORACLE_HOME
environment variable is automatically set in the registry. Manually setting this variable prevents installationInsert 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.
Double-click setup.exe
to start Oracle Universal Installer.
In the Welcome window click Next.
In the Select a Product to Install window, choose Oracle Database 10g Companion Products and click Next.
In the Specify Home Details window, do the following:
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.
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.Click Next.
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.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 manually verify the prerequisite check to confirm the selected Oracle home.
Click Next.
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.
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.
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.
In the Summary window, check the list of products that are installed, and click Install.
In the End of Installation window, make a note of the URLs that Oracle HTTP Server uses.
Note:
These URLs are also listed in theORACLE_BASE
\
ORACLE_HOME
\Apache\Apache\setupinfo.txt
file.Click Exit and click Yes to exit from the Oracle Universal Installer.
Optionally, delete the OraInstall
date_time
directory to remove the temporary files that were created during the installation process. The OraInstall
date_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 OraInstall
date_time
directory.
Restart Oracle HTTP Server. For example:
ORACLE_BASE\ORACLE_HOME\opmn\bin\opmnctl restartproc ias-component=HTTP_Server
See Also:
Chapter 4, "Oracle Database Companion CD Postinstallation Tasks" for information on tasks that you must complete after you have installed Oracle HTTP ServerThis section covers the following topics:
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 renders inoperable any previous version of HTML DB you may have installed on your system.
Connect to the database as a privileged user, such as SYS
or SYSTEM
, for example:
c:\> sqlplus sys/SYS_password as sysdba
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;
Use Oracle Universal Installer to uninstall Oracle Workflow server or the Oracle Workflow middle tier components.
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
The following steps describe how to use Oracle Universal Installer to remove Oracle software:
Note:
Always use Oracle Universal Installer to remove Oracle software. Do not delete any Oracle home directories without first using Oracle Universal Installer to remove the software.Stop the Oracle HTTP Server and Oracle Process Manager and Notification services.
From the Start menu, select Programs, then Oracle - HOME_NAME, then Oracle Installation Products, then Universal Installer.
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.
In the Inventory window, select the Oracle home and the Oracle products to remove.
To delete specific products, select them in the tree window.
Click Remove.
A confirmation window appears asking you to confirm to deinstall the products and their dependent components.
Click Yes.
A progress indicator appears as the software is removed.