Friday, April 20, 2012

ORA-00257: archiver error. Connect internal only, until freed

Today I faced this issue. The users were unable to login to Oracle Apps. When I checked the system the archive logs SAN volume was full. The database was not able to write the online logs to destination  path. I tried to connect to database using SQL Plus and it gave me the following error:

ORA-00257: archiver error. Connect internal only, until freed

I took the following steps to resolve the issue.

  • Tried to delete old archive logs using RMAN but rman was also not able to connect
  • Then I deleted the old logs using OS command and freed some space.
  • Switch the log as
              SQL> alter system switch logfile;
  • Check the current status of archive logs as
             SQL> archive log list;
  • Then finally I bounced the Apps and DB services.

4 comments:

Unknown said...

These hot heels are the latest in a series of fashion copycat skirmishes, including knockoff Michael Kors and Victoria Beckham dresses, Taylor Tomasi Hill's alleged Marc Jacobs ripoff and of course, that other famous copycat shoe case: Ivanka new balance Trump's supposed lifting of Derek Lam sandal designs.Despite an ongoing lawsuit, Christian Louboutin is having a great year. New mom Jessica Simpson has given mbt shoes clearance him shout outs, he's creating a real life Cinderella glass shoe and most recently, London's Design Museum has dedicated a whole exhibit to his mbt craftsmanship.
After a look at 26 New Balance Releases for January 2015, the brand is back to showcase a number of new collections to louboutin shoes kick off the year strong. From the New Balance 696 “Tomboy Pack” strictly for the ladies that features a premium suede and some Camouflage mbt shoes for women donning classics, we can’t wait to see what else is in store for the brand. NB looks for eclectic inspirations nearly everywhere – even shoes with red soles guitars are referenced atop a few models. Which pair is your favorite? Be sure to check out more of the latest New Balance releases mbt shoes discontinued for January 2015 after the break and get updated on the latest release dates via our Sneaker Release Dates page.
Just previewed yesterday, now www.overstock.com Social Status sails in with an official look at their upcoming collab with New Balance for the “Winter in the Hamptons” 1600. The cold new balance 998 season yachting-inspired sneaker features the classic runner in a mbt shoes premium blend of pig suede, nubuck and Cone denim. The leather and nubuck panels represent the interiors of luxurious yachts, while the dark denim is inspired by a boater’s material of choice when it gets too chilly for their lightweight summer khakis. Meanwhile, splashes of mbt mens shoes teal represent the ocean. Each pair will also come with custom social Status and New Balance branded hang tabs. The Social Status x New red bottom shoes Balance CM1600 “Winter in the Hamptons” drops December 13 in all six Social Status locations and on for $164.95.
But do luxury department new balance shoes for women stores really care about attracting middle class shoppers? Certainly not if it means losing prestige with the uber-rich. Luxury spending is fueling growth in new balance shoes the fashion industry, as profits at upscale stores like Saks Fifth Avenue, Neiman Marcus and Nordstrom show. And unlike heel heights,

Unknown said...

canada goose canadian goose canada goose jacket canada goose sale canada goose outlet canada goose jackets Canada Goose Bib Canada Goose Parka Canada Goose Pant Canada Goose Snow Bunting Canada Goose Burnett Jacket Canada Goose Hybridge Hoody Canada Goose Langford Parka Canada Goose Ontario Parka Canada Goose Summit Jacket Canada Goose Tundra Down Cargo Pant Canada Goose Camrose Parka Canada Goose Freestyle Vest Canada Goose Livigno Parka Canada Goose Solaris Parka

Anonymous said...

beats by dre, lululemon, vans, nike trainers, reebok shoes, ghd, giuseppe zanotti, nfl jerseys, soccer shoes, longchamp, gucci, soccer jerseys, louboutin, babyliss, mac cosmetics, nike air max, nike air max, celine handbags, converse outlet, iphone cases, herve leger, nike roshe, wedding dresses, oakley, chi flat iron, ralph lauren, north face outlet, lancel, ray ban, birkin bag, timberland boots, valentino shoes, instyler, hollister, ferragamo shoes, hollister, new balance, mcm handbags, jimmy choo shoes, insanity workout, north face outlet, asics running shoes, vans shoes, bottega veneta, abercrombie and fitch, baseball bats, hollister, p90x workout, nike huarache, mont blanc

mctatee said...

visit homepage replica ysl handbags read the full info here investigate this site click here for info more info here