ORA-00054: resource busy and acquire with NOWAIT specified Posted by MOHAMMED ABDUL HAMEED on 6:11 AM

SQL> alter table Details add (mobile varchar2(15));
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified

Workaround :

1 . In Oracle 11g you can set ddl_lock_timeout i.e. allow DDL to wait 
for the object to become available, simply specify how long you would like it to wait:

SQL> alter session set ddl_lock_timeout = 500;
Session altered.

SQL> alter table Details add (mobile varchar2(15));
Table altered.

2.  We can mark your table as read-only to prevent DML:
SQL> alter table emp read only;
Session altered.

SQL> alter table Details add (mobile varchar2(15));
Table altered. 

3. This workaround is not preferred on production database , can you use according to the criticality of the problem. 

Identify the session which is locking the object

SQL> select a.sid, a.serial#
from v$session a, v$locked_object b, dba_objects c 
where b.object_id = c.object_id 
and a.sid = b.session_id
and OBJECT_NAME='Details';

kill that session using

SQL> alter system kill session 'sid,serial#'; 

ORA-09817: Write to audit file failed. Posted by MOHAMMED ABDUL HAMEED on 11:01 PM

[oracle@exdprd]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Jun 26 07:59:43 2018

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

ERROR:
ORA-09817: Write to audit file failed.
Linux-x86_64 Error: 28: No space left on device
Additional information: 12
ORA-01075: you are currently logged on

Workaround :

1. Check the free space of mount point /u01 

[oracle@exdprd]$ df -h

2. Remove old and unwanted trace and audit files.

3 . Check the space now on mount pount /u01

4. Now we will be able to login successfully. 

Storage Terminology Posted by MOHAMMED ABDUL HAMEED on 11:16 PM

1  B (Byte)  = 8 Bits.

1 KB (Kilo Byte)  = 1024 B or 103 (Bytes).

1 MB (Mega Byte) = 1024 KB or 106 (Kilo Bytes).

1 GB (Giga Byte) = 1024 MB or 109 (Mega Bytes).

1 TB (Tera Byte) = 1024 GB or 1012 (Giga Bytes).

1 PB (Peta Byte) = 1024 TB or 1015 (Tera Bytes).

1 EB (Exa Byte) = 1024 PB or 1018 (Peta Bytes).

1 ZB (Zetta Byte) = 1024 EB or 1021 (Exa Bytes).

1 YB (Yotta Byte) = 1024 ZB or 1024 (Zetta Bytes).

1  (Bronto Byte) = 1024 YB or 1027 (Yotta Bytes).

1  (Geop Byte) = 1024 ZB or 1030 (Bronto Bytes).