Search Results

Search: Posts Made By: jnrpeardba
1,309
Posted By jnrpeardba
Here is my results of running the script $...
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...
1,309
Posted By jnrpeardba
Hello, the problem is if I execute the...
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...
1,828
Posted By jnrpeardba
Hello, thanks for your reply but as a...
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...
1,309
Posted By jnrpeardba
Help with Database size script
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...
1,828
Posted By jnrpeardba
Help with Database size script
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...
1,957
Posted By jnrpeardba
Hello, thanks for the link, but it does not...
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...
1,957
Posted By jnrpeardba
Help with Daily DB growth script
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...
6,610
Posted By jnrpeardba
Many thanks, now up and running fine via...
Many thanks,

now up and running fine via cron
2,730
Posted By jnrpeardba
works like a dream, Many thanks
works like a dream,

Many thanks
2,730
Posted By jnrpeardba
script for RAC information required
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...
6,610
Posted By jnrpeardba
Hi, I would like to get the ORA-19815...
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
6,610
Posted By jnrpeardba
Thanks, I will test and let you know ...
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...
6,610
Posted By jnrpeardba
Hi, thanks and that is true what you say,...
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
...
6,610
Posted By jnrpeardba
OK, tested and worked so thanks I did...
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...
6,610
Posted By jnrpeardba
Hi, Yes that is true. However the alert...
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...
6,610
Posted By jnrpeardba
Script for V$flash_recovery_area_usage
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...
29,465
Posted By jnrpeardba
OK, thanks, I've scheduled it via cron -...
OK, thanks,

I've scheduled it via cron - and it now works perfect - thanks again for all your assiatance
29,465
Posted By jnrpeardba
OK Thanks, this time it mail'd me, ...
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 -->...
29,465
Posted By jnrpeardba
Thanks very much - It worked as there were no...
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...
29,465
Posted By jnrpeardba
Thanks for that - now when I execute the script...
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...
29,465
Posted By jnrpeardba
Hi, that's perfect, thanks. However...
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...
29,465
Posted By jnrpeardba
Hi, Thanks for that and I executed the...
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

...
29,465
Posted By jnrpeardba
adrci - is the new 11g feature that reads the...
adrci - is the new 11g feature that reads the alert log

Automatic Diagnostic Repository Command Interface
29,465
Posted By jnrpeardba
OK, thanks, I have this particular script,...
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...
29,465
Posted By jnrpeardba
Shell script to capture ORA errors from Alert Log
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.
...
Showing results 1 to 25 of 25

 

Featured Tech Videos

All times are GMT -4. The time now is 01:21 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy