AW: UNIX : script help/input

2003-10-02 Thread Stefan Jahnke
Betreff: RE: UNIX : script help/input Good! The more the merrier! Welcome to the club. Oh most definitely. As I just finished writing a prototype package for assigning MAC addresses ( we make network stuff - that's a technical term ), I have endured the agonies of doing hex math in PL/SQL. I

RE: UNIX : script help/input

2003-10-02 Thread Jamadagni, Rajendra
Title: RE: UNIX : script help/input XOR that gives me some painful memories in recent days ... xor is possible in pl/sql but needs a little work. I migrated a C encryption code to pl/sql and then use utl_tcp to sent it to our router which feeds the modem banks. This is how I worked

RE: UNIX : script help/input

2003-10-02 Thread Norris, Gregory T [ITS]
Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all

Re: UNIX : script help/input

2003-10-02 Thread Don Yu
Johan: Please see the attachment file, which is my script for everyday web server log file and uses nslookup to process the results. Hope that it is helpful. Don Johan Muller wrote: Anybody with a quick and dirty (elegant would be nice too), to munge output from a nslookup output file to a

Re: AW: UNIX : script help/input

2003-10-02 Thread Jared . Still
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:AW: UNIX : script help/input Hi Speaking of Perl, ... maybe somebody (Jared) can help out with some Perl / Windows problems: I'm using ActiveState 5.6 with DBI module, which works fine. Now, since I

RE: UNIX : script help/input

2003-10-02 Thread Jared . Still
] Sent by: [EMAIL PROTECTED] 10/02/2003 05:54 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: UNIX : script help/input XOR that gives me some painful memories in recent days ... xor is possible in pl/sql

RE: UNIX : script help/input

2003-10-02 Thread Jamadagni, Rajendra
, October 02, 2003 2:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: UNIX : script help/inputRaj, I did consider doing it this way, but the thought of writing stuff to the bit level for a prototype was just too painful. Left pad with zeroes, take a substring, feed

Re: UNIX : script help/input

2003-10-02 Thread Vladimir Begun
[EMAIL PROTECTED] wrote: Left pad with zeroes, take a substring, feed it to the handy-dandy hex/oct/bin/dec converter package - much easier. Jared, what Oracle edition do you use? I'm asking because you might want to consider not to use 'handy-dandy' hex/oct/bin/dec converter package, but

Re: UNIX : script help/input

2003-10-02 Thread Vladimir Begun
Jamadagni, Rajendra wrote: unfortunately we _had_ to do it in pl/sql ... it is part of the encrypted feed that we send out to our clients ... it is decoded by a chip. Oh well I am back to array of references ... I'd suggest to consider external C function -- it's faster, it's easier to

RE: UNIX : script help/input

2003-10-02 Thread Jamadagni, Rajendra
Title: RE: UNIX : script help/input it was actually C code ... but because data is going on a modem, the pl/sql speed is acceptable (in fact we have to _wait_ after sending out each message). Had fun doing that though ... it is critical, tied to our SLA ... so must be up all the time. I'd

Re: UNIX : script help/input

2003-10-02 Thread Jared . Still
-L [EMAIL PROTECTED] cc: Subject:Re: UNIX : script help/input [EMAIL PROTECTED] wrote: Left pad with zeroes, take a substring, feed it to the handy-dandy hex/oct/bin/dec converter package - much easier. Jared, what Oracle edition do you use? I'm asking because you might want

Re: UNIX : script help/input

2003-10-02 Thread Jared . Still
recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: UNIX : script help/input Jamadagni, Rajendra wrote: unfortunately we _had_ to do it in pl/sql ... it is part of the encrypted feed that we send out to our clients ... it is decoded by a chip. Oh well I am back

UNIX : script help/input

2003-10-01 Thread Johan Muller
Anybody with a quick and dirty (elegant would be nice too), to munge output from a nslookup output file to a delimited file? 'File content: Server: dns1.mci.comAddress: 199.249.19.1 Name: WCOM-4NXZGAPWY5.mcilink.comAddress: 166.50.73.209 Delimited file should have the following line(s); (using |

