PROTECTED]
Sent by: [EMAIL PROTECTED]
03/04/2003 09:14 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: dbshut script - shutdown or shutdown
immediate
Suppose you have a database with a sid of mydb
in this scenario. Of course it would not be a lot
different if we don't shutdown the databases when the box is going down ;) But
if I have the startup script in place as well have the shutdown script too.
I am not suggesting one option should be used instead of the other. Its a
question of personal
Carmichael [mailto:[EMAIL PROTECTED]
Enviado el: Miércoles, 02 de Abril de 2003 22:34
Para: Multiple recipients of list ORACLE-L
Asunto: RE: dbshut script - shutdown or shutdown immediate
yeah so? are you suggesting that Oracle instance recovery can't handle
a database crash? If so, better pray your
Precisely.
I am trying to propose the abort option, but I am not the majority around this place I
call work.. :)
On a more than dozen times in the last few months, I had to kill oracle processes to
get the database to shutdown (with immediate), so the scheduled reboot of the machine
will
Title: RE: dbshut script - shutdown or shutdown immediate
-Original Message-
From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]]
...
So use your test systems, load them up like production, and try both.
I bet in 9 out of 10 cases, checkpoint+abort+startup will be much
faster
Title: RE: dbshut script - shutdown or shutdown immediate
-Original Message-
From: Pardee, Roy E [mailto:[EMAIL PROTECTED]]
I would
have guessed
that optimally, you'd try immediate first then abort if
immediate takes
too long.
I've read that some people on the list have
Jacques - We have used SHUTDOWN IMMEDIATE for over 5 years now for cold
backups, with zero problems. Weekend before last we had 3 production
databases that didn't go down for backup (all of our databases scheduled for
cold backups). When I checked the following morning they were just hanging.
The
Here's how we do it:
We have 2 cron jobs, one of which runs 10 minutes after the first.
The first does a shutdown immediate. The second checks if oracle is running
and, if so, does a shutdown abort.
-Original Message-
Sent: Thursday, April 03, 2003 2:24 PM
To: Multiple recipients of
: dbshut script - shutdown or shutdown immediate
-Original Message-
From: Pardee, Roy E [mailto:[EMAIL PROTECTED]
I would
have guessed
that optimally, you'd try immediate first then abort if
immediate takes
too long.
I've read that some people on the list have done this. I am
Alas, I'm until recently a prisoner of windows so I can't speak to shell
scripts. On windows I'd probably try a windows script host vbscript like
so:
warning = air code
Option Explicit
Dim WinShell
Dim jobImmediate
Dim
From: Joan Hsieh [EMAIL PROTECTED]
Chris,
We hang on shutdown immediate, not startup. That's why I choose to use
shutdown abort.
Well, in that case of course you'd use it, but personally, if it was me, I'd
want to find out why it was hanging, and fix that instead. I'm not
suggesting shutdown
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
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
.
Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus
is
connect internal
shutdown
Should I modify the script to shutdown immediate so that it kills
any connections?
Environment is Oracle 8.1.7 /AIX 4.3.3.
Thanks,
Peter Schauss
Northrop Grumman Corporation
at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus
is
connect internal
shutdown
Should I modify the script to shutdown immediate so that it kills
any connections?
Environment is Oracle 8.1.7 /AIX 4.3.3.
Thanks,
Peter Schauss
Northrop Grumman Corporation
--
Please see
tries to shut down the system. The other instances,
which do not support a 24x7 process shut down properly.
Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus
is
connect internal
shutdown
Should I modify the script to shutdown immediate so that it kills
From: Schauss, Peter [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: dbshut script - shutdown or shutdown immediate
Date: Wed, 02 Apr 2003 07:03:38 -0800
I have one Oracle instance which supports an application
server which always
when she tries to shut down the system. The other instances,
which do not support a 24x7 process shut down properly.
Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus
is
connect internal
shutdown
Should I modify the script to shutdown immediate so
Yes, that should be a standard practice any time you perform an new Oracle install.
Otherwise, that database will problably always hang waiting for all sessions to
disconnect before completing the shutdown.
I believe the latest versions of Oracle have corrected that issue in the dbshut
script
process shut down properly.
Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus
is
connect internal
shutdown
Should I modify the script to shutdown immediate so that it kills
any connections?
Environment is Oracle 8.1.7 /AIX 4.3.3.
Thanks,
Peter
.
Otherwise, that database will problably always hang waiting for all sessions
to
disconnect before completing the shutdown.
I believe the latest versions of Oracle have corrected that issue in the
dbshut
script.
-Original Message-
Peter
Sent: Wednesday, April 02, 2003 9:04 AM
To: Multiple
On Wed, 2 Apr 2003, [EMAIL PROTECTED] wrote:
Then, while bringing up, we do
startup restrict;
shutdown immediate;
startup
Why? Doesn't it start up fine the first time?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please see the official ORACLE-L FAQ:
process shut down properly.
Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus
is
connect internal
shutdown
Should I modify the script to shutdown immediate so that it kills
any connections?
Environment is Oracle 8.1.7 /AIX 4.3.3.
From: Joan Hsieh [EMAIL
]
[EMAIL PROTECTED] cc:
om Subject: RE: dbshut script - shutdown or
shutdown immediate
Shutdown abort is pretty drastic, are you sure shutdown immediate didn't
work?
Well said. This topic has been circulating in many DBA forums for a long time.
Shutdown immediate does rollback and will take time if no.of users
is high. On the otherside, shutdown abort simply takes the db down and
Multiplexing redo logs has nothing to do with the archive mode. Logs are
multiplexed so that an error writing to one of the members in a group does
not cause the instance to terminate.
Myth - If you use disk mirroring, you don't need to multiplex your redo logs.
Reality - Mirroring only
is
connect internal
shutdown
Should I modify the script to shutdown immediate so that it kills
any connections?
Environment is Oracle 8.1.7 /AIX 4.3.3.
From: Joan Hsieh [EMAIL PROTECTED]
Peter,
I modified to shutdown abort, starup then shutdown immediate
This topic is getting interesting once more. Lets contribute.
Multiplexing redo logs has nothing to do with the archive mode.
Take a situation wherein the db is in NOARCH mode with only one member per group
(default setup). The dba gives shutdown abort and upon starting for some reason the
What does this have to do with archivelog mode? In the bizarre
scenario in which you lose a log between the time you shut down and
started up, you are screwed with or without archivelog mode.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 2 Apr 2003, GovindanK wrote:
This topic
The scenario you describe would occur regardless of the archive mode. An
active log cannot be archived. This would require that the ARCH process read
the log while LGWR is writing it. Once a log switch occurs (automatic or
manual), the previously active log can be archived.
In this scenario,
not support a 24x7 process shut down properly.
Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to
sqlplus
is
connect internal
shutdown
Should I modify the script to shutdown immediate so that it kills
any connections?
Environment is Oracle 8.1.7
:Re: dbshut script - shutdown or shutdown immediate
Multiplexing redo logs has nothing to do with the archive mode. Logs are
multiplexed so that an error writing to one of the members in a group does
not cause the instance to terminate.
Myth - If you use disk mirroring, you don't need
On Wed, 2 Apr 2003, Stephen Murphy wrote:
We replace the simple shutdown command with:
shutdown immediate
startup restrict
alter system switch logfile;
host sleep 10
shutdown immediate
Why do you do this elaborate dance? Are you trying to get the last
On Wed, 2 Apr 2003, Chris Berry wrote:
Shutdown abort is pretty drastic, are you sure shutdown immediate
didn't work?
What is drastic about shutdown abort?
Never one to opt out of a shutdown abort thread,
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
- Uses shutdown abort exclusively
On Wed, 2 Apr 2003, GovindanK wrote:
Shutdown immediate does rollback and will take time if no.of users
is high.
Number of users is not the largest contributing factor to shutdown
immediate taking a long time. The longest poles in the tent are large
transaction rollback and lazy temp segment
Well... my official oracle instructor in dba larva school said that it's
tantamount to crashing the db--or so I recall anyway. This isn't so?
Peace,
-Roy
Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487
-Original Message-
Sent: Wednesday, April 02, 2003 2:09 PM
http://download-west.oracle.com/docs/cd/A81042_01/DOC/server.816/a76956/onlinere.htm#3981
would be nice reference.
What i was trying to communicate was this: If the log is not multiplexed and the only
log member is not avbl for writing then LGWR cannot write and the db instance will go
down.
Agreed. I admit my English needs some improvement. What i wanted to say was about
rollback but used the words no.of.users. Thanks for pointing out.
GovindanK
Jeremiah Wilton [EMAIL PROTECTED] wrote:
On Wed, 2 Apr 2003, GovindanK wrote:
Shutdown immediate does rollback and will take time if
From: Jeremiah Wilton [EMAIL PROTECTED]
On Wed, 2 Apr 2003, Chris Berry wrote:
Shutdown abort is pretty drastic, are you sure shutdown immediate
didn't work?
What is drastic about shutdown abort?
Never one to opt out of a shutdown abort thread,
--
Jeremiah Wilton
Suppose you have a database with a sid of mydb running on unix.
Shutdown abort is like doing the following from the unix command line:
ps -ef | grep mydb | grep -v grep | xargs kill -9. All the processes
that make up the instance or processes that are connected to that
instance are killed. The
- Uses shutdown abort exclusively
- successful shutdowns/startups: over 10,000
- problems with shutdown abort: 0
- versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta)
- still employed!
- Drives to work on busy streets exclusively
- successful trips to work: over 14,000
- accidents during
To me it seemed the same as turning off your computer with the power button instead
of the shutdown command or using kill -9, sometimes you have to, but it's not what
you do normally.
Chris Berry
Sounds practical.
GovindanK
--
Shutdown Immediate v. Shutdown abort (Tastes Great...Less Filling!)
I'll admit to being in the Immediate camp. Why? I like the database to come down in a
consistent state except in emergency circumstances. There have been bugs related to
shutdown abort causing database problems.
Do those in the
On Wed, Apr 02, 2003 at 03:43:43PM -0800, Darrell Landrum wrote:
- Drives to work on busy streets exclusively
- successful trips to work: over 14,000
- accidents during trips to work: 0
- still, I drive carefully
--
I've always taken Jeremiah's modivation on this to be functionality.
You can
yeah so? are you suggesting that Oracle instance recovery can't handle
a database crash? If so, better pray your server never crashes.
--- Pardee, Roy E [EMAIL PROTECTED] wrote:
Well... my official oracle instructor in dba larva school said that
it's
tantamount to crashing the db--or so I
Carmichael To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
[EMAIL PROTECTED] cc:
ahoo.comSubject: RE: dbshut script
script - shutdown or shutdown immediate
Suppose you have a database with a sid of mydb running on unix.
Shutdown abort is like doing the following from the unix command line:
ps -ef | grep mydb | grep -v grep | xargs kill -9. All the processes
that make up the instance or processes
Oracle crash??? What's that :)??? Isn't that a bug in SQL Server only ?
-Mensaje original-
De: Rachel Carmichael [mailto:[EMAIL PROTECTED]
Enviado el: Miércoles, 02 de Abril de 2003 22:34
Para: Multiple recipients of list ORACLE-L
Asunto: RE: dbshut script - shutdown or shutdown
]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Error while running export backup shell script
Date: Thu, 20 Mar 2003 23:43:36 -0800
Hi List,
I have got a shell script for taking full export backup which I am
attaching with this mail as .sql file as I cannot send .sh file
Hi List,
I have got a shell script for taking full export backup which I am
attaching with this mail as .sql file as I cannot send .sh file as file
attachments. I am getting the following error when I run the script in
full_exp_20030321_1309_job.log
Hi,
Looks like one or more environment issues. First, make sure that mknod is in your
path or go ahead and enter the full path to it in the script ( /usr/sbin/mknod on my
local HP system, looks like you might be on Sun, though ).
Next, make sure your export command is all on one line.
Instead
Hi Ranganath,
I think you must be executing this script from oracle user. It seems you
do not have execute permissions on mknod command. Ask your sysadmin to give
access to that command.
or
run this script from root user by exporting the ORACLE_SID ORACLE_HOME.
rukmini
The mknod command isn't in the path. Either
setup the path in the script or explicitly
specify the path.
I don't think that the ORACLE_HOME is getting set
correctly in your derive_oracle_paths function.
Check the oratab file.
Hemant
--- Krishnaswamy, Ranganath [EMAIL PROTECTED] wrote:
Hi
it DOES mean that your ORACLE_HOME is not getting set in the environment.
Which shell is the script running in ? Are you sure that the
export ORATAB=/var/opt/oracle/oratab and other lines are actually exporting
of the variables ? Else try ORATAB=/var/opt/oracle/oratab; export ORATAB
and so on
Hemant
Anyone have a
"simple" script to scan an alert
log for errors and
email a report if found?
Customer wants
something to run "often", but only
email when an error
is found. I've got something
that does a bit of
that and runs twice a day, but
always sends
out.
Thanks.
Maks.
:[EMAIL PROTECTED]
-s Oracle ORCL alert
erase c:\orant\rdbms80\trace\orcl\orclalrt.tmp
rename c:\orant\rdbms80\trace\orcl\orclalrt.log orclalrt.tmp
:END
-Original Message-
Sent: Friday, March 21, 2003 11:40 AM
To: Multiple recipients of list ORACLE-L
Anyone have a simple script to scan
Check Tim Gorman's web site, http://www.evdbt.com/tools.htm. He has a script
(chk_oerr.sh) to monitor alert.log for new ORA- errors and e-mail.
You can see how it is done and come up with your own version for your own
requirements.
- Kirti
-Original Message-
Sent: Friday, March 21
You can try a korn shell script called chkdberr.ksh at
http://www.appsdba.com/scripts/chkdberr.ksh, it's already got the email
built in.
At 10:39 AM 3/21/2003 -0800, you wrote:
Anyone have a simple script to scan an alert
log for errors and email a report if found?
Customer wants something
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
/prod/dba/sys_data/newpath`/misc_logs/chk_alerts.log
Andy:
This is a very cool script.
Thanks very much!!
Barb
--- Andy Rivenes [EMAIL PROTECTED] wrote:
You can try a korn shell script called chkdberr.ksh
at
http://www.appsdba.com/scripts/chkdberr.ksh, it's
already got the email
built in.
At 10:39 AM 3/21/2003 -0800, you wrote:
Anyone
Hi,
Our app is strange. :-( We use pl/sql(9i) package to
create all the html and java script. I have two drop
down boxes on a form, the values for the second box
changes dynamically depends on the value of the first
box. The values for the boxes are from cursors
written in pl/sql. We
Janet,
Try the forums at http://java.sun.com or inquire at http://devtrends.oracle.com
Darrell
[EMAIL PROTECTED] 03/13/03 10:59AM
Hi,
Our app is strange. :-( We use pl/sql(9i) package to
create all the html and java script. I have two drop
down boxes on a form, the values for the second
Hi,
Thank you to all those answering my java script
question.
As I said, all the html and java script are generated
by pl/sql package. I'd like to know can the onClick
method below call a pl/sql procedure? If it cann't, I
suppose onClick needs to call a java script function
first
: Multiple recipients of list
ORACLE-LSubject: RE: nt script
Thanks to all of you for your advice about learning Windows
Shell Scripting. Suggestions were: - read Windows NT
Shell Scripting by Tim Hill - http://www.calweb.com/~webspace/batch/index.htm
- RTFH facility (help command at the DOS
Title: RE: nt script
Thanks to all of you for your advice about learning Windows Shell Scripting. Suggestions were:
- read Windows NT Shell Scripting by Tim Hill
- http://www.calweb.com/~webspace/batch/index.htm
- RTFH facility (help command at the DOS prompt)
- Many useful NT commands
-
From: Jose Luis Delgado [mailto:[EMAIL PROTECTED]
I'll try to help you between lines...
i.e. I'll write the corresponding CMD line for your
script.
Regards!
JL
in a .CMD file:
echo Sending mail!!!
echo Sending mail!!!
dt=$(date '+%H%M_%m%d%y
Hi Dear list;
I don't have experience on NT scripting. but I have an urgent need for
nt script. Someone's help would be appreciated. Here is the question;
How to convert this script to nt script? I need to reboot the nt server
if there is any error on this sql statement instead of paging someone
Hi Jose,
Many many thanks to you. This is great.
Joan
Jose Luis Delgado wrote:
Hi!!
I'll try to help you between lines...
i.e. I'll write the corresponding CMD line for your
script.
Regards!
JL
in a .CMD file:
echo Sending mail!!!
echo Sending mail!!!
dt=$(date '+%H
Title: RE: nt script
Can anyone recommend a book / website on the DOS batch file language? I usually try to install cygwin and write shell scripts but some of our database servers don't have cygwin.
For example, I have no idea what this statement does:
FOR /F TOKENS=1,2* %%A IN ('DATE/T') DO
Title: RE: nt script
I have found http://www.calweb.com/~webspace/batch/index.htmto
be useful.
Raj
-
Rajendra dot Jamadagni at espn dot
com Any views expressed here are
strictly personal. QOTD: Any clod can
have facts, having
]
I'll try to help you between lines...
i.e. I'll write the corresponding CMD line for your
script.
Regards!
JL
in a .CMD file:
echo Sending mail!!!
echo Sending mail!!!
dt=$(date '+%H%M_%m%d%y')
FOR /F TOKENS=1,2* %%A IN ('DATE/T') DO SET DATE=%%B
export ORACLE_SID=FMRPT
SET
. I'll write the corresponding CMD line for your
script.
Regards!
JL
in a .CMD file:
echo Sending mail!!!
echo Sending mail!!!
dt=$(date '+%H%M_%m%d%y')
FOR /F TOKENS=1,2* %%A IN ('DATE/T') DO SET DATE=%%B
export ORACLE_SID=FMRPT
SET ORACLE_SID=FMRPT
sqlplus
Title: RE: nt script
If you
just do a HELP COMMAND, where command is the name of the command you need help
on, you can find out as much as you really need to know about
BATCH.
In
your sample of FOR /F
"TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B
They were trying to set
%%A was unexpected at this time.
-Original Message-
From: Jose Luis Delgado [mailto:[EMAIL PROTECTED]
I'll try to help you between lines...
i.e. I'll write the corresponding CMD line for your
script.
Regards!
JL
in a .CMD file:
echo Sending mail!!!
echo Sending mail
Title: RE: nt script
Do yourself a
favour - resist temptation of even considering DOS batch "language" (as it
isnothing morethan a horrid pile of I-won't-say-what;-)
Better
choiceis WSH and VBScript or JScript. Windows Scripting Host comes with
every IE - therefore every Windo
We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC
System/6000: Version 2.3.4.0.0.
I have a database here with about 600 Oracle users defined
in dba_users. However, likely one half or more of the defined users no
longer connect to the database. I want to purge out the users that do not
Title: RE: Script to Turn Off All Oracle Auditing Options?
To create the audit trail views, run cataudit.sql.
To delete the audit trail views, run catnoaud.sql.
To find out which are the active options, use this statement:
SELECT * FROM sys.dba_priv_audit_opts;
or for audit options
In my previous message, I forgot to say:
You could always use the scorched earth approach and change everyone's
password. Then see who complains that they can't log in. :)
-Original Message-
We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version
2.3.4.0.0.
I have a
I see yet another poor soul still supporting V7.3.4.5 as I am doing on V2.6
Solaris.
You should be warned that on a couple of different occasions (I'm a slow
learner)
when I launched a SQL script which changed AUDITing on hundreds of objects,
Oracle went bonkers. It appearded as though
Dear All,
Here we have about 14 Oracle devlopers and some times they run a
sript which down grade the database performance. I nicely asked for a script
that a developer has run for testing but sometimes they won't give away it
so easily. So I would like to know that is it possible to get
Title: RE: trace (get) sql script
Hi,
If you've asked nicely; tried reasoning with the developer; and talked to management without success, use this:
REVOKE CONNECT from developer_user_name;
Works for me!
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED
by: cc:
[EMAIL PROTECTED] Subject: trace (get) sql script
Try v$sql, v$sqlarea, and v$sqltext. They should get
you everything you need.
--- [EMAIL PROTECTED] wrote:
Dear All,
Here we have about 14 Oracle devlopers and some
times they run a
sript which down grade the database performance. I
nicely asked for a script
that a developer has run
Title: RE: Embeded password in script
Thank you, Jared. I have the book you wrote and will look into it.
Regards,
David
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 24, 2003 4:51 PM
To: Multiple recipients of list ORACLE-L
Subject: Re
recipients of list ORACLE-L
I have been tasked to write a script to run SQL. I don't want a password
field to be shown in the script. Does someone have run into this and have a
better idea? For example, I have following line in my script.
Sqlplus dbimpl/password @SQLscript.sql
Also, from
You can have username/password in the first line of the sqlplus script.
sqlplus @your-script.sql
Your-script.sql will have id/pw in the first line.
Regards,
Waleed
-Original Message-
Sent: Monday, February 24, 2003 3:54 PM
To: Multiple recipients of list ORACLE-L
I have been tasked
: Embeded password in script
Actually, this would still display the password in the output
of ps -ef
because the $syspw environment variable is resolved before
handing it to
sqlplus.
Try sqlplus dbimpl/$syspw and then a ps -ef...
Rich
Rich JesseSystem/Database
sqlplus /nolog !
conn dbimpl/password
@SQLscript.sql
!
-Original Message-
Sent: Monday, February 24, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
I have been tasked to write a script to run SQL. I don't want a password
field to be shown in the script. Does someone have run
( encrypted with MD5 ).
If the job is a Perl script ( fairly likely around here ) the password
can't appear to PS, as no password is ever used on the command
line.
It's handy for command line stuff as well, as I only need rights to
access the password database via the password daemon. I don't
have to know
I have been tasked to write a script to run SQL. I don't want a password
field to be shown in the script. Does someone have run into this and have a
better idea? For example, I have following line in my script.
Sqlplus dbimpl/password @SQLscript.sql
Also, from command line we go through
sqlplus -s EOF
connect system/[EMAIL PROTECTED]
@SQLScript
EOF
-Original Message-
From: Nguyen, David M [mailto:[EMAIL PROTECTED]
Sent: Monday, February 24, 2003 3:54 PM
To: Multiple recipients of list ORACLE-L
Subject: Embeded password in script
I have been tasked to write
password in
script
[EMAIL PROTECTED]
02/24/2003 12:54
PM
Please respond to
ORACLE-L
I have been tasked to write a script
David
You could change the read permission on the script so nobody can read it.
A larger issue is how to prevent other users from seeing the password while
your process is executing. Connor McDonald who participates on this list has
some ideas at:
http://www.jlcomp.demon.co.uk/faq
Title: RE: Embeded password in script
cat pwfile
syspw=blah
export syspw
^D
chmod 700 pwfile
Unix Prompt . pwfile
Unix Prompt sqlplus dbimpl/$syspw @your_script_here
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views
/${password} @SQLscript.sql
someone could still see the Oracle password with a sneaky ps command while
your script is running.
a very similar approach could be taken with perl if awk isn't your cup of
tea.
-Original Message-
Sent: Monday, February 24, 2003 2:54 PM
To: Multiple recipients of list
to run regularly from cron, I use the password
daemon pwd.pl and retrieve the passwords across the network
( encrypted with MD5 ).
If the job is a Perl script ( fairly likely around here ) the password
can't appear to PS, as no password is ever used on the command
line.
It's handy for command line
directory can be quite restrictive
(only authorized people).
The sql directory can be read only to the world (no passwords are stored
in any scripts).
The ps command cannot display the password, but can show what script is
running.
Have Fun :)
Nguyen, David M wrote:
I have been tasked to write
Hi,
I have an oracle 8173 db on Sun Solaris 2.8 and a developer run some perl
script (using DBI and DBD). But the program repeatly generated oracle trace
file in udump dirctory. I looked at the file and it has the following info
again and again (I set the max dump file size to 5M, otherwise
sorry my script is a UNIX script!
Orysia Husak
Database Management Services
perotsystems - CHW Phoenix
(602) 307-2896
(602) 300-9752 (Cell)
-Original Message-
Sent: Thursday, February 06, 2003 11:00 AM
To: Multiple recipients of list ORACLE-L
Could you post it to the list?
Igor
Good morning everyone Win2k pro, oracle 8.17
Ive been investigating a simple monitor script which will email me if
the database is not available. I need this to be as simple as possible
(ideally a batch file)
Ive come across this on orafaq
http://www.orafaq.net/scripts/win/isdbup.txt
But dosnt
201 - 300 of 983 matches
Mail list logo
