Search Results

Here is my results of running the script

$ ./db_size

SQL>

SQL> exitHere is the script
# -- Total size of Database Size in GB
set echo off feedback off verify off pause off
SELECT...

Hello,

the problem is if I execute the script from the shell prompt - it enters the database and nothing more. It will just sit at the SQL> prompt and do nothing. If I enter the database and copy...

Hello,

thanks for your reply but as a newbie, it's not very clear.
I was just hoping to cut and paste the results into a .sh script and execute the script. A novice like me, is unable to...

Hello,

I'm not very good at scripting as my job is an DBA for a small firm, but now I'd like to implement a few cron jobs which access and report on the databases on an automatic basis.

This...

Hello,

I'm not very good at scripting as my job is an DBA for a small firm, but now I'd like to implement a few cron jobs which access and report on the databases on an automatic basis.

This...

Hello,

thanks for the link, but it does not really provide what I am seeking. It just tells you the SQL Statement to determine the db growth. I am seeking the code that will write the output from...

Hello,

I have a script SELECT TO_CHAR(creation_time, 'RRRR Month') "Month",
SUM(bytes)/1024/1024 "Growth in MB"
FROM sys.v_$datafile
WHERE creation_time > SYSDATE-365
GROUP BY...

Many thanks,

now up and running fine via cron

works like a dream,

Many thanks

Hello,

is it possible for someone to generate a shell script that will do the following, please. UNIX Shell script novice who is after a script to look at a few things within an Oracle RAC...

Hi,

I would like to get the ORA-19815 entries for the past 24 hrs and then only mail
if it breaches the 80% threshold

thankyou

Thanks,

I will test and let you know

---------- Post updated at 05:17 PM ---------- Previous update was at 04:45 PM ----------

Hi,

it nearly worked, thanks, just a small error at the...

Hi,

thanks and that is true what you say, and I was just using the ORA-600 as an example. But I wanted to be able to act on the Flash back area, if the disk was say 80% full.

Thanks
...

OK,

tested and worked so thanks

I did that - but if there are any other errors within the hour will it also mail these?

For example I could have ORA-600 or other meaningless errors that I...

Hi,

Yes that is true. However the alert script runs once a day at 4am and I'd like to run this particular script on an hourly basis. Otherwise the first sign I am aware of the space issue is in...

Hello,

on a daily / hourly basis I need need to check the size for the Flash Recovery Area (v$flash_recovery_area_usage)

I was not in work yesterday and when I arrived today I checked the...

OK, thanks,

I've scheduled it via cron - and it now works perfect - thanks again for all your assiatance

OK Thanks,

this time it mail'd me,

however not sure about the statement 'You may need to adjust the path to oraenv.'

this is my location for oraenv -->...

Thanks very much - It worked as there were no errors yesterday, but I would have expected for it to mail me - and say that - or does it only mail on error, i.e if it finds something? output from...

Thanks for that - now when I execute the script nothing happens.
I would like to capture the script to see what happens but if I execute file.sh > file.log the log file is empty

This is the...

Hi,

that's perfect, thanks.

However is it possible to only capture that particular day's errors. So for example this will be run on a daily basis, say 3am and I would like the ORA error...

Hi,

Thanks for that and I executed the script and these are the results.
Maybe something is not enabled, prior to execution. This was run from the command line, not from cron

...

adrci - is the new 11g feature that reads the alert log

Automatic Diagnostic Repository Command Interface

OK, thanks,

I have this particular script, which I have executed - but nothing is extracted from the alert log and therefore no mail is sent.
Can you have a scan through this script and tell me...

Hi,

as the title says, I am after a simple script, which will open the Alert log from
an 11.2.0.1 Linux environment and mail the error message and description to a recipient email address.
...