Wednesday 10 April 2013

Alert Log file errors in 11.2.0.1 DB.Fatal NI connect error 12537 and 12547.


Hi,
I have found below messages in one of our 11.2.0.1 Oracle development DB alert log file.

1)

  Fatal NI connect error 12537, connecting to:

  (LOCAL=NO)

  VERSION INFORMATION:
TNS for Linux: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
  Time: 09-DEC-2013 20:27:35
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12537
    
TNS-12537: TNS:connection closed
    ns secondary err code: 12560
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
opiodr aborting process unknown ospid (12547) as a result of ORA-609
Mon Dec 09 20:27:35 2013

2) 

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

  VERSION INFORMATION:
TNS for Linux: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
  Time: 09-OCT-2013 23:05:36
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12547
    
TNS-12547: TNS:lost contact
    ns secondary err code: 12560
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
opiodr aborting process unknown ospid (10574) as a result of ORA-609
Wed Oct 09 23:05:56 2013
Clearing Resource Manager plan via parameter
Thu Oct 10 03:03:13 2013

3) 
Fatal NI connect error 12170.

  VERSION INFORMATION:
TNS for Linux: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
  Time: 10-OCT-2013 03:03:13
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12535
    
TNS-12535: TNS:operation timed out
    ns secondary err code: 12560
    nt main err code: 505
    
TNS-00505: Operation timed out
    nt secondary err code: 110
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.12.161)(PORT=55325))
Thu Oct 10 05:49:45 2013

4) Errors in file /u01/app/diag/rdbms/epm/epm/trace/epm_j000_15056.trc  (incident=31383):
ORA-00600: internal error code, arguments: [17059], [0x0B98A25A0], [0x0B98A2E38], [0x0C24173C8], [], [], [], [], [], [], [], []
Incident details in: /u01/app/diag/rdbms/epm/epm/incident/incdir_31383/epm_j000_15056_i31383.trc
Thu Jan 02 21:34:12 2014
Errors in file /u01/app/diag/rdbms/epm/epm/trace/epm_j000_15056.trc  (incident=31384):
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17059], [0x0B98A25A0], [0x0B98A2E38], [0x0C24173C8], [], [], [], [], [], [], [], []
Incident details in: /u01/app/diag/rdbms/epm/epm/incident/incdir_31384/epm_j000_15056_i31384.trc
Thu Jan 02 21:34:12 2014
Trace dumping is performing id=[cdmp_20140102213412]


Pfile and Startup Process :

 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileidm.ora
System parameters with non-default values:
  processes                = 500
  sessions                 = 772
  memory_target            = 2400M
  control_files            = "/u01/app/oracle/oradata/idm/control01.ctl"
  control_files            = "/u01/app/oracle/oradata/idm/control02.ctl"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = "bias.com"
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=idmXDB)"
  audit_file_dest          = "/u01/app/oracle/admin/idm/adump"
  audit_trail              = "DB"
  db_name                  = "idm"
  open_cursors             = 800
  diagnostic_dest          = "/u01/app/oracle"
  • Thu Oct 17 21:42:11 2013 PMON started with pid=2, OS id=2818 
  • Thu Oct 17 21:42:11 2013 VKTM started with pid=3, OS id=2820 at elevated priority
  • Thu Oct 17 21:42:11 2013 GEN0 started with pid=4, OS id=2824 
  • VKTM running at (10)millisec precision with DBRM quantum (100)ms
  • Thu Oct 17 21:42:11 2013 DIAG started with pid=5, OS id=2826 
  • Thu Oct 17 21:42:11 2013 DBRM started with pid=6, OS id=2828 
  • Thu Oct 17 21:42:11 2013 PSP0 started with pid=7, OS id=2830 
  • Thu Oct 17 21:42:11 2013 DIA0 started with pid=8, OS id=2832 
  • Thu Oct 17 21:42:11 2013 MMAN started with pid=9, OS id=2834 
  • Thu Oct 17 21:42:11 2013 DBW0 started with pid=10, OS id=2836 
  • Thu Oct 17 21:42:11 2013 LGWR started with pid=11, OS id=2838 
  • Thu Oct 17 21:42:11 2013 CKPT started with pid=12, OS id=2840 
  • Thu Oct 17 21:42:11 2013 SMON started with pid=13, OS id=2842 
  • Thu Oct 17 21:42:11 2013 RECO started with pid=14, OS id=2844 
  • Thu Oct 17 21:42:11 2013 MMON started with pid=15, OS id=2846 

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Oct 17 21:42:11 2013
MMNL started with pid=16, OS id=2848 
starting up 1 shared server(s) ...
ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Reusing ORACLE_BASE from an earlier startup = /u01/app/oracle
Thu Oct 17 21:42:12 2013
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 961017972
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Thu Oct 17 21:42:16 2013
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
Started redo scan
Completed redo scan


Alert Log Errors :




No comments:

Post a Comment