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.