4 Replies Latest reply: Jun 26, 2013 1:06 AM by Sally RSS

    ERROR   OGG-01031 error 11, Resource temporarily unavailable

    818128
      Hi All,

      One of our pump extract in Database Source has just abended this morning. These are the reports shown. It is strange, because it only happen to one of our pump extracts, meanwhile the other pump extracts running without problem. Anyone has idea how to overcome this problem?

      Thanks,
      Arief


      CACHEMGR virtual memory values (may have been adjusted)
      CACHEBUFFERSIZE: 1M
      CACHESIZE: 8G
      CACHEBUFFERSIZE (soft max): 4M
      CACHEPAGEOUTSIZE (normal): 4M
      PROCESS VM AVAIL FROM OS (min): 16G
      CACHESIZEMAX (strict force to disk): 13.99G

      Database Version:
      Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
      PL/SQL Release 10.2.0.3.0 - Production
      CORE 10.2.0.3.0 Production
      TNS for Solaris: Version 10.2.0.3.0 - Production
      NLSRTL Version 10.2.0.3.0 - Production

      Database Language and Character Set:
      NLS_LANG environment variable specified has invalid format, default value will be used.
      NLS_LANG environment variable not set, using default value AMERICAN_AMERICA.US7ASCII.
      NLS_LANGUAGE = "AMERICAN"
      NLS_TERRITORY = "AMERICA"
      NLS_CHARACTERSET = "WE8ISO8859P1"

      Warning: your NLS_LANG setting does not match database server language setting.
      Please refer to user manual for more information.

      2010-11-24 10:01:09 INFO OGG-01226 Socket buffer size set to 27985 (flush size 27985).

      Source Context :
      SourceModule : [er.extrout]
      SourceID : [home/ecloud/workspace/Build_FBO_OpenSys_r11.1.1.0.0_078_[34085]/perforce/src/app/er/extrout.c]
      SourceFunction : [complete_tcp_msg]
      SourceLine : [1393]

      2010-11-24 10:01:19 ERROR OGG-01031 There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using
      ENCRYPT) or an unknown error. (Reply received is Unable to open file "/orcl/goldengate/dirdat/trail_f/rf004174" (error 11, Resource temporarily unavailable)).

      2010-11-24 10:01:19 ERROR OGG-01668 PROCESS ABENDING.
        • 1. Re: ERROR   OGG-01031 error 11, Resource temporarily unavailable
          -joe
          Hi Arief.

          I suspect you got it figured out by now but this looks like you ran out of disk space or someone deleted rf004174. It could be that the server/collector process that does the writing on the target crashed from some reason as well, but that's a very simple and stable component. I don't think I've ever seen it crash. Regardless, I'll bet a restart of the pump got around it (if/once disk space was not an issue). But please feel free to let the thread know how you got around this.

          Thanks,
          -joe
          • 2. Re: ERROR   OGG-01031 error 11, Resource temporarily unavailable
            user10439672
            check the RMTHOST parameter in your PUMP parameter file.
            It must be the target system , not local host !
            • 3. Re: ERROR   OGG-01031 error 11, Resource temporarily unavailable
              876431
              Hi,

              Error:
              -------------
              2010-11-24 10:01:19 ERROR OGG-01031 There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Reply received is Unable to open file "/orcl/goldengate/dirdat/trail_f/rf004174" (error 11, Resource temporarily unavailable)).

              Cause:
              --------------------
              If you have a shared file system and the OS doesn't shutdown cleanly, you may have file locks on files held by the file system preventing OGG from obtaining and exclusive lock on the file.


              Workaround:
              -------------
              Move the original file to another name, then copy that file back to the original name

              Example:
              a. Move the file /orcl/goldengate/dirdat/trail_f/rf004174 to /orcl/goldengate/dirdat/trail_f/rf004174_backup
              b. Then copy /orcl/goldengate/dirdat/trail_f/rf004174_backup to /orcl/goldengate/dirdat/trail_f/rf004174
              c. Then restart Extract.
              d. Once it restarts, You can delete the backup file /orcl/goldengate/dirdat/trail_f/rf004174_backup


              Also a new UNLOCKEDTRAILFILES parameter was added for GLOBALS as a workaround for problems with trail files that remain locked by Collector if there is a network outage that affects the target system. As of GoldenGate version 10.4, Collector began locking a trail file when writing data to it, to prevent corruption from other processes that may attempt to write to the same trail. UNLOCKEDTRAILFILES prevents Collector from locking the trail files.


              Hope this information helps.

              Thanks & Regards
              Santhosh
              • 4. Re: ERROR   OGG-01031 error 11, Resource temporarily unavailable
                Sally

                hi,I've tried this method,add UNLOCKEDTRAILFILES parameter into globals parameter files,but it doesn't work.