RE: UNIX : script help/input

2003-10-01 Thread Stephane Faroult
Anybody with a quick and dirty (elegant would be nice too), to munge output from a nslookup output file to a delimited file? 'File content: Server: dns1.mci.com Address: 199.249.19.1 Name:WCOM-4NXZGAPWY5.mcilink.com Address: 166.50.73.209 Delimited file should have the following

Re: UNIX : script help/input

2003-10-01 Thread Joe Testa
I supposed if you send to a file, we can read it using ORACLE to parse it w/plsql and then using utl_file write it back out but seems like overkill to use oracle for that, but then again this is an oracle list, so i'll have to assume thats what you wanted, anyone up for the task :) joe Johan

Re: UNIX : script help/input

2003-10-01 Thread Mladen Gogala
#!/usr/bin/perl -w use strict; use bytes; my ($NAME,$IP,@LB); while () { chomp; @LB=split /\s+/; if ($LB[0] =~ /^name:/i) { $NAME=$LB[1]; } if ($LB[0] =~ /^address:/i) { $IP=$LB[1]; write; } } format STDOUT= @ ,@ $NAME,$IP

Re: UNIX : script help/input

2003-10-01 Thread Johan Muller
Mladen, It worked! Heartfelt thank you from the evangelized perl crowd (now watch the list-owner grin).Mladen Gogala [EMAIL PROTECTED] wrote: #!/usr/bin/perl -wuse strict;use bytes;my ($NAME,$IP,@LB);while () {chomp;@LB=split /\s+/;if ($LB[0] =~ /^name:/i) {$NAME=$LB[1];}if ($LB[0] =~

Re: UNIX : script help/input

2003-10-01 Thread Mladen Gogala
On Wed, 2003-10-01 at 13:24, Johan Muller wrote: Mladen, It worked! Did you have any doubts? That's precisely what perl is good for. Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No

Re: UNIX : script help/input

2003-10-01 Thread Tanel Poder
Thank God for Perl and Mladen ;) Tanel. - Original Message - From: Johan Muller To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 01, 2003 8:24 PM Subject: Re: UNIX : script help/input Mladen, It worked! Heartfelt thank you

RE: UNIX : script help/input

2003-10-01 Thread Jamadagni, Rajendra
-LSubject: Re: UNIX : script help/input Thank God for Perl and Mladen ;) Tanel. - Original Message - From: Johan Muller To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 01, 2003 8:24 PM Subject: Re: UNIX : script help

Re: UNIX : script help/input

2003-10-01 Thread Jared Still
:) On Wed, 2003-10-01 at 10:24, Johan Muller wrote: Mladen, It worked! Heartfelt thank you from the evangelized perl crowd (now watch the list-owner grin). Mladen Gogala [EMAIL PROTECTED] wrote: #!/usr/bin/perl -w use strict; use bytes; my ($NAME,$IP,@LB); while () { chomp;

Re: UNIX : script help/input

2003-10-01 Thread Govindan K
Thank God for Jared -Original Message- From: Tanel PoderSent: 10/1/2003 10:37:55 AMTo: [EMAIL PROTECTED]Subject: Re: UNIX : script help/input Thank God for Perl and Mladen ;) Tanel. - Original Message - From: Johan Muller To: Multiple recipients of list ORACLE-L

RE: UNIX : script help/input

2003-10-01 Thread Mladen Gogala
On Wed, 2003-10-01 at 14:34, Jamadagni, Rajendra wrote: Funny .. I am currently sitting in a Perl class, so I can actually read what MG has written. I'll be soon Perl-literate ... Raj Good! The more the merrier! Welcome to the club. Note: This message is for the named person's use only.

Re: UNIX : script help/input

