Creating and initializing Oracle on Windows

Complete the following steps to create and initialize the Oracle database on a Windows server:

Before you begin

The database server software must be installed and configured.
You must have created an Oracle user for the exclusive use by the TrueSight Middleware and Transaction Monitor (TMTM) product.
For the NLS_CHARACTERSET: Use a single byte character set like WE8ISO8859P1 or WE8MSWIN1252.

Access to Oracle objects through synonyms is not supported.
if you plan to use Transaction Management features of TMTM, use the largest data block/page size allowed by the DBMS, preferably 32K. Consult your DBMS vendor documentation on how to create a database or database objects with a larger page size.
The Services server must be in close physical proximity to the database server with a network latency of less than 5ms between them (100 Mb LAN). BMC recommends a gigabit LAN.
Database clients must be appropriate to the installation of the core components and to the database server. TMTM services are 64-bit applications on Windows and Linux (SLES, RHEL). BMC recommends that the database client version matches the database server version.

Install the database client software on any computer that needs access to the database.
Run ora.create.sql and ora.init.sql using SQL*Plus.

sqlplus user/password@OracleServer @ora.create.sql > ora.create.log
sqlplus user/password@OracleServer @ora.init.sql > ora.init.log

Oracle default statistics (collected by Oracle) are acceptable.
The TMTM Oracle user must own the TMTM database objects.
Analyze table and truncate table commands are executed by TMTM. Ensure that the TMTM database user has authority to execute these commands.
When the scripts are complete, ensure that your entire database network is functioning and all of the clients can access and write to the server.
If you use an Oracle database with the TMTM Application Service and your service log indicates it is unable to find the Oracle dll, refer to TMTM Application Service and Oracle.