date:20030701

Hi!

I personally still prefer to do dropping manually. First drop objects from
tablespace, then drop tablespace, then check with fuser whether anyone still
uses the datafile, then rm datafile. It takes longer, but I like to have
more control over things (including contents option can be quite dangerous
for example..)

Tanel.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 02, 2003 1:16 AM


> It's about time, don't you think?!!
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
>
> -Original Message-
> Sent: Tuesday, July 01, 2003 6:05 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Yep, if you type drop tablespace  including contents and datafiles;
> the datafiles are removed.
>
> Also, if you are using OMF (oracle managed files) by some odd reason then
> dropping tablespace also deletes the datafiles, even if you don't specify
> "including contents and datafiles" option.
>
> A small example below..
> Tanel.
>
> SQL> alter session set db_create_file_dest="G:\";
>
> Session altered.
>
> SQL> create tablespace g;
>
> Tablespace created.
>
> SQL> select name from v$datafile;
>
> NAME
> --
--
> 
> C:\ORACLE\ORA92\ORCL\SYSTEM01.DBF
> C:\ORACLE\ORA92\ORCL\UNDOTBS01.DBF
> C:\ORACLE\ORA92\ORCL\CWMLITE01.DBF
> C:\ORACLE\ORA92\ORCL\DRSYS01.DBF
> C:\ORACLE\ORA92\ORCL\EXAMPLE01.DBF
> C:\ORACLE\ORA92\ORCL\INDX01.DBF
> C:\ORACLE\ORA92\ORCL\ODM01.DBF
> C:\ORACLE\ORA92\ORCL\TOOLS01.DBF
> C:\ORACLE\ORA92\ORCL\USERS01.DBF
> C:\ORACLE\ORA92\ORCL\XDB01.DBF
> C:\ORACLE\ORA92\ORCL\TS2K01.DBF
>
> NAME
> --
--
> 
> G:\O1_MF_G_ZJ3XXJ00_.DBF
>
> 12 rows selected.
>
> SQL> ho dir G:\O1_MF_G_ZJ3XXJ00_.DBF
>  Volume in drive G has no label.
>  Volume Serial Number is 7042-6228
>
>  Directory of G:\
>
> 02.07.2003  00:05  104 865 792 O1_MF_G_ZJ3XXJ00_.DBF
>1 File(s)104 865 792 bytes
>0 Dir(s) 298 082 304 bytes free
>
> SQL> drop tablespace g;
>
> Tablespace dropped.
>
> SQL> ho dir G:\O1_MF_G_ZJ3XXJ00_.DBF
>  Volume in drive G has no label.
>  Volume Serial Number is 7042-6228
>
>  Directory of G:\
>
> File Not Found
>
> SQL>
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, July 02, 2003 12:28 AM
>
>
> > There's a new feature in 9i that can remove the os file also
> >
> > Ramon E. Estevez
> > [EMAIL PROTECTED]
> > 809-535-8994
> >
> >
> >
> > -Original Message-
> > Jose Luis Delgado
> > Sent: Tuesday, July 01, 2003 5:13 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > It dissappered from the data dict...
> >
> > but it should exist at os level...
> >
> > you need to rm it...
> >
> > check it...
> >
> > HTH
> > JL
> >
> > --- Hamid Alavi <[EMAIL PROTECTED]> wrote:
> > > Hi List,
> > >
> > > Today I have dropped a big tablespace(4 Gig) as soon
> > > as I dropped it the
> > > data file also disappeared from the list of
> > > datafiles, as I know the
> > > datafile must be removed manually Any idea?
> > >
> > > I am using 9.0.1 on solaris 2.8
> > >
> > > Thanks,
> > >
> > > Hamid Alavi
> > >
> > > Office  :  818-737-0526
> > > Cell phone  :  818-416-5095
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.net
> > > --
> > > Author: Hamid Alavi
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051
> > > http://www.fatcity.com
> > > San Diego, California-- Mailing list and web
> > > hosting services
> > >
> > -
> > > To REMOVE yourself from this mailing list, send an
> > > E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of
> > > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > > ORACLE-L
> > > (or the name of mailing list you want to be removed
> > > from).  You may
> > > also send the HELP command for other information
> > > (like subscribing).
> >
> >
> > __
> > Do you Yahoo!?
> > SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Jose Luis Delgado
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
> > message BODY, include a line containing: UNSUB ORACLE-L (or the name of
> > mailing list you want to be removed from).  You may also send the HELP
> > command for other information (like subscribing).

Re: OT: perl DBI/DBD: can I pass in an array as parameter?

2003-07-01 Thread Tim Bunce

Not yet. It is being worked on though:
http://groups.google.com/groups?dq=&hl=en&lr=&ie=UTF-8&oe=UTF-8&safe=off&threadm=7sfzlwita2.fsf%40ash.int.sifira.dk&prev=/groups%3Fhl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26safe%3Doff%26group%3Dperl.dbi.dev
http://groups.google.com/groups?dq=&hl=en&lr=&ie=UTF-8&oe=UTF-8&safe=off&threadm=20030616160334.GA9324%40dansat.data-plan.com&prev=/groups%3Fhl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26safe%3Doff%26group%3Dperl.dbi.dev

Tim.

On Tue, Jul 01, 2003 at 08:19:49AM -0800, Guang Mei wrote:
> Hi:
> 
> Does anyone know if I can pass an array in perl to an sql using DBI/DBD so
> that I get result set from Oracle?
> 
> Specifically, I want do something like in perl:
> 
> 
> $sth = $dbh->prepare (" select  tab1.col1, tab2.col2 from tab1, tab2
>where tab1.ID1 = tab2.ID2
>and   tab1.X = ? ");
> 
> my @my_array;
> 
> # filling in my_array with data here
> 
> $sth->execute(@my_array);
> 
> my ($col1, $col2);
> while(($col1, $col2) = $sth->fetchrow_array())  {
> 
>   # do processing of $col1 and $col2;
> }
> 
> I am hoping to save repeated sql calls, do only one call and get all the
> rows back.
> 
> Is it possible in any version DBI/DBD? I looked at
> 
> http://perldoc.com/perl5.6.1/lib/DBI.html
> 
> and I does not seem to be able to figure it out. If it is possible, any
> simple example code somewhere?
> 
> Thanks.
> 
> Guang
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Guang Mei
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Bunce
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Table CACHE/NOCACHE

2003-07-01 Thread AK

Did u do a full scan of table again after nocache setting ? 

-ak

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 01, 2003 12:20 PM


> Guys,
> 
> Help me figure this one out. Was helping a colleague
> diagnose slow response time (8.1.7/Solaris running
> Peoplesoft ). x$bh showed 102,248 out of 170,000
> buffers belonged to a single table, which he said he
> cached explicitly. He did "NOCACHE" (on my suggestion)
> on the large table. 
> I still find that the table is in buffer cache (even
> Buff# haven't changed - starts with buf#=1 - not sure
> if this means LRU end) even after a week. DB cannot be
> bounced since it is production. 
> Do you know of any reason why it is not flushed out of
> cache when table is altered to NoCache?
> 
> Thanks,
> Ravi.
> 
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Ravi Kulkarni
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: AK
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: nt script

2003-07-01 Thread Jared . Still

Learn Perl and forget this ugly MS batch stuff.

It's such a kludge.






"Seefelt, Beth" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 07/01/2003 02:49 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: nt script



FIND or FINDSTR should work equally well, I think.  Maybe it depends on
your exact platform.

-Original Message-
Sent: Tuesday, July 01, 2003 5:07 PM
To: Multiple recipients of list ORACLE-L


Hi...

I could not follow this thread, so, I do not know the
current status...

anyway... I tested this and it works...

1.- First, I saw that you asked for: string called ORA
and your errorlevel statement failed.

2.- Second, the script sent by: Seefelt, Beth looks
like it works (I did not test it), EXCEPT that you
HAVE to change this line:

> FIND "ORA-03313" psprcsrv_psnt_%MMDD%.log

with this one:

> FINDSTR "ORA-03313" psprcsrv_psnt_%MMDD%.log

HTH
JL

there you go... (modify at your own needs...)

copy con test.cmd
findstr "%1" alert_develop.log
if errorlevel 1 goto no
if errorlevel 0 goto si
:no
   echo no se encontr≤ la cadena: %1
   goto fin
:si
   echo si se encontr≤ la cadena: %1
:fin
ctrl-Z

--- "Seefelt, Beth" <[EMAIL PROTECTED]>
wrote:
> 
> That actually makes it alot easier
> 
> FOR /F "tokens=1-5 delims=/, " %%i in ('date/t') DO
> SET MMDD=%%j%%k
> if NOT EXIST psprcsrv_psnt_%MMDD%.log goto no_file
> FIND "ORA-03313" psprcsrv_psnt_%MMDD%.log
> if errorlevel 1 ( echo 'there is a match'
>  d:\start_proc.bat )
> goto :EOF
> 
> :no_file
>   echo Can't find todays log!
>   exit /b 2
> 
> 
> 
> -Original Message-
> Sent: Tuesday, July 01, 2003 3:51 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Bob,
> 
> I tested it out, it works on one hard code file. If
> I set thisfile it
> works. But in reality, I need to find today's log,
> the log file name
> convention is always goes psprcsrv_psnt_0701.log
> with the date suffix to
> the end. I can't hard code the file name in the bat
> file. Is there
> anyway how to get around with this?
> 
> Thanks,
> 
> Joan
> 
> Bob Metelsky wrote:
> > 
> > Don't run it line by line
> > Save it to a file called myfind.bat
> > 
> > Then call from a command prompt
> > 
> > C:\> myfind.bat
> > 
> > Or click the batch file, be sure to leave the
> pause so you can see an
> > error if any. Once its working, you can then
> implemet blat as someone
> > suggested
> > 
> > Here is a version using variables
> > 
> >
>
##
> > 
> > [myfind.bat]
> > :: Find example by BMetelsky on 
> Friday-April-11-2003-9:22:53 AM
> > :: This script searches thefile for a string and
> if it finds it, sends
> > an email message to dbamail
> > :: 0 =is found
> > echo off
> > set themess=A Database SERVICE on %computername%
> is NOT running on
> > %date% at %time%
> > set [EMAIL PROTECTED]
> > set blatfile=D:\dbmon\blattext.txt
> > set thefile=D:\dbmon\runit.log
> > set subject=A DB SERVICE IS NOT RUNNING
> > set [EMAIL PROTECTED]
> > echo starting >%blatfile%
> > 
> > find "ERROR:" %thefile% >NUL
> > 
> > IF ERRORLEVEL 1 GOTO no
> > IF NOT ERRORLEVEL 1 GOTO yes
> > :no
> > goto end
> > 
> > :yes
> > echo A db service is down on
> %computername%>%blatfile%
> > blat D:\dbmon\blattext.txt -subject "%subject%"
> -to "%dbamail%" -i
> > "%from%" -body "%themess%"
> > goto end
> > 
> > :end
> > @exit
> > rem echo %errorlevel%
> > 
> >
>
##
> > 
> > > Hi Bob, thanks for the reply. I added your code
> and tested
> > > still no good. I tested the case without a
> match. Still go to run.
> > >
> > > Joan
> > >
> > > D:\oracle\admin>FORFILES
> > > -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log
>  -d+0 -c"CMD
> > > /c echo @FILE" PSPRCSRV_PSNT_0630.log
> PSPRCSRV_PSNT_0701.log
> > >
> > > D:\oracle\admin>echo on
> > >
> > > D:\oracle\admin>FORFILES
> > > -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log
>  -d+0 -c"CMD
> > > /c type d:\pslog
> [EMAIL PROTECTED]|findstr ORA-03113
> > > >D:\oracle\admin\test.log"
> > >
> > > D:\oracle\admin>rem FORFILES
> > > -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log
>  -d+0 -c"CMD
> > > /c type d:\p
> [EMAIL PROTECTED]|findstr ORA-03113"
> >NUL
> > >
> > > D:\oracle\admin>IF ERRORLEVEL 1 GOTO no
> > >
> > > D:\oracle\admin>IF NOT ERRORLEVEL 1 GOTO
> RUN_PROC
> > >
> > > D:\oracle\admin>rem d:\psfm\start_proc_sched.bat
> > >
> > > D:\oracle\admin>echo run
> > > run
> > >
> > > D:\oracle\admin>pause
> > > Press any key to continue . . .
> > >
> > > D:\oracle\admin>goto end
> > >
> > > D:\oracle\admin>echo "finished"
> > > "finished"
> > >
> > > D:\oracle\admin>rem if errorlevel 1
> @d:\psfm\start_proc_sched.bat
> > >
> > > Bob Metelsky wrote:
> > > >
> > > > echo off
> > > > @cls
> > > > find "ORA-124" C:\yourlog.txt >NUL
> > > >
> > > > IF ERRORLEVEL 1 GOTO no
> > > > IF NOT ERRORLEVEL 1 GOTO yes
> > >

RE: Drop Tablespace

It's about time, don't you think?!!

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Tuesday, July 01, 2003 6:05 PM
To: Multiple recipients of list ORACLE-L


Yep, if you type drop tablespace  including contents and datafiles;
the datafiles are removed.

Also, if you are using OMF (oracle managed files) by some odd reason then
dropping tablespace also deletes the datafiles, even if you don't specify
"including contents and datafiles" option.

A small example below..
Tanel.

SQL> alter session set db_create_file_dest="G:\";

Session altered.

SQL> create tablespace g;

Tablespace created.

SQL> select name from v$datafile;

NAME


C:\ORACLE\ORA92\ORCL\SYSTEM01.DBF
C:\ORACLE\ORA92\ORCL\UNDOTBS01.DBF
C:\ORACLE\ORA92\ORCL\CWMLITE01.DBF
C:\ORACLE\ORA92\ORCL\DRSYS01.DBF
C:\ORACLE\ORA92\ORCL\EXAMPLE01.DBF
C:\ORACLE\ORA92\ORCL\INDX01.DBF
C:\ORACLE\ORA92\ORCL\ODM01.DBF
C:\ORACLE\ORA92\ORCL\TOOLS01.DBF
C:\ORACLE\ORA92\ORCL\USERS01.DBF
C:\ORACLE\ORA92\ORCL\XDB01.DBF
C:\ORACLE\ORA92\ORCL\TS2K01.DBF

NAME


G:\O1_MF_G_ZJ3XXJ00_.DBF

12 rows selected.

SQL> ho dir G:\O1_MF_G_ZJ3XXJ00_.DBF
 Volume in drive G has no label.
 Volume Serial Number is 7042-6228

 Directory of G:\

02.07.2003  00:05  104 865 792 O1_MF_G_ZJ3XXJ00_.DBF
   1 File(s)104 865 792 bytes
   0 Dir(s) 298 082 304 bytes free

SQL> drop tablespace g;

Tablespace dropped.

SQL> ho dir G:\O1_MF_G_ZJ3XXJ00_.DBF
 Volume in drive G has no label.
 Volume Serial Number is 7042-6228

 Directory of G:\

File Not Found

SQL>


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 02, 2003 12:28 AM


> There's a new feature in 9i that can remove the os file also
>
> Ramon E. Estevez
> [EMAIL PROTECTED]
> 809-535-8994
>
>
>
> -Original Message-
> Jose Luis Delgado
> Sent: Tuesday, July 01, 2003 5:13 PM
> To: Multiple recipients of list ORACLE-L
>
>
> It dissappered from the data dict...
>
> but it should exist at os level...
>
> you need to rm it...
>
> check it...
>
> HTH
> JL
>
> --- Hamid Alavi <[EMAIL PROTECTED]> wrote:
> > Hi List,
> >
> > Today I have dropped a big tablespace(4 Gig) as soon
> > as I dropped it the
> > data file also disappeared from the list of
> > datafiles, as I know the
> > datafile must be removed manually Any idea?
> >
> > I am using 9.0.1 on solaris 2.8
> >
> > Thanks,
> >
> > Hamid Alavi
> >
> > Office  :  818-737-0526
> > Cell phone  :  818-416-5095
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > --
> > Author: Hamid Alavi
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California-- Mailing list and web
> > hosting services
> >
> -
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jose Luis Delgado
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
> message BODY, include a line containing: UNSUB ORACLE-L (or the name of
> mailing list you want to be removed from).  You may also send the HELP
> command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ramon E. Estevez
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Pod

Re: Drop Tablespace

2003-07-01 Thread AK

datafiles gone from v$datafile or from OS ?  If it's from your controlfile
then this is okay . But u will have to remove os files manually .
-ak

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 01, 2003 1:35 PM


> Hi List,
>
> Today I have dropped a big tablespace(4 Gig) as soon as I dropped it the
> data file also disappeared from the list of datafiles, as I know the
> datafile must be removed manually Any idea?
>
> I am using 9.0.1 on solaris 2.8
>
> Thanks,
>
> Hamid Alavi
>
> Office  :  818-737-0526
> Cell phone  :  818-416-5095
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Hamid Alavi
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: AK
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Drop Tablespace

Yep, if you type drop tablespace  including contents and datafiles;
the datafiles are removed.

Also, if you are using OMF (oracle managed files) by some odd reason then
dropping tablespace also deletes the datafiles, even if you don't specify
"including contents and datafiles" option.

A small example below..
Tanel.

SQL> alter session set db_create_file_dest="G:\";

Session altered.

SQL> create tablespace g;

Tablespace created.

SQL> select name from v$datafile;

NAME


C:\ORACLE\ORA92\ORCL\SYSTEM01.DBF
C:\ORACLE\ORA92\ORCL\UNDOTBS01.DBF
C:\ORACLE\ORA92\ORCL\CWMLITE01.DBF
C:\ORACLE\ORA92\ORCL\DRSYS01.DBF
C:\ORACLE\ORA92\ORCL\EXAMPLE01.DBF
C:\ORACLE\ORA92\ORCL\INDX01.DBF
C:\ORACLE\ORA92\ORCL\ODM01.DBF
C:\ORACLE\ORA92\ORCL\TOOLS01.DBF
C:\ORACLE\ORA92\ORCL\USERS01.DBF
C:\ORACLE\ORA92\ORCL\XDB01.DBF
C:\ORACLE\ORA92\ORCL\TS2K01.DBF

NAME


G:\O1_MF_G_ZJ3XXJ00_.DBF

12 rows selected.

SQL> ho dir G:\O1_MF_G_ZJ3XXJ00_.DBF
 Volume in drive G has no label.
 Volume Serial Number is 7042-6228

 Directory of G:\

02.07.2003  00:05  104 865 792 O1_MF_G_ZJ3XXJ00_.DBF
   1 File(s)104 865 792 bytes
   0 Dir(s) 298 082 304 bytes free

SQL> drop tablespace g;

Tablespace dropped.

SQL> ho dir G:\O1_MF_G_ZJ3XXJ00_.DBF
 Volume in drive G has no label.
 Volume Serial Number is 7042-6228

 Directory of G:\

File Not Found

SQL>


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 02, 2003 12:28 AM


> There's a new feature in 9i that can remove the os file also
>
> Ramon E. Estevez
> [EMAIL PROTECTED]
> 809-535-8994
>
>
>
> -Original Message-
> Jose Luis Delgado
> Sent: Tuesday, July 01, 2003 5:13 PM
> To: Multiple recipients of list ORACLE-L
>
>
> It dissappered from the data dict...
>
> but it should exist at os level...
>
> you need to rm it...
>
> check it...
>
> HTH
> JL
>
> --- Hamid Alavi <[EMAIL PROTECTED]> wrote:
> > Hi List,
> >
> > Today I have dropped a big tablespace(4 Gig) as soon
> > as I dropped it the
> > data file also disappeared from the list of
> > datafiles, as I know the
> > datafile must be removed manually Any idea?
> >
> > I am using 9.0.1 on solaris 2.8
> >
> > Thanks,
> >
> > Hamid Alavi
> >
> > Office  :  818-737-0526
> > Cell phone  :  818-416-5095
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > --
> > Author: Hamid Alavi
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California-- Mailing list and web
> > hosting services
> >
> -
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jose Luis Delgado
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
> message BODY, include a line containing: UNSUB ORACLE-L (or the name of
> mailing list you want to be removed from).  You may also send the HELP
> command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ramon E. Estevez
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services

RE: Drop Tablespace

2003-07-01 Thread DENNIS WILLIAMS

Hamid
   Is there any chance this was created as an Oracle Managed File (OMF)?
http://otn.oracle.com/products/oracle9i/daily/04.html

They have special file names.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Tuesday, July 01, 2003 3:35 PM
To: Multiple recipients of list ORACLE-L


Hi List,

Today I have dropped a big tablespace(4 Gig) as soon as I dropped it the
data file also disappeared from the list of datafiles, as I know the
datafile must be removed manually Any idea?

I am using 9.0.1 on solaris 2.8

Thanks,

Hamid Alavi

Office  :  818-737-0526
Cell phone  :  818-416-5095

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Do Not Call

2003-07-01 Thread Michael Kline




Punched cards and a sorter. Then COBOL with 
indexed files once
loaded sequentially.
 


Michael KlineBusiness to Business 
SolutionsRichmond, 
VA804-744-1545

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of TOMPKINS, 
  MARGARETSent: Tuesday, July 01, 2003 4:55 PMTo: Multiple 
  recipients of list ORACLE-LSubject: RE: Do Not 
  Call
  That's only on the GUI side.  The 
  backend is an Excel spreadsheet with embedded FORTRAN calls.  That gets 
  interfaced with all the assembler code.   :-)
  Respectfully, Maggie Tompkins - 
  DCII Integration Technology 
  Services Organization - Kansas City Defense Finance and Accounting Service 816-926-1117 (DSN 465); 
  [EMAIL PROTECTED] 
  -Original Message-From: Goulet, Dick 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 01, 2003 3:15 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Do Not Call
  Now wait a minute, isn't that suppose to 
  be a government web site?  Therefore it must be a flat file processed by 
  an Ada backend.
   
  Dick GouletSenior Oracle DBAOracle Certified 8i DBA 
  -Original Message-From: Gene Sais 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 01, 2003 3:10 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Do Not Call
  http://uptime.netcraft.com/up/graph/?host=www.donotcall.gov
   
  Well, if it were unix then it couldn't be SQLserver.  It is Windows, 
  therefore I assume its SQLserver, but it could be Oracle.  But who runs 
  Oracle on Windows anyway *hahahaha*>>> 
  [EMAIL PROTECTED] 07/01/03 02:29PM >>>
  Paradox for DOS 
  -Original Message- From: Orr, Steve [mailto:[EMAIL PROTECTED]] Sent: 
  Tuesday, July 01, 2003 2:00 PM To: Multiple recipients of list ORACLE-L 
  Subject: Do Not Call 
  There have been over 10,000,000 entries made in the National Do Not Call 
  Registry since Friday June 27. Does anyone know the database engine in 
  which this is stored? 
  Curious in Bozeman, MT -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 
  Author: Orr, Steve   INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
  San Diego, California    -- Mailing 
  list and web hosting services 
  - 
  To REMOVE yourself from this mailing list, send an E-Mail message to: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the 
  message BODY, include a line containing: UNSUB ORACLE-L (or the name of 
  mailing list you want to be removed from).  You may also send the 
  HELP command for other information (like subscribing).

RE: Oracle DBA 9i Books ever needed.

2003-07-01 Thread Cary Millsap

