Thursday, August 30, 2012

ORA-01119 and ORA-27086

This was tested on Oracle 11.2. If you get the messages above, it could be that you are trying to add a file from 1 instance to another. In the example below, I tried to add a tempfile currently in use by instance ANDREW01 while I was connected to a different instance:
 
SQL> l
  1  alter tablespace temp add tempfile
  2  '/database/Andrew/ANDREW01/temp01.dbf'
  3* reuse
SQL> /
alter tablespace temp add tempfile
*
ERROR at line 1:
ORA-01119: error in creating database file
'/database/Andrew/ANDREW01/temp01.dbf'
ORA-27086: unable to lock file - already in use
SVR4 Error: 11: Resource temporarily unavailable
Additional information: 8
Additional information: 23210
Additional information: 16409
 
SQL>

No comments: