Oracle 11.2 DBconsole: ERROR TargetManager: TIMEOUT when compute dynamic properties for target

Errors in emagent.trc

2014-09-27 11:15:08,109 Thread-11772 WARN  command: Job Subsystem Timeout set at 600 seconds
2014-09-27 11:15:08,125 Thread-11772 WARN  upload: Upload manager has no Failure script: disabled
2014-09-27 11:15:08,140 Thread-11772 WARN  metadata: Metric VirtualHosts does not have any data columns
2014-09-27 11:15:08,140 Thread-11772 WARN  metadata: Metric collectSnapshot does not have any data columns
2014-09-27 11:15:08,187 Thread-11772 WARN  metadata: Metric hung_system_traces does not have any data columns
2014-09-27 11:15:08,249 Thread-6148 WARN  TargetManager: Query returned 0 rows (only one expected) for the dynamic property from_cluster
2014-09-27 11:17:08,263 Thread-10144 ERROR TargetManager: TIMEOUT when compute dynamic properties for target db11g
2014-09-27 11:17:08,263 Thread-10144 ERROR TargetManager: nmeetm.c : Target db11g has a failed critical dynamic property
2014-09-27 11:17:08,263 Thread-10144 ERROR TargetManager: Target Manager: Target {db11g, oracle_database} is broken: dynamic properties can not be calculated in time.

Solution:

Update emd.properties file:

# changed from default 120
dynamicPropsComputeTimeout_oracle_database=240

TNS-12637: Packet received failed (high logon time)

DB version Oracle Database 11.2.0.4

Error in alert.log

Fatal NI connect error 12637, connecting to:
 (LOCAL=NO)

  VERSION INFORMATION:
    TNS for 64-bit Windows: Version 11.2.0.4.0 - Production
    Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production
    Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production
  Time: 27-SEP-2014 10:23:08
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12637
    
TNS-12637: Packet received failed
    ns secondary err code: 12532
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
opiodr aborting process unknown ospid (10820) as a result of ORA-609
Sat Sep 27 10:28:09 2014

Error in $ORACLE_HOME\host12345_nsm\sysman\log\emagent.trc

2014-09-27 09:25:28,546 Thread-7180 ERROR fetchlets.oslinetok: Process stdout = starting...0 
starting 1...
starting 2...
got dbversion..started...
 dbversion is 11dbversion is not 9
2014-09-27 09:25:28,546 Thread-7180 ERROR fetchlets.oslinetok: Process stderr = em_error=Could not connect to dbsnmp/(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host12345)(Port=1521))(CONNECT_DATA=(SID=nsm)))
            : ORA-12637: Packet received failed (DBD ERROR: OCIServerAttach)

Solution:

Try to update sqlnet.ora file

DEFAULT_SDU_SIZE=2048

Resize Oracle 11g redo log files

Check logfile groups and status:

SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS           FIRST_CHANGE# FIRST_TI NEXT_CHANGE# NEXT_TIM
---------------- ------------- -------- ------------ --------
         1          1       4441   52428800        512          1 NO
INACTIVE              36466120 06.09.14     36478293 06.09.14

         2          1       4442   52428800        512          1 NO
CURRENT               36478293 06.09.14   2,8147E+14

         3          1       4440   52428800        512          1 NO
INACTIVE              36431037 06.09.14     36466120 06.09.14


SQL> select * from v$logfile;

    GROUP# STATUS  TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------

IS_
---
         3         ONLINE
E:\APP\ORACLE\ORADATA\NSM\REDO03.LOG
NO

         2         ONLINE
E:\APP\ORACLE\ORADATA\NSM\REDO02.LOG
NO

    GROUP# STATUS  TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------

IS_
---

         1         ONLINE
E:\APP\ORACLE\ORADATA\NSM\REDO01.LOG
NO


SQL> select group#, status from v$log;

    GROUP# STATUS
---------- ----------------
         1 INACTIVE
         2 CURRENT
         3 INACTIVE
 
Add an additional logfile group (this is optional, but the database should have at least 2 groups during resize activity):

SQL> ALTER DATABASE ADD LOGFILE GROUP 4 'E:\APP\ORACLE\ORADATA\NSM\REDO04.LOG' S IZE 200M;
SQL> SELECT GROUP#, BYTES/1024/1024 MB, STATUS FROM V$LOG;

    GROUP#         MB STATUS
---------- ---------- ----------------
         1         50 INACTIVE
         2         50 CURRENT
         3         50 INACTIVE
         4        200 UNUSED

Recreate logfile groups:

SQL> ALTER DATABASE DROP LOGFILE GROUP 1;
SQL> SELECT GROUP#, BYTES/1024/1024 MB, STATUS FROM V$LOG;

    GROUP#         MB STATUS
