bcv copy - duplicate rows unique prim key
Hi, When I issue an alter table move statement and afterwards an alter index rebuild for the primary key on this table I got an error duplicate rows found. This primary key is unique. The database has just been migrated for test purposes. In production we are still on oracle 7.3.4. I found the offending rows by validating into an exceptions table. When I compared these with production it didn't exist there. I turned out that these records were updated during the time of copying the database. This database is on EMC Symmetrix and the copy has been made through a bcv. Before starting the bcv all tablespaces are put into backup mode and then a split is done through EMC software to get a copy. About 20 seconds before the update in the table the tablespace has been put into backup mode and 40 seconds after the update the tablespaces are brought back to normal. Besides a hotbackup to tape we use this bcv regularly to copy databases so this behaviour is starting to worry me. Any idea what might be going wrong here? Regards, Jeroen Details: Production : HP-UX 10.20, Oracle 7.3.4.3, Symmetrix 3330 Test: HP-UX 11.11 , Oracle 9.2.0.4
Re: continuously copy archive redo logfiles to tape
We use cron facility to run a script that copies archived log files, not in use by archiver process, (fuser command) to a different location. We also use 'Autosys' software to run such scripts on remote servers. Another script, that runs after the 'copying' script, confirms that the 'copying' was successful and removes 'copied' archived log from archived log destination When hired junior DBAs in the distant past, we 'oriented' them by asking them to manually do such copying and removing of archived logs :) - Kirti --- Roger Xu [EMAIL PROTECTED] wrote: Hello, How do I continuously copy archive redo logfiles to tape ? Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: continuously copy archive redo logfiles to tape
hi kirti i was using the below method to copy archives to drsites and running this cron very frequently. the job used to ship and delete them immediately after successful copy and i used to have fuser check. but soon we started hitting this issue when we used to ship archives even when they are being used by the archiver. i think you are using fuser to find whether the file is open and then you ship it. when i implemented this i thought archiver process open the archive file once and then starts copying the redo..which seems logical..but it so happens archiver closed the files (ran truss os ARCH process) frequently when writing to the same file and my fusuer check used to fail occasionally. This was in 8.1.7.2. but these things may have changed now. just fyi. thanks sai Kirtikumar Deshpande [EMAIL PROTECTED] wrote: We use cron facility to run a script that copies archived log files, not in use by archiverprocess, (fuser command) to a different location. We also use 'Autosys' software to run suchscripts on remote servers. Another script, that runs after the 'copying' script, confirms that the'copying' was successful and removes 'copied' archived log from archived log destination When hired junior DBAs in the distant past, we 'oriented' them by asking them to manually do suchcopying and removing of archived logs :) - Kirti --- Roger Xu <[EMAIL PROTECTED]>wrote: Hello, How do I continuously copy archive redo logfiles to tape ? Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L F! AQ: http://www.orafaq.net -- Author: Roger Xu INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).__Do you Yahoo!?The New Yahoo! Shopping - with improved product searchhttp://shopping.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Kirtikumar DeshpandeINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: continuously copy archive redo logfiles to tape
Sai, We do not delete the files right away. The 'delete' scripts verifies that the file is present (with correct file size) at the destination before deleting it. We have not had any problems with this method for over 5 years now. I never used 8.1.7.2 much, so I can't say how the ARCH process behaved in that version. - Kirti --- Sai Selvaganesan [EMAIL PROTECTED] wrote: hi kirti i was using the below method to copy archives to drsites and running this cron very frequently. the job used to ship and delete them immediately after successful copy and i used to have fuser check. but soon we started hitting this issue when we used to ship archives even when they are being used by the archiver. i think you are using fuser to find whether the file is open and then you ship it. when i implemented this i thought archiver process open the archive file once and then starts copying the redo..which seems logical..but it so happens archiver closed the files (ran truss os ARCH process) frequently when writing to the same file and my fusuer check used to fail occasionally. This was in 8.1.7.2. but these things may have changed now. just fyi. thanks sai Kirtikumar Deshpande [EMAIL PROTECTED] wrote: We use cron facility to run a script that copies archived log files, not in use by archiver process, (fuser command) to a different location. We also use 'Autosys' software to run such scripts on remote servers. Another script, that runs after the 'copying' script, confirms that the 'copying' was successful and removes 'copied' archived log from archived log destination When hired junior DBAs in the distant past, we 'oriented' them by asking them to manually do such copying and removing of archived logs :) - Kirti --- Roger Xu wrote: Hello, How do I continuously copy archive redo logfiles to tape ? Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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).
continuously copy archive redo logfiles to tape
Hello, How do I continuously copy archive redo logfiles to tape ? Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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: continuously copy archive redo logfiles to tape
I'd try using backup software. There are only two utilities that work: 1) EMC/Legato Systems Legato Networker 2) Veritas Net*Backup 3) Spectralogic Alexndria backup. 4) Syncsort Backup 5) IBM Tivoli backup. 6) HP OmniBackup 7) CA Arcserve 8) BMC SQL*BackTrack On 10/14/2003 12:59:25 PM, Roger Xu wrote: Hello, How do I continuously copy archive redo logfiles to tape ? Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all 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. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor 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 the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: continuously copy archive redo logfiles to tape
Well, Backtrack is working well, in fact we will buy it for our new DB2 environment since we are quite happy with it in the Oracle environment. What is the other one working ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Mladen Gogala Sent: 14 octobre, 2003 13:19 To: Multiple recipients of list ORACLE-L I'd try using backup software. There are only two utilities that work: 1) EMC/Legato Systems Legato Networker 2) Veritas Net*Backup 3) Spectralogic Alexndria backup. 4) Syncsort Backup 5) IBM Tivoli backup. 6) HP OmniBackup 7) CA Arcserve 8) BMC SQL*BackTrack On 10/14/2003 12:59:25 PM, Roger Xu wrote: Hello, How do I continuously copy archive redo logfiles to tape ? Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all 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. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor 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 the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: How to copy recursive files in Windows? like unix cp -r
xcopy /e /h source destn - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 00:29 Hi List: How to copy recursive files in Windows? like unix cp -r Thanks in advance, Sami __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to copy recursive files in Windows? like unix cp -r
Hi List: How to copy recursive files in Windows? like unix cp -r Thanks in advance, Sami __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA 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: How to copy recursive files in Windows? like unix cp -r
Title: RE: How to copy recursive files in Windows? like unix cp -r xcopy /s -- copies recursively if sub-dir is not empty xcopy /e -- everything including empty. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Oracle DBA [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 08, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Subject: How to copy recursive files in Windows? like unix cp -r Hi List: How to copy recursive files in Windows? like unix cp -r Thanks in advance, Sami **This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.**5
RE: How to copy recursive files in Windows? like unix cp -r
xcopy /e source destination Example: xcopy /e c:\temp e:\ -Original Message- Sent: Wednesday, October 08, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Hi List: How to copy recursive files in Windows? like unix cp -r Thanks in advance, Sami __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rothouse, Michael 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: How to copy recursive files in Windows? like unix cp -r
xcopy -Original Message- Sent: Wednesday, October 08, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Hi List: How to copy recursive files in Windows? like unix cp -r Thanks in advance, Sami __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed 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: How to copy recursive files in Windows? like unix cp -r
use xcopy /S or /E C:\help xcopy Copies files and directory trees. XCOPY source [destination] [/A | /M] [/D[:date]] [/P] [/S [/E]] [/V] [/W] [/C] [/I] [/Q] [/F] [/L] [/H] [/R] [/T] [/U] [/K] [/N] [/O] [/X] [/Y] [/-Y] [/Z] [/EXCLUDE:file1[+file2][+file3]...] source Specifies the file(s) to copy. destination Specifies the location and/or name of new files. /A Copies only files with the archive attribute set, doesn't change the attribute. /M Copies only files with the archive attribute set, turns off the archive attribute. /D:m-d-y Copies files changed on or after the specified date. If no date is given, copies only those files whose source time is newer than the destination time. /EXCLUDE:file1[+file2][+file3]... Specifies a list of files containing strings. When any of the strings match any part of the absolute path of the file to be copied, that file will be excluded from being copied. For example, specifying a string like \obj\ or .obj will exclude all files underneath the directory obj or all files with the .obj extension respectively. /P Prompts you before creating each destination file. /S Copies directories and subdirectories except empty ones. /E Copies directories and subdirectories, including empty ones. Same as /S /E. May be used to modify /T. /V Verifies each new file. /W Prompts you to press a key before copying. /C Continues copying even if errors occur. /I If destination does not exist and copying more than one file, assumes that destination must be a directory. /Q Does not display file names while copying. /F Displays full source and destination file names while copying. /L Displays files that would be copied. /H Copies hidden and system files also. /R Overwrites read-only files. /T Creates directory structure, but does not copy files. Does not include empty directories or subdirectories. /T /E includes empty directories and subdirectories. /U Copies only files that already exist in destination. /K Copies attributes. Normal Xcopy will reset read-only attributes. /N Copies using the generated short names. /O Copies file ownership and ACL information. /X Copies file audit settings (implies /O). /Y Suppresses prompting to confirm you want to overwrite an existing destination file. /-Y Causes prompting to confirm you want to overwrite an existing destination file. /Z Copies networked files in restartable mode. The switch /Y may be preset in the COPYCMD environment variable. This may be overridden with /-Y on the command line. At 12:59 PM 10/8/2003, you wrote: Hi List: How to copy recursive files in Windows? like unix cp -r Thanks in advance, Sami __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA 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). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling 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: How to copy recursive files in Windows? like UNIX cp -r
For stubborn files, or if an error occurs during the copy, this uses the /c switch FOR /d %a in (G:\some\location\*) do xcopy *.* /s /c H:\someother\location This essentially forces the xcopy through the source directory, sometimes useful for copying off of cds where the data can be temporarily unavailable due to windows interaction with the hardware bob -Original Message- Sent: Wednesday, October 08, 2003 3:15 PM To: Multiple recipients of list ORACLE-L xcopy -Original Message- Sent: Wednesday, October 08, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Hi List: How to copy recursive files in Windows? like unix cp -r Thanks in advance, Sami __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anyone have a copy of DUL ??
Hi Juan, I read the link this morning but be the server seems to have gone bonks -Page Not Found error!! I hope the doc has not been maliciously deleted!! Any other reference to the doc?? Best regards, CSW Simon. -Original Message- Sent: Thursday, September 18, 2003 3:40 PM To: Multiple recipients of list ORACLE-L There are DUL?s manual. http://www.fors.com/velpuri2/dul_ucg8.html May be interesting for someone. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Pete Finnigan Enviado el: jueves, 18 de septiembre de 2003 13:55 Para: Multiple recipients of list ORACLE-L Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Anyone have a copy of DUL ??
Hi Simon, seems to be there now, just tried it 4:50pm UK time. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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: Anyone have a copy of DUL ??
Bernard of Oracle Holland made DUL (Direct UnLoader) several years ago. I took the very last internals class conducted by Oracle Support EMEA Vice President Andre Bakker (the only VP to conduct internals classes, I think. I also think he quit Support in disgust some time later :-) ), and we talked about a severe case we had in Denmark at that time. Basically, a company that made technical specs (including drawings) for some very advanced, high-speed transportation things, had not taken a backup of their system tablespace for 18 months. Then the system01.dbf file did its own thing, and their database didn't really feel good. Andre told me that he had a guy who was working on a tool that might be able to help us out. But it was in beta, etc., etc. So I went back to Denmark, called Bernhard, and we agreed that he would fix the bugs as we encountered them. I sent one of my guys - Christian Fabricius - online, and he was gone for three days, but got all the technical drawings out of the datafiles (Bernhard had to fix two or three things as we went along - a tribute to his coding skills). All that time, practially, Bernhard was online. Rock'n'roll. We were very proud. First time in history. Blah blah blah. When my manager went to a meeting with the customer a week later we were all expecting joy and happiness and perhaps some gratefullness from the customer. But no. He was furious. Why hadn't we told him that it was neccessary to take a backup of the system tablespace? Where in the documentation did it clearly state that that was required? It was all our fault. And we didn't even charge them more than normal hourly rates. I never tried the other suggestion Andre had (and which he had used many times himself): Create a dummy database that has the same datafiles as the problem database. Then take the file headers from the dummy database and patch on top of the real database. Then you can start up, since the information in the file headers match. Andre was one cool guy. He's enjoying early retirement, he claims. Mogens Rachel Carmichael wrote: Kevin Loney tells the story of making a call to the data center from the CIO's office and asking them to make a copy of the backup tapes and leave them at reception. since the call came from the CIO's office, they made the copy --- Pete Finnigan [EMAIL PROTECTED] wrote: Hi Peter Glad to hear that there are controls in Oracle for use of DUL, I was thinking of a case where i heard that one guy rang up the backup storage company for a large company and requested a set of backup tapes be left at reception at the company and he just walked in off the street and took them. Mitnik tells similar stories in his book. Thanks for the internal Oracle insight Peter, kind regards Pete In article [EMAIL PROTECTED], Peter Gram [EMAIL PROTECTED] writes Hi Pete I have used Dul many times at customer sites when I was employed by Oracle Denmark. Every time the customer management had to verify by phone and fax that they understood the full impact of using Dul. Oracle have disclaimer that explains the problems with missing transaction consistency of the data saved by Dul and the security issues. The customer has to sign and fax the disclaimer back to Oracle before we came on site .-) After I left Oracle several people ask me if would write a Dul and I declined. I'm of the opinion that Dul should stay behind the Oracle firewall. /peter Pete Finnigan wrote: Hi Mark I agree with you Mark, even if its supplied by Oracle technicians - it is as you say possible to by-pass security completely. Does anyone in Oracle check that the field support personnel dispatched to a site ( in urgency ) are dumping data for the owner of it? - I covered the issue of DUL with regards to security is the SANS Oracle security step-by-step book - action 6.5.1 kind regards Pete In article [EMAIL PROTECTED], Mark Leith [EMAIL PROTECTED] writes One problem I see with giving this away free is that you will be supplying a tool that allows you to extract data from the database, bypassing all inbuilt security. A BIG no no. I suppose that also applies to this kind of tool even under a paid license structure. -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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
Anyone have a copy of DUL ??
There are DUL?s manual. http://www.fors.com/velpuri2/dul_ucg8.html May be interesting for someone. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Pete Finnigan Enviado el: jueves, 18 de septiembre de 2003 13:55 Para: Multiple recipients of list ORACLE-L Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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: Anyone have a copy of DUL ??
Wouldn't something like DUL need to read Oracle's dictionary? My impression is that a lot of stuff in the data files is heavily encoded, like date and number formats. Wouldn't you need the dictionary to understand where one column stops and the next starts, and maybe even where one row ends and the next begins? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 18, 2003 7:40 AM To: Multiple recipients of list ORACLE-L There are DUL?s manual. http://www.fors.com/velpuri2/dul_ucg8.html May be interesting for someone. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Pete Finnigan Enviado el: jueves, 18 de septiembre de 2003 13:55 Para: Multiple recipients of list ORACLE-L Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Anyone have a copy of DUL ??
Call Oracle Support ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:39 PM There are DUL?s manual. http://www.fors.com/velpuri2/dul_ucg8.html May be interesting for someone. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Pete Finnigan Enviado el: jueves, 18 de septiembre de 2003 13:55 Para: Multiple recipients of list ORACLE-L Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anyone have a copy of DUL ??
Title: RE: Anyone have a copy of DUL ?? at about 10K/hr make sure you have PO on hand. From what I have heard, they install, work and de-install. You just get to see the end result. If you can get DUL copy, you could also send email to uncle Larry and ask for Oracle source code. Raj -Original Message- From: Tanel Poder [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 18, 2003 9:50 AM To: Multiple recipients of list ORACLE-L Subject: Re: Anyone have a copy of DUL ?? Call Oracle Support ;) Tanel. This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Anyone have a copy of DUL ??
Title: RE: Anyone have a copy of DUL ?? probably not, in absence of DD it will probably dump column id and table ids and rowids. If you dump a block, you will see that column length is also stored to indicate how many bytes to read. Raj -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 18, 2003 9:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Anyone have a copy of DUL ?? Wouldn't something like DUL need to read Oracle's dictionary? My impression is that a lot of stuff in the data files is heavily encoded, like date and number formats. Wouldn't you need the dictionary to understand where one column stops and the next starts, and maybe even where one row ends and the next begins? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 18, 2003 7:40 AM To: Multiple recipients of list ORACLE-L There are DUL?s manual. http://www.fors.com/velpuri2/dul_ucg8.html May be interesting for someone. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Pete Finnigan Enviado el: jueves, 18 de septiembre de 2003 13:55 Para: Multiple recipients of list ORACLE-L Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: Anyone have a copy of DUL ??
I do it but there say don´t have DUL -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Tanel Poder Enviado el: jueves, 18 de septiembre de 2003 15:50 Para: Multiple recipients of list ORACLE-L Asunto: Re: Anyone have a copy of DUL ?? Call Oracle Support ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:39 PM There are DUL?s manual. http://www.fors.com/velpuri2/dul_ucg8.html May be interesting for someone. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Pete Finnigan Enviado el: jueves, 18 de septiembre de 2003 13:55 Para: Multiple recipients of list ORACLE-L Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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: Anyone have a copy of DUL ??
Hi! Yes, you have to start from very beginning, you have be able to decode number date columns, have to know internal row structure, block structure, be able to find the start of tab$ and clu$, you have to be able to read extent maps from segment headers (in LMT you don't have anything in uet$ nor fet$ tables), you got to be able to read chained migrated rows, cluster tables (some base tables are clustered), read rollback segments if want consistent data... ... etc. That way it's possible to read data out from any datafile. The problem is that if you're missing data dictionary (have lost system TS) and don't have a reasonable backup, you don't know the names of your tables nor column names. A lot easier would be to write an online dul, which queries data dictionary for location of extents and object definitions for example and then scans only relevant datablocks. That way one doesn't have to start decoding data dictionary from scratch. But this approach has other problems like data consistency issues (if some blocks have been modified in buffer cache haven't been written to datafiles). Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 4:44 PM Wouldn't something like DUL need to read Oracle's dictionary? My impression is that a lot of stuff in the data files is heavily encoded, like date and number formats. Wouldn't you need the dictionary to understand where one column stops and the next starts, and maybe even where one row ends and the next begins? Dennis Williams DBA, 80%OC P,100%DBALifetouch,[EMAIL PROTECTED] hursday,September18,2003740AMToMultiplerecipientsoflistORACLE-LThereareDULsm anual.httpwww.fors.comvelpuri2dul_ucg8.htmlMaybeinterestingforsomeone.-M ensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Pete Finnigan Enviado el: jueves, 18 de septiembre de 2003 13:55 Para: Multiple recipients of list ORACLE-L Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
Re: Anyone have a copy of DUL ??
Hi Juan, There are some interesting papers on the rest of this site as wqell if you scroll around the directories. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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: Anyone have a copy of DUL ??
Indeed, the row directory is in the block header. And like Raj said, there is a length value to tell you how far to read. The values are encoded in Oracle's internal format, such as the 7 bytes coding for Date type. Richard Ji -Original Message- From: Joe Testa [mailto:[EMAIL PROTECTED] Sent: Thu 9/18/2003 11:14 AM To: Multiple recipients of list ORACLE-L Cc: Subject:Re: Anyone have a copy of DUL ?? Dennis, i dont think those 2 items you mentioned are that encoded, using the dump command you can see how they are stored. joe DENNIS WILLIAMS wrote: Wouldn't something like DUL need to read Oracle's dictionary? My impression is that a lot of stuff in the data files is heavily encoded, like date and number formats. Wouldn't you need the dictionary to understand where one column stops and the next starts, and maybe even where one row ends and the next begins? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 18, 2003 7:40 AM To: Multiple recipients of list ORACLE-L There are DUL?s manual. http://www.fors.com/velpuri2/dul_ucg8.html May be interesting for someone. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Pete Finnigan Enviado el: jueves, 18 de septiembre de 2003 13:55 Para: Multiple recipients of list ORACLE-L Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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). winmail.dat
Re: Anyone have a copy of DUL ??
Regular blockdump interprets the result into human readable format. However, if you set event 10289 at level 1, you'll have hexdumps instead can continue from there :) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 6:14 PM Dennis, i dont think those 2 items you mentioned are that encoded, using the dump command you can see how they are stored. joe DENNIS WILLIAMS wrote: Wouldn't something like DUL need to read Oracle's dictionary? My impression is that a lot of stuff in the data files is heavily encoded, like date and number formats. Wouldn't you need the dictionary to understand where one column stops and the next starts, and maybe even where one row ends and the next begins? Dennis Williams DBA, 80%OCP,100%DBALifetouch,[EMAIL PROTECTED] SentThursday,September18,2003740AMToMultiplerecipientsoflistORACLE-LThereare DULsmanual.httpwww.fors.comvelpuri2dul_ucg8.htmlMaybeinteresting for someone. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Pete Finnigan Enviado el: jueves, 18 de septiembre de 2003 13:55 Para: Multiple recipients of list ORACLE-L Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Anyone have a copy of DUL ??
They give DUL only for big money for customers with big problems (e.g. not solvable otherwise) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 6:04 PM I do it but there say don´t have DUL -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Tanel Poder Enviado el: jueves, 18 de septiembre de 2003 15:50 Para: Multiple recipients of list ORACLE-L Asunto: Re: Anyone have a copy of DUL ?? Call Oracle Support ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:39 PM There are DUL?s manual. http://www.fors.com/velpuri2/dul_ucg8.html May be interesting for someone. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Pete Finnigan Enviado el: jueves, 18 de septiembre de 2003 13:55 Para: Multiple recipients of list ORACLE-L Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Anyone have a copy of DUL ??
Dennis, i dont think those 2 items you mentioned are that encoded, using the dump command you can see how they are stored. joe DENNIS WILLIAMS wrote: Wouldn't something like DUL need to read Oracle's dictionary? My impression is that a lot of stuff in the data files is heavily encoded, like date and number formats. Wouldn't you need the dictionary to understand where one column stops and the next starts, and maybe even where one row ends and the next begins? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 18, 2003 7:40 AM To: Multiple recipients of list ORACLE-L There are DUL?s manual. http://www.fors.com/velpuri2/dul_ucg8.html May be interesting for someone. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Pete Finnigan Enviado el: jueves, 18 de septiembre de 2003 13:55 Para: Multiple recipients of list ORACLE-L Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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: Anyone have a copy of DUL ??
Tanel, Richard That was what my innocent question related to. I had played with LogMiner without a dictionary and it was challenging. Naturally with a program you can take care of some of those issues in the program. Anyway, from the replies this sounds feasible and probably really useful. Naturally if you expect to become the next Bill Gates, then Oracle could easily cut you off by making DUL generally available. But you could give it away for free as a way of creating credentials for yourself in the Oracle community. Also, you could probably get plenty of opportunities from desperate clients to help them extract their data. In some of these situations, money doesn't mean so much. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 18, 2003 10:35 AM To: Multiple recipients of list ORACLE-L Regular blockdump interprets the result into human readable format. However, if you set event 10289 at level 1, you'll have hexdumps instead can continue from there :) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 6:14 PM Dennis, i dont think those 2 items you mentioned are that encoded, using the dump command you can see how they are stored. joe DENNIS WILLIAMS wrote: Wouldn't something like DUL need to read Oracle's dictionary? My impression is that a lot of stuff in the data files is heavily encoded, like date and number formats. Wouldn't you need the dictionary to understand where one column stops and the next starts, and maybe even where one row ends and the next begins? Dennis Williams DBA, 80%OCP,100%DBALifetouch,[EMAIL PROTECTED] SentThursday,September18,2003740AMToMultiplerecipientsoflistORACLE-LThereare DULsmanual.httpwww.fors.comvelpuri2dul_ucg8.htmlMaybeinteresting for someone. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Pete Finnigan Enviado el: jueves, 18 de septiembre de 2003 13:55 Para: Multiple recipients of list ORACLE-L Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE
RE: Anyone have a copy of DUL ??
1) it's Field Support not Tech Support that has it 2) Oracle does not sell nor does it release the code for DUL. A field support technician comes to your site, installs it, runs it and removes it. You pay a fee for this. when I used it (in '98), the fee was $5k per every 8 hour period, with a minimum of $10K as the starting fee. --- Juan Miranda [EMAIL PROTECTED] wrote: I do it but there say don´t have DUL -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Tanel Poder Enviado el: jueves, 18 de septiembre de 2003 15:50 Para: Multiple recipients of list ORACLE-L Asunto: Re: Anyone have a copy of DUL ?? Call Oracle Support ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:39 PM There are DUL?s manual. http://www.fors.com/velpuri2/dul_ucg8.html May be interesting for someone. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Pete Finnigan Enviado el: jueves, 18 de septiembre de 2003 13:55 Para: Multiple recipients of list ORACLE-L Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
RE: Anyone have a copy of DUL ??
One problem I see with giving this away free is that you will be supplying a tool that allows you to extract data from the database, bypassing all inbuilt security. A BIG no no. I suppose that also applies to this kind of tool even under a paid license structure. How many of you would shout at Cool-Tools for giving away a tool such as this, that your developers can use to hack your data files? ;) Nice idea in concept - huge liability it reality. -Original Message- Rachel Carmichael Sent: 18 September 2003 17:15 To: Multiple recipients of list ORACLE-L 1) it's Field Support not Tech Support that has it 2) Oracle does not sell nor does it release the code for DUL. A field support technician comes to your site, installs it, runs it and removes it. You pay a fee for this. when I used it (in '98), the fee was $5k per every 8 hour period, with a minimum of $10K as the starting fee. --- Juan Miranda [EMAIL PROTECTED] wrote: I do it but there say don4t have DUL -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Tanel Poder Enviado el: jueves, 18 de septiembre de 2003 15:50 Para: Multiple recipients of list ORACLE-L Asunto: Re: Anyone have a copy of DUL ?? Call Oracle Support ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:39 PM There are DUL?s manual. http://www.fors.com/velpuri2/dul_ucg8.html May be interesting for someone. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Pete Finnigan Enviado el: jueves, 18 de septiembre de 2003 13:55 Para: Multiple recipients of list ORACLE-L Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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: Anyone have a copy of DUL ??
You can't bypass Oracle security (well if configured and patched well) from remote with any tools (at least I surely hope so that there wouldn't be any backdoors). There is no magic tool which can log on to Oracle without password from remote and start scanning all the datafiles. This DUL works only when having direct access to datafile itself! This means direct access, not even some sysdba remote login. So there is no more security risk in letting a user access the physical datafile with DUL than with vi editor. In latter case one just has to work more to figure out the physical data structure. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 7:35 PM One problem I see with giving this away free is that you will be supplying a tool that allows you to extract data from the database, bypassing all inbuilt security. A BIG no no. I suppose that also applies to this kind of tool even under a paid license structure. How many of you would shout at Cool-Tools for giving away a tool such as this, that your developers can use to hack your data files? ;) Nice idea in concept - huge liability it reality. -Original Message- Rachel Carmichael Sent: 18 September 2003 17:15 To: Multiple recipients of list ORACLE-L 1) it's Field Support not Tech Support that has it 2) Oracle does not sell nor does it release the code for DUL. A field support technician comes to your site, installs it, runs it and removes it. You pay a fee for this. when I used it (in '98), the fee was $5k per every 8 hour period, with a minimum of $10K as the starting fee. --- Juan Miranda [EMAIL PROTECTED] wrote: I do it but there say don4t have DUL -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Tanel Poder Enviado el: jueves, 18 de septiembre de 2003 15:50 Para: Multiple recipients of list ORACLE-L Asunto: Re: Anyone have a copy of DUL ?? Call Oracle Support ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:39 PM There are DUL?s manual. http://www.fors.com/velpuri2/dul_ucg8.html May be interesting for someone. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Pete Finnigan Enviado el: jueves, 18 de septiembre de 2003 13:55 Para: Multiple recipients of list ORACLE-L Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
RE: Anyone have a copy of DUL ??
Mark, I see what you are talking about, but my developers don't have access to data files. Heck, I don't have access to data files in production. The production DBA controls the account. I totally agree that a tool such as this in the wrong hands can be very dangerous, same thing applies for other tools, ethereal, kismet etc. I do believe the benefit of such a tool available out weights the risk of it. I'd like to hear other list members opnion on it. Yours turely Richard Ji -Original Message- Sent: Thursday, September 18, 2003 12:35 PM To: Multiple recipients of list ORACLE-L One problem I see with giving this away free is that you will be supplying a tool that allows you to extract data from the database, bypassing all inbuilt security. A BIG no no. I suppose that also applies to this kind of tool even under a paid license structure. How many of you would shout at Cool-Tools for giving away a tool such as this, that your developers can use to hack your data files? ;) Nice idea in concept - huge liability it reality. -Original Message- Rachel Carmichael Sent: 18 September 2003 17:15 To: Multiple recipients of list ORACLE-L 1) it's Field Support not Tech Support that has it 2) Oracle does not sell nor does it release the code for DUL. A field support technician comes to your site, installs it, runs it and removes it. You pay a fee for this. when I used it (in '98), the fee was $5k per every 8 hour period, with a minimum of $10K as the starting fee. --- Juan Miranda [EMAIL PROTECTED] wrote: I do it but there say don4t have DUL -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Tanel Poder Enviado el: jueves, 18 de septiembre de 2003 15:50 Para: Multiple recipients of list ORACLE-L Asunto: Re: Anyone have a copy of DUL ?? Call Oracle Support ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:39 PM There are DUL?s manual. http://www.fors.com/velpuri2/dul_ucg8.html May be interesting for someone. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Pete Finnigan Enviado el: jueves, 18 de septiembre de 2003 13:55 Para: Multiple recipients of list ORACLE-L Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http
Re: Anyone have a copy of DUL ??
Hi Mark I agree with you Mark, even if its supplied by Oracle technicians - it is as you say possible to by-pass security completely. Does anyone in Oracle check that the field support personnel dispatched to a site ( in urgency ) are dumping data for the owner of it? - I covered the issue of DUL with regards to security is the SANS Oracle security step-by-step book - action 6.5.1 kind regards Pete In article [EMAIL PROTECTED], Mark Leith [EMAIL PROTECTED] writes One problem I see with giving this away free is that you will be supplying a tool that allows you to extract data from the database, bypassing all inbuilt security. A BIG no no. I suppose that also applies to this kind of tool even under a paid license structure. -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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: Anyone have a copy of DUL ??
Well if they can hack at it with Perl it's not really the tool that's the problem and preventing access to the tool is not a solution. -Original Message- Sent: Thursday, September 18, 2003 10:35 AM To: Multiple recipients of list ORACLE-L One problem I see with giving this away free is that you will be supplying a tool that allows you to extract data from the database, bypassing all inbuilt security. A BIG no no. I suppose that also applies to this kind of tool even under a paid license structure. How many of you would shout at Cool-Tools for giving away a tool such as this, that your developers can use to hack your data files? ;) Nice idea in concept - huge liability it reality. -Original Message- Rachel Carmichael Sent: 18 September 2003 17:15 To: Multiple recipients of list ORACLE-L 1) it's Field Support not Tech Support that has it 2) Oracle does not sell nor does it release the code for DUL. A field support technician comes to your site, installs it, runs it and removes it. You pay a fee for this. when I used it (in '98), the fee was $5k per every 8 hour period, with a minimum of $10K as the starting fee. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Anyone have a copy of DUL ??
Hi Pete I have used Dul many times at customer sites when I was employed by Oracle Denmark. Every time the customer management had to verify by phone and fax that they understood the full impact of using Dul. Oracle have disclaimer that explains the problems with missing transaction consistency of the data saved by Dul and the security issues. The customer has to sign and fax the disclaimer back to Oracle before we came on site .-) After I left Oracle several people ask me if would write a Dul and I declined. I'm of the opinion that Dul should stay behind the Oracle firewall. /peter Pete Finnigan wrote: Hi Mark I agree with you Mark, even if its supplied by Oracle technicians - it is as you say possible to by-pass security completely. Does anyone in Oracle check that the field support personnel dispatched to a site ( in urgency ) are dumping data for the owner of it? - I covered the issue of DUL with regards to security is the SANS Oracle security step-by-step book - action 6.5.1 kind regards Pete In article [EMAIL PROTECTED], Mark Leith [EMAIL PROTECTED] writes One problem I see with giving this away free is that you will be supplying a tool that allows you to extract data from the database, bypassing all inbuilt security. A BIG no no. I suppose that also applies to this kind of tool even under a paid license structure. -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 smime.p7s Description: S/MIME cryptographic signature
Re: Anyone have a copy of DUL ??
Juan I have the URL that you can get a copy from but you need access to Oracle's network. Wrote about it in Select Journal. In 1999 - I wrote: DUL - Data recovery UnLoader DUL or Data recovery UnLoader is a utility that that will generate either a data file or an Oracle Export file by reading the database's datafiles! Cool huh? Apparently it is for internal use only by the Oracle Technical Support staff only. Most of you would not have access to this site but if you did, this is where you would find it http://www-sup.nl.oracle.com/dul There is one catch. I have been informed that it is available for Windows only. Then I found out in 2001: Oracles DUL Data recovery UnLoader Many many moons ago in a previous issue of Select (1999), I wrote of an internally used product by the worldwide support team. This product was called the DUL or Data UnLoader. The utility will read an Oracle datafile and extract data from it. Even from a crashed database. In fact, it was written as a recovery tool for a totally knackered database. The output is a SQL*Loader control file and its data input file. All it requires is the datafile. It does not even need the SYSTEM datafile. Because it is such a power tool, if used unethically, the information gathered can be damaging to the company. At that time, it only ran on Windows and I gave a URL where it can be found. http://www-sup.nl.oracle.com/dul Only one catch. The site was accessible only within Oracle. If you have a friend working at Oracle, you may want to ask him/her nicely to get it for you. If you have a genuine need for the product, you might want to try Oracle Worldwide support. Do I have a copy? Maybe. Try mailing to [EMAIL PROTECTED] . DUL is NOT a supported Oracle product, it is not even an Oracle product. DUL is for support and internal Oracle use only. Since then, the product has been enhanced and is current version is Ver. 8 and there is also a Solaris port. The irony of this product is that there is a rumor that the author of the program would like to commercialize it as he developed it in his own time but Oracle is not having a bar of it. I believe negotiation may be going on. What version of O/S were you intending on using it on? Note the email [EMAIL PROTECTED] that you might find useful. ta tony At 04:39 AM 18/09/2003 -0800, you wrote: There are DUL?s manual. http://www.fors.com/velpuri2/dul_ucg8.html May be interesting for someone. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Pete Finnigan Enviado el: jueves, 18 de septiembre de 2003 13:55 Para: Multiple recipients of list ORACLE-L Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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: Anyone have a copy of DUL ??
What DBA, in their right mind, is going to give any user or developer file level access to their datafiles? That is what user and group permissions are there to restrict. All our db's have 600 level file permissions for oracle user access only. If we have to bring someone on site for using a tool such as DUL, you can bet that we dba's will either be the keyboard jockey, or breathing down the necks of the consultant as they work. Non-dba access to the datafiles is just stupid, and anyone who would allow it deserves everything they get. Rodd On Thu, 2003-09-18 at 11:35, Mark Leith wrote: One problem I see with giving this away free is that you will be supplying a tool that allows you to extract data from the database, bypassing all inbuilt security. A BIG no no. I suppose that also applies to this kind of tool even under a paid license structure. How many of you would shout at Cool-Tools for giving away a tool such as this, that your developers can use to hack your data files? ;) Nice idea in concept - huge liability it reality. -Original Message- Rachel Carmichael Sent: 18 September 2003 17:15 To: Multiple recipients of list ORACLE-L 1) it's Field Support not Tech Support that has it 2) Oracle does not sell nor does it release the code for DUL. A field support technician comes to your site, installs it, runs it and removes it. You pay a fee for this. when I used it (in '98), the fee was $5k per every 8 hour period, with a minimum of $10K as the starting fee. --- Juan Miranda [EMAIL PROTECTED] wrote: I do it but there say don4t have DUL -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Tanel Poder Enviado el: jueves, 18 de septiembre de 2003 15:50 Para: Multiple recipients of list ORACLE-L Asunto: Re: Anyone have a copy of DUL ?? Call Oracle Support ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:39 PM There are DUL?s manual. http://www.fors.com/velpuri2/dul_ucg8.html May be interesting for someone. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Pete Finnigan Enviado el: jueves, 18 de septiembre de 2003 13:55 Para: Multiple recipients of list ORACLE-L Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may
Re: Anyone have a copy of DUL ??
Peter, I used DUL (one of my last 40 hour days) under extreme urgency. We didn't have to fax anything, but then, our senior Vice President did call Ray Lane's secretary to get Field Support to pull someone in off vacation to come to our site, so I guess that's pretty good verification. The product does what it says it will do... and I hope I NEVER have to use it again. Rachel --- Peter Gram [EMAIL PROTECTED] wrote: Hi Pete I have used Dul many times at customer sites when I was employed by Oracle Denmark. Every time the customer management had to verify by phone and fax that they understood the full impact of using Dul. Oracle have disclaimer that explains the problems with missing transaction consistency of the data saved by Dul and the security issues. The customer has to sign and fax the disclaimer back to Oracle before we came on site .-) After I left Oracle several people ask me if would write a Dul and I declined. I'm of the opinion that Dul should stay behind the Oracle firewall. /peter Pete Finnigan wrote: Hi Mark I agree with you Mark, even if its supplied by Oracle technicians - it is as you say possible to by-pass security completely. Does anyone in Oracle check that the field support personnel dispatched to a site ( in urgency ) are dumping data for the owner of it? - I covered the issue of DUL with regards to security is the SANS Oracle security step-by-step book - action 6.5.1 kind regards Pete In article [EMAIL PROTECTED], Mark Leith [EMAIL PROTECTED] writes One problem I see with giving this away free is that you will be supplying a tool that allows you to extract data from the database, bypassing all inbuilt security. A BIG no no. I suppose that also applies to this kind of tool even under a paid license structure. -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 ATTACHMENT part 2 application/x-pkcs7-signature name=smime.p7s __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anyone have a copy of DUL ??
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tanel Poder A lot easier would be to write an online dul, which queries data dictionary for location of extents and object definitions for example and then scans only relevant datablocks. I think that in most Oracle databases, along with the software is included an online DUL. If I remember right it's called something like SQL. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer 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: Anyone have a copy of DUL ??
Forgetting about a piddly, little-known OS called Neanderthal Technology. Where default Oracle installation tosses everything out there with full control for everyone -- or it used to do that. But even if you change the permissions, anybody that needs to do anything on the box must have administrator privileges; so tightening up the permissions is bit like trying to piss up a rope. -Original Message- What DBA, in their right mind, is going to give any user or developer file level access to their datafiles? That is what user and group permissions are there to restrict. All our db's have 600 level file permissions for oracle user access only. If we have to bring someone on site for using a tool such as DUL, you can bet that we dba's will either be the keyboard jockey, or breathing down the necks of the consultant as they work. Non-dba access to the datafiles is just stupid, and anyone who would allow it deserves everything they get. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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: Anyone have a copy of DUL ??
Yes, there are. The paper that explains the naming of X$ tables I found to be particularly interesting. Jared On Thu, 2003-09-18 at 08:14, Pete Finnigan wrote: Hi Juan, There are some interesting papers on the rest of this site as wqell if you scroll around the directories. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
RE: Anyone have a copy of DUL ??
Title: RE: Anyone have a copy of DUL ?? also check the one about log miner ... Raj -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 18, 2003 4:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: Anyone have a copy of DUL ?? Yes, there are. The paper that explains the naming of X$ tables I found to be particularly interesting. Jared On Thu, 2003-09-18 at 08:14, Pete Finnigan wrote: Hi Juan, There are some interesting papers on the rest of this site as wqell if you scroll around the directories. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Anyone have a copy of DUL ??
Which site? I've been skimming over this thread and missed it. Thanks, --Walt Weaver Bozeman, Montana -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 2:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: Anyone have a copy of DUL ?? Yes, there are. The paper that explains the naming of X$ tables I found to be particularly interesting. Jared On Thu, 2003-09-18 at 08:14, Pete Finnigan wrote: Hi Juan, There are some interesting papers on the rest of this site as wqell if you scroll around the directories. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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.net -- Author: Weaver, Walt 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: Anyone have a copy of DUL ??
Hi! Good point, but there are few issues. Unloading data with SQL is slower than doing it directly. Yes, direct export is very fast, but it doesn't have the flexibility DUL does - DUL is built do survive any corruptions in data, while your export just may fail or server process crashes, DUL just keeps going tries to extract as much as possible. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 10:19 PM -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tanel Poder A lot easier would be to write an online dul, which queries data dictionary for location of extents and object definitions for example and then scans only relevant datablocks. I think that in most Oracle databases, along with the software is included an online DUL. If I remember right it's called something like SQL. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anyone have a copy of DUL ??
See the original post which asked this question. -Original Message- Sent: Thursday, September 18, 2003 4:50 PM To: Multiple recipients of list ORACLE-L Which site? I've been skimming over this thread and missed it. Thanks, --Walt Weaver Bozeman, Montana -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 2:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: Anyone have a copy of DUL ?? Yes, there are. The paper that explains the naming of X$ tables I found to be particularly interesting. Jared On Thu, 2003-09-18 at 08:14, Pete Finnigan wrote: Hi Juan, There are some interesting papers on the rest of this site as wqell if you scroll around the directories. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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.net -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anyone have a copy of DUL ??
And DUL doesn't need a running instance to do it's job. All it needs are as much data files as you got. Richard -Original Message- Sent: Thursday, September 18, 2003 5:00 PM To: Multiple recipients of list ORACLE-L Hi! Good point, but there are few issues. Unloading data with SQL is slower than doing it directly. Yes, direct export is very fast, but it doesn't have the flexibility DUL does - DUL is built do survive any corruptions in data, while your export just may fail or server process crashes, DUL just keeps going tries to extract as much as possible. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 10:19 PM -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tanel Poder A lot easier would be to write an online dul, which queries data dictionary for location of extents and object definitions for example and then scans only relevant datablocks. I think that in most Oracle databases, along with the software is included an online DUL. If I remember right it's called something like SQL. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anyone have a copy of DUL ??
Okay, okay, I'll check the archives. --Walt shuffling around his office trying to find his web browser -Original Message- From: Richard Ji [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Anyone have a copy of DUL ?? See the original post which asked this question. -Original Message- Sent: Thursday, September 18, 2003 4:50 PM To: Multiple recipients of list ORACLE-L Which site? I've been skimming over this thread and missed it. Thanks, --Walt Weaver Bozeman, Montana -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 2:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: Anyone have a copy of DUL ?? Yes, there are. The paper that explains the naming of X$ tables I found to be particularly interesting. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weaver, Walt 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: Anyone have a copy of DUL ??
:) www.fors.com/velpuri2 -Original Message- Sent: Thursday, September 18, 2003 5:55 PM To: Multiple recipients of list ORACLE-L Okay, okay, I'll check the archives. --Walt shuffling around his office trying to find his web browser -Original Message- From: Richard Ji [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Anyone have a copy of DUL ?? See the original post which asked this question. -Original Message- Sent: Thursday, September 18, 2003 4:50 PM To: Multiple recipients of list ORACLE-L Which site? I've been skimming over this thread and missed it. Thanks, --Walt Weaver Bozeman, Montana -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 2:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: Anyone have a copy of DUL ?? Yes, there are. The paper that explains the naming of X$ tables I found to be particularly interesting. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Anyone have a copy of DUL ??
Correct, but I was talking about easily writable DUL before, a DUL which doesn't require decoding data dictionary. But use of this kind of loader would mostly be for learning purposes. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 19, 2003 12:19 AM And DUL doesn't need a running instance to do it's job. All it needs are as much data files as you got. Richard -Original Message- Sent: Thursday, September 18, 2003 5:00 PM To: Multiple recipients of list ORACLE-L Hi! Good point, but there are few issues. Unloading data with SQL is slower than doing it directly. Yes, direct export is very fast, but it doesn't have the flexibility DUL does - DUL is built do survive any corruptions in data, while your export just may fail or server process crashes, DUL just keeps going tries to extract as much as possible. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 10:19 PM -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tanel Poder A lot easier would be to write an online dul, which queries data dictionary for location of extents and object definitions for example and then scans only relevant datablocks. I think that in most Oracle databases, along with the software is included an online DUL. If I remember right it's called something like SQL. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Anyone have a copy of DUL ??
Hi Jared Yes, I read that one as well very interesting, I have not seen it before. There is also a BBED simple user manual, not elaborate but better than I have seen before. kind regards Pete In article [EMAIL PROTECTED], Jared Still [EMAIL PROTECTED] writes Yes, there are. The paper that explains the naming of X$ tables I found to be particularly interesting. Jared On Thu, 2003-09-18 at 08:14, Pete Finnigan wrote: Hi Juan, There are some interesting papers on the rest of this site as wqell if you scroll around the directories. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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: Anyone have a copy of DUL ??
Hi Walt, probably someone else will reply before me as i am reading this offline but anyway for the meaning of x$ tables try http://www.fors.com/velpuri2 /X$/List%20of%20X$%20Tables kind regards Pete In article [EMAIL PROTECTED], Weaver, Walt [EMAIL PROTECTED] writes Which site? I've been skimming over this thread and missed it. -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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: Anyone have a copy of DUL ??
I realize that Oracle's DUL tool works for datafiles from a database that cannot be started. Far from me to argue with Mr. Poder, but I thought he meant by online DUL a DUL that would work when the instance is running. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Richard Ji And DUL doesn't need a running instance to do it's job. All it needs are as much data files as you got. -Original Message- Good point, but there are few issues. Unloading data with SQL is slower than doing it directly. Yes, direct export is very fast, but it doesn't have the flexibility DUL does - DUL is built do survive any corruptions in data, while your export just may fail or server process crashes, DUL just keeps going tries to extract as much as possible. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer 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: Anyone have a copy of DUL ??
Why all the interest about reading Oracle files? There is no magic in doing this! It does not matter how sophisticated the server is, the data simply resides in data files. You can view it easily using: cat file | strings Regards, Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed 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: Anyone have a copy of DUL ??
Yeah! cat file | strings myfile.txt sqlldr data=myfile.txt piece of cake. ;) Guaranteed to work on BLOBs, LONG RAWs regardless of NLS settings. Waleed, either you're being facetious, or missing the point, I can't tell which. If this were coming from Mladen, there would be no doubt. Jared On Thu, 2003-09-18 at 16:30, Khedr, Waleed wrote: Why all the interest about reading Oracle files? There is no magic in doing this! It does not matter how sophisticated the server is, the data simply resides in data files. You can view it easily using: cat file | strings Regards, Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
Can i have a copy of metalink doc 52576.1 ?
Hi List, Sorry to post this again.Hope i will get some replies this time. I don't find Doc 52576.1 (Reg. cleaning up a RMAN catalog) on metalink. Can someone mail me if u have a copy of the same ? TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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: Redo Copy Latch contention ??
Please see the link... Steve Adams has given lots of information on it. http://www.ixora.com.au/ Yes you have contention problem and that may be causing high CPU Utilizxation. It is not simple to analyse redo copy contention problem and soln with below data... detail investigation, you have to performed - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 03, 2003 1:50 AM Thanks Kirti, We have HP Openview implemented on our database and hence got some alert on redo copy latch. When I have queried the database I found the contention on this latch. Yes we have other performance issues ( HIGH CPU utilization , because of lotta bad code ). and We are checking every possible contention on the database. Question : How can I determine if this redo copy latch is causing the performance issues , guess that is my main question before altering some hidden parameter in init.ora. Madhu Reddy X13944 -Original Message- Sent: Wednesday, July 02, 2003 1:56 PM To: Multiple recipients of list ORACLE-L According that suggestion you do seem to have redo copy latch contention. As far as getting that ratio close to suggested value, you may set some special init.ora parameters. There is plenty of notes on Metalink for that. But, you should first determine if this is causing any performance issue. Have you explored all other avenues to address those issues. If not, I would not worry about this contention. - Kirti --- Reddy, Madhusudana [EMAIL PROTECTED] wrote: Hello ALL, Do you guys think we have redo copy latch contention ?? Also what are your suggestions on tuning Redo Copy Latch ?? SUBSTR(LN.NAME,1,20) GETS MISSES IMMEDIATE_GETS IMMEDIATE_MISSES -- -- -- redo allocation 9433506468862115 00 redo copy 22097497 907958724 1592481 14:54:54 SQL select (497/22097)*100 from dual; (497/22097)*100 ~ (misses/gets)*100 --- 2.2491741 --- Oracle suggests it should be under 1% Madhu Reddy X13944 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Manoj Kumar Jha 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: Redo Copy Latch contention ??
You can still tune the buffers, you just don't need BCHR to do it. See http://www.ixora.com.au/scripts/sql/ideal_cache_size.sql and http://www.ixora.com.au/newsletter/2001_03.htm I've procedurized this script to run from dbms_jobs every 15 minutes. Two reports are used to give current buffer size, ideal buffers average and ideal buffers max. One does an aggregate of the whole enchilada, the other breaks it down into weekly aggregates. The whole set of files is at http://www.cybcon.com/~jkstill/util/zips/idcs.tgz Jared Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/02/2003 07:50 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Redo Copy Latch contention ?? You are probably right but it was good to have V6-type control over the mechanism. log_simultaneous_copies, log_small_entry_max_size (maximum number of characters that was allocated when allocation latch was acquired) and log_entry_prebuild_threshold (the size of redo after which the user process was building redo entries, instead of LGWR) were easy to understand and maintain. These days, I have no control. Do you remember X$KCBCH tables (I'm not sure about the spelling of this one) that was helping you compute hit ratio if there were few more block buffers? World certainly was simpler before you and Cary destroyed the hit ratio. Shame on you :)! On 2003.07.02 22:24, Anjo Kolk wrote: Wrong alert in HP Open view (you can configure that) and (again) ignoring other more relevant performance information ('High CPU usage'). I have never seen a system where tuning the redo copy latches made a huge improvement in performance. Anjo. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Redo Copy Latch contention ??
Hello ALL, Do you guys think we have redo copy latch contention ?? Also what are your suggestions on tuning Redo Copy Latch ?? SUBSTR(LN.NAME,1,20)GETS MISSES IMMEDIATE_GETS IMMEDIATE_MISSES -- -- -- redo allocation 943350646 8862115 0 0 redo copy 22097 497 907958724 1592481 14:54:54 SQL select (497/22097)*100 from dual; (497/22097)*100 ~ (misses/gets)*100 --- 2.2491741 --- Oracle suggests it should be under 1% Madhu Reddy X13944 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana 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: Redo Copy Latch contention ??
According that suggestion you do seem to have redo copy latch contention. As far as getting that ratio close to suggested value, you may set some special init.ora parameters. There is plenty of notes on Metalink for that. But, you should first determine if this is causing any performance issue. Have you explored all other avenues to address those issues. If not, I would not worry about this contention. - Kirti --- Reddy, Madhusudana [EMAIL PROTECTED] wrote: Hello ALL, Do you guys think we have redo copy latch contention ?? Also what are your suggestions on tuning Redo Copy Latch ?? SUBSTR(LN.NAME,1,20)GETS MISSES IMMEDIATE_GETS IMMEDIATE_MISSES -- -- -- redo allocation 943350646 8862115 0 0 redo copy 22097 497 907958724 1592481 14:54:54 SQL select (497/22097)*100 from dual; (497/22097)*100 ~ (misses/gets)*100 --- 2.2491741 --- Oracle suggests it should be under 1% Madhu Reddy X13944 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: Redo Copy Latch contention ??
Thanks Kirti, We have HP Openview implemented on our database and hence got some alert on redo copy latch. When I have queried the database I found the contention on this latch. Yes we have other performance issues ( HIGH CPU utilization , because of lotta bad code ). and We are checking every possible contention on the database. Question : How can I determine if this redo copy latch is causing the performance issues , guess that is my main question before altering some hidden parameter in init.ora. Madhu Reddy X13944 -Original Message- Sent: Wednesday, July 02, 2003 1:56 PM To: Multiple recipients of list ORACLE-L According that suggestion you do seem to have redo copy latch contention. As far as getting that ratio close to suggested value, you may set some special init.ora parameters. There is plenty of notes on Metalink for that. But, you should first determine if this is causing any performance issue. Have you explored all other avenues to address those issues. If not, I would not worry about this contention. - Kirti --- Reddy, Madhusudana [EMAIL PROTECTED] wrote: Hello ALL, Do you guys think we have redo copy latch contention ?? Also what are your suggestions on tuning Redo Copy Latch ?? SUBSTR(LN.NAME,1,20)GETS MISSES IMMEDIATE_GETS IMMEDIATE_MISSES -- -- -- redo allocation 943350646 8862115 0 0 redo copy 22097 497 907958724 1592481 14:54:54 SQL select (497/22097)*100 from dual; (497/22097)*100 ~ (misses/gets)*100 --- 2.2491741 --- Oracle suggests it should be under 1% Madhu Reddy X13944 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana 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: Redo Copy Latch contention ??
Question : How can I determine if this redo copy latch is causing the performance issues , guess that is my main question before altering some hidden parameter in init.ora. Do a 10046 trace and see if you have any waits on this latch. I'll run the risk of being sued for copyright infringement and say that you can't extrapolate detail from an aggregate and aggregates are what you get from the V$ views. Redo copy latch contention might not be a problem for 99% of your users but it might be a huge problem for the other 1% of your users. However, you have no way of figuring out which users are suffering from this by looking at V$ views. And you can't even tell if redo latch contention is a problem even if your ratio is screwed. I'm willing to bet you my autographed Steve Adams' book that you will not fix your redo latch contention by tweaking an init.ora parameter (unless it's set _redo_latch_ratio=0). Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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: Redo Copy Latch contention ??
Wrong alert in HP Open view (you can configure that) and (again) ignoring other more relevant performance information ('High CPU usage'). I have never seen a system where tuning the redo copy latches made a huge improvement in performance. Anjo. On Wednesday 02 July 2003 22:20, you wrote: Thanks Kirti, We have HP Openview implemented on our database and hence got some alert on redo copy latch. When I have queried the database I found the contention on this latch. Yes we have other performance issues ( HIGH CPU utilization , because of lotta bad code ). and We are checking every possible contention on the database. Question : How can I determine if this redo copy latch is causing the performance issues , guess that is my main question before altering some hidden parameter in init.ora. Madhu Reddy X13944 -Original Message- Sent: Wednesday, July 02, 2003 1:56 PM To: Multiple recipients of list ORACLE-L According that suggestion you do seem to have redo copy latch contention. As far as getting that ratio close to suggested value, you may set some special init.ora parameters. There is plenty of notes on Metalink for that. But, you should first determine if this is causing any performance issue. Have you explored all other avenues to address those issues. If not, I would not worry about this contention. - Kirti --- Reddy, Madhusudana [EMAIL PROTECTED] wrote: Hello ALL, Do you guys think we have redo copy latch contention ?? Also what are your suggestions on tuning Redo Copy Latch ?? SUBSTR(LN.NAME,1,20)GETS MISSES IMMEDIATE_GETS IMMEDIATE_MISSES ---- -- redo allocation 943350646 8862115 0 0 redo copy 22097 497 907958724 1592481 14:54:54 SQL select (497/22097)*100 from dual; (497/22097)*100 ~ (misses/gets)*100 --- 2.2491741 --- Oracle suggests it should be under 1% Madhu Reddy X13944 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Anjo Kolk http://www.oraperf.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anjo Kolk 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: Redo Copy Latch contention ??
You are probably right but it was good to have V6-type control over the mechanism. log_simultaneous_copies, log_small_entry_max_size (maximum number of characters that was allocated when allocation latch was acquired) and log_entry_prebuild_threshold (the size of redo after which the user process was building redo entries, instead of LGWR) were easy to understand and maintain. These days, I have no control. Do you remember X$KCBCH tables (I'm not sure about the spelling of this one) that was helping you compute hit ratio if there were few more block buffers? World certainly was simpler before you and Cary destroyed the hit ratio. Shame on you :)! On 2003.07.02 22:24, Anjo Kolk wrote: Wrong alert in HP Open view (you can configure that) and (again) ignoring other more relevant performance information ('High CPU usage'). I have never seen a system where tuning the redo copy latches made a huge improvement in performance. Anjo. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Redo Copy Latch contention ??
I guess fixing queries and code can give much significant and noticable performance gain compared to what one can get by fixing redo copy latch . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 9:40 AM Hello ALL, Do you guys think we have redo copy latch contention ?? Also what are your suggestions on tuning Redo Copy Latch ?? SUBSTR(LN.NAME,1,20) GETS MISSES IMMEDIATE_GETS IMMEDIATE_MISSES -- -- -- redo allocation 9433506468862115 00 redo copy 22097497 907958724 1592481 14:54:54 SQL select (497/22097)*100 from dual; (497/22097)*100 ~ (misses/gets)*100 --- 2.2491741 --- Oracle suggests it should be under 1% Madhu Reddy X13944 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: copy a datafile to a raw device
Stephen / Gene, Actually there is no difference between Raw Devices and File Systems when Oracle reads/writes Oracle Blocks. It is the OS interface that is different -- Character-device or Block-device. Most OSs include a header portion in a Raw Device which must be skipped because when Oracle makes read/write calls to the file [ie, the Raw Device] the OS automatically ignores the header. See these Notes on MetaLink 1. Note 23037.1 on Raw Partitions as Oracle Data Files 2. Note 45351.1 for Digital Unix [skip block of 64K] 3. Note 146384.1 for HP-UX [skip block of 8K] 4. Note 153892.1 on how to use RMAN to copy the data Hemant At 01:19 PM 19-06-03 -0800, you wrote: I might expand on this some. If you think about it, any time you store bytes on something, the storing process has to make a note of where it put the bytes; maybe how many bytes it put there; if the bytes are not contiguous, then info about where one set leaves off and where the next set picks up. And on and on ... I've never worked with Oracle raw devices and am just guessing here, but applying some knowledge about how other forms of storage work, I seems logical that Oracle would have to format the raw device and essentially create a sort of proprietary file system there. If you just toss some bytes on a raw device and tell Oracle to go get 'em, then I'm guessing Oracle will just say something like: This might be a raw device, but it ain't no stinkin' ORACLE raw device. Or, to put it another way: What's this merde? (Pardon my French.) (You have to wonder if there is an error message *something* like this buried down in the Oracle kernel by some irreverent programmer.) -Original Message- From: Stephen Lee Sent: Thursday, June 19, 2003 3:27 PM To: Multiple recipients of list ORACLE-L Subject: RE: copy a datafile to a raw device Well heck. Nobody else has replied, so I might take a stab at it here. I suspect that the format of the data (bits and bytes) required on a raw device is different than the format of the data in a file in a file system. I'm stretching a bit here, but I think an analogy would be what would happen if you dd a file from UFS to NTFS. The data on the NTFS might be a digital copy of what was on UFS, but it's format is totally useless in the context of NTFS. -Original Message- From: Gurelei [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 1:55 PM To: Multiple recipients of list ORACLE-L Subject: copy a datafile to a raw device hi all: I need to move a SYSTEM datafile from a filesystem to a raw device. I have shutdown the database, copied the file via dd if=system of=/dev/raw renamed the file in the database, but couldn't open the database because of the error: Unknown File Header Version read for file number 1. I tried another dd: dd if=system of=/dev/raw obs=32768 (32K is the db block size), but I got the same error. Can anyone see what else could be wrong with my dd command thanks Gene __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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
copy a datafile to a raw device
hi all: I need to move a SYSTEM datafile from a filesystem to a raw device. I have shutdown the database, copied the file via dd if=system of=/dev/raw renamed the file in the database, but couldn't open the database because of the error: Unknown File Header Version read for file number 1. I tried another dd: dd if=system of=/dev/raw obs=32768 (32K is the db block size), but I got the same error. Can anyone see what else could be wrong with my dd command thanks Gene __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei 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: copy a datafile to a raw device
Well heck. Nobody else has replied, so I might take a stab at it here. I suspect that the format of the data (bits and bytes) required on a raw device is different than the format of the data in a file in a file system. I'm stretching a bit here, but I think an analogy would be what would happen if you dd a file from UFS to NTFS. The data on the NTFS might be a digital copy of what was on UFS, but it's format is totally useless in the context of NTFS. -Original Message- From: Gurelei [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 1:55 PM To: Multiple recipients of list ORACLE-L Subject: copy a datafile to a raw device hi all: I need to move a SYSTEM datafile from a filesystem to a raw device. I have shutdown the database, copied the file via dd if=system of=/dev/raw renamed the file in the database, but couldn't open the database because of the error: Unknown File Header Version read for file number 1. I tried another dd: dd if=system of=/dev/raw obs=32768 (32K is the db block size), but I got the same error. Can anyone see what else could be wrong with my dd command thanks Gene __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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: copy a datafile to a raw device
Title: RE: copy a datafile to a raw device It's been a number of years since I did anything with raw devices, so this is all ancient and possibly out of date/incorrect. I believe Stephen to be wrong. The bits and bytes written on the data file are identical, regardless of whether the device is raw or cooked. However, back in the day I worked with these, the file could not use the first block of the raw device, as that was reserved for operating system usage (and back then on those devices, this was 8K). So, we had to do something like dd if=system of=/dev/raw obs=8192 seek=1 to force the dd to skip the first 8K. Since you have already overwritten the first block of the raw device, you might have to drop it and re-create it. Also, since the first 8K was reserved for the OS, the size of the raw device must be at LEAST the size of the datafile + 8K. Matt Matt Adams - GE Appliances - [EMAIL PROTECTED] Another month has ended. All Targets Met. All Systems Working. All Customers Satisfied. All Staff Enthusiastic. All Pigs Fed And Ready To Fly. -Original Message- From: Stephen Lee [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 19, 2003 4:27 PM To: Multiple recipients of list ORACLE-L Subject: RE: copy a datafile to a raw device Well heck. Nobody else has replied, so I might take a stab at it here. I suspect that the format of the data (bits and bytes) required on a raw device is different than the format of the data in a file in a file system. I'm stretching a bit here, but I think an analogy would be what would happen if you dd a file from UFS to NTFS. The data on the NTFS might be a digital copy of what was on UFS, but it's format is totally useless in the context of NTFS. -Original Message- From: Gurelei [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 19, 2003 1:55 PM To: Multiple recipients of list ORACLE-L Subject: copy a datafile to a raw device hi all: I need to move a SYSTEM datafile from a filesystem to a raw device. I have shutdown the database, copied the file via dd if=system of=/dev/raw renamed the file in the database, but couldn't open the database because of the error: Unknown File Header Version read for file number 1. I tried another dd: dd if=system of=/dev/raw obs=32768 (32K is the db block size), but I got the same error. Can anyone see what else could be wrong with my dd command thanks Gene __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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: copy a datafile to a raw device
Gene Good ideas from Stephen. A more basic issue if you haven't dealt with it is that copying a system datafile is different from copying other datafiles. You can't have the database open. I recall that you have to STARTUP MOUNT and ALTER DATABASE DATAFILE. This procedure is covered in the Oracle Manuals. Just thought I should mention this in case you hadn't considered it. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 19, 2003 3:27 PM To: Multiple recipients of list ORACLE-L Well heck. Nobody else has replied, so I might take a stab at it here. I suspect that the format of the data (bits and bytes) required on a raw device is different than the format of the data in a file in a file system. I'm stretching a bit here, but I think an analogy would be what would happen if you dd a file from UFS to NTFS. The data on the NTFS might be a digital copy of what was on UFS, but it's format is totally useless in the context of NTFS. -Original Message- From: Gurelei [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 1:55 PM To: Multiple recipients of list ORACLE-L Subject: copy a datafile to a raw device hi all: I need to move a SYSTEM datafile from a filesystem to a raw device. I have shutdown the database, copied the file via dd if=system of=/dev/raw renamed the file in the database, but couldn't open the database because of the error: Unknown File Header Version read for file number 1. I tried another dd: dd if=system of=/dev/raw obs=32768 (32K is the db block size), but I got the same error. Can anyone see what else could be wrong with my dd command thanks Gene __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: copy a datafile to a raw device
Gene, I recall a similar scenario (this was Oracle7, so it may not apply). The real issue was that oracle uses different file header configurations for cooked and raw files when it uses them. I don't think you can copy the file to a raw device and expect oracle to be happy about it. I think you will have to recreate the database (since it is the system tablespace). If it were another tablespace, I think you could get by with just recreating the tablespace. Daniel Fink -Original Message- From: Gurelei [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 1:55 PM To: Multiple recipients of list ORACLE-L Subject: copy a datafile to a raw device hi all: I need to move a SYSTEM datafile from a filesystem to a raw device. I have shutdown the database, copied the file via dd if=system of=/dev/raw renamed the file in the database, but couldn't open the database because of the error: Unknown File Header Version read for file number 1. I tried another dd: dd if=system of=/dev/raw obs=32768 (32K is the db block size), but I got the same error. Can anyone see what else could be wrong with my dd command thanks Genebegin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard
RE: copy a datafile to a raw device
What platform is this on? On some UNIX platforms the file header for the raw device may vary in size. (It has been a while since I dealt with raw devices). You may have to use seek= option (dd command) to skip the header bytes before actually writing the data using 'dd'. Or just call Oracle Support. - Kirti --- Stephen Lee [EMAIL PROTECTED] wrote: Well heck. Nobody else has replied, so I might take a stab at it here. I suspect that the format of the data (bits and bytes) required on a raw device is different than the format of the data in a file in a file system. I'm stretching a bit here, but I think an analogy would be what would happen if you dd a file from UFS to NTFS. The data on the NTFS might be a digital copy of what was on UFS, but it's format is totally useless in the context of NTFS. -Original Message- From: Gurelei [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 1:55 PM To: Multiple recipients of list ORACLE-L Subject: copy a datafile to a raw device hi all: I need to move a SYSTEM datafile from a filesystem to a raw device. I have shutdown the database, copied the file via dd if=system of=/dev/raw renamed the file in the database, but couldn't open the database because of the error: Unknown File Header Version read for file number 1. I tried another dd: dd if=system of=/dev/raw obs=32768 (32K is the db block size), but I got the same error. Can anyone see what else could be wrong with my dd command thanks Gene __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: copy a datafile to a raw device
Dennis, Thanks for your input. I am doing what the manual says - shutdown , copy, mount, alter, open and every time I'm getting the unknown file header message. I suspect that I am missing some parameters in my dd command because of - as Stephen suggested - different formats. I guess I will have to play with different parameters to see which one is correct. thanks Gene --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Gene Good ideas from Stephen. A more basic issue if you haven't dealt with it is that copying a system datafile is different from copying other datafiles. You can't have the database open. I recall that you have to STARTUP MOUNT and ALTER DATABASE DATAFILE. This procedure is covered in the Oracle Manuals. Just thought I should mention this in case you hadn't considered it. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei 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: copy a datafile to a raw device
I might expand on this some. If you think about it, any time you store bytes on something, the storing process has to make a note of where it put the bytes; maybe how many bytes it put there; if the bytes are not contiguous, then info about where one set leaves off and where the next set picks up. And on and on ... I've never worked with Oracle raw devices and am just guessing here, but applying some knowledge about how other forms of storage work, I seems logical that Oracle would have to format the raw device and essentially create a sort of proprietary file system there. If you just toss some bytes on a raw device and tell Oracle to go get 'em, then I'm guessing Oracle will just say something like: This might be a raw device, but it ain't no stinkin' ORACLE raw device. Or, to put it another way: What's this merde? (Pardon my French.) (You have to wonder if there is an error message *something* like this buried down in the Oracle kernel by some irreverent programmer.) -Original Message- From: Stephen Lee Sent: Thursday, June 19, 2003 3:27 PM To: Multiple recipients of list ORACLE-L Subject: RE: copy a datafile to a raw device Well heck. Nobody else has replied, so I might take a stab at it here. I suspect that the format of the data (bits and bytes) required on a raw device is different than the format of the data in a file in a file system. I'm stretching a bit here, but I think an analogy would be what would happen if you dd a file from UFS to NTFS. The data on the NTFS might be a digital copy of what was on UFS, but it's format is totally useless in the context of NTFS. -Original Message- From: Gurelei [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 1:55 PM To: Multiple recipients of list ORACLE-L Subject: copy a datafile to a raw device hi all: I need to move a SYSTEM datafile from a filesystem to a raw device. I have shutdown the database, copied the file via dd if=system of=/dev/raw renamed the file in the database, but couldn't open the database because of the error: Unknown File Header Version read for file number 1. I tried another dd: dd if=system of=/dev/raw obs=32768 (32K is the db block size), but I got the same error. Can anyone see what else could be wrong with my dd command thanks Gene __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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: copy a datafile to a raw device
Gurelei,ÄúºÃ£¡ hi, what is your OS? In some os, you have to skip some block on that raw device for lvm usage. If you use rman copy, rman will handle it for you. Good luck === 2003-06-19 10:55:00 ÄúÔÚÀ´ÐÅÖÐдµÀ£º=== hi all: I need to move a SYSTEM datafile from a filesystem to a raw device. I have shutdown the database, copied the file via dd if=system of=/dev/raw renamed the file in the database, but couldn't open the database because of the error: Unknown File Header Version read for file number 1. I tried another dd: dd if=system of=/dev/raw obs=32768 (32K is the db block size), but I got the same error. Can anyone see what else could be wrong with my dd command thanks Gene __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei 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). = = = = = = = = = = = = = = = = = = = = Ö Àñ£¡ chao_ping [EMAIL PROTECTED] 2003-06-20 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping 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: copy a datafile to a raw device
Concerning my speculation about error messages in the Oracle kernel, the following is an actual error message in an app here. Of course, the error is never supposed to occur -- so says the programmer when I asked about it. SERROR_MESSAGE := 'How did I Get Here? Where is my car? Who is that laying next to me? Oh my God is that a marriage license?!'; Just in case you developers out there have any creative urges. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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: copy a datafile to a raw device
Well, this oracle file system is the logical storage structure of tablespace, segment, extent, db blocks which is the same on File System or raw device. Richard Ji -Original Message- Sent: Thursday, June 19, 2003 5:20 PM To: Multiple recipients of list ORACLE-L I might expand on this some. If you think about it, any time you store bytes on something, the storing process has to make a note of where it put the bytes; maybe how many bytes it put there; if the bytes are not contiguous, then info about where one set leaves off and where the next set picks up. And on and on ... I've never worked with Oracle raw devices and am just guessing here, but applying some knowledge about how other forms of storage work, I seems logical that Oracle would have to format the raw device and essentially create a sort of proprietary file system there. If you just toss some bytes on a raw device and tell Oracle to go get 'em, then I'm guessing Oracle will just say something like: This might be a raw device, but it ain't no stinkin' ORACLE raw device. Or, to put it another way: What's this merde? (Pardon my French.) (You have to wonder if there is an error message *something* like this buried down in the Oracle kernel by some irreverent programmer.) -Original Message- From: Stephen Lee Sent: Thursday, June 19, 2003 3:27 PM To: Multiple recipients of list ORACLE-L Subject: RE: copy a datafile to a raw device Well heck. Nobody else has replied, so I might take a stab at it here. I suspect that the format of the data (bits and bytes) required on a raw device is different than the format of the data in a file in a file system. I'm stretching a bit here, but I think an analogy would be what would happen if you dd a file from UFS to NTFS. The data on the NTFS might be a digital copy of what was on UFS, but it's format is totally useless in the context of NTFS. -Original Message- From: Gurelei [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 1:55 PM To: Multiple recipients of list ORACLE-L Subject: copy a datafile to a raw device hi all: I need to move a SYSTEM datafile from a filesystem to a raw device. I have shutdown the database, copied the file via dd if=system of=/dev/raw renamed the file in the database, but couldn't open the database because of the error: Unknown File Header Version read for file number 1. I tried another dd: dd if=system of=/dev/raw obs=32768 (32K is the db block size), but I got the same error. Can anyone see what else could be wrong with my dd command thanks Gene __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing
RE: copy a datafile to a raw device
You left out, ...and why is there a goat in the corner? Sounds like a fun way to have at my duhvelopers (not the good ones). -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/19/03 4:49 PM Concerning my speculation about error messages in the Oracle kernel, the following is an actual error message in an app here. Of course, the error is never supposed to occur -- so says the programmer when I asked about it. SERROR_MESSAGE := 'How did I Get Here? Where is my car? Who is that laying next to me? Oh my God is that a marriage license?!'; Just in case you developers out there have any creative urges. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: copy a datafile to a raw device
You didn't mention what Unix platform you are on. But since a striaght dd didn't work, you need to use seek to skip some blocks. -Original Message- Sent: Thursday, June 19, 2003 2:55 PM To: Multiple recipients of list ORACLE-L hi all: I need to move a SYSTEM datafile from a filesystem to a raw device. I have shutdown the database, copied the file via dd if=system of=/dev/raw renamed the file in the database, but couldn't open the database because of the error: Unknown File Header Version read for file number 1. I tried another dd: dd if=system of=/dev/raw obs=32768 (32K is the db block size), but I got the same error. Can anyone see what else could be wrong with my dd command thanks Gene __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: copy a datafile to a raw device
And if I dd a 200 Mb data file to a 1500 Mb raw device ??? -Original Message- Well, this oracle file system is the logical storage structure of tablespace, segment, extent, db blocks which is the same on File System or raw device. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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: copy a datafile to a raw device
You just have lots of empty space left on your raw device. -Original Message- Sent: Thursday, June 19, 2003 6:30 PM To: Multiple recipients of list ORACLE-L And if I dd a 200 Mb data file to a 1500 Mb raw device ??? -Original Message- Well, this oracle file system is the logical storage structure of tablespace, segment, extent, db blocks which is the same on File System or raw device. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus COPY error solved (sort of)
Hadn't thought of trying that; makes sense. Thanks. --- Reardon, Bruce (CALBBAY) [EMAIL PROTECTED] wrote: When you tried under NT, did you use sqlplus.exe or sqlplusw.exe? If you used sqlplusw.exe, this sounds like Bug No. 1504702 The workaround is to use the copy command from the character version of sqlplus (sqlplus.exe) rather than the GUI version. HTH, Bruce Reardon __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus COPY error solved (sort of)
When you tried under NT, did you use sqlplus.exe or sqlplusw.exe? If you used sqlplusw.exe, this sounds like Bug No. 1504702 The workaround is to use the copy command from the character version of sqlplus (sqlplus.exe) rather than the GUI version. HTH, Bruce Reardon -Original Message- Sent: Saturday, 26 October 2002 10:49 AM it's oraus.msg located in rdbms/mesg but that file does NOT exist on Windows systems anymore --- Stephen Lee [EMAIL PROTECTED] wrote: Some severe rustiness here on this topic; but the mists of time have me thinking that Oracle is looking for the file that contains the text for messages it wants to display, and in your case, it can't find the file. I used to know what file this was and where it was located; but would have to look it up now. -Original Message- Sent: Friday, October 25, 2002 3:24 PM This COPY script failure occurred when running in SQL*Plus on Windows NT. In SQL*Plus on (Unix) database server, runs just fine, so immediate problem solved. Shouldn't it work from PC, though? --- Paul Baumgartel [EMAIL PROTECTED] wrote: I'm trying to use (for the first time in 15 years of Oracle experience!) SQL*Plus COPY, and am receiving the following incomprehensible error: SQL @odss/cmsr Array fetch/bind size is 100. (arraysize is 100) Will commit after every 10 array binds. (copycommit is 10) Maximum long size is 2. (long is 2) ERROR: ORA--3393898: Message -3393898 not found; product=RDBMS; facility=ORA Anyone seen this or anything like it? My environment is set up properly; i.e., errors returned by operations other than COPY display the way they're supposed to. TIA! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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: SQL*Plus COPY error
I've not seen this particular error. Over the years I've found SQL*Plus COPY to be buggy. I just did a search on Metalink for sqlplus copy error. Your problem is not addressed directly, but other problems point to bugs in the GUI version of SQL*PLUS. Oracle's advice is to use the command line, non-GUI version of SQL*Plus for COPY. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 25, 2002 12:54 PM I'm trying to use (for the first time in 15 years of Oracle experience!) SQL*Plus COPY, and am receiving the following incomprehensible error: SQL @odss/cmsr Array fetch/bind size is 100. (arraysize is 100) Will commit after every 10 array binds. (copycommit is 10) Maximum long size is 2. (long is 2) ERROR: ORA--3393898: Message -3393898 not found; product=RDBMS; facility=ORA Anyone seen this or anything like it? My environment is set up properly; i.e., errors returned by operations other than COPY display the way they're supposed to. TIA! __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall 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).
SQL*Plus COPY error
I'm trying to use (for the first time in 15 years of Oracle experience!) SQL*Plus COPY, and am receiving the following incomprehensible error: SQL @odss/cmsr Array fetch/bind size is 100. (arraysize is 100) Will commit after every 10 array binds. (copycommit is 10) Maximum long size is 2. (long is 2) ERROR: ORA--3393898: Message -3393898 not found; product=RDBMS; facility=ORA Anyone seen this or anything like it? My environment is set up properly; i.e., errors returned by operations other than COPY display the way they're supposed to. TIA! __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus COPY error
Paul - Hopefully you will receive more helpful advice, but I have received strange errors using the COPY command and the reply I received from Oracle support was that it was being phased out and if I didn't like errors I should write a small PL/SQL program to perform this task (give you a copy if you want it). That was 5 years ago, so obviously it hasn't disappeared. I would recommend modifying your COPY statement until you get away from the error. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 25, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I'm trying to use (for the first time in 15 years of Oracle experience!) SQL*Plus COPY, and am receiving the following incomprehensible error: SQL @odss/cmsr Array fetch/bind size is 100. (arraysize is 100) Will commit after every 10 array binds. (copycommit is 10) Maximum long size is 2. (long is 2) ERROR: ORA--3393898: Message -3393898 not found; product=RDBMS; facility=ORA Anyone seen this or anything like it? My environment is set up properly; i.e., errors returned by operations other than COPY display the way they're supposed to. TIA! __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL*Plus COPY error solved (sort of)
This COPY script failure occurred when running in SQL*Plus on Windows NT. In SQL*Plus on (Unix) database server, runs just fine, so immediate problem solved. Shouldn't it work from PC, though? --- Paul Baumgartel [EMAIL PROTECTED] wrote: I'm trying to use (for the first time in 15 years of Oracle experience!) SQL*Plus COPY, and am receiving the following incomprehensible error: SQL @odss/cmsr Array fetch/bind size is 100. (arraysize is 100) Will commit after every 10 array binds. (copycommit is 10) Maximum long size is 2. (long is 2) ERROR: ORA--3393898: Message -3393898 not found; product=RDBMS; facility=ORA Anyone seen this or anything like it? My environment is set up properly; i.e., errors returned by operations other than COPY display the way they're supposed to. TIA! __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus COPY error solved (sort of)
Some severe rustiness here on this topic; but the mists of time have me thinking that Oracle is looking for the file that contains the text for messages it wants to display, and in your case, it can't find the file. I used to know what file this was and where it was located; but would have to look it up now. -Original Message- Sent: Friday, October 25, 2002 3:24 PM To: Multiple recipients of list ORACLE-L This COPY script failure occurred when running in SQL*Plus on Windows NT. In SQL*Plus on (Unix) database server, runs just fine, so immediate problem solved. Shouldn't it work from PC, though? --- Paul Baumgartel [EMAIL PROTECTED] wrote: I'm trying to use (for the first time in 15 years of Oracle experience!) SQL*Plus COPY, and am receiving the following incomprehensible error: SQL @odss/cmsr Array fetch/bind size is 100. (arraysize is 100) Will commit after every 10 array binds. (copycommit is 10) Maximum long size is 2. (long is 2) ERROR: ORA--3393898: Message -3393898 not found; product=RDBMS; facility=ORA Anyone seen this or anything like it? My environment is set up properly; i.e., errors returned by operations other than COPY display the way they're supposed to. TIA! __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee 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: SQL*Plus COPY error solved (sort of)
it's oraus.msg located in rdbms/mesg but that file does NOT exist on Windows systems anymore --- Stephen Lee [EMAIL PROTECTED] wrote: Some severe rustiness here on this topic; but the mists of time have me thinking that Oracle is looking for the file that contains the text for messages it wants to display, and in your case, it can't find the file. I used to know what file this was and where it was located; but would have to look it up now. -Original Message- Sent: Friday, October 25, 2002 3:24 PM To: Multiple recipients of list ORACLE-L This COPY script failure occurred when running in SQL*Plus on Windows NT. In SQL*Plus on (Unix) database server, runs just fine, so immediate problem solved. Shouldn't it work from PC, though? --- Paul Baumgartel [EMAIL PROTECTED] wrote: I'm trying to use (for the first time in 15 years of Oracle experience!) SQL*Plus COPY, and am receiving the following incomprehensible error: SQL @odss/cmsr Array fetch/bind size is 100. (arraysize is 100) Will commit after every 10 array binds. (copycommit is 10) Maximum long size is 2. (long is 2) ERROR: ORA--3393898: Message -3393898 not found; product=RDBMS; facility=ORA Anyone seen this or anything like it? My environment is set up properly; i.e., errors returned by operations other than COPY display the way they're supposed to. TIA! __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 'redo copy' latch
Naveen: The parameter in 8.1.7 is hidden (I think it's hidden in 8.0 too). The parameter that controls the number of redo copy latches is log_simultaneous_copies. Check if it's in v$parameter, if it's not then it's a hidden one. Anyway you'll be able to see it at x$ksppi and x$ksppcv. HTH Greetings Diego Cutrone Thanx for the reply. Version is 8.0.6.1.0 on WindowsNT What is the parameter that defines the no. of 'redo copy latches'. Is it decided by Oracle or DBA has the control over it? Regards Naveen -Original Message- Sent: Wednesday, October 23, 2002 4:34 AM To: Multiple recipients of list ORACLE-L Naveen: What Oracle version are you using? The LGWR behavior has changed in version 8i. As far as I know (and you can read many papers about it in ixora site), the redo copy latches are requested as immediate (no-wait mode), all of them except the last one. The last one is requested in wait mode. As you have many redo copy latches Oracle does not waste any time sleeping for one of them, he tries the other ones first and sleep for the last one. BUT this is the LGWR behavior up to version 7.3.4, I think that in newer versions (8i 9i) it has changed a lot, and I believe that Oracle does not wait for the redo copy latches any longer. I hope some Guru could confirm this and explain the new behavior in detail. HTH Greetings Diego Cutrone Hi All, When looking at v$latch it gave me the following stats for 'redo copy' GETS: 35 MISSES: 21 IMMEDIATE_GETS: 326975 IMMEDIATE_MISSES: 65 according to my understanding 'redo copy' is required when the process writes to the redo buffer. am i right? if i'm right, why is it that this latch is requested with a no-wait option(evident from high IMMEDIATE_GETS as compared to GETS). regards Naveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata 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: 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: Naveen Nahata 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: 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).
'redo copy' latch
Hi All, When looking at v$latch it gave me the following stats for 'redo copy' GETS: 35 MISSES: 21 IMMEDIATE_GETS: 326975 IMMEDIATE_MISSES: 65 according to my understanding 'redo copy' is required when the process writes to the redo buffer. am i right? if i'm right, why is it that this latch is requested with a no-wait option(evident from high IMMEDIATE_GETS as compared to GETS). regards Naveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata 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: 'redo copy' latch
Naveen: What Oracle version are you using? The LGWR behavior has changed in version 8i. As far as I know (and you can read many papers about it in ixora site), the redo copy latches are requested as immediate (no-wait mode), all of them except the last one. The last one is requested in wait mode. As you have many redo copy latches Oracle does not waste any time sleeping for one of them, he tries the other ones first and sleep for the last one. BUT this is the LGWR behavior up to version 7.3.4, I think that in newer versions (8i 9i) it has changed a lot, and I believe that Oracle does not wait for the redo copy latches any longer. I hope some Guru could confirm this and explain the new behavior in detail. HTH Greetings Diego Cutrone Hi All, When looking at v$latch it gave me the following stats for 'redo copy' GETS: 35 MISSES: 21 IMMEDIATE_GETS: 326975 IMMEDIATE_MISSES: 65 according to my understanding 'redo copy' is required when the process writes to the redo buffer. am i right? if i'm right, why is it that this latch is requested with a no-wait option(evident from high IMMEDIATE_GETS as compared to GETS). regards Naveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata 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: 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).
RE: 'redo copy' latch
Thanx for the reply. Version is 8.0.6.1.0 on WindowsNT What is the parameter that defines the no. of 'redo copy latches'. Is it decided by Oracle or DBA has the control over it? Regards Naveen -Original Message- Sent: Wednesday, October 23, 2002 4:34 AM To: Multiple recipients of list ORACLE-L Naveen: What Oracle version are you using? The LGWR behavior has changed in version 8i. As far as I know (and you can read many papers about it in ixora site), the redo copy latches are requested as immediate (no-wait mode), all of them except the last one. The last one is requested in wait mode. As you have many redo copy latches Oracle does not waste any time sleeping for one of them, he tries the other ones first and sleep for the last one. BUT this is the LGWR behavior up to version 7.3.4, I think that in newer versions (8i 9i) it has changed a lot, and I believe that Oracle does not wait for the redo copy latches any longer. I hope some Guru could confirm this and explain the new behavior in detail. HTH Greetings Diego Cutrone Hi All, When looking at v$latch it gave me the following stats for 'redo copy' GETS: 35 MISSES: 21 IMMEDIATE_GETS: 326975 IMMEDIATE_MISSES: 65 according to my understanding 'redo copy' is required when the process writes to the redo buffer. am i right? if i'm right, why is it that this latch is requested with a no-wait option(evident from high IMMEDIATE_GETS as compared to GETS). regards Naveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata 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: 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: Naveen Nahata 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).
Is it possible to copy one db to another if the SID is different
Hi, Qn : Is it possible to copy one database to another if the source database name is different from the target database name ? I need to clone Oracle Applications 11I from one machine (source instance:PROD) to another (target instance:TEST). I followed the instructions on Metalink doc 135792.1 Cloning Oracle Applications Release 11I. Everything works fine until I re-create the controlfile in the target instance. In svrmgrl = STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 2 MAXDATAFILES 500 MAXINSTANCES 1 MAXLOGHISTORY 453 LOGFILE GROUP 1 ( '/dg3/oracle/testredo/log01a.dbf', '/dg4/oracle/testredo/log01b.dbf' ) SIZE 10M DATAFILE '/dg7/oracle/testdata/system01.dbf', '/dg7/oracle/testdata/system02.dbf', ... '/dg8/oracle/testdata/ctxd01.dbf', . CHARACTER SET US7ASCII CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01161: database name PROD in file header does not match given name of TEST Any advice ? Thanks. (Please reply to [EMAIL PROTECTED]) Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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: Is it possible to copy one db to another if the SID is differ
Hi Yen-wee, I tried but still get the following error message : CREATE CONTROLFILE SET DATABASE TEST RESETLOGS NOARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01161: database name PROD in file header does not match given name of TEST ORA-01110: data file 6: '/dg8/oracle/testdata/ctxd01.dbf' Any advice ? Thanks. (Please reply to [EMAIL PROTECTED]) Regds, New Bee -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 3:18 PM To: CHAN Chor Ling Catherine (CSC) Subject:RE: Is it possible to copy one db to another if the SID is differ ent Hi Can u try SET instead of REUSE? CREATE CONTROLFILE SET DATABASE TEST RESETLOGS ARCHIVELOG -Original Message- From: CHAN Chor Ling Catherine (CSC) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 3:13 PM To: Multiple recipients of list ORACLE-L Subject: Is it possible to copy one db to another if the SID is different Hi, Qn : Is it possible to copy one database to another if the source database name is different from the target database name ? I need to clone Oracle Applications 11I from one machine (source instance:PROD) to another (target instance:TEST). I followed the instructions on Metalink doc 135792.1 Cloning Oracle Applications Release 11I. Everything works fine until I re-create the controlfile in the target instance. In svrmgrl = STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 2 MAXDATAFILES 500 MAXINSTANCES 1 MAXLOGHISTORY 453 LOGFILE GROUP 1 ( '/dg3/oracle/testredo/log01a.dbf', '/dg4/oracle/testredo/log01b.dbf' ) SIZE 10M DATAFILE '/dg7/oracle/testdata/system01.dbf', '/dg7/oracle/testdata/system02.dbf', ... '/dg8/oracle/testdata/ctxd01.dbf', . CHARACTER SET US7ASCII CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01161: database name PROD in file header does not match given name of TEST Any advice ? Thanks. (Please reply to [EMAIL PROTECTED]) Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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: CHAN Chor Ling Catherine (CSC) 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: Is it possible to copy one db to another if the SID is differ
Hi, You have to recreate the controlfile as CREATE CONTROLFILE SET DATABASE TEST RESETLOGS ARCHIVELOG. The new database name will be TEST . Pl ensure that the old control files are deleted before recereating the controlfile . Regards Rajendra -Original Message- Sent: Wednesday, October 09, 2002 12:43 PM To: Multiple recipients of list ORACLE-L different Hi, Qn : Is it possible to copy one database to another if the source database name is different from the target database name ? I need to clone Oracle Applications 11I from one machine (source instance:PROD) to another (target instance:TEST). I followed the instructions on Metalink doc 135792.1 Cloning Oracle Applications Release 11I. Everything works fine until I re-create the controlfile in the target instance. In svrmgrl = STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 2 MAXDATAFILES 500 MAXINSTANCES 1 MAXLOGHISTORY 453 LOGFILE GROUP 1 ( '/dg3/oracle/testredo/log01a.dbf', '/dg4/oracle/testredo/log01b.dbf' ) SIZE 10M DATAFILE '/dg7/oracle/testdata/system01.dbf', '/dg7/oracle/testdata/system02.dbf', ... '/dg8/oracle/testdata/ctxd01.dbf', . CHARACTER SET US7ASCII CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01161: database name PROD in file header does not match given name of TEST Any advice ? Thanks. (Please reply to [EMAIL PROTECTED]) Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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: Choudhary Rajendra (TTL_LKO) 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: Is it possible to copy one db to another if the SID is different
Hi, Please use SET in create controlfile statement if you are going to change the DB Name. CREATE CONTROLFILE REUSE SET DATABASE TEST RESETLOGS ARCHIVELOG thnx Venkat ORACLE-L@fatcity. com To: Multiple recipients of list ORACLE-L Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: Is it possible to copy one db to another if the SID is different 10/09/02 12:43 PM Please respond to ORACLE-L Hi, Qn : Is it possible to copy one database to another if the source database name is different from the target database name ? I need to clone Oracle Applications 11I from one machine (source instance:PROD) to another (target instance:TEST). I followed the instructions on Metalink doc 135792.1 Cloning Oracle Applications Release 11I. Everything works fine until I re-create the controlfile in the target instance. In svrmgrl = STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 2 MAXDATAFILES 500 MAXINSTANCES 1 MAXLOGHISTORY 453 LOGFILE GROUP 1 ( '/dg3/oracle/testredo/log01a.dbf', '/dg4/oracle/testredo/log01b.dbf' ) SIZE 10M DATAFILE '/dg7/oracle/testdata/system01.dbf', '/dg7/oracle/testdata/system02.dbf', ... '/dg8/oracle/testdata/ctxd01.dbf', . CHARACTER SET US7ASCII CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01161: database name PROD in file header does not match given name of TEST Any advice ? Thanks. (Please reply to [EMAIL PROTECTED]) Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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: 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: Is it possible to copy one db to another if the SID is differ
hi you have to do a alter database backup controlfile to trace on the source database change all occurrences PROD in TEST in the created backup controlfile the create controlfile reuse has to be create controlfile SET database test oracle note 61590.1 on metalink g.g. kor rdw the netherlands -Oorspronkelijk bericht- Van: CHAN Chor Ling Catherine (CSC) [SMTP:[EMAIL PROTECTED]] Verzonden:woensdag 9 oktober 2002 9:13 Aan: Multiple recipients of list ORACLE-L Onderwerp:Is it possible to copy one db to another if the SID is different Hi, Qn : Is it possible to copy one database to another if the source database name is different from the target database name ? I need to clone Oracle Applications 11I from one machine (source instance:PROD) to another (target instance:TEST). I followed the instructions on Metalink doc 135792.1 Cloning Oracle Applications Release 11I. Everything works fine until I re-create the controlfile in the target instance. In svrmgrl = STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 2 MAXDATAFILES 500 MAXINSTANCES 1 MAXLOGHISTORY 453 LOGFILE GROUP 1 ( '/dg3/oracle/testredo/log01a.dbf', '/dg4/oracle/testredo/log01b.dbf' ) SIZE 10M DATAFILE '/dg7/oracle/testdata/system01.dbf', '/dg7/oracle/testdata/system02.dbf', ... '/dg8/oracle/testdata/ctxd01.dbf', . CHARACTER SET US7ASCII CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01161: database name PROD in file header does not match given name of TEST Any advice ? Thanks. (Please reply to [EMAIL PROTECTED]) Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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: 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: Is it possible to copy one db to another if the SID is differ
Thanks to those (Venkat, Rajendra and Yen-Wee) who replied. Problem has been resolved. Solution : * Has to use CREATE CONTROLFILE SET DATABASE TEST RESETLOGS ARCHIVELOG * I forgot to delete old control files. Thank you so much. Regds, New Bee -Original Message- From: Choudhary Rajendra (TTL_LKO) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 4:08 PM To: Multiple recipients of list ORACLE-L Subject:RE: Is it possible to copy one db to another if the SID is differ Hi, You have to recreate the controlfile as CREATE CONTROLFILE SET DATABASE TEST RESETLOGS ARCHIVELOG. The new database name will be TEST . Pl ensure that the old control files are deleted before recereating the controlfile . Regards Rajendra -Original Message- Sent: Wednesday, October 09, 2002 12:43 PM To: Multiple recipients of list ORACLE-L different Hi, Qn : Is it possible to copy one database to another if the source database name is different from the target database name ? I need to clone Oracle Applications 11I from one machine (source instance:PROD) to another (target instance:TEST). I followed the instructions on Metalink doc 135792.1 Cloning Oracle Applications Release 11I. Everything works fine until I re-create the controlfile in the target instance. In svrmgrl = STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 2 MAXDATAFILES 500 MAXINSTANCES 1 MAXLOGHISTORY 453 LOGFILE GROUP 1 ( '/dg3/oracle/testredo/log01a.dbf', '/dg4/oracle/testredo/log01b.dbf' ) SIZE 10M DATAFILE '/dg7/oracle/testdata/system01.dbf', '/dg7/oracle/testdata/system02.dbf', ... '/dg8/oracle/testdata/ctxd01.dbf', . CHARACTER SET US7ASCII CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01161: database name PROD in file header does not match given name of TEST Any advice ? Thanks. (Please reply to [EMAIL PROTECTED]) Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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: Choudhary Rajendra (TTL_LKO) 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: CHAN Chor Ling Catherine (CSC) 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