Creating and initializing Oracle on Linux

Before you begin

• The database server software must be installed and configured.
• An Oracle user created for exclusive use by TrueSight Middleware and Transaction Monitor (TMTM).
• Set the following in sqlnet.ora on the TMTM server:
  • DIAG_ADR_ENABLED=FALSE
  • DIAG_DDE_ENABLED=FALSE
  • DIAG_SIGHANDLER_ENABLED=FALSE

• For the NLS_CHARACTERSET: Use a single byte character set like WE8ISO8859P1 or WE8MSWIN1252 if you want the best performance. Multi-byte character sets like AL32UTF8 are okay, though less efficient.
  
  

  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. 

To create and initialize Oracle on Linux

1. Install the database client software on any computer that needs access to the database.
2. 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 10 and 11 default statistics (collected by Oracle) are acceptable.
3. Set the ORACLE_HOME variable for TMTM:
   • Enter set ORACLE_HOME=oracle_client_absolute_path.
   • Enter export ORACLE_HOME.

4. Add the following paths to the .profile file of the local user used to run services.
   Adding these paths to your profile ensures that services can locate and use required third-party software on your system.
   
   Replace db_details with the path to any TMTM database specific shared objects that are needed to run database applications. If necessary, work with your system or database administrator or your database documentation to determine the appropriate information to add to the path. If you do not plan on using a dedicated user account to run services, then follow your company's policies for setting local environment variables to add this information.
   
   

   64-bit Oracle	Export/add to .profile filea
   Linuxb	LD_LIBRARY_PATH=.:/InstallDir:$ORACLE_HOME/lib:$LD_LIBRARY_PATH This allows TMTM to access 64-bit libraries (libclnstsh.so, etc) of the 64-bit Oracle client installation.

   1. The colon is a separator character and must appear between each path.
   2. The LD_LIBRARY_PATH must be set on all Linux systems with the TMTM Application Service.

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

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

Where to go from here

Run scripts to create and initialize the database.