If I start 'sqlplus' from console in /home/user directories, I can
load/execute the script by doing:
SQL> @scriptname
But what if I don't start sqlplus from that directories? How do I tell Oracle
to find the scripts in /home/user, then if it's not there in /usr/local/bin,
e in /home/user directories, I can
load/execute the script by doing:
SQL> @scriptname
But what if I don't start sqlplus from that directories? How do I tell
Oracle
to find the scripts in /home/user, then if it's not there in
/usr/local/bin,
for example? So that I can be anywhere
Title: RMAN Script Question
David,
Change the
following line in ur script :
backup database plus archivelog delete
input
to
backup incremental level = 0 plus
archivelog delete input
Hth,
Samir
Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] Phone
RDB,
It is always best to include the path for the script that you want to
execute. That way you make sure that you execute your script and not
someone else's. There can be many scripts of the same name in the
directory path.
Ron
>>> [EMAIL PROTECTED] 08/14/03 03:19PM >>&
Title: RMAN Script Question
I believe I have an RMAN script syntax error. The following script works fine:
resync catalog;
run {
allocate channel t1 type 'SBT_TAPE';
backup incremental level 0
skip inaccessible
tag hot_db_bk_level0
filesperset 5
format 'data_full_%d_%U_%p_%c
:
[EMAIL PROTECTED] Subject: How to tell Oracle the
directories of script files
om
Hello,
Suppose I have some SQL scripts in my /home/user directories, /usr/local/bin
directories, etc.
If I start 'sqlplus' from console in /home/user directories, I can
load/execute the script by doing:
SQL> @scriptname
But what if I don't start sqlplus from that director
Title: RE: How to tell Oracle the directories of script files
Use SQLPATH.
Alan Martin
Defense Logistics Info Service
Battle Creek, MI
-Original Message-
From: Reuben D. Budiardja [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 14, 2003 2:09 PM
To: Multiple recipients of list
Title: RMAN Script Question
Thanks
Samir, but I already tried that one too and it didn't work
either.
Best regards,
David B. Wagoner Database Administrator Arsenal Digital
Solutions -Original Message-From:
SARKAR, Samir [mailto:[EMAIL PROTECTED]Sent:
Wednesday, August 06,
Title: RMAN Script Question
David,
I notice that u r
using the line
format 'data_full_%d_%U_%p_%c.bak' (database);
in ur backup
script when u r actually performing a database backup including archived logs
backup.
Try modifying the
script as :
resync catalog; run
Title: RMAN Script Question
David,
I have
a set of scripts which do various rman backups that I would be happy to send you
if you send me your email address ( no attachments to the list). They work
because I use them every day.
Ruth
-Original Message-From: [EMAIL PROTECTED
For something a little different, play with the attached free.sql script.
-Original Message-
where can i find a script to find segments which can't extend due to low of
space in tablespace .
-ak
free.sql
Description: Binary data
AK, this is a very old script.
set pagesize 999
spool extent.lst
ttitle 'Database Objects that will have Trouble Throwing Extents'
column owner format a10;
column segment_name format a22;
column segment_type format a10;
column tablespace_name format a14;
column next_extent format 9
where can i find a script to find segments which
can't extend due to low of space in tablespace .
-ak
a NUMBER. Consider
> "count(*)" perhaps?
>
> -Original Message-
> Sent: Monday, July 21, 2003 4:59 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Im calling a script that uses dynamic sql. Im passing in a value as well.
I
> keep getting
>
&g
ps?
-Original Message-
Sent: Monday, July 21, 2003 4:59 PM
To: Multiple recipients of list ORACLE-L
Im calling a script that uses dynamic sql. Im passing in a value as well. I
keep getting
SP2-0552: Bind variable "2" not declared.
Here is a code snipped
declare
v_var1 Varch
ps?
-Original Message-
Sent: Monday, July 21, 2003 5:00 PM
To: Multiple recipients of list ORACLE-L
Im calling a script that uses dynamic sql. Im passing in a value as well. I
keep getting
SP2-0552: Bind variable "2" not declared.
Here is a code snipped
declare
v_var1 Varch
Title: RE: need execute immediate and script help
you want 'select count(*)' ... right?
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD
Im calling a script that uses dynamic sql. Im passing in a value as well. I keep
getting
SP2-0552: Bind variable "2" not declared.
Here is a code snipped
declare
v_var1 Varchar2(30) := 'TEST';
v_var2 VARCHAR2(30) := '&1';
total number;
Im calling a script that uses dynamic sql. Im passing in a value as well. I keep
getting
SP2-0552: Bind variable "2" not declared.
Here is a code snipped
declare
v_var1 Varchar2(30) := 'TEST';
v_var2 VARCHAR2(30) := '&1';
total number;
Hi Pete, Garry and Stephan,
Thanx a lot for the solution. It is working for me.
Thanx once again,
Regards,
~Dilip
Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com
Buy The Best In BOOKS at http://www.bestsellers.indiatimes.com
Bid for for Air Tickets @ Re.1 on A
lege had been granted to a particular user
> including
> mining through all of the roles granted hierarchically to roles etc.
> I
> posted a reference to a PL/SQL script I have knocked up as an answer
> there.
>
> I thought people here might be find it useful as well, its at
>
Hi everyone
I just answered a post on the server newsgroup from someone who wanted
to know if a privilege had been granted to a particular user including
mining through all of the roles granted hierarchically to roles etc. I
posted a reference to a PL/SQL script I have knocked up as an answer
Something else for people who are bored:
If I may ASS-U-ME that your ultimate goal is to have variables like:
LINE_THIS
LINE_THAT
LINE_THE_OTHER_THING
and you want to be able to change what is after the LINE part, if you have
genuine ksh93, and you like playing around with scripting stuff, then
Hi,
This works in ksh:
DBNAME=PROD
LINE_PROD=500
OTHER=\${LINE_${DBNAME}}
eval echo $OTHER
Regards
Pete
[END]
-Original Message-
Sent: 15 July 2003 11:35
To: Multiple recipients of list ORACLE-L
Hi List,
The requirement is as follows:
DBNAME=PROD ( 'DBNAME'
ROTECTED]>
cc:
Subject:OT: unix shell script question
Hi List,
The requirement is as follows:
DBNAME=PROD ( 'DBNAME' variable contains value 'PROD' )
LINE_PROD=100 ( 'LINE_PROD' variable contains value 100 )
Now I want to echo the LINE_PROD varia
Hi List,
The requirement is as follows:
DBNAME=PROD ( 'DBNAME' variable contains value 'PROD' )
LINE_PROD=100 ( 'LINE_PROD' variable contains value 100 )
Now I want to echo the LINE_PROD variable using DBNAME variable.
e.g
echo ${LINE_${DBNAME}} should return 100.
Is this possible and if yes,
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
By: George Leonard ([EMAIL PROTECTED])
# ([EMAIL PROTECTED])
#
# Description : Script checks last 200 lines of
# : the alert log for specific
# : Oracle errors, then pages or e-mails depending #on the
error.
#
# Paramete
])
# ([EMAIL PROTECTED])
#
# Description : Script checks last 200 lines of
# : the alert log for specific
# : Oracle errors, then pages or e-mails depending #on the
error.
#
# Parameter : ORACLE_SID#
#
# Format for
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
Thanx Gudmundur,Ranganath,Peter and Johnfor the scripts.
now i have to test the scritps on windows :(
Regards,
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fa
> 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
Try this (Solaris):
(B
(Bgrep ^ 'alert.txt' &&/usr/ucb/mail -s "ALERT - " fred <
(B'alert.txt'
(B
(BThe file 'alert.txt' is a spool file generated from an Oracle SQL script.
(BIf a non-null result arises, an alert condition exi
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
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
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
Hi Sami
Try something like this in korn shell, i have typed it in from memory so
please check the syntax...:-)
#!/bin/ksh
location="/tmp"
filename="YOURFILENAME"
done=false
while [[ $done = false ]]; do
if [[ ! -a $filename ]]; then
echo "do something"
cp $
Script would be good for this kind of thing, I think. Dig how similar this
windows scripting host script is to your pseudocode:
'
Dim FSO
Const WatchForFile = "c:\pretend.txt"
Const CopyFileTo = "c:\copied.txt"
Sent by: cc:
[EMAIL PROTECTED] Subject: Script to check filename
continuously
Hi All
Does anyone have script(DOS batch file or Unix Shell) to do the following
stuff?
loop
if exist FILE_NAME
begin
do something;
copy files to remote machine,etc...
EXIT;
end;
end loop;
Thanks
Sami
--
Please see the official ORACLE-L FAQ
ts working, you can then implemet blat as someone
> > suggested
> >
> > Here is a version using variables
> >
> > ##
> >
> > [myfind.bat]
> > :: Find example by BMetelsky on Friday-April-11-2003-9
1/2003 02:49 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc:
> Subject:RE: nt script
>
> FIND or FINDSTR should work equally well, I think. Maybe it depends on
> your exact platfor
cc:
Subject:RE: nt script
FIND or FINDSTR should work equally well, I think. Maybe it depends on
your exact platform.
-Original Message-
Sent: Tuesday, July 01, 2003 5:07 PM
To: Multiple recipients of list ORACLE-L
Hi...
I could not follow this thread, so, I do
tested this and it works...
1.- First, I saw that you asked for: string called ORA
and your errorlevel statement failed.
2.- Second, the script sent by: Seefelt, Beth looks
like it works (I did not test it), EXCEPT that you
HAVE to change this line:
> FIND "ORA-03313" psprcsrv_psnt_%MM
ror if any. Once its working, you can then implemet blat as someone
> > suggested
> >
> > Here is a version using variables
> >
> > ##
> >
> > [myfind.bat]
> > :: Find example by BMetelsky on
Hi Senthil...
I think you can get software from the internet...
but... if you need to do it at command level...
I would try a telnet to the 25 port...
If you need assistance, I can create something similar
here at work... and send it to you, just for sending
mails...
HTH
JL
--- Senthil Kumar D
Hi...
I could not follow this thread, so, I do not know the
current status...
anyway... I tested this and it works...
1.- First, I saw that you asked for: string called ORA
and your errorlevel statement failed.
2.- Second, the script sent by: Seefelt, Beth looks
like it works (I did not test
ing, you can then implemet blat as someone
> suggested
>
> Here is a version using variables
>
> ######
>
> [myfind.bat]
> :: Find example by BMetelsky on Friday-April-11-2003-9:22:53 AM
> :: This script searches thefile for a string and if it finds it, sends
> an email mess
Write your daily file to a 'nodate' file. Then copy it to a date file for
backup. Run your script against the 'nodate' file.
Ron
-Original Message-
Sent: Tuesday, July 01, 2003 2:51 PM
To: Multiple recipients of list ORACLE-L
Bob,
I tested it out, it works on on
t; going to return the errorlevel for the last file checked. Just use
> FINDSTR with a wildcard.
>
> FINDSTR /S /I /L "ORA-03113" d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log
> if errorlevel 1 goto run_proc
> echo 'there is a match'
>
> if errorlevel 0 got
see an
> error if any. Once its working, you can then implemet blat as someone
> suggested
>
> Here is a version using variables
>
> ##
>
> [myfind.bat]
> :: Find example by BMetelsky on Friday-April-11-2003-9:22
03113" d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log
> if errorlevel 1 goto run_proc
> echo 'there is a match'
>
> if errorlevel 0 goto end
> echo 'there is no match'
>
> :run_proc
> d:\start_proc.bat
> goto end
>
> :end
>
> HTH.
>
&g
re is a match'
>
> if errorlevel 0 goto end
> echo 'there is no match'
>
> :run_proc
> d:\start_proc.bat
> goto end
>
> :end
>
> HTH.
>
> -Original Message-
> Sent: Tuesday, July 01, 2003 12:15 PM
> To: Multiple recipients of
quot; d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log
> if errorlevel 1 goto run_proc
> echo 'there is a match'
>
> if errorlevel 0 goto end
> echo 'there is no match'
>
> :run_proc
> d:\start_proc.bat
> goto end
>
> :end
>
> HTH.
>
on using variables
##
[myfind.bat]
:: Find example by BMetelsky on Friday-April-11-2003-9:22:53 AM
:: This script searches thefile for a string and if it finds it, sends
an email message to dbamail
:: 0 =is found
echo off
set themess=A Database SE
For the mail part use...
On this page ->
http://www.interlog.com/~tcharron/blat.html
Download and install his file ->
http://www.interlog.com/~tcharron/blat194.zip
To send mail from a *.bat script-> blat %myfile.log% -subject
"%mysubject%" -to %toaddre
ERRORLEVEL 1 GOTO no
> IF NOT ERRORLEVEL 1 GOTO yes
>
> :no
> ECHO NOT FOUND
> goto end
>
> :yes
> ECHO String IS found
> pause
> goto end
>
> :end
> exit
>
> >
> > Hi listers,
> >
> > I am working on a nt script. I download
_proc
> echo 'there is a match'
>
> if errorlevel 0 goto end
> echo 'there is no match'
>
> :run_proc
> d:\start_proc.bat
> goto end
>
> :end
>
> HTH.
>
> -Original Message-
> Sent: Tuesday, July 01, 2003 12:15 PM
> To:
goto run_proc
echo 'there is a match'
if errorlevel 0 goto end
echo 'there is no match'
:run_proc
d:\start_proc.bat
goto end
:end
HTH.
-Original Message-
Sent: Tuesday, July 01, 2003 12:15 PM
To: Multiple recipients of list ORACLE-L
Hi listers,
I am working on a nt
is a match'
if errorlevel 0 goto end
echo 'there is no match'
:run_proc
d:\start_proc.bat
goto end
:end
HTH.
-Original Message-
Sent: Tuesday, July 01, 2003 12:15 PM
To: Multiple recipients of list ORACLE-L
Hi listers,
I am working on a nt script. I download FORFILE ex
I got it from http://www.ipass.net/davesisk/oont_download.htm
[EMAIL PROTECTED] wrote:
>
> Joan:
>
> Where did you get the FORFILE.EXE program from? And, yes I will look at the
> NT s
you can use perl from activestate.com. run your awk script through a2p and
see if it works. there are many mail modules... Mime::Lite, Mail::Send to
name a couple.
On Tue, 1 Jul 2003, Senthil Kumar D wrote:
> Hi Group,
>
> In one of our client place we are having Oracle 8.1.7 (std
Joan:
Where did you get the FORFILE.EXE program from? And, yes I will look at the
NT script.
RWB
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly
echo off
@cls
find "ORA-124" C:\yourlog.txt >NUL
IF ERRORLEVEL 1 GOTO no
IF NOT ERRORLEVEL 1 GOTO yes
:no
ECHO NOT FOUND
goto end
:yes
ECHO String IS found
pause
goto end
:end
exit
>
> Hi listers,
>
> I am working on a nt script. I download FORFILE exe, it wo
There's great freeware smtp client called BLAT that you can use. You
can probably google search for it or find it on www.download.com
HTH.
-Original Message-
Sent: Tuesday, July 01, 2003 11:20 AM
To: Multiple recipients of list ORACLE-L
Hi Group,
In one of our client place we are ha
Hi listers,
I am working on a nt script. I download FORFILE exe, it works fine. My
intention is finding the ORA-03113 string in the log. If there is a
match, then reboot the server, else do nothing. I don't have problem
with the findstr part. However, the errorlevel always return 0, no
matt
Hi Group,
In one of our client place we are having Oracle 8.1.7 (std Ed) on NT.
Here we need to send mails if the DB is down or if the listener is down or
any errors in the alert log is found. In Unix we can use shell scripts and
awk to do this. What about in NT/
Guru's do you have any scrip
> -Original Message-
> From: mike mon [mailto:[EMAIL PROTECTED]
>
> Does anyone has script which can check "grant
> privilege" on a table and generate output for future
> usage?
If you're looking for a script to show existing grants on a table, you c
I might have gotten something bass-ackwards here. Please correct as needed.
"Testing?! We don't need no stinkin' testing."
> -Original Message-
>
>
> select 'grant '||privilege||' to '|| grantee ||' on
> '||table_name||';' from
> dba_tab_privs where owner = 'BUBBA';
>
--
Please se
select 'grant '||privilege||' to '|| grantee ||' on '||table_name||';' from
dba_tab_privs where owner = 'BUBBA';
Note that this will get everything owned by BUBBA: tables, procedures,
packages, views, sequences.
> -Original Message---
Does anyone has script which can check "grant
privilege" on a table and generate output for future
usage?
Thanks.
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.
27;;' from sys.all_tables where owner = '';
select 'GRANT DELETE ON .'||'' || table_name ||' TO '
||';' from sys.all_tables where owner = '';
select 'GRANT EXECUTE ON .'||'' || object_name ||' TO '
||';'
tput the same to SQL creation scripts as well though..
I would personally do both. :)
The tool is free. You can get it here:
http://www.cool-tools.co.uk/Products/dbatool.html
HTH
Mark
-Original Message-
mike mon
Sent: 20 June 2003 13:45
To: Multiple recipients of list ORACLE-L
Does anyon
Does anyone has script which can check "grant
privilege" on a table and generate output for future
usage?
Thanks.
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.
Thanks! That's exactly what I need!
Jin
Quoting Pete Finnigan <[EMAIL PROTECTED]>:
> Hi
>
> You can stop the script by using the line
>
> whenever sqlerror exit rollback
>
> and then generating an error by using an exception in a PL/SQL block as
> follow
Hi
You can stop the script by using the line
whenever sqlerror exit rollback
and then generating an error by using an exception in a PL/SQL block as
follows:
oracle:jupiter> cat imp.sql
whenever sqlerror exit rollback
declare
cursor c_db is
select name from v$datab
Hi Chen,
My solution will be about the same with previous DBA guru
I assume u r using Window (if is unix you just need to change a little bit here and
there)
I write this script for you.
+save as imp.sql++
SET HEAD OFF
SET FEEBACK OFF
SET
Ave !
Here is one possible solution.
Create two tiny scripts. First script let say ex.sql which includes only
word exit and linefeed and second one cont.sql which has only one space
character, nothing else. Then in Your sql script:
--
column NAME noprint new_value SCRIPT_NAME
select decode
You could use a little indirect approach in this case.
The file import.sql will look like this
set feed off
set lines 120
set trimpsool off
set pages 0
spool imp.sh
select 'imp un/[EMAIL PROTECTED] file=a.dmp full=yes'
from v$database
where name = 'TEST'
/
spoo off
exit
You
I have a script and can be run on commandline like:
> sqlplus /@TEST @import.sql
However, I want to check database name at the beginning of import.sql. I knew
"select name from v$database" can obtain database name. But how can I stop the
script if I found it is not TEST
ica.se To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECT
Begin
EXECUTE IMMEDIATE 'CREATE INDEX ART_HIERARKI_LOCKEDIX1 ON
ART_HIERARKI_LOCKED(SELSKAP, SETT_ID, VGRP, ART_GRP, ART_UGRP)
TABLESPACE PBKIX PCTFREE 10 STORAGE(INITIAL 65536 NEXT PCTINCREASE
)';
EXECUTE IMMEDIATE 'CREATE UNIQUE INDEX PK_ART_HIERARKI_LOCKED ON
ART_HIERARKI_LOCKED(SELSKAP,
PROTECTED]
> Date: 2003/06/05 Thu AM 06:54:42 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Create index script in pl/sql
>
> Hallo all,
>
> anyone whom could help me with this:
>
> I would like to have an example of pl/sql procedur
Hallo all,
anyone whom could help me with this:
I would like to have an example of pl/sql procedur which does the following:
CREATE INDEX ART_HIERARKI_LOCKEDIX1 ON
ART_HIERARKI_LOCKED(SELSKAP, SETT_ID, VGRP, ART_GRP, ART_UGRP)
TABLESPACE PBKIX PCTFREE 10 STORAGE(INITIAL 65536 NEXT PCTINCRE
One more foot in the grave of us diehard IMMEDIATE fans (nee anti-ABORT).
Good to know that it's an option! Now if I can just get all of our various
software vendors to support anything above 8.1.7.2.0...
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED]
In 9i Release 2 :
exec dbms_stats.flush_database_monitoring_info
Nothing of the sort in earlier releases...
- Kirti
-Original Message-
Sent: Friday, April 04, 2003 9:09 AM
To: Multiple recipients of list ORACLE-L
Oh joy! The ABORT argument again! ;)
Is there a way to flush ta
On Fri, 4 Apr 2003, Darrell Landrum wrote:
> I once read an article in an IT publication (several years ago) in
> which the author stated that if you are still rebooting your Unix
> servers routinely, your Unix admins don't know what they're doing.
> Yes, the language was that harsh.
> I thought t
Oh joy! The ABORT argument again! ;)
Is there a way to flush table monitoring counts before the ABORT, either in
8i or 9i?
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent
[EMAIL PROTECTED] wrote:
Your reasons beat ours, Ray. We just reboot the box every weekend
because we do and we always have. It is AIX, too. We don't even reboot
our Win 2K machines as often.
there's also run away processes from poorly written third party
software, or internally written for t
All our unix servers (+-25) are AIX 4.3.
We reboot only if there is a problem.
Stephane
-Original Message-
Landrum
Sent: Friday, April 04, 2003 9:29 AM
To: Multiple recipients of list ORACLE-L
I once read an article in an IT publication (several years ago) in which
the author stated th
I once read an article in an IT publication (several years ago) in which
the author stated that if you are still rebooting your Unix servers
routinely, your Unix admins don't know what they're doing. Yes, the
language was that harsh.
I thought this was ludicrous for 2 reasons:
1) The author assume
Title: RE: dbshut script - why shutdown so much???
Your reasons beat ours, Ray. We just reboot the box every weekend because we do and we always have. It is AIX, too. We don't even reboot our Win 2K machines as often.
April Wells
Oracle DBA/ Oracle Apps DBA
-Original Me
On Thu, Apr 03, 2003 at 06:58:37PM -0800, Connor McDonald wrote:
> All this discussion on shutdown does motivate me to
> ask why is everyone shutting down so frequently?
--
Here are my reasons this past year:
oracle security patches
sun kernel patches
power "issues"
static configuration change
8
I'll agree to that.
I've had many discussions with our SAP BASIS admin about
this. They have to shutdown SAP periodically, and she was
always asking to bounce the database.
I always ask 'Why?', and would proceed to explain why not.
She finally quit asking. ;)
Jared
On Thursday 03 April 200
All this discussion on shutdown does motivate me to
ask why is everyone shutting down so frequently?
Almost without exception my ideal for any oracle
database is
a) never shut it down
b) if you really do need to shut it down, then use
abort
c) if you are not allowed to use abort, then use
abort-s
101 - 200 of 1050 matches
Mail list logo
