Highlighted
Absent Member.. GTrejos7 Absent Member..
Absent Member..
188 views

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

PROBLEM:
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.....

ERROR
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.



CAUSE:

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.




SOLUTION:

Add the settings as follows:

# ovconfchg -ovrg server -edit

And then add these settings:
[opc]
DATABASE=OML.WORLD
HA_3TIER_CONFIGURATION=NO_HARG
HA_ACTIVE_NODE=TRUE
HA_RESOURCE_GROUP=ov-server
OPC_HA=TRUE
OPC_INSTALLATION_TIME=01/17/13 08:09:54
OPC_INSTALLED_VERSION=09.10.230
OPC_MGMTSV_CHARSET=utf8
OPC_MGMT_SERVER=abc.net
OPC_SVCM_ADD_WARN_IF_EXISTS=TRUE
OPC_SVCM_ERROR_CHECKING=FULL


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:
/var/opt/OV/shared/server/datafiles/xpl/config/settings.dat

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

This is documented in the following KCS article:

http://support.openview.hp.com/selfsolve/document/KM00972168

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.