Contents

Introduction

Prerequisites

Requirements

Components Used

Background Information

Problem

Solution

Introduction

This document describes a step by step procedure to replace nco_g_oracle process with nco_g_jdbc in Prime Central 1.4 and later releases.

Prerequisites

Requirements

Cisco recommends that you have knowledge of these topics:

- Prime Central

- Basic Linux Operating System (OS) commands

Components Used

The information in this document is based on these software and hardware versions:

- Prime Central 1.4 and above

- Oracle database

The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.

Background Information

After Prime Central upgrades from any lower version to Prime Central 1.4 and later releases, at few instances you observe that nco_g_oracle process still runs instead of nco_g_jdbc process.

Default behaviour of upgrade process to Prime Central 1.4 and later release includes replacement of nco_g_oracle by nco_g_jdbc process.

Problem

Prime Central G_JDBC.log throws this error message that indicates the issue wherein nco_g_oracle process still runs post Prime Central 1.4 and later releases sucessfull upgrade:

Fatal: F-IVM-005-001: OpenServer - Fatal Error: Could not find server name 'NCO_GATE' in interfaces file

Note: G_JDBC.log file is stored at installation-directory/faultmgmt/omnibus/log directory.

Solution

Step 1. Check omni.date file for NCO_GATE entries:

[NCO_GATE]

{

Primary: <server_hostname> 4300

}

Note: omni.dat file is stored at installation-directory/faultmgmt/etc directory.

Step 2. If you find other NCO entries like these, and if NCO_GATE entries are not added or added incorrectly then follow Step 3.:

[NCO_GATE_REF]

{

Primary: <server_hostname> 4310

}

[NCO_GATE_TEST]

{

Primary: <server_hostname> 4320

}

[NCO_GATE_PROD]

{

Primary: <server_hostname> 4330

}

Step 3. Add NCO_GATE entries in omni.dat file:

[NCO_GATE]

{

Primary: <server_hostname> 4300

}

Note: You have to add an entry for NCO_GATE with a free open port.

Step 4. Regenerate interfaces file /etc/interfaces.linux2x86:

su - primeusr

cd $NCHOME/bin/

./nco_igen -arch linux2x86

Step  5. Restart JDBC_Gateway:

cd $NCHOME/omnibus/bin

./nco_pa_stop -server NCO_PA -user primeusr -password <primeusrpwd> -process JDBC_Gateway

./nco_pa_start -server NCO_PA -user primeusr -password <primeusrpwd> -process JDBC_Gateway

Note: primeusrpwd is the password for Prime Central application user.

Step 6. Kill the already started nco_g_oracle process from Linux OS.