Netcool Configuration Manager - Base Database Server

The Netcool Configuration Manager - Base database server hosts the database server relational database management system.

The Netcool Configuration Manager - Base database server is the nexus of all the activity that occurs in the Netcool Configuration Manager - Base component. Both the Presentation and Worker servers are constantly reading and writing data in the database, as the product is being utilized by end users or the application programming interface (API).

The database server hosts the database server relational database management system. It is by default configured to listen on port 1521 for Oracle and port 50000 for DB2. The database port needs to be open for database queries that are made by the Netcool Configuration Manager - Base servers. The Presentation server needs access to port 1521 or 50000 to be able to execute the reads and writes that are being requested by either the GUI client or the API. The Worker servers need to connect to the database to gather the UOWs created by end users or API clients and process the UOWs against devices.

Workers will also need to write the configurations they pull from the network devices as well the details of the UOWs they execute. The reporting server will need access to the database server as well to gather the data needed to generate its reports. Finally, the Netcool Configuration Manager - Base administrator should be able to connect to the database from the management client with tools such as SQL Developer. This allows access to the tables that Netcool Configuration Manager - Base uses.

Often times, the Netcool Configuration Manager - Base administrator is not the owner of the database server and the overall management of the database server, the operating system is maintained by another group. Getting access to the database servers console either via SSH or Telnet may or may not be possible based on corporate policy. Direct access to the database console is useful for the Netcool Configuration Manager - Base administrator to help debug issues.