Setting up the Oracle database instance on Windows

Article:HOWTO17771  |  Created: 2009-01-22  |  Updated: 2010-12-09  |  Article URL http://www.symantec.com/docs/HOWTO17771
Article Type
How To


Environment

Subject


Setting up the Oracle database instance on Windows

Before you install Enterprise Reporter, you need to set up an Oracle database instance that Enterprise Reporter can use for data storage.

Table: Setting up the database instance on Windows outlines the process to set up the Enterprise Reporter database instance on Windows.

Table: Setting up the database instance on Windows

Step

Description

1

If you have not yet installed the Oracle database software, do the following:

  • Install Oracle Database 10g Release 2 (10.2.0.1.0)

    We recommend that you do not create the Enterprise Reporter database instance when you install Oracle. Doing so increases the amount of time that it takes to upgrade to 10.2.0.4.

  • Upgrade to 10.2.0.4 or 11.1.0.7

2

Create the database instance with Oracle's Database Configuration Assistant (DBCA). When you use the DBCA, we recommend that you use the General Purpose template.

See Requirements for the Oracle database instance.

3

Ensure that the tnsnames.ora, listener.ora, and sqlnet.ora files include the proper entries. The files reside in the following locations:

  • Solaris: Oracle_HOME/network/admin

  • Windows: Oracle_HOME\network\admin

See Example of the tnsnames.ora file.

See Example of the listener.ora file.

See Example of the sqlnet.ora file.

4

Verify that the Oracle TNS listener service is running. If it is not running, start the listener service.

See Verifying that the Oracle TNS listener is running.

5

(Optional) Manually create the required schema and tablespaces.

See Creating tablespaces and schema for the Oracle database instance.

This step is not required because the Enterprise Reporter installer creates the required schema and tablespaces. We recommend that you let the installer create the schema and tablespaces.

6

Verify that the database instance is properly configured.

See Ensuring that your Oracle database is properly configured.

See Requirements for the Oracle database instance


Legacy ID



v24828768_v25756417


Article URL http://www.symantec.com/docs/HOWTO17771


Terms of use for this information are found in Legal Notices