2 Replies Latest reply: Nov 16, 2012 4:25 AM by Osama_Mustafa RSS

    flush is not c

    969801
      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
      PL/SQL Release 11.2.0.1.0 - Production
      CORE 11.2.0.1.0 Production
      TNS for Linux: Version 11.2.0.1.0 - Production
      NLSRTL Version 11.2.0.1.0 - Production



      every two or three days,there will be two errors , not the same time!



      --------error one :
      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: 14-NOV-2012 20:20:32
      Tracing not turned on.
      Tns error struct:
      ns main err code: 12535

      TNS-12535: TNS:operation timed out
      ns secondary err code: 12606
      nt main err code: 0
      nt secondary err code: 0
      nt OS err code: 0

      for this one : i tried below,but it didn't work
      1. set INBOUND_CONNECT_TIMEOUT_=0 in listener.ora
      2. set SQLNET.INBOUND_CONNECT_TIMEOUT = 0 in sqlnet.ora of server.
      3. stop and start both listener and database.
      4. Now try to connect to DB and observe the behaviour



      -----the second:
      Thread 1 cannot allocate new log, sequence 204
      Private strand flush not complete
      Current log# 2 seq# 203 mem# 0: /u01/app/oracle/oradata/Met/redo02.log
      Current log# 2 seq# 203 mem# 1: /bak/oradata/redo02.log
      Thread 1 advanced to log sequence 204 (LGWR switch)
      Current log# 4 seq# 204 mem# 0: /u01/app/oracle/oradata/Met/redo04.log
      Current log# 4 seq# 204 mem# 1: /bak/oradata/redo04.log


      for this one ,i have try add logfile member ,resize the logfile member !
      but it didn't work