Category: Oracle Database

ORA-00206: error in writing (block 42, # blocks 1) of control file

DBA notified me of this error

Wed Nov 25 13:46:11 BRST 2015
Errors in file /usr/software/oracle/admin/orarvt015/bdump/rvt015_lgwr_2388.trc:
ORA-00206: error in writing (block 42, # blocks 1) of control file
ORA-00202: control file: ‘/usr/oradata/orarvt015/control2/control02.ctl’
ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 5: Input/output error

Umount the filesystem

root@linux:~ # umount /usr/oradata/orarvt015

I ran fsck

root@linux:~ # fsck -t ext3 /dev/mapper/oradatavg-dat.orarvt015new
fsck 1.38 (30-Jun-2005)
e2fsck 1.38 (30-Jun-2005)
/dev/mapper/oradatavg-dat.orarvt015new: recovering journal
/dev/mapper/oradatavg-dat.orarvt015new: clean, 137/209715200 files, 318872229/419428352 blocks

Then I mounted the filesystem again

root@linux:~ # mount /usr/oradata/orarvt015

Showing filesystem size

root@linux:~ # df -h /usr/oradata/orarvt015
Filesystem Size Used Avail Use% Mounted on
1.6T 1.2T 304G 80% /usr/oradata/orarvt015

It solved the problem


Oracle RMAN Error – RMAN-00600: internal error, arguments [2012] [] [] [] []

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signalled during parse
RMAN-00600: internal error, arguments [2012] [] [] [] []

Check if there is a filesystem with 100% utilization

Starting an Oracle database instance

Here is a reference if I need to start an Oracle database instance. It may not be the best way but this is how I done.

I became the user oracle

root@solaris:/ # su – oracle

Exported the variable that sets the instance that I’ll deal with

oracle@solaris:~ $ export ORACLE_SID=testing

Started sqlplus

oracle@solaris:~ $ sqlplus /nolog
SQL*Plus: Release – Production on Fri Jun 18 10:57:30 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected as user sysdba

SQL> connect /as sysdba
Connected to an idle instance.

And finally started the instance

SQL> startup
ORACLE instance started.

Total System Global Area 209747872

Fixed Size 728992

Variable Size 167772160

Database Buffers 40960000

Redo Buffers 286720


Database mounted.
Database opened.

Pressed CTRL+D to exit sqlplus

SQL> Disconnected from Oracle9i Enterprise Edition Release – 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release – Production

You’ll also need to start the Oracle Database Listener