Installing Oracle Installing Oracle Manifold users will often use Oracle database products in conjunction with Manifold System. In particular, Manifold users will take advantage of that are provided within Enterprise Edition to store drawings and images within Oracle servers. This topic provides a summary of installation procedures that may be used to install Oracle products for use with Manifold. Two products are covered: Oracle 10g Express Edition and Oracle 10g Enterprise Edition. In addition, Oracle Client software should be installed on machines that will be working with Oracle databases. The client software need not be installed on the machine on which the Oracle Express or Enterprise server software is installed. These software packages may be downloaded at no charge from Oracle's web site and used to develop applications.

The following summaries have been written for installation on a Windows XP SP2 machine using Oracle versions that were downloadable at the time of this writing. Procedures for Windows Server 2003 and for newer Oracle editions will be very similar.

3 Upgrading to the New Release of Oracle Database. Upgrading to a new release of Oracle Database is a basic part of database maintenance and administration. In the summary screen note the port numbers used (For example, Oracle database listener: 1521, Oracle Services for Microsoft Transaction Server: 2030, HTTP. In the welcome screen of the Oracle Net Configuration Assistant that comes up at the end of the installation process, be sure the Perform typical configuration box.

To install Oracle 10g Express Edition (10.2.1.0): 1. Close all running applications. Start the installation of Oracle 10g Express Edition by launching OracleXE.exe in the Oracle installation files folder.

In the welcome screen click Next. In the license screen read through the license and then click I accept the terms in the license agreement, and click Next.

In the destination location screen accept the default folder suggested for installation or specify a different folder if desired and click Next. In the password screen enter a password string in the Enter password text box. Enter the same string in the Confirm password text box, and click Next.

Write down the password you used. In the summary screen note the port numbers used (For example, Oracle database listener: 1521, Oracle Services for Microsoft Transaction Server: 2030, HTTP listener: 8080), then click Install. Wait until the installation completes. In the installation complete screen click Finish. Close the database portal page, if you have any open.

Configuring Windows Firewall (This continuation of the installation is not necessary if you are not planning to access this instance of Oracle from other machines or if the firewall is turned off.) 10. Launch the Windows Control Panel. Double click the Windows Firewall icon. Switch to the Exceptions page. Click Add Port. Set (that is, enter) the name to Oracle Listener. Set the port number to the value noted in step 9 above (for example, 1521).

Click Change Scope. Click My network (subnet) only. Click OK to close the Change Scope dialog. Click OK to close the Add Port dialog. Click OK to close the Windows Firewall dialog. After following the above steps it is easy to test that an Oracle Express installation is functional by using the in Manifold to quickly connect to Oracle. The following set of instructions assumes we are running Manifold on the same machine on which Oracle has been installed.

Connecting to an Oracle Express Installation: 1. Launch Manifold and launch the Tools - Database Console command. Press the [.] browse button to the right of the Data source box to launch the Data Sources dialog. Create a connection to Oracle Express and connect to it as given in the example in the topic. Once a connection has been made to Oracle Express with Database Console as above the Data source string will remember that connection. (if we have installed) will also remember that connection for the dialog's Data source. To install Oracle 10g Enterprise Edition (10.2.0.1): 1.

Close all running applications. Start the installation of Oracle 10g Enterprise Edition by launching SETUP.EXE in the Oracle installation files folder. Bamboo The Gift Of The Gods Pdf Converter there. In the installation method screen select Basic Installation. Set installation type to Enterprise Edition. Note the database name ( orcl). Enter a password string in the Enter password text box.

Enter the same string in the Confirm password text box, and click Next. In the prerequisite checks screen click Next.

In the summary screen, click Install. Wait until the installation completes. In the database configuration assistant screen that pops up during the installation, click OK. If you get a Windows Security Alert box asking whether or not you want to block java or javaw, click Keep Blocking. At the end of the installation screen click Exit. In the confirmation dialog click Yes.