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>