RE: how to determine who/what is opening the database
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <jeremy.schneider@xxxxxxxxxxxxxx>, <rhojel.echano@xxxxxxxxx>
- Date: Mon, 26 Jul 2010 10:51:17 -0400
Can you mount in exclusive mode (just to get the job done)? Then look
for why this is happening?
Just a rhetorical suggestion.
Joel Patterson
Database Administrator
904 727-2546
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jeremy Schneider
Sent: Monday, July 26, 2010 10:09 AM
To: rhojel.echano@xxxxxxxxx
Cc: Chris.Stephens@xxxxxxx; ORACLE-L
Subject: Re: how to determine who/what is opening the database
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> 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
Other related posts:
