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:
|
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. |
3 |
Ensure that the
See Example of the tnsnames.ora file. |
4 |
Verify that the Oracle TNS listener service is running. If it is not running, start the listener service. |
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. |