2003-10-01 Thread Jared Still
- From: Johan Muller mailto:[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 8:24 PM Subject: Re: UNIX : script help/input Mladen, It worked! Heartfelt thank you

RE: UNIX : script help/input

2003-10-01 Thread Jared Still
Good! The more the merrier! Welcome to the club. Oh most definitely. As I just finished writing a prototype package for assigning MAC addresses ( we make network stuff - that's a technical term ), I have endured the agonies of doing hex math in PL/SQL. I finally bit the bullet and used string

Re: UNIX : script help/input

2003-10-01 Thread Vladimir Begun
Jared Jared Still wrote: Good! The more the merrier! Welcome to the club. Oh most definitely. As I just finished writing a prototype package for assigning MAC addresses ( we make network stuff - that's a technical term ), I have endured the agonies of doing hex math in PL/SQL. I finally bit the

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

2003-02-04 Thread Stephen Lee
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 something like this be adaptable to your stuff? #!/usr/bin/ksh { sqlplus -s -XXX joe/blow@SID set

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

2003-02-04 Thread gmei
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 something like this be adaptable to your stuff? #!/usr/bin/ksh { sqlplus -s -XXX joe/blow

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

2003-02-04 Thread Suzy Vordos
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 and that off set the other thing and trimspool on set whatever else

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

2003-02-03 Thread Reginald . W . Bailey
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 have a

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

2003-02-03 Thread Guang Mei
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 123578$ Maybe there

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

2003-02-03 Thread Stephen Lee
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: Stephen Lee

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

2003-02-03 Thread tim
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 unix.

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

2003-02-03 Thread Ron Thomas
: Subject: OT: unix script quetion: to replace

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

2003-02-03 Thread Jared . Still
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: Subject:OT: unix script quetion: to replace

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

2003-02-03 Thread Guang Mei
/\$/\\\$/g' 123\$45\$678 ...will work Guang Mei [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] m cc: Sent by: Subject: OT: unix

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

2003-02-03 Thread Brian_P_MacLean
: OT: unix script quetion: to replace $ with \$ [EMAIL PROTECTED

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

2003-02-03 Thread Jared . Still
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 this: I am trying to run table analyze in multiple treads (I

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

2003-02-03 Thread Stephen Lee
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 \$

2003-02-03 Thread Guang Mei
Please respond to 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

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

2003-02-03 Thread gmei
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 and that off set the other thing and trimspool on set whatever else

Re: Unix script to stop pwd-protected listener

2002-10-11 Thread Michal Zaschke
Hi, we have lsnrctl with 750 and listener.ora with 600 permissions and everything runs fine. For job stopping process you can then use the encrypted password wirtten in listener.ora. HTH, Mike [EMAIL PROTECTED] wrote: Hi, Solaris 8, Oracle 9i listener It seems that anyone who

Unix script to stop pwd-protected listener

2002-10-10 Thread Long . Nguyen
Hi, Solaris 8, Oracle 9i listener It seems that anyone who has a login on Solaris can shut the listener down. I have tried with a non-dba userid and could stop the listener. The default file permission for ORACLE_HOME/bin/lsnrctl is 751, and for ORACLE_HOME/network/admin/listener.ora file

Re: Unix script to stop password-protected listener

2002-10-09 Thread Gilles PARC
Hi Michal, It's a security breach and bug #2366907 has been opened for that. So protect carefully your listener.ora file from non privileged readers. Regards At 01:53 08/10/2002 -0800, you wrote: Yes, you can change your listener.ora file permission up to 600 on the server side. In a shell

Re: Unix script to stop password-protected listener

2002-10-08 Thread Michal Zaschke
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_listener. lsnrctl EOF set password C6C144CF750E3CA5 stop exit EOF If the password is not in the listener.ora file,

Unix script to stop password-protected listener

2002-10-07 Thread Long . Nguyen
Hi, Solaris 8, Oracle 9i listener It seems that anyone who has a login on Solaris can shut the listener down. I have tried with a non-dba userid and could stop the listener. The default file permission for ORACLE_HOME/bin/lsnrctl is 751, and for ORACLE_HOME/network/admin/listener.ora file is

RE: Unix script to stop password-protected listener

2002-10-07 Thread Choudhary Rajendra (TTL_LKO)
Hi , We can very well protect the Server side executables by changing the permission of the file . We had implemented this on all our database sites and normal user don't have access to lsnrctl,svrmgrl,namesctl etc .You can also protect the listener.ora file by changing

RE: Unix Script Quest : Urgent

2002-08-10 Thread Brian_P_MacLean
by: cc: [EMAIL PROTECTED] Subject: RE: Unix Script Quest : Urgent

Unix Script Quest : Urgent

2002-08-09 Thread johanna . doran
Is there a way to captureall files hit by a process/user in unix (Sun Solaris 9, ksh)? I am seeing an OCI file not found on my production box. I can't resovle it. So, I want to run the same process on my development box (where it works) and get a list of files that it is hitting (I can

Re: Unix Script Quest : Urgent

2002-08-09 Thread Steven Lembark
Is there a way to capture all files hit by a process/user in unix (Sun Solaris 9, ksh)? I am seeing an OCI file not found on my production box. I can't resovle it. So, I want to run the same process on my development box (where it works) and get a list of files that it is hitting (I can

Re: Unix Script Quest : Urgent

2002-08-09 Thread Peter Barnett
ldd filename should give you the dependencies. --- [EMAIL PROTECTED] wrote: Is there a way to capture all files hit by a process/user in unix (Sun Solaris 9, ksh)? I am seeing an OCI file not found on my production box. I can't resovle it. So, I want to run the same process on my

RE: Unix Script Quest : Urgent

2002-08-09 Thread Seefelt, Beth
I think that will give you files that it successfully accessed, but not the ones that were referenced but not found. You can do what you're asking on VMS and NT, so it seems like there should be a way in Unix, although I asked my Unix SA's that same question a few years back and they said that

RE: Unix Script Quest : Urgent

2002-08-09 Thread johanna . doran
:48 AM To: Multiple recipients of list ORACLE-L Subject: Re: Unix Script Quest : Urgent ldd filename should give you the dependencies. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Unix Script Quest : Urgent

2002-08-09 Thread chris . w . johnson
Hannah, I'm no Unix guru either but in this situation I use 'truss', e.g. truss procname HTH Chris -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: 09 August 2002 16:08To: Multiple recipients of list ORACLE-LSubject: Unix Script Quest : Urgent

Re: Unix Script Quest : Urgent

2002-08-09 Thread Charlie Mengler
Never say never. The output from truss shows all system calls; which includes file opens. Here is an interesting exercise for those on *nix boxes. From one window/session do the following ... $ sqlplus From a different window where you are logged onto the system as root find the pid (process

RE: Unix Script --- Archive Log Destination Issue

2002-05-14 Thread Brian_P_MacLean
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] estbuy.com cc: Sent by:Subject: RE: Unix Script

Unix Script --- Archive Log Destination Issue

2002-05-13 Thread Reddy, Madhusudana
Hello All, I have a script, which cleans up the archive log destination by moving the old archive logs to a retention area based on the thresholds 1. Percent of space utilization 2. greater than 2 days old. The script was working fine , except for the reason , sometimes we see multiple copies

RE: Unix Script --- Archive Log Destination Issue

2002-05-13 Thread Reddy, Madhusudana
My mistake , this new script is only working sometimes. Which is scheduled every hour , but not working at all the hour changes . -Original Message- Sent: Monday, May 13, 2002 11:28 AM To: Multiple recipients of list ORACLE-L Hello All, I have a script, which cleans up the archive log

Does any one know how to call LDAP from UNIX script ?

2002-05-02 Thread Steven Joshua
Hello: Hope the subject make sense. I'm new to LDAP, and don't know how it works. I need to use SQL Loader to load a text file into Oracle817 Database from a unix box. The file/data comes from LDAP server. My question is: how do I get the file/object from LDAP site from my unix script? Does

Does any one know how to call LDAP from UNIX script ?

2002-05-02 Thread Steven Joshua
Hello: Hope the subject make sense. I'm new to LDAP, and don't know how it works. I need to use SQL Loader to load a text file into Oracle817 Database from a unix box. The file/data comes from LDAP server. My question is: how do I get the file/object from LDAP site from my unix script? Does

Re: Does any one know how to call LDAP from UNIX script ?

2002-05-02 Thread Charlie Mengler
Database from a unix box. The file/data comes from LDAP server. My question is: how do I get the file/object from LDAP site from my unix script? Does anyone has any examples? or know a helpful URL? Thanks From Steven __ Do You Yahoo

Re: Does any one know how to call LDAP from UNIX script ?

2002-05-02 Thread Joe Raube
, and don't know how it works. I need to use SQL Loader to load a text file into Oracle817 Database from a unix box. The file/data comes from LDAP server. My question is: how do I get the file/object from LDAP site from my unix script? Does anyone has any examples? or know a helpful URL

RE: Does any one know how to call LDAP from UNIX script ?

2002-05-02 Thread Jesse, Rich
] Quad/Tech International, Sussex, WI USA -Original Message- From: Charlie Mengler [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 02, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Subject: Re: Does any one know how to call LDAP from UNIX script ? I hope you can read UGLY

Re: Does any one know how to call LDAP from UNIX script ?

2002-05-02 Thread Steven Joshua
. My question is: how do I get the file/object from LDAP site from my unix script? Does anyone has any examples? or know a helpful URL? Thanks From Steven __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness

Re: Does any one know how to call LDAP from UNIX script ?

2002-05-02 Thread Suzy Vordos
the subject make sense. I'm new to LDAP, and don't know how it works. I need to use SQL Loader to load a text file into Oracle817 Database from a unix box. The file/data comes from LDAP server. My question is: how do I get the file/object from LDAP site from my unix script? Does

RE: Does any one know how to call LDAP from UNIX script ?

2002-05-02 Thread Koivu, Lisa
33063 -Original Message- From: Steven Joshua [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 02, 2002 6:17 PM To: Multiple recipients of list ORACLE-L Subject: Re: Does any one know how to call LDAP from UNIX script ? Thanks for the code. But can we do this in UNIX shell

Re: Does any one know how to call LDAP from UNIX script ?

2002-05-02 Thread Suzy Vordos
from my unix script? Does anyone has any examples? or know a helpful URL? Thanks From Steven __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please

RE: Does any one know how to call LDAP from UNIX script ?

2002-05-02 Thread Steven Joshua
To: Multiple recipients of list ORACLE-L Subject:Re: Does any one know how to call LDAP from UNIX script ? Thanks for the code. But can we do this in UNIX shell script or Java? Thanks again Steven --- Charlie Mengler [EMAIL PROTECTED] wrote: I hope you can read UGLY

Re: Unix script

2002-04-16 Thread Brian_P_MacLean
] Sent by: cc: [EMAIL PROTECTED] Subject: Unix script om

Re: Unix script

2002-04-16 Thread Brian_P_MacLean
] 04/16/02 09:06 Subject: Re: Unix script(Document link: Brian P MacLean) AM

Unix script

2002-04-15 Thread Roland . Skoldblom
Hallo, I have this unix script, please tell me how to change it so it also does the following: (See attached file: laddabilbo.sh) counts the time between start time and end time of the process(I mean time difference between Jobb startat(Job started) and Job Klart(Job Finished). IThis log

Help in unix script

2002-03-28 Thread Mandal, Ashoke
Greetings all, I need to do the following unix top -b -U norad PID USERNAME THR PRI NICE SIZE RES STATE TIMECPU COMMAND 12733 norad 1 602 3936K 3392K run 0:05 7.21% dbganlz 12747 norad 4 522 13M 10M sleep 0:05 4.20% dbgora 12721 norad 1 53

Re: Help in unix script

2002-03-28 Thread Brian_P_MacLean
] cc: [EMAIL PROTECTED] 03/28/02 11:05 Subject: Re: Help in unix script(Document link: Brian P MacLean) AM

RE: Help in unix script

2002-03-28 Thread Mark Leith
Hi Ashoke, I see that you are using NORAD (I am the resident NORAD sales critter ;P). Can't help you much on the script help, but one thing I can say: Have you looked at the IAS agent of NORAD (the system monitoring agent)? This will be able to do all that you want.. Under the standard rules

Re: Help in unix script

2002-03-28 Thread Brian_P_MacLean
] ronic.com cc: Sent by:Subject: Help in unix script [EMAIL PROTECTED

RE: OT : Unix script to monitor log file size/disk space

2002-03-21 Thread Radim J.
Hi, What version of unix do you use ? I use this script on HP. If you want I can send it to you. Radim -Original Message- Ling Catherine (CSC) Sent: Wednesday, March 13, 2002 6:08 AM To: Multiple recipients of list ORACLE-L Hi Gurus, Does anyone have the unix script to monitor disk

RE: OT : Unix script to monitor log file size/disk space

2002-03-21 Thread CHAN Chor Ling Catherine (CSC)
J. [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 5:13 AM To: Multiple recipients of list ORACLE-L Subject:RE: OT : Unix script to monitor log file size/disk space Hi, What version of unix do you

OT : Unix script to monitor log file size/disk space

2002-03-12 Thread CHAN Chor Ling Catherine (CSC)
Hi Gurus, Does anyone have the unix script to monitor disk space or a certain file ? For example, if the disk space is more than 80%, send an email to the administrator or if the log file is too huge, email the log file to the administrator and truncate the file etc . Please help. Thanks

OT - Unix Script to get file name and size from remote server

2002-03-01 Thread Nancy McCormick
This may be a little off topic so I apologize in advance. But I have seen some good Unix scripting help come across lately so I thought I would go ahead and send this. I am trying to setup a Unix script that will logon to a remote server, get the name and size of all the files in a remote

Re: OT - Unix Script to get file name and size from remote server

2002-03-01 Thread Jack van Zanen
this. I am trying to setup a Unix script that will logon to a remote server, get the name and size of all the files in a remote directory and write the results to a local directory. I need to do this to ensure that all the source files for loading our data warehouse have been received

RE: OT - Unix Script to get file name and size from remote server

2002-03-01 Thread marmstrong
Message- Sent: Friday, March 01, 2002 10:09 AM To: Multiple recipients of list ORACLE-L This may be a little off topic so I apologize in advance. But I have seen some good Unix scripting help come across lately so I thought I would go ahead and send this. I am trying to setup a Unix script

RE: OT - Unix Script to get file name and size from remote server

2002-03-01 Thread Nancy McCormick
be a little off topic so I apologize in advance. But I have seen some good Unix scripting help come across lately so I thought I would go ahead and send this. I am trying to setup a Unix script that will logon to a remote server, get the name and size of all the files in a remote directory and write

UNIX SCRIPT

2002-02-15 Thread Hamid Alavi
HI LIST, I AM LOOKING FOR A SCRIPT TO MAKE A COLD BACKUP FOR ORACLE 8.1.6 ON SunOS 5.7. I want to schedule this script to shutdown the database at mid night and make a backup then start it up at 5:00 AM. Any URL or link or any document it will be very helpful. Hamid Alavi Office 818 737-0526

RE: UNIX SCRIPT

2002-02-15 Thread Kevin Lange
Thats a rather open question. What are you doing your backup to ? Simply to another disk drive or are you putting the files out to a tape? If you are using a tape, are you using some kind of tape management software or simply copying the files to the tape ? Are you copying it all to a backup

Re: UNIX SCRIPT

2002-02-15 Thread Jared . Still
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:UNIX SCRIPT HI LIST, I AM LOOKING FOR A SCRIPT TO MAKE A COLD BACKUP FOR ORACLE 8.1.6 ON SunOS 5.7. I want to schedule this script to shutdown the database at mid night and make a backup

RE: UNIX SCRIPT

2002-02-15 Thread Bellows, Bambi
Here's basically what you need to do: 1) Write a script which determines which files to backup (hit the DBA and V$ tables) 2) Shutdown the database 3) Once you have those files, use them as a driver in a for|while loop (for each file, A) Check if it's raw or UFS if [ raw ] then

RE: Unix script

2002-01-28 Thread Thomas, Kevin
Do some research man!! This stuff isn't hard to find...sheesh!! -Original Message- Sent: 28 January 2002 14:31 To: Multiple recipients of list ORACLE-L Hallo, I have this unix script. I would like to include code which checks if the oracle database is up and running so the procedure

RE: Unix script

2002-01-28 Thread Hallas John
Title: RE: Unix script Basis of a script added into yours below. Note I am only checking to see if there is a PMON proces up - maybe best to make a sqlplus connection and read v$instance or something and exit if it fails. Really very poor but will give you something to work on. What I

Unix script

2002-01-27 Thread Roland . Skoldblom
Hallo, I have this unix script. I would like to get a errorlog if the pl/sql procedure konto.fillbotables.anrop doesnt start at all. Please tell me how to write the code and where to include it in this shell script. #!/bin/sh . /usr/bin/orasetup.sh . /d31/appl/konto/bat/movefiles.sh sqlldr

Ang: RE: Unix script

2002-01-27 Thread Roland . Skoldblom
this unix script. I would like to get a errorlog if the pl/sql procedure konto.fillbotables.anrop doesnt start at all. Please tell me how to write the code and where to include it in this shell script. #!/bin/sh . /usr/bin/orasetup.sh . /d31/appl/konto/bat/movefiles.sh sqlldr userid=konto/icakort

Re: Unix - script

2002-01-11 Thread Sundar
Ltd.(2nd Floor East - Weirs Building)Tel: 0141 568 2377Fax: 0141 568 2366http://www.calanais.com-Original Message-Sent: 09 January 2002 07:16To: Multiple recipients of list ORACLE-LHallo,I would like to have an example of a unix script, which does the following:copy some files from directory

RE: Unix - script

2002-01-11 Thread Veronica Levin
Asunto: RE: Unix - script I would suggest using wget, which is built exactly for this purpose. -Original Message- Sent: Wednesday, January 09, 2002 3:20 AM To: Multiple recipients of list ORACLE-L Roland, Try this by setting up environment variables at the top of your script: SERVER1

RE: Unix - script

2002-01-11 Thread Jared . Still
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ia.com.ni cc: Sent by: Subject: RE: Unix - script

Ang: RE: Unix - script

2002-01-10 Thread Roland . Skoldblom
Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 09 January 2002 07:16 To: Multiple recipients of list ORACLE-L Hallo, I would like to have an example of a unix script, which does the following

Re: Unix - script

2002-01-09 Thread C.S.Venkata Subramanian
Use unix utility ftp to copy file between 2 mc's or use rcopy. For more details refer to man pages. -- On Tue, 08 Jan 2002 23:15:35 Roland.Skoldblom wrote: Hallo, I would like to have an example of a unix script, which does the following: copy some files from directory /prod/sas/data

RE: Unix - script

2002-01-09 Thread Thomas, Kevin
Hallo, I would like to have an example of a unix script, which does the following: copy some files from directory /prod/sas/data located at hardy.(which is a computer) to the other database hakon. Is it possible to do this. Please help me quick. Thanks in advance Roland S -- Please see

RE: Unix - script

2002-01-09 Thread Thomas, Kevin
Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 09 January 2002 07:16 To: Multiple recipients of list ORACLE-L Hallo, I would like to have an example of a unix script, which

RE: Unix - script

2002-01-09 Thread Mike Killough
It could be faster to remote copy: rcp -p /archive/orcl/arch_1_2290.arc oracle@server2:/archive/orcl/arch_1_2290.arc Mike From: Thomas, Kevin [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Unix - script Date: Wed, 09 Jan

RE: Unix - script

2002-01-09 Thread Thomas, Kevin
] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Unix - script Date: Wed, 09 Jan 2002 00:35:23 -0800 Forgot to mention, the 'cd scripts' line in both examples is not required, it's just been left in from the script I copied. oops! K

RE: Unix - script

2002-01-09 Thread Scott . Shafer
PROTECTED]] Sent: Wednesday, January 09, 2002 1:16 AM To: Multiple recipients of list ORACLE-L Subject: Unix - script Hallo, I would like to have an example of a unix script, which does the following: copy some files from directory /prod/sas/data located at hardy.(which

  1   2   >