Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

alert file not being updated

Status
Not open for further replies.

penzk001

Technical User
Mar 11, 2003
82
MT
Good morning,

I have encountered quite a strange problem, this morning. The alert file of the machine is not being update, in fact I have restarted the machine (AIX and Oracle 8i) however the alert is still not being updated.

Where can i look to solve the problem.
 
Go into svrmgrl or sqlplus and do a:
"show parameter dump"
Make sure the &quot;background_dump_dest&quot; is where you think it is. Also look in your init<SID>.ora or config<SID>.ora files to see if you background_dump_dest parameter is set properly.
 
The following are the parameters:

NAME TYPE VALUE
------------------------------------ ------- ------------------------------
background_core_dump string full
background_dump_dest string /ora_db/admin/ecustDT/bdump
core_dump_dest string /ora_db/admin/ecustDT/cdump
max_dump_file_size string UNLIMITED
shadow_core_dump string full
user_dump_dest string /ora_db/admin/ecustDT/udump

:ecustDT@/>ls -ltr /ora_db/admin/ecustDT/bdump/alert_ecustDT.log
-rw-rw-r-- 1 oracle dba 1978368 Oct 22 01:46 /ora_db/admin/ecustDT/bdump/alert_ecustDT.log
:ecustDT@/>

:ecustDT@/>date
Wed Oct 29 09:47:48 NFT 2003
:ecustDT@/>

the instance was restarted today 29/10/2003 and the alert file was not updated to reflect want happened.
 
Problem solved, the file was a linked (not using ln -s) to a file in a full filesystem so oracle could not write.

Thanks for your help
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top