skip to main content
op5 Oracle Extension : Oracle database configuration
   
Oracle database configuration
First we need to setup the database schema in Oracle database server before configuring op5 Monitor.
These should be provided to you with the product.
Database schemas
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.
These database schemas should have been provided with the delivery this product.
To create the required databases, the following schemas should be used:
merlin database:
merlin_seq-<version>.sql
ninja_seq-<version>.sql
Default dbuser/password included: merlin/merlin (edit file to change this)
nacoma database:
nacoma-<version>.sql
nacoma_roles-<version>.sql
Default dbuser/password included: nacoma/nacoma (edit file to change this).
Merlin database setup
To setup the merlin database follow the steps below:
Create a listner
Create a listener using the Oracle tool 'Net Configuration Assistant'. Suggested parameters:
Name: merlin
Protocol: TCP
Port: 1521
Create the database
Create a database named 'merlin' using the Oracle tool: 'Database configuration assistant' using the following parameters:
Template: General purpose
Global Database Name: merlin
SID: merlin
Listener: merlin
Note: it is important to set and remember the password for the 'system' user since it will be used when setting up the database.
Setup the database
Start sqlplus from the dir where the sql scripts are located.
sqlplus merlin (Username: system, Password: ****)
Execute the two merlin sql scripts listed above:
@merlin_seq-<version>.sql
@ninja_seq-<version>.sql
Nacoma database setup
To setup the nacoma database follow the steps below:
Create a listener
Create a listener using the Oracle tool 'Net Configuration Assistant'. Suggested parameters:
Name: nacoma
Protocol: TCP
Port: 1521
Create the database
Create a database named 'nacoma' using the Oracle tool: 'Database configuration assistant' using the following parameters:
Template: General purpose
Global Database Name: nacoma
SID: nacoma
listener: nacoma
Note: it is important to set and remember the password for the 'system' user since it will be used when setting up the database.
Setup the database
Start sqlplus from the dir where the sql scripts are located.
sqlplus nacoma (Username: system, Password: ****)
Execute the two nacoma sql scripts listed above:
@nacoma-<version>.sql
@nacoma_roles-<version>.sql