Thanx Mladen.
i have got some scripts now.
i have to try one by one and find out which suits my need.
thanx u all.
Jp.
10-07-2003 09:09:24, Mladen Gogala <[EMAIL PROTECTED]> wrote:
>Here is a good one:
>create or replace directory bdump as '/oracle/admin/o9i/bdump'
>/
>grant read on directory b
If you have more databases, there are synonyms, views and db-links.
That is classic DBA patchwork. The funniest siutations arise when
you have a circle of synonyms and db-links pointing to each other,
just like perpetuum mobile. What is impossible in thermodynamics, is
possible in oracle. It doesn
And load 'em to CLOBs as well and use InterMedia Text to index them ;)
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, July 11, 2003 12:59 AM
> > Here is a good one:
> > create or replace directory bdump as
> > '/oracle/admin/o9
> Here is a good one:
> create or replace directory bdump as
> '/oracle/admin/o9i/bdump' / grant read on directory bdump to
> public / create table alert_log_ext ( line varchar2(2000) )
> organization external ( type oracle_loader default directory
> bdump access parameters
>(
>reco
Here is a good one:
create or replace directory bdump as '/oracle/admin/o9i/bdump'
/
grant read on directory bdump to public
/
create table alert_log_ext (
line varchar2(2000) )
organization external
(
type oracle_loader
default directory bdump
access parameters
(
records delimited by newli
Hi there
Hope this helps.
First the ksh file.
#!/bin/ksh
#
# File : check_alertlog.ksh
# Created : 01/02/2002
# Modified : 04/02/2002
# : 20/02/2002 Removed the CC for the email
#
# By: George Leonard ([EMAIL PROTECTED])
#
Yep, it's called ALORS (Alert LOg Repository System) and is cool (but will
get better). Now, I'm not sure, but you could try this address:
http://ip14.ds1-ba.adsl.cybercity.dk:8080/alors/
- let me know if it doesn't work.
Mogens
Gudmundur Bjarni Josepsson wrote:
I need a parse a
> I need a parse alert log and mail me if there is any error.
I know Mogens (pronounced moans) and the guys at Miracle are working on GAPALPART
(Generic All-Powerful Alert Log Parser And Reporting Tool). That could be something
that you could use. I also know of a tool called MONO which is wri
sage-
(B> From: Prem Khanna J [mailto:[EMAIL PROTECTED]
(B> Sent: 07 July 2003 10:39
(B> To: Multiple recipients of list ORACLE-L
(B> Subject: any script to parse alert log ?!
(B>
(B>
(B> Guys,
(B>
(B> I need a parse alert log and mail me if there is a
This was posted by David Hill on 21/3/3. Hope it helps
John
Here a fast little script I wrote that can be ran every minute
Emails only when it finds a new message
And pages if it finds a new message between 6pm and 5am
FPATH=/prod/dba/scr
autoload f_xmail
logfile=/prod/dba/logs/`cat /p
sorry guys...there was some TYPO in my previous mail.
I need to parse alert log and mail me if there is any error.
Hope u guys would have some script for the same.
i have 8i and 9i instances spread across windows 2000 network.
even if u guys have script for unix,just pass it on to me.
let me mod
Guys,
I need a parse alert log and mail me if there is any error.
Hope u guys would have some script for the same.
i have 8i and 9i instances spread across windows 2000 network.
even if u guys have script for unix,just pass it on to me.
let me modify and try it.
Thanks and Regards,
Jp.
--
Pl
12 matches
Mail list logo