I'll second the recommendation of Christopher Lawson's new book. Very nice.

By not mentioning Gaja and Kirti's work explicitly in the first
sentence should not be considered a withholding of endorsement. My opinion
of their work is--hey!--right on the cover.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic 101 in Dallas, Washington, Denver, Sydney
- Hotsos Symposium 2004, March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
DENNIS WILLIAMS
Sent: Tuesday, July 01, 2003 11:00 AM
To: Multiple recipients of list ORACLE-L

Rajuveera
   Are you seeking a book on DBA (administration) or performance tuning or
real time database design? The more specific the question, the more likely
the answer will match your needs. If you have some books, don't be shy about
mentioning them so you don't just get recommendations that include books you
already have. Since most of us collect books, if you say what you need that
isn't included in your existing books, we can recommend books that cover
different material.
   For performance tuning, a great book to start with is:
Oracle 101 Performance Tuning by Jaga Krishna Vaidyanatha, Kirtikumar
Deshpande, and John Kostelac.
   I have also been impressed with:
The Art and Science of Oracle Performance Tuning by Christopher Lawson. This
is very new, just published. 
Both of these books emphasize the fact that successful performance tuning
begins with a correct philosophy. With a mistaken philosophy you can spend a
lot of time and may even think you are being successful.
   There are two aspects to performance tuning, tuning the system and tuning
your SQL. Which is more important will vary by your situation and as a
competent DBA you need to understand both. For example, some packaged
applications do not allow you to tune the SQL at all. But often tuning SQL
statements can yield great gains in performance.
   As to the other topics you mention, perhaps it would be best if you reply
with more specifics as to your situation.
   Sitting here in the U.S., it is rather difficult for me to tell what
books are available to you in Hyderabad. Can you buy books from
www.amazon.com?
   Getting a book that applies to both 8i and 9i is easy, in my experience.
When a new Oracle version arrives, publishers often brush up an existing
book with some new information so they can place the new version number on
the book. It takes awhile for authors to absorb the impact that the changes
can have on the daily work of a DBA and produce a book that incorporates
these changes. I'm just trying to accurately represent the situation, not
being critical. Fortunately when Oracle creates a new version, 99% of the
features already there still work. Just familiarize yourself with the main
feature differences between versions and you'll be fine with any book.
   I will be on vacation for several days, so if you are sleeping when this
reply is posted, I will be unable to reply. However, there are others on
this list that can provide far more competent assistance than I, even
including some book authors.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, July 01, 2003 3:40 AM
To: Multiple recipients of list ORACLE-L


Dear Friends,

I am willing to buy Oracle DBA 9i books. ,I need your suggestion on this. 

I got information friends from this list that the book ("Practical Oracle 8i
- Jonathan Lewis".) is practically good.  Even I am also looking for the
same kind of book, But I want it for both 8i and 9i. It should be more
practical oriented , performance tuning and real time database design and
problems. The book should be more practical oriented .

What abt performance tuning 101 techniques , Oracle 9i DBA handbook.
What are the best books for Oracle DBA (Intermediate level ) available in
INDIA , HYDERABAD.

Any URL / best sites also will be helpful.
Thanks
Rajuveera


** 
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.
**
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Veeraraju_Mareddi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EM

RE: nt script


FIND or FINDSTR should work equally well, I think.  Maybe it depends on
your exact platform.

-Original Message-
Sent: Tuesday, July 01, 2003 5:07 PM
To: Multiple recipients of list ORACLE-L


Hi...

I could not follow this thread, so, I do not know the
current status...

anyway... I tested this and it works...

1.- First, I saw that you asked for: string called ORA
and your errorlevel statement failed.

2.- Second, the script sent by: Seefelt, Beth looks
like it works (I did not test it), EXCEPT that you
HAVE to change this line:

> FIND "ORA-03313" psprcsrv_psnt_%MMDD%.log

with this one:

> FINDSTR "ORA-03313" psprcsrv_psnt_%MMDD%.log

HTH
JL

there you go... (modify at your own needs...)

copy con test.cmd
findstr "%1" alert_develop.log
if errorlevel 1 goto no
if errorlevel 0 goto si
:no
   echo no se encontr≤ la cadena: %1
   goto fin
:si
   echo si se encontr≤ la cadena: %1
:fin
ctrl-Z

--- "Seefelt, Beth" <[EMAIL PROTECTED]>
wrote:
> 
> That actually makes it alot easier
> 
> FOR /F "tokens=1-5 delims=/, " %%i in ('date/t') DO
> SET MMDD=%%j%%k
> if NOT EXIST psprcsrv_psnt_%MMDD%.log goto no_file
> FIND "ORA-03313" psprcsrv_psnt_%MMDD%.log
> if errorlevel 1 ( echo 'there is a match'
> d:\start_proc.bat )
> goto :EOF
> 
> :no_file
>   echo Can't find todays log!
>   exit /b 2
> 
> 
> 
> -Original Message-
> Sent: Tuesday, July 01, 2003 3:51 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Bob,
> 
> I tested it out, it works on one hard code file. If
> I set thisfile it
> works. But in reality, I need to find today's log,
> the log file name
> convention is always goes psprcsrv_psnt_0701.log
> with the date suffix to
> the end. I can't hard code the file name in the bat
> file. Is there
> anyway how to get around with this?
> 
> Thanks,
> 
> Joan
> 
> Bob Metelsky wrote:
> > 
> > Don't run it line by line
> > Save it to a file called myfind.bat
> > 
> > Then call from a command prompt
> > 
> > C:\> myfind.bat
> > 
> > Or click the batch file, be sure to leave the
> pause so you can see an
> > error if any. Once its working, you can then
> implemet blat as someone
> > suggested
> > 
> > Here is a version using variables
> > 
> >
>
##
> > 
> > [myfind.bat]
> > :: Find example by BMetelsky on 
> Friday-April-11-2003-9:22:53 AM
> > :: This script searches thefile for a string and
> if it finds it, sends
> > an email message to dbamail
> > :: 0 =is found
> > echo off
> > set themess=A Database SERVICE on %computername%
> is NOT running on
> > %date% at %time%
> > set [EMAIL PROTECTED]
> > set blatfile=D:\dbmon\blattext.txt
> > set thefile=D:\dbmon\runit.log
> > set subject=A DB SERVICE IS NOT RUNNING
> > set [EMAIL PROTECTED]
> > echo starting >%blatfile%
> > 
> > find "ERROR:" %thefile% >NUL
> > 
> > IF ERRORLEVEL 1 GOTO no
> > IF NOT ERRORLEVEL 1 GOTO yes
> > :no
> > goto end
> > 
> > :yes
> > echo A db service is down on
> %computername%>%blatfile%
> > blat D:\dbmon\blattext.txt -subject "%subject%"
> -to "%dbamail%" -i
> > "%from%" -body "%themess%"
> > goto end
> > 
> > :end
> > @exit
> > rem echo %errorlevel%
> > 
> >
>
##
> > 
> > > Hi Bob, thanks for the reply. I added your code
> and tested
> > > still no good. I tested the case without a
> match. Still go to run.
> > >
> > > Joan
> > >
> > > D:\oracle\admin>FORFILES
> > > -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log
>  -d+0 -c"CMD
> > > /c echo @FILE" PSPRCSRV_PSNT_0630.log
> PSPRCSRV_PSNT_0701.log
> > >
> > > D:\oracle\admin>echo on
> > >
> > > D:\oracle\admin>FORFILES
> > > -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log
>  -d+0 -c"CMD
> > > /c type d:\pslog
> [EMAIL PROTECTED]|findstr ORA-03113
> > > >D:\oracle\admin\test.log"
> > >
> > > D:\oracle\admin>rem FORFILES
> > > -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log
>  -d+0 -c"CMD
> > > /c type d:\p
> [EMAIL PROTECTED]|findstr ORA-03113"
> >NUL
> > >
> > > D:\oracle\admin>IF ERRORLEVEL 1 GOTO no
> > >
> > > D:\oracle\admin>IF NOT ERRORLEVEL 1 GOTO
> RUN_PROC
> > >
> > > D:\oracle\admin>rem d:\psfm\start_proc_sched.bat
> > >
> > > D:\oracle\admin>echo run
> > > run
> > >
> > > D:\oracle\admin>pause
> > > Press any key to continue . . .
> > >
> > > D:\oracle\admin>goto end
> > >
> > > D:\oracle\admin>echo "finished"
> > > "finished"
> > >
> > > D:\oracle\admin>rem if errorlevel 1
> @d:\psfm\start_proc_sched.bat
> > >
> > > Bob Metelsky wrote:
> > > >
> > > > echo off
> > > > @cls
> > > > find "ORA-124" C:\yourlog.txt >NUL
> > > >
> > > > IF ERRORLEVEL 1 GOTO no
> > > > IF NOT ERRORLEVEL 1 GOTO yes
> > > >
> > > > :no
> > > > ECHO NOT FOUND
> > > > goto end
> > > >
> > > > :yes
> > > >  ECHO String IS found
> > > > pause
> > > > goto end
> > > >
> > > > :end
> > > > exit
> > > >
> > > > >
> > > > > Hi listers,
> > > > >
> > > > > I am working on a nt script. I download
> FORFILE exe, it
> > > works fine.
> > > > > My intention is f

RE: Microsoft VS Oracle (again)

2003-07-01 Thread Gabriel Aragon

This is what I wanted to hear.. tks!

Gabriel

--- "Goulet, Dick" <[EMAIL PROTECTED]> wrote:
> Well, I'll be a little more forgiving than Raj
> has been.  Basically MicroSoft is just the "pot
> calling the kettle black".  
>  
> On the issue of price, well yes MicroSoft does
> have an edge, but that's just how they've eliminated
> all of their other competition over the years.  The
> product does not cost less than Oracle or DB2, it's
> just that MicroSoft can leverage the tremendous
> amounts of cash they have to offset the giveaway
> they're into.  I believe that was one of the points
> of the Antitrust suit they were embroiled in.  
>  
> On RAC they really have a long way to go.  If
> you want to do a federated database setup like
> MicroSoft states, just buy standard edition Oracle
> licenses & toss in a pile of database links.  Works
> the same way & you don't have to pay extra for it. 
> The whole idea of RAC is that when one node dies,
> for whatever reason, the data that node was hosting
> is not offline till you get it repaired. And
> actually you really do not need to do anything to
> your application to take advantage of RAC, except
> adjust your error handling to understand that a
> transaction needed to be resubmitted.
>  
> Overall I think MicroSoft's Achilles heel is
> Windows.  Their a one OS horse. Oracle is a multi OS
> horse that runs the same whatever the platform.  And
> BTW, Oracle runs RAC on Red Hat without any
> additional software, never mind that it runs on
> Linux in the first place.  Similar things can also
> be said for DB2, Sybase, and Informix.  When, if
> ever, Microsoft has a version of Sql*Server that
> runs as multiple independent processes on Linux then
> I'll give them a second look.  As long as their a
> single multi-threaded Windows only process they can
> stay in Redmond.  Also, yes they are the "fastest
> growing" database on the market, take a look at that
> copy of Windows 2000 Advanced Server you've got. 
> There's a copy of Sql*Server 2000 in there, and you
> can't uninstall it.  Billy G is still up to his old
> tricks.  The only solution to MicroSoft is forced
> divestiture.  Too bad that judge could not stand up
> to King George.
>  
> 
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA 
> 
> -Original Message-
> Sent: Tuesday, July 01, 2003 1:40 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Aargh ... 
> 
> you must be very brave telling a Oracle cult to move
> to SQL Server ... 
> 
> How do we know you are not Billy G using an alias
> ... 
> 
> 8>) 
> 
> Raj 
>

> 
> Rajendra dot Jamadagni at nospamespn dot com 
> All Views expressed in this email are strictly
> personal. 
> QOTD: Any clod can have facts, having an opinion is
> an art ! 
> 
> 
> -Original Message- 
> Sent: Tuesday, July 01, 2003 1:00 PM 
> To: Multiple recipients of list ORACLE-L 
> 
> 
> FYI 
> 
> One of my friends at Microsoft, (yes I must to 
> confess, I have friends at MS) gave me a "present", 
> it's a 4 cd's kit called "SQL Server 2000 for the 
> Oracle Customer", the kit consist in 4 cd's with 
> demos, docs, presentations, videos and a lot of
> stuff 
> showing why sql server is a better option as a DB 
> instead oracle, contains price lists, performance 
> evaluation and many other "information", maybe you'd
> 
> like to spend some of your time giving Billy a
> chance 
> to defend his product. The 4 cd's are available 
> (almost completely) as links in: 
> 
> http://www.microsoft.com/sql/oraclekit 
> 
> Any comments? 
> 
> Gabriel 
> 
> 


=
"Any dream worth having is a dream worth fighting for"(Cualquier sueño que valga la 
pena tener, es un sueño por el que vale la pena luchar)Charles Xavier

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gabriel Aragon
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

create imp and exp Oracle as single-task binaries?

2003-07-01 Thread Guang Mei

Hi:

I saw the following message while searching web for some tips to improve exp
speed. Has anyone tried this "un-supported" way and found improved
performance? Had any problems? I don't have a machine that I can try this.

Guang

-
Oracle Export/Import Scripts: How to create imp and exp Oracle as
single-task binaries
Posted by: Administrator


 If someone is interested in implementing the create a new Oracle import
binary as a single-task, see the steps below.

The import and export programs (imp/exp) run in two task mode to protect the
SGA from potential corruption by user programs. By relinking these two
programs in single task mode you can gain much improvement in speed. In many
cases up to 30%.

To read the complete article, click on the Read more ... link.

Submitted by our member: Chris


Oracle themselves use this method although it is NOT supported by Oracle.

Running in single-task is much faster but it requires more memory since the
Oracle executable's text is no longer shared between the front-end and
background processes. If you need to transfer large amounts of data between
databases, relink the executale for greater efficiency.

To relink the RDBMS kernel and create the two new imp/exp programs, use the
following:

$ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk singletask
$ make -f ins_rdbms.mk expst
$ make -f ins_rdbms.mk impst
$ make -f ins_rdbms.mk sqlldrst
$ mv expst $ORACLE_HOME/bin/
$ mv impst $ORACLE_HOME/bin/
$ mv sqlldrst $ORACLE_HOME/bin/

Now use expst and impst instead of imp or exp when doing export & import of
data.

Let me know if you have any problems, or improve the above procedure
somehow.

Thanks.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Guang Mei
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: nt script

Seefelt,

It picked up the right log. however, it ended up run errorleverl 1 in
any condition (with or without a match). Isn't that interesting?

Joan

"Seefelt, Beth" wrote:
> 
> That actually makes it alot easier
> 
> FOR /F "tokens=1-5 delims=/, " %%i in ('date/t') DO SET MMDD=%%j%%k
> if NOT EXIST psprcsrv_psnt_%MMDD%.log goto no_file
> FIND "ORA-03313" psprcsrv_psnt_%MMDD%.log
> if errorlevel 1 ( echo 'there is a match'
>   d:\start_proc.bat )
> goto :EOF
> 
> :no_file
>   echo Can't find todays log!
>   exit /b 2
> 
> -Original Message-
> Sent: Tuesday, July 01, 2003 3:51 PM
> To: Multiple recipients of list ORACLE-L
> 
> Bob,
> 
> I tested it out, it works on one hard code file. If I set thisfile it
> works. But in reality, I need to find today's log, the log file name
> convention is always goes psprcsrv_psnt_0701.log with the date suffix to
> the end. I can't hard code the file name in the bat file. Is there
> anyway how to get around with this?
> 
> Thanks,
> 
> Joan
> 
> Bob Metelsky wrote:
> >
> > Don't run it line by line
> > Save it to a file called myfind.bat
> >
> > Then call from a command prompt
> >
> > C:\> myfind.bat
> >
> > Or click the batch file, be sure to leave the pause so you can see an
> > error if any. Once its working, you can then implemet blat as someone
> > suggested
> >
> > Here is a version using variables
> >
> > ##
> >
> > [myfind.bat]
> > :: Find example by BMetelsky on  Friday-April-11-2003-9:22:53 AM
> > :: This script searches thefile for a string and if it finds it, sends
> > an email message to dbamail
> > :: 0 =is found
> > echo off
> > set themess=A Database SERVICE on %computername% is NOT running on
> > %date% at %time%
> > set [EMAIL PROTECTED]
> > set blatfile=D:\dbmon\blattext.txt
> > set thefile=D:\dbmon\runit.log
> > set subject=A DB SERVICE IS NOT RUNNING
> > set [EMAIL PROTECTED]
> > echo starting >%blatfile%
> >
> > find "ERROR:" %thefile% >NUL
> >
> > IF ERRORLEVEL 1 GOTO no
> > IF NOT ERRORLEVEL 1 GOTO yes
> > :no
> > goto end
> >
> > :yes
> > echo A db service is down on %computername%>%blatfile%
> > blat D:\dbmon\blattext.txt -subject "%subject%" -to "%dbamail%" -i
> > "%from%" -body "%themess%"
> > goto end
> >
> > :end
> > @exit
> > rem echo %errorlevel%
> >
> > ##
> >
> > > Hi Bob, thanks for the reply. I added your code and tested
> > > still no good. I tested the case without a match. Still go to run.
> > >
> > > Joan
> > >
> > > D:\oracle\admin>FORFILES
> > > -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0 -c"CMD
> > > /c echo @FILE" PSPRCSRV_PSNT_0630.log PSPRCSRV_PSNT_0701.log
> > >
> > > D:\oracle\admin>echo on
> > >
> > > D:\oracle\admin>FORFILES
> > > -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0 -c"CMD
> > > /c type d:\pslog [EMAIL PROTECTED]|findstr ORA-03113
> > > >D:\oracle\admin\test.log"
> > >
> > > D:\oracle\admin>rem FORFILES
> > > -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0 -c"CMD
> > > /c type d:\p [EMAIL PROTECTED]|findstr ORA-03113" >NUL
> > >
> > > D:\oracle\admin>IF ERRORLEVEL 1 GOTO no
> > >
> > > D:\oracle\admin>IF NOT ERRORLEVEL 1 GOTO RUN_PROC
> > >
> > > D:\oracle\admin>rem d:\psfm\start_proc_sched.bat
> > >
> > > D:\oracle\admin>echo run
> > > run
> > >
> > > D:\oracle\admin>pause
> > > Press any key to continue . . .
> > >
> > > D:\oracle\admin>goto end
> > >
> > > D:\oracle\admin>echo "finished"
> > > "finished"
> > >
> > > D:\oracle\admin>rem if errorlevel 1 @d:\psfm\start_proc_sched.bat
> > >
> > > Bob Metelsky wrote:
> > > >
> > > > echo off
> > > > @cls
> > > > find "ORA-124" C:\yourlog.txt >NUL
> > > >
> > > > IF ERRORLEVEL 1 GOTO no
> > > > IF NOT ERRORLEVEL 1 GOTO yes
> > > >
> > > > :no
> > > > ECHO NOT FOUND
> > > > goto end
> > > >
> > > > :yes
> > > >  ECHO String IS found
> > > > pause
> > > > goto end
> > > >
> > > > :end
> > > > exit
> > > >
> > > > >
> > > > > Hi listers,
> > > > >
> > > > > I am working on a nt script. I download FORFILE exe, it
> > > works fine.
> > > > > My intention is finding the ORA-03113 string in the log.
> > > If there is
> > > > > a match, then reboot the server, else do nothing. I don't have
> > > > > problem with the findstr part. However, the errorlevel
> > > always return
> > > > > 0, no matter it find the error or not. So the if statement is
> not
> > > > > working. Can somebody give me some light on NT syntax? On
> > > unix, it
> > > > > is so easy to script the condition. Please help,
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Joan
> > > > >
> > > > >
> > > > >  FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log
> > > > > -d+0 -c"CMD /c type
> > > > > d:[EMAIL PROTECTED]|findstr ORA-03113" if
> > > > > errorlevel 1 goto run_proc echo 'there is a match'
> > > > >
> > > > > if errorlevel 0 goto end
> > > > > echo 'there is no match'
> > > > >
> > > > > :run_proc
> > > > > d:\start_proc.bat

RE: Microsoft VS Oracle (again)

2003-07-01 Thread Johnston, Tim

Title: RE: Microsoft VS Oracle (again)



"Also, 
yes they are the "fastest growing" database on the market, take a look at that 
copy of Windows 2000 Advanced Server you've got."
 
And, I 
think all the exchange servers now have Sql*Server as a back end...  
Considering they almost own that corner of the market, I bet that adds up to a 
license or two...
 
Tim

  -Original Message-From: Goulet, Dick 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 01, 2003 4:11 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Microsoft VS Oracle (again)
      Well, I'll be a little more forgiving than Raj has 
  been.  Basically MicroSoft is just the "pot calling the kettle 
  black".  
   
      On the issue of price, well yes MicroSoft does have 
  an edge, but that's just how they've eliminated all of their other competition 
  over the years.  The product does not cost less than Oracle or DB2, it's 
  just that MicroSoft can leverage the tremendous amounts of cash they have to 
  offset the giveaway they're into.  I believe that was one of the points 
  of the Antitrust suit they were embroiled in.  
   
      On RAC they really have a long way to 
  go.  If you want to do a federated database setup like 
  MicroSoft states, just buy standard edition Oracle licenses & toss in a 
  pile of database links.  Works the same way & you don't have to pay 
  extra for it.  The whole idea of RAC is that when one node dies, for 
  whatever reason, the data that node was hosting is not offline till you get it 
  repaired. And actually you really do not need to do anything to your 
  application to take advantage of RAC, except adjust your error handling to 
  understand that a transaction needed to be resubmitted.
   
      Overall I think MicroSoft's Achilles heel is 
  Windows.  Their a one OS horse. Oracle is a multi OS horse that runs the 
  same whatever the platform.  And BTW, Oracle runs RAC on Red Hat without 
  any additional software, never mind that it runs on Linux in the first 
  place.  Similar things can also be said for DB2, Sybase, and 
  Informix.  When, if ever, Microsoft has a version of Sql*Server that runs 
  as multiple independent processes on Linux then I'll give them a second 
  look.  As long as their a single multi-threaded Windows only process they 
  can stay in Redmond.  Also, yes they are the "fastest growing" database 
  on the market, take a look at that copy of Windows 2000 Advanced Server you've 
  got.  There's a copy of Sql*Server 2000 in there, and you can't uninstall 
  it.  Billy G is still up to his old tricks.  The only solution to 
  MicroSoft is forced divestiture.  Too bad that judge could not stand up 
  to King George.
   
  Dick GouletSenior Oracle DBAOracle Certified 8i DBA 
  
  -Original Message-From: Jamadagni, Rajendra 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 01, 2003 
  1:40 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Microsoft VS Oracle (again)
  Aargh ... 
  you must be very brave telling a Oracle cult to move to SQL 
  Server ... 
  How do we know you are not Billy G using an alias ... 
  
  8>) 
  Raj  
  Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. 
  QOTD: Any clod can have facts, having an opinion is an art 
  ! 
  -Original Message- From: 
  Gabriel Aragon [mailto:[EMAIL PROTECTED]] 
  Sent: Tuesday, July 01, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Subject: Microsoft VS Oracle (again) 
  FYI 
  One of my friends at Microsoft, (yes I must to 
  confess, I have friends at MS) gave me a "present", 
  it's a 4 cd's kit called "SQL Server 2000 for the 
  Oracle Customer", the kit consist in 4 cd's with 
  demos, docs, presentations, videos and a lot of stuff 
  showing why sql server is a better option as a DB 
  instead oracle, contains price lists, performance 
  evaluation and many other "information", maybe you'd 
  like to spend some of your time giving Billy a chance 
  to defend his product. The 4 cd's are available 
  (almost completely) as links in: 
  http://www.microsoft.com/sql/oraclekit 
  
  Any comments? 
  Gabriel

