Embeded password in script

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 th

perl script generating oracle udump trace file

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

RE: Looking for simple monitor script dbup.bat

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

RE: Looking for simple monitor script dbup.bat

Title: RE: Looking for simple monitor script dbup.bat If I understand you correctly, the problem is that you don't get an ERRORLEVEL set when you are unable to connect to a database. Have you tried sqlplus/nolog? (Ignore the french text, I have Oracle installed  in french on my P

Re: Looking for simple monitor script dbup.bat

Could you post it to the list? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, February 06, 2003 12:14 PM > Bob, > I have a very simple script which checks to see if

RE: Looking for simple monitor script dbup.bat

Title: RE: Looking for simple monitor script dbup.bat Hi Bob, Check out Steve Adams' script (www.ixora.com.au).  It's written in ksh and will need a little modification to send emails, but it's bulletproof.  Also others on the list have mentioned Cygwin (?) the Windows-ksh t

RE: Looking for simple monitor script dbup.bat

Bob, I have a very simple script which checks to see if the database is up and open. I've emailed you the script. Orysia Husak Database Management Services PEROTSYSTEMS (602) 307-2896 cell: (602) 300-9752 -Original Message- Sent: Thursday, February 06, 2003 9:00 AM To: Mul

Looking for simple monitor script dbup.bat

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

Re: FW: OT: unix script quetion: to replace $ with \$

ign), as > > some InterMedia > > table names do, the piped command will fail. > > > > Guang > > > > > -Original Message- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of > > > Stephen Lee > > > Se

FW: OT: unix script quetion: to replace $ with \$

ed command will fail. > > Guang > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of > > Stephen Lee > > Sent: Monday, February 03, 2003 3:54 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: OT

RE: OT: unix script quetion: to replace $ with \$

PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of > > Stephen Lee > > Sent: Monday, February 03, 2003 3:54 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: OT: unix script quetion: to replace $ with \$ > > > > > > > > Would somethin

RE: OT: unix script quetion: to replace $ with \$

3:54 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: OT: unix script quetion: to replace $ with \$ > > > > Would something like this be adaptable to your stuff? > > #!/usr/bin/ksh > > { > sqlplus -s <<-XXX > joe/blow@SID > set this an

Re: OT: unix script quetion: to replace $ with \$

044 echo '123$45$678' | sed -e "s#\044#\\\044#g" Jared "Guang Mei" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/03/2003 12:09 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc:

RE: OT: unix script quetion: to replace $ with \$

Would something like this be adaptable to your stuff? #!/usr/bin/ksh { sqlplus -s <<-XXX joe/blow@SID set this and that off set the other thing and trimspool on set whatever else select table_name from dba_tables where owner = 'BUBBA'; } | while read LINE;

Re: OT: unix script quetion: to replace $ with \$

ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: OT: unix script quetion: to replace $ with \$ Hi, Brian: Thanks for your (and others) help. I can not use signle quotes in "echo" in my program. The reason is

Re: OT: unix script quetion: to replace $ with \$

Sent by: Subject: OT: unix script quetion:

Re: OT: unix script quetion: to replace $ with \$

Hi, Brian: Thanks for your (and others) help. I can not use signle quotes in "echo" in my program. The reason is this: I am trying to run table analyze in multiple treads (I found doing this reduce time by 50%). By doing this I run sh script "gather_ISI_table_stats_executeX.sh

Re: OT: unix script quetion: to replace $ with \$

echo '123$45$678' | sed -e 's#\$#\\$#g' "Guang Mei" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/03/2003 10:39 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: S

Re: OT: unix script quetion: to replace $ with \$

[EMAIL PROTECTED] cc: Subject: OT: unix scri

Re: OT: unix script quetion: to replace $ with \$

Please note the use of single-quotes (') instead of double-quotes (") in the echo command, as well as the use of single-quotes in the sed command... $ echo '123$45$678' | sed 's/\$/\\$/g' 123\$45\$678 Hope this helps... > Hi: > > I have a quick question about replacing "$" with "\$" on

RE: unix script quetion: to replace $ with \$

echo '123$456$789' | sed 's/\$/\\\$/g' 123\$456\$789 Why? The "$" means "end of line" to sed; so you have to quote it too. > -Original Message- > Maybe there is another syntax that I should use? TIA. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steph

OT: unix script quetion: to replace $ with \$

Hi: I have a quick question about replacing "$" with "\$" on unix. I need to convert string "123$45$678" to "123\$45\$678" through a pipe. I tried with sed command, but could not get it to work: essex$ echo "123$45$678" | sed s/"$"/"\$"/g 123578$ essex$ echo "123$45$678" | sed s/"$"/"\\$"/g 123

Re: OT: unix script quetion: to replace $ with \$

Use the translate command "tr". Type "man tr" for help with using it. RWB "Guang Mei" <[EMAIL PROTECTED]>@fatcity.com on 02/03/2003 12:39:48 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Hi: I h

Re: create tablespace script

> > Takes a lot less code. > > Jared > > > > > > > mkb <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 01/21/2003 01:09 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <

Re: create tablespace script

; > Sent by: [EMAIL PROTECTED] > 01/21/2003 01:09 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:Re: create tablespace script > > > Helmut, >

Re: create tablespace script

Subject:Re: create tablespace script Helmut, I have the following in perl. It handles multiple datafiles for a tablespace. See the in-line comments below. You can modify this logic for PL/SQL. I think I also have a script in PL/SQL (somewhere) that I wrote and converted to p

Re: create tablespace script

Helmut, I have the following in perl. It handles multiple datafiles for a tablespace. See the in-line comments below. You can modify this logic for PL/SQL. I think I also have a script in PL/SQL (somewhere) that I wrote and converted to perl. Let me know if you'd like to take a look at

RE: create tablespace script

Title: create tablespace script Watch out because this also creates the DDL for the system tablespace, if you are using real temporary tablespaces it will not create the DDL for that.   declare   cursor c_ts is select * from dba_tablespaces;   cursor c_df (p_tablespace varchar2) is select

RE: create tablespace script

Title: create tablespace script DBA_DATA_FILES contains the tablespace name. Use that to 'group' the datafiles together. -Original Message-From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 21, 2003 7:49 AMTo: Multiple recipients of list

create tablespace script

Title: create tablespace script Hi! I want to write a "create tablespace" script that creates all "create tablespace" statements for a database. I got this script working if each tablesspace has only one datafile. But how would I handle it if a tabl

RE: Unix Max Extent Script

My favorite is when people go nutty checking every possible variable in their scripts before getting to the thing the script was actually written for i.e... Check to see if database sid is valid, check to see if user name is valid, check to see if time zone on server is set, what is ambient

Re:Unix Max Extent Script

ll not fit into their tablespace and segments whose number of extents are approaching the max number of extents. But, what I am looking for is a Unix shell script that will run one of these scripts and mail alerts based on the results. Has anyone written a shell script that will do this that they woul

Re: Unix Max Extent Script

en which basically was a spool to a file of a SELECT * on the various views in the dictionary, wrapped into a shell script and followed by a number of greps ... Why use SELECT when you can grep with regular expressions ? -- Regards, Stephane Faroult Oriole Software -- Please see the official ORA

RE: Unix Max Extent Script

segments whose next extents will not fit into their tablespace and segments whose number of extents are approaching the max number of extents. But, what I am looking for is a Unix shell script that will run one of these scripts and mail alerts based on the results. Has anyone written a shell script

RE: Unix Max Extent Script

Title: Message Here is what we run.  It is part of a group of scripts we run every 15 minutes that monitor all the databases.  The script will either send a page or an email, depending on how it is called.   The command to run the script (cron every 15 minutes): nextext.sh prod zrls1 > /

RE: Unix Max Extent Script

creating a whole bunch of new scripts for people to manage. If you still insist on going the UNIX scripting route please DO NOT write a specific script to check extents. Instead write a script which runs any .sql file and checks for rows returned, then takes some action based upon the fact that

RE: Unix Max Extent Script

Title: RE: Unix Max Extent Script search for "smenu" in Google ... it is a bunch of scripts with all sh interface. Raj __ Rajendra Jamadagni      MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion express

RE: Unix Max Extent Script

segments whose number of extents are approaching the max number of extents. But, what I am looking for is a Unix shell script that will run one of these scripts and mail alerts based on the results. Has anyone written a shell script that will do this that they would like to share? There are many other

Unix Max Extent Script

I have found many great SQL scripts to identify segments whose next extents will not fit into their tablespace and segments whose number of extents are approaching the max number of extents. But, what I am looking for is a Unix shell script that will run one of these scripts and mail alerts based

RE: Script to recreate schema

Yes. And bvi for binary files. -Original Message- Sent: Thursday, December 26, 2002 2:04 AM To: Multiple recipients of list ORACLE-L exp userid=system/manager file=schema.dmp rows=n owner=scott vi schema.dmp really. Jared On Wednesday 25 December 2002 09:53, Andrey Bronfin wrote: >

Re: Script to recreate schema

> > I'm sure many of you have scripts to recreate an Oracle schema including > > objects (i am interested in tables, indexes , comments, views, sequences, > > triggers, stored procs/functions etc..) > exp userid=system/manager file=schema.dmp rows=n owner=scott > vi schema.dmp Instead of "vi schem

Re: Script to recreate schema

exp userid=system/manager file=schema.dmp rows=n owner=scott vi schema.dmp really. Jared On Wednesday 25 December 2002 09:53, Andrey Bronfin wrote: > Dear gurus ! > I'm sure many of you have scripts to recreate an Oracle schema including > objects (i am interested in tables, indexes , comments,

Script to recreate schema

RE: Any way to script or document jobs defined to the NT/MS2000 T

<[EMAIL PROTECTED]<[EMAIL PROTECTED]> om> cc: Sent by: Subject: Any way to script or document jobs [EMAIL PROTECTED]defined to the NT/MS2000 Task

Re: Any way to script or document jobs defined to the NT/MS2000 Task

om> cc: Sent by: Subject: Any way to script or document jobs [EMAIL PROTECTED]defined to the NT/MS2000 Task

RE: Any way to script or document jobs defined to the NT/MS2000 T

the server we would lose the schedule and have to figure out how and When all the batch jobs were scheduled. Does anyone know a way to script or otherwise document jobs defined to the Task Scheduler? R. Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying

RE: Any way to script or document jobs defined to the NT/MS2000 T

ure out how and When all the batch jobs were scheduled. Does anyone know a way to script or otherwise document jobs defined to the Task Scheduler? R. Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me

Any way to script or document jobs defined to the NT/MS2000 Task

We have started using the NT/MS2000 Task Scheduler instead of the 'AT' command to schedule jobs. I am concerned that if we lose the server we would lose the schedule and have to figure out how and When all the batch jobs were scheduled. Does anyone know a way to script or otherwise doc

RE: 9i database create script - My, how things have changed

Title: 9i database create script - My, how things have changed Sorry, false alarm. Sometimes us simple folk have a hard time with them pretty pictures. Figgered it out finally. -Original Message-From: Cornio, Georgette Ms USACFSC [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December

RE: 9i database create script - My, how things have changed

Title: 9i database create script - My, how things have changed I followed the same procedure as 8.1.7 to make the scripts and modified them   What part does not work, no mo ?     -Original Message-From: Jeremy Pulcifer [mailto:[EMAIL PROTECTED]]Sent: Monday, December 02, 2002

Re: 9i database create script - My, how things have changed

Some simple options: 1) The 9.x installer still gives the option of creating scripts in the old fashioned way. The key is not to choose a "template" database. A little scrubbing and they work fine...but man do they take a while to create a db nowadays. 2) My preferred option is to create a skel

