RE: backup unix script

executable files like sql+, svrmgrl, exp, imp), yes your database must be down it you do this. Hope this can help Sinardy -Original Message- Sent: Thursday, 29 November 2001 12:08 PM To: Multiple recipients of list ORACLE-L hi gurus, I found this unix script ... can any tell me what

Script to Disable Constraint, Change Value, then Enable Constrain

Listers, Does anyone have a script that will do the following: Accept user input for old data value Accept user input for new data value Disable table constraint Update record with new data value Enable constraint A script like this would help

Re: Problem Running DDL SQL Script

] cc: 21/11/01 22:35 Subject: Problem Running DDL SQL Script Please respond

Problem Running DDL SQL Script

I have this script that will generate a DB with a number of create table and create index statements. When I try to run it in SQL*Plus I get this error: ORA-00959 tablespace SOS2_TBLSPC does not exist. ORA-00942 table or view doesn't exist Here is a sample of one of the create statements

Re: Data integration script using PERL

: Is there someone who wrote a script in a PERL language designed to insert data in Oracle tables by reading data from a text data file ? If so, is it possible to have just an example of it so that I can adapt it for my need. Just not to reinvent the wheel Thanx

RE: Data integration script using PERL

integration script using PERL Hmm, no one ever asks for loaders, as sqlloader does a pretty good job of that. What everyone always asks for is an unloader. ( coming up, easier than you think :) Loading is pretty straightforward. If you have the column names as the first row, even better

Re: Insert script generator