RE: Do Not Call

2003-07-01 Thread TOMPKINS, MARGARET




Yeah.  It was either that or a Turing 
machine.  Maggie 
 
-Original Message-From: Thater, 
William [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 
01, 2003 4:20 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Do Not Call
 

  -Original Message-From: TOMPKINS, MARGARET 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 01, 2003 
  4:55 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Do Not Call
  That's only on the GUI side.  The 
  backend is an Excel spreadsheet with embedded FORTRAN calls.  That gets 
  interfaced with all the assembler code.   :-)[Shrek] 
   
  running BAP 
  on TOS on the old GE box, eh?
   
  --
  Bill 
  "Shrek" Thater ORACLE 
  DBA  BAARF Party member #25
      
  [EMAIL PROTECTED]
  
  Through the 
  release of atomic energy, our generation has brought into the world the most 
  revolutionary force since prehistoric man's discovery of fire. This basic 
  force of the universe cannot be fitted into the outmoded concept of narrow 
  nationalisms. For there is no secret and there is no defence; there is no 
  possibility of control except through the aroused understanding and insistence 
  of the peoples of the world. We scientists recognise our inescapable 
  responsibility to carry to our fellow citizens an understanding of atomic 
  energy and its implication for society. In this lies our only security and our 
  only hope - we believe that an informed citizen will act for life and not for 
  death. - Albert Einstein

RE: Drop Tablespace

2003-07-01 Thread Ramon E. Estevez

There's a new feature in 9i that can remove the os file also

Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994

-Original Message-
Jose Luis Delgado
Sent: Tuesday, July 01, 2003 5:13 PM
To: Multiple recipients of list ORACLE-L

It dissappered from the data dict...

but it should exist at os level...

you need to rm it...

check it...

HTH
JL

--- Hamid Alavi <[EMAIL PROTECTED]> wrote:
> Hi List,
> 
> Today I have dropped a big tablespace(4 Gig) as soon
> as I dropped it the
> data file also disappeared from the list of
> datafiles, as I know the
> datafile must be removed manually Any idea?
> 
> I am using 9.0.1 on solaris 2.8
> 
> Thanks,
> 
> Hamid Alavi
> 
> Office  :  818-737-0526
> Cell phone  :  818-416-5095
> 
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Hamid Alavi
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ramon E. Estevez
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Do Not Call

2003-07-01 Thread Thater, William




 

  -Original Message-From: TOMPKINS, MARGARET 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 01, 2003 
  4:55 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Do Not Call
  That's only on the GUI side.  The 
  backend is an Excel spreadsheet with embedded FORTRAN calls.  That gets 
  interfaced with all the assembler code.   :-)[Shrek] 
   
  running BAP 
  on TOS on the old GE box, eh?
   
  --
  Bill 
  "Shrek" Thater ORACLE 
  DBA  BAARF Party member #25
      
  [EMAIL PROTECTED]
  
  Through the 
  release of atomic energy, our generation has brought into the world the most 
  revolutionary force since prehistoric man's discovery of fire. This basic 
  force of the universe cannot be fitted into the outmoded concept of narrow 
  nationalisms. For there is no secret and there is no defence; there is no 
  possibility of control except through the aroused understanding and insistence 
  of the peoples of the world. We scientists recognise our inescapable 
  responsibility to carry to our fellow citizens an understanding of atomic 
  energy and its implication for society. In this lies our only security and our 
  only hope - we believe that an informed citizen will act for life and not for 
  death. - Albert Einstein

RE: Should percent increase higher than 0 in 817?

2003-07-01 Thread Thater, William

Gogala, Mladen  scribbled on the wall in glitter crayon:

> What about ones that you don't know?

ones you don't know can hurt you.;-)

--
Bill "Shrek" Thater ORACLE DBA  BAARF Party member #25
[EMAIL PROTECTED]

It's no coincidence that in no known language does the phrase "As pretty as
an airport" appear. - Douglas Adams
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Drop Tablespace

2003-07-01 Thread Stephane Faroult

Normal behaviour. If you say 'drop' to Oracle it knows it no longer has
to care about it, and so does it. From then, the file has no more
special for Oracle than say your background wallpaper image.

Hamid Alavi wrote:
> 
> Hi List,
> 
> Today I have dropped a big tablespace(4 Gig) as soon as I dropped it the
> data file also disappeared from the list of datafiles, as I know the
> datafile must be removed manually Any idea?
> 
> I am using 9.0.1 on solaris 2.8
> 
> Thanks,
> 
> Hamid Alavi
> 
> Office  :  818-737-0526
> Cell phone  :  818-416-5095
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Hamid Alavi
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Need Script!!

2003-07-01 Thread Jose Luis Delgado

Hi Senthil...

I think you can get software from the internet...

but... if you need to do it at command level...
I would try a telnet to the 25 port...

If you need assistance, I can create something similar
here at work... and send it to you, just for sending
mails...

HTH
JL

--- Senthil Kumar D <[EMAIL PROTECTED]>
wrote:
> Hi Group,
> 
> In one of our client place we are having Oracle
> 8.1.7 (std Ed) on NT.
> 
> Here we need to send mails if the DB is down or if
> the listener is down or
> any errors in the alert log is found. In Unix we can
> use shell scripts and
> awk to do this. What about in NT/
> 
> Guru's do you have any scripts to do the same.
> 
> Please help me in this.
> 
> TIA,
> Senthil.
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Senthil Kumar D
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Upgrade 8.1.7.3.0 to 8.1.7.4.1 on W2K

2003-07-01 Thread Jared . Still

Assuming that you are changing the second Oracle Home, ie.  Home1.

Change the following entries in the registry:

HKLM\Software\Oracle\ALL_HOMES\ID1\PATH

HKLM\Software\Oracle\HOME1\ORACLE_HOME

Depending on how you've located init and dump files, etc., you
may see other entries in HKLM\Software\Oracle\HOME1 that 
need to be changed as well.

You then need to remove and re-create the service.

oradim -delete -sid SID

oradim -new -sid SID  -pfile 

type oradmin on a command line to get all options.

Then check HKLM\System\CurrentControlSet\Services\OracleService
to ensure that the correct binary is in use.

Edit your tnsnames.ora/names registry or whatever you use for name 
resolution.

That should about do it.

Jared






Jack van Zanen <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 07/01/2003 08:55 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Upgrade 8.1.7.3.0 to 8.1.7.4.1 on W2K


Hi All, 

We have a test machine with both the 81730 and 81741 software in their own 
oracle homes. 
We now want to move a database from the 81730 home to 81741 
I know I have to run the catalog.sql, catproc.sql from the new home etc... 
But how do I tell the registry that the database moved homes?? 

TiA 
Jacob A. van Zanen 
Oracle DBA 
Quant Systems Europe b.v. 
Tel : +31 (0) 251 - 268 268 
Mobile: +31 (0) 6 51308813 
Fax: +31 (0) 251 - 268 269 
E-mail: [EMAIL PROTECTED] 
Visit our web site at http://www.quantsystems.nl/ 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: nt script

2003-07-01 Thread Jose Luis Delgado

Hi...

I could not follow this thread, so, I do not know the
current status...

anyway... I tested this and it works...

1.- First, I saw that you asked for: string called ORA
and your errorlevel statement failed.

2.- Second, the script sent by: Seefelt, Beth looks
like it works (I did not test it), EXCEPT that you
HAVE to change this line:

> FIND "ORA-03313" psprcsrv_psnt_%MMDD%.log

with this one:

> FINDSTR "ORA-03313" psprcsrv_psnt_%MMDD%.log

HTH
JL

there you go... (modify at your own needs...)

copy con test.cmd
findstr "%1" alert_develop.log
if errorlevel 1 goto no
if errorlevel 0 goto si
:no
   echo no se encontr≤ la cadena: %1
   goto fin
:si
   echo si se encontr≤ la cadena: %1
:fin
ctrl-Z

--- "Seefelt, Beth" <[EMAIL PROTECTED]>
wrote:
> 
> That actually makes it alot easier
> 
> FOR /F "tokens=1-5 delims=/, " %%i in ('date/t') DO
> SET MMDD=%%j%%k
> if NOT EXIST psprcsrv_psnt_%MMDD%.log goto no_file
> FIND "ORA-03313" psprcsrv_psnt_%MMDD%.log
> if errorlevel 1 ( echo 'there is a match'
> d:\start_proc.bat )
> goto :EOF
> 
> :no_file
>   echo Can't find todays log!
>   exit /b 2
> 
> 
> 
> -Original Message-
> Sent: Tuesday, July 01, 2003 3:51 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Bob,
> 
> I tested it out, it works on one hard code file. If
> I set thisfile it
> works. But in reality, I need to find today's log,
> the log file name
> convention is always goes psprcsrv_psnt_0701.log
> with the date suffix to
> the end. I can't hard code the file name in the bat
> file. Is there
> anyway how to get around with this?
> 
> Thanks,
> 
> Joan
> 
> Bob Metelsky wrote:
> > 
> > Don't run it line by line
> > Save it to a file called myfind.bat
> > 
> > Then call from a command prompt
> > 
> > C:\> myfind.bat
> > 
> > Or click the batch file, be sure to leave the
> pause so you can see an
> > error if any. Once its working, you can then
> implemet blat as someone
> > suggested
> > 
> > Here is a version using variables
> > 
> >
>
##
> > 
> > [myfind.bat]
> > :: Find example by BMetelsky on 
> Friday-April-11-2003-9:22:53 AM
> > :: This script searches thefile for a string and
> if it finds it, sends
> > an email message to dbamail
> > :: 0 =is found
> > echo off
> > set themess=A Database SERVICE on %computername%
> is NOT running on
> > %date% at %time%
> > set [EMAIL PROTECTED]
> > set blatfile=D:\dbmon\blattext.txt
> > set thefile=D:\dbmon\runit.log
> > set subject=A DB SERVICE IS NOT RUNNING
> > set [EMAIL PROTECTED]
> > echo starting >%blatfile%
> > 
> > find "ERROR:" %thefile% >NUL
> > 
> > IF ERRORLEVEL 1 GOTO no
> > IF NOT ERRORLEVEL 1 GOTO yes
> > :no
> > goto end
> > 
> > :yes
> > echo A db service is down on
> %computername%>%blatfile%
> > blat D:\dbmon\blattext.txt -subject "%subject%"
> -to "%dbamail%" -i
> > "%from%" -body "%themess%"
> > goto end
> > 
> > :end
> > @exit
> > rem echo %errorlevel%
> > 
> >
>
##
> > 
> > > Hi Bob, thanks for the reply. I added your code
> and tested
> > > still no good. I tested the case without a
> match. Still go to run.
> > >
> > > Joan
> > >
> > > D:\oracle\admin>FORFILES
> > > -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log
>  -d+0 -c"CMD
> > > /c echo @FILE" PSPRCSRV_PSNT_0630.log
> PSPRCSRV_PSNT_0701.log
> > >
> > > D:\oracle\admin>echo on
> > >
> > > D:\oracle\admin>FORFILES
> > > -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log
>  -d+0 -c"CMD
> > > /c type d:\pslog
> [EMAIL PROTECTED]|findstr ORA-03113
> > > >D:\oracle\admin\test.log"
> > >
> > > D:\oracle\admin>rem FORFILES
> > > -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log
>  -d+0 -c"CMD
> > > /c type d:\p
> [EMAIL PROTECTED]|findstr ORA-03113"
> >NUL
> > >
> > > D:\oracle\admin>IF ERRORLEVEL 1 GOTO no
> > >
> > > D:\oracle\admin>IF NOT ERRORLEVEL 1 GOTO
> RUN_PROC
> > >
> > > D:\oracle\admin>rem d:\psfm\start_proc_sched.bat
> > >
> > > D:\oracle\admin>echo run
> > > run
> > >
> > > D:\oracle\admin>pause
> > > Press any key to continue . . .
> > >
> > > D:\oracle\admin>goto end
> > >
> > > D:\oracle\admin>echo "finished"
> > > "finished"
> > >
> > > D:\oracle\admin>rem if errorlevel 1
> @d:\psfm\start_proc_sched.bat
> > >
> > > Bob Metelsky wrote:
> > > >
> > > > echo off
> > > > @cls
> > > > find "ORA-124" C:\yourlog.txt >NUL
> > > >
> > > > IF ERRORLEVEL 1 GOTO no
> > > > IF NOT ERRORLEVEL 1 GOTO yes
> > > >
> > > > :no
> > > > ECHO NOT FOUND
> > > > goto end
> > > >
> > > > :yes
> > > >  ECHO String IS found
> > > > pause
> > > > goto end
> > > >
> > > > :end
> > > > exit
> > > >
> > > > >
> > > > > Hi listers,
> > > > >
> > > > > I am working on a nt script. I download
> FORFILE exe, it
> > > works fine.
> > > > > My intention is finding the ORA-03113 string
> in the log.
> > > If there is
> > > > > a match, then reboot the server, else do
> nothing. I don't have
> > > > > problem with the findstr part. However, the
> errorlevel

Re: Drop Tablespace

2003-07-01 Thread Jose Luis Delgado

It dissappered from the data dict...

but it should exist at os level...

you need to rm it...

check it...

HTH
JL

--- Hamid Alavi <[EMAIL PROTECTED]> wrote:
> Hi List,
> 
> Today I have dropped a big tablespace(4 Gig) as soon
> as I dropped it the
> data file also disappeared from the list of
> datafiles, as I know the
> datafile must be removed manually Any idea?
> 
> I am using 9.0.1 on solaris 2.8
> 
> Thanks,
> 
> Hamid Alavi
> 
> Office  :  818-737-0526
> Cell phone  :  818-416-5095
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Hamid Alavi
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Do Not Call

2003-07-01 Thread TOMPKINS, MARGARET




