flash_recovery_area full error- cant start database

Trace file /opt/app/oracle/diag/rdbms/cert/cert/trace/cert_ora_8290.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /opt/app/oracle/product/11.2.0/dbhome_1
System name: Linux
Node name: xpsi7
Release: 2.6.32-131.12.1.el6.x86_64
Version: #1 SMP Tue Aug 23 11:13:45 CDT 2011
Machine: x86_64
Instance name: cert
Redo thread mounted by this instance: 1
Oracle process number: 19
Unix process pid: 8290, image: oracle@xpsi7 (TNS V1-V3)

*** 2011-10-18 22:11:30.934
*** SESSION ID:(96.3) 2011-10-18 22:11:30.934
*** CLIENT ID:() 2011-10-18 22:11:30.934
*** SERVICE NAME:() 2011-10-18 22:11:30.934
*** MODULE NAME:(sqlplus@xpsi7 (TNS V1-V3)) 2011-10-18 22:11:30.934
*** ACTION NAME:() 2011-10-18 22:11:30.934

ORA-19815: WARNING: db_recovery_file_dest_size of 4070572032 bytes is 100.00% used, and has 0 remaining bytes available.
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 43637760 bytes disk space from 4070572032 limit
*** 2011-10-18 22:11:30.936 4132 krsh.c
ARCH: Error 19809 Creating archive log file to '/opt/app/oracle/flash_recovery_area/CERT/archivelog/2011_10_18/o1_mf_1_114_%u_.arc'
*** 2011-10-18 22:11:30.936 2747 krsi.c
krsi_dst_fail: dest:1 err:19809 force:0 blast:1
DDE: Problem Key 'ORA 312' was flood controlled (0x1) (no incident)
ORA-00312: online log 3 thread 1: '/opt/app/oracle/oradata/cert/redo03.log'
ORA-16038: log 3 sequence# 114 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1: '/opt/app/oracle/oradata/cert/redo03.log'

*** 2011-10-18 22:11:31.000
USER (ospid: 8290): terminating the instance due to error 16038


Fixed by
sqlplus / as sysdba
startup nomount

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 10G SCOPE=BOTH SID='*';

select * from v$recovery_file_dest;




select * from v$flash_recovery_area_usage;

select name
, floor(space_limit / 1024 / 1024) "Size MB"
, ceil(space_used / 1024 / 1024) "Used MB"
from v$recovery_file_dest
order by name;

Java Notes

Java Notes: - one public class per file and the filename should be named after the public class name - The top level class cannot be private or protected - Multiple classes can be declared in a file but only one can be Public. If you ever are in a situation where you need to use two classes with the same name but in different packages, then using imports does not work. You will need to refer to each class by their fully qualified name in your source file. The following code compiles successfully: public class FullyQualifiedDemo { public javax.management.AttributeList a1; public javax.swing.text.html.parser.AttributeList a2; } Example: Take note of the command line arguments (dir structure) where it can compile and where it can run from Code: Message.java: package org.rakesh; public class Message { public void PrintMessage(String msg) { System.out.println(msg); } } TestMessage.java: package org.rakesh.test; import org.rakesh.Message; public class TestMessage { public static void main(String[] args) { Message m; m = new Message(); m.PrintMessage("Rakesh Prajapati"); } } NOTE: (no other dir path other than below could compile or run) To Compile: bash-4.1$ pwd /home/oracle/workspace/learning/src bash-4.1$ javac -d ../bin Message.java bash-4.1$ pwd /home/oracle/workspace/learning/src bash-4.1$ javac -cp ../bin -d ../bin TestMessage.java To Run: bash-4.1$ pwd /home/oracle/workspace/learning/bin bash-4.1$ java org/rakesh/test/TestMessage Rakesh Prajapati

Emacs ispell-buffer error

Error: No word lists can be found for the language “en_US”.

When u get try  M-x ispell-buffer in Emacs, then you need to install the aspell-en package:

yum install aspell-en

Emacs cheat sheet

C-o

Insert a blank line after the cursor (open-line).

C-x C-o

Delete all but one of many consecutive blank lines (delete-blank-lines).
M + l to change to lowercase all the letters from the cursor to the end of the word
M + u convert to upper case

M + c capitalizes first letter.

Deletion means erasing text and not saving it in the kill ring. For the most part, the Emacs commands that delete text are those that erase just one character or only whitespace.

C-d

Delete next character (delete-char).



Delete previous character (delete-backward-char).
M-\
Delete spaces and tabs around point (delete-horizontal-space).
M-
Delete spaces and tabs around point, leaving one space (just-one-space).
C-x C-o
Delete blank lines around the current line (delete-blank-lines).
M-^
Join two lines by deleting the intervening newline, along with any indentation following it (delete-indentation).

flash plugin for scientific linux

[root@xpsi7 rick]# yum install flash-plugin
Loaded plugins: refresh-packagekit
adobe-linux-i386                                         |  951 B     00:00    
adobe-linux-i386/primary                                 |  12 kB     00:00    
adobe-linux-i386                                                          18/18
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package flash-plugin.x86_64 0:10.3.162.29-0.1.el6.rf set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package           Arch        Version                      Repository     Size
================================================================================
Installing:
 flash-plugin      x86_64      10.3.162.29-0.1.el6.rf       rpmforge      3.5 M

Transaction Summary
================================================================================
Install       1 Package(s)
Upgrade       0 Package(s)

Total download size: 3.5 M
Installed size: 10 M
Is this ok [y/N]: y
Downloading Packages:
flash-plugin-10.3.162.29-0.1.el6.rf.x86_64.rpm           | 3.5 MB     00:11    
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing     : flash-plugin-10.3.162.29-0.1.el6.rf.x86_64               1/1

Installed:
  flash-plugin.x86_64 0:10.3.162.29-0.1.el6.rf                                 

Complete!
[root@xpsi7 rick]#

iptables , remove all DROP rules

iptables -L -n | grep DROP  | awk '{print "iptables -D INPUT -s ",$4,"-j DROP"}' | sh

# There may be a way to flush all rules without specifying all ip addresses
# ie delete all DROP rules from the input chain.

Oracle - Flash recovery area full

Errors in file /opt/oracle/diag/rdbms/cert/CERT/trace/CERT_m000_11268.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 53687091200 bytes is 98.96% used, and has 556750848 remaining bytes available.
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files, then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.
************************************************************************
Fri Apr 29 22:33:36 2011
Thread 1 cannot allocate new log, sequence 1253

-- The size was increased to 50 Gb.

[oracle@www oracle]$ du -m flash_recovery_area/
1       flash_recovery_area/CERT/archivelog/2011_04_30
168     flash_recovery_area/CERT/archivelog/2011_04_26
62      flash_recovery_area/CERT/archivelog/2011_04_24
50279   flash_recovery_area/CERT/archivelog/2011_04_29
126     flash_recovery_area/CERT/archivelog/2011_04_28
610     flash_recovery_area/CERT/archivelog/2011_04_27
20      flash_recovery_area/CERT/archivelog/2011_04_25
51263   flash_recovery_area/CERT/archivelog
1       flash_recovery_area/CERT/onlinelog
51274   flash_recovery_area/CERT
51274   flash_recovery_area/