Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. Oracle Error

Oracle Error

Scheduled Pinned Locked Moved Database
databaseoraclehelp
5 Posts 4 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    Member 8677251
    wrote on last edited by
    #1

    The following error occurred while trying to connect database ora-00257 archiver error solution in sql developer need solution for sql developer :confused:

    Kornfeld Eliyahu PeterK U 2 Replies Last reply
    0
    • M Member 8677251

      The following error occurred while trying to connect database ora-00257 archiver error solution in sql developer need solution for sql developer :confused:

      Kornfeld Eliyahu PeterK Offline
      Kornfeld Eliyahu PeterK Offline
      Kornfeld Eliyahu Peter
      wrote on last edited by
      #2

      As I remember this error is caused by out-of-space in your storage, so log data can not be stored (archived) while trying to run some transaction... Please check your disks...

      I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

      "It never ceases to amaze me that a spacecraft launched in 1977 can be fixed remotely from Earth." ― Brian Cox

      M 1 Reply Last reply
      0
      • Kornfeld Eliyahu PeterK Kornfeld Eliyahu Peter

        As I remember this error is caused by out-of-space in your storage, so log data can not be stored (archived) while trying to run some transaction... Please check your disks...

        I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

        M Offline
        M Offline
        Member 8677251
        wrote on last edited by
        #3

        I have already checked the disk its not full suggest any other solution.............

        J 1 Reply Last reply
        0
        • M Member 8677251

          I have already checked the disk its not full suggest any other solution.............

          J Offline
          J Offline
          Jorgen Andersson
          wrote on last edited by
          #4

          Kornfeld is absolutely correct, you're having space problems. The simplest and best solution is usually to run a backup, that will cleanup old archived files (depending on your settings). If you're running Oracle express edition, it's not the harddrive space that's the limit, it's the maximum storage space allowed. 4GB Before 11.2G, 11 GB after. Also check your settings so that all file locations are correct.

          Wrong is evil and must be defeated. - Jeff Ello[^]

          1 Reply Last reply
          0
          • M Member 8677251

            The following error occurred while trying to connect database ora-00257 archiver error solution in sql developer need solution for sql developer :confused:

            U Offline
            U Offline
            User 10400166
            wrote on last edited by
            #5

            Cause: The archiver process received an error while trying to archive a redo log. If the problem is not resolved soon, the database will stop executing transactions. The most likely cause of this message is the destination device is out of space to store the redo log file.

            Action: Check the archiver trace file for a detailed description of the problem. Also, verify that the device specified in the initialization parameter archive_log_dest is set up properly for archiving.

            1 Reply Last reply
            0
            Reply
            • Reply as topic
            Log in to reply
            • Oldest to Newest
            • Newest to Oldest
            • Most Votes


            • Login

            • Don't have an account? Register

            • Login or register to search.
            • First post
              Last post
            0
            • Categories
            • Recent
            • Tags
            • Popular
            • World
            • Users
            • Groups