That's only on the GUI side.  The 
backend is an Excel spreadsheet with embedded FORTRAN calls.  That gets 
interfaced with all the assembler code.   :-)
Respectfully, Maggie Tompkins - DCII 
Integration Technology 
Services Organization - Kansas City Defense Finance and Accounting Service 816-926-1117 (DSN 465); 
[EMAIL PROTECTED] 
-Original Message-From: Goulet, Dick 
[mailto:[EMAIL PROTECTED]Sent: Tuesday, July 01, 2003 3:15 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: Do 
Not Call
Now wait a minute, isn't that suppose to be 
a government web site?  Therefore it must be a flat file processed by an 
Ada backend.
 
Dick GouletSenior Oracle DBAOracle Certified 8i DBA 
-Original Message-From: Gene Sais 
[mailto:[EMAIL PROTECTED]Sent: Tuesday, July 01, 2003 3:10 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: Do 
Not Call
http://uptime.netcraft.com/up/graph/?host=www.donotcall.gov
 
Well, if it were unix then it couldn't be SQLserver.  It is Windows, 
therefore I assume its SQLserver, but it could be Oracle.  But who runs 
Oracle on Windows anyway *hahahaha*>>> 
[EMAIL PROTECTED] 07/01/03 02:29PM >>>
Paradox for DOS 
-Original Message- From: Orr, Steve [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 
July 01, 2003 2:00 PM To: Multiple recipients of list ORACLE-L Subject: 
Do Not Call 
There have been over 10,000,000 entries made in the National Do Not Call 
Registry since Friday June 27. Does anyone know the database engine in 
which this is stored? 
Curious in Bozeman, MT -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 
Author: Orr, Steve   INET: [EMAIL PROTECTED] 
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com San 
Diego, California    -- Mailing list and 
web hosting services 
- To 
REMOVE yourself from this mailing list, send an E-Mail message to: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 
BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list 
you want to be removed from).  You may also send the HELP command for 
other information (like subscribing).

RE: Microsoft VS Oracle (again)

2003-07-01 Thread Richard Ji

Not familiar with SQL*Server but why not?  What's preventing it
from work?  I run Oracle under a Linux environment which runs
in VMware for my dev and test.  Also run a RAC under Linux using
VMware.  Other people have done RAC running under Windows under VMware.
So, what is it with SQL*Server that it won't work under VMware?
Just would like know.

Regards,

Richard

-Original Message-
Sent: Tuesday, July 01, 2003 4:47 PM
To: Multiple recipients of list ORACLE-L


Nope, does not work that way.  I've seen it tried.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Tuesday, July 01, 2003 4:15 PM
To: Multiple recipients of list ORACLE-L


None.

Hmmm, maybe if you run VMware on Linux then you can run
SQL Server from a virtual machine.

Richard Ji

-Original Message-
Sent: Tuesday, July 01, 2003 3:00 PM
To: Multiple recipients of list ORACLE-L


On which unix boxes does SQL Server work? I don't want to 
replace all of my AIX, HP-UX and Solaris boxes with NT.
I'll consider SQL Server as a replacement as soon as it starts
operating on Unix. Microsoft operating systems have spurned the whole
industry trying to protect them from viruses, which makes them completely
unsuitable for a central database of a Fortune 500 company. Does
SQL Server work on Linux?

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, July 01, 2003 1:00 PM
To: Multiple recipients of list ORACLE-L


FYI

One of my friends at Microsoft, (yes I must to
confess, I have friends at MS) gave me a "present",
it's a 4 cd's kit called "SQL Server 2000 for the
Oracle Customer", the kit consist in 4 cd's with
demos, docs, presentations, videos and a lot of stuff
showing why sql server is a better option as a DB
instead oracle, contains price lists, performance
evaluation and many other "information", maybe you'd
like to spend some of your time giving Billy a chance
to defend his product. The 4 cd's are available
(almost completely) as links in:

http://www.microsoft.com/sql/oraclekit

Any comments?

Gabriel

=
"Any dream worth having is a dream worth fighting for"(Cualquier sueño que
valga la pena tener, es un sueño por el que vale la pena luchar)Charles
Xavier

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gabriel Aragon
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Ji
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-

RE: Should percent increase higher than 0 in 817?

What about ones that you don't know?

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, July 01, 2003 4:11 PM
To: Multiple recipients of list ORACLE-L


PCTINCREASE is a bad good thing.  Every DBA that I know of hunts down
objects with a pctincrease other than 0 and resets them.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Do Not Call

2003-07-01 Thread April Wells

Title: RE: Do Not Call





IMS...


HDAM database!


April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas


You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need.

~ Jerry Gillies ~




-Original Message-
From: Orr, Steve [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 01, 2003 2:58 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Do Not Call



Nah... Too current. It's probably COBOL/ISAM.



-Original Message-
Sent: Tuesday, July 01, 2003 1:15 PM
To: Multiple recipients of list ORACLE-L



Probably MS Access.


My $0.02 worth,


Ken Janusz, CPIM



- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 01, 2003 12:59 PM



> There have been over 10,000,000 entries made in the National Do Not 
> Call Registry since Friday June 27. Does anyone know the database 
> engine in which this is stored?
> 
> 
> Curious in Bozeman, MT
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

Drop Tablespace

2003-07-01 Thread Hamid Alavi

Hi List,

Today I have dropped a big tablespace(4 Gig) as soon as I dropped it the
data file also disappeared from the list of datafiles, as I know the
datafile must be removed manually Any idea?

I am using 9.0.1 on solaris 2.8

Thanks,

Hamid Alavi

Office  :  818-737-0526
Cell phone  :  818-416-5095

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: perl DBI/DBD: can I pass in an array as parameter?

2003-07-01 Thread Alex

not sure if this is what you want. one sql call

select  tab1.col1, tab2.col2 from tab1, tab2
where tab1.ID1 = tab2.ID2
and   tab1.X = ?
and   tab1.X = ?
and   tab1.X = ?
;

@my_array = (1,2,3);
sth->execute(@my_array);




On Tue, 1 Jul 2003, Guang Mei wrote:

> No. I want to reduce the numebr of sql calls.
>
> For example,
>
> @my_array = (1,2,3);
>
> I don't want to do
>
> select  tab1.col1, tab2.col2 from tab1, tab2
>where tab1.ID1 = tab2.ID2
>and   tab1.X = 1;
>
> select  tab1.col1, tab2.col2 from tab1, tab2
>where tab1.ID1 = tab2.ID2
>and   tab1.X = 2;
>
> select  tab1.col1, tab2.col2 from tab1, tab2
>where tab1.ID1 = tab2.ID2
>and   tab1.X = 3;
>
> because that would require three calls to Oracle. I want to pass @my_array
> in so the sql statment only run once and return all the rows. Similar to
> "forall ..."  in PL/SQL situation.
>
> Guang
>
> -Original Message-
> STEVE OLLIG
> Sent: Tuesday, July 01, 2003 2:56 PM
> To: Multiple recipients of list ORACLE-L
>
>
> if i get you right - you're trying to treat the resultset from a query as an
> array in Perl.  That's the way it works.  Try something like this:
>
> $sth = $dbh->prepare (" select  tab1.col1, tab2.col2 from tab1, tab2
>where tab1.ID1 = tab2.ID2
>and   tab1.X = ? ");
> my $resultset = $sth->execute("value for X");
> foreach (@$resultset) {
>   my($col1, $col2) = @$_;
>   # do more stuff
> }
>
> -Original Message-
> Sent: Tuesday, July 01, 2003 11:20 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi:
>
> Does anyone know if I can pass an array in perl to an sql using DBI/DBD so
> that I get result set from Oracle?
>
> Specifically, I want do something like in perl:
>
>
> $sth = $dbh->prepare (" select  tab1.col1, tab2.col2 from tab1, tab2
>where tab1.ID1 = tab2.ID2
>and   tab1.X = ? ");
>
> my @my_array;
>
> # filling in my_array with data here
>
> $sth->execute(@my_array);
>
> my ($col1, $col2);
> while(($col1, $col2) = $sth->fetchrow_array())  {
>
>   # do processing of $col1 and $col2;
> }
>
> I am hoping to save repeated sql calls, do only one call and get all the
> rows back.
>
> Is it possible in any version DBI/DBD? I looked at
>
> http://perldoc.com/perl5.6.1/lib/DBI.html
>
> and I does not seem to be able to figure it out. If it is possible, any
> simple example code somewhere?
>
> Thanks.
>
> Guang
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Guang Mei
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: STEVE OLLIG
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Guang Mei
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Alex
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be r

RE: nt script


That actually makes it alot easier

FOR /F "tokens=1-5 delims=/, " %%i in ('date/t') DO SET MMDD=%%j%%k
if NOT EXIST psprcsrv_psnt_%MMDD%.log goto no_file
FIND "ORA-03313" psprcsrv_psnt_%MMDD%.log
if errorlevel 1 ( echo 'there is a match'
  d:\start_proc.bat )
goto :EOF

:no_file
  echo Can't find todays log!
  exit /b 2



-Original Message-
Sent: Tuesday, July 01, 2003 3:51 PM
To: Multiple recipients of list ORACLE-L


Bob,

I tested it out, it works on one hard code file. If I set thisfile it
works. But in reality, I need to find today's log, the log file name
convention is always goes psprcsrv_psnt_0701.log with the date suffix to
the end. I can't hard code the file name in the bat file. Is there
anyway how to get around with this?

Thanks,

Joan

Bob Metelsky wrote:
> 
> Don't run it line by line
> Save it to a file called myfind.bat
> 
> Then call from a command prompt
> 
> C:\> myfind.bat
> 
> Or click the batch file, be sure to leave the pause so you can see an
> error if any. Once its working, you can then implemet blat as someone
> suggested
> 
> Here is a version using variables
> 
> ##
> 
> [myfind.bat]
> :: Find example by BMetelsky on  Friday-April-11-2003-9:22:53 AM
> :: This script searches thefile for a string and if it finds it, sends
> an email message to dbamail
> :: 0 =is found
> echo off
> set themess=A Database SERVICE on %computername% is NOT running on
> %date% at %time%
> set [EMAIL PROTECTED]
> set blatfile=D:\dbmon\blattext.txt
> set thefile=D:\dbmon\runit.log
> set subject=A DB SERVICE IS NOT RUNNING
> set [EMAIL PROTECTED]
> echo starting >%blatfile%
> 
> find "ERROR:" %thefile% >NUL
> 
> IF ERRORLEVEL 1 GOTO no
> IF NOT ERRORLEVEL 1 GOTO yes
> :no
> goto end
> 
> :yes
> echo A db service is down on %computername%>%blatfile%
> blat D:\dbmon\blattext.txt -subject "%subject%" -to "%dbamail%" -i
> "%from%" -body "%themess%"
> goto end
> 
> :end
> @exit
> rem echo %errorlevel%
> 
> ##
> 
> > Hi Bob, thanks for the reply. I added your code and tested
> > still no good. I tested the case without a match. Still go to run.
> >
> > Joan
> >
> > D:\oracle\admin>FORFILES
> > -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0 -c"CMD
> > /c echo @FILE" PSPRCSRV_PSNT_0630.log PSPRCSRV_PSNT_0701.log
> >
> > D:\oracle\admin>echo on
> >
> > D:\oracle\admin>FORFILES
> > -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0 -c"CMD
> > /c type d:\pslog [EMAIL PROTECTED]|findstr ORA-03113
> > >D:\oracle\admin\test.log"
> >
> > D:\oracle\admin>rem FORFILES
> > -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0 -c"CMD
> > /c type d:\p [EMAIL PROTECTED]|findstr ORA-03113" >NUL
> >
> > D:\oracle\admin>IF ERRORLEVEL 1 GOTO no
> >
> > D:\oracle\admin>IF NOT ERRORLEVEL 1 GOTO RUN_PROC
> >
> > D:\oracle\admin>rem d:\psfm\start_proc_sched.bat
> >
> > D:\oracle\admin>echo run
> > run
> >
> > D:\oracle\admin>pause
> > Press any key to continue . . .
> >
> > D:\oracle\admin>goto end
> >
> > D:\oracle\admin>echo "finished"
> > "finished"
> >
> > D:\oracle\admin>rem if errorlevel 1 @d:\psfm\start_proc_sched.bat
> >
> > Bob Metelsky wrote:
> > >
> > > echo off
> > > @cls
> > > find "ORA-124" C:\yourlog.txt >NUL
> > >
> > > IF ERRORLEVEL 1 GOTO no
> > > IF NOT ERRORLEVEL 1 GOTO yes
> > >
> > > :no
> > > ECHO NOT FOUND
> > > goto end
> > >
> > > :yes
> > >  ECHO String IS found
> > > pause
> > > goto end
> > >
> > > :end
> > > exit
> > >
> > > >
> > > > Hi listers,
> > > >
> > > > I am working on a nt script. I download FORFILE exe, it
> > works fine.
> > > > My intention is finding the ORA-03113 string in the log.
> > If there is
> > > > a match, then reboot the server, else do nothing. I don't have
> > > > problem with the findstr part. However, the errorlevel
> > always return
> > > > 0, no matter it find the error or not. So the if statement is
not
> > > > working. Can somebody give me some light on NT syntax? On
> > unix, it
> > > > is so easy to script the condition. Please help,
> > > >
> > > > Thanks,
> > > >
> > > > Joan
> > > >
> > > >
> > > >  FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log
> > > > -d+0 -c"CMD /c type
> > > > d:[EMAIL PROTECTED]|findstr ORA-03113" if
> > > > errorlevel 1 goto run_proc echo 'there is a match'
> > > >
> > > > if errorlevel 0 goto end
> > > > echo 'there is no match'
> > > >
> > > > :run_proc
> > > > d:\start_proc.bat
> > > > goto end
> > > >
> > > > :end
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > --
> > > > Author: Joan Hsieh
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > > > San Diego, California-- Mailing list and web
> > hosting services
> > > >
> > 
> > > > -
> > > > To REMOVE yourself from this mailing list, se

RE: Microsoft VS Oracle (again)

Nope, does not work that way.  I've seen it tried.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Tuesday, July 01, 2003 4:15 PM
To: Multiple recipients of list ORACLE-L


None.

Hmmm, maybe if you run VMware on Linux then you can run
SQL Server from a virtual machine.

Richard Ji

-Original Message-
Sent: Tuesday, July 01, 2003 3:00 PM
To: Multiple recipients of list ORACLE-L


On which unix boxes does SQL Server work? I don't want to 
replace all of my AIX, HP-UX and Solaris boxes with NT.
I'll consider SQL Server as a replacement as soon as it starts
operating on Unix. Microsoft operating systems have spurned the whole
industry trying to protect them from viruses, which makes them completely
unsuitable for a central database of a Fortune 500 company. Does
SQL Server work on Linux?

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, July 01, 2003 1:00 PM
To: Multiple recipients of list ORACLE-L


FYI

One of my friends at Microsoft, (yes I must to
confess, I have friends at MS) gave me a "present",
it's a 4 cd's kit called "SQL Server 2000 for the
Oracle Customer", the kit consist in 4 cd's with
demos, docs, presentations, videos and a lot of stuff
showing why sql server is a better option as a DB
instead oracle, contains price lists, performance
evaluation and many other "information", maybe you'd
like to spend some of your time giving Billy a chance
to defend his product. The 4 cd's are available
(almost completely) as links in:

http://www.microsoft.com/sql/oraclekit

Any comments?

Gabriel

=
"Any dream worth having is a dream worth fighting for"(Cualquier sueño que
valga la pena tener, es un sueño por el que vale la pena luchar)Charles
Xavier

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gabriel Aragon
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Ji
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Production Database stays up; copies will not recover

Hi!

Oracle can only guarantee database consistency and sanity when it's
underlying layers like OS and disk controllers do not fail.
Try:

Startup mount;
select distinct resetlogs_change# from v$datafile_header;

Do you see only one distinct change#?

Tanel.


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 01, 2003 8:34 PM


> Tru64 5.1
> 8.1.7.3
> We had a disk controller fail last week, but redundant hardware let the
> system stay up until it could be replaced over the weekend.  The
production
> database restarted without any problems, trace files, or alert log errors.
>
> The problem is that the reporting copy of production, taken from a disk
> mirror break (hot backup, mounted on a seperate system) will not recover.
I
> get an ORA-1190 'controlfile or data file 1 is from before the last
> RESETLOGS' but the last resetlogs was over a month ago.  First attempt to
> solve was to use a slightly older copy of the SYSTEM datafile from an
> earlier backup disk mirror break (hot backup). Results were the same.  I
> then assumed something was wrong with the controlfile, so I tried to
rebuild
> that.  No luck, the Create controlfile command returned a ORA1189 'file is
> from a different RESETLOGS than previous files' against file#2 (even
though
> I replaced the file# 1's datafile with the original [neither copy of #1
was
> opened]).
>
> My worries are two-fold; 1) that there is a subtle error in the control
file
> or SYSTEM datafile that only an attempted recovery exposes and 2) any
backup
> taken after the hardware failure last week will not be viable.
>
> Any suggestions as how to proceed to either prove or disprove this.
>
> Thanks,
> Mike Hand
> Polaroid Corp
>
> P.S.  I had hoped to go on vacation at the end of the week leaving a
stable
> database behind (for a change).
>
> This transmission is intended only for use by the addressee(s) named
herein and may contain information that is proprietary, confidential and/or
legally privileged. If you are not the intended recipient, you are hereby
notified that any disclosure, copying, distribution, or use of the
information contained herein (including any reliance thereon) is STRICTLY
PROHIBITED. If you received this transmission in error, please immediately
contact the sender and destroy the material in its entirety, whether in
electronic or hard copy format. Thank you.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Hand, Michael T
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Production Database stays up; copies will not recover

> Do you see only one distinct change#?

Note that if you got read only tablespaces, then it's ok to see more than
one distinct change#'s, but for read write's it should be the same.

Tanel.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Microsoft VS Oracle (again)

2003-07-01 Thread Richard Ji

None.

Hmmm, maybe if you run VMware on Linux then you can run
SQL Server from a virtual machine.

Richard Ji

-Original Message-
Sent: Tuesday, July 01, 2003 3:00 PM
To: Multiple recipients of list ORACLE-L


On which unix boxes does SQL Server work? I don't want to 
replace all of my AIX, HP-UX and Solaris boxes with NT.
I'll consider SQL Server as a replacement as soon as it starts
operating on Unix. Microsoft operating systems have spurned the whole
industry trying to protect them from viruses, which makes them completely
unsuitable for a central database of a Fortune 500 company. Does
SQL Server work on Linux?

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, July 01, 2003 1:00 PM
To: Multiple recipients of list ORACLE-L


FYI

One of my friends at Microsoft, (yes I must to
confess, I have friends at MS) gave me a "present",
it's a 4 cd's kit called "SQL Server 2000 for the
Oracle Customer", the kit consist in 4 cd's with
demos, docs, presentations, videos and a lot of stuff
showing why sql server is a better option as a DB
instead oracle, contains price lists, performance
evaluation and many other "information", maybe you'd
like to spend some of your time giving Billy a chance
to defend his product. The 4 cd's are available
(almost completely) as links in:

http://www.microsoft.com/sql/oraclekit

Any comments?

Gabriel

=
"Any dream worth having is a dream worth fighting for"(Cualquier sueño que
valga la pena tener, es un sueño por el que vale la pena luchar)Charles
Xavier

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gabriel Aragon
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Ji
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Tech meetings

Title: Message



The 
best meetings should be like the most efficient SQL statements...  
;-)
 

  
  -Original Message-From: M.Godlewski 
  [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 10:30 
  AMTo: Multiple recipients of list ORACLE-LSubject: Tech 
  meetings
  List,
   
  Just wondering if your organization has tech meetings, and what is 
  discussed and what the goals of the meetings are?
   
  I've been asked about this, and was wondering if there is a quick list 
  out there any where.
   
  TIA
   
  
  
  Do you Yahoo!?The New 
  Yahoo! Search - Faster. Easier. Bingo.

RE: printing out of Pl/SQL

Frank,

I've not done dll calls from Oracle as well, we use HP-UX and Linux, which I 
believe is much simpler.  Anyhow, along a similar lane, here's a snippet of extproc C 
code that I've written to run an SQR from a PL/SQL call:

char *run_sqr(char *prog, char *uname)
{  FILE *sout = NULL;
   FILE *lg = NULL;
   char cmd[1000];
   char bfr[200];
   char *rval = NULL;

   sprintf(cmd, "sqr %s %s -I/opt/psoft/fsdev75/sqr/ 
-M/opt/psoft/fsdev75/sqr/allmaxes.max -XB\n\0",
prog, uname);
   sout = popen(cmd,"r");
   if(sout)
   {  lg = fopen("/ora1/extproc.log","w");
  fprintf(lg, "%s", cmd);
  while(fgets(bfr, sizeof(bfr), sout))
  {  if(!strncmp(bfr, "ERROR", 5)) break;
 else fprintf(lg, "%s", bfr);
  }
  pclose(sout);
  fclose(lg);
   }
   else sprintf(bfr, "Error runnign SQR\0");
   rval = calloc(1, strlen(bfr)+3);
   if(rval) strcpy(rval, bfr);
   return(rval);
}

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Tuesday, July 01, 2003 11:20 AM
To: Multiple recipients of list ORACLE-L


Hi Dick,

> Could you use an extproc call to handle the printing of 
> the file & then deleting it?

I have never tried to use extproc, nor have I done dll function calls out of
PlSQL.
What version of Oracle can do this. We are using 8.0.6. Is it able to do
that ?
Someone give an example, on howto define .dll functions and call it ? 

any help is appreciated

> Frank <




Confidentiality Notes

This email and any files transmitted is intended only for the person or
entity to which it is addressed and may contain confidential and/or
privileged material. If you are not the authorised recipient, any use,
disclosure, copying, distribution or any action taken or omitted to be
taken in reliance on it, is prohibited. If you received this in error,
please contact the sender and delete the material from any computer.

E-mail messages are not necessarily secure. Scheidt & Bachmann does not
accept responsibility for any changes made to this message after it was
sent. 

Thank you for your cooperation!

Diese E-Mail und alle angehängten Dateien ist ausschließlich für die
Person / Personen bestimmt, an die diese adressiert ist und könnte
vertrauliche und / oder rechtlich geschützte Informationen enthalten.
Sollten Sie nicht der für diese E-Mail bestimmte Adressat oder nicht zum
Empfang berechtigt sein, ist Ihnen jeder Gebrauch, sowie jede
Veröffentlichung, Vervielfältigung oder Weitergabe wie auch das
Ergreifen oder Unterlassen von Maßnahmen im Vertrauen auf erlangte
Information untersagt. Sollten Sie diese E-Mail irrtümlich erhalten
haben, benachrichtigen Sie bitte den Absender und löschen diese E-Mail
von jedem Computer.

E-Mail-Mitteilungen sind nicht notwendigerweise sicher. Scheidt &
Bachmann übernimmt keine Verantwortung für Veränderungen dieser
Mitteilung, die nach dem Senden vorgenommen wurden. 

Herzlichen Dank für Ihre Unterstützung!


-



>-Ursprüngliche Nachricht-
>Von: Goulet, Dick [mailto:[EMAIL PROTECTED]
>Gesendet am: Dienstag, 1. Juli 2003 15:49
>An: Multiple recipients of list ORACLE-L
>Betreff: RE: printing out of Pl/SQL
>

>
>Dick Goulet
>Senior Oracle DBA
>Oracle Certified 8i DBA 
>
>-Original Message-
>Sent: Tuesday, July 01, 2003 3:35 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi,
>
>>Von: Baswannappa, Shiva [mailto:[EMAIL PROTECTED]
>>Gesendet am: Montag, 30. Juni 2003 18:09
>
>>1. Have the UTL_FILE write to a file in directory called 
>>'printdir' (you can
>>name it whatever you like)
>
>.
>
>that is exactly the way it is running right now but our customer
>had to change it's mind due to some fiscal policies in his country.
>
>So I have to be more "online" with my printoutput.
>
>Means, as soon, as the data reaches the database it has to be printed
>onto endless paper which is stamped by the finacial office. So "nobody"
>should be able to manipulate the data... preventing tax fraud.
>
>> Frank <
>___
>_
>
>
>
>Confidentiality Notes
>
>This email and any files transmitted is intended only for the person or
>entity to which it is addressed and may contain confidential and/or
>privileged material. If you are not the authorised recipient, any use,
>disclosure, copying, distribution or any action taken or omitted to be
>taken in reliance on it, is prohibited. If you received this in error,
>please contact the sender and delete the material from any computer.
>
>E-mail messages are not necessarily secure. Scheidt & Bachmann does not
>accept responsibility for any changes made to this message after it was
>sent. 
>
>Thank you for your cooperation!
>
>Diese E-Mail und alle angehängten Dateien ist ausschließlich für die
>Person / Persone

RE: Tech meetings

Title: Message



Sounds 
like that meeting was missing the middle letter "A."

  
  -Original Message-From: Johnston, Tim 
  [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 12:45 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Tech meetings
  We 
  had these at the last place I was at...  The senior folks from the 
  various teams would get together...  One person or group was designated 
  to present a topic for the next meeting...  Neat idea but 
  it failed at that location...  The reason?  The VP of App Dev 
  decided he wanted to attend the meetings...  Which meant we spent every 
  meeting teaching him the basics and never really getting to the good 
  stuff...  It ended up being a huge waste of time for the majority of the 
  people in the room...
   
  Tim
  
-Original Message-From: M.Godlewski 
[mailto:[EMAIL PROTECTED]Sent: Tuesday, July 01, 2003 12:30 
PMTo: Multiple recipients of list ORACLE-LSubject: 
Tech meetings
List,
 
Just wondering if your organization has tech meetings, and what is 
discussed and what the goals of the meetings are?
 
I've been asked about this, and was wondering if there is a quick list 
out there any where.
 
TIA
 


Do you Yahoo!?The 
New Yahoo! Search - Faster. Easier. 
Bingo.

RE: Should percent increase higher than 0 in 817?

PCTINCREASE is a bad good thing.  Every DBA that I know of hunts down objects with a 
pctincrease other than 0 and resets them.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Tuesday, July 01, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L


Everything I have seen says no. I did the following.

Set PCTINCREASE = 0
Set my initial and next extents to 5m so they are uniform. A woman I work with swears 
there is Oracle documentation that in 817 PCTINCREASE should be greater than 0 because 
the default is 50. 


ORA-03232 unable to allocate an extent of string blocks from tablespace string

Cause: An attempt was made to specify a HASH_MULTIBLOCK_IO_COUNT value that is greater 
than the tablespace's NEXT value.

Action: Increase the value of NEXT for the tablespace using ALTER TABLESPACE DEFAULT 
STORAGE or decrease the value of HASH_MULTIBLOCK_IO_COUNT.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Microsoft VS Oracle (again)

The most useful thing that Microsoft has ever been 
selling is Microsoft Xenix.

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, July 01, 2003 4:11 PM
To: Multiple recipients of list ORACLE-L


Now, now, Microsoft has made some very useful desktop caliber applications,
including SQL Server.



>>> [EMAIL PROTECTED] 07/01/03 02:30PM >>>
SQL server on Unix lets see.That would be none.

SQL Server doesn't even run on Windows much less any other platform...

Bwahahahahahaha...

sorry...I got carried away...



-Original Message-
Sent: Tuesday, July 01, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L


On which unix boxes does SQL Server work? I don't want to 
replace all of my AIX, HP-UX and Solaris boxes with NT.
I'll consider SQL Server as a replacement as soon as it starts
operating on Unix. Microsoft operating systems have spurned the whole
industry trying to protect them from viruses, which makes them completely
unsuitable for a central database of a Fortune 500 company. Does
SQL Server work on Linux?

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED] 


-Original Message-
Sent: Tuesday, July 01, 2003 1:00 PM
To: Multiple recipients of list ORACLE-L


FYI

One of my friends at Microsoft, (yes I must to
confess, I have friends at MS) gave me a "present",
it's a 4 cd's kit called "SQL Server 2000 for the
Oracle Customer", the kit consist in 4 cd's with
demos, docs, presentations, videos and a lot of stuff
showing why sql server is a better option as a DB
instead oracle, contains price lists, performance
evaluation and many other "information", maybe you'd
like to spend some of your time giving Billy a chance
to defend his product. The 4 cd's are available
(almost completely) as links in:

http://www.microsoft.com/sql/oraclekit 

Any comments?

Gabriel

=
"Any dream worth having is a dream worth fighting for"(Cualquier sueño que
valga la pena tener, es un sueño por el que vale la pena luchar)Charles
Xavier

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Gabriel Aragon
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Odland, Brad
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Darrell Landrum
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, Califo

Re: Do Not Call

2003-07-01 Thread KENNETH JANUSZ

Or maybe RPGII and flat files.


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 01, 2003 2:58 PM


> Nah... Too current. It's probably COBOL/ISAM.
> 
> 
> -Original Message-
> Sent: Tuesday, July 01, 2003 1:15 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Probably MS Access.
> 
> My $0.02 worth,
> 
> Ken Janusz, CPIM
> 
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, July 01, 2003 12:59 PM
> 
> 
> > There have been over 10,000,000 entries made in the National Do Not 
> > Call Registry since Friday June 27. Does anyone know the database 
> > engine in which this is stored?
> > 
> > 
> > Curious in Bozeman, MT
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: KENNETH JANUSZ
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Microsoft VS Oracle (again)

2003-07-01 Thread Darrell Landrum

Now, now, Microsoft has made some very useful desktop caliber applications, including 
SQL Server.



>>> [EMAIL PROTECTED] 07/01/03 02:30PM >>>
SQL server on Unix lets see.That would be none.

SQL Server doesn't even run on Windows much less any other platform...

Bwahahahahahaha...

sorry...I got carried away...



-Original Message-
Sent: Tuesday, July 01, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L


On which unix boxes does SQL Server work? I don't want to 
replace all of my AIX, HP-UX and Solaris boxes with NT.
I'll consider SQL Server as a replacement as soon as it starts
operating on Unix. Microsoft operating systems have spurned the whole
industry trying to protect them from viruses, which makes them completely
unsuitable for a central database of a Fortune 500 company. Does
SQL Server work on Linux?

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED] 


-Original Message-
Sent: Tuesday, July 01, 2003 1:00 PM
To: Multiple recipients of list ORACLE-L


FYI

One of my friends at Microsoft, (yes I must to
confess, I have friends at MS) gave me a "present",
it's a 4 cd's kit called "SQL Server 2000 for the
Oracle Customer", the kit consist in 4 cd's with
demos, docs, presentations, videos and a lot of stuff
showing why sql server is a better option as a DB
instead oracle, contains price lists, performance
evaluation and many other "information", maybe you'd
like to spend some of your time giving Billy a chance
to defend his product. The 4 cd's are available
(almost completely) as links in:

http://www.microsoft.com/sql/oraclekit 

Any comments?

Gabriel

=
"Any dream worth having is a dream worth fighting for"(Cualquier sueño que
valga la pena tener, es un sueño por el que vale la pena luchar)Charles
Xavier

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Gabriel Aragon
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Odland, Brad
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Darrell Landrum
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Do Not Call




Now wait a minute, isn't that suppose to be 
a government web site?  Therefore it must be a flat file processed by an 
Ada backend.
 
Dick GouletSenior Oracle DBAOracle Certified 8i DBA 
-Original Message-From: Gene Sais 
[mailto:[EMAIL PROTECTED]Sent: Tuesday, July 01, 2003 3:10 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: Do 
Not Call
http://uptime.netcraft.com/up/graph/?host=www.donotcall.gov
 
Well, if it were unix then it couldn't be SQLserver.  It is Windows, 
therefore I assume its SQLserver, but it could be Oracle.  But who runs 
Oracle on Windows anyway *hahahaha*>>> 
[EMAIL PROTECTED] 07/01/03 02:29PM >>>
Paradox for DOS 
-Original Message- From: Orr, Steve [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 
July 01, 2003 2:00 PM To: Multiple recipients of list ORACLE-L Subject: 
Do Not Call 
There have been over 10,000,000 entries made in the National Do Not Call 
Registry since Friday June 27. Does anyone know the database engine in 
which this is stored? 
Curious in Bozeman, MT -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 
Author: Orr, Steve   INET: [EMAIL PROTECTED] 
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com San 
Diego, California    -- Mailing list and 
web hosting services 
- To 
REMOVE yourself from this mailing list, send an E-Mail message to: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 
BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list 
you want to be removed from).  You may also send the HELP command for 
other information (like subscribing).

RE: Microsoft VS Oracle (again)

Title: RE: Microsoft VS Oracle (again)



    Well, I'll be a little more forgiving than Raj has 
been.  Basically MicroSoft is just the "pot calling the kettle 
black".  
 
    On the issue of price, well yes MicroSoft does have an 
edge, but that's just how they've eliminated all of their other competition over 
the years.  The product does not cost less than Oracle or DB2, it's just 
that MicroSoft can leverage the tremendous amounts of cash they have to offset 
the giveaway they're into.  I believe that was one of the points of the 
Antitrust suit they were embroiled in.  
 
    On RAC they really have a long way to 
go.  If you want to do a federated database setup like MicroSoft 
states, just buy standard edition Oracle licenses & toss in a pile of 
database links.  Works the same way & you don't have to pay extra for 
it.  The whole idea of RAC is that when one node dies, for whatever reason, 
the data that node was hosting is not offline till you get it repaired. And 
actually you really do not need to do anything to your application to take 
advantage of RAC, except adjust your error handling to understand that a 
transaction needed to be resubmitted.
 
    Overall I think MicroSoft's Achilles heel is Windows.  
Their a one OS horse. Oracle is a multi OS horse that runs the same whatever the 
platform.  And BTW, Oracle runs RAC on Red Hat without any additional 
software, never mind that it runs on Linux in the first place.  Similar 
things can also be said for DB2, Sybase, and Informix.  When, if ever, 
Microsoft has a version of Sql*Server that runs as multiple independent 
processes on Linux then I'll give them a second look.  As long as their a 
single multi-threaded Windows only process they can stay in Redmond.  Also, 
yes they are the "fastest growing" database on the market, take a look at that 
copy of Windows 2000 Advanced Server you've got.  There's a copy of 
Sql*Server 2000 in there, and you can't uninstall it.  Billy G is still up 
to his old tricks.  The only solution to MicroSoft is forced 
divestiture.  Too bad that judge could not stand up to King 
George.
 
Dick GouletSenior Oracle DBAOracle Certified 8i DBA 

-Original Message-From: Jamadagni, Rajendra 
[mailto:[EMAIL PROTECTED]Sent: Tuesday, July 01, 2003 1:40 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
Microsoft VS Oracle (again)
Aargh ... 
you must be very brave telling a Oracle cult to move to SQL 
Server ... 
How do we know you are not Billy G using an alias ... 

8>) 
Raj  
Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! 

-Original Message- From: Gabriel 
Aragon [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, July 01, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Subject: 
Microsoft VS Oracle (again) 
FYI 
One of my friends at Microsoft, (yes I must to confess, I have friends at MS) gave me a "present", it's a 4 cd's kit called "SQL Server 2000 for the Oracle Customer", the kit consist in 4 cd's with demos, docs, presentations, videos and a lot of stuff showing why sql server is a better option as a DB instead oracle, contains price lists, performance evaluation and many other "information", maybe you'd like to spend some of your time giving Billy a chance to defend his product. The 4 cd's are available (almost completely) as links in: 
http://www.microsoft.com/sql/oraclekit 
Any comments? 
Gabriel

Re: Perl for Oracle DBAs - dbup.pl

2003-07-01 Thread Dwayne Cox

oops!  My apologies for not posting the solution to the list.  Thanks 
for covering for my oversight Jared.   *sheepish grin*

Dwayne

Jared Still wrote:
FYI, if any of you are using the dbup.pl script
from the PDBA toolkit:
The solution to Dwayne's problem was to change
the following line in dbup.conf from this:
   %onCallList = ( 'default' => 'corpdba' );

to this:

   %onCallList = ( 
 '20030101' => 'corpdba',
 'default' => 'corpdba' 
   );

Seems the programmer didn't take into account that
the 'default' might be the only value in the onCallList
hash.
I've already given him (the programmer) a stern reprimand.

Jared

--
Dwayne Cox
Corporate Database Administrator
Info Tech, Inc.
5700 SW 34th Street, Suite 1235
Gainesville, FL  32608
email: [EMAIL PROTECTED]
phone: 352.381.4521 fax: 352.381.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Dwayne Cox
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: nt script

2003-07-01 Thread Smith, Ron L.

Write your daily file to a 'nodate' file.  Then copy it to a date file for
backup.  Run your script against the 'nodate' file.

Ron

-Original Message-
Sent: Tuesday, July 01, 2003 2:51 PM
To: Multiple recipients of list ORACLE-L


Bob,

I tested it out, it works on one hard code file. If I set thisfile it works.
But in reality, I need to find today's log, the log file name convention is
always goes psprcsrv_psnt_0701.log with the date suffix to the end. I can't
hard code the file name in the bat file. Is there anyway how to get around
with this?

Thanks,

Joan

Bob Metelsky wrote:
> 
> Don't run it line by line
> Save it to a file called myfind.bat
> 
> Then call from a command prompt
> 
> C:\> myfind.bat
> 
> Or click the batch file, be sure to leave the pause so you can see an 
> error if any. Once its working, you can then implemet blat as someone 
> suggested
> 
> Here is a version using variables
> 
> ##
> 
> [myfind.bat]
> :: Find example by BMetelsky on  Friday-April-11-2003-9:22:53 AM
> :: This script searches thefile for a string and if it finds it, sends 
> an email message to dbamail
> :: 0 =is found
> echo off
> set themess=A Database SERVICE on %computername% is NOT running on 
> %date% at %time% set [EMAIL PROTECTED]
> set blatfile=D:\dbmon\blattext.txt
> set thefile=D:\dbmon\runit.log
> set subject=A DB SERVICE IS NOT RUNNING
> set [EMAIL PROTECTED]
> echo starting >%blatfile%
> 
> find "ERROR:" %thefile% >NUL
> 
> IF ERRORLEVEL 1 GOTO no
> IF NOT ERRORLEVEL 1 GOTO yes
> :no
> goto end
> 
> :yes
> echo A db service is down on %computername%>%blatfile%
> blat D:\dbmon\blattext.txt -subject "%subject%" -to "%dbamail%" -i 
> "%from%" -body "%themess%" goto end
> 
> :end
> @exit
> rem echo %errorlevel%
> 
> ##
> 
> > Hi Bob, thanks for the reply. I added your code and tested still no 
> > good. I tested the case without a match. Still go to run.
> >
> > Joan
> >
> > D:\oracle\admin>FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s 
> > -m*.log  -d+0 -c"CMD /c echo @FILE" PSPRCSRV_PSNT_0630.log 
> > PSPRCSRV_PSNT_0701.log
> >
> > D:\oracle\admin>echo on
> >
> > D:\oracle\admin>FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s 
> > -m*.log  -d+0 -c"CMD /c type d:\pslog 
> > [EMAIL PROTECTED]|findstr ORA-03113
> > >D:\oracle\admin\test.log"
> >
> > D:\oracle\admin>rem FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ 
> > -s -m*.log  -d+0 -c"CMD /c type d:\p 
> > [EMAIL PROTECTED]|findstr ORA-03113" >NUL
> >
> > D:\oracle\admin>IF ERRORLEVEL 1 GOTO no
> >
> > D:\oracle\admin>IF NOT ERRORLEVEL 1 GOTO RUN_PROC
> >
> > D:\oracle\admin>rem d:\psfm\start_proc_sched.bat
> >
> > D:\oracle\admin>echo run
> > run
> >
> > D:\oracle\admin>pause
> > Press any key to continue . . .
> >
> > D:\oracle\admin>goto end
> >
> > D:\oracle\admin>echo "finished"
> > "finished"
> >
> > D:\oracle\admin>rem if errorlevel 1 @d:\psfm\start_proc_sched.bat
> >
> > Bob Metelsky wrote:
> > >
> > > echo off
> > > @cls
> > > find "ORA-124" C:\yourlog.txt >NUL
> > >
> > > IF ERRORLEVEL 1 GOTO no
> > > IF NOT ERRORLEVEL 1 GOTO yes
> > >
> > > :no
> > > ECHO NOT FOUND
> > > goto end
> > >
> > > :yes
> > >  ECHO String IS found
> > > pause
> > > goto end
> > >
> > > :end
> > > exit
> > >
> > > >
> > > > Hi listers,
> > > >
> > > > I am working on a nt script. I download FORFILE exe, it
> > works fine.
> > > > My intention is finding the ORA-03113 string in the log.
> > If there is
> > > > a match, then reboot the server, else do nothing. I don't have 
> > > > problem with the findstr part. However, the errorlevel
> > always return
> > > > 0, no matter it find the error or not. So the if statement is 
> > > > not working. Can somebody give me some light on NT syntax? On
> > unix, it
> > > > is so easy to script the condition. Please help,
> > > >
> > > > Thanks,
> > > >
> > > > Joan
> > > >
> > > >
> > > >  FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log
> > > > -d+0 -c"CMD /c type
> > > > d:[EMAIL PROTECTED]|findstr ORA-03113" if 
> > > > errorlevel 1 goto run_proc echo 'there is a match'
> > > >
> > > > if errorlevel 0 goto end
> > > > echo 'there is no match'
> > > >
> > > > :run_proc
> > > > d:\start_proc.bat
> > > > goto end
> > > >
> > > > :end
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > --
> > > > Author: Joan Hsieh
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > > > San Diego, California-- Mailing list and web
> > hosting services
> > > >
> > 
> > > > -
> > > > To REMOVE yourself from this mailing list, send an E-Mail 
> > > > message
> > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
> > > > and in the message BODY, include a line containing: UNSUB
> > > > ORACLE-L (or the name of mailing

Re: Performance

2003-07-01 Thread Stephane Faroult

Ramon,

I have had a closer look at your coe. My gut feeling is that 
 
SELECT MAX(A.ACM_FECACUM),
   Nvl(A.ACM_ACUMDBANT,0) -
   nvl(A.ACM_ACUMCRANT,0) +
   nvl(A.ACM_ACUMDB,0)-
   nvl(A.ACM_ACUMCR,0)
into   vFechaIni, vSaldoAnt
from  tcon_acum A,
  (select ACM_Oficina,
  ACM_Moneda,
  nvl(max(TRUNC(ACM_FECACUM)), '2001/01/01')
MAXFECACUM
   FROM TCON_ACUM
   WHERE
 Acm_codigo   = pCuenta   AND
 ACM_Sucursal = i
   GROUP BY ACM_Oficina, ACM_Moneda) T
where
   A.acm_codigo= pCuenta  AND
   A.acm_sucursal  = i   AND
   T.ACM_Oficina  = A.ACM_Oficina  AND
   T.ACM_Moneda   = A.ACM_MOneda AND
  TRUNC(A.ACM_FECACUM)  = T.MAXFECACUM
 GROUP BY Nvl(A.ACM_ACUMDBANT,0), nvl(A.ACM_ACUMCRANT,0),
nvl(A.ACM_ACUMDB,0),nvl(A.ACM_ACUMCR,0);
   nvl(A.ACM_ACUMDB,0),nvl(A.ACM_ACUMCR,0);

would return the same thing as what you have, only faster. On first
readin I had not noticed that you IN (SELECT ...) was correlated. Ouch.
If ACM_CODIGO and ACM_SUCURSAL are indexed (and the index is
discriminant enough), and if (ACM_OFICINA, ACM_MONEDA) are also
separately indexed (with the same restriction as before), it should run
reasonably fast.

"Ramon E. Estevez" wrote:
> 
> Tks Stephane and Madlen,
> 
> Still the same problem.
> 
> I added the hint /*+ FIRST_ROWS */ to the query that invoke the function
> and it changed from FTS to use Index but still have the same problem.  I
> added the same hint to the function and
> Nothing.
> 
> I checked the v$session_wait during the execution of the procedure and
> the only thing that
> Was waiting was SQL NET TO CLIENT MESSAGE.
> 
> Ramon E. Estevez
> [EMAIL PROTECTED]
> 809-535-8994
> 
> -Original Message-
> Stephane Faroult
> Sent: Friday, June 27, 2003 6:15 PM
> To: Multiple recipients of list ORACLE-L
> 
> Ramon,
> 
> This is not a strange case at all; I find quite customary to see
> dazzling fast queries in a development environment crawl pathetically in
> production.
> My Spanish being reduced to some vague remnants of Latin (and just
> enough to understand the promotion of Mexican holiday resorts) I must
> confess to some difficulty in understanding your code. Anyway, CBO seems
> to be the culprit, isn't it? What is the main behavioural difference
> between CBO and RBO? Primarily, CBO doesn't shy as much of full table
> scans, and disdain indices much more often, jumping for the (usually
> quite efficient) hash join instead. When stats slow down a query, it
> usually means that nested loops were efficient, and in that case hash
> joins are not. To put the CBO back on tracks, /*+ FIRST_ROWS */ is
> usually enough. If it isn't, list the tables in the FROM clause in the
> order you know to be suitable (the table for which you feed the most
> selective values in the query first) and add ORDERED to the hint to ram
> the message home.
>  I have found this to be efficient in most cases.
> 
> HTH,
> 
>  Stephane Faroult
> 
> "Ramon E. Estevez" wrote:
> >
> > Hi list,
> >
> > SCENARIO LAB DB = Oracle 8.1.7.4.0 on Suse Linux 7.2
> > PRODUCTION DB   = Oracle 8.1.7.4.0 on HP-UX B.11.00
> >
> > I have this strange case, I have this query that generate a text file
> > and in the PRODUCTION environment ran for about 30 minutes.  When
> > running the same query in LAB ran in about 2 minutes.  The 2 instances
> 
> > have the same parameters setted and the same amount of data, the Lab
> > DB is updated every night with the production data throught IMP/EXP
> > procedure.
> >
> > Trying to solve the problem, today I ran statistics in LAB and the
> > query lasted more than in PRODUCTION and before was about 2 minutes.
> >
> > TIA
> >
> > -*
> > --
> > Here is the code of the CODE in the form and the function.
> >
> > PROCEDURE genera_archivo IS
> > vcOutFile   varchar2(30) :=
> > 'c:\pruebas\archivo.txt';
> >   hOutFiletext_io.file_type;
> >
> >   cursor cuentas is
> >  select  b.MATHOPERATOR, b.MAPACCOUNTLOCAL,
> >  a.PRINTORDER,   b.sequence
> >  from tequivaccount a, tequivaccountdetail b
> > where
> >  a.REPORTCODE = b.REPORTCODE   and
> >  a.CODE   = b.CODE and
> >  a.reportcode = 'BDI01'
> > order by a.PRINTORDER, b.sequence   ;
> >
> >   vSaldo  number;
> >   vCuenta varchar2(14);
> > BEGIN
> > set_application_property(CURSOR_STYLE,'BUSY');
> > hOutFile := text_io.fopen(:nombre_plano,'w');
> >
> > text_io.put_line(hOutFile,to_char(:fecha_fin,'ddmm')||'cifrado');
> >
> >   fo

RE: Do Not Call

Nah... Too current. It's probably COBOL/ISAM.


-Original Message-
Sent: Tuesday, July 01, 2003 1:15 PM
To: Multiple recipients of list ORACLE-L


Probably MS Access.

My $0.02 worth,

Ken Janusz, CPIM


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 01, 2003 12:59 PM


> There have been over 10,000,000 entries made in the National Do Not 
> Call Registry since Friday June 27. Does anyone know the database 
> engine in which this is stored?
> 
> 
> Curious in Bozeman, MT
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Tech meetings

2003-07-01 Thread Ron Rogers

This could be called "training" and we have no budget for training

If it wasn't for the constant change and lack of communications I think
I would be bored here.
Ronmô¿ôm


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: perl DBI/DBD: can I pass in an array as parameter?

2003-07-01 Thread STEVE OLLIG

ok - that makes more sense.  sorry for misinterpreting the question.  i've
never done it, but my first instinct would be to explore using an in clause
in the query - 

select  tab1.col1, tab2.col2 from tab1, tab2
   where tab1.ID1 = tab2.ID2
   and   tab1.X in (1, 2, 3)

can you simply pass an array to the prepared statement that way?  i'd try it
but don't have a sandbox with the DBI/DBD modules handy.

perhaps one of the great Perl gurus of the list will offer some insight...

-Original Message-
Sent: Tuesday, July 01, 2003 2:45 PM
To: Multiple recipients of list ORACLE-L


No. I want to reduce the numebr of sql calls.

For example,

@my_array = (1,2,3);

I don't want to do

select  tab1.col1, tab2.col2 from tab1, tab2
   where tab1.ID1 = tab2.ID2
   and   tab1.X = 1;

select  tab1.col1, tab2.col2 from tab1, tab2
   where tab1.ID1 = tab2.ID2
   and   tab1.X = 2;

select  tab1.col1, tab2.col2 from tab1, tab2
   where tab1.ID1 = tab2.ID2
   and   tab1.X = 3;

because that would require three calls to Oracle. I want to pass @my_array
in so the sql statment only run once and return all the rows. Similar to
"forall ..."  in PL/SQL situation.

Guang

-Original Message-
STEVE OLLIG
Sent: Tuesday, July 01, 2003 2:56 PM
To: Multiple recipients of list ORACLE-L


if i get you right - you're trying to treat the resultset from a query as an
array in Perl.  That's the way it works.  Try something like this:

$sth = $dbh->prepare (" select  tab1.col1, tab2.col2 from tab1, tab2
   where tab1.ID1 = tab2.ID2
   and   tab1.X = ? ");
my $resultset = $sth->execute("value for X");
foreach (@$resultset) {
  my($col1, $col2) = @$_;
  # do more stuff
}

-Original Message-
Sent: Tuesday, July 01, 2003 11:20 AM
To: Multiple recipients of list ORACLE-L


Hi:

Does anyone know if I can pass an array in perl to an sql using DBI/DBD so
that I get result set from Oracle?

Specifically, I want do something like in perl:


$sth = $dbh->prepare (" select  tab1.col1, tab2.col2 from tab1, tab2
   where tab1.ID1 = tab2.ID2
   and   tab1.X = ? ");

my @my_array;

# filling in my_array with data here

$sth->execute(@my_array);

my ($col1, $col2);
while(($col1, $col2) = $sth->fetchrow_array())  {

  # do processing of $col1 and $col2;
}

I am hoping to save repeated sql calls, do only one call and get all the
rows back.

Is it possible in any version DBI/DBD? I looked at

http://perldoc.com/perl5.6.1/lib/DBI.html

and I does not seem to be able to figure it out. If it is possible, any
simple example code somewhere?

Thanks.

Guang

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: STEVE OLLIG
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Guang Mei
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: STEVE OLLIG
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGu

RE: perl DBI/DBD: can I pass in an array as parameter?

2003-07-01 Thread Guang Mei

No. I want to reduce the numebr of sql calls.

For example,

@my_array = (1,2,3);

I don't want to do

select  tab1.col1, tab2.col2 from tab1, tab2
   where tab1.ID1 = tab2.ID2
   and   tab1.X = 1;

select  tab1.col1, tab2.col2 from tab1, tab2
   where tab1.ID1 = tab2.ID2
   and   tab1.X = 2;

select  tab1.col1, tab2.col2 from tab1, tab2
   where tab1.ID1 = tab2.ID2
   and   tab1.X = 3;

because that would require three calls to Oracle. I want to pass @my_array
in so the sql statment only run once and return all the rows. Similar to
"forall ..."  in PL/SQL situation.

Guang

-Original Message-
STEVE OLLIG
Sent: Tuesday, July 01, 2003 2:56 PM
To: Multiple recipients of list ORACLE-L


if i get you right - you're trying to treat the resultset from a query as an
array in Perl.  That's the way it works.  Try something like this:

$sth = $dbh->prepare (" select  tab1.col1, tab2.col2 from tab1, tab2
   where tab1.ID1 = tab2.ID2
   and   tab1.X = ? ");
my $resultset = $sth->execute("value for X");
foreach (@$resultset) {
  my($col1, $col2) = @$_;
  # do more stuff
}

-Original Message-
Sent: Tuesday, July 01, 2003 11:20 AM
To: Multiple recipients of list ORACLE-L


Hi:

Does anyone know if I can pass an array in perl to an sql using DBI/DBD so
that I get result set from Oracle?

Specifically, I want do something like in perl:


$sth = $dbh->prepare (" select  tab1.col1, tab2.col2 from tab1, tab2
   where tab1.ID1 = tab2.ID2
   and   tab1.X = ? ");

my @my_array;

# filling in my_array with data here

$sth->execute(@my_array);

my ($col1, $col2);
while(($col1, $col2) = $sth->fetchrow_array())  {

  # do processing of $col1 and $col2;
}

I am hoping to save repeated sql calls, do only one call and get all the
rows back.

Is it possible in any version DBI/DBD? I looked at

http://perldoc.com/perl5.6.1/lib/DBI.html

and I does not seem to be able to figure it out. If it is possible, any
simple example code somewhere?

Thanks.

Guang

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: STEVE OLLIG
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Guang Mei
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: nt script


Correct.  FORFILES will not work.  

-Original Message-
Sent: Tuesday, July 01, 2003 3:20 PM
To: Multiple recipients of list ORACLE-L


Hi Seefelt,

with or without match, I added ORA-03113 and deleted it later to test
both case. They all run ERRORLEVERL 1 condition. No matter what.

Joan

CODE:

FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0 -c"CMD
/c type d:[EMAIL PROTECTED]|findstr ORA-03113" 

IF ERRORLEVEL 1 ( echo 'there is no match' ) 
goto :no
IF NOT ERRORLEVEL 1 (echp 'there is a match')
GOTO :RUN_PROC
:run_proc
rem d:\psfm\start_proc_sched.bat
echo run
pause
goto end
:no
echo do nothing

TEST RUN WITHOUT MATCH;

D:\oracle\admin>FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s
-m*.log  -d+0 -c"CMD /c echo @FILE"
PSPRCSRV_PSNT_0630.log
PSPRCSRV_PSNT_0701.log

D:\oracle\admin>echo on

D:\oracle\admin>rem FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s
-m*.log  -d+0 -c"CMD /c type d:\
[EMAIL PROTECTED]|findstr ORA-03113
>D:\oracle\admin\test.log"

D:\oracle\admin>FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s
-m*.log  -d+0 -c"CMD /c type d:\pslo
[EMAIL PROTECTED]|findstr ORA-03113"

D:\oracle\admin>IF ERRORLEVEL 1 (echo 'there is no match'  )
D:\oracle\admin>goto :no
D:\oracle\admin>echo do nothing
do nothing
D:\oracle\admin>goto end
D:\oracle\admin>echo "finished"
"finished"

TEST RUN WITH A MATCH;

D:\oracle\admin>FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s
-m*.log  -d+0 -c"CMD /c type d:\pslog
[EMAIL PROTECTED]|findstr ORA-03113"
ORA-03113

D:\oracle\admin>IF ERRORLEVEL 1 (echo 'there is no match'  )
D:\oracle\admin>goto :no
D:\oracle\admin>echo do nothing
do nothing
D:\oracle\admin>goto end
D:\oracle\admin>echo "finished"
"finished"


"Seefelt, Beth" wrote:
> 
> BTW, it can also be written like this.  Just FYI.
> 
> FINDSTR /S /I /L "ORA-03113" d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log
> if errorlevel 1 ( echo 'there is a match'
>   d:\start_proc.bat )
> goto :EOF
> 
> -Original Message-
> Sent: Tuesday, July 01, 2003 12:35 PM
> To: [EMAIL PROTECTED]
> 
> Hi,
> 
> I think FORFILES is probably overkill here.  And it probably is only
> going to return the errorlevel for the last file checked.  Just use
> FINDSTR with a wildcard.
> 
> FINDSTR /S /I /L "ORA-03113" d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log
> if errorlevel 1 goto run_proc
> echo 'there is a match'
> 
> if errorlevel 0 goto end
> echo 'there is no match'
> 
> :run_proc
> d:\start_proc.bat
> goto end
> 
> :end
> 
> HTH.
> 
> -Original Message-
> Sent: Tuesday, July 01, 2003 12:15 PM
> To: Multiple recipients of list ORACLE-L
> 
> Hi listers,
> 
> I am working on a nt script. I download FORFILE exe, it works fine. My
> intention is finding the ORA-03113 string in the log. If there is a
> match, then reboot the server, else do nothing. I don't have problem
> with the findstr part. However, the errorlevel always return 0, no
> matter it find the error or not. So the if statement is not working.
Can
> somebody give me some light on NT syntax? On unix, it is so easy to
> script the condition. Please help,
> 
> Thanks,
> 
> Joan
> 
>  FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0
-c"CMD
> /c type d:[EMAIL PROTECTED]|findstr ORA-03113"
> if errorlevel 1 goto run_proc
> echo 'there is a match'
> 
> if errorlevel 0 goto end
> echo 'there is no match'
> 
> :run_proc
> d:\start_proc.bat
> goto end
> 
> :end
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Joan Hsieh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Seefelt, Beth
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list a

RE: Tech meetings

Good information!  Thanks for the heads up on the pit falls."Johnston, Tim" <[EMAIL PROTECTED]> wrote:


We had these at the last place I was at...  The senior folks from the various teams would get together...  One person or group was designated to present a topic for the next meeting...  Neat idea but it failed at that location...  The reason?  The VP of App Dev decided he wanted to attend the meetings...  Which meant we spent every meeting teaching him the basics and never really getting to the good stuff...  It ended up being a huge waste of time for the majority of the people in the room...
 
Tim

-Original Message-From: M.Godlewski [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 01, 2003 12:30 PMTo: Multiple recipients of list ORACLE-LSubject: Tech meetings
List,
 
Just wondering if your organization has tech meetings, and what is discussed and what the goals of the meetings are?
 
I've been asked about this, and was wondering if there is a quick list out there any where.
 
TIA
 


Do you Yahoo!?The New Yahoo! Search - Faster. Easier. Bingo.
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.

RE: Microsoft VS Oracle (again)

2003-07-01 Thread Jamadagni, Rajendra

Title: RE: Microsoft VS Oracle (again)

You missed the smiley ...

Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !

-Original Message-
From: Gabriel Aragon [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 01, 2003 3:10 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Microsoft VS Oracle (again)

mmm maybe I was not clear, my intention was to show
you what I call the MS's "desperated" cry for help.. I
love Oracle! for ever!

I just want to hear some comments about the 'facts'
they put there, I mean, how much is true?

;-)

--- "Jamadagni, Rajendra"
<[EMAIL PROTECTED]> wrote:
> Aargh ...
> 
> you must be very brave telling a Oracle cult to move
> to SQL Server ...
> 
> How do we know you are not Billy G using an alias
> ...
> 
> 8>)
> 
> Raj
>

> 
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly
> personal.
> QOTD: Any clod can have facts, having an opinion is
> an art !
> 
> 
> -Original Message-
> Sent: Tuesday, July 01, 2003 1:00 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> FYI
> 
> One of my friends at Microsoft, (yes I must to
> confess, I have friends at MS) gave me a "present",
> it's a 4 cd's kit called "SQL Server 2000 for the
> Oracle Customer", the kit consist in 4 cd's with
> demos, docs, presentations, videos and a lot of
> stuff
> showing why sql server is a better option as a DB
> instead oracle, contains price lists, performance
> evaluation and many other "information", maybe you'd
> like to spend some of your time giving Billy a
> chance
> to defend his product. The 4 cd's are available
> (almost completely) as links in:
> 
> http://www.microsoft.com/sql/oraclekit
> 
> Any comments?
> 
> Gabriel
> >
*This
> e-mail message is confidential, intended only for
> the named recipient(s) above and may contain
> information that is privileged, attorney work
> product or exempt from disclosure under applicable
> law. If you have received this message in error, or
> are not the named recipient(s), please immediately
> notify corporate MIS at (860) 766-2000 and delete
> this e-mail message from your computer, Thank
>
you.*1
> 

=
"Any dream worth having is a dream worth fighting for"(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gabriel Aragon
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

RE: Tech meetings

Thanks! This does help me.Rudy Zung <[EMAIL PROTECTED]> wrote:

Don't know if what we do in our shop here qualifies for your question or not, but our dev groups do "stand-up meetings." Relatively quick meetings (that can be done standing up; no meeting rooms required) that are usually finished in about 20 minutes. In the stand-ups, we get heads-up for things and specifications that might be coming down the pipeline from the product management and design side. We get a quick update on the state of deployment (what version has rolled into production, what version is in the QA pipeline) and what the next impending set of changes are about to get pushed onto the dev servers. If there's any potential "gotcha"s that have been experienced (especially on the coding front) they get publicized in the stand-ups as well.
The main point of our stand-ups are to make sure that all the developers are relatively aware of the scheduling and direction of the product, and to highlight any programming difficulties and workarounds that might arise so that when different developers hit those gotchas, they'll already know that a solution might already.
These stand-up meetings are basically within a development team/group. Project leads have their own meetings with the product management group. So essentially, the product manager has his own meetings; then the product manager has meetings with the dev project leads to convey what they want in the next iteration of the product; the project leads then present these to the dev group in a stand-up meeting.

-Original Message-From: M.Godlewski [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 12:30 PMTo: Multiple recipients of list ORACLE-LSubject: Tech meetings
List,
Just wondering if your organization has tech meetings, and what is discussed and what the goals of the meetings are?
I've been asked about this, and was wondering if there is a quick list out there any where.
TIA
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.

RE: Tech meetings

A little of both!  I would think there is some how do plan to do this, or why is that the recommended way of doing it type questions and answers sessions.
 
DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:

By tech meetings, do you mean status type meetings or learning typemeetings?-Original Message-Sent: Tuesday, July 01, 2003 11:30 AMTo: Multiple recipients of list ORACLE-LList,Just wondering if your organization has tech meetings, and what is discussedand what the goals of the meetings are?I've been asked about this, and was wondering if there is a quick list outthere any where.TIA_ Do you Yahoo!?The New Yahoo! Search - Faster. Easier. Bingo.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: DENNIS WILLIAMSINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web
 hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.

RE: Tech meetings

2003-07-01 Thread DENNIS WILLIAMS

By tech meetings, do you mean status type meetings or learning type
meetings?

-Original Message-
Sent: Tuesday, July 01, 2003 11:30 AM
To: Multiple recipients of list ORACLE-L


List,
 
Just wondering if your organization has tech meetings, and what is discussed
and what the goals of the meetings are?
 
I've been asked about this, and was wondering if there is a quick list out
there any where.
 
TIA


 



  _  

Do you Yahoo!?
The New  
Yahoo! Search - Faster. Easier. Bingo.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Do Not Call

2003-07-01 Thread Odland, Brad

Title: RE: Do Not Call



They 
contracted with Halliburton they then subcontracted with Accenture to 
design and build a RDBMS engine from open source code (they outsourced it to a 
guy in Jaipur).
 
900 
million Halliburton gets 700 million, Accenture 199.999 
millioncontractor got $15/hour and a used Moped.
 
It is 
really the D.O.N.O.T. Call List
 
D - 
Department
O - of 
the
N - 
National
O - 
Office of
T - 
Telemarketing
 
Tricked you again!
 
 -Original Message-From: 
Loughmiller, Greg [mailto:[EMAIL PROTECTED]Sent: 
Tuesday, July 01, 2003 1:30 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Do Not Call

  Paradox for DOS 
  -Original Message- From: Orr, 
  Steve [mailto:[EMAIL PROTECTED]] 
  Sent: Tuesday, July 01, 2003 2:00 PM To: Multiple recipients of list ORACLE-L Subject: Do Not Call 
  There have been over 10,000,000 entries made in the National 
  Do Not Call Registry since Friday June 27. Does anyone 
  know the database engine in which this is stored? 
  
  Curious in Bozeman, MT -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.net 
  -- Author: Orr, Steve 
    INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
  San Diego, 
  California    -- Mailing list and web 
  hosting services - 
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (or the name of mailing 
  list you want to be removed from).  You may also 
  send the HELP command for other information (like subscribing).

RE: Microsoft VS Oracle (again)

2003-07-01 Thread STEVE OLLIG

there is an animal that once looked very much like SQL Server (could be an
identical twin).  it does run on your favorite flavor of Unix and Linux.
it's called Sybase Adaptive Server Enterprise :o)

-Original Message-
Sent: Tuesday, July 01, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L


On which unix boxes does SQL Server work? I don't want to 
replace all of my AIX, HP-UX and Solaris boxes with NT.
I'll consider SQL Server as a replacement as soon as it starts
operating on Unix. Microsoft operating systems have spurned the whole
industry trying to protect them from viruses, which makes them completely
unsuitable for a central database of a Fortune 500 company. Does
SQL Server work on Linux?

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, July 01, 2003 1:00 PM
To: Multiple recipients of list ORACLE-L


FYI

One of my friends at Microsoft, (yes I must to
confess, I have friends at MS) gave me a "present",
it's a 4 cd's kit called "SQL Server 2000 for the
Oracle Customer", the kit consist in 4 cd's with
demos, docs, presentations, videos and a lot of stuff
showing why sql server is a better option as a DB
instead oracle, contains price lists, performance
evaluation and many other "information", maybe you'd
like to spend some of your time giving Billy a chance
to defend his product. The 4 cd's are available
(almost completely) as links in:

http://www.microsoft.com/sql/oraclekit

Any comments?

Gabriel

=
"Any dream worth having is a dream worth fighting for"(Cualquier sueño que
valga la pena tener, es un sueño por el que vale la pena luchar)Charles
Xavier

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gabriel Aragon
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: STEVE OLLIG
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: nt script

Bob,

I tested it out, it works on one hard code file. If I set thisfile it
works. But in reality, I need to find today's log, the log file name
convention is always goes psprcsrv_psnt_0701.log with the date suffix to
the end. I can't hard code the file name in the bat file. Is there
anyway how to get around with this?

Thanks,

Joan

Bob Metelsky wrote:
> 
> Don't run it line by line
> Save it to a file called myfind.bat
> 
> Then call from a command prompt
> 
> C:\> myfind.bat
> 
> Or click the batch file, be sure to leave the pause so you can see an
> error if any. Once its working, you can then implemet blat as someone
> suggested
> 
> Here is a version using variables
> 
> ##
> 
> [myfind.bat]
> :: Find example by BMetelsky on  Friday-April-11-2003-9:22:53 AM
> :: This script searches thefile for a string and if it finds it, sends
> an email message to dbamail
> :: 0 =is found
> echo off
> set themess=A Database SERVICE on %computername% is NOT running on
> %date% at %time%
> set [EMAIL PROTECTED]
> set blatfile=D:\dbmon\blattext.txt
> set thefile=D:\dbmon\runit.log
> set subject=A DB SERVICE IS NOT RUNNING
> set [EMAIL PROTECTED]
> echo starting >%blatfile%
> 
> find "ERROR:" %thefile% >NUL
> 
> IF ERRORLEVEL 1 GOTO no
> IF NOT ERRORLEVEL 1 GOTO yes
> :no
> goto end
> 
> :yes
> echo A db service is down on %computername%>%blatfile%
> blat D:\dbmon\blattext.txt -subject "%subject%" -to "%dbamail%" -i
> "%from%" -body "%themess%"
> goto end
> 
> :end
> @exit
> rem echo %errorlevel%
> 
> ##
> 
> > Hi Bob, thanks for the reply. I added your code and tested
> > still no good. I tested the case without a match. Still go to run.
> >
> > Joan
> >
> > D:\oracle\admin>FORFILES
> > -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0 -c"CMD
> > /c echo @FILE" PSPRCSRV_PSNT_0630.log PSPRCSRV_PSNT_0701.log
> >
> > D:\oracle\admin>echo on
> >
> > D:\oracle\admin>FORFILES
> > -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0 -c"CMD
> > /c type d:\pslog [EMAIL PROTECTED]|findstr ORA-03113
> > >D:\oracle\admin\test.log"
> >
> > D:\oracle\admin>rem FORFILES
> > -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0 -c"CMD
> > /c type d:\p [EMAIL PROTECTED]|findstr ORA-03113" >NUL
> >
> > D:\oracle\admin>IF ERRORLEVEL 1 GOTO no
> >
> > D:\oracle\admin>IF NOT ERRORLEVEL 1 GOTO RUN_PROC
> >
> > D:\oracle\admin>rem d:\psfm\start_proc_sched.bat
> >
> > D:\oracle\admin>echo run
> > run
> >
> > D:\oracle\admin>pause
> > Press any key to continue . . .
> >
> > D:\oracle\admin>goto end
> >
> > D:\oracle\admin>echo "finished"
> > "finished"
> >
> > D:\oracle\admin>rem if errorlevel 1 @d:\psfm\start_proc_sched.bat
> >
> > Bob Metelsky wrote:
> > >
> > > echo off
> > > @cls
> > > find "ORA-124" C:\yourlog.txt >NUL
> > >
> > > IF ERRORLEVEL 1 GOTO no
> > > IF NOT ERRORLEVEL 1 GOTO yes
> > >
> > > :no
> > > ECHO NOT FOUND
> > > goto end
> > >
> > > :yes
> > >  ECHO String IS found
> > > pause
> > > goto end
> > >
> > > :end
> > > exit
> > >
> > > >
> > > > Hi listers,
> > > >
> > > > I am working on a nt script. I download FORFILE exe, it
> > works fine.
> > > > My intention is finding the ORA-03113 string in the log.
> > If there is
> > > > a match, then reboot the server, else do nothing. I don't have
> > > > problem with the findstr part. However, the errorlevel
> > always return
> > > > 0, no matter it find the error or not. So the if statement is not
> > > > working. Can somebody give me some light on NT syntax? On
> > unix, it
> > > > is so easy to script the condition. Please help,
> > > >
> > > > Thanks,
> > > >
> > > > Joan
> > > >
> > > >
> > > >  FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log
> > > > -d+0 -c"CMD /c type
> > > > d:[EMAIL PROTECTED]|findstr ORA-03113" if
> > > > errorlevel 1 goto run_proc echo 'there is a match'
> > > >
> > > > if errorlevel 0 goto end
> > > > echo 'there is no match'
> > > >
> > > > :run_proc
> > > > d:\start_proc.bat
> > > > goto end
> > > >
> > > > :end
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > --
> > > > Author: Joan Hsieh
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > > > San Diego, California-- Mailing list and web
> > hosting services
> > > >
> > 
> > > > -
> > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
> > > > and in the message BODY, include a line containing: UNSUB
> > > > ORACLE-L (or the name of mailing list you want to be removed
> > > > from).  You may also send the HELP command for other
> > > > information (like subscribing).
> > > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Bob Metelsky
> > >   INET

RE: nt script


Small correction

FOR /F %x in ('dir /b /od d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log') do
FIND "ORA-03313" %~fx
if errorlevel 1 ( echo 'there is a match'
  d:\start_proc.bat )
goto :EOF



And when you use FOR in a bat file, you have to replace all % with %%


-Original Message-
Sent: Tuesday, July 01, 2003 2:18 PM
To: [EMAIL PROTECTED]



Yes.  

FOR /F %x in ('dir /b /od d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log') do
FIND "ORA-03313" %x
if errorlevel 1 ( echo 'there is a match'
  d:\start_proc.bat )
goto :EOF


What this does is list each file in order of oldest to newest.  It does
the FIND on each one, but the errorlevel is only reported for the *last*
one which will be the latest file.

It will not traverse the subdirectories though.

HTH.






-Original Message-
Sent: Tuesday, July 01, 2003 2:05 PM
To: Multiple recipients of list ORACLE-L


Thanks Seefelt,

I need to get the most recent log to check. There are more than 30 logs
on that directory. I just check the most currenct one. That's why I use
d+0 still it give me 2 files. Is there any way I can just get one file?

Jon



"Seefelt, Beth" wrote:
> 
> Hi,
> 
> I think FORFILES is probably overkill here.  And it probably is only
> going to return the errorlevel for the last file checked.  Just use
> FINDSTR with a wildcard.
> 
> FINDSTR /S /I /L "ORA-03113" d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log
> if errorlevel 1 goto run_proc
> echo 'there is a match'
> 
> if errorlevel 0 goto end
> echo 'there is no match'
> 
> :run_proc
> d:\start_proc.bat
> goto end
> 
> :end
> 
> HTH.
> 
> -Original Message-
> Sent: Tuesday, July 01, 2003 12:15 PM
> To: Multiple recipients of list ORACLE-L
> 
> Hi listers,
> 
> I am working on a nt script. I download FORFILE exe, it works fine. My
> intention is finding the ORA-03113 string in the log. If there is a
> match, then reboot the server, else do nothing. I don't have problem
> with the findstr part. However, the errorlevel always return 0, no
> matter it find the error or not. So the if statement is not working.
Can
> somebody give me some light on NT syntax? On unix, it is so easy to
> script the condition. Please help,
> 
> Thanks,
> 
> Joan
> 
>  FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0
-c"CMD
> /c type d:[EMAIL PROTECTED]|findstr ORA-03113"
> if errorlevel 1 goto run_proc
> echo 'there is a match'
> 
> if errorlevel 0 goto end
> echo 'there is no match'
> 
> :run_proc
> d:\start_proc.bat
> goto end
> 
> :end
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Joan Hsieh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Seefelt, Beth
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the

RE: Microsoft VS Oracle (again)

2003-07-01 Thread Odland, Brad

SQL server on Unix lets see.That would be none.

SQL Server doesn't even run on Windows much less any other platform...

Bwahahahahahaha...

sorry...I got carried away...



-Original Message-
Sent: Tuesday, July 01, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L


On which unix boxes does SQL Server work? I don't want to 
replace all of my AIX, HP-UX and Solaris boxes with NT.
I'll consider SQL Server as a replacement as soon as it starts
operating on Unix. Microsoft operating systems have spurned the whole
industry trying to protect them from viruses, which makes them completely
unsuitable for a central database of a Fortune 500 company. Does
SQL Server work on Linux?

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, July 01, 2003 1:00 PM
To: Multiple recipients of list ORACLE-L


FYI

One of my friends at Microsoft, (yes I must to
confess, I have friends at MS) gave me a "present",
it's a 4 cd's kit called "SQL Server 2000 for the
Oracle Customer", the kit consist in 4 cd's with
demos, docs, presentations, videos and a lot of stuff
showing why sql server is a better option as a DB
instead oracle, contains price lists, performance
evaluation and many other "information", maybe you'd
like to spend some of your time giving Billy a chance
to defend his product. The 4 cd's are available
(almost completely) as links in:

http://www.microsoft.com/sql/oraclekit

Any comments?

Gabriel

=
"Any dream worth having is a dream worth fighting for"(Cualquier sueño que
valga la pena tener, es un sueño por el que vale la pena luchar)Charles
Xavier

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gabriel Aragon
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Odland, Brad
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: nt script


Yes.  

FOR /F %x in ('dir /b /od d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log') do
FIND "ORA-03313" %x
if errorlevel 1 ( echo 'there is a match'
  d:\start_proc.bat )
goto :EOF


What this does is list each file in order of oldest to newest.  It does
the FIND on each one, but the errorlevel is only reported for the *last*
one which will be the latest file.

It will not traverse the subdirectories though.

HTH.






-Original Message-
Sent: Tuesday, July 01, 2003 2:05 PM
To: Multiple recipients of list ORACLE-L


Thanks Seefelt,

I need to get the most recent log to check. There are more than 30 logs
on that directory. I just check the most currenct one. That's why I use
d+0 still it give me 2 files. Is there any way I can just get one file?

Jon



"Seefelt, Beth" wrote:
> 
> Hi,
> 
> I think FORFILES is probably overkill here.  And it probably is only
> going to return the errorlevel for the last file checked.  Just use
> FINDSTR with a wildcard.
> 
> FINDSTR /S /I /L "ORA-03113" d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log
> if errorlevel 1 goto run_proc
> echo 'there is a match'
> 
> if errorlevel 0 goto end
> echo 'there is no match'
> 
> :run_proc
> d:\start_proc.bat
> goto end
> 
> :end
> 
> HTH.
> 
> -Original Message-
> Sent: Tuesday, July 01, 2003 12:15 PM
> To: Multiple recipients of list ORACLE-L
> 
> Hi listers,
> 
> I am working on a nt script. I download FORFILE exe, it works fine. My
> intention is finding the ORA-03113 string in the log. If there is a
> match, then reboot the server, else do nothing. I don't have problem
> with the findstr part. However, the errorlevel always return 0, no
> matter it find the error or not. So the if statement is not working.
Can
> somebody give me some light on NT syntax? On unix, it is so easy to
> script the condition. Please help,
> 
> Thanks,
> 
> Joan
> 
>  FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0
-c"CMD
> /c type d:[EMAIL PROTECTED]|findstr ORA-03113"
> if errorlevel 1 goto run_proc
> echo 'there is a match'
> 
> if errorlevel 0 goto end
> echo 'there is no match'
> 
> :run_proc
> d:\start_proc.bat
> goto end
> 
> :end
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Joan Hsieh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Seefelt, Beth
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Microsoft VS Oracle (again)

2003-07-01 Thread Gabriel Aragon

mmm maybe I was not clear, my intention was to show
you what I call the MS's "desperated" cry for help.. I
love Oracle! for ever!

I just want to hear some comments about the 'facts'
they put there, I mean, how much is true?

;-)

--- "Jamadagni, Rajendra"
<[EMAIL PROTECTED]> wrote:
> Aargh ...
> 
> you must be very brave telling a Oracle cult to move
> to SQL Server ...
> 
> How do we know you are not Billy G using an alias
> ...
> 
> 8>)
> 
> Raj
>

> 
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly
> personal.
> QOTD: Any clod can have facts, having an opinion is
> an art !
> 
> 
> -Original Message-
> Sent: Tuesday, July 01, 2003 1:00 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> FYI
> 
> One of my friends at Microsoft, (yes I must to
> confess, I have friends at MS) gave me a "present",
> it's a 4 cd's kit called "SQL Server 2000 for the
> Oracle Customer", the kit consist in 4 cd's with
> demos, docs, presentations, videos and a lot of
> stuff
> showing why sql server is a better option as a DB
> instead oracle, contains price lists, performance
> evaluation and many other "information", maybe you'd
> like to spend some of your time giving Billy a
> chance
> to defend his product. The 4 cd's are available
> (almost completely) as links in:
> 
> http://www.microsoft.com/sql/oraclekit
> 
> Any comments?
> 
> Gabriel
> >
*This
> e-mail message is confidential, intended only for
> the named recipient(s) above and may contain
> information that is privileged, attorney work
> product or exempt from disclosure under applicable
> law. If you have received this message in error, or
> are not the named recipient(s), please immediately
> notify corporate MIS at (860) 766-2000 and delete
> this e-mail message from your computer, Thank
>
you.*1
> 


=
"Any dream worth having is a dream worth fighting for"(Cualquier sueño que valga la 
pena tener, es un sueño por el que vale la pena luchar)Charles Xavier

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gabriel Aragon
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Do Not Call

2003-07-01 Thread KENNETH JANUSZ

Probably MS Access.

My $0.02 worth,

Ken Janusz, CPIM


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 01, 2003 12:59 PM


> There have been over 10,000,000 entries made in the National Do Not Call
> Registry since Friday June 27. Does anyone know the database engine in
> which this is stored? 
> 
> 
> Curious in Bozeman, MT
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: KENNETH JANUSZ
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Do Not Call

2003-07-01 Thread Gene Sais




http://uptime.netcraft.com/up/graph/?host=www.donotcall.gov
 
Well, if it were unix then it couldn't be SQLserver.  It is Windows, 
therefore I assume its SQLserver, but it could be Oracle.  But who runs 
Oracle on Windows anyway *hahahaha*>>> 
[EMAIL PROTECTED] 07/01/03 02:29PM >>>
Paradox for DOS 
-Original Message- From: Orr, 
Steve [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, July 01, 2003 2:00 PM To: Multiple recipients of list ORACLE-L Subject: 
Do Not Call 
There have been over 10,000,000 entries made in the National Do 
Not Call Registry since Friday June 27. Does anyone know 
the database engine in which this is stored? 

Curious in Bozeman, MT -- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- Author: Orr, Steve   INET: [EMAIL PROTECTED] 
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California    
-- Mailing list and web hosting services - 
To REMOVE yourself from this mailing list, send an E-Mail 
message to: [EMAIL PROTECTED] (note EXACT spelling of 
'ListGuru') and in the message BODY, include a line 
containing: UNSUB ORACLE-L (or the name of mailing list 
you want to be removed from).  You may also send 
the HELP command for other information (like subscribing).

Re: nt script

Hi Seefelt,

with or without match, I added ORA-03113 and deleted it later to test
both case. They all run ERRORLEVERL 1 condition. No matter what.

Joan

CODE:

FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0 -c"CMD
/c type d:[EMAIL PROTECTED]|findstr ORA-03113" 

IF ERRORLEVEL 1 ( echo 'there is no match' ) 
goto :no
IF NOT ERRORLEVEL 1 (echp 'there is a match')
GOTO :RUN_PROC
:run_proc
rem d:\psfm\start_proc_sched.bat
echo run
pause
goto end
:no
echo do nothing

TEST RUN WITHOUT MATCH;

D:\oracle\admin>FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s
-m*.log  -d+0 -c"CMD /c echo @FILE"
PSPRCSRV_PSNT_0630.log
PSPRCSRV_PSNT_0701.log

D:\oracle\admin>echo on

D:\oracle\admin>rem FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s
-m*.log  -d+0 -c"CMD /c type d:\
[EMAIL PROTECTED]|findstr ORA-03113
>D:\oracle\admin\test.log"

D:\oracle\admin>FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s
-m*.log  -d+0 -c"CMD /c type d:\pslo
[EMAIL PROTECTED]|findstr ORA-03113"

D:\oracle\admin>IF ERRORLEVEL 1 (echo 'there is no match'  )
D:\oracle\admin>goto :no
D:\oracle\admin>echo do nothing
do nothing
D:\oracle\admin>goto end
D:\oracle\admin>echo "finished"
"finished"

TEST RUN WITH A MATCH;

D:\oracle\admin>FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s
-m*.log  -d+0 -c"CMD /c type d:\pslog
[EMAIL PROTECTED]|findstr ORA-03113"
ORA-03113

D:\oracle\admin>IF ERRORLEVEL 1 (echo 'there is no match'  )
D:\oracle\admin>goto :no
D:\oracle\admin>echo do nothing
do nothing
D:\oracle\admin>goto end
D:\oracle\admin>echo "finished"
"finished"


"Seefelt, Beth" wrote:
> 
> BTW, it can also be written like this.  Just FYI.
> 
> FINDSTR /S /I /L "ORA-03113" d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log
> if errorlevel 1 ( echo 'there is a match'
>   d:\start_proc.bat )
> goto :EOF
> 
> -Original Message-
> Sent: Tuesday, July 01, 2003 12:35 PM
> To: [EMAIL PROTECTED]
> 
> Hi,
> 
> I think FORFILES is probably overkill here.  And it probably is only
> going to return the errorlevel for the last file checked.  Just use
> FINDSTR with a wildcard.
> 
> FINDSTR /S /I /L "ORA-03113" d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log
> if errorlevel 1 goto run_proc
> echo 'there is a match'
> 
> if errorlevel 0 goto end
> echo 'there is no match'
> 
> :run_proc
> d:\start_proc.bat
> goto end
> 
> :end
> 
> HTH.
> 
> -Original Message-
> Sent: Tuesday, July 01, 2003 12:15 PM
> To: Multiple recipients of list ORACLE-L
> 
> Hi listers,
> 
> I am working on a nt script. I download FORFILE exe, it works fine. My
> intention is finding the ORA-03113 string in the log. If there is a
> match, then reboot the server, else do nothing. I don't have problem
> with the findstr part. However, the errorlevel always return 0, no
> matter it find the error or not. So the if statement is not working. Can
> somebody give me some light on NT syntax? On unix, it is so easy to
> script the condition. Please help,
> 
> Thanks,
> 
> Joan
> 
>  FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0 -c"CMD
> /c type d:[EMAIL PROTECTED]|findstr ORA-03113"
> if errorlevel 1 goto run_proc
> echo 'there is a match'
> 
> if errorlevel 0 goto end
> echo 'there is no match'
> 
> :run_proc
> d:\start_proc.bat
> goto end
> 
> :end
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Joan Hsieh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Seefelt, Beth
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an

RE: Microsoft VS Oracle (again)

On which unix boxes does SQL Server work? I don't want to 
replace all of my AIX, HP-UX and Solaris boxes with NT.
I'll consider SQL Server as a replacement as soon as it starts
operating on Unix. Microsoft operating systems have spurned the whole
industry trying to protect them from viruses, which makes them completely
unsuitable for a central database of a Fortune 500 company. Does
SQL Server work on Linux?

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, July 01, 2003 1:00 PM
To: Multiple recipients of list ORACLE-L


FYI

One of my friends at Microsoft, (yes I must to
confess, I have friends at MS) gave me a "present",
it's a 4 cd's kit called "SQL Server 2000 for the
Oracle Customer", the kit consist in 4 cd's with
demos, docs, presentations, videos and a lot of stuff
showing why sql server is a better option as a DB
instead oracle, contains price lists, performance
evaluation and many other "information", maybe you'd
like to spend some of your time giving Billy a chance
to defend his product. The 4 cd's are available
(almost completely) as links in:

http://www.microsoft.com/sql/oraclekit

Any comments?

Gabriel

=
"Any dream worth having is a dream worth fighting for"(Cualquier sueño que
valga la pena tener, es un sueño por el que vale la pena luchar)Charles
Xavier

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gabriel Aragon
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Table CACHE/NOCACHE

2003-07-01 Thread Ravi Kulkarni

Guys,

Help me figure this one out. Was helping a colleague
diagnose slow response time (8.1.7/Solaris running
Peoplesoft ). x$bh showed 102,248 out of 170,000
buffers belonged to a single table, which he said he
cached explicitly. He did "NOCACHE" (on my suggestion)
on the large table. 
I still find that the table is in buffer cache (even
Buff# haven't changed - starts with buf#=1 - not sure
if this means LRU end) even after a week. DB cannot be
bounced since it is production. 
Do you know of any reason why it is not flushed out of
cache when table is altered to NoCache?

Thanks,
Ravi.

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ravi Kulkarni
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Tech meetings

2003-07-01 Thread Rudy Zung

Title: Message



Don't 
know if what we do in our shop here qualifies for your question or not, but our 
dev groups do "stand-up meetings." Relatively quick meetings (that can be done 
standing up; no meeting rooms required) that are usually finished in about 20 
minutes. In the stand-ups, we get heads-up for things and specifications that 
might be coming down the pipeline from the product management and design side. 
We get a quick update on the state of deployment (what version has rolled into 
production, what version is in the QA pipeline) and what the next impending set 
of changes are about to get pushed onto the dev servers. If there's any 
potential "gotcha"s that have been experienced (especially on the coding front) 
they get publicized in the stand-ups as well.
 
The 
main point of our stand-ups are to make sure that all the developers are 
relatively aware of the scheduling and direction of the product, and to 
highlight any programming difficulties and workarounds that might arise so that 
when different developers hit those gotchas, they'll already know that a 
solution might already.
 
These 
stand-up meetings are basically within a development team/group. Project leads 
have their own meetings with the product management group. So essentially, the 
product manager has his own meetings; then the product manager has meetings with 
the dev project leads to convey what they want in the next iteration of the 
product; the project leads then present these to the dev group in a stand-up 
meeting.

  
  -Original Message-From: M.Godlewski 
  [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 12:30 
  PMTo: Multiple recipients of list ORACLE-LSubject: Tech 
  meetings
  List,
   
  Just wondering if your organization has tech meetings, and what is 
  discussed and what the goals of the meetings are?
   
  I've been asked about this, and was wondering if there is a quick list 
  out there any where.
   
  TIA

RE: perl DBI/DBD: can I pass in an array as parameter?

2003-07-01 Thread STEVE OLLIG

if i get you right - you're trying to treat the resultset from a query as an
array in Perl.  That's the way it works.  Try something like this:

$sth = $dbh->prepare (" select  tab1.col1, tab2.col2 from tab1, tab2
   where tab1.ID1 = tab2.ID2
   and   tab1.X = ? ");
my $resultset = $sth->execute("value for X");
foreach (@$resultset) {
  my($col1, $col2) = @$_;
  # do more stuff
}

-Original Message-
Sent: Tuesday, July 01, 2003 11:20 AM
To: Multiple recipients of list ORACLE-L


Hi:

Does anyone know if I can pass an array in perl to an sql using DBI/DBD so
that I get result set from Oracle?

Specifically, I want do something like in perl:


$sth = $dbh->prepare (" select  tab1.col1, tab2.col2 from tab1, tab2
   where tab1.ID1 = tab2.ID2
   and   tab1.X = ? ");

my @my_array;

# filling in my_array with data here

$sth->execute(@my_array);

my ($col1, $col2);
while(($col1, $col2) = $sth->fetchrow_array())  {

  # do processing of $col1 and $col2;
}

I am hoping to save repeated sql calls, do only one call and get all the
rows back.

Is it possible in any version DBI/DBD? I looked at

http://perldoc.com/perl5.6.1/lib/DBI.html

and I does not seem to be able to figure it out. If it is possible, any
simple example code somewhere?

Thanks.

Guang

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Guang Mei
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: STEVE OLLIG
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Do Not Call

2003-07-01 Thread Adams, Matthew (GECP, MABG, 088130)

Title: RE: Do Not Call





Turbo Pascal Database Toolbox


http://www.emsps.com/oldtools/borpasv.htm#tpdb



Matt Adams - GE Appliances - [EMAIL PROTECTED]
Another month has ended.
All Targets Met. All Systems Working.
All Customers Satisfied. All Staff Enthusiastic. 
All Pigs Fed And Ready To Fly.


-Original Message-
From: Orr, Steve [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 01, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L
Subject: Do Not Call



There have been over 10,000,000 entries made in the National Do Not Call
Registry since Friday June 27. Does anyone know the database engine in
which this is stored? 



Curious in Bozeman, MT
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: nt script

2003-07-01 Thread Bob Metelsky



Don't run it line by line
Save it to a file called myfind.bat

Then call from a command prompt

C:\> myfind.bat

Or click the batch file, be sure to leave the pause so you can see an
error if any. Once its working, you can then implemet blat as someone
suggested


Here is a version using variables

##

[myfind.bat]
:: Find example by BMetelsky on  Friday-April-11-2003-9:22:53 AM 
:: This script searches thefile for a string and if it finds it, sends
an email message to dbamail
:: 0 =is found 
echo off
set themess=A Database SERVICE on %computername% is NOT running on
%date% at %time%
set [EMAIL PROTECTED]
set blatfile=D:\dbmon\blattext.txt
set thefile=D:\dbmon\runit.log
set subject=A DB SERVICE IS NOT RUNNING
set [EMAIL PROTECTED]
echo starting >%blatfile%

find "ERROR:" %thefile% >NUL

IF ERRORLEVEL 1 GOTO no
IF NOT ERRORLEVEL 1 GOTO yes
:no
goto end

:yes
echo A db service is down on %computername%>%blatfile%
blat D:\dbmon\blattext.txt -subject "%subject%" -to "%dbamail%" -i
"%from%" -body "%themess%"
goto end

:end
@exit
rem echo %errorlevel%

##



> Hi Bob, thanks for the reply. I added your code and tested 
> still no good. I tested the case without a match. Still go to run.
> 
> Joan
> 
> D:\oracle\admin>FORFILES 
> -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0 -c"CMD 
> /c echo @FILE" PSPRCSRV_PSNT_0630.log PSPRCSRV_PSNT_0701.log
> 
> D:\oracle\admin>echo on
> 
> D:\oracle\admin>FORFILES 
> -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0 -c"CMD 
> /c type d:\pslog [EMAIL PROTECTED]|findstr ORA-03113 
> >D:\oracle\admin\test.log"
> 
> D:\oracle\admin>rem FORFILES 
> -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0 -c"CMD 
> /c type d:\p [EMAIL PROTECTED]|findstr ORA-03113" >NUL
> 
> D:\oracle\admin>IF ERRORLEVEL 1 GOTO no
> 
> D:\oracle\admin>IF NOT ERRORLEVEL 1 GOTO RUN_PROC
> 
> D:\oracle\admin>rem d:\psfm\start_proc_sched.bat
> 
> D:\oracle\admin>echo run
> run
> 
> D:\oracle\admin>pause
> Press any key to continue . . .
> 
> D:\oracle\admin>goto end
> 
> D:\oracle\admin>echo "finished"
> "finished"
> 
> D:\oracle\admin>rem if errorlevel 1 @d:\psfm\start_proc_sched.bat
> 
> Bob Metelsky wrote:
> > 
> > echo off
> > @cls
> > find "ORA-124" C:\yourlog.txt >NUL
> > 
> > IF ERRORLEVEL 1 GOTO no
> > IF NOT ERRORLEVEL 1 GOTO yes
> > 
> > :no
> > ECHO NOT FOUND
> > goto end
> > 
> > :yes
> >  ECHO String IS found
> > pause
> > goto end
> > 
> > :end
> > exit
> > 
> > >
> > > Hi listers,
> > >
> > > I am working on a nt script. I download FORFILE exe, it 
> works fine. 
> > > My intention is finding the ORA-03113 string in the log. 
> If there is 
> > > a match, then reboot the server, else do nothing. I don't have 
> > > problem with the findstr part. However, the errorlevel 
> always return 
> > > 0, no matter it find the error or not. So the if statement is not 
> > > working. Can somebody give me some light on NT syntax? On 
> unix, it 
> > > is so easy to script the condition. Please help,
> > >
> > > Thanks,
> > >
> > > Joan
> > >
> > >
> > >  FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log
> > > -d+0 -c"CMD /c type
> > > d:[EMAIL PROTECTED]|findstr ORA-03113" if 
> > > errorlevel 1 goto run_proc echo 'there is a match'
> > >
> > > if errorlevel 0 goto end
> > > echo 'there is no match'
> > >
> > > :run_proc
> > > d:\start_proc.bat
> > > goto end
> > >
> > > :end
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Joan Hsieh
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 
> http://www.fatcity.com
> > > San Diego, California-- Mailing list and web 
> hosting services
> > > 
> 
> > > -
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
> > > and in the message BODY, include a line containing: UNSUB
> > > ORACLE-L (or the name of mailing list you want to be removed
> > > from).  You may also send the HELP command for other
> > > information (like subscribing).
> > >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Bob Metelsky
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web 
> hosting services
> > 
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> > the message BODY, include a line containing: UNSUB ORACLE-L (or the 
> > name of mailing list you want to be removed from).  You may 
> also send 
> > the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L

Re: Need Script!!

2003-07-01 Thread Brian_P_MacLean


For the mail part use...

On this page  ->
http://www.interlog.com/~tcharron/blat.html
Download and install his file ->
http://www.interlog.com/~tcharron/blat194.zip
To send mail from a *.bat script-> blat %myfile.log% -subject
"%mysubject%" -to %toaddress% -f %fromaddress%


For the scripting part you can do it all in simple dos bat files (really U
can), perl (use ActivePerl from http://www.activestate.com), or you can do
the Unix thingy by searching Google for Windows ports of Unix commands,
they are easy to find, start here ->
http://www.weihenstephan.de/~syring/win32/UnxUtils.html




   
 
  "Senthil Kumar D"
 
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> 
  tworks.com> cc:  
 
  Sent by:Subject:  Need Script!!  
 
  [EMAIL PROTECTED]
  
  m
 
   
 
   
 
  07/01/2003 08:19 AM  
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 




Hi Group,

In one of our client place we are having Oracle 8.1.7 (std Ed) on NT.

Here we need to send mails if the DB is down or if the listener is down or
any errors in the alert log is found. In Unix we can use shell scripts and
awk to do this. What about in NT/

Guru's do you have any scripts to do the same.

Please help me in this.

TIA,
Senthil.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Senthil Kumar D
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Logical standby

2003-07-01 Thread Paul Baumgartel

I misspoke--there ARE in fact orphan records in the child table, and
they're the ones inserted by the import on the primary.  So this would
seem to be a problem of the order in which operations are applied on
the standby--perhaps due to parallelism in the apply process.  

Am I making any sense here?  ;-)



--- Paul Baumgartel <[EMAIL PROTECTED]> wrote:
> I have successfully (on the third attempt) gotten a logical standby
> database up, running, and applying changes from the primary. 
> However,
> I quickly ran into a problem, and I'm wondering if anyone else has
> seen
> it.  
> 
> On the primary, I ran a script that disables foreign keys, imports
> data
> into existing tables, and re-enables the FKs.  It runs with no errors
> on the primary, but the attempt to re-enable the first FK on the
> standby throws an error 
> 
> ORA-02298: cannot validate (.) - parent keys not found
> 
> However, (and here's the strange part), querying the table in
> question
> shows that there are _no_ orphan records in the child table.  In
> fact,
> a comparison of the tables on the two databases shows that their
> contents are identical.
> 
> Now, I know that applying DDL to a standby can be problematic, but
> this
> result makes no sense at all.  
> 
> Any ideas, comments, or expressions of sympathy are welcome.
> 
>  
> 
> 
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Paul Baumgartel
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Tech meetings

2003-07-01 Thread Johnston, Tim




We had 
these at the last place I was at...  The senior folks from the various 
teams would get together...  One person or group was designated to present 
a topic for the next meeting...  Neat idea but it 
failed at that location...  The reason?  The VP of App Dev decided he 
wanted to attend the meetings...  Which meant we spent every meeting 
teaching him the basics and never really getting to the good stuff...  It 
ended up being a huge waste of time for the majority of the people in the 
room...
 
Tim

  -Original Message-From: M.Godlewski 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 01, 2003 12:30 
  PMTo: Multiple recipients of list ORACLE-LSubject: Tech 
  meetings
  List,
   
  Just wondering if your organization has tech meetings, and what is 
  discussed and what the goals of the meetings are?
   
  I've been asked about this, and was wondering if there is a quick list 
  out there any where.
   
  TIA
   
  
  
  Do you Yahoo!?The New 
  Yahoo! Search - Faster. Easier. Bingo.

Re: Re: Should percent increase higher than 0 in 817?

2003-07-01 Thread rgaffuri

thank you. new project for me, so if im going to argue with someone who has been here 
for a while... want to be safe. 
> 
> From: Gaja Krishna Vaidyanatha <[EMAIL PROTECTED]>
> Date: 2003/07/01 Tue PM 02:25:00 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Should percent increase higher than 0 in 817?
> 
> Greetings,
> 
> Non-zero PCTINCREASE causes unnecessary free space
> fragmentation in your tablespaces and should be
> avoided. Especially in 8.1.7, where there is no need
> for this, given that locally-managed tablespaces are
> supported, where PCTINCREASE is NOT even relevant. If
> you use
> 
> One of the historical reasons for having a non-zero
> PCTINCREASE in the Oracle6 and Oracle7 days, was to
> urge SMON to automatically coalesce free space, at the
> end of the file, especially after an object is
> dropped. In 7.3, the alter tablespace XXX coalesce
> command was introduced, which provided on-demand
> coalescing even with PCTINCREASE at 0.
> 
> If you have dictionary-managed tablespaces try to
> convert to locally-managed tablespaces. Otherwise, use
> a PCTINCREASE of 0, use uniform extent sizes at the
> tablespace and DO NOT use extent-sizing at the
> object-level.
> 
> 
> Cheers,
> 
> 
> Gaja
> 
> --- [EMAIL PROTECTED] wrote:
> > Everything I have seen says no. I did the following.
> > 
> > Set PCTINCREASE = 0
> > Set my initial and next extents to 5m so they are
> > uniform. A woman I work with swears there is Oracle
> > documentation that in 817 PCTINCREASE should be
> > greater than 0 because the default is 50. 
> > 
> > 
> > ORA-03232 unable to allocate an extent of string
> > blocks from tablespace string
> > 
> > Cause: An attempt was made to specify a
> > HASH_MULTIBLOCK_IO_COUNT value that is greater than
> > the tablespace's NEXT value.
> > 
> > Action: Increase the value of NEXT for the
> > tablespace using ALTER TABLESPACE DEFAULT STORAGE or
> > decrease the value of HASH_MULTIBLOCK_IO_COUNT.
> > 
> > 
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > -- 
> > Author: <[EMAIL PROTECTED]
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California-- Mailing list and web
> > hosting services
> >
> -
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
> 
> 
> =
> 
> 
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Gaja Krishna Vaidyanatha
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Any Collaboration Suite or 9iAS listservers?

2003-07-01 Thread Paula_Stankus

Title: RE: Any Collaboration Suite or 9iAS listservers?





Guys,


Are there any 9ias listservers for admins?  What are the best references for 9ias for admins.  related to security, load balancing, performance tuning, high-availability.

Thanks,
Paula


-Original Message-
From: Larry Elkins [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 6:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Any Collaboration Suite or 9iAS listservers?



Brian and Michael,


Try some of the ODTUG list-servers at ODTUG
(http://www.odtug.com/subscrib.htm). 9iAS is discussed quite frequently (and
not always fondly ;)) on the DEV2K list as well as some of the others such
as the WEB and JAVA lists.


Regards,


Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Brian
> Dunbar
> Sent: Tuesday, December 31, 2002 12:29 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Any Collaboration Suite or 9iAS listservers?
>
>
> Question for the group;
>
> If there are no listservers/mail lists specific to 9iAS/'managing Oracle
> from a System Admin POV' ... would there be an interest in subscribing to
> such a list?
>
> I've learned a LOT from this list, but I'd estimate 60% - 70% of
> the content
> is of no interest to me at all, as I'm not a DBA or a developer...
>
> thanks,
>
> ~brian
>
>
> -Original Message-
> Sent: Monday, December 30, 2002 8:04 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Does anyone know of any Collaboration Suite or 9iAS specific
> listservers?  I
> tried subscribing to the webcys_l listserver but it appears to be
> inactive.
>
> TIA...
>
> 
> Michael D. Gilly Sr.
> email: [EMAIL PROTECTED]
> 
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Brian Dunbar
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California    -- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Larry Elkins
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Tech meetings

2003-07-01 Thread Farnsworth, Dave




Preferably to be held at a local 
pub.

  -Original Message-From: M.Godlewski 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 01, 2003 11:30 
  AMTo: Multiple recipients of list ORACLE-LSubject: Tech 
  meetings
  List,
   
  Just wondering if your organization has tech meetings, and what is 
  discussed and what the goals of the meetings are?
   
  I've been asked about this, and was wondering if there is a quick list 
  out there any where.
   
  TIA
   
  
  
  Do you Yahoo!?The New 
  Yahoo! Search - Faster. Easier. Bingo.

RE: Do Not Call

2003-07-01 Thread Loughmiller, Greg

Title: RE: Do Not Call





Paradox for DOS




-Original Message-
From: Orr, Steve [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 01, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L
Subject: Do Not Call



There have been over 10,000,000 entries made in the National Do Not Call
Registry since Friday June 27. Does anyone know the database engine in
which this is stored? 



Curious in Bozeman, MT
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: nt script

Hi Bob, thanks for the reply. I added your code and tested still no
good. I tested the case without a match. Still go to run.

Joan

D:\oracle\admin>FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s
-m*.log  -d+0 -c"CMD /c echo @FILE"
PSPRCSRV_PSNT_0630.log
PSPRCSRV_PSNT_0701.log

D:\oracle\admin>echo on

D:\oracle\admin>FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s
-m*.log  -d+0 -c"CMD /c type d:\pslog
[EMAIL PROTECTED]|findstr ORA-03113 >D:\oracle\admin\test.log"

D:\oracle\admin>rem FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s
-m*.log  -d+0 -c"CMD /c type d:\p
[EMAIL PROTECTED]|findstr ORA-03113" >NUL

D:\oracle\admin>IF ERRORLEVEL 1 GOTO no

D:\oracle\admin>IF NOT ERRORLEVEL 1 GOTO RUN_PROC

D:\oracle\admin>rem d:\psfm\start_proc_sched.bat

D:\oracle\admin>echo run
run

D:\oracle\admin>pause
Press any key to continue . . .

D:\oracle\admin>goto end

D:\oracle\admin>echo "finished"
"finished"

D:\oracle\admin>rem if errorlevel 1 @d:\psfm\start_proc_sched.bat

Bob Metelsky wrote:
> 
> echo off
> @cls
> find "ORA-124" C:\yourlog.txt >NUL
> 
> IF ERRORLEVEL 1 GOTO no
> IF NOT ERRORLEVEL 1 GOTO yes
> 
> :no
> ECHO NOT FOUND
> goto end
> 
> :yes
>  ECHO String IS found
> pause
> goto end
> 
> :end
> exit
> 
> >
> > Hi listers,
> >
> > I am working on a nt script. I download FORFILE exe, it works
> > fine. My intention is finding the ORA-03113 string in the
> > log. If there is a match, then reboot the server, else do
> > nothing. I don't have problem with the findstr part. However,
> > the errorlevel always return 0, no matter it find the error
> > or not. So the if statement is not working. Can somebody give
> > me some light on NT syntax? On unix, it is so easy to script
> > the condition. Please help,
> >
> > Thanks,
> >
> > Joan
> >
> >
> >  FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log
> > -d+0 -c"CMD /c type
> > d:[EMAIL PROTECTED]|findstr ORA-03113"
> > if errorlevel 1 goto run_proc echo 'there is a match'
> >
> > if errorlevel 0 goto end
> > echo 'there is no match'
> >
> > :run_proc
> > d:\start_proc.bat
> > goto end
> >
> > :end
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Joan Hsieh
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
> > and in the message BODY, include a line containing: UNSUB
> > ORACLE-L (or the name of mailing list you want to be removed
> > from).  You may also send the HELP command for other
> > information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Bob Metelsky
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: nt script

Thanks Seefelt,

I need to get the most recent log to check. There are more than 30 logs
on that directory. I just check the most currenct one. That's why I use
d+0 still it give me 2 files. Is there any way I can just get one file?

Jon



"Seefelt, Beth" wrote:
> 
> Hi,
> 
> I think FORFILES is probably overkill here.  And it probably is only
> going to return the errorlevel for the last file checked.  Just use
> FINDSTR with a wildcard.
> 
> FINDSTR /S /I /L "ORA-03113" d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log
> if errorlevel 1 goto run_proc
> echo 'there is a match'
> 
> if errorlevel 0 goto end
> echo 'there is no match'
> 
> :run_proc
> d:\start_proc.bat
> goto end
> 
> :end
> 
> HTH.
> 
> -Original Message-
> Sent: Tuesday, July 01, 2003 12:15 PM
> To: Multiple recipients of list ORACLE-L
> 
> Hi listers,
> 
> I am working on a nt script. I download FORFILE exe, it works fine. My
> intention is finding the ORA-03113 string in the log. If there is a
> match, then reboot the server, else do nothing. I don't have problem
> with the findstr part. However, the errorlevel always return 0, no
> matter it find the error or not. So the if statement is not working. Can
> somebody give me some light on NT syntax? On unix, it is so easy to
> script the condition. Please help,
> 
> Thanks,
> 
> Joan
> 
>  FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0 -c"CMD
> /c type d:[EMAIL PROTECTED]|findstr ORA-03113"
> if errorlevel 1 goto run_proc
> echo 'there is a match'
> 
> if errorlevel 0 goto end
> echo 'there is no match'
> 
> :run_proc
> d:\start_proc.bat
> goto end
> 
> :end
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Joan Hsieh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Seefelt, Beth
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: nt script


BTW, it can also be written like this.  Just FYI.


FINDSTR /S /I /L "ORA-03113" d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log
if errorlevel 1 ( echo 'there is a match'
  d:\start_proc.bat )
goto :EOF



-Original Message-
Sent: Tuesday, July 01, 2003 12:35 PM
To: [EMAIL PROTECTED]



Hi,

I think FORFILES is probably overkill here.  And it probably is only
going to return the errorlevel for the last file checked.  Just use
FINDSTR with a wildcard.

FINDSTR /S /I /L "ORA-03113" d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log
if errorlevel 1 goto run_proc
echo 'there is a match'

if errorlevel 0 goto end
echo 'there is no match'

:run_proc
d:\start_proc.bat
goto end

:end


HTH.


-Original Message-
Sent: Tuesday, July 01, 2003 12:15 PM
To: Multiple recipients of list ORACLE-L


Hi listers,

I am working on a nt script. I download FORFILE exe, it works fine. My
intention is finding the ORA-03113 string in the log. If there is a
match, then reboot the server, else do nothing. I don't have problem
with the findstr part. However, the errorlevel always return 0, no
matter it find the error or not. So the if statement is not working. Can
somebody give me some light on NT syntax? On unix, it is so easy to
script the condition. Please help,

Thanks,

Joan


 FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0 -c"CMD
/c type d:[EMAIL PROTECTED]|findstr ORA-03113"
if errorlevel 1 goto run_proc
echo 'there is a match'

if errorlevel 0 goto end
echo 'there is no match'

:run_proc
d:\start_proc.bat
goto end

:end
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Should percent increase higher than 0 in 817?

2003-07-01 Thread Gaja Krishna Vaidyanatha

Greetings,

Non-zero PCTINCREASE causes unnecessary free space
fragmentation in your tablespaces and should be
avoided. Especially in 8.1.7, where there is no need
for this, given that locally-managed tablespaces are
supported, where PCTINCREASE is NOT even relevant. If
you use

One of the historical reasons for having a non-zero
PCTINCREASE in the Oracle6 and Oracle7 days, was to
urge SMON to automatically coalesce free space, at the
end of the file, especially after an object is
dropped. In 7.3, the alter tablespace XXX coalesce
command was introduced, which provided on-demand
coalescing even with PCTINCREASE at 0.

If you have dictionary-managed tablespaces try to
convert to locally-managed tablespaces. Otherwise, use
a PCTINCREASE of 0, use uniform extent sizes at the
tablespace and DO NOT use extent-sizing at the
object-level.

Cheers,

Gaja

--- [EMAIL PROTECTED] wrote:
> Everything I have seen says no. I did the following.
> 
> Set PCTINCREASE = 0
> Set my initial and next extents to 5m so they are
> uniform. A woman I work with swears there is Oracle
> documentation that in 817 PCTINCREASE should be
> greater than 0 because the default is 50. 
> 
> 
> ORA-03232 unable to allocate an extent of string
> blocks from tablespace string
> 
> Cause: An attempt was made to specify a
> HASH_MULTIBLOCK_IO_COUNT value that is greater than
> the tablespace's NEXT value.
> 
> Action: Increase the value of NEXT for the
> tablespace using ALTER TABLESPACE DEFAULT STORAGE or
> decrease the value of HASH_MULTIBLOCK_IO_COUNT.
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: <[EMAIL PROTECTED]
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).

=

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gaja Krishna Vaidyanatha
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: nt script


Hi,

I think FORFILES is probably overkill here.  And it probably is only
going to return the errorlevel for the last file checked.  Just use
FINDSTR with a wildcard.

FINDSTR /S /I /L "ORA-03113" d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log
if errorlevel 1 goto run_proc
echo 'there is a match'

if errorlevel 0 goto end
echo 'there is no match'

:run_proc
d:\start_proc.bat
goto end

:end


HTH.


-Original Message-
Sent: Tuesday, July 01, 2003 12:15 PM
To: Multiple recipients of list ORACLE-L


Hi listers,

I am working on a nt script. I download FORFILE exe, it works fine. My
intention is finding the ORA-03113 string in the log. If there is a
match, then reboot the server, else do nothing. I don't have problem
with the findstr part. However, the errorlevel always return 0, no
matter it find the error or not. So the if statement is not working. Can
somebody give me some light on NT syntax? On unix, it is so easy to
script the condition. Please help,

Thanks,

Joan


 FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0 -c"CMD
/c type d:[EMAIL PROTECTED]|findstr ORA-03113"
if errorlevel 1 goto run_proc
echo 'there is a match'

if errorlevel 0 goto end
echo 'there is no match'

:run_proc
d:\start_proc.bat
goto end

:end
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Tech meetings

2003-07-01 Thread Rachel Carmichael

we've started them recently -- only had two so far, part 1 and 2
presentations/interactive sessions on "extreme programming"

the goal is to get us talking across the various application groups,
spread knowledge, learn some of the newer techniques out there.

No one has (yet) asked me to do one or more presentations on Oracle
though.

--- "M.Godlewski" <[EMAIL PROTECTED]> wrote:
> List,
>  
> Just wondering if your organization has tech meetings, and what is
> discussed and what the goals of the meetings are?
>  
> I've been asked about this, and was wondering if there is a quick
> list out there any where.
>  
> TIA
> 
> 
>  
> 
> 
> -
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Microsoft VS Oracle (again)

2003-07-01 Thread Jamadagni, Rajendra

Title: RE: Microsoft VS Oracle (again)





Aargh ...


you must be very brave telling a Oracle cult to move to SQL Server ...


How do we know you are not Billy G using an alias ...


8>)


Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !



-Original Message-
From: Gabriel Aragon [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 01, 2003 1:00 PM
To: Multiple recipients of list ORACLE-L
Subject: Microsoft VS Oracle (again)



FYI


One of my friends at Microsoft, (yes I must to
confess, I have friends at MS) gave me a "present",
it's a 4 cd's kit called "SQL Server 2000 for the
Oracle Customer", the kit consist in 4 cd's with
demos, docs, presentations, videos and a lot of stuff
showing why sql server is a better option as a DB
instead oracle, contains price lists, performance
evaluation and many other "information", maybe you'd
like to spend some of your time giving Billy a chance
to defend his product. The 4 cd's are available
(almost completely) as links in:


http://www.microsoft.com/sql/oraclekit


Any comments?


Gabriel



*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

Re: nt script

I got it from http://www.ipass.net/davesisk/oont_download.htm

[EMAIL PROTECTED] wrote:
> 
> Joan:
> 
> Where did you get the FORFILE.EXE program from? And, yes I will look at the
> NT script.
> 
> RWB
> 
> 
> Reginald W. Bailey
> IBM Global Services - ETS SW GDSD - Database Management
> Your Friendly Neighborhood DBA
> 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> 
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Logical standby

2003-07-01 Thread Paul Baumgartel

I have successfully (on the third attempt) gotten a logical standby
database up, running, and applying changes from the primary.  However,
I quickly ran into a problem, and I'm wondering if anyone else has seen
it.  

On the primary, I ran a script that disables foreign keys, imports data
into existing tables, and re-enables the FKs.  It runs with no errors
on the primary, but the attempt to re-enable the first FK on the
standby throws an error 

ORA-02298: cannot validate (.) - parent keys not found

However, (and here's the strange part), querying the table in question
shows that there are _no_ orphan records in the child table.  In fact,
a comparison of the tables on the two databases shows that their
contents are identical.

Now, I know that applying DDL to a standby can be problematic, but this
result makes no sense at all.  

Any ideas, comments, or expressions of sympathy are welcome.

 


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Upgrade 8.1.7.3.0 to 8.1.7.4.1 on W2K

2003-07-01 Thread Reginald . W . Bailey


Try telling it very nicely. :)
Try looking in the registry under HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE.
You can change the home location of the appropriate instance (HOME0, HOME1,
etc.) there. Change it in the main Oracle directory then in the individual
HOME(n) folder.
I hope this helps.




Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECTED]
[EMAIL PROTECTED]



   
  
[EMAIL PROTECTED]  
 
EMS.NL   To: [EMAIL PROTECTED] 
   
Sent by: cc:   
  
[EMAIL PROTECTED]   Subject: Upgrade 8.1.7.3.0 to 
8.1.7.4.1 on W2K  
ity.com
  
   
  
   
  
07/01/2003 
  
10:55 AM   
  
Please respond 
  
to ORACLE-L
  
   
  
   
  






Hi All,

We have a test machine with both the 81730 and 81741 software in their own
oracle homes.
We now want to move a database from the 81730 home to 81741

I know I have to run the catalog.sql, catproc.sql from the new home etc...
But how do I tell the registry that the database moved homes??

TiA

Jacob A. van Zanen
Oracle DBA
Quant Systems Europe b.v.
Tel : +31 (0) 251 - 268 268
Mobile: +31 (0) 6 51308813
Fax: +31 (0) 251 - 268 269
E-mail: [EMAIL PROTECTED]
Visit our web site at http://www.quantsystems.nl/





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: RMAN Recovery Question: Restore with loss of control files an

2003-07-01 Thread Jared Still


I'm now working on the problem of restoring a database
from one server to another, with different directory 
locations and names. ( on Windoze )

I've got the syntax down, but there's something missing
in the Veritas docs, and I'm not quite there yet.  

Guess I'll have to call Veritas support now.  If you've
ever complained about Oracle support...

I'll post the solution when done.

Jared

On Tuesday 01 July 2003 08:40, Paul Baumgartel wrote:
> 1.  I have configured RMAN for controlfile autobackup, so that every DB
> backup produces a backup of the controlfiles and spfile as well.  With
> these, I can easily recover from a loss of every single database file.
> I can't imagine why anyone wouldn't do it this way (reponses invited).
>
> 2.  MetaLink states that the location of a backup file is embedded in
> the file itself, that it can't be used if it's moved to another
> location, and that this is a feature (yeah, right).  On Unix, symlinks
> will do the trick; on Windoze, the suggested workaround is to back up
> the backup to another location that matches the one from which you want
> to use it.  I ran into this when restoring a backup on another system
> that had a different drive layout; rather than backing up the backup, I
> just juggled drive letters.  The lesson here is to ensure that your
> backup directories are configured and named consistently across all
> database servers.
>
> --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> > Timothy
> >   I will tell you what I've figured out. Perhaps someone else can
> > provide additional information.
> >
> > 1. Some people have reported success in extracting the control file
> > from the RMAN backup. I got stuck on the issue that RMAN wouldn't
> > function unless the target instance was up with STARTUP MOUNT, but I
> > couldn't mount the database
> > until I had a control file to mount. I finally gave up and took the
> > expedient of doing a separate SQL BACKUP CONTROLFILE statement, using
> > the RMAN backup directory. To perform a disaster recovery, I just
>
> move
>
> > my copy of the control file into position first.
> >
> > 2. I have not been able to convince RMAN to use a different backup
> > location.
> > Fortunately with Unix it is easy to create a link that looks like the
> > original location.
> >
> >
> >
> > Dennis Williams
> > DBA, 80%OCP, 100% DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED]
> >
> > -Original Message-
> > Sent: Monday, June 30, 2003 10:35 AM
> > To: Multiple recipients of list ORACLE-L
> > catalo database
> >
> >
> >
> > Hi there everyone,
> >
> > I have read the documentation and I am missing something, I am stuck
> > on two
> > points:
> >
> > (1) How do I recover from a RMAN backup to disk if I have lost all
> > the
> > original database files (control files, data files and redo logs)
> >
> > (2) How do I change the location for RMAN to check for the backup up
> > file
> > i.e. Backup file was on E: but now in F:, when I enter restore it
> > only
> > checks the original location.
> >
> >
> > Specifications:
> > Oracle  8.1.7.4.10
> > Windows 2000SP4
> >
> >
> > I know that in the backup part I can use the FORMAT string to specify
> > the
> > filename and location.
> >
> >
> > Cheers
> > Tim Clarkson
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: DENNIS WILLIAMS
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Do Not Call

There have been over 10,000,000 entries made in the National Do Not Call
Registry since Friday June 27. Does anyone know the database engine in
which this is stored? 


Curious in Bozeman, MT
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Tech meetings

List,
 
Just wondering if your organization has tech meetings, and what is discussed and what the goals of the meetings are?
 
I've been asked about this, and was wondering if there is a quick list out there any where.
 
TIA
 
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.

Re: Oracle DBA 9i Books ever needed.

2003-07-01 Thread Jared Still

Must have:

Expert one-on-one Oracle by Tom Kyte.
Wrox press is out of business, but there
are still copies available on Amazon.

Oracle DBA 101, by Marlene Theriault, Rachel Carmichael 
and James Viscusi.

Oracle Performance Tuning 101 by Gaja Vaidyanatha, 
Kirti Deshpande and John A. Kostelac

( I can spell Gaja's name without looking! )

And while not strictly necessary, it would make me
and Andy Duncan very happy if you would also get:

Perl for Oracle DBA's:)

Jared

On Tuesday 01 July 2003 01:39, Veeraraju_Mareddi wrote:
> Dear Friends,
>
> I am willing to buy Oracle DBA 9i books. ,I need your suggestion on this.
>
> I got information friends from this list that the book ("Practical Oracle
> 8i - Jonathan Lewis".) is practically good.  Even I am also looking for the
> same kind of book, But I want it for both 8i and 9i. It should be more
> practical oriented , performance tuning and real time database design and
> problems. The book should be more practical oriented .
>
> What abt performance tuning 101 techniques , Oracle 9i DBA handbook.
> What are the best books for Oracle DBA (Intermediate level ) available in
> INDIA , HYDERABAD.
>
> Any URL / best sites also will be helpful.
> Thanks
> Rajuveera
>
>
> **
> This email (including any attachments) is intended for the sole use of the
> intended recipient/s and may contain material that is CONFIDENTIAL AND
> PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
> distribution or forwarding of any or all of the contents in this message is
> STRICTLY PROHIBITED. If you are not the intended recipient, please contact
> the sender by email and delete all copies; your cooperation in this regard
> is appreciated.
> **

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Production Database stays up; copies will not recover

2003-07-01 Thread Hand, Michael T

Tru64 5.1
8.1.7.3
We had a disk controller fail last week, but redundant hardware let the
system stay up until it could be replaced over the weekend.  The production
database restarted without any problems, trace files, or alert log errors.

The problem is that the reporting copy of production, taken from a disk
mirror break (hot backup, mounted on a seperate system) will not recover.  I
get an ORA-1190 'controlfile or data file 1 is from before the last
RESETLOGS' but the last resetlogs was over a month ago.  First attempt to
solve was to use a slightly older copy of the SYSTEM datafile from an
earlier backup disk mirror break (hot backup). Results were the same.  I
then assumed something was wrong with the controlfile, so I tried to rebuild
that.  No luck, the Create controlfile command returned a ORA1189 'file is
from a different RESETLOGS than previous files' against file#2 (even though
I replaced the file# 1's datafile with the original [neither copy of #1 was
opened]).

My worries are two-fold; 1) that there is a subtle error in the control file
or SYSTEM datafile that only an attempted recovery exposes and 2) any backup
taken after the hardware failure last week will not be viable.

Any suggestions as how to proceed to either prove or disprove this.

Thanks,
Mike Hand
Polaroid Corp

P.S.  I had hoped to go on vacation at the end of the week leaving a stable
database behind (for a change).

This transmission is intended only for use by the addressee(s) named herein and may 
contain information that is proprietary, confidential and/or legally privileged. If 
you are not the intended recipient, you are hereby notified that any disclosure, 
copying, distribution, or use of the information contained herein (including any 
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, 
please immediately contact the sender and destroy the material in its entirety, 
whether in electronic or hard copy format. Thank you.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hand, Michael T
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Should percent increase higher than 0 in 817?

2003-07-01 Thread rgaffuri

Everything I have seen says no. I did the following.

Set PCTINCREASE = 0
Set my initial and next extents to 5m so they are uniform. A woman I work with swears 
there is Oracle documentation that in 817 PCTINCREASE should be greater than 0 because 
the default is 50. 


ORA-03232 unable to allocate an extent of string blocks from tablespace string

Cause: An attempt was made to specify a HASH_MULTIBLOCK_IO_COUNT value that is greater 
than the tablespace's NEXT value.

Action: Increase the value of NEXT for the tablespace using ALTER TABLESPACE DEFAULT 
STORAGE or decrease the value of HASH_MULTIBLOCK_IO_COUNT.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Need Script!!

2003-07-01 Thread Alex

you can use perl from activestate.com. run your awk script through a2p and
see if it works. there are many mail modules... Mime::Lite, Mail::Send to
name a couple.

On Tue, 1 Jul 2003, Senthil Kumar D wrote:

> Hi Group,
>
> In one of our client place we are having Oracle 8.1.7 (std Ed) on NT.
>
> Here we need to send mails if the DB is down or if the listener is down or
> any errors in the alert log is found. In Unix we can use shell scripts and
> awk to do this. What about in NT/
>
> Guru's do you have any scripts to do the same.
>
> Please help me in this.
>
> TIA,
> Senthil.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Senthil Kumar D
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Alex
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Performance