Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-472 DBWR terminated/SOLVED

RE: ORA-472 DBWR terminated/SOLVED

From: Jack van Zanen <JACK_at_QUANTSYSTEMS.NL>
Date: Thu, 10 Oct 2002 00:50:35 -0800
Message-ID: <F001.004E559A.20021010005035@fatcity.com>


THX Investigation revealed that this one directory belonged to root(?????).

Jack

-----Original Message-----

Sent: Wednesday, October 09, 2002 7:14 PM To: Multiple recipients of list ORACLE-L

Are privileges of the oracle user and the directory where the alert log goes the same for all three databases?

Henry

-----Original Message-----

Zanen
Sent: Wednesday, October 09, 2002 6:43 AM To: Multiple recipients of list ORACLE-L

creating a file solved the problem(actually renamed the alertlog back to original name) and it wasn't such a big deal. I am just wondering why two databases with similar setup and exact same versions on the same machine do not have the same problems.
Creating a workaround for this database is not my first choice as this is a script that runs of a remote server and is standard for all UNIX databases.

But if all else fails................................


Thx

Jack

-----Original Message-----

Sent: Wednesday, October 09, 2002 12:08 PM To: Multiple recipients of list ORACLE-L

Not seen this before but trying creating a new alert log file using touch if unix or a simple output (something like type nonexistantfile > alrtSID.log) if using dos. See if the same problem occurs. At least then you can narrow it down to a definite problem recreating the alert log file which you can look into further and you will have a workaround.

If you've already done this what was the outcome?

BTW - you do not need to shutdown the database to be able to rename the alert log file successfully - Oracle *should* create the file if it needs to output messages and cannot find an existing file.

Lewis Bishop
---

Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant
Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R)

Phone : 020 8298 3418
Mobile: 07950 380857
Email : lewis.bishop_at_woolwich.co.uk

"Enabling Competitive Advantage for Barclays in IT and Business Processing"

-----Original Message-----

Sent: 09 October 2002 10:39
To: Multiple recipients of list ORACLE-L

This header confirms that this email message has been swept for the presence of computer viruses.

Corporate IT
THE WOOLWICH


Hi All,

We have a database running 7.3.4.5 and implemented a procedure that renames the alert logs every day.
When the databases are down we rename the alert logs with a date extension. Now we have three databases of which two will simply create a new alert log and startup (including the test instance on which we tried it). The third one will not start up and give above error.

All databases are shutdown the same way.

Has anybody seen this behaviour before and found a reason/solution for it?

Jacob A. van Zanen
Oracle DBA



Quant Systems Europe BV
Zuiderkade 7
1948NG Beverwijk
Tel. :0251 268268

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jack van Zanen
  INET: JACK_at_QUANTSYSTEMS.NL

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Bishop Lewis
  INET: Lewis.Bishop_at_woolwich.co.uk
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jack van Zanen
  INET: JACK_at_QUANTSYSTEMS.NL
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Henry Poras
  INET: hporas_at_etal.uri.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jack van Zanen
  INET: JACK_at_QUANTSYSTEMS.NL
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Oct 10 2002 - 03:50:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US