Absent Member.. GTrejos7 Absent Member..
Absent Member..

[ST OMU] OMU processes down and getting error "ORA-12154: TNS:could not resolve the connect ..."

Operations Manager for Unix/Linux (OMU/OML) shows all the process down and there is no connection to the Database
as "opc_op" user.

The following error when trying to verify connection to the Database:

#echo "select count(*) from opc_act_messages;" | /opt/OV/bin/OpC/opcdbpwd -exe sqlplus -s
ORA-12154: TNS:could not resolve the connect identifier specified
SP2-0306: Invalid option
Usage: CONN.....

ORA-01017: invalid username/password; login denied

Issuing a tnsping command to the instance of the DB works fine.
The listener is running just fine as well.


Somehow all the settings in the [opc] namespace in ovrg server were deleted.
Only local settings for the [opc] namespace are present.
Among other things that contains the DATABASE setting with the Oracle Net name for the database.
That’s why the OML processes are not able to connect to the database.


Add the settings as follows:

# ovconfchg -ovrg server -edit

And then add these settings:
OPC_INSTALLATION_TIME=01/17/13 08:09:54

These settings are not the most recent ones, so it is recommended to check if there are more recent settings,
for example from a more recent itochecker.

Also, the ovrg server settings are stored in this file:

If customer has a backup, they could selectively restore that file to get more recent settings.

This is documented in the following KCS article:


HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
If you liked it I would appreciate KUDOs.
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.