Installing Oracle

Manifold users will often use Oracle database products in conjunction with Manifold System. In particular, Manifold Enterprise Edition users will take advantage of Oracle Spatial Facilities 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.

 

To install Oracle 10g Express Edition (10.2.1.0):

 

1. Close all running applications.

2. Start the installation of Oracle 10g Express Edition by launching OracleXE.exe in the Oracle installation files folder.

3. In the welcome screen click Next.

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

5. In the destination location screen accept the default folder suggested for installation or specify a different folder if desired and click Next.

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

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

8. Wait until the installation completes.

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

11. Double click the Windows Firewall icon.

12. 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 TCP. Click Change Scope. Click My network (subnet) only. Click OK to close the Change Scope dialog. Click OK to close the Add Port dialog.

13. 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 Database Console 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.

2. Press the [...] browse button to the right of the Data source box to launch the Data Sources dialog.

3. Create a connection to Oracle Express and connect to it as given in the example in the Data Source Dialog topic.

 

Once a connection has been made to Oracle Express with Database Console as above the Data source string will remember that connection. Administrator Console (if we have Database Administrator Edition 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.

2. Start the installation of Oracle 10g Enterprise Edition by launching SETUP.EXE in the Oracle installation files folder.

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

4. In the prerequisite checks screen click Next.

5. In the summary screen, click Install.

6. Wait until the installation completes.

7. In the database configuration assistant screen that pops up during the installation, click OK.

8. If you get a Windows Security Alert box asking whether or not you want to block java or javaw, click Keep Blocking.

9. At the end of the installation screen click Exit. In the confirmation dialog click Yes.

 

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.

11. Double click the Windows Firewall icon.

12. 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 TCP. Click Change Scope. Click My network (subnet) only. Click OK to close the Change Scope dialog. Click OK to close the Add Port dialog.

13. Click OK to close the Windows Firewall dialog.

 

 

To install the full version of Oracle client software and configure it connect to an instance of Oracle (not required if Manifold is used on the server machine):

 

1. Close all running applications.

2. Start the installation of Oracle 10g Client by launching SETUP.EXE in the Oracle installation files folder.

3. In the welcome screen click Next.

4. In the installation type screen select Custom and click Next.

5. In the home details screen specify the installation folder or accept the default and click Next.

6. In the product components screen check Oracle Call Interface, Oracle Net as well as any other components you want to install and then click Next.

7. In the prerequisite checks screen click Next.

8. In the summary screen click Install.

9. Wait until the installation completes.

10. 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 is unchecked and click Next.

11. In the naming methods screen of the assistant click Next.

12. In the service name screen of the assistant specify the service name as the database name you used when installing an instance of Oracle (by default, xe for Express Edition and orcl for Enterprise Edition), and click Next.

13. In the protocols screen of the assistant select TCP and click Next.

14. In the TCP / IP configuration screen of the assistant specify the host name as the name of the machine running Oracle and click Next.

15. In the test screen of the assistant click Yes, perform a test and click Next. If the test does not succeed (if it fails the text output will contains the phrase "The test did not succeed."), click Change Login and supply a valid user name (system) and the password you used when installing the instance of Oracle and click OK. After the test succeeds click Next.

16. In the net service name screen of the assistant specify the net service name as something memorable, such as oracledb and click Next. You will use this name when connecting to this database from Manifold and other applications.

17. In the another net service screen of the assistant click No and then click Next.

18. In the done screen of the assistant click Next.

19. In the second done screen of the assistant click Next.

20. In the final done screen of the assistant click Finish.

21. In the end of installation screen click Exit. In the confirmation dialog click Yes.

 

 

To install Oracle Instant Client and configure it to connect to an instance of Oracle (not required if Manifold is used on the server machine):

(This process is also described in the readme file in the archive of installation files downloaded for Oracle client software.)

 

1. Create a new folder (for example, C:\Oracle) and unzip the archive into this folder.

2. Set the system PATH environment variable to include the path to the folder.

3. Set the system TNS_ADMIN environment variable to point to the folder.

4. Create a new blank text file and enter the following text:

 

localservice=

(DESCRIPTION= (ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=server)(PORT=1521)))