Re: 9i database create script - My, how things have changed

TED]> Sent by: [EMAIL PROTECTED] 12/02/2002 12:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: 9i database create script - My, how things have changed ...since 8.1.7. I've always ran the data

9i database create script - My, how things have changed

Title: 9i database create script - My, how things have changed ...since 8.1.7. I've always ran the database creation utility, then swiped the scripts outta the admin\[sid]\create\ directory, scrubbed 'em a bit, and let er rip. My consultants create/install new db's quite freq

RE: Urgent : Shell Script is needed !!!!!

FONT-SIZE: 10pt; MARGIN-LEFT: 0px; COLOR: #cc; FONT-FAMILY: Helvetica, "Times New Roman" } Thank you for the mail , i have prepared a script by reading some examples which were written in the past thanks again Madhu -Original Message-From: Kevin Lange [mailto:

RE: Urgent : Shell Script is needed !!!!!

 -Original Message-From: Reddy, Madhusudana [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 14, 2002 2:50 PMTo: Multiple recipients of list ORACLE-LSubject: Urgent : Shell Script is needed ! Hello All,   I have to do automation of manual process of the following things, being

Re: Urgent : Shell Script is needed !!!!!

> "Reddy, Madhusudana" wrote: > > Hello All, > > > I have to do automation of manual process of the following things, > being not good at the Shell scripting , I need your help or at least a > sample script would be great > > Manual process: >

Urgent : Shell Script is needed !!!!!

Title: Blank Hello All,   I have to do automation of manual process of the following things, being not good at the Shell scripting , I need your help or at least a sample script would be great Manual process: 1. get the oldest partition name from a partitioned table 2. create a non

Script for Import 29000000 lines in background and to create index.

Friends : I have a situation : I need to import file wiht 29.000.000 lines and after it i would like to create a index in background on unix. Does anyone have some example off shell script that does it using nohup and & ? My idea is to call just one time and to run all operations, like

RE: How to zip a file on From Unix shell script

a file on From Unix shell script With or without the *really fine* compression flag??  (-rf)   : )   --| Brian McGraw /* DBA */  Infinity Insurance || mailto:[EMAIL PROTECTED] |--

