Re: how to determine who/what is opening the database

From: Rhojel Echano <rhojel.echano_at_gmail.com>
Date: Mon, 26 Jul 2010 10:37:55 +0800
Message-ID: <AANLkTimbMzt_PrRpNekUM9u5t1gYWyY_685GoeoNibgh_at_mail.gmail.com>

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_at_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_at_adm.com>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_at_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.
>
> CONFIDENTIALITY NOTICE:
> This message is intended for the use of the individual or entity to which
> it is addressed and may contain information that is privileged, confidential
> and exempt from disclosure under applicable law. If the reader of this
> message is not the intended recipient or the employee or agent responsible
> for delivering this message to the intended recipient, you are hereby
> notified that any dissemination, distribution or copying of this
> communication is strictly prohibited. If you have received this
> communication in error, please notify us immediately by email reply.
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Jul 25 2010 - 21:37:55 CDT