As nobody gave me the script I really wanted to, I had to create one myself :((( Starting part is based on Jared's dump.sql but the rest of course is different. Here is link to it, just in case of need ;))) http://www.itsystems.lv/gints/dba_selects.htm#s21 Gints Plivna IT Sistçmas, Meríeïa 13

Data integration script using PERL

Is there someone who wrote a script in a PERL language designed to insert data in Oracle tables by reading data from a text data file ? If so, is it possible to have just an example of it so that I can adapt it for my need. Just not to reinvent the wheel Thanx

pass a value from a shell script to a store procedure

Hey List, I need to pass a value `date - 1` to a store procedure from a shell script. Really appreciate if anyone can help. Thanks, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anne Yu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: pass a value from a shell script to a store procedure

, November 09, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Hey List, I need to pass a value `date - 1` to a store procedure from a shell script. Really appreciate if anyone can help. Thanks, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anne Yu

RE: pass a value from a shell script to a store procedure

to pass a value `date - 1` to a store procedure from a shell script. Really appreciate if anyone can help. Thanks, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anne Yu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: pass a value from a shell script to a store procedure

,$DBA from dual; exit EOF echo Done! -Original Message- Sent: Friday, November 09, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Hey List, I need to pass a value `date - 1` to a store procedure from a shell script. Really appreciate if anyone can help. Thanks, -- Please

RE: pass a value from a shell script to a store procedure

` to a store procedure from a shell script. Really appreciate if anyone can help. Thanks, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anne Yu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: pass a value from a shell script to a store procedure

/incredibly_secret_password select $DATE,$DBA from dual; exit EOF echo Done! -Original Message- Sent: Friday, November 09, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Hey List, I need to pass a value `date - 1` to a store procedure from a shell script. Really appreciate if anyone

Re: Is this script correct ?

: my Subject: Re: Is this script correct ? Sent by: root

RE: Script for next_extent of objects = free space available

= c.tablespace_name and c.status != 'READ ONLY' and a.next_extent/1024 b.big_chunk; HTH Gerardo -Original Message- Sent: Tuesday, October 30, 2001 11:10 PM To: Multiple recipients of list ORACLE-L Hi Gurus, I am looking for a script that shows the list of tables with next extent = the free space

RE: Script for next_extent of objects = free space available

Hi Gerardo, I notice that in your script the free space is also derived from dba_free_space (same as my script). Although I issued the command alter database set autoextend on next ??M for the datafile, the table dba_free_space does not reflect this changes. Any other advice ? Thanks. Regds

RE: Script for next_extent of objects = free space available

Hi, I have this Space Bound object script that will list every table that can not allocate it's next extent. It will not list tables in tablespace that is set to autoextent. This is not entirely correct as you may have set an upper limit to the auto extent (if you feel like adding it in please

DATABASE CREATION SCRIPT

Hi, We will appreciate if someone can send a script that can be used to creata a oracle database on unix . We need to give these script as batch file to developer so that they can create database. Oracle version is 8.1.7 OS sun solaris 2.8 Thanks -Harvinder -- Please see the official ORACLE

RE: DATABASE CREATION SCRIPT

Hi, We will appreciate if someone can send a script that can be used to creata a oracle database on unix . We need to give these script as batch file to developer so that they can create database. Oracle version is 8.1.7 OS sun solaris 2.8 Thanks -Harvinder -- Please see the official ORACLE-L

Re:DATABASE CREATION SCRIPT

will appreciate if someone can send a script that can be used to creata a oracle database on unix . We need to give these script as batch file to developer so that they can create database. Oracle version is 8.1.7 OS sun solaris 2.8 Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http

RE: DATABASE CREATION SCRIPT

31, 2001 1:55 PM To: Multiple recipients of list ORACLE-L Subject: DATABASE CREATION SCRIPT Hi, We will appreciate if someone can send a script that can be used to creata a oracle database on unix . We need to give these script as batch file to developer so that they can create

RE: DATABASE CREATION SCRIPT

Title: RE: DATABASE CREATION SCRIPT -Original Message- From: Harvinder Singh [mailto:[EMAIL PROTECTED]] We will appreciate if someone can send a script that can be used to creata a oracle database on unix . We need to give these script as batch file to developer so

Script for next_extent of objects = free space available

Hi Gurus, I am looking for a script that shows the list of tables with next extent = the free space available in the tablespace. Does anyone have the script ? I write a script displaying the list of table-spaces with inadequate space for the next extent of the table SELECT F.TABLESPACE_NAME

RMAN HOTBACKUP AUTOMATED SCRIPT

Hi Can some one send me automated RMAN backup scripts please? Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Re: RMAN HOTBACKUP AUTOMATED SCRIPT

run { allocate channel t1 type 'SBT_TAPE'; backup incremental level 0 skip inaccessible tag hot_fdm1_bk_level0 filesperset 2 format 'bk_%s_%p_%t' (database); sql 'alter system archive log current'; backup filesperset 20 format 'al_%s_%p_%t' (archivelog all delete

Re: RMAN HOTBACKUP AUTOMATED SCRIPT

Hi Seema, I use this script. I have added comments so it should not be difficult to understand. Let me know if you need any clarification: the usage is -- exec_restore.ksh -d [SID] -f [rman_cmdfile] Deepak PS: i have not included command file as i think probably need only the wrapper

Re: Database Security Script...

: Database Security Script... Sent by: root

Re: ORA-03113 when executing the initjvm script

Hello all of you, I get the ORA-03113 (end-of-file on communication channel) error when I execute the initjvm script. This script is needed to use utl_smtp package. Here is the output I get: *** ERROR: ORA-03114: not connected to ORACLE create or replace java system; * ERROR en línea 1

ORA-03113 when executing the initjvm script

Hello all of you, I get the ORA-03113 (end-of-file on communication channel) error when I execute the initjvm script. This script is needed to use utl_smtp package. Here is the output I get: *** ERROR: ORA-03114: not connected to ORACLE create or replace java system; * ERROR en línea 1: ORA

Re: ORA-03113 when executing the initjvm script

of the 3113 in the init.ora: event=3113 trace name errorstack level 10 REGARDS. --- Beatriz Martínez Jiménez [EMAIL PROTECTED] wrote: Hello all of you, I get the ORA-03113 (end-of-file on communication channel) error when I execute the initjvm script. This script is needed to use utl_smtp

RE: ORA-03113 when executing the initjvm script

the ORA-03113 (end-of-file on communication channel) error when I execute the initjvm script. This script is needed to use utl_smtp package. Here is the output I get: *** ERROR: ORA-03114: not connected to ORACLE create or replace java system; * ERROR en línea 1: ORA-03113: end-of-file

RE: ORA-03113 when executing the initjvm script

Chris, Basically the error 3113 is bit different from the other errors. Most of the errors (if not all ORA errors other than 3113 and 1041 I think) are generated from rdbms kernel where as 3113 is generated from the client side, You won't be able to get an error stack trace or

RE: ORA-03113 when executing the initjvm script

Gopal, I have tried it many times (dumping errorstack at level 3 on 3113) but somehow it didn't give the analyst any clue. I don't know why ... and neither did he (the analyst). Of course none of my errors are related to JVM, we haven't started putting JAVA in our DB, that's for 9i

RE: looking for a parsing script

Title: RE: looking for a parsing script Actually, what I've got is a table with a varchar2(4000) column holding statements pulled from various databases (all kinds of statments, not just selects). What I'm writing is a pl/sql routine to parse through all these statments and generate a list

RE: looking for a parsing script

and generate a list of the tables, views and synonyms that are referenced. I was hoping someone might already have such a script. DBI might prove simpler for this via regexen or Parse::RecDescent. -- Steven Lembark 2930 W. Palmer Workhorse Computing

looking for a parsing script

Title: looking for a parsing script Before I go out an re-invent the wheel (again), I wanted to ask if anyone has a script (preferably pl/sql) for parsing out table references from an SQL statement. Matt Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over

Re: looking for a parsing script

Matt, What kind of file will the SQL be in? Do you have a sample? Jared On Monday 24 September 2001 07:15, Adams, Matthew (GEA, 088130) wrote: Before I go out an re-invent the wheel (again), I wanted to ask if anyone has a script (preferably pl/sql) for parsing out table references from

ora-01555 when running long script

Hi, We are running script in whcih we are updating 25 tables but after every 5 tables we are getting oracle error ora-01555.. we tried many options with rolback segment but no use: 1) few very large rollback segment 2 many large rolback segments rollback tablespace size is 5GB what can

RE: ora-01555 when running long script

- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Harvinder Singh Enviado el: Sunday, 23 September, 2001 5:15 PM Para: Multiple recipients of list ORACLE-L Asunto: ora-01555 when running long script Hi, We are running script in whcih we are updating 25 tables but after every 5 tables

RE: ora-01555 when running long script

One thing to remember here is that a single transaction will only use one rollback segment. The problem is that ORA-1555 errors occur because a consistent get for a particular db block failed. Here are some things to check: 1. Make sure you're running this script during off hours. The fewer

Need script to generate DDL for snapshot/materialized view recrea

!! Please do not post Off Topic to this List !! Hello all, I need to regenerate the DDL to recreate a snapshot/materialized view in an 8.1.6 database, but I don't want to reinvent the wheel. Can anyone help me out with a script? Thanks in advance, Jim

RE: Need script to generate DDL for snapshot/materialized view re

, 2001 10:25 AM To: Multiple recipients of list ORACLE-L recrea !! Please do not post Off Topic to this List !! Hello all, I need to regenerate the DDL to recreate a snapshot/materialized view in an 8.1.6 database, but I don't want to reinvent the wheel. Can anyone help me out with a script

Script for checking temp usage

Does anybody have a script that will tell you which session_ids are using temp and how much they are using? We occasionally get runaway sessions that don't release temp and this would allow us to easily locate the offending session. I've already checked OraMag and used google

Re: Script for checking temp usage

try this query: SELECT s.username, s.serial#, s.sid, u.tablespace, u.contents, u.extents, u.blocks FROM v$session s, v$sort_usage u WHERE s.saddr=u.session_addr; Lucy On Mon, 10 Sep 2001, Jenkins, Michael wrote: Does anybody have a script that will tell you which session_ids are using

RE: Script for checking temp usage

Michael - I've had similar problems (although the pain isn't high enough for me to get in there and fix them yet). To do this I've set up a cron job to check every 15 minutes. The script I run is: set lines 100 pages 87 column username format a10 column tablespace format a6 heading 'TBSP

RE: Script for checking temp usage

North, Chelmsford 01863 -Original Message- Sent: Monday, September 10, 2001 12:20 PM To: Multiple recipients of list ORACLE-L Does anybody have a script that will tell you which session_ids are using temp and how much they are using? We occasionally get runaway sessions that don't

Re: Script for checking temp usage

Since 8.X joining v$sort_usage and v$session. In 7.X Metalink had an script that I enclose. When the query is running, you can issue a query over v$session_wait. Looking for the event 'db file sequential read' where p1 includes all the files of the temp tablespace. Regards. --- Jenkins

RE: Script for checking temp usage

=u.session_addr; Lucy On Mon, 10 Sep 2001, Jenkins, Michael wrote: Does anybody have a script that will tell you which session_ids are using temp and how much they are using? We occasionally get runaway sessions that don't release temp and this would allow us to easily locate the offending

Script to Generate SQL To Recreate All Tables and Indexes for Sch

Hello, Can anybody help me with a script or tool that will generate SQL to recreate all tables and all indexes in a schema? I DO NOT want the script to generate storage parameters. If anybody has a script that does this, or can suggest a free tool, please let me know. I need to recreate all

RE: Script to Generate SQL To Recreate All Tables and Indexes for

Take a look at my site, www.vampired.net, you will find a script to do both, it can be modified pretty easily to remove the storage clauses. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher

Re: Script to Generate SQL To Recreate All Tables and Indexes for Sch

PROTECTED] wrote: Hello, Can anybody help me with a script or tool that will generate SQL to recreate all tables and all indexes in a schema? I DO NOT want the script to generate storage parameters. If anybody has a script that does this, or can suggest a free tool, please let me know. I

Uniix-script-help

Hallo, Anyone whom has a good example on a unix-script that does this: I want it to run sqlloader script, which loads data into a table in the database and also make an insert from this table into anothertable? I wantthis to be scheduled every day. Also with a check if the file exists

Unix-script

Hallo Can anyone give me an example on how to write a unix script which schedules the run run of a sqlloader script from unix server into the database. I mean I could easily get the file tmanually o be imported if i use the ftp command, but how do i do if I want that to be scheduled? Roland

AW: Unix-script

Title: AW: Unix-script Hi Roland, try this: 1) shell script #!/usr/bin/ksh # ora_load.sh # load data to db using sql loader . /etc/profile . $HOME/.profile cd /home/oracle/load # set Oracle specific environmental variables here export NLS_NUMERIC_CHARACTERS=., export ORACLE_SID

Re: Unix-script

Ron, try man cron or man crontab write your shell script as if you were going to run it from the command line manually (however, make sure you define all the environment variables you will need within the script) Once it is done and working, use cron to schedule it for Unix. Rachel

RE: Unix-script

} Schedule the whole thing in cron. --Michael -Original Message- Sent: Thursday, August 30, 2001 1:27 PM To: Multiple recipients of list ORACLE-L Ron, try man cron or man crontab write your shell script as if you were going to run it from the command line manually (however, make sure you

Unix-script

Hallo, Can anyone give me an eaxmple of a iunix script, which checks if the file in unixsystem exists and if it does then it runs th esqlloader script, which loads data into a database table.? Thanks in advance. Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Re: Unix-script

[EMAIL PROTECTED] wrote: Hallo, Can anyone give me an eaxmple of a iunix script, which checks if the file in unixsystem exists and if it does then it runs th esqlloader script, which loads data into a database table.? Thanks in advance. Roland There is a script named upload.ksh

How to loop call to SQL script in PL/SQL...

Hi DBA's Developers, I first tried to call a batch file which calls SQL*Plus and executes an SQL script from within Perl, but I had no success. Perhaps I'm taking the wrong approach. I'm sure it can be done using PL/SQL. I want to run an SQL script repeatedly every 5 seconds throughout the day

RE: How to loop call to SQL script in PL/SQL...

Title: RE: How to loop call to SQL script in PL/SQL... Denmark, Every 5 seconds?? That's going to put an awful load on your database, dont'cha think? That's also going to be a very large file. We tried this a few months ago when jrun was acting suspect and we were getting a bunch

dyn sql(get the constraints script)

for those of you with metalstink, its Doc ID: Note:1016836.6 for those of you who dont(and want it, email me). have a good weekend everyone(for those of you already into the weekend in Australia and NZ, what does the weekend look like, good? joe

RE: TNSPING Test Script for NT

.bat script for NT that will run a TNSPING against a certain connect descriptor and write the results to a file. I need to have the TNSPING run for say 1000 loops. Once complete, I can search through the file for errors. Thanks, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: TNSPING Test Script for NT

-Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 21, 2001 2:37 PM To: Multiple recipients of list ORACLE-L Can anyone help me with a simple .bat script for NT that will run a TNSPING against a certain connect descriptor and write the results to a file. I need to have

TNSPING Test Script for NT

Can anyone help me with a simple .bat script for NT that will run a TNSPING against a certain connect descriptor and write the results to a file. I need to have the TNSPING run for say 1000 loops. Once complete, I can search through the file for errors. Thanks, Ed -- Please see the official

NT backup script question

I have a NT cold backup script but I would like to add at last a winzip or any other compress command. Any idea from someone who has already done this ? Thanx

Re: NT backup script question

n, OCP DBAPerceptron, Inc.(734)414-4627[EMAIL PROTECTED] - Original Message - From: ALEMU Abiy To: Multiple recipients of list ORACLE-L Sent: Friday, August 17, 2001 7:40 AM Subject: NT backup script question I have a NT cold backup script but I would like to

Re: NT backup script question

Internet: http://www.powerarchiver.com Email: [EMAIL PROTECTED] Paul -Original Message- Sent: Friday, August 17, 2001 12:41 To: Multiple recipients of list ORACLE-L I have a NT cold backup script but I would like to add at last a winzip or any other compress command. Any idea from

RE: NT backup script question

PowerArchiver is another good one, I know a couple of the people on the list use it to compress their NT backup sets From: Mark Leith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: NT backup script question Date: Fri, 17

RE: NT backup script question

one, I know a couple of the people on the list use it to compress their NT backup sets From: Mark Leith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: NT backup script question Date: Fri, 17 Aug 2001 07:34:19 -0800 Try PKZIP

Running sql script from stored procedure

Dear DBA Gurus, I have a .sql file which contains a series of insert statements. I want to call this .sql file and run it from a stored procedure. Is it possible? If so, how? Please post your answers to me directly as I am not receiving messages directly from the list rather

Re: Running sql script from stored procedure

Use UTL_FILE to read your .sql file, and then execute your sql-statements using dynamic sql (DBMS_SQL or 'EXECUTE IMMEDIATE'). Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent:

Rman script

Hello, Can anyone let me know as to which script has to be run for creating the catalogs of rman on 8.1.7 on sun solaris. I am missing the catrman.sql in the rdbms/admin directory. have they renamed this script or is it somehow missing in this rdbms/admin directory. I even checked this out

Rman script

Thanks for anybody trying to help I did get to know how to create it. I lazy bum not to go thro the document. Thanks anyway _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official

Re: Rman script

hi Arun there is a create catalog coomnad that you need to fire connected as the catalog owner (rman) Deepak --- ARUN K C [EMAIL PROTECTED] wrote: Hello, Can anyone let me know as to which script has to be run for creating the catalogs of rman on 8.1.7 on sun solaris. I am missing

Help automating SQL Hot Backup script with batch file...

script. However, when I try to invoke the SQLPLUS or SVRMGR program with the Hot_Backup script it fails with a message that I'm not connected to Oracle or Oracle is not available. As you can see from the commented lines in the batch file, I tried other options as well but none seems to work

Re: Executing script shell

2001 19:25, Eca Eca wrote: Friends : How can i do for connect in the database by unix, when the operational system received a email ? For example : I send a email to the address (or alias) when unix receives this email i would like to run a script ... I don't know how to write a shell script

RE: catparr.sql ..... sample script

That doesn't work on 8i. You should change the scripts using x$bh instead of v$cache and v$bh. Regards. --- Brian MacLean [EMAIL PROTECTED] wrote: As already stated you get v$bh and v$cache views. Here is a script that uses them to tell you WTF is using your db_block_buffers. Sample

RE: catparr.sql ..... sample script

get v$bh and v$cache views. Here is a script that uses them to tell you WTF is using your db_block_buffers. Sample output follows the script (have fun). REM REM Brian P. Mac Lean 01-JUL-01 REM REM SGA DB Block Hogs and Activity REM REM Must Be Run As SYS or Internal

Executing script shell

Friends : How can i do for connect in the database by unix, when the operational system received a email ? For example : I send a email to the address (or alias) when unix receives this email i would like to run a script ... I don't know how to write a shell script for to do it ... Hugs

RE: Can Unix script not changeable and not readable ?

Compilation will not make the password unreadable. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 31, 2001 8:30 PM To: Multiple recipients of list ORACLE-L Hi all, How make unix script and Oracle sql script not readable

Re: Perl Script for Alert Log

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Okan CIMEN Sent: Tuesday, July 31, 2001 7:55 PM To: Multiple recipients of list ORACLE-L Subject: Re: Perl Script for Alert Log Hello, I have a soft copy of the book Teach yourself perl 5 in 21 days by David

RE: Perl Script for Alert Log

ORACLE-L Ron, thanks for the script, but what was the name of the book that taught you this! Rachel From: Smith, Ron L. [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Perl Script for Alert Log Date: Mon, 30 Jul 2001 13:50:29

Re: Can Unix script not changeable and not readable ?

MacGregor, Ian A. schrieb: Compilation will not make the password unreadable. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] Hi, if you want to hide the connect strings, place them in an extra directory, only x-able and readable by privileged users. Then have your

RE: Perl Script for Alert Log

-Original Message- Sent: Monday, July 30, 2001 9:00 PM To: Multiple recipients of list ORACLE-L Ron, thanks for the script, but what was the name of the book that taught you this! Rachel From: Smith, Ron L. [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L

Re: Perl Script for Alert Log

, 2001 9:00 PM To: Multiple recipients of list ORACLE-L Ron, thanks for the script, but what was the name of the book that taught you this! Rachel From: Smith, Ron L. [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Perl

RE: Perl Script for Alert Log

thanks! From: Smith, Ron L. [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Perl Script for Alert Log Date: Tue, 31 Jul 2001 05:41:14 -0800 The book is Teach yourself Perl in 21 days It's is written so anyone can understand

Re: Can Unix script not changeable and not readable ?

well u can use unix permissions, chmod 000 filename. then only the owner can change it back, but then no one can read it either. :) joe Sinardy wrote: Hi all, How make unix script and Oracle sql script not readable or chnageable, something like compile it into executable format

Perl Script for Alert Log

A few weeks ago I was looking for a script that would combine the date records with the detail records on the Oracle alert_log. I didn't get any responses so I decided to do it myself. (I hate it when that happens!). Anyway, everyone here tells me how great Perl is at handling things like

Re: Perl Script for Alert Log

Ron, thanks for the script, but what was the name of the book that taught you this! Rachel From: Smith, Ron L. [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Perl Script for Alert Log Date: Mon, 30 Jul 2001 13:50:29 -0800

UNIX SCRIPT ISSUE - URGENT

is in one place. Using the script above would take me over 20 000 hours. Any way I can grab the files one at the time based on a ls command, and invoke the script, and to end up when the last file has been processed. ALTERNATIVE: Each file contains the IP address which has to move into the first

Re: UNIX SCRIPT ISSUE - URGENT

Since you have so many files, you are likely to hit problems with the line length of the various shells. Assuming that all of the files are in the directory /usr/myfiles and that the script mentioned below is named cvtip, is executable and is in /usr/local/bin (or some other directory

RE: UNIX SCRIPT ISSUE - URGENT

Title: RE: UNIX SCRIPT ISSUE - URGENT No unix expert but the first option can be achieved automatically by running the following script for filename in `ls *.file` do unix script as listed done Rename a couple of the files and try out the syntax and work out the timings. Once it all

RE: UNIX SCRIPT ISSUE - URGENT

for i in `ls` do YourScript.shl $i done Unless you are also processing your newfile.dat in the script you need to make unique names for the output files. Something like: sed s/Report by Hosts/$IP| Report by Hosts/ $FN new_${FN}.dat so you will get an output file from each input file

Re: UNIX SCRIPT ISSUE - URGENT

Try awk or perl. They can handle string manipulation from OS commands simply and quickly. A simple awk script to take the first 16 characters of the output of ls and put it into a data file follows: gawk 'BEGIN { while (ls | getline) print substr($1,1,16) | Report by Hosts}' new.dat Defry

NON-oracle question: perl script to syn time with an vax host

hi, anyone know where i can find an perl script to syn a PC clock to a VAX clock? thanks for any help, sorry for non-oracle question === Patrick Housholder Sr. Staff Anl Tech Spt Design United Airlines Flight Training Center Denver CO -- Please see the official

RE: NON-oracle question: perl script to syn time with an vax hos

Hi Patrick, Not a Perl script but, Do you run Pathworks on the Vax and if so what version? With Pathworks V5 and above you can do it from an NT cmd line with a simple net time command. eg if running Pathworks and VAX is called vax1 then from NT command line: net time \\vax1 /set /y (ie NT

RE: Backup script giving error when run by cron

Manivannan, I would still put into your script (shutdown.sh) alongwith your ORACLE_SID variable etc. the following lines. ORACLE_HOME=/absolute_path_name_of Oracle_home export ORACLE_HOME PATH=$PATH:$ORACLE_HOME/bin export PATH Give it a try !! Lee -Original Message- Sent: 20 July

Re: RE: Backup script giving error when run by cron - Solved

Hi list, Lee's suggestion worked... Thanks to all the guys who gave suggestions. regards, Manivannan Muthukrishnan. Enjoy being an Indyan at http://www.indya.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services

RE: Backup script giving error when run by cron

command given in the shutdown script doesn't run.. It says svrmgrl - not found. I'm running the cron from the dba user. But still the environment is not set. What should I do?? thanks in advance, Manivannan.M Begin Included Message Sent: Wed, 18 Jul 2001 23:40:30 -0800 To: Multiple

<    2   3   4   5   6   7   8   9   10   >