This document is intended for the System administrator that has the operational responsibility for the op5 system. You are expected to have good knowledge and understanding of computers and Oracle database managment tools.This manual shows how to setup database connections from op5 Monitor to a Oracle database backend under Solaris and Red Hat Enterprise Linux.This manual only covers installation of Oracle extension for op5 Monitor, for further information please consult op5 Monitor User manual and op5 Monitor Administration manual found on www.op5.com/manualsFirst we need to setup the database schema in Oracle database server before configuring op5 Monitor.Two databases should be created, merlin and nacoma. The merlin database will be used to store status information for the monitored objects. The nacoma database is used while changes to the monitored objects are beeing made.merlin database:nacoma database:Name: merlinProtocol: TCPPort: 1521Create a database named 'merlin' using the Oracle tool: 'Database configuration assistant' using the following parameters:Template: General purposeGlobal Database Name: merlinSID: merlinListener: merlinNote: it is important to set and remember the password for the 'system' user since it will be used when setting up the database.sqlplus merlin (Username: system, Password: ****)Name: nacomaProtocol: TCPPort: 1521Create a database named 'nacoma' using the Oracle tool: 'Database configuration assistant' using the following parameters:Template: General purposeGlobal Database Name: nacomaSID: nacomalistener: nacomaNote: it is important to set and remember the password for the 'system' user since it will be used when setting up the database.Direct database access - This mean all database parameters are configured in the configuration file for the respective module. For MySQL this is the only allowed option.TNS database access - This move database name, address and port configuration to config file tnsnames.ora. This method is only supported for Oracle databases. To use RAC (Real Application Cluster) this is the only supported method to configure database access. The configuration examples below are based on the example tnsnames.ora file described in section tnsnames.oraCopy /opt/monitor/op5/ninja/application/config/database.php to /opt/monitor/op5/ninja/application/config/custom/database.php and edit the destination file.cp /opt/monitor/op5/ninja/application/config/database.php /opt/monitor/op5/ninja/application/config/custom/database.phpset ‘dbname’ to the database name set ‘dbport’ to the database portNOTE 1: There should not be any blank lines with in a section in the configuration above. A section start with a identifier enclosed in square brackets ([backend_merlinoci_1] in the example above.To configure merlin you first need to edit /opt/monitor/op5/merlin/merlin.conf. In the database {} section set host and type. Depending on your oracle install name (database name), user and password might also need to be edited.By default merlin uses ‘auto_commit’ meaning every statement is commited. This will impact performance in large environments. To enable bulk operation you use the parameters commit_interval and commit_queries.Enabling these as in the example below mean we commit when we have 2000 queries or when 3 seconds have elapsed, which ever come first. If the database server is heavily loaded it might be beneficial to decrease the number of queries in each operation, commit_interval=1 and commit_queries=500 could be a suitable setting in such cases.To configure merlin you first need to edit /opt/monitor/op5/merlin/merlin.conf. In the database {} section set conn_str to the merlin identifier from configuration file tnsnames.oraDepending on your oracle install user and password might also need to be edited. By default merlin uses ‘auto_commit’ meaning every statement is commited. This will impact performance in large environments. To enable bulk operation you use the parameters commit_interval and commit_queries. Enabling these as in the example below mean we commit when we have 2000 queries or when 3 seconds have elapsed, which ever come first.Secondly you need to edit the config options in the top of /opt/monitor/op5/merlin/import.phpTo configure Nacoma (the object configuration tool) you edit /opt/monitor/op5/nacoma/include/db_config.inc.phpTo configure Nacoma (the object configuration tool) you edit /opt/monitor/op5/nacoma/include/db_config.inc.php