Tuesday, June 2, 2015

Oracle Solution Part 1

12:48 AM Posted by Mehdi Pourhadi No comments
Since this the first part one of the most common error you encouter with is, well atleast for me it was, is when you want to connect via Oracle Database with client such as "Oracle SQL Developer" is :

"fix ora-00257: archiver error. connect internal only, until freed"

Cause: The archiver process received an error while trying to archive a redo log. so 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 or your db ecovery file destination space is filled up and you need to expand it the following commad will solve your problem :
in our example its 80GB.
sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Mar 3 13:48:59 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
SQL> sho parameter db_recovery_file
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
db_recovery_file_dest string
/flash_recovery_area
db_recovery_file_dest_size big integer
80G
SQL> alter system set db_recovery_file_dest_size = 800g;
Database altered
SQL> sho parameter db_recovery_file
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
db_recovery_file_dest string
/flash_recovery_area
db_recovery_file_dest_size big integer
800G
Its better to restart your database for further error encountering, if the Database open up nicely there you go.
NOTE : since we gave it 800GB you need to consider your disk space as its generate the archive redo logs ;)

0 comments:

Post a Comment