RE: Any way to script or document jobs defined to the NT/MS2000 T
Ron, The only way I have found is to manually copy (through the GUI) the jobs to another location. Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 05 December 2002 14:24 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- We have started using the NT/MS2000 Task Scheduler instead of the 'AT' command to schedule jobs. I am concerned that if we lose the server we would lose the schedule and have to figure out how and When all the batch jobs were scheduled. Does anyone know a way to script or otherwise document jobs defined to the Task Scheduler? R. Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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.com -- Author: Bishop Lewis 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: Are There any way of calling NT OS Commands like print, del e
Shiva,
Attached is an email from Ankur Shah from another posting - have not tried it
myself but this may help.
Lewis Bishop
---
Barclays Enable - ISS - E-NTRUST/Bexleyheath NT
Oracle Database Consultant
Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R)
Phone : 020 8298 3418
Mobile: 07950 380857
Email : [EMAIL PROTECTED]
Enabling Competitive Advantage for Barclays in IT and
Business Processing
-Original
Message-
From: Baswannappa, Shiva
[mailto:[EMAIL PROTECTED]]
Sent: 05 December 2002 15:10
To: Multiple recipients of list
ORACLE-L
Subject: Are There any way of
calling NT OS Commands like print, del etc.
This
header confirms that this email message has been swept for the
presence of computer viruses.
Corporate IT
THE WOOLWICH
--
Hi Gurus
I am looking for easy of calling OS commands like
print, del, etc. from PL/SQL on a NT4 system running Oracle 8.1.7. I tried the
Java approach from oracle web site, it works for few commands and not all.
Any insight, direction and help to achieve is very
much appreciated.
Thanks in advance
Regards
Shiva
Baswannappa
Senior Developer
Digital Consulting and Software Services
Phone: 281.243.2658
Fax: 281.243.2504
Web: http://www.dcss.com
If the reader of this e-mail is not an intended
recipient, you have received this e-mail in error and any review,
dissemination, distribution or copying is strictly prohibited. If you have
received this e-mail in error, please notify the sender immediately by return
e-mail and permanently delete the copy you received. Thank you.
Sent: 30 September 2002 13:46
To: LazyDBA.com Discussion
This header confirms that this email message has been swept for the presence of
computer viruses.
Corporate IT
THE WOOLWICH
--
Many tasks have been automated using shell scripting languages. Frequently,
these shell scripts need to be called from an Oracle stored procedure, but no
direct interface to call shell scripts is provided. Oracle does, however,
provide a method for calling C and Java programs via external procedures. Since
many shell programmers have never programmed in C or Java, converting shell
scripts or writing new tasks in either of these languages is difficult and time
consuming.
This solution provides a C routine that will make OS calls, and these calls can
be commands, shell scripts, or other application programs. Using this method,
no C programming experience is required, but does allow existing and new tasks
to be written as shell scripts.
This article does not provide information to setup the database or
environment for external procedures.
Refer to How to Configure a UNIX Oracle Server to Use External Procedures for
information on setting up the Oracle Server machine.
The external procedure is written in C and compiled with the Oracle
makefile, and hence, an Oracle supported compiler for the specific UNIX
platform is required. See Certified
Compilers
From the Oracle server machine:
1. Create a file for the external procedure code:
shell.c
===
#include stdio.h
#include stdlib.h
#include string.h
void sh(char *);
void sh( char *cmd )
{
int num;
num = system(cmd);
}
2. Compile and link the C code into a shared library:
make -f $ORACLE_HOME/rdbms/demo/demo_rdbms.mk extproc_nocallback \
SHARED_LIBNAME=shell.so OBJS=shell.o
Log into SQL*Plus to perform the remaining steps.
3. Define the shared library in Oracle:
CREATE LIBRARY shell_lib IS 'full path to shared lib/shell.so'; /
4. Create the PL/SQL wrapper procedure:
CREATE OR REPLACE PROCEDURE shell (cmd IN CHAR)
AS EXTERNAL
NAME sh
LIBRARY shell_lib
LANGUAGE C
PARAMETERS (
cmd STRING);
/
5. Call a shell script:
SQL exec shell('sh myscript.sh');
PL/SQL procedure successfully completed.
===
HTHU
Ankur Shah
Oracle DBA
DHR-GA
- Original Message -
To: LazyDBA.com Discussion [EMAIL PROTECTED]
Sent: Monday, September 30, 2002 3:08 AM
But i want to call the shell script or the file from a stored procedure.
-Original Message-
Sent: Monday, September 30, 2002 12:33 PM
To: Dibyendu Kole-VP
there are cron jobs in unix, just like schedulers e.g. dbms_jobs in oracle. hope this
would solve your problem.
Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to [EMAIL PROTECTED]
To subscribe: send a blank email to [EMAIL PROTECTED]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
RE: Win2k Perl accessing Oracle Parameters?
/parameter with =
$ENV{}./span/fonto:p/o:p/p
p style=3D'margin-left:36.0pt'font size=3D2 face=3DArialspan =
style=3D'font-size:
10.0pt;font-family:Arial'But the ORACLE_HOME is not an environmental =
parameter
per se./span/font br
font size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;font-family:Arial'I have
a workaround by setting it up in the enviroment, however I would like =
to write
this script with the aim at it being machine =
unspecific./span/fonto:p/o:p/p
p style=3D'margin-left:36.0pt'font size=3D2 face=3DArialspan =
style=3D'font-size:
10.0pt;font-family:Arial'(Jared, hope you can answer me on this. Want =
to get a
copy of your book, unfortunately with the exchange rate and import =
taxes etc it
will cost me R590,00. Quiet a chunk of the ole budget, maybe early next =
year.)/span/fonto:p/o:p/p
p style=3D'margin-left:36.0pt'font size=3D2 face=3DArialspan =
style=3D'font-size:
10.0pt;font-family:Arial'Regards/span/font br
bifont face=3DArialspan =
style=3D'font-family:Arial;font-weight:bold;
font-style:italic'Denham Eva/span/font/i/b br
bifont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;font-family:Arial;
font-weight:bold;font-style:italic'Oracle DBA/span/font/i/b =
br
ifont size=3D2 color=3Dblack face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial;color:black;font-style:italic'quot;UNIX is =
basically a
simple operating system, but you have to be a genius to understand the
simplicity.quot;/span/font/i br
ifont size=3D2 color=3Dblack face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial;color:black;font-style:italic'Dennis =
Ritchie./span/font/i
o:p/o:p/p
div class=3DMsoNormal align=3Dcenter =
style=3D'margin-left:36.0pt;text-align:center'strongb
style=3D'mso-ansi-font-weight:normal;mso-bidi-font-weight:normal'font =
size=3D3
color=3D#a0 face=3DArialspan =
style=3D'font-size:12.0pt;font-family:Arial;
color:#A0;font-weight:normal'
hr size=3D2 width=3D100% align=3Dcenter
/span/font/b/strong/div
p class=3DMsoNormal style=3D'margin-left:36.0pt'strongbfont =
size=3D2
color=3D#a0 face=3DArialspan =
style=3D'font-size:10.0pt;font-family:Arial;
color:#A0'DISCLAIMER/span/font /b/strongo:p/o:p/p
p style=3D'margin-left:36.0pt'font size=3D1 face=3DArialspan =
style=3D'font-size:
7.5pt;font-family:Arial'This message is for the named person's use =
only. It
may contain confidential, proprietary or legally privileged =
information. No
confidentiality or privilege is waived or lost by any mistransmission. =
If you
receive this message in error, please immediately delete it and all =
copies of
it from your system, destroy any hard copies of it and notify the =
sender. You
must not, directly or indirectly, use, disclose, distribute, print, or =
copy any
part of this message if you are not the intended recipient. TFMC, its =
holding
company, and any of its subsidiaries each reserve the right to monitor =
and
manage all e-mail communications through its =
networks./span/fontfont
size=3D1span style=3D'font-size:7.5pt' /span/fonto:p/o:p/p
p style=3D'margin-left:36.0pt'font size=3D1 face=3DArialspan =
style=3D'font-size:
7.5pt;font-family:Arial'Any views expressed in this message are those =
of the
individual sender, except where the message states otherwise and the =
sender is
authorized to state them to be views of any such =
entity./span/fontfont
size=3D1span style=3D'font-size:7.5pt' /span/fonto:p/o:p/p
div class=3DMsoNormal align=3Dcenter =
style=3D'margin-left:36.0pt;text-align:center'font
size=3D3 face=3DTimes New Romanspan style=3D'font-size:12.0pt'
hr size=3D2 width=3D100% align=3Dcenter
/span/font/div
div class=3DMsoNormal align=3Dcenter =
style=3D'margin-left:36.0pt;text-align:center'font
size=3D3 face=3DTimes New Romanspan style=3D'font-size:12.0pt'
hr size=3D2 width=3D100% align=3Dcenter
/span/font/div
p class=3DMsoNormal style=3D'margin-left:36.0pt'font size=3D3
face=3DTimes New Romanspan style=3D'font-size:12.0pt'This e-mail =
message has
been scanned for Viruses and Content and cleared by strongbfont
color=3D#ff8000 face=3DTimes New Romanspan =
style=3D'color:#FF8000'MailMarshal/span/font
- /b/strongFor more information please visitstrongbfont
face=3DTimes New Roman /font/b/stronga
href=3Dhttp://www.marshalsoftware.com;strongbfont face=3DTimes =
New =
Romanwww.marshalsoftware.com/font/b/strong/astrongbfont
face=3DTimes New Roman =
/font/b/strongo:p/o:p/span/font/p
div class=3DMsoNormal align=3Dcenter =
style=3D'margin-left:36.0pt;text-align:center'font
size=3D3 face=3DTimes New Romanspan style=3D'font-size:12.0pt'
hr size=3D2 width=3D100% align=3Dcenter
/span/font/div
/div
/body
/html
--_=_NextPart_001_01C27F2F.5CF0F180--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bishop Lewis
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
RE: Download Oracle 7.3.4
Ahh, one of the hardcore diehards... Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 27 October 2002 03:38 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Anyone HERE actually get SCO 7.3.4 working on Linux? If so, anyone got a copy - I would love to take a pop at it (never had the opportunity). Yeah, I had SCO Oracle 7.x ( forget what the x was ) running on Linux about 7 years ago. Yeah, I was on the bleeding edge. :) There were compatibility libraries available for running SCO software on Linux. Worked great! Don't ask for details. That was 7 years ago. I don't even remember how old I was then. Jared Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 24 October 2002 15:34 To: Multiple recipients of list ORACLE-L Oooo! I forgot about the SCO. I never tried it but I had read about it. Those were the days eh? -Original Message- Sent: Thursday, October 24, 2002 5:39 AM To: Multiple recipients of list ORACLE-L Although, you should *apparently* be able to load the 7.3.4 version of SCO on Linux - or maybe that's just an urban myth! Yes, i remember installing the first version of 8 on Linux (hey I had some time on my hands) and it was a bit of a nightmare - back to the days when Oracle had 2 hits on metalink for Linux! ;-) Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 23 October 2002 22:29 To: Multiple recipients of list ORACLE-L The first version of Oracle that ran on Linux was the early adoptor pre-release of 8.0.5 in 1998 -Original Message- Sent: Wednesday, October 23, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Hi list, I need to do some testing in an Oracle 7.3.4 for linux (redhat), where can I download this Oracle version from? it doesn't appear to be online in OTN. thanks for your help. Greetings Diego Cutrone -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis 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: Download Oracle 7.3.4
Those were the days eh? Not really! ;-) It was a preverbial pain in the butt! ;-) Anyone HERE actually get SCO 7.3.4 working on Linux? If so, anyone got a copy - I would love to take a pop at it (never had the opportunity). Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 24 October 2002 15:34 To: Multiple recipients of list ORACLE-L Oooo! I forgot about the SCO. I never tried it but I had read about it. Those were the days eh? -Original Message- Sent: Thursday, October 24, 2002 5:39 AM To: Multiple recipients of list ORACLE-L Although, you should *apparently* be able to load the 7.3.4 version of SCO on Linux - or maybe that's just an urban myth! Yes, i remember installing the first version of 8 on Linux (hey I had some time on my hands) and it was a bit of a nightmare - back to the days when Oracle had 2 hits on metalink for Linux! ;-) Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 23 October 2002 22:29 To: Multiple recipients of list ORACLE-L The first version of Oracle that ran on Linux was the early adoptor pre-release of 8.0.5 in 1998 -Original Message- Sent: Wednesday, October 23, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Hi list, I need to do some testing in an Oracle 7.3.4 for linux (redhat), where can I download this Oracle version from? it doesn't appear to be online in OTN. thanks for your help. Greetings Diego Cutrone -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dcutrone 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.com -- Author: Sherman, Edward 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.com -- Author: Bishop Lewis 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.com -- Author: Sherman, Edward 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.com -- Author: Bishop Lewis 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
RE: Download Oracle 7.3.4
Although, you should *apparently* be able to load the 7.3.4 version of SCO on Linux - or maybe that's just an urban myth! Yes, i remember installing the first version of 8 on Linux (hey I had some time on my hands) and it was a bit of a nightmare - back to the days when Oracle had 2 hits on metalink for Linux! ;-) Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 23 October 2002 22:29 To: Multiple recipients of list ORACLE-L The first version of Oracle that ran on Linux was the early adoptor pre-release of 8.0.5 in 1998 -Original Message- Sent: Wednesday, October 23, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Hi list, I need to do some testing in an Oracle 7.3.4 for linux (redhat), where can I download this Oracle version from? it doesn't appear to be online in OTN. thanks for your help. Greetings Diego Cutrone -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dcutrone 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.com -- Author: Sherman, Edward 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.com -- Author: Bishop Lewis 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: Problem installing Oracle 8.1.7 on Windows 2000
I know you're getting loads of small tips and hints rather than solutions but here's another - I've only seen jrew go to 100% cpu when there was insufficient memory available... Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 16 October 2002 16:19 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Are you installing from the console? Trying to install from a terminal server session can give those kinds of problems on 2000. HTH, Beth -Original Message- Sent: Wednesday, October 16, 2002 10:34 AM To: Multiple recipients of list ORACLE-L Hi, I am installing Oracle 8.1.7 on a MS Windows 2000 SP 3 system. When I get to the Net8 Configuration assistant, process jrew.exe goes to 100% of the CPU. I have let it run for over 15 minutes before stopping it from the Oracle installer. The process stops using the CPU but the Oracle installer hangs. I have to cancel the installer. If I try to create a database, I get a TNS adapter error. I have installed 8.1.7 on Windows NT without a problem. I have opened a TAR. Anyone experience this problem? Any help will be greatly appreciated. Thanks. Larry Noble DBA Medrad Inc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Noble, Larry H. 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.com -- 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.com -- Author: Bishop Lewis 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: Kind of urgent database not autostarting after upgrade
Download the kill utility from www.sysinternals.com - that'll let you kill almost anything. I agree with previous posts in that you should try to kill off the services/shutdown the db, and remove them using ORADIM. If this doesn't remove the services then remove them using INSTSRV -REMOVE [1] from the resource kit (that will get rid of them), then recreate using ORADIM. Make sure you use the correct ORADIM binaries (right version) for the removal and recreation of the services. [1] Be aware though that once the services are gone, if you can't recreate them then you could be facing a more serious error than you currently have. Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 16 October 2002 16:40 To: Multiple recipients of list ORACLE-L I'm not sure about the upgrade from WinNT to Win2K, but the easiest remedy for the DB not auto-starting is to delete and re-create the service. You can use ORADIM, and then while re-creating the service, you can use option of autostart. Regards Naveen Hi Yes, that's part of the problem/original bug where oradim could not recreate the service after deleting it. You need to reboot. Here is the bug 1266248 Problem is with the call that is made to ORADIM.EXE by the service when the registry entry ora_sid_autostart=true. Oradim hangs, the service is shown to be in status 'starting' and the service oracleservicesid cannot be stopped. ORACLE.EXE must be killed from Task Manager, and ORADIM.EXE cannot be killed.Setting reg entry ora_sid_autostart=false, and rebooting, resolves the issue, leaving us, of course, without an aotostart option. It is worth noting that dispite the status of the service, the database can be started and stopped manually from Server Manager. The error is only on the service attempting to autostart the database. We removed and rebuilt oracleservicesid using Oradim, and this fixed the problem temporarily. We were able to use the service to start/stop, until a reboot, after which the same problem occurs. I was just off the phone with Oracle, and was advised to start another tar... Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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.com -- Author: Bishop Lewis 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: Double Take and Oracle
I'm always dubious of these types of products (especially when there are no reference sites available) and would opt for a batched up standby database solution (syncing every 5/10/15 minutes or so) myself. I'm not saying Double-Take is not good - I've got no experience of it and am sorry it's not any help but you have an option should Double-Take not work correctly. Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 15 October 2002 08:28 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hello Esteemed Gurus Pls advise... We are trying to get Double Take to work on our site. Does anyone actually have this product working??? Salesperson claims Double Take is certified by Oracle - does anyone know? Where could I find out, other than the company itself? For those of you who don't know this product pls give your opinion. Double Take is a software that copies your database files and parameter files etc across to a disaster recovery machine, bit for bit. At failure of the production the recovery becomes the production system and starts up the database. Basicly the datafiles are still open?? We get the following error when we start up the database on the recovery system in tests: ORA-01172: recovery of thread 1 stuck at bloack 176624 of file 2. I would just like to add that when this happens we resync the databases and try again to test and guess what - it is the turn of file 3 to give the above error, and so back and forth we go. To say the very least I am frustrated beyond comprihension. To make this worse there is no one else in South Africa that uses this software with Oracle, apparently in France. Convienant - I'd say. So I have no one to turn to about this. (Apparently it works well with MSSQL). Anyone any ideas? The Enviroment is Windows 2K SP3. Oracle 817 Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity. Dennis Ritchie. DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis 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: Oracle9i upgrade exam - Recommended books/material? (Borderin
: Freeman, Robert 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.com -- Author: Bishop Lewis 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.com -- Author: Freeman, Robert 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.com -- Author: Bishop Lewis 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: RE: Double Take and Oracle
Eva - just checking - from their docs have you verified that the transactional applications option is selected on the optimisations screen? This seems the most likely omission - and are you also sure that you are including all necessary files in the selected copy? Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 15 October 2002 16:09 To: Multiple recipients of list ORACLE-L Thanks for the input so far. Double-Take works real time so the database is never down. I also followed their setup direction to the letter. Problem on our site is that this product is being used for SQL Server and Exchange (Appears to work fine there, but Oracle is a beast of another color compared to these Access on Steroids databases), management are insisting for the sake of conformity that this must work. At ever attempted startup another file gives an error, most frustrating of all is that there is almost no consistency to the errors. Denham Eva -Original Message- Sent: Tuesday, October 15, 2002 4:04 PM To: Multiple recipients of list ORACLE-L Lewis, I can understand where Eva is coming from. I had a demo of a similar product some time ago. Their BIG selling point is that you have a production server and a backup that is close in time with your production server at half (or less) the cost of a hot standby. Their reasoning is that you don't have Oracle running on the standby and consequently don't have to pay Oracle a license fee for the second server since only one server is running at any point in time. Logically their point is well taken. Regrettably and understandably that is NOT Oracle's point of view. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis 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: Oracle9i upgrade exam - Recommended books/material? (Borderin
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.com -- Author: Freeman, Robert 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). _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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.com -- Author: Freeman, Robert 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). _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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.com -- Author: Freeman, Robert 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.com -- Author: Bishop Lewis 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: ORA-472 DBWR terminated
Not seen this before but trying creating a new alert log file using touch if unix or a simple output (something like type nonexistantfile alrtSID.log) if using dos. See if the same problem occurs. At least then you can narrow it down to a definite problem recreating the alert log file which you can look into further and you will have a workaround. If you've already done this what was the outcome? BTW - you do not need to shutdown the database to be able to rename the alert log file successfully - Oracle *should* create the file if it needs to output messages and cannot find an existing file. Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 09 October 2002 10:39 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hi All, We have a database running 7.3.4.5 and implemented a procedure that renames the alert logs every day. When the databases are down we rename the alert logs with a date extension. Now we have three databases of which two will simply create a new alert log and startup (including the test instance on which we tried it). The third one will not start up and give above error. All databases are shutdown the same way. Has anybody seen this behaviour before and found a reason/solution for it? Jacob A. van Zanen Oracle DBA Quant Systems Europe BV Zuiderkade 7 1948NG Beverwijk Tel.:0251 268268 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen 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.com -- Author: Bishop Lewis 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: ORA-472 DBWR terminated
Apart from ensuring that the unix file permissions are fine have you considered that the alert log file may be being created but in a different location? Have a look and do a search. I seem to recall seeing an unexplainable event like this on Windows before Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 09 October 2002 11:43 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- creating a file solved the problem(actually renamed the alertlog back to original name) and it wasn't such a big deal. I am just wondering why two databases with similar setup and exact same versions on the same machine do not have the same problems. Creating a workaround for this database is not my first choice as this is a script that runs of a remote server and is standard for all UNIX databases. But if all else fails Thx Jack -Original Message- Sent: Wednesday, October 09, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Not seen this before but trying creating a new alert log file using touch if unix or a simple output (something like type nonexistantfile alrtSID.log) if using dos. See if the same problem occurs. At least then you can narrow it down to a definite problem recreating the alert log file which you can look into further and you will have a workaround. If you've already done this what was the outcome? BTW - you do not need to shutdown the database to be able to rename the alert log file successfully - Oracle *should* create the file if it needs to output messages and cannot find an existing file. Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 09 October 2002 10:39 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hi All, We have a database running 7.3.4.5 and implemented a procedure that renames the alert logs every day. When the databases are down we rename the alert logs with a date extension. Now we have three databases of which two will simply create a new alert log and startup (including the test instance on which we tried it). The third one will not start up and give above error. All databases are shutdown the same way. Has anybody seen this behaviour before and found a reason/solution for it? Jacob A. van Zanen Oracle DBA Quant Systems Europe BV Zuiderkade 7 1948NG Beverwijk Tel.:0251 268268 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen 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.com -- Author: Bishop Lewis 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.com -- Author: Jack van Zanen 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
RE: Remember me? Oracle DBA veteran considering getting certifi
Title: RE: Remember me? Oracle DBA veteran considering getting certifi I expect that there are plenty of copies still in circulation but to my knowledge coriolis is no more shame, really, although the exam cram books tended to have quite a few errors they were an excellent portable aid to certification. Lewis Bishop --- Barclays Enable/ISS/OPTS - OracleDatabase Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 19:58 To: Multiple recipients of list ORACLE-L Subject: RE: Remember me? Oracle DBA veteran considering getting certifi This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Well, Amazon is sending me 8i certification books published by coriolis - h. -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 10:44 AM To: Multiple recipients of list ORACLE-L Subject: RE: Remember me? Oracle DBA veteran considering getting certifi FYI, I think Coriolis no longer exists. Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, September 30, 2002 9:38 AM To: Multiple recipients of list ORACLE-L certifi Paula, Your experience sounds very similar to mine which I documented on http://www.hcresources.co.uk/ocp.htm http://www.hcresources.co.uk/ocp.htm . I used the Exam Cram series and was very happy with them. I am booked for the 8i upgrade next week but despite using 8i for however long it has been available I cannot believe how much there is to learn. I can see myself putting off the exam once again John -Original Message- Sent: 30 September 2002 04:48 To: Multiple recipients of list ORACLE-L Sorry I didn't respond sooner - been up to my neck recovering from a bad controller. Anyway - 8i. If Mike Ault wrote a cram book for 9i upgrade I would get that one too. Please don't tell me that 8i ceritfication is retired. -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Saturday, September 28, 2002 5:28 PM To: Multiple recipients of list ORACLE-L Which version you are talking about? 8i or 9i upgrade certification Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Sat, 28 Sep 2002 08:53:19 -0800 Well, Given the IT market I felt that it was worth getting certified even though I haven't had any problems and been working with Oracle as DBA for over 8 years. However, I decided that I didn't want to spend a lot of money or time to do it. I have 2 small children, work, - yadayadayada(sp?). I got the self-test for the first test, studied using that and read Mike Ault's Exam cram book from front to back (excellent resource, concise, straightforward, good examples - just a couple of errors in whole book). Total test time was about 30 hours. Took the exam this morning in 60 minutes (120 alloted), got 49 out of 57 questions correct and passed. I really want to thank Mike Ault for the excellent concise Cram book and intend to continue on this same path for the other exams. Unfortunately, Mike didn't write all of them - however, I am hoping they are all of the same level of quality. I haven't taken a course in Oracle (any) for about 5 year and SQL/PLSQL in about 10-12. Total hours to prepare : 30 hours Resources: Exam Cram by Mike Ault and self-test exam Any additional costs - none Didn't want to study on clients time so ended up studying mostly between the hours of 2:00 a.m. and 8:00 a.m. in the morning. Hope the others go well and can get this done before Oracle changes the criteria. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com 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
RE: View contents of global temp table
Title: RE: View contents of global temp table *Your session* should be able to see the rows. If you commit (or rollback) the table will be truncated. Are you commiting? Lewis Bishop --- Barclays Enable/ISS/OPTS - OracleDatabase Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 15:34 To: Multiple recipients of list ORACLE-L Subject: RE: View contents of global temp table This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Rick, it is like any other table ... if the data is committed and you have access you can see data, else no you can't. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 9:43 AM To: Multiple recipients of list ORACLE-L Subject: View contents of global temp table Hi All, In session 1 I am loading data into a global temp table. Is there any way to see contents of that table? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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: Opening an 8.0.5 Database with 8i
Under NT when doing the upgrade from 8.0.5 to 8i the database will be mounted once the 8i services are created (assuming -startmode auto has been supplied). There are various data dictionary objects that need upgrading via the upgrade script (u0800050.sql) so it's a good idea to restrict access immediately after creating the service and before running the upgrade script. I would assume a similar scenario exists on unix based systems. So the answer is yes - you can OPEN an 8.0.5 database under 8.1.7 but as for successful use - who knows? Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 30 September 2002 12:28 To: Multiple recipients of list ORACLE-L Hi I got a question from a co-worker about opening an 8.0.5 database using 8.1.7 Since I don't have 8.1.7 here to test it, does anybody know wether this is possible or not ? I guess not, maybe it can exclusively mounted/opened followed by some script to upgrade it to 8.1.7 ? Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke 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, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis 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 Blackmail
If you want them to shut up and play nice(r) then I'd strongly suggest having a few prominent G3's around on desktops and at least one server (say file + print running Samba) with an RH or SuSE sitcker on it next to the NT boxes on your rack. See if that helps them understand your point of view... Yes, this is quite an important point. MS's biggest selling point in the past is that previously you had no choice. You do now. MS Sales Rep: Mac's are too complex, and Linux is hard to administer You: Err - no I don't think so - look over there - we currently run with Linux servers performing mail, file and print server functions - and did you know that they cost of ownership is competitive to MS even after we consider specialised Linux skills costs? Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] The information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis 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 Installer not launching in NT[Scanned]
and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis 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: Datafile size on NT or 2000
The 4GB problem on NT was ONLY where it would autoextend over a 4gb boundary (eg 4,8,12,16...). You can manually size the datafile whatever size you wish - ie you can cross the boundary manually. However, one place I recently contracted at were determined to cold backup their 120GB data warehouse system and it was decided to zip the datafiles as part of the backup process. Zip only handles files up to 4GB in size so they standardised on 4000MB datafiles (zipped down they reduced to 80mb - yep huge allocation, little data - it takes all sorts!) - guess who had to rebuild the data warehouse to these specs! ;-( So, on deciding your datafile size, be aware of various issues - mostly regarding the management of these files. I would agree with my previous client that 4gb (or near) is probably the biggest I'd go on windows systems unless there's a *specific* and good reason to go higher. Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 06 September 2002 00:10 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- There used to be a bug that caused problems with files on NT 4g or more in size. I've standardsized on 3999 meg as a result of this. -- Tony JohnsonEmail : [EMAIL PROTECTED] Manager Database Administration Voice : ( 480 ) 682 - 0849 Trimble Navigation Cell : ( 602 ) 363 - 7328 7408 W. Detroit Street #100 Fax: ( 480 ) 961 - 8801 Chandler, AZ 85226 -- Murphy's Data Constant:Data will be damaged in direct proportion to its value -Original Message- Sent: Thursday, September 05, 2002 2:29 PM To: Multiple recipients of list ORACLE-L What is an ideal datafile size for a large database 10G or greater Oracle 8.1.6 We have been using slightly under 2G and looking for an ideal size and possible reasons to use such a size Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Tony Johnson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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
RE: Why it picks the same PFile for both the DBs
the HELP command for other information (like subscribing). The information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Why it picks the same PFile for both the DBs
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.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Data Warehouse on Windows -more
Adar, From what I understand and have seen it's not just at 4GB - it's EVERY 4GB. So for example if your database extends from 3.8GB - 4.2GB it fail just as it will extending from 7.8GB-8.2GB or 11.8GB - 12.2GB (for example). It certainly DOESN'T mean that you can't use files larger than 4GB! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 19 August 2002 19:19 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hello Aleem This is not a boundary. It is a problem if you use autoextend and the file grows from less then 4Gb to more then 4GB. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 19, 2002 1:48 PM Where can I find the more information on this boundary? Is there any such limit for Oracle/Linux? TIA! Aleem -Original Message- Sent: Thursday, August 15, 2002 7:44 PM To: Multiple recipients of list ORACLE-L Subject: RE: Data Warehouse on Windows Don't forget the Oracle/Windows 4GB boundary corruption problem! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 15 August 2002 14:58 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hi, I was asked to give some hint for the hardware for a data warheouse running on Win 2k and holding about 20-40 GB data. Project will have about 40 small and 7-8 large tables. Users 20. Probably long running queries. Which hardware would you use? How many processors? Which disks? The os-system is set and cannot be Unix/Linux according to management decision. Any tips/recommendations appreciated Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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
RE: Data Warehouse on Windows -more
You can search metalink for 4gb boundary or windows 4gb corruption - both of these should raise various notes which refer to it. But, as already mentioned if you ensure AUTOEXTEND is OFF you'll have nothing to worry about. AFAIK this is only a WINDOWS problem. Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 19 August 2002 12:49 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Where can I find the more information on this boundary? Is there any such limit for Oracle/Linux? TIA! Aleem -Original Message- Sent: Thursday, August 15, 2002 7:44 PM To: Multiple recipients of list ORACLE-L Subject:RE: Data Warehouse on Windows Don't forget the Oracle/Windows 4GB boundary corruption problem! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 15 August 2002 14:58 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hi, I was asked to give some hint for the hardware for a data warheouse running on Win 2k and holding about 20-40 GB data. Project will have about 40 small and 7-8 large tables. Users 20. Probably long running queries. Which hardware would you use? How many processors? Which disks? The os-system is set and cannot be Unix/Linux according to management decision. Any tips/recommendations appreciated Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised
RE: Data Warehouse on Windows
It is an Oracle on Windows problem. Basically it's not that you can't have files over 4GB - just don't have autoextend on (something I always avoid anyway). You CAN manually extend past the 4GB boundaries (ie 4, 8, 12...). Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 15 August 2002 18:54 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Was that corruption problem in Oracle or in the windows OS? I asked a Microsoft person here and he says that the file size limit for windows2000 is in exabytes. (2^64 bytes) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 15, 2002 11:44 AM To: Multiple recipients of list ORACLE-L Subject:RE: Data Warehouse on Windows Don't forget the Oracle/Windows 4GB boundary corruption problem! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 15 August 2002 14:58 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hi, I was asked to give some hint for the hardware for a data warheouse running on Win 2k and holding about 20-40 GB data. Project will have about 40 small and 7-8 large tables. Users 20. Probably long running queries. Which hardware would you use? How many processors? Which disks? The os-system is set and cannot be Unix/Linux according to management decision. Any tips/recommendations appreciated Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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
RE: Moving to UK - what are Oracle contracts like?
Grant, Well good luck. Things are still tight here in the UK (see a recent post about FTV's) and there are many contractors on the bench. A recent group forum topic touched on the fact that 35% of new signers-on (the dole) are from IT. Last year I had 2 stints of 6 weeks between contracts and consider myself fortunate that it wasn't longer. It was great spending 3 months with the family but it sure did eat into the savings. Right now, there is more work OUTSIDE of London in areas such as the Midlands, Birmingham and York as well as quite a bit on mainland Europe. If you plan to come to London looking for a contract prepare yourself. Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 16 August 2002 08:48 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Very sorry about OT post - please feel free to flame/respond to me personally. I'm moving to the UK, and wonder what structure most contractors are employed under. I've read about IR35 (pretty much the same as the alienation of income rule here is Aus). Do people work as sole traders, set up their own plc, work for a body shop, or some combination of the above? Apologies again for the bandwidth consumption. Ciao Fuzzy :-) -- Woo Hoo! - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Moving to UK - what are Oracle contracts like?
-- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Moving to UK - what are Oracle contracts like?
for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Moving to UK - what are Oracle contracts like?
') 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, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Manavendra Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action
RE: Data Warehouse on Windows
Don't forget the Oracle/Windows 4GB boundary corruption problem! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 15 August 2002 14:58 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hi, I was asked to give some hint for the hardware for a data warheouse running on Win 2k and holding about 20-40 GB data. Project will have about 40 small and 7-8 large tables. Users 20. Probably long running queries. Which hardware would you use? How many processors? Which disks? The os-system is set and cannot be Unix/Linux according to management decision. Any tips/recommendations appreciated Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Dba tools on NT
Without a doubt - perl - get it free from www.activestate.com. Why use it? Well, it is so flexible compared to other NT/DOS scripting tools you'll wonder why you never had it before! It's also portable meaning all those scripts you write should work on multi platforms with just a little tweak! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 13 August 2002 17:25 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hello all We are looking on programming and scripting tools for DBA team on NT. Can you, oracle DBA's on NT, tell me off the list what tools you are using for these functions and, if you be so kind, why you choose them. TIA Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: DBVisualizer
I've just downloaded it and you can issue select statements but it's just that it says multi-sql statement scripts cannot be run... not really that much use I guess! ;-) However, this is not what I would use it for - I'd only use the 'references' section anyway - good tool though! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 31 July 2002 13:04 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Bill, sorry, but I tried your link to check out DBVisualizer. It seems to be good, but it is not a freebie anymore. With the current version you can see all your tables and so on, but you cannot issue a select statement in the free version anymore. Just for your interest. Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
on...whether there are only 5 or as many as 15 students enrolled...we've decided to allow you the opportunity to register for a seat in one of our upcoming courses for 50% OFF. That's right, instead of the normal $3,499 registration fee for our Oracle8i / 9i DBA eBoot Camp, you can register for only $1,749. Here's what you get: - A 5 week blended eLearning program that includes Instructor Led Training in our Virtual Classroom environment. That's right, you simply need to login to the Virtual Classroom at the designated time to receive Live, Instructor Led Training...without having to leave your home or office! - The course includes training for all 5 Oracle8i OCP DBA exams, plus as a FREE BONUS we are including our Oracle9i New Features for Administrators course that will prepare you for the Oracle9i Upgrade exam. That's a === message truncated === = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: GZip/WinZip...hot backups...
From what i remember Winzip has a file limit of 4gb... Lewis Bishop --- Barclays Enable/ISS/OPTS Oracle Database Consultant Phone: 020 8298 3418 Mobile: 07950 380857 Email:[EMAIL PROTECTED] -Original Message- Sent: 17 July 2002 20:24 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- A fellow DBA had mentioned that during his disaster recovery test, gzip had unzipped his Solaris files but did not restore the .dbf extension. Thus leaving him to manually rename his files to include a .dbf extension. He examined the gzip man pages but could not find any flags to set or anything to help. Has anyone else encountered this? Ideas? During a hot backup, on W2K platform, he uses WinZip to backup/compress all the datafiles into one large backup file. Has anyone encountered any problems with using this approach? Versus using the ocopy or copy command? He mentioned that on occasion he gets an error message from WinZip that the file was open, but everything seems to work. Many thanks in advance!!! Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Weird Windoze 'AT' Behavior
The Scheduler is installed with IE5.5 - definitively worth the install. As far as executing some lines but not others - it sounds like a environment variable problem to me - put a set command (to list variables and a pause command in your script (or output a log file) and check that your environmental settings are okay. Lewis Bishop --- Oracle Database Consultant - Barclays Enable/ISS/OpenPlan Email: [EMAIL PROTECTED] -Original Message- Sent: 17 July 2002 16:14 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Dave, I've found AT to be flakey at best. I haven't had your specific problem, but I have had problems where AT would only occasionally run when it was supposed to. I don't remember if it was a specific NT patch or a version of IE explorer, but one of these will install a Scheduler utility, which I've found to be pretty reliable. If you open My Computer (or explorer) you should see a folder called Scheduled Tasks. Double-click and then use the wizard to set up a call to your batch file. HTH, -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 7/17/02, Farnsworth, Dave [EMAIL PROTECTED] wrote: I have Oracle 8.1.7 running on NT. I do cold backups nightly and have a batch file that is called by the NT 'AT' scheduler. I recently changed some lines of commands in the batch file and since then when the batch file is executed by 'AT' only the lines that I did not edit are executed. If I execute the batch file from the command prompt it works fine. I deleted the job from 'AT' and then entered it back in but still getting this odd behavior of only executing the commands that I did not edit. Our SA's know nothing about 'AT' so they are of no help. Has anyone else seen this odd behavior in the 'AT' function in Windoze? I know you find it hard to believe that something can be weird in Windoze. ;o) And yes, I am soon planning on learning RMAN and do hot backups. I have the 8i Backup and Recovery Handbook for my reading pleasure. I see the app that is being used going to a 24X7 schedule. Now it is only used during the day. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Alan Davey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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