---------- ---------- ----------------
         2         50 CURRENT
         3         50 INACTIVE
         4        200 UNUSED
SQL> ALTER DATABASE ADD LOGFILE GROUP 1 'E:\APP\ORACLE\ORADATA\NSM\REDO01.LOG' SIZE 200M REUSE;
SQL> SELECT GROUP#, BYTES/1024/1024 MB, STATUS FROM V$LOG;

    GROUP#         MB STATUS
---------- ---------- ----------------
         1        200 UNUSED
         2         50 CURRENT
         3         50 INACTIVE
         4        200 UNUSED

Make a logswitch and a checkpoint to advance with the CURRENT and ACTIVE logfile:

SQL> ALTER SYSTEM SWITCH LOGFILE;
SQL> SELECT GROUP#, BYTES/1024/1024 MB, STATUS FROM V$LOG;

    GROUP#         MB STATUS
---------- ---------- ----------------
         1        200 CURRENT
         2         50 ACTIVE
         3         50 INACTIVE
         4        200 UNUSED

SQL> ALTER SYSTEM CHECKPOINT;
SQL> SELECT GROUP#, BYTES/1024/1024 MB, STATUS FROM V$LOG;

    GROUP#         MB STATUS
---------- ---------- ----------------
         1        200 CURRENT
         2         50 INACTIVE
         3         50 INACTIVE
         4        200 UNUSED

Recreate other logfile groups reusing exiting redo log files:

SQL> ALTER DATABASE DROP LOGFILE GROUP 2;
SQL> SELECT GROUP#, BYTES/1024/1024 MB, STATUS FROM V$LOG;

    GROUP#         MB STATUS
---------- ---------- ----------------
         1        200 CURRENT
         3         50 INACTIVE
         4        200 UNUSED

SQL> ALTER DATABASE ADD LOGFILE GROUP 2 'E:\APP\ORACLE\ORADATA\NSM\REDO02.LOG' SIZE 200M REUSE;
SQL> SELECT GROUP#, BYTES/1024/1024 MB, STATUS FROM V$LOG;

    GROUP#         MB STATUS
---------- ---------- ----------------
         1        200 CURRENT
         2        200 UNUSED
         3         50 INACTIVE
         4        200 UNUSED

SQL> ALTER DATABASE DROP LOGFILE GROUP 3;
SQL> ALTER DATABASE ADD LOGFILE GROUP 3 'E:\APP\ORACLE\ORADATA\NSM\REDO03.LOG' SIZE 200M REUSE;
SQL> SELECT GROUP#, BYTES/1024/1024 MB, STATUS FROM V$LOG;

    GROUP#         MB STATUS
---------- ---------- ----------------
         1        200 CURRENT
         2        200 UNUSED
         3        200 UNUSED
         4        200 UNUSED

SQL> ALTER SYSTEM SWITCH LOGFILE;
SQL> SELECT GROUP#, BYTES/1024/1024 MB, STATUS FROM V$LOG;

    GROUP#         MB STATUS
---------- ---------- ----------------
         1        200 ACTIVE
         2        200 CURRENT
         3        200 UNUSED
         4        200 UNUSED

Remove additional logfile group:

SQL> ALTER DATABASE DROP LOGFILE GROUP 4;
SQL> SELECT GROUP#, BYTES/1024/1024 MB, STATUS FROM V$LOG;

    GROUP#         MB STATUS
---------- ---------- ----------------
         1        200 ACTIVE
         2        200 CURRENT
         3        200 UNUSED

SQL> ALTER SYSTEM SWITCH LOGFILE;
SQL> SELECT GROUP#, BYTES/1024/1024 MB, STATUS FROM V$LOG;

    GROUP#         MB STATUS
---------- ---------- ----------------
         1        200 ACTIVE
         2        200 ACTIVE
         3        200 CURRENT

SQL> ALTER SYSTEM CHECKPOINT;
SQL> SELECT GROUP#, BYTES/1024/1024 MB, STATUS FROM V$LOG;

    GROUP#         MB STATUS
---------- ---------- ----------------
         1        200 INACTIVE
         2        200 INACTIVE
         3        200 CURRENT

SQL> SELECT * FROM V$LOGFILE;

    GROUP# STATUS  TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------

IS_
---
         3         ONLINE
E:\APP\ORACLE\ORADATA\NSM\REDO03.LOG
NO

         2         ONLINE
E:\APP\ORACLE\ORADATA\NSM\REDO02.LOG
NO

    GROUP# STATUS  TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------

IS_
---

         1         ONLINE
E:\APP\ORACLE\ORADATA\NSM\REDO01.LOG
NO


SQL>EXIT

DELETE REDOLOG4.LOG FILE FROM OS