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