(CONNECT_DATA=(SERVICE_NAME=remoteservice))

)

 

Replace localservice with the name to use for the database connection on the machine to which you are installing Instant Client, server with the name of the machine hosting the instance of Oracle you will use, and remoteservice with the name of the database to connect to on that machine (for example, xe if it is the default database name for Oracle Express Edition or orcl if it is the default database name for Oracle Enterprise Edition).

5. Save the text file as TNSNAMES.ORA in the folder created in step 1.

 

 

To connect to an Oracle database using Manifold:

 

1. Set up a connection to the desired database using either the full version of Oracle client software or Oracle Instant Client. This step is not required if Manifold is used on the server machine.

2. Launch Manifold.

3. Launch Tools - Database Console.

4. Click the Browse button to connect to the Data Source dialog.

5. In the Data Source dialog create a connection to the desired Oracle database and connect to it following the example given in the Data Source Dialog topic. When specifying the server name in the in the Oracle Data Source dialog that appears as part of specifying an Oracle data source in the Data Source dialog, specify as the server as:

a) The Windows computer name of the machine being used if Manifold is being used on the server machine. For example, if the Windows Control Panel, System applet's Computer Name tab says the name of our machine is gisfiles that is what we would use.

b) If Manifold is being used on a client machine that is different from the server machine, the name of the database connection as configured in the Oracle client in use. For example, oracledb if we follow the above example for installing the full version of Oracle client software or localservice if we follow the above example of installing Oracle Instant Client and haven't bothered to change the connection name from "localservice". Note: the default server name used for Oracle Express installations is xe and is not oracledb. This is an important detail that is different between Oracle Express and Oracle Enterprise editions.

 

Note that in the above procedures, although there are the expected dialogs to go through for installing Oracle software as there would be for any big-time application with sophisticated options, once the installation is done it is very easy to connect to Oracle from Manifold. Manifold will remember the data source used in both the Database Console and (if Database Administrator Edition is installed) the Administrator Console.

 

Adding Users to Oracle

 

For security and administrative control, it is a good idea to create user logins for an Oracle database so that users can access the database without having to connect using Administrator logins such as system.

 

For Oracle XE and other Oracle products, Oracle provides a convenient Database Control facility running over local web pages that may be used to add users. Launch the Database Control from the Windows Start button, drilling down through All Programs to the Oracle program choices. After logging into the Database Control using the system administrator login we can go to the Administration tab and drill down into the Users page. Click the Create button to launch the Create User page.

 

In the General tab, provide a Name and Password for the user and choose a Default Tablespace (such as USERS) and a Temporary Tablespace (such as TEMP) for the user.

 

In the Roles tab, the user must have a CONNECT role, which is provided by default.

 

In the System Privileges tab, the user must have CREATE SEQUENCE, CREATE TABLE and CREATE TRIGGER privileges. Click the Edit List button and add these privileges.

 

In the Quotas tab, the user must be allowed to use sufficient space for their storage requirements. Many DBMS administrators in small organizations will give users Unlimited quotas for USERS and TEMP tablespaces. This is somewhat trusting of users, but in an era of very large hard disks and reasonably sensible users it often is easier to simply grant unlimited usage than it is for relatively inexpert DBMS administrators to worry about managing storage space quotas.

 

Press OK to create the user. We can then use that user login to connect to the DBMS. Each login that uses the USERS tablespace will be able to see drawings or images stored in the DBMS by other such logins.

 

DBMS administrators will find that Oracle has many first-rate facilities for organizing databases and user access. Such facilities are beyond the scope of this documentation but are well-covered by Oracle documentation and educational resources.

 

See Also

 

Oracle Spatial Facilities

The Data Source Dialog

Tools - Administrator Console