Oracle® Enterprise Manager IBM Tivoli Netcool/OMNIbus Connector Installation and Configuration Guide Release 12.1 (12.1.0.2.0) Part Number E36154-03 |
|
|
PDF · Mobi · ePub |
The Oracle Enterprise Manager Connector Framework requires a web service interface for forwarding event information to IBM Tivoli Netcool/OMNIbus (Netcool/OMNIbus). Since Netcool/OMNIbus does not provide a web services interface, you must install a third-party web service for Netcool/OMNIbus front-end, which is included in the Oracle Enterprise Manager Netcool/OMNIbus installation package.
You can install the web service on a Windows or Unix system that has connectivity to the Netcool/OMNIbus server. In addition to the web service for Netcool/OMNIbus front-end, you must also install a back-end Oracle Agent for Netcool/OMNIbus on the same physical system as the Netcool/OMNIbus server. The Oracle Agent for Netcool/OMNIbus is preconfigured and is also included in the Oracle Enterprise Manager IBM Tivoli Netcool/OMNIbus installation package.
Figure 2-1 shows the communication between the various components of the Netcool/OMNIbus Connector.
The following sections in this chapter discuss these topics:
You can install the web service for IBM Tivoli Netcool/OMNIbus on the following platforms that support Java Runtime Environment (JRE) 1.6:
Microsoft Windows
Oracle Solaris
HP-UX
Linux
You can install the Oracle Agent for IBM Tivoli Netcool/OMNIbus on the following platforms:
Microsoft Windows (2000, 2003, 2008, XP)
IBM AIX (RS/6000 OS version 5.2+, 5.3, 6.x, and 7.x)
Linux RHEL (64-bit) 5.3, 5.4, 5.6
Oracle Solaris (8, 9, and 10)
Ensure that the following prerequisites have been met before proceeding to the next section.
My Oracle Support Preferred Credentials must be set to enable you to download the Connector from the Self Update page of the Enterprise Manager Cloud Control.
To set the credentials:
From the Setup menu of Enterprise Manager Cloud Control, select My Oracle Support, then select Set Credentials.
Enter the user name and password information, then click Apply.
From Setup menu, select Extensibilty, then Self Update.
From the Self Update page, click Check Updates to schedule a job to collect the metadata for the connector.
See Also:
"Using Self Update to Download Oracle Products" section of the Enterprise Manager Cloud Administration Guide for more details.An IBM Tivoli Netcool/OMNIbus user account must be set up that the web service for Netcool/OMNIbus can use to access the Object Server database. The account must have read permission to the alerts.status
, alerts.details
, and alerts.journal
database tables.
An unzip utility must be available on the system where the Oracle Agent for Netcool/OMNIbus is to be installed.
A Netcool/OMNIbus Process Agent must be installed on the system where the Oracle Agent for Netcool/OMNIbus is to be installed. Oracle recommends installing the Oracle Agent for Netcool/OMNIbus on the Object Server system.
The Netcool/OMNIbus connector requires a Netcool/OMNIbus TEC EIF Probe to insert events into IBM Tivoli Netcool/OMNIbus. This probe can be a single standalone master or a master/slave pair. At a minimum, a master Netcool/OMNIbus TEC EIF Probe must be installed on a system that has connectivity to the Object Server system.
The Netcool/OMNIbus connector is not included out-of-box, so you need to download it from the Oracle Enterprise Manager store. All connectors in the store are available for download via the Self Update page of Enterprise Manager Cloud Control.
Note:
There are no special privileges needed to download a connector. However, you need the Super Administrator privilege to apply a connector.To download and install (apply) the connector:
From the Setup menu, select Extensibility, then select Self Update.
Click the Management Connector link in the Type column.
The IBM Tivoli Netcool/OMNIbus connector appears in the list with a status of Available.
Click on IBM Tivoli Netcool/OMNIbus connector to select it, then click Download.
The Schedule Download window appears, where you can determine when the download should be performed.
Click Select to download immediately.
If you want to schedule the download for a later time, specify the date and time when the download should occur, and click Select. You will need to return and finish the remainder of this procedure after the scheduled download date and time.
If necessary, refresh the screen until the status of the connector changes to Downloaded.
Click on the IBM Tivoli Netcool/OMNIbus connector to select it, and then click Apply.
After you respond to the prompt to confirm the operation, a page appears that indicates the request has been submitted.
Refresh the screen until the status of the connector changes from Apply Scheduled to Applied.
See Also:
"Using Self Update to Download Oracle Products" section of the Enterprise Manager Cloud Administration Guide for detailed information and diagnostic procedures.The agent and web service installation files are included in the Self Update archive that was installed in Installing the Connector in Enterprise Manager.
To export the installation files:
Determine the command required to export the adapter installation file. To do this, perform the following steps:
From the Setup menu, select Extensibility, then Self Update.
Click on the Management Connector link in the Type column.
Click on the IBM Tivoli Netcool/OMNIbus connector to select it, then select Export from the Actions list.
A pop-up window similar to the example shown in Figure 2-2 appears with the command required to export the file.
Open a command window on the Enterprise Manager host system and navigate to a temporary directory where you can copy the file.
Log into EM CLI using the following command:
emcli login -username=<Enterprise Manager Super Administrator log in>
You will be asked to provide the password information.
You must execute EM CLI from the OMS server system. See the Oracle Enterprise Manager Command Line Interface for information about setting up EM CLI.
Run the EM CLI export_update
command from your system, changing <dirname>
to the full path of the temporary directory.
This action creates a zip file. The file name is comprised of the ID value you specify in the export_update
command with a .zip extension. In the example command in Figure 2-2, the zip file name would be:
1208A7C0D8913455B18D12F65ABCA8A0.zip
Extract the installation files from the zip file using the following command:
unzip *.zip archives/*
The web service for Netcool/OMNIbus acts as a front-end for all data flowing into and out of Netcool/OMNIbus. Oracle Enterprise Manager posts calls to the web service whenever it needs to create or update an alert or get new or updated alerts from Netcool/OMNIbus.
You can install the web service for Netcool/OMNIbus on any Unix or Windows system that runs the Oracle JRE 1.6 and has connectivity to the Netcool/OMNIbus server and the Oracle Enterprise Manager OMS (Oracle Management Service).
The following sections explain how to install and then subsequently run the Web Service on a Unix platform:
The following prerequisites must be met before proceeding to the next section:
To install the web service on a Unix platform, perform the following steps:
Create a directory where you want to install the web service.
Copy the OMNIbus_webservices_adapter.jar
file from the Management Server host system to the web service installation directory. The file is located in the archives directory that was extracted in Exporting the Installation Files.
Open a command prompt window and change the working directory to the web service installation directory.
Enter the following command to extract the web services components from the web services .jar file:
jar xvf OMNIbus_webservices_adapter.jar
Note:
If the system where the web service for Netcool/OMNIbus is being installed does not have the JRE installed, you cannot extract the jar file contents. You need to copy the .jar file to a system that has the installed JRE and transfer the files after they have been extracted.This creates the adapters directory that contains the installation files.
Enter the following command to change the working directory:
cd adapters/endpoints/omnibus
Enter the following command to run the installation script:
sh ./install.sh
When the script prompts whether you want to use HTTPS:
If you specify Y, then the web service is set up to use HTTPS port number 8443.
If you specify N, then the web service is set up to use HTTP port number 8080.
When the script prompts for the user name of the web service, enter a user name that must be provided to access the web service for Netcool/OMNIbus.
The user name can be any value and is not associated with any specific OS or Netcool/OMNIbus account. Make a note of this value and supply it when configuring the Netcool/OMNIbus connector in Enterprise Manager.
When the script prompts for the password of the web service, enter the password that must be provided to access the web service for Netcool/OMNIbus.
The password can be any value and is not associated with any specific OS or Netcool/OMNIbus account. Note this value and supply it when configuring the Netcool/OMNIbus connector in Enterprise Manager.
When the script prompts for the username to access the Object Server database, enter the username of an account that has read access to the alerts.status
, alerts.details
, and alerts.journals
database tables.
When the script prompts for the password to access the Object Server database, enter the password for the account specified in the previous step.
When the script prompts for the host name of the Object Server system, enter the host name or IP address of the system where the Object Server is installed. You will not be allowed to specify a host name of localhost, because the web service will fail when attempting to connect to the Object Server database.
When the script prompts for the Object Server database port number, enter the port number to use when connecting to the Object Server database. The default port number is 4100. To determine the port number used by your system, start the Netcool/OMNIbus Administrator and open the Object Servers window. The port number for the Object Server is listed on this window.
The web service can be configured to attempt to connect to a backup Object Server database if there are problems connecting to the primary Object Server database. You are prompted to specify whether you want to configure the web service to connect to a backup Object Server instance. If you answer N to the prompt, skip to step 17.
When the script prompts for the host name of the backup Object Server system, enter the host name or IP address of the system where the backup Object Server is installed. You are not allowed to specify a host name of localhost, because the web service will fail when attempting to connect to the Object Server database.
When the script prompts for the backup Object Server database port number, enter the port number to use when connecting to the backup Object Server database. The default port number is 4100. To determine the port number used by your system, start the Netcool/OMNIbus Administrator and open the Object Servers window. The port number for the Object Server is listed on this window.
When the script prompts for the master EIF probe host name, enter the host name or IP address of the system where the master TEC EIF probe is installed.
When the script prompts for the master EIF probe port number, enter the port number to use when connecting to the master TEC EIF probe. The port number is defined in the PortNumber
property in the tivoli_eif.props
file. The file is located in the EIF probe installation directory.
The web service can be configured to also send events to a slave EIF probe when sending events to the master EIF probe. You will be prompted to specify whether you want to configure the web service to send events to a slave EIF probe. If you answer N to the prompt, skip to step 22.
When the script prompts for the slave EIF probe host name, enter the host name or IP address of the system where the slave TEC EIF probe is installed.
When the script prompts for the slave EIF probe port number, enter the port number to use when connecting to the slave TEC EIF probe. The port number is defined in the PortNumber
property in the tivoli_eif.props
file. The file is located in the EIF probe installation directory.
After the script displays the message "Netcool/OMNIbus Adapter Install Complete," press Enter to complete the installation.
Copy additional required jar files as specified in Copying the Required .jar Files
If the web service was configured to run using the HTTPS protocol, you must set up SSL as specified in Section 6.1, "Configure Oracle Enterprise Manager to Use SSL."
Delete the OMNIbus_webservices_adapter.jar
file from the installation directory.
The web service framework is now installed and ready to start.
To run the web service for Netcool/OMNIbus framework commands listed with the following tasks, first change the working directory to ...
adapters/bin
... in the installation directory.
Start: ./service.sh start
Shut Down: ./service.sh stop
Restart: ./service.sh restart
Check Status: ./service.sh status
Perform the following steps to verify that the web service for Netcool/OMNIbus is functional.
Open a terminal and change the working directory to the adapters/bin
directory in the installation directory.
Run the test script:
./testAdapter.sh
When the utility prompts for the web service password, enter the password you specified for the web service for Netcool/OMNIbus in step 9 of Installing the Web Service on Unix.
If the test completes successfully, the last line the utility displays is "Test completed successfully."
The web service for Netcool/OMNIbus requires you to copy the following .jar files to the lib/adapters
directory:
log.jar
— Used by the EIF probe
evd.jar
— Used by the EIF probe
jconn2.jar
— Sybase JDBC driver file
To copy the appropriate .jar files, complete the following steps:
From the Object Server system, access the following directory:
Unix:
$OMNIHOME/probes/<platform>
Windows:
%OMNIHOME%\probes\<platform>
Where:
<platform>
is the actual platform name (such as win32
).
Copy the log.jar
and evd.jar
files to the lib/adapters
directory in the web service installation directory.
Access the following URL to download the Sybase JDBC driver file:
http://downloads.sybase.com/swd/summary.do?client=support&baseprod=63
Create an account, which is required to download the driver. After you have created an account, select All from the drop-down list next to "Display" and "in all months" next to "platforms."
Click Go to get a list of drivers available for download.
Select jConnect for JDBC - EBF 13904: 5.5 ESD #22 and download.
This action downloads the EBF13904.tgz
file. This file includes the jconnect55.zip
file. The jconn2.jar
file is located in this zip file in the jconnect55/jConnect-5_5/classes
directory.
Copy the jconn2.jar
file to the lib/adapters
directory.
To uninstall the web service on Unix:
Open a command terminal on the system where the web service is installed.
Change the working directory to the adapters/bin directory in the web service installation directory.
Enter the following command to shut down the web service:
./service.sh stop
Enter the following command to go up two levels in the directory structure:
cd ../..
Remove the adapters directory and all subdirectories using the following command:
rm -rf adapters
The following sections explain how to install and then subsequently run the web service for Netcool/OMNIbus on a Windows platform:
The following prerequisites must be met before proceeding to the next section.
Oracle Java Runtime Environment (JRE) version 6 Update 11 or higher is installed.
JAVA_HOME
environment variable is set to the JRE installation directory.
Zip utility, such as WinZip, is installed for unzipping a zip file.
To install the web service on a Windows platform, perform the following steps:
Create a directory where you want to install the web service.
Copy the OMNIbus_webservices_adapter.jar
file from the Management Server host system to the web service installation directory. The file is located in the archives directory that was extracted in Exporting the Installation Files
Open a command prompt window and change the working directory to the web service installation directory.
Enter the following command to extract the web services components from the web services .jar
file:
jar xvf OMNIbus_webservices_adapter.jar
Note:
If the system where the web service for Netcool/OMNIbus is being installed does not have the JRE installed, you cannot extract the jar file contents. You need to copy the jar file to a system that has the installed JRE and transfer the files after they have been extracted.This creates the adapters directory that contains the installation files.
Enter the following command to change the working directory as follows:
cd adapters\endpoints\omnibus
Enter the following command to run the installation script:
install.bat
When the script prompts whether you want to use HTTPS:
If you specify Y, then the web service is set up to use HTTPS port number 8443.
If you specify N, then the web service is set up to use HTTP port number 8080.
When the script prompts for the user name of the web service, enter a user name that must be provided to access the web service for Netcool/OMNIbus.
The user name can be any value and is not associated with any specific OS or Netcool/OMNIbus account. Note this value and supply it when configuring the Netcool/OMNIbus connector in Enterprise Manager.
When the script prompts for the password of the web service, enter the password that must be provided to access the web service for Netcool/OMNIbus.
The password can be any value and is not associated with any specific OS or Netcool/OMNIbus account. Note this value and supply it when configuring the Netcool/OMNIbus connector in Enterprise Manager.
When the script prompts for the username to access the Object Server database, enter the username of an account that has read access to the alerts.status
, alerts.details
, and alerts.journals
database tables.
When the script prompts for the password to access the Object Server database, enter the password for the account specified in the previous step.
When the script prompts for the host name of the Object Server system, enter the host name or IP address of the system where the Object Server is installed. You will not be allowed to specify a host name of localhost, because the web service will fail when attempting to connect to the Object Server database.
When the script prompts for the Object Server database port number, enter the port number to use when connecting to the Object Server database. The default port number is 4100. To determine the port number used by your system, start the Netcool/OMNIbus Administrator and open the Object Servers window. The port number for the Object Server is listed on this window.
The web service can be configured to attempt to connect to a backup Object Server database if there are problems connecting to the primary Object Server database. You will be prompted to specify whether you want to configure the web service to connect to a backup Object Server instance. If you answer N to the prompt, skip to step 17.
When the script prompts for the host name of the backup Object Server system, enter the host name or IP address of the system where the backup Object Server is installed. You will not be allowed to specify a hostname of localhost, because the web service will fail when attempting to connect to the Object Server database.
When the script prompts for the backup Object Server database port number, enter the port number to use when connecting to the backup Object Server database. The default port number is 4100. To determine the port number used by your system, start the Netcool/OMNIbus Administrator and open the Object Servers window. The port number for the Object Server is listed on this window.
When the script prompts for the master EIF probe hostname, enter the host name or IP address of the system where the master TEC EIF probe is installed.
When the script prompts for the master EIF probe port number, enter the port number to use when connecting to the master TEC EIF probe. The port number is defined in the PortNumber
property in the tivoli_eif.props
file. The file is located in the EIF probe installation directory.
You can also configure the web service to also send events to a slave EIF probe when sending events to the master EIF probe. You will be prompted to specify whether you want to configure the web service to send events to a slave EIF probe. If you answer N to the prompt, skip to step 22.
When the script prompts for the slave EIF probe hostname, enter the host name or IP address of the system where the slave TEC EIF probe is installed.
When the script prompts for the slave EIF probe port number, enter the port number to use when connecting to the slave TEC EIF probe. The port number is defined in the PortNumber
property in the tivoli_eif.props
file. The file is located in the EIF probe installation directory.
After the script displays the message "Netcool/OMNIbus Adapter Install Complete," click Enter to complete the installation.
Copy additional required jar files as specified in Copying the Required .jar Files
If the web service was configured to run using the HTTPS protocol, you must set up SSL as specified in Section 6.1, "Configure Oracle Enterprise Manager to Use SSL."
Optional: If you want to run the web service as a Windows service, perform the following steps:
Change the working directory to the adapters\bin
directory in the installation directory.
Enter the following command to install the web service as a Windows service:
service.bat install
Delete the OMNIbus_webservices_adapter.jar
file from the installation directory.
The web service framework is now installed and ready to start.
You can run the web service either as a standalone service or Windows service.
Running as a Standalone Service
To start the web service for Netcool/OMNIbus framework when set up as a standalone application (not set up to run as a Windows service):
Change the working directory to the adapters\bin
directory in the installation directory.
Run the following command:
startAdapters.bat
To shut down the web service Netcool/OMNIbus framework, close the window where you started the web service.
To start the web service for Netcool/OMNIbus framework when set up to run as a Windows service, enter the following command:
net start iWaveAdapters
To shut down the web service Netcool/OMNIbus framework, enter the following command:
net stop iWaveAdapters
Perform the following steps to verify that the web service for Netcool/OMNIbus is functional.
Open a terminal and change the working directory to the adapters\bin
directory in the installation directory.
Enter the following command to run the test script:
.\testAdapter.bat
When the utility prompts for the web service password, enter the password you specified for the web service for Netcool/OMNIbus in step 9 of Installing the Web Service on Windows.
If the test completes successfully, the last line the utility displays is "Test completed successfully."
To uninstall the web service on Windows:
Open a command terminal on the system where the web service is installed.
Change the working directory to the adapters\bin
directory in the web service installation directory.
Enter the following command to shut down the web service:
.\service stop
If the web service was configured to run as a windows service, enter the following command to uninstall the web service as a windows service:
.\service uninstall
Delete the web service installation directory (adapters) and all subdirectories.
The Oracle Agent for Netcool/OMNIbus is invoked by an Object Server external procedure to send event information to the web service for Netcool/OMNIbus.
Note:
The IBM Tivoli Netcool/OMNIbus Process Control/Process Agent must first be installed on the system where the Agent is to be installed. Oracle recommends installing the Oracle Agent for Netcool/OMNIbus on the Object Server system.To install the Oracle Agent for Netcool/OMNIbus, perform the following steps:
Create a directory where you want to install the Oracle Agent for Netcool/OMNIbus.
Determine the name of the installation file based on the OS platform where the agent is being installed.
The platforms and associated installation files are as follows:
Windows — OMNIbusAgentWindows.zip
AIX — OMNIbusAgentAIX.tar.gz
Linux — OMNIbusAgentLinux.tar.gz
Oracle Solaris — OMNIbusAgentSolaris.tar.gz
Transfer the appropriate installation file from the Management Server host system to the Agent installation directory. The file is located in the archives directory that was extracted in Exporting the Installation Files.
Extract the files from the zip archive. This creates the agent directory that contains the installation files.
Change the working directory to the agent directory.
Run the setup script to configure the agent.
The file name depends on the platform. If the platform is Windows, the setup script is named Setup.cmd
. For all other platforms, the setup script is named setup.sh
and should be called using the following command:
sh ./setup.sh
When the script prompts for the web service host name, enter the host name or IP address where the web service for Netcool/OMNIbus is installed.
When the script prompts for the web service port, enter the port number the web service for Netcool/OMNIbus uses to receive transactions from the Agent. Specify the default value of 8080 unless the web service has been reconfigured to use a different port.
When the script prompts for the user ID to specify when creating event journal entries in Netcool/OMNIbus, enter the user ID of a user that has permission to add journal entries. If no value is specified, the user ID will default to 0 (root
). The value specified must be an integer value and will not work properly if a different value is entered.
The script generates the necessary configuration files and places them in the Agent directory. The Agent is now installed, but you need to make some modifications in Netcool/OMNIbus for everything to function properly.
Perform the steps in Modifying Netcool/OMNIbus to complete the setup.
To uninstall the Oracle Agent for Netcool/OMNIbus:
Perform the steps in Uninstalling Modifications to Netcool/OMNIbus.
Delete the Oracle Agent for Netcool/OMNIbus installation directory and all of its contents.
The procedures in the following sections enable you to configure Netcool/OMNIbus to work with the installed Oracle Agent and web service components:
Configuring the Object Server Database to create a custom database table and the triggers/procedures the Oracle Agent and web service require.
Configuring the TEC EIF Probe to change the configuration of the TEC EIF probe to populate the custom database table when creating/updating events in Netcool/OMNIbus.
Change Deduplication Trigger Priority to change the configuration of the TEC EIF probe to populate the custom database table when creating/updating events in Netcool/OMNIbus.
Perform the following steps to run the configuration script that sets up the Netcool/OMNIbus Object Server database to work with the installed Oracle Agent and web service components.
If the Oracle Agent for Netcool/OMNIbus was NOT installed on the primary Object Server system, copy the configure_oracle_webservice.sql
file from the system where the Oracle Agent for Netcool/OMNIbus was installed to the system where the primary Object Server is installed.
Run the SQL script using the appropriate command listed below based on the applicable platform:
Unix:
$OMNIBUSHOME/bin/nco_sql -S <objserver> -U <username> -P <password> < <script_directory>/configure_oracle_webservice.sql
Windows:
"%OMNIBUSHOME%\bin\isql" -S <objserver> -U <username> -P <password> -i <script_directory>\configure_oracle_webservice.sql
When entering the commands, provide the following information:
objserver
— Object Server name
username
— User name that will be used when connecting to the database. The account must have permission to create tables, triggers, and procedures in the Object Server database.
password
— Password associated with the user name
script_directory
— Directory where the configure_oracle_webservice.sql
file is located. If the Oracle Agent for Netcool/OMNIbus was installed on the primary Object Server system, this will be the Oracle Agent for Netcool/OMNIbus installation directory. Otherwise, it will be the directory where the file was copied.
You need to manually change the set up of the TEC EIF probe configuration to accept alerts from the web service for Netcool/OMNIbus. You must modify the existing EIF probe rules file to include an Oracle-supplied rules file.
Note:
If the probes are configured to operate in a master/slave pair, these changes are required for each probe.To install the new rules file, perform the following steps:
Shut down the EIF probe.
Access the EIF probe installation directory.
Make a back-up copy of the existing tivoli_eif.rules
file.
Copy the oracle_eif.rules
file from the system where the Oracle Agent for Netcool/OMNIbus was installed to the EIF probe install directory.
Modify the tivoli_eif.rules
file as follows:
Insert the following statements before any other executable statements:
defaultAlerts = registertarget("<PRIMARY>", "<BACKUP>", "alerts.status") OracleAlerts = registertarget("<PRIMARY>", "<BACKUP>", "custom.oracle_status")
Replace <PRIMARY>
with the name of the primary object server.
Replace <BACKUP>
with the name of the back-up server. If a back-up is not configured, replace it with an empty string so that the back-up server is "".
In the location where the tivoli_eif_tpc.rules
and tivoli_eif_tsm.rules
files are included, add an include statement for the oracle_eif.rules
file.
Save the tivoli_eif.rules
file.
Make sure the Inactivity parameter for the tivoli_eif.props
file is set to 0.
Restart the EIF probe.
The oracle_alert_reinserted
trigger in the primary_only
group must run first in order to function properly. To ensure the trigger runs first, the priority of the deduplication trigger in the default_triggers
group must be changed from 1 to 2.The trigger priority can modified using the Netcool/OMNIbus Administrator application.
Note:
On some older versions of Netcool/OMNIbus, this trigger does not exist. If the trigger does not exist in your system, then no changes are required in this section.To uninstall modification made to Netcool/OMNIbus:
Revert Deduplication Trigger Priority
Change the priority of the deduplication trigger in the default_triggers
group back to 1. The trigger priority can modified using the Netcool/OMNIbus Administrator application.
Revert TEC EIF Probe Configuration
Perform the following to revert the TEC EIF probe configuration back to its original settings:
Shut down the EIF probe.
Access the EIF probe installation directory.
Replace the tivoli_eif.rules
file with the backup copy of the file that was created during installation.
Delete the oracle_eif.rules
file from the EIF probe install directory.
Restart the EIF probe.
Revert the Object Server Database Configuration
Perform the following steps to uninstall the customizations made to the Netcool/OMNIbus Object Server database during installation:
If the Oracle Agent for Netcool/OMNIbus was NOT installed on the primary Object Server system, copy the uninstall_oracle_webservice.sql
file from the system where the Oracle Agent for Netcool/OMNIbus was installed to the system where the primary Object Server is installed.
Run the SQL script using the appropriate command listed below based on the applicable platform:
Unix:
$OMNIBUSHOME/bin/nco_sql -S <objserver> -U <username> -P <password> <script_directory>/uninstall_oracle_webservice.sql
Windows:
"%OMNIBUSHOME%\bin\isql" -S <objserver> -U <username> -P <password> -i <script_directory>\uninstall_oracle_webservice.sql
When entering the commands, provide the following information:
objserver
— Object Server name
username
— User name that will be used when connecting to the database. The account must have permission to delete tables, triggers, and procedures from the Object Server database.
password
— Password associated with the user name
script_directory
— Directory where the uninstall_oracle_webservice.sql
file is located. If the Oracle Agent for Netcool/OMNIbus was installed on the primary Object Server system, this will be the Oracle Agent for Netcool/OMNIbus installation directory. Otherwise it will be the directory where the file was copied.