ORA-27121

ORACLE:/home/oracle>su - txnmgr
Password:
DEV:/d02/txnmgr>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 24 17:15:40 2009

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

Enter user-name: ftuser
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment
Linux Error: 13: Permission denied

solution:
ORACLE:/home/oracle>cd $ORACLE_HOME/bin
ORACLE:/d01/app/oracle/product/10.2.0/db_1/bin>chmod 6751 oracle
ORACLE:/d01/app/oracle/product/10.2.0/db_1/bin>

Enter user-name: ftuser
Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select * from dual;

D
-
X

ora-00054 error

SQL> alter table FUND_TRANSFER_TBL enable row movement;
alter table FUND_TRANSFER_TBL enable row movement
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified


SQL> col username format a20
col sess_id format a10
col object format a25
col mode_held format a10
select oracle_username || ' (' || s.osuser || ')' username
, s.sid || ',' || s.serial# sess_id
, owner || '.' || object_name object
, object_type
, decode( l.block
, 0, 'Not Blocking'
, 1, 'Blocking'
, 2, 'Global') status
, decode(v.locked_mode
, 0, 'None'
, 1, 'Null'
, 2, 'Row-S (SS)'
, 3, 'Row-X (SX)'
, 4, 'Share'
, 5, 'S/Row-X (SSX)'
, 6, 'Exclusive', TO_CHAR(lmode)) mode_held
from v$locked_object v
, dba_objects d
, v$lock l
, v$session s
where v.object_id = d.object_id
and v.object_id = l.id1
and v.session_id = s.sid
order by oracle_username
, session_id
/


USERNAME SESS_ID OBJECT OBJECT_TYPE
-------------------- ---------- ------------------------- -------------------
STATUS MODE_HELD
------------ ----------
FTUSER (txnmgr) 159,20 FTUSER.FUND_TRANSFER_TBL TABLE
Not Blocking Row-X (SX)

SQL> select object_name, o.object_id from user_objects o, v$locked_object l
2 where o.object_id = l.object_id
3 /

OBJECT_NAME
-------------------------------------------------------------------------------- OBJECT_ID
----------
FUND_TRANSFER_TBL
54953



SQL> alter system kill session '159,20';

System altered.

SQL> alter table fund_transfer_tbl enable row movement;

Table altered.