Maybe fuser or lsof would help. fuser should already be installed if it's linux - and if you're interested, here's a script & example for running it on an oracle datafile directory: http://www.ardentperf.com/2007/05/03/whos-accessing-that-file/ -Jeremy Rhojel Echano wrote: > Run fuser on the file file to see the processes that has it opened > then start your investigation from there. > You can easily write a shell script to periodically run this if you > want some "monitoring". > > e.g. > > [oracle@localhost ~]$ /sbin/fuser > /u02/app/oracle/oradata/ORA11GR2/system01.dbf > /u02/app/oracle/oradata/ORA11GR2/system01.dbf: 3372 3380 3382 3386 > 3390 3478 3492 3494 3496 3498 3500 3502 3504 3508 3512 > 3514 3516 > > On Mon, Jul 26, 2010 at 12:26 AM, Stephens, Chris > <Chris.Stephens@xxxxxxx <mailto:Chris.Stephens@xxxxxxx>> wrote: > > 10.2.0.4 on RHEL 5 > > > > I’m in doing some datafile renaming for my own sanity. > > > > The thing is, once I mount the database and rename a few > datafiles, I start getting messages that the database is open. > > > > ERROR at line 1: > > ORA-01511: error in renaming log/data files > > ORA-01121: cannot rename database file 2 - file is in use or recovery > > ORA-01110: data file 2: '/u01/oradata/db_name/undotbs01.dbf' > > > > SYS@remgt> alter database open; > > alter database open > > * > > ERROR at line 1: > > ORA-01531: a database already open by the instance > > > > > > How would I go about figuring out what or who is opening the > database? This has happened repeatedly. > > > > I have contact the system administrators and they can’t think of > any monitoring software they have configured to do thiat. > -- http://www.ardentperf.com +1 312-725-9249 Jeremy Schneider Chicago