RE: How to zip a file on From Unix shell script

-LSubject: RE: How to zip a file on From Unix shell script The best compression known to man is achieved by using  the 'rm' compression utility. -Original Message-From: WLSH [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 16, 2002 6:44 PMTo: Multiple rec

RE: How to zip a file on From Unix shell script

PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Gogala, Mladen Sent: Thursday, October 17, 2002 1:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to zip a file on >From Unix shell script   The best compression known to man is achieved by using  the 'rm' compre

RE: How to zip a file on From Unix shell script

Unix shell script Hello, list: We have a unix nightly job which will send an email to a user. However, the file size is very large, so we need to zip the file before we send it out. Does anyone know the syntax or command of zipping a file from UNIX ?   Regards, [EMAIL PROTECTED] Do

RE: How to zip a file on From Unix shell script

zip a file on >From Unix shell script   I'm curious how you get sendmail/mailx to send a file as an attachment?  I suppose it can be done. -Original Message- From: Tim Gorman [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 17, 2002 11:59 AM To: Multiple recipients of list

RE: How to zip a file on From Unix shell script

try this... cat << ! To: [EMAIL PROTECTED] [EMAIL PROTECTED] Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="DMW.Boundary.605592468" Attached you can find the files. ! uuencode file001 uuencode file002 uuencode file0

RE: How to zip a file on From Unix shell script

chard" ricas.com> cc: Sent by: Subject: RE: How to zip a file on From Unix shell script [EM

RE: How to zip a file on From Unix shell script

file on From Unix shell script you can download it at http://www.gnu.org/software/gzip/gzip.html...   - Original Message - From: WLSH To: Multiple recipients of list ORACLE-L Sent: Thursday, October 17, 2002 9:34 AM Subject: Re: How to zip a fi

RE: How to zip a file on From Unix shell script

Maybe this is of additional help   http://www.gzip.org/zlib/   -Original Message-From: WLSH [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 17, 2002 11:35 AMTo: Multiple recipients of list ORACLE-LSubject: Re: How to zip a file on From Unix shell script Thanks, all

RE: How to zip a file on From Unix shell script

Try doing a google on pkzip for unix   We have it our HP-UX box it works fine   -Original Message- From: WLSH [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 17, 2002 11:35 AM To: Multiple recipients of list ORACLE-L Subject: Re: How to zip a file on >From Unix shell scr

Re: How to zip a file on From Unix shell script

you can download it at http://www.gnu.org/software/gzip/gzip.html...   - Original Message - From: WLSH To: Multiple recipients of list ORACLE-L Sent: Thursday, October 17, 2002 9:34 AM Subject: Re: How to zip a file on From Unix shell script Thanks, all

Re: How to zip a file on From Unix shell script

it may pay to add the .zip extension to the filename so that themail client knows what to do with it.Reginald.W.Bailey@jp morgan.com To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>Sent by: cc: [EMAIL PROTECTED] Subject: Re: How to zip a file on From Unix shell script 17/10/02

Re: How to zip a file on From Unix shell script

ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Re: How to zip a file on From Unix shell

Re: How to zip a file on From Unix shell script

You can use compress or gzip to compress a file. compress -v [filename] should compress the file and tell you the percentage as well. Gzip is a GNU utility that may be on your system. These utilities may not be in your current path. RWB WLSH <[EMAIL PROTECTED]>@fatcity.com on 10/16/2002 0

Re: How to zip a file on From Unix shell script

On Wed, Oct 16, 2002 at 02:43:33PM -0800, WLSH wrote: > > Hello, list: > > We have a unix nightly job which will send an email to a user. However, the file >size is very large, so we need to zip the file before we send it out. Does anyone >know the syntax or command of zipping a file from UNIX

How to zip a file on From Unix shell script

Hello list: We had a Unix job ran nightly and will send email to a user. But the file size is very large. So we need to zip the file when we send email to user from UNIX.   Does any one know the syntax or command of doing this (zip file) ? Regards, [EMAIL PROTECTED]  Do you Yahoo!? Faith Hill - Ex

How to zip a file on From Unix shell script

Hello, list: We have a unix nightly job which will send an email to a user. However, the file size is very large, so we need to zip the file before we send it out. Does anyone know the syntax or command of zipping a file from UNIX ?  Regards, [EMAIL PROTECTED]Do you Yahoo!? Faith Hill - Exclusive P

Re: Unix script to stop pwd-protected listener

un lsnrctl, issue "set password" command, put in the >password, issue "stop", issue "exit". > > I need to implement this stop in a Shell script so that I can call the script at the >server reboot time. Do you know how to supply a password to lsnrctl set p

Unix script to stop pwd-protected listener

lsnrctl, issue "set password" command, put in the password, issue "stop", issue "exit". I need to implement this stop in a Shell script so that I can call the script at the server reboot time. Do you know how to supply a password to lsnrctl set password command in a s

Re: Unix script to stop password-protected listener

In a shell script you can then use encrypted password found >in listener.ora on line PASSWORDS_. > >lsnrctl <set password C6C144CF750E3CA5 >stop >exit >EOF > >If the password is not in the listener.ora file, run lsnrctl, set >password manualy and execute SAVE_

Re: Unix script to stop password-protected listener

Yes, you can change your listener.ora file permission up to 600 on the server side. In a shell script you can then use encrypted password found in listener.ora on line PASSWORDS_. lsnrctl < > Hi , >We can very well protect the Server side executables by changing the > permi

RE: Unix script to stop password-protected listener

o the following interactively: run lsnrctl, issue "set password" command, put in the password, issue "stop", issue "exit". I need to implement this stop in a Shell script so that I can call the script at the server reboot time. Do you know how to supply a password t

Unix script to stop password-protected listener

, issue "set password" command, put in the password, issue "stop", issue "exit". I need to implement this stop in a Shell script so that I can call the script at the server reboot time. Do you know how to supply a password to lsnrctl set password command in a s

Unix shell script to stop a password-protected listener

, issue "set password" command, put in the password, issue "stop", issue "exit". I need to implement this stop in a Shell script so that I can call the script at the server reboot time. Do you know how to supply a password to lsnrctl set password command in a s

RE: svrmgrl echo v$database in script

> echo $ORACLE_SID >> logfile > > Scott Shafer > San Antonio, TX > 210.581.6217 > > > > -Original Message- > > From: Baker, Barbara [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, October 02, 2002 6:28 PM > > To: Multiple recipients of list ORACLE-L

RE: RE: svrmgrl echo v$database in script

Dan, I've had a similar problem with glogin.sql and login.sql in the past. Rather than gut my login scripts, I just edited or removed the SQLPATH environment variable. And set a variable in the korn script to point to the location of the SQL files. This variable is then used to locat

Re:RE: RE: svrmgrl echo v$database in script

ick, That is one method. My rule is that all destructive actions are run from scripts that require the database name as a parameter. If the $ORACLE_SID and parameter don't match, the script terminates. I realize this is redundant, but better safe than having to perform a production recove

RE: RE: svrmgrl echo v$database in script

Dick, That is one method. My rule is that all destructive actions are run from scripts that require the database name as a parameter. If the $ORACLE_SID and parameter don't match, the script terminates. I realize this is redundant, but better safe than having to perform a produ

RE: svrmgrl echo v$database in script

October 03, 2002 12:44 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: svrmgrl echo v$database in script > > If fyou want to do it from within a script, you either need to code the > select into a .sql file that you run OR you need to "escape" the $ with

Re:RE: svrmgrl echo v$database in script

Dan, You can use a anonymous PL/SQL block like the following in you login.sql or script file is necessary, it keeps those errors from happening: whenever sqlerror exit declare db varchar2(30); begin select global_name into db from global_name; if(db not like 'DEV%&#

RE: svrmgrl echo v$database in script

SIDs to perform ops on multiple db's if needed, i.e., "sqlplus user@current_sid ... exit echo $current_sid >> logfile" in your script. Scott Shafer San Antonio, TX 210.581.6217 > -Original Message- > From: Fink, Dan [SMTP:[EMAIL PROTECTED]] > Sent: Thurs

Re: svrmgrl echo v$database in script

ker, Barbara [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, October 02, 2002 6:28 PM > > To: Multiple recipients of list ORACLE-L > > Subject: svrmgrl echo v$database in script > > > > > > Oracle 8.0.5 > > Solaris 2.6 > > > > List: > > I'v

RE: svrmgrl echo v$database in script

s of list ORACLE-L > Subject: svrmgrl echo v$database in script > > > Oracle 8.0.5 > Solaris 2.6 > > List: > I've created a script (ksh) called from elsewhere that shuts down the > database. I REALLY want to echo the name of the database into my log file > befo

RE: svrmgrl echo v$database in script

What happens if the ORACLE_SID is set to one value and the caller uses SQL*Net to access a different database? While this is not usually the case in scripts, it could be a problem if the script is parted of a called function. ORACLE_SID=DEV sqlplus scott/tiger@PROD <-- I'm not connecte

RE: svrmgrl echo v$database in script

Use \ to escape the $ sign. select name from v_\$database; - Kirti > -Original Message- > From: Baker, Barbara [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, October 02, 2002 6:28 PM > To: Multiple recipients of list ORACLE-L > Subject: svrmgrl echo v$dat

RE: svrmgrl echo v$database in script

hafer San Antonio, TX 210.581.6217 > -Original Message- > From: Baker, Barbara [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, October 02, 2002 6:28 PM > To: Multiple recipients of list ORACLE-L > Subject: svrmgrl echo v$database in script > > > Oracle 8.0.5 > Sol

RE: svrmgrl echo v$database in script

If fyou want to do it from within a script, you either need to code the select into a .sql file that you run OR you need to "escape" the $ with a \ in your ksh script --- [EMAIL PROTECTED] wrote: > echo $ORACLE_SID >> logfile > > Scott Shafer > Sa

RE: svrmgrl echo v$database in script

echo $ORACLE_SID >> logfile Scott Shafer San Antonio, TX 210.581.6217 > -Original Message- > From: Baker, Barbara [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, October 02, 2002 6:28 PM > To: Multiple recipients of list ORACLE-L > Subject: svrmgrl echo

RE: svrmgrl echo v$database in script

Title: RE: svrmgrl echo v$database in script The shell thinks that "$database" is an environment variable. Try instead "select name from v\$database" > -Original Message- > From: Baker, Barbara [mailto:[EMAIL PROTECTED]] > > Oracle 8.0.5 > Sola

RE: svrmgrl echo v$database in script

Hi Barbara! Try using a "\" before the "$". So your script should read: echo "Stop oracle instance \"${ORACLE_SID}\" at `date` " ${ORACLE_HOME}/bin/svrmgrl << EOF connect internal

Re: svrmgrl echo v$database in script

PROTECTED] 10/02/02 04:28 PMcc: Please respond toSubject: svrmgrl echo v$database in script

svrmgrl echo v$database in script

Oracle 8.0.5 Solaris 2.6 List: I've created a script (ksh) called from elsewhere that shuts down the database. I REALLY want to echo the name of the database into my log file before I shut down.While "select name from v$database" works fine from svrmgrl interactively, it t

<    1   2   3   4   5   6   7   8   9   10   >