Schedule script is not executing some times - Page 2

itkamaraj · #8 05-21-2012

can you post the sample log lines

otherwise, i cant help you

Mohammed Fareed · #9 05-21-2012

Condition 1:-For Shutdown

PHP Code:


Mon Apr 30 17:52:16 2012
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Apr 30 18:00:18 2012

Condition 2 Instance terminated:-

PHP Code:


KCF: write/open error block=0x440 online=1
     file=2 X:\ORACLE\ORADATA\XXXX\UNDOTBS01.DBF
     error=27070 txt: 'OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.'
Fri May 18 11:28:00 2012
Errors in file X:\oracle\admin\XXXx\bdump\XXX_dbw0_5728.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01114: IO error writing block to file 2 (block # 1088)
ORA-01110: data file 2: 'X:\ORACLE\ORADATA\XXX\UNDOTBS01.DBF'
ORA-27070: skgfdisp: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
DBW0: terminating instance due to error 1242
Instance terminated by DBW0, pid = 5728

itkamaraj · #10 05-21-2012

in the old code, i didnt use the

Code:

 
IF InStr(FileText,"shutdown") or Instr(FileText,"terminating instance") Then

Mohammed Fareed · #11 05-21-2012

I want to use this both the condition in the script "shutdown" & Terminating Instance".

itkamaraj · #12 05-21-2012

Code:

 
IF InStr(FileText,"shutdown") Then
IF Instr(FileText,"terminating instance") Then
...........
..........
..........
End IF
End IF

Mohammed Fareed · #13 05-21-2012

Thanks for update.
given conditions are placed in the script but its not filtering the words "Shutdown" & "terminated Instance" please suggest.

Thread Tools	Search this Thread
Show Printable Version Email this Page Subscribe to this Thread	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Cron to schedule job at different times	apjneeraj	Shell Programming and Scripting	2	05-24-2011 08:08 AM
Best way to schedule script to run Ubuntu 10.04	glev2005	UNIX for Dummies Questions & Answers	1	02-04-2011 12:42 PM
Schedule a script to run at 10am from mon to fri	firestar	Shell Programming and Scripting	7	01-21-2011 12:24 PM
How to schedule my script without crontab	prashant43	Shell Programming and Scripting	3	06-08-2009 11:49 AM
Script Schedule Scrutiny	geralex2	Shell Programming and Scripting	2	08-29-2006 03:52 AM