Problem : tnsping service test fails

Error :

1. TNSPING test under generic services in Enterprise Manager fails.

2. Manually running tnsping from the bin directory of the agent home (which hosts the beacon) fails with the following error:-

[oracle@svruatebsdl1 SVRUAT_svruatebsdl1]$ tnsping SVRPRD

TNS Ping Utility for Linux: Version 11.1.0.7.0 - Production on 06-NOV-2013 20:50:39

Copyright (c) 1997, 2008, Oracle.  All rights reserved.

Message 3511 not found; No message file for product=network, facility=TNSMessage 3512 not found; No message file for product=network, facility=TNSAttempting to contact ( (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=svrprdebsdl1.singiri.com)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=SVRPRD) (INSTANCE_NAME=SVRPRD)))

TNS-12533: Message 12533 not found; No message file for product=network, facility=TNS

Solution A:

The following workaround is effective, but will not record a corrective action in the agent inventory as should be considered an inferior solution, consequently:

Copy the missing files from an Oracle database install hosted on a similar operating system as the agent hosting the beacon.  Note that the tnsping in the 11.1.0.1 agent home is 11.1.0.7 so ideally copy the files from an 11.1.0.7 database home.

1. Login to the server hosting the Enterprise Manager repository database.

2. Extract the following:

<ORACLE_HOME>/network/mesg/tnsus.msg

<ORACLE_HOME>/network/mesg/tnsus.msb

3. Login to the agent server and copy the files into:

<AGENT_HOME>/network/mesg/tnsus.msg

<AGENT_HOME>/network/mesg/tnsus.msb

4. Execute the tnsping test to verify.

Solution B:

Upgrade to Enterprise Manager 12.1.0.3 Cloud Control.

+++++++++++++++++++++++++

Error:

The listener is down: Message 3509 not found; No message file for product=network, facility=TNS

Solution:

To implement the solution, execute the following steps:

$ chmod 775 $ORACLE_HOME/network/mesg

$ cd mesg

$ chmod 666 *

Note: The ORACLE_HOME referred is the ORACLE_HOME from where the listener is started.

+++++++++++++++

(Doc ID 1454550.1) 

++++++++++Manjunatha++++++++++