RE: Unix question

2003-12-23 Thread Bellow, Bambi
grep -v try will give you all the lines which do not contain "try" cat |sed "s/try//g" > newfile will strip the characters "try" from all lines HTH, Bambi. -Original Message- Sent: Monday, December 22, 2003 6:54 AM To: Multiple recipients of list ORACLE-L Hallo all of you, Is ther

RE: Unix question

2003-12-22 Thread Jayaram Keshava Murthy (Cognizant)
for multiple patterns...    Hope this will help.    Regards  kesh -Original Message-From: Gene Sais [mailto:[EMAIL PROTECTED]Sent: Monday, December 22, 2003 6:39 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Unix question grep command will help you or you could

Re: Unix question

2003-12-22 Thread Gene Sais
grep command will help you or you could venture to the sed command.  grep is probably the most used unix command.  To learn more, man grep .  >>> [EMAIL PROTECTED] 12/22/03 07:54AM >>>Hallo all of you,Is there anyone whom could help me with the unix command how to find all rows , that doesnt

Re: Unix scripts on Windows 2000 after installing MKS tool kit

2003-12-03 Thread M Rafiq
Carel, Thank you very much for your response and advise. I have started testing with little problem so far... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Wed, 03 Dec 2003 00:59:26 -0800 > Hi > > Has anybody experience with using

Re: Unix scripts on Windows 2000 after installing MKS tool kit

2003-12-03 Thread Carel-Jan Engel
> Hi > > Has anybody experience with using unix scripts on Windows 2000 after > installing MKS toolkit? > Are those scripts run without major modification (after changing > path/folder > related info). > > My client wants to run their unix shell scripts on their Windows platform > after installing

RE: UNIX OT: exclude files in tar

2003-11-26 Thread Stephen.Lee
Expanding the logic to its logical conclusion, we produce philosophies similar to that found at www.despair.com. CONSULTING: If you aren't part of the solution, then there is good money to be made in prolonging the problem. > -Original Message- > > I like that logic! I might just start

RE: UNIX OT: exclude files in tar

2003-11-25 Thread Ross Collado
> Sent: Wednesday, 26 November 2003 6:25 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: UNIX OT: exclude files in tar > > > > On 11/25/2003 11:44:26 AM, [EMAIL PROTECTED] wrote: > > > > Maybe can use -prune option of find to send file list to tar

Re: UNIX OT: exclude files in tar

2003-11-25 Thread Mladen Gogala
On 11/25/2003 11:44:26 AM, [EMAIL PROTECTED] wrote: > > Maybe can use -prune option of find to send file list to tar: > Why do it in a simple way when there is an opportunity to (ab)use perl? Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain con

Re: UNIX OT: exclude files in tar

2003-11-25 Thread Mladen Gogala
Then I'll pipe it to cpio -H tar, which will solve the problem. On 11/25/2003 01:24:26 PM, Tanel Poder wrote: > This approach might cause problems, if you have really lots of files -> your > shell argument buffer (or whatever is the correct name for it) becomes full > > Tanel. > > - Original

Re: UNIX OT: exclude files in tar

2003-11-25 Thread Tanel Poder
This approach might cause problems, if you have really lots of files -> your shell argument buffer (or whatever is the correct name for it) becomes full Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, November 25, 2003 4:54 PM >

RE: UNIX OT: exclude files in tar

2003-11-25 Thread Robertson Lee - lerobe
You can use the -L option and have a file listing everything you want ie, ls > file edit file and remove the dir you don't want tar files with the -L option and the file you created above. never done this myself -Original Message- [EMAIL PROTECTED] Sent: 25 November 2003 16:44 To: Mul

RE: UNIX OT: exclude files in tar

2003-11-25 Thread Stephen.Lee
Maybe can use -prune option of find to send file list to tar: cd /home find ./user01 -name mark03 -prune -o -print > -Original Message- > > > > I can't seem to get the tar command right. I wanted to tar > a directory but > > EXCLUDE one of the subdirectory in it. > > Example: > > /hom

Re: UNIX OT: exclude files in tar

2003-11-25 Thread Mladen Gogala
tar cvf /tmp/test1.tar `perl -e 'foreach On 11/25/2003 12:24:26 AM, Ross Collado wrote: > Hello, > > On Solaris 8 > > I can't seem to get the tar command right. I wanted to tar a directory but > EXCLUDE one of the subdirectory in it. > Example: > /home/user01 > /home/user01/mark01 > /home/user0

Re: UNIX OT: exclude files in tar

2003-11-25 Thread Mladen Gogala
I never rely on tar to do that. Here is the trick that I use when I want to be selective: tar zcvf /tmp/test1.tgz `perl -e 'foreach (<*.pl>) { if (/connect/) {print "$_\n";}}'` Basically, you write a small perl script which will output only the files you want and hand that to tar. Works each an

Re: UNIX OT: exclude files in tar

2003-11-25 Thread Michael Boligan
It doesn't use the exclude, but it would do what you want: cd /home/user01 tar -cvf /dev/rmt0 mark01 mark02 where /dev/rmt0 is your tape device, or you can substitute a disk destination. HTH, Mike

Re: UNIX OT: exclude files in tar

2003-11-24 Thread Brian_P_MacLean
Just another excuse to read the tar man page. This series of commands seamed to work in testing. Note the "excluded" and "OK" on the tar command output. As the tar man page states, be careful on the leading and trailing spaces in the exclude file. As with most Unix commands, DON'T use a "-" in

Re: unix question

2003-11-20 Thread jo_holvoet
Something our Unix admins tend to do is move the files along different directories. E.g. they start in dir1; after succesfull backup, move them to dir2, etc. and after succesfull backup in dir4 delete them. So they should always get backed up 4 times even if you miss a run. Of course your backup

RE: unix question

2003-11-19 Thread Smith, Ron L.
The following statement will delete all files older than 5 days: find . -name 'files_you_want_to_delete*.log' -mtime +5 -exec rm {} \; To test it, change the name of the file name and change the 'rm' to 'ls'. It should just list the files older than 5 days. That way you know it is working. Ron

RE: unix question

2003-11-19 Thread Bellow, Bambi
USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE. COUNT=`ls -lrt /|wc -l` if [ $COUNT -ge 4 ] ; then find -name -mtime +4 -exec rm -f {} \; fi USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.

Re: unix question

2003-11-19 Thread Quintin, Richard
How about something like dir=foo if [ `ls -1 $dir` -lt 4 ]; then find $dir -mtime +4 | xargs rm fi On Wed, 2003-11-19 at 15:20, [EMAIL PROTECTED] wrote: > I want to store some files. I make a new copy every night. I want to archive it back > 4 days. So after 4 days, I want to delete the old co

RE: unix question

2003-11-19 Thread Jamadagni, Rajendra
How about something like ... find /your_dir_name_here -name '*.log' -mtime +4 -exec \ rm {} \; Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clo

Re: UNIX OT: deleting file starting with --

2003-10-31 Thread Jared Still
Many unix commands recognize the '--' parameter. What this means on the command line is that everything entered after the -- is not a switch, but an argument. 'rm -- --cart' will delete the file. man getopt for details. Jared On Thu, 2003-10-30 at 20:44, Ross Collado wrote: > Hi, > How do I de

Re: UNIX OT: deleting file starting with --

2003-10-30 Thread Vladimir Begun
Ross Collado wrote: Hi, How do I delete a file named --cart ? Thanks, Ross touch -- --card ls -al -- --card rm -- --card ls -al -- --card -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. -- Please see the official

RE: UNIX OT: deleting file starting with --

2003-10-30 Thread Sinardy Xing
rm -i ??cart -Original Message- Sent: 31 October 2003 12:44 To: Multiple recipients of list ORACLE-L Hi, How do I delete a file named --cart ? Thanks, Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ross Collado INET: [EMAIL PROTECTED] Fat City Netw

RE: UNIX OT: deleting file starting with --

2003-10-30 Thread Vergara, Michael (TEM)
We just had one like this. Our UNIX SA said to use the fully-qualified path to the file, as in rm -i /this/is/the/path/to/--cart HTH, Mike -Original Message- Sent: Thursday, October 30, 2003 8:44 PM To: Multiple recipients of list ORACLE-L Hi, How do I delete a file named --cart ?

RE: Unix Help

2003-10-08 Thread Nelson, Allan
Title: Message DEST_DIR=your_desination_directory SOURCE_DIR=your_source_directory   for file in `ls $SOURCE_DIR` do    fn=basename $file    if [ ! -f $DEST_DIR/$fn ]    then   cp $file $DEST_DIR/$fn    fi done   Hope it helps. Allan -Original Message-From: Sujatha Madan [

Re: UNIX : script help/input

2003-10-02 Thread Jared . Still
    To:        Multiple 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

Re: UNIX : script help/input

2003-10-02 Thread Jared . Still
ltiple recipients of list ORACLE-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

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

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 writ

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 TO_CHAR/T

RE: UNIX : script help/input

2003-10-02 Thread Jamadagni, Rajendra
: Thursday, 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 it to the

RE: UNIX : script help/input

2003-10-02 Thread Jared . Still
t; <[EMAIL PROTECTED]> 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 pain

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: 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 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 ho

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 b

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 Jared Still
> Tanel. > > - Original Message - > > From: Johan Muller <mailto:[EMAIL PROTECTED]> > To: Multiple recipients of list ORACLE-L > <mailto:[EMAIL PROTECTED]> > Sent: Wednesday, October 01, 2003 8:24 PM > Subjec

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 on

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

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 (<

RE: UNIX : script help/input

2003-10-01 Thread Jamadagni, Rajendra
RACLE-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

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

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 confidenti

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] =~ /^a

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 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 M

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 fol

Re: Unix- How to remove the first few lines(N) in a file without

2003-09-16 Thread Ron Thomas
Lets not forget about the vernerable ed... # # strip of the header of the input file # ed $data_filename < Sent: Sunday, September 14, 2003 10:49 PM > Mladen ,I want to automate this thing. So don't want > to go with :1,5d stuff > > --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > > The best thin

Re: Unix- How to remove the first few lines(N) in a file without

2003-09-16 Thread Tanel Poder
(reposting) Afaik, vi can run in non-interactive, "batch" mode too. But I'd go with tail +6 Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, September 14, 2003 10:49 PM > Mladen ,I want to automate this thing. So don't want > to

Re: Unix- How to remove the first few lines(N) in a file without

2003-09-14 Thread Ravi Kulkarni
Sami, Try this [dev99105]: cat file1 1 to be removed 2 to be removed 3 to be removed 4 to be removed 5 to be removed a s [dev99105]: tail +6 file1 a s Thanks, Ravi. --- Oracle DBA <[EMAIL

Re: Unix- How to remove the first few lines(N) in a file without

2003-09-14 Thread Oracle DBA
Mladen ,I want to automate this thing. So don't want to go with :1,5d stuff --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > The best thing to do would be something like: > vi filename > :1,5d > :x! > > That would do the trick. > Also this: >

Re: Unix- How to remove the first few lines(N) in a file without

2003-09-14 Thread Mladen Gogala
The best thing to do would be something like: vi filename :1,5d :x! That would do the trick. Also this: * #!/usr/bin/perl -w use strict my $ind=1; open FILE1,"/file1/path"||die "Cannot open file1:$!\n"; open FILE2,">/fil

Re: Unix- How to remove the first few lines(N) in a file without

2003-09-14 Thread Oracle DBA
Hi Tim, Thanks for your response. But it is not deleting the 1st 6 lines. See below $ $ cat x 12 22 32 42 52 62 72 82 92 $ $ sed '6,$p' x 12 22 32 42 52 62 62 72 72 82 82 92 92 $ --- Tim Gorman <[EMAIL PROTECTED]> wrote: > sed '6,$p' filename > new-filename > > on 9/14/03 7:49 AM, Ora

Re: Unix- How to remove the first few lines(N) in a file without

2003-09-14 Thread Tim Gorman
sed '6,$p' filename > new-filename on 9/14/03 7:49 AM, Oracle DBA at [EMAIL PROTECTED] wrote: > Hi List, > > I want to remove the first 5 lines of the text from > unix text file. Is there a command to do it without > opening a file manually? (I don't want to use (DD > command) > > For example,

RE: UNIX and Oracle

2003-08-30 Thread Corniche Park
You may take a look at the book Oracle for Linux DBA's. > "Design and Implementation of the [UNIX || 4.x BSD] Operating System" by > [Bach || McCusic et all] > > Should both have excellent overviews of shared memory, semaphores, and why > they're useful. If you want even more nitty gritty, pick u

RE: UNIX and Oracle

2003-08-29 Thread Cary Millsap
One small correction is that the Berkeley book you're describing is by Leffer and others (Bach wrote the AT&T one). Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Sydney - Hotsos Symposium 2004, March 7-10 Dallas - Visit www.hotsos.com for sch

RE: UNIX and Oracle

2003-08-29 Thread Rich Holland
"Design and Implementation of the [UNIX || 4.x BSD] Operating System" by [Bach || McCusic et all] Should both have excellent overviews of shared memory, semaphores, and why they're useful. If you want even more nitty gritty, pick up a decent book on pthreads programming and you'll also learn abou

Re: Unix process tree

2003-08-11 Thread Tanel Poder
Title: Unix process tree Redhat AS 2.1 at least has something, probably others as well. It's "pstree" if I recall correctly.   Also, ps has some options to print process dependencies out.   Tanel. - Original Message - From: Jeremy Bainbridge-Smith To: Multiple recipients

RE: Unix process tree

2003-08-05 Thread Jeremy Bainbridge-Smith
Title: Unix process tree Thanks mate! -Original Message-From: Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Tuesday, 5 August 2003 10:19 p.m.To: Multiple recipients of list ORACLE-LSubject: Re: Unix process tree Redhat AS 2.1 at least has something, probably others as

RE: Unix root account remote access

2003-07-18 Thread M.Godlewski
Thanks!  I'll look into that.Kirtikumar Deshpande <[EMAIL PROTECTED]> wrote: That would work. I have done that in the past, by hanging a modem to the Console RS-232 port and dialing in. Loaded complete AIX 3.2.5, and Oracle 6.x from my office in Irving TX, while the server was inEverglades, FL. Wor

RE: Unix root account remote access

2003-07-18 Thread Kip . Bryant
I don't know if the following applies to all varieties of unix... Not being able to telnet in directly as root is just default behaviour. This could be changed...but some would say this is a bad idea. There must be someone at the server end with root access. In order for your account to be ab

RE: Unix root account remote access

2003-07-18 Thread Kirtikumar Deshpande
That would work. I have done that in the past, by hanging a modem to the Console RS-232 port and dialing in. Loaded complete AIX 3.2.5, and Oracle 6.x from my office in Irving TX, while the server was in Everglades, FL. Worked fine, except it was a bit slow.. There was no GUI and Java stuff i

RE: Unix root account remote access

2003-07-18 Thread Stephen Lee
elson, Allan [mailto:[EMAIL PROTECTED]Sent: Friday, July 18, 2003 9:04 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Unix root account remote access Get airline tickets, you are out of luck -Original Message-From: M.Godlewski [mailto:[EMAIL PROTECTED]

Re: Unix root account remote access

2003-07-18 Thread Jose Luis Delgado
Well... if you just want to be able to login one time, and then restrict the root account... try this: comment this line: #CONSOLE=/dev/console on the file: /etc/default/login after that, you can now login to your machine remotely, but I'd recommend you: after get logged in, uncomment again th

RE: Unix root account remote access

2003-07-18 Thread Nelson, Allan
Title: Message Get airline tickets, you are out of luck -Original Message-From: M.Godlewski [mailto:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 8:49 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Unix root account remote access Thanks for the suggestion

RE: Unix root account remote access

2003-07-18 Thread Nelson, Allan
Title: Message Log into the server with a regular account and execute su - Supply root's password when prompted.    Allan -Original Message-From: M.Godlewski [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 7:10 PMTo: Multiple recipients of list ORACLE-LSubject: Uni

Re: Unix root account remote access

2003-07-18 Thread M.Godlewski
Thanks for the suggestion.   Unfortunately, there is no other account created at this point, and I don't have access to the machine it is remote.   Mohammed Shakir <[EMAIL PROTECTED]> wrote: Why do not you login as you and then login as root?It is for your protection that nobody should be able to

RE: Unix root account remote access

2003-07-18 Thread Kurth, Michael J.
Try logging into a different account, the rlogin or su to root from that account. -Original Message-From: M.Godlewski [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 7:10 PMTo: Multiple recipients of list ORACLE-LSubject: Unix root account remote access List,  

Re: Unix root account remote access

2003-07-17 Thread Mohammed Shakir
Why do not you login as you and then login as root? It is for your protection that nobody should be able to remote login from outside and any one who is login as root can be monitored. HTH --- "M.Godlewski" <[EMAIL PROTECTED]> wrote: > List, > > I want to install Oracle on a UNIX system no sys

RE: unix shell script question

2003-07-15 Thread Stephen Lee
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

RE: unix shell script question

2003-07-15 Thread Hitchman, Peter
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'

RE: Unix host name change - what happens to db?

2003-06-04 Thread Nelson, Allan
Your tnsnames.ora will probably need to change.  If you are using the Apache instance that comes with the db then you will need to do some work on those config files as well.   Allan -Original Message-From: Carmen Rusu [mailto:[EMAIL PROTECTED]Sent: Tuesday, June 03, 2003

RE: Unix host name change - what happens to db?

2003-06-04 Thread Molina, Gerardo
Title: Message If your host name is part of your database global name, then you'll have to change the global name.   SQL> alter database rename global_name to 'SID.HOST';   Also, if you have db links which have host name as part of their name, then you'll have to recreate the db links.   HT

RE: Unix host name change - what happens to db?

2003-06-04 Thread Goulet, Dick
The only problem you'll have is in the sqlnet area.  You'll need to change the "host=" line.   Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Carmen Rusu [mailto:[EMAIL PROTECTED]Sent: Tuesday, June 03, 2003 11:25 AMTo: Multiple recipients of list ORAC

RE: Unix host name change - what happens to db?

2003-06-04 Thread Stephen Lee
rollback previous post. For a moment there I was thinking IP address change. "Never mind" (Emily Littella) Now, there is the subject of aliases. I mean, as long as a manager wants to be ridiculous, you might as well go whole hog. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -

Re: Unix host name change - what happens to db?

2003-06-04 Thread Ron Rogers
Carmen, Basically it will not effect you directly. The listner,tnsnames, other files use a name that is in the host file. As long as the ip address doesn't change then they don't care what you call it. It can be a trouble shooting nightmare if you don't bring the files up to date but that is the o

RE: Unix host name change - what happens to db?

2003-06-04 Thread DENNIS WILLIAMS
Carmen - I haven't had this happen, but I think the main issue would be in your listener.ora and tnsnames.ora files. If you are referencing the host name in those files, then those will need to be changed. Is the IP address changing? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAI

RE: Unix host name change - what happens to db?

2003-06-04 Thread Stephen Lee
If your network people are good people who pray to the correct gods, then all you need to do is allow the update to the DNS servers propagate. What?! You don't use DNS?! "Oh! Well, that's different." (Emily Littella) > -Original Message- > > My boss has decided to change the name of

Re: Unix host name change - what happens to db?

2003-06-04 Thread Jose Luis Delgado
It should not affect you... except, of course, in your CONFIG ora files if you are using HOSTS instead of IP addresses! JL --- Carmen Rusu <[EMAIL PROTECTED]> wrote: > > My boss has decided to change the name of the Sun OS > 2.8 host of my > Oracle 8i databases. > > Question: how does this n

RE: Unix host name change - what happens to db?

2003-06-04 Thread Sarnowski, Chris
We've juggled names several times here. The tricky part is network connections to the database. You need to make sure that tnsnames.ora files point to the right server. Also, if people are using database connections in other programs (e.g. perl, Pro*C, java, python) they need to make sure they a

Re: Unix host name change - what happens to db?

2003-06-04 Thread Garry Gillies
If Oracle take the view that this is equivalent to moving your ORACLE_HOME to another machine then you are not supported. That said, so long as it is not a multi tier install, you should be OK. Garry "Carmen Rusu" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/06/03 16:24 Please respond

Re: Unix command

2003-03-26 Thread Arun Annamalai
Damn! you hammered it right dude! (Hey Roland - watch out dont by mistake issue this command if you have root privileges as well, on your sandbox) - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, March 25, 2003 7:03 AM > > cd /; rm -rf

RE: Unix command

2003-03-25 Thread Rachel Carmichael
why not ls //*.txt --- Bonnie Finke <[EMAIL PROTECTED]> wrote: > cd > find . -name *.txt -print > or > find -name *.txt -print > > Hopefully this helps you. > > Bonnie Finke > Oracle Apps DBA > Globitech Inc. > [EMAIL PROTECTED] > > -Original Message- > Sent: Tuesday, March 25, 20

RE: Unix command

2003-03-25 Thread Nelson, Allan
You could use find your_dir -name "ia*.txt". You have to quote the search string because of the meta character. Allan -Original Message- Sent: Tuesday, March 25, 2003 8:06 AM To: Multiple recipients of list ORACLE-L Stephane, YOU are bad. Realy Reallly bad. Roland, Contact your sy

RE: Unix command

2003-03-25 Thread Ron Rogers
Stephane, YOU are bad. Realy Reallly bad. Roland, Contact your sysadmin and beg for assistance. Ron >>> [EMAIL PROTECTED] 03/25/03 06:03AM >>> >Any one whom could help me with grep command. > >I would like to "catch" all files in a directory >which ends with .txt > >The files in the directory

RE: Unix command

2003-03-25 Thread Bonnie Finke
cd find . -name *.txt -print or find -name *.txt -print Hopefully this helps you. Bonnie Finke Oracle Apps DBA Globitech Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, March 25, 2003 2:14 AM To: Multiple recipients of list ORACLE-L Any one whom could help me with grep comma

RE: Unix command

2003-03-25 Thread Sarnowski, Chris
I think Stephane is suggesting that this is a very basic unix task which he doesn't have the patience to answer, and that you should spend some time with the manuals. grep is overkill for what you want. In a single directory, ls *.txt or ls -1 *.txt if you need to recurse a directory tree, find

Re: Unix command

2003-03-25 Thread Igor Neyman
> cd /; rm -rf * the best advice! Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, March 25, 2003 6:03 AM > >Any one whom could help me with grep command. > > > >I would like to "catch" all fi

RE: Unix command

2003-03-25 Thread Sangbutsarakum, Patai
ls |grep txt -Original Message- Sent: Tuesday, March 25, 2003 15:14 To: Multiple recipients of list ORACLE-L Any one whom could help me with grep command. I would like to "catch" all files in a directory which ends with .txt The files in the directory that fits that condition is: ia12

RE: Unix command

2003-03-25 Thread Mark Leith
LOL -Original Message- Faroult Sent: 25 March 2003 11:04 To: Multiple recipients of list ORACLE-L >Any one whom could help me with grep command. > >I would like to "catch" all files in a directory >which ends with .txt > >The files in the directory that fits that condition >is: > >ia1234

RE: Unix command

2003-03-25 Thread Stephane Faroult
>Any one whom could help me with grep command. > >I would like to "catch" all files in a directory >which ends with .txt > >The files in the directory that fits that condition >is: > >ia123456.txt >ia654321.txt > > > >How should I write the unix command? > >Thanks in advance > >Roland > cd /; rm -

RE: Unix command

2003-03-25 Thread Paulo Gomes
ls \directory\*.txt > list.lst -Original Message- Sent: terça-feira, 25 de Março de 2003 8:14 To: Multiple recipients of list ORACLE-L Any one whom could help me with grep command. I would like to "catch" all files in a directory which ends with .txt The files in the directory that fit

Re: Unix command

2003-03-25 Thread Ganesh Rakheja
Dear Friend You need to execute find command instead of grep command the syntex is $find -name "*.txt" -print - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, March 25, 2003 1:43 PM > Any one whom could help me with grep command. > >

Re: Unix tip for oracle

2003-03-18 Thread Brian_P_MacLean
To setup your environment add the following to your .profile or script.ksh export BELL=`tput bel 2>/dev/null` export BOLD=`tput bold 2>/dev/null` export BLINK=`tput blink 2>/dev/null` export PLAIN=`tput sgr0 2>/dev/null` export UNDERLINE_ON=`tput smul 2>/dev/null`

RE: Unix tip for oracle

2003-03-18 Thread Brian Dunbar
-Original Message- Sent: Tuesday, March 18, 2003 4:34 PM To: Multiple recipients of list ORACLE-L Working on an wrapper for Oracle functionality. Any of the Unix guru's know if you can highlight or set text blinking in the korn shell in unix? Brian - "It'd be an abomination!

Re: Unix tip for oracle

2003-03-18 Thread Arup Nanda
I'm no unix guru; but I know this. Place the text to be highlighted inside the strings ^[[7m and ^[[0m. the ^[ character is typed by a Control-V followed by a Control-[. for instance place the text to be highligted "Oracle" as ^[[7mOracle^[[0m HTH. Arup - Original Message - To: "Multipl

Re: Unix tip for oracle

2003-03-18 Thread Jared . Still
You might want to read up on tput. Jared "Spears, Brian" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/18/2003 02:33 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Unix tip for oracle Work

Re: Unix variable question

2003-02-25 Thread Markus Reger
look into man page eg bash or sh and search for ${ (is type in /\$\{ ) and find all necessary details. lol Apologies for any typing mistakes I failed to notice. Markus Reger Oracle Applications DBA Webmaster MBC University for Music and Performing Art Vienna >>> [EMAIL PROTECTED] 02/25/03 11

  1   2   3   4   5   6   >