RE: I know its early since OOW is just over BUT
Is anyone planning on going to IOUG conference in Toronto, CA, next spring(2004)??? Joe Some papers submitted ... Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Rman equivalent for MS-SQL server
Hi good people- Does anyone out there know of the equivalent of oracles RMAN in MS SQL server environs. Im investigating the possibility of having my SQL server dump the backups direct to a third party tape library VERITAS to be specific. Your input on this thread will be highly appreciated. CSW Simon.
Oracle Press OCP exam guide frustrations
All, I just purchased a Oracle9i Fundamentals I exam guide published by Oracle Press and am very disappointed with the quality of the publication. There seems to be quite a few mistakes, misleading sentences and typos (not in the Errata) which is very frustrating. Also, there is a question in the Managing Tablespaces and Datafiles chapter that replies on the order of the multiple-choices, however the quiz software randomises the choices so the question no longer makes sense - and is impossible to answer as presented. For those that have completed the OCP exam, is this what I am to expect? Does anyone know of any other resources I might be able to use? How are the OCP exam guides published by Sybex? Any help would be greatly appreciated. Regards, Craig. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Munday INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Rman equivalent for MS-SQL server
There is no MSSQL utility that is directly equivalent to RMAN. You use Enterprise Manager or Query Analyzer to manage backups. Gudmundur - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Tuesday, September 16, 2003 9:39 AM Subject: Rman equivalent for MS-SQL server Hi good people- Does anyone out there know of the equivalent of oracles RMAN in MS SQL server environs. Im investigating the possibility of having my SQL server dump the backups direct to a third party tape library VERITAS to be specific. Your input on this thread will be highly appreciated. CSW Simon.
RMAN-03015 error during TSPITR
Hi, My target instance is 9.2.0.4 on Host A ( Ms-win2k + SP3 ). My recovery catalog is also 9.2.0.4 on Host B ( Ms-win2k + SP3 ). My target destination for backup files is R:\ which resides on Host C (WinNT).This drive R:\ is common to both Host A and B. Things work fine accessing R:\ from both Host A and B. I tried a TSPITR following the doc. 180436.1. It is for 8i. Question #1: is it applicable for 9i also ? If YES, when i say (on Host A,the target), run { ALLOCATE AUXILIARY CHANNEL A1 TYPE DISK; ALLOCATE CHANNEL c1 TYPE DISK; recover tablespace users until time TO_DATE('MAR-05-2002 11:27:00', 'MON-DD- HH:MI:SS'); } i get the error below: channel a1: starting datafile backupset restore channel a1: specifying datafile(s) to restore from backup set restoring datafile 1 to D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF released channel: a1 released channel: c1 RMAN-00571: == RMAN-00569: === ERROR MESSAGE STACK FOLLOWS = RMAN-00571: == RMAN-03002: failure of recover command at 09/16/2003 17:48:32 RMAN-03015: error occurred in stored script Memory Script ORA-19504: failed to create file D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF ORA-27040: skgfrcre: create error, unable to create file OSD-04002: unable to open file O/S-Error: (OS 3) Path not found. Question #2: db_file_name_convert=(d:\oracle\oradata\pe92,d:\oracle\oradata\aux92); log_file_name_convert=(d:\oracle\oradata\pe92,d:\oracle\oradata\aux92); why does RMAN try to restore SYSTEM01.DBF to D:\ORACLE\ORA92\DATABASE\ ? i have not mentioned this path anywhere in my recovery action. Question #3: though it is not restore path,why does RMAN's Memory script append ;\ in the path i.e.,D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF this is where it fails. can someone explain me where the problem is ? 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: Dataguard Benchmark
Title: Message Hi Plan of the Benchmark = ? If you mean an action plan of important steps ? We have just started. I Shall send it to you shortly. Monitoring of Actual Bandwidth thruput (MBPS) used versus that set on WAN will be done . (other than actual application transaction thruput rate (TPS) , OS resources Utilizations ) Thanks indeed -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 2:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: Dataguard Benchmark Did you plan that benchmark? What did you decide to monitor in the planning phase? -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of VIVEK_SHARMA Sent: Monday, September 15, 2003 1:49 PM To: Multiple recipients of list ORACLE-L Subject: Dataguard Benchmark We are doing a Data guard Benchmark. INFO.:- - WAN Simulator :- We have a WAN Simulator with 2 routers at either ends of it. Thruputs from 0 to 2 MBPS can be manually set as is required by the run. Application = Banking :- Transactions mainly OLTP in nature (Both DML SELECTS) . We can do CPU intensive batch Transactions too if advised by you folks Machines = 2 machines of 4 CPUs each Memory = 8 GB on each machine O.S. = Solaris 9 Oracle = 9.2 Sniffer network tool ( to get volume of bytes transferred over the WAN ) Dataguard Setup will transfer Data thru the listener services :- i.e. init.ora - LOG_ARCHIVE_DEST_2 = SERVICE=SERVICE_NAME_FROM_TNSNAMES.ORA,. . . Execution methodology:- Run Same Transactions Volume in BOTH Logical Physical (Maximum Protection , Maximum Availability , Maximum performance ) standby modes Qs What readings to be particularly monitored measured? Qs What thruput bandwidths should be benchmarked? Qs Does total Size of Existent Database-in-use matter to the Benchmark? Current Database Size = 3 GB Qs Does RMAN setup add any value to the Dataguard benchmark in some way? Else we will do Without RMAN, manually altering the various modes Qs Any Sample Docs, Links on existing Dataguard Benchmarks? Qs Any else that will enable us to bring out a paper of reasonable standard?
RE: Rman equivalent for MS-SQL server
You can actually use Database Maintenance Plans, to mimic RMAN to a certain extent. Database Maintenance Plans is basically a wizard that generates a load of MSDB jobs that get run by the SQL*Agent. This does have some limitations though. It has no support for differential backups, doesn't support appended backups to an already existing device, you can't duplex back up files, and a number of the backup options aren't available. This is described in some detail in SQLServer for Oracle DBAs an e-book that I would highly recommend to all primarily Oracle DBAs that have to do a certain amount of SQLServer work too. http://www.chriskempster.com/ HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Gudmundur Josepsson Sent: 16 September 2003 11:19 To: Multiple recipients of list ORACLE-L There is no MSSQL utility that is directly equivalent to RMAN. You use Enterprise Manager or Query Analyzer to manage backups. Gudmundur - Original Message - To: Multiple recipients of list ORACLE-L Sent: Tuesday, September 16, 2003 9:39 AM Hi good people- Does anyone out there know of the equivalent of oracles RMAN in MS SQL server environs. Im investigating the possibility of having my SQL server dump the backups direct to a third party tape library VERITAS to be specific. Your input on this thread will be highly appreciated. CSW Simon. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rman equivalent for MS-SQL server
This beast does not exist. You can use the Database Maintenance Plans in EM to manage your backups. I have found these to be flaky and prefer writing my own custom backup plans in scripts and schedule these as jobs. >From my experience on SQL Server I recommend doing a native SQL Server backup to disk, then have the third party backup software pickup those files to tape. Just my $.02 Dave -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 16, 2003 4:39 AMTo: Multiple recipients of list ORACLE-LSubject: Rman equivalent for MS-SQL server Hi good people- Does anyone out there know of the equivalent of oracles RMAN in MS SQL server environs. Im investigating the possibility of having my SQL server dump the backups direct to a third party tape library VERITAS to be specific. Your input on this thread will be highly appreciated. CSW Simon.
Re: Checking for code using hints(from database)
(reposting) Hi! I think you should focus on why you do have bad performance/CBO decisions when all tables have been analyzed. Finding most expensive operations (v$sql, 10046 trace, tkprof) - comparing their execution plans with different statistics (tkprof, explain plan, v$sql_plan in 9i) - finding the reasons behing bad CBO decisions (10053 trace). But if you really want to search for hints, then you should search for '%/*+%' in v$sql during normal database usage time (not v$sqlarea, because it's access is more CPU resource hungry). DBA_SOURCE provides you information about stored pl/sql only and you can't search wrapped code. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, September 14, 2003 11:09 AM I think you need to scan user_source; select distinct name from user_source where type in ('FUNCTION' , 'PROCEDURE' , 'PACKAGE BODY') and text like '%/*+%'; Did not test the query though. HTH GovindanK On Sat, 13 Sep 2003 19:59 , M Rafiq [EMAIL PROTECTED] sent: Env OPEN VMS ALPHA 7.3 Database 8.1.7.4 Optimizer = Choose Application written for Rule but use of lot of Hints in code. Reason of using cost based optimizer to create/use function based indexes. Selected tables are analyzed as all tablles(except sys) resulted in bad performance. This is the environment of a short time project I am working with. I would like to track all those tables which are being used in application/customized code using HINTS and atleast analyze those tables which are not in their selective analyze list which is also not being analyzed regularly. What is the best place to check such codes v$sqlarea/V$sql/V$sqltext or any other place in database. I will appreciate a sql code to fetch all such codes from database. If I am thinking in wrong direction, I shall appreciate your assistance.Right now I don't have option to check application codes from system. Regards Rafiq _ Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage. http://join.msn.com/\?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Message sent via Zuvio Mail Get your own FREE email account with SPAM and Antivirus protection! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Govindan K INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Unix- How to remove the first few lines(N) in a file without
(reposting) Afaik, vi can run in non-interactive, batch mode too. But I'd go with tail +6 Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, September 14, 2003 10:49 PM Mladen ,I want to automate this thing. So don't want to go with :1,5d stuff --- Mladen Gogala [EMAIL PROTECTED] wrote: The best thing to do would be something like: vi filename :1,5d :x! That would do the trick. Also this: * #!/usr/bin/perl -w use strict my $ind=1; open FILE1,/file1/path||die Cannot open file1:$!\n; open FILE2,/file2/path||die Cannot open file2:$!\n; # Skip 5 lines for($ind=1;$ind=5;$ind++) { FILE1; } # copy files while (FILE1) { print FILE2 $_; } print I'm all done\n; On 2003.09.14 12:14, Tim Gorman wrote: sed '6,$p' filename new-filename on 9/14/03 7:49 AM, Oracle DBA at [EMAIL PROTECTED] wrote: Hi List, I want to remove the first 5 lines of the text from unix text file. Is there a command to do it without opening a file manually? (I don't want to use (DD command) For example, == 1 to be removed 2 to be removed 3 to be removed 4 to be removed 5 to be removed a s == Any help would be really appreciated. TIA Sami __ 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: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 -- 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). __ 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: 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: 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: Dataguard Benchmark
No. I mean the goals of the benchmark. What are you measuring and why. On 2003.09.16 06:10, VIVEK_SHARMA wrote: Hi Plan of the Benchmark = ? If you mean an action plan of important steps ? We have just started. I Shall send it to you shortly. Monitoring of Actual Bandwidth thruput (MBPS) used versus that set on WAN will be done . (other than actual application transaction thruput rate (TPS) , OS resources Utilizations ) Thanks indeed -Original Message- Sent: Tuesday, September 16, 2003 2:59 AM To: Multiple recipients of list ORACLE-L Did you plan that benchmark? What did you decide to monitor in the planning phase? -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of VIVEK_SHARMA Sent: Monday, September 15, 2003 1:49 PM To: Multiple recipients of list ORACLE-L Subject: Dataguard Benchmark We are doing a Data guard Benchmark. INFO.:- - WAN Simulator :- We have a WAN Simulator with 2 routers at either ends of it. Thruputs from 0 to 2 MBPS can be manually set as is required by the run. Application = Banking :- Transactions mainly OLTP in nature (Both DML SELECTS) . We can do CPU intensive batch Transactions too if advised by you folks Machines = 2 machines of 4 CPUs each Memory = 8 GB on each machine O.S. = Solaris 9 Oracle = 9.2 Sniffer network tool ( to get volume of bytes transferred over the WAN ) Dataguard Setup will transfer Data thru the listener services :- i.e. init.ora - LOG_ARCHIVE_DEST_2 = 'SERVICE=SERVICE_NAME_FROM_TNSNAMES.ORA,. . .' Execution methodology:- Run Same Transaction's Volume in BOTH Logical Physical (Maximum Protection , Maximum Availability , Maximum performance ) standby modes Qs What readings to be particularly monitored measured? Qs What thruput bandwidths should be benchmarked? Qs Does total Size of Existent Database-in-use matter to the Benchmark? Current Database Size = 3 GB Qs Does RMAN setup add any value to the Dataguard benchmark in some way? Else we will do Without RMAN, manually altering the various modes Qs Any Sample Docs, Links on existing Dataguard Benchmarks? Qs Any else that will enable us to bring out a paper of reasonable standard? -- 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: HP-UX 11/9iR2/dbv
(reposting) Hi! In 9i, you can actually dbv files online. No blocks are falsely detected as corrupt, they're just rescanned in case block header tail SCN and wrap bytes don't match. If the block is continuously in change, then block is reported as being in flux not corrupt. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, September 14, 2003 11:04 PM Hi All! This is a question for the script gurus out there. I am running an SAP system. Recently, during a DR test, we found several files with corruption. These were found originally with an ORA-600 [12700], and confirmed with dbv. So now they want me to run dbv's on the database files during the maintenance window. Now, I can create a script that will scan all the files, but it's linear and will take for-flipping-ever. So, has anyone out there created a script (csh, ksh, sh, perl, whatever) that can take a parameter list of files, and keep several child processes running at a time? What I want to do is create a list of all database files. This list would be input to a script that would keep 'n' child processes running (running 'dbv') until the list was exhausted. Say that 'n' was six. This process would keep 6 dbv's running. When one child dbv process finished, the next in line would be started. Anybody done something like this, or am I just an ambitious dreamer? Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
how to benchmark HDS 9570 storage?
Hi, friends: We plan to purchase a HDS 9570 storage system with 4Gb Cache/14 Disks to replace current Sun T3 storage. Our database is an OLTP system with 80%read/20 write. But decision has to be made whether HDS 9570 really worth its price and how much it outperforms sun T3. Those friends that are running HDS storage , can you share your experience with using HDS storage for oracle database , how it performs and what raid level are you running? (HDS claims that raid5 in HDS is as efficient as raid10). Thanks Regards zhu chao msn:[EMAIL PROTECTED] www.cnoug.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: zhu chao INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
set correct next time after fixing broken job
If I mark a job as broken to prevent its being run and later mark it as being unbroken, it appears that by default the "next run date" is set as the current date. If I want to have the job rescheduled back to its original date/time, is there a way to do that. Let's say the job runs daily at 10:00 p.m. If I mark the job as broken and later as unbroken without specifying a date, it runs immediately. However, I know that I can code a date when I unbreak the job, but how can I do this in sql without hardcoding a date. We have several jobs we would sometimes like halted during maintenance and would like to avoid having to hardcode a date when unbreak them. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
RE: Configuring RMAN
Title: Configuring RMAN You have to create the catalog. Check the docs to see how to do this. In 8.1.7 I think it is simply create catalog. Then you have to register the databases you want to use this catalog for, etc. The docs are quite good. HTH, Ruth -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Ramon E. EstevezSent: Monday, September 15, 2003 7:24 PMTo: Multiple recipients of list ORACLE-LSubject: Configuring RMAN Hi list, I am implementing RMAN in an RH AS 2.1 environment on Oracle 8.1.7 and at the prompt When using rman catalog rman/[EMAIL PROTECTED] I get rman: can't open catalog I recreated the password file and the same error. TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994
Re: error transporting a tablespace from 8i to 9i?
It looks like your 8i database is defined with national char set of WE8ISO8859P1 and your target is defined with AL16UTF16 as national char set. They have to match if you want to transport tablespace. See in metalink: Note:66320.1 Subject: Changing the Database Character Set or the Database National Character Set Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 15, 2003 10:29 PM We are trying to transport a tablespace from 8i to 9i. According to metalink Oracle changed the NCHAR character set to 2 values so we dont have a match. we can do an export/import, but no transportable tablespaces. Any known work around? Short of destroying all our 8i databases and recreating them to match the 9i standards(since the 9i ones cant use what is in 8i). Connected to: Oracle9i Enterprise Edition RelEase 9.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production IMP-2: failed to open expdat.dmp for read Import file: expdat.dmp /mnt/myfile.dbf Export file created by EXPORT:V08.01.07 via conventional path About to import transportable tablespace(s) metadata... import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversion) IMP-00017: following statement failed with ORACLE error 19736: BEGIN sys.dbms_plugts.beginImport ('8.1.7.3.0',31,'31',NULL,'NULL',226234 ,1569301,1); END; IMP-3: ORACLE error 19736 encountered ORA-19736: can not plug a tablespace into a database using a different national character set ORA-06512: at SYS.DBMS_PLUGTS, line 1797 ORA-06512: at SYS.DBMS_PLUGTS, line 1636 ORA-06512: at line 1 IMP-00017: following statement failed with ORACLE error 29344: BEGIN sys.dbms_plugts.checkUser('myuser); END; IMP-3: ORACLE error 29344 encountered ORA-29344: Owner validation failed - failed to match owner 'WEB_OWNER_3' ORA-06512: at SYS.DBMS_PLUGTS, line 1597 ORA-06512: at line 1 IMP-00034: Warning: FromUser myuser not found in export file Import terminated successfully with warnings. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: I know its early since OOW is just over BUT
If my presentation gets accepted. I can't afford it otherwise. Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Joe Testa Sent: Monday, September 15, 2003 4:49 PM To: Multiple recipients of list ORACLE-L Subject: I know its early since OOW is just over BUT Is anyone planning on going to IOUG conference in Toronto, CA, next spring(2004)??? Joe -- 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Cron question
Hallo, anyone whom could help me with this. I am trying to use crontab -e to start a procedure. but I cant get it right. Anyone whom could help me with the command how to write if I want a program in unix to be scheduled to run every monday at 6 o´clock in the morning? Thanks in advance. Roland -- 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: Cron question
Title: RE: Cron question $ man cron That is all! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 16, 2003 8:19 AM To: Multiple recipients of list ORACLE-L Subject: Cron question Hallo, anyone whom could help me with this. I am trying to use crontab -e to start a procedure. but I cant get it right. Anyone whom could help me with the command how to write if I want a program in unix to be scheduled to run every monday at 6 o´clock in the morning? Thanks in advance. Roland -- 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: Raid Arrays and Power Loss
Ian, Thanks for sharing (seriously). Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- MacGregor, Ian A. Sent: Monday, September 15, 2003 11:34 PM To: Multiple recipients of list ORACLE-L Last Friday was hot here, and rumor has it our 230 KV power line sagged and touched some tree branches. The local power company shut it off. Leaving our systems to depend on UPS. About 30 minutes afterwards one system produced these errors. This was jus before the system went dead Fri Sep 12 12:58:40 2003 Errors in file /opt/oracle/admin/BBRO/bdump/bbro_ckpt_1420.trc: ORA-00206: error in writing (block 3, # blocks 1) of controlfile ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl' ORA-27063: skgfospo: number of bytes read/written is incorrect SVR4 Error: 5: I/O error Additional information: -1 Additional information: 8192 Fri Sep 12 12:58:42 2003 Errors in file /opt/oracle/admin/BBRO/bdump/bbro_ckpt_1420.trc: ORA-00221: error on write to controlfile ORA-00206: error in writing (block 3, # blocks 1) of controlfile ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl' ORA-27063: skgfospo: number of bytes read/written is incorrect SVR4 Error: 5: I/O error Additional information: -1 Additional information: 8192 Fri Sep 12 12:58:42 2003 CKPT: terminating instance due to error 221 Instance terminated by CKPT, pid = 1420 - Things look pretty shaky here. When things were restarted the following error was produced. Fri Sep 12 13:32:01 2003 ORA-00204: error in reading (block 1, # blocks 1) of controlfile ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl' ORA-27091: skgfqio: unable to queue I/O SVR4 Error: 6: No such device or address Additional information: 1 The raid array had not been powered on --- However Fri Sep 12 15:33:08 2003 ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl' ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or directory Additional information: 3 Fri Sep 12 15:33:11 2003 ORA-205 signalled during: alter database mount... Now the file system is available, but the file itself has disappeared. It was not corrupted, just disappeared. We duplex a copy to an internal disk. So recovery was easy. However once this was fixed Fri Sep 12 16:18:58 2003 Thread recovery: start rolling forward thread 1 Fri Sep 12 16:18:58 2003 Errors in file /opt/oracle/admin/BBRO/udump/bbro_ora_1804.trc: ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: '/u2/oradata/BBRO/redo0301.log' ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or directory Additional information: 3 ORA-313 signalled during: ALTER DATABASE OPEN... - These files are on a RAID 1 LUN. Both copies of the file are gone. Again not corrupted but gone. I don't know if using duplexing rather than RAID 1 would have mattered here, but I am changing things so that one group of redo logs is on internal disk and written via the duplexing method. Ian MacGregor Stanford linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: XDB,Context questions
Hi, have you considered free or commercial search engines to save you the effort of building the search capabilities into the database, it might be easier to meld an existing search and index into your oracle app? just a thought considering you want to concentrate on cost. 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: archive old data
Hi Nancy One way we did it three / four years ago whilst working on a finance system was to build a second archive database. The main database table in the production system held details of the financial transactions and was partitioned into 13 partitions split on months, at each month end the oldest one was exported off and removed from live and a new partition was opened for the next month. There was a requirement that archived data needed to be available but didn't need to be online, so we built a second database with just the finance transactions table with six empty partitions. All of the other tables in the live system didn't get archived as they were either look- up tables or small enough that the old data didn't impact the performance and storage from a users perspective. This helped us as the archive database then had a set of a few hundred synonyms that were links to the tables in the live system. When archived data was needed by the business it was imported to the archive partition's and users pointed the application at this database. The access times were impacted by this method but our remit on providing archived data on this legacy system was to save costs on disk space and hardware. We scripted the rollover so it happened automatically at month end. The solution was not perfect but it worked and saved disc space in not needing to replicate the whole database and not having to archive all of the data and allowed recovery of archived data quite quickly. The production database held 1.5 - 2 terabytes of data by the way mostly in the financial transactions. hth 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: I know its early since OOW is just over BUT
Title: RE: I know its early since OOW is just over BUT -Original Message-From: Adams, Matthew (GECP, MABG, 088130) [mailto:[EMAIL PROTECTED]Sent: Monday, September 15, 2003 5:17 PMTo: Multiple recipients of list ORACLE-LSubject: RE: I know its early since OOW is just over BUT As of now, I'm planning on going, but as always, that is subject to the whims of Damagement. [Shrek] i've pretty much been told that the only way i'll get to go is if: a) i present so i get the company name out in front ofpeople [well i put in but never got an acknowledgement so i'm guessing that ain't gonna happen.] b) take vacation and pay for everything myself [and i know that ain't happening.;-)] so i'll let you know later.;-) -- Bill "Shrek" Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] When asked how World War III would be fought, Einstein replied that he didn't know. But he knew how World War IV would be fought: With sticks and stones.
SQLPLUS with cronjob is giving problem
Hi List I am trying to automate Number of Oracle Connections using cronjob. $ crontab -l 0 8 * * * /export/home/oracle/scripts/dba/.Schedulejobs/xyz_conn_monitor.sh /tmp/xyz_conn_monitor.lst 21 $ cat xyz_conn_monitor.sh /u02/app/oracle/product/8.1.7/bin/sqlplus user1/[EMAIL PROTECTED] @/export/home/oracle/scripts/dba/.Schedulejobs/xyz_conn_monitor.sql $ cat xyz_conn_monitor.lst Message file sp1lang.msb not found Error 6 initializing SQL*Plus But if run /export/home/oracle/scripts/dba/.Schedulejobs/xyz_conn_monitor.sh in unix $ prompt, it is running fine. Could someone help me to resolve the same? Thanks in advance Sami __ 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: 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).
IOUG April 18-22, Toronto
I asked my manager if I can go, maybe I can present a paper. Now I just have to decide what topic to present on. I don't want to do something that is on the bleeding edge, I want to do something that would be useful to the largest number of people. I leave the marketing to Oracle Corp., they know the newer products best it seems to me. I am not a concepts person, I don't go by the product descriptions and features, I go by practical experience. (aka Trial by Fire) Right now we are still planning / testing a migration to 9iAS 9.0.2. on Windows (I know, no comments please), maybe I can do a paper on how to install, configure, secure, and manage 9iAS effectively. If you have any other suggestions, don't hesitate to mention them -- what would be most useful to you at your site? Do I ever want to go to this conference! Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice 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: Oracle Press OCP exam guide frustrations
Try out self study materials from http://www.selftestsoftware.com they are simply outstanding. I have always found them helpful for all my exams. But at same time I never totally rely on them, I first complete my ground work with standard syllabus (available on Oracle OCP site) and Oracle Documentation then only I Open them ;-). HTH, Rajesh Dayal Senior Oracle DBA (OCP 8,8i,9i) International Information Technology Company LLC -Original Message- Sent: Tuesday, September 16, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Subject:Fwd: Oracle Press OCP exam guide frustrations All, I just purchased a Oracle9i Fundamentals I exam guide published by Oracle Press and am very disappointed with the quality of the publication. There seems to be quite a few mistakes, misleading sentences and typos (not in the Errata) which is very frustrating. Also, there is a question in the Managing Tablespaces and Datafiles chapter that replies on the order of the multiple-choices, however the quiz software randomises the choices so the question no longer makes sense - and is impossible to answer as presented. For those that have completed the OCP exam, is this what I am to expect? Does anyone know of any other resources I might be able to use? How are the OCP exam guides published by Sybex? Any help would be greatly appreciated. Regards, Craig. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Munday INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: IOUG April 18-22, Toronto
Right now we are still planning / testing a migration to 9iAS 9.0.2. on Windows (I know, no comments please), maybe I can do a paper on how to install, configure, secure, and manage 9iAS effectively. Yes, a presentation type solving and avoiding problems during 9iAS R2 installation would definitely be interesting topic, since 9iAS R2 installation is anything else than simple and problem free. I'll be hopefully speaking there as well, about E-Business Suite and database topics. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Configuring RMAN
Title: Message Thanks Ruth and Belinda, That's what I'm trying to do, connect to the DB to create the catalog and register the DB. This is what I get when trying to connect to rman [EMAIL PROTECTED] oracle]$ rman rman/[EMAIL PROTECTED]rman: can't open rman/[EMAIL PROTECTED][EMAIL PROTECTED] oracle]$ TIA Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ruth GramoliniSent: Tuesday, September 16, 2003 8:54 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Configuring RMAN You have to create the catalog. Check the docs to see how to do this. In 8.1.7 I think it is simply create catalog. Then you have to register the databases you want to use this catalog for, etc. The docs are quite good. HTH, Ruth -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Ramon E. EstevezSent: Monday, September 15, 2003 7:24 PMTo: Multiple recipients of list ORACLE-LSubject: Configuring RMAN Hi list, I am implementing RMAN in an RH AS 2.1 environment on Oracle 8.1.7 and at the prompt When using rman catalog rman/[EMAIL PROTECTED] I get rman: can't open catalog I recreated the password file and the same error. TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994
RE: SQLPLUS with cronjob is giving problem
Hopefully, you've read the fine manual and, therefore, know that .profile, .kshrc and alike are not executed, so you don't have ORACLE_HOME, ORACLE_SID and alike? -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oracle DBA Sent: Tuesday, September 16, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Subject: SQLPLUS with cronjob is giving problem Hi List I am trying to automate Number of Oracle Connections using cronjob. $ crontab -l 0 8 * * * /export/home/oracle/scripts/dba/.Schedulejobs/xyz_conn_monitor.sh /tmp/xyz_conn_monitor.lst 21 $ cat xyz_conn_monitor.sh /u02/app/oracle/product/8.1.7/bin/sqlplus user1/[EMAIL PROTECTED] @/export/home/oracle/scripts/dba/.Schedulejobs/xyz_conn_monitor.sql $ cat xyz_conn_monitor.lst Message file sp1lang.msb not found Error 6 initializing SQL*Plus But if run /export/home/oracle/scripts/dba/.Schedulejobs/xyz_conn_monitor.sh in unix $ prompt, it is running fine. Could someone help me to resolve the same? Thanks in advance Sami __ 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: 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). 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: Cron question
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] on Tuesday, September 16, 2003 8:19 AM said; Hallo, anyone whom could help me with this. I am trying to use crontab -e to start a procedure. but I cant get it right. Anyone whom could help me with the command how to write if I want a program in unix to be scheduled to run every monday at 6 o´clock in the morning? I hate to be one of those annoying RTFM types but this is pretty basic stuff if you're going to be doing anything at all in Unix. This is teach-a-man-to-fish type stuff. At the command shell type the following, your answers are there. $HOST:/:# man cron brian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian Dunbar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
exporting synonyms
While exporting synonyms , export hangs. Help ? -- 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: SQLPLUS with cronjob is giving problem
Title: RE: SQLPLUS with cronjob is giving problem oops ... someone forgot to run . ./.profile in the sh file ... 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: Tuesday, September 16, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Subject: SQLPLUS with cronjob is giving problem Hi List I am trying to automate Number of Oracle Connections using cronjob. $ crontab -l 0 8 * * * /export/home/oracle/scripts/dba/.Schedulejobs/xyz_conn_monitor.sh /tmp/xyz_conn_monitor.lst 21 $ cat xyz_conn_monitor.sh /u02/app/oracle/product/8.1.7/bin/sqlplus user1/[EMAIL PROTECTED] @/export/home/oracle/scripts/dba/.Schedulejobs/xyz_conn_monitor.sql $ cat xyz_conn_monitor.lst Message file sp1lang.msb not found Error 6 initializing SQL*Plus But if run /export/home/oracle/scripts/dba/.Schedulejobs/xyz_conn_monitor.sh in unix $ prompt, it is running fine. Could someone help me to resolve the same? Thanks in advance Sami __ 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: 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). 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: how to do a variable in-list of numbers?
Ryan Will this link help you?. Let me know. http://asktom.oracle.com/pls/ask/f\?p=4950:12:5406168887273966472::NO::F4950_P12_DATE_MMDD:20010430#tag586600793569 HTH GovindanK I am catching up on the mail from the list and I think you can use dynamic sql. Something like: mysql := 'insert into tab2 select col1 from tab1 where col2 in ('; open cursor mysql := mysql || value || ','; loop substr(mysql,-1,1) := ');'; execute immediate 'mysql'; Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 29, 2003 4:31 PM I need to do an insert select of the form insert into tab2 select col1 from tab1 where col2 in (inlist of numbers); I do not know how many values will be in my inlist at runtime. With strings I just build a big string. How do I build an 'inlist' of numbers at runtime? Im using a cursor to determine which values need to be added to my inlist. I think I can do some kind of cast, but im not familiar with it. Im on 8i. I do not want to j ust run this inside my cursor. It could then execute 300-400 times and will run all day. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Message sent via Zuvio Mail Get your own FREE email account with SPAM and Antivirus protection! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Govindan K INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SQLPLUS with cronjob is giving problem
Sami, You need to set your Oracle Home inside your shell script before you run SqlPlus. Cron runs as a syetm user, not as your local Oracle user - the user you log in with. You could simple add . $HOME/.profile right before your sqlplus statement, or set your ORACLE_HOME environmental. Type ENV at the comand line to see what the Oracle environmental variables are set to. Godd Luck! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 16, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Hi List I am trying to automate Number of Oracle Connections using cronjob. $ crontab -l 0 8 * * * /export/home/oracle/scripts/dba/.Schedulejobs/xyz_conn_monitor.sh /tmp/xyz_conn_monitor.lst 21 $ cat xyz_conn_monitor.sh /u02/app/oracle/product/8.1.7/bin/sqlplus user1/[EMAIL PROTECTED] @/export/home/oracle/scripts/dba/.Schedulejobs/xyz_conn_monitor.sql $ cat xyz_conn_monitor.lst Message file sp1lang.msb not found Error 6 initializing SQL*Plus But if run /export/home/oracle/scripts/dba/.Schedulejobs/xyz_conn_monitor.sh in unix $ prompt, it is running fine. Could someone help me to resolve the same? Thanks in advance Sami __ 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: 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SQLPLUS with cronjob is giving problem
I encountered this before and it turned out that I had to add the Oracle environment variables to the shell script. It worked fine when I was already logged in because my environment variables were already set through .login or .profile. Add it to your shell script. -Original Message- Sent: Tuesday, September 16, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Hi List I am trying to automate Number of Oracle Connections using cronjob. $ crontab -l 0 8 * * * /export/home/oracle/scripts/dba/.Schedulejobs/xyz_conn_monitor.sh /tmp/xyz_conn_monitor.lst 21 $ cat xyz_conn_monitor.sh /u02/app/oracle/product/8.1.7/bin/sqlplus user1/[EMAIL PROTECTED] @/export/home/oracle/scripts/dba/.Schedulejobs/xyz_conn_monitor.sql $ cat xyz_conn_monitor.lst Message file sp1lang.msb not found Error 6 initializing SQL*Plus But if run /export/home/oracle/scripts/dba/.Schedulejobs/xyz_conn_monitor.sh in unix $ prompt, it is running fine. Could someone help me to resolve the same? Thanks in advance Sami __ 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: 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: Configuring RMAN
Probably because you need correct command argument. Try rman catalog= mailto:catalog=rman/[EMAIL PROTECTED] rman/[EMAIL PROTECTED] or rman traget= mailto:traget=rman/[EMAIL PROTECTED] rman/[EMAIL PROTECTED]
RE: Cron question
anyone whom could help me to tell what difference is between this mail and mail sent by [EMAIL PROTECTED] on Thu, 25 Apr 2002 12:46, as it can be found in the list archive. So the above mentioned message is: * Date: Thu, 25 Apr 2002 12:46:07 +0200 Subject: Cronjob Hallo, I would like to have this cronjob run only in saturday mornings at 6 am. How could I easy change this script? 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh /d31/appl/konto/log/laddabilbo.log 21 Thanks in advance Roland *** And this question was answered. -Original Message- Sent: Tuesday, September 16, 2003 4:19 PM To: Multiple recipients of list ORACLE-L Hallo, anyone whom could help me with this. I am trying to use crontab -e to start a procedure. but I cant get it right. Anyone whom could help me with the command how to write if I want a program in unix to be scheduled to run every monday at 6 oclock in the morning? Thanks in advance. Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: exporting synonyms
Define hang. What is export waiting for? -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 10:25 AM To: Multiple recipients of list ORACLE-L Subject: exporting synonyms While exporting synonyms , export hangs. Help ? -- 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). 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: Re: how to do a variable in-list of numbers?
i figured it out a while ago. thanks guys. From: Govindan K [EMAIL PROTECTED] Date: 2003/09/16 Tue AM 10:24:38 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: how to do a variable in-list of numbers? Ryan Will this link help you?. Let me know. http://asktom.oracle.com/pls/ask/f\?p=4950:12:5406168887273966472::NO::F4950_P12_DATE_MMDD:20010430#tag586600793569 HTH GovindanK I am catching up on the mail from the list and I think you can use dynamic sql. Something like: mysql := 'insert into tab2 select col1 from tab1 where col2 in ('; open cursor mysql := mysql || value || ','; loop substr(mysql,-1,1) := ');'; execute immediate 'mysql'; Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 29, 2003 4:31 PM I need to do an insert select of the form insert into tab2 select col1 from tab1 where col2 in (inlist of numbers); I do not know how many values will be in my inlist at runtime. With strings I just build a big string. How do I build an 'inlist' of numbers at runtime? Im using a cursor to determine which values need to be added to my inlist. I think I can do some kind of cast, but im not familiar with it. Im on 8i. I do not want to j ust run this inside my cursor. It could then execute 300-400 times and will run all day. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Message sent via Zuvio Mail Get your own FREE email account with SPAM and Antivirus protection! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Govindan K INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RE: Oracle Press OCP exam guide frustrations
they are not outstanding. they are ok? They are also expensive. I have found the Coriolis books to be better than the Osborne books in quality. They dont have 9i ones. you can get the 8.0/8i ones for $9/each at maryland-merchant.com Im using those myself, then the docs. I didnt like the osborne books. From: Rajesh Dayal [EMAIL PROTECTED] Date: 2003/09/16 Tue AM 10:09:24 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Oracle Press OCP exam guide frustrations Try out self study materials from http://www.selftestsoftware.com they are simply outstanding. I have always found them helpful for all my exams. But at same time I never totally rely on them, I first complete my ground work with standard syllabus (available on Oracle OCP site) and Oracle Documentation then only I Open them ;-). HTH, Rajesh Dayal Senior Oracle DBA (OCP 8,8i,9i) International Information Technology Company LLC -Original Message- Sent: Tuesday, September 16, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Subject: Fwd: Oracle Press OCP exam guide frustrations All, I just purchased a Oracle9i Fundamentals I exam guide published by Oracle Press and am very disappointed with the quality of the publication. There seems to be quite a few mistakes, misleading sentences and typos (not in the Errata) which is very frustrating. Also, there is a question in the Managing Tablespaces and Datafiles chapter that replies on the order of the multiple-choices, however the quiz software randomises the choices so the question no longer makes sense - and is impossible to answer as presented. For those that have completed the OCP exam, is this what I am to expect? Does anyone know of any other resources I might be able to use? How are the OCP exam guides published by Sybex? Any help would be greatly appreciated. Regards, Craig. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Munday INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
middle tier centric application
Whenever I talk to DB people or read DB articles/books the consensus is to use a database centric application. A person who just started recently says he has had alot of success with 'caching' in a middle tier using BEA Weblogic and limiting calls to the database. Does anyone have any experiences with this? He says that the 'beans' also make it highly portable. Just started reading Tom Kyte's new book and he says this is a big no no. However, I like to keep myself open minded to people with differing ideas and not have a total database bias. -- 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: Configuring RMAN
[EMAIL PROTECTED] Outlook. The mailto:; thingy was added by the lovely M$ product, not me. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mladen Gogala Sent: Tuesday, September 16, 2003 10:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Configuring RMAN Probably because you need correct command argument. Try rman catalog= mailto:catalog=rman/[EMAIL PROTECTED] rman/[EMAIL PROTECTED] or rman traget= mailto:traget=rman/[EMAIL PROTECTED] rman/[EMAIL PROTECTED] 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: Configuring RMAN
Title: Message You are not running the RMAN you thought you are - check your $PATH. Original Message - From: Ramon E. Estevez To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 17, 2003 2:19 AM Subject: RE: Configuring RMAN Thanks Ruth and Belinda, That's what I'm trying to do, connect to the DB to create the catalog and register the DB. This is what I get when trying to connect to rman [EMAIL PROTECTED] oracle]$ rman rman/[EMAIL PROTECTED]rman: can't open rman/[EMAIL PROTECTED][EMAIL PROTECTED] oracle]$ TIA Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ruth GramoliniSent: Tuesday, September 16, 2003 8:54 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Configuring RMAN You have to create the catalog. Check the docs to see how to do this. In 8.1.7 I think it is simply create catalog. Then you have to register the databases you want to use this catalog for, etc. The docs are quite good. HTH, Ruth -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Ramon E. EstevezSent: Monday, September 15, 2003 7:24 PMTo: Multiple recipients of list ORACLE-LSubject: Configuring RMAN Hi list, I am implementing RMAN in an RH AS 2.1 environment on Oracle 8.1.7 and at the prompt When using rman catalog rman/[EMAIL PROTECTED] I get rman: can't open catalog I recreated the password file and the same error. TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994
RE: Is Cary's new book shipping now?
Title: Message September 2003. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jamadagni, RajendraSent: Tuesday, September 16, 2003 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: Is Cary's new book shipping now? Anyone know? Hotsos says expected in 09/2003 Oreilly shows info as if it is shipping, bookpool tells me my order is still partially out of stock. Cary any ideas when it is going to be published? Thanks 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 ! 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 LLCand 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.
RE: Raid Arrays and Power Loss
For the curious, what brand/model RAID 1 are you using? Size? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED] Sent: Monday, September 15, 2003 11:34 PM To: Multiple recipients of list ORACLE-L Subject: Raid Arrays and Power Loss Last Friday was hot here, and rumor has it our 230 KV power line sagged and touched some tree branches. The local power company shut it off. Leaving our systems to depend on UPS. About 30 minutes afterwards one system produced these errors. This was jus before the system went dead snip -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
'query rewrite' system privg
Hello list , I am using oracle 9.2.0.1.0 enterprise edition on windows A user in my database is able to create materialized views with query rewrite enabled. But I have not given him 'query rewrite' system privilege. Isn't it required to create a mat. view with query rewrite enabled ? drop user test cascade; create user test identified by test default tablespace users temporary tablespace temp quota unlimited on users; grant create session, create table, create materialized view to test ; Now this user is able to create materialized view mymatview tablespace users build immediate refresh on demand enable query rewrite as select * from dual ; -- 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: Cron question
I wouldnt know since i filter any message starting with Hallo to bit bucket. :) joe Gints Plivna wrote: anyone whom could help me to tell what difference is between this mail and mail sent by [EMAIL PROTECTED] on Thu, 25 Apr 2002 12:46, as it can be found in the list archive. So the above mentioned message is: * Date: Thu, 25 Apr 2002 12:46:07 +0200 Subject: Cronjob Hallo, I would like to have this cronjob run only in saturday mornings at 6 am. How could I easy change this script? 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh /d31/appl/konto/log/laddabilbo.log 21 Thanks in advance Roland *** And this question was answered. -Original Message- Sent: Tuesday, September 16, 2003 4:19 PM To: Multiple recipients of list ORACLE-L Hallo, anyone whom could help me with this. I am trying to use crontab -e to start a procedure. but I cant get it right. Anyone whom could help me with the command how to write if I want a program in unix to be scheduled to run every monday at 6 oclock in the morning? Thanks in advance. Roland -- 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).
translate, replace...?
Hi, I have a column with carriage returns (chr(13) ) and line feeds (chr(10)). I want to select this column replacing the chr(13) with 'R' and chr(10) with ' ' . Whats the best way to do this? Regards IA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Imran Ashraf INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: I know its early since OOW is just over BUT
Bill, you submitted and didnt get an acknowledgement that it was submitted? if not, resubmit the info, you should get an email at least saying it was received(if i remember correctly), now who's paper got accepted is a few months out still. joe Thater, William wrote: -Original Message- *From:* Adams, Matthew (GECP, MABG, 088130) [mailto:[EMAIL PROTECTED] *Sent:* Monday, September 15, 2003 5:17 PM *To:* Multiple recipients of list ORACLE-L *Subject:* RE: I know its early since OOW is just over BUT As of now, I'm planning on going, but as always, that is subject to the whims of Damagement. [Shrek] i've pretty much been told that the only way i'll get to go is if: a) i present so i get the company name out in front of people [well i put in but never got an acknowledgement so i'm guessing that ain't gonna happen.] b) take vacation and pay for everything myself [and i know that ain't happening.;-)] so i'll let you know later.;-) -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] When asked how World War III would be fought, Einstein replied that he didn't know. But he knew how World War IV would be fought: With sticks and stones. -- 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).
Connect to a remote database without a link
Title: Message Does anyone have an example of connecting to a remote database without a database link? I think that I have seen it done before by putting in the username and password and tnsnamesconnection information right into the select statement. Can it be done? Tom
Is Cary's new book shipping now?
Title: Is Cary's new book shipping now? Anyone know? Hotsos says expected in 09/2003 Oreilly shows info as if it is shipping, bookpool tells me my order is still partially out of stock. Cary any ideas when it is going to be published? Thanks 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 ! 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
Fw: pct_direct_access for a secondary index on an iot
Resending , didn't seem to have reached the list the first time. Hello list, I am unable to get a value in dba_indexes(pct_direct_access) for a bitmap index I created on an iot. I am using Oracle 9.2.0.1.0 enterprise edition on windows . Can someone help me by telling me what I need to do. I have done the following : --First create the iot with a mapping table. sql create table countries ( country_id char(2) , country_name varchar2 (40) , currency_name varchar2(25), constraint country_c_id_pk primary key (country_id ) ) organization index including country_name pctthreshold 20 tablespace users overflow tablespace indx mapping table; Table created. SQL insert into HR.countries values ( 'C', 'A', NULL ) ; 1 row created. SQL insert into HR.countries values ( 'D', 'A', NULL ) ; 1 row created. SQL insert into HR.countries values ( 'E', 'A', NULL ) ; 1 row created. SQL COMMIT ; Commit complete. --Now create a bmp index on it. SQL create bitmap index myindex on countries (country_name ) ; Index created. --This command should analyze the iot and its mapping table. SQL analyze table countries compute statistics; Table analyzed. --Might as well analyze the bmp index ( this does no harm right ? ) SQL analyze index myindex compute statistics; Index analyzed. SQL select index_name, pct_direct_access from DBA_indexes where index _name = 'MYINDEX' and owner=user; INDEX_NAME PCT_DIRECT_ACCESS -- - MYINDEX --As you can see I get a null value in the pct_dircect_access column. .Thanks -- 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: Is Cary's new book shipping now?
Title: Message I believe the official publication date is 09/17. Tomorrow, Tomorrow Youre only a Day Away Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mladen Gogala Sent: Tuesday, September 16, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Subject: RE: Is Cary's new book shipping now? September 2003. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jamadagni, Rajendra Sent: Tuesday, September 16, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Subject: Is Cary's new book shipping now? Anyone know? Hotsos says expected in 09/2003 Oreilly shows info as if it is shipping, bookpool tells me my order is still partially out of stock. Cary any ideas when it is going to be published? Thanks 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 ! 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 LLCand 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.
Nosort parallel dml uses TEMP tablespace
Title: Nosort parallel dml uses TEMP tablespace Apologies if this has been covered before but metalink is not clear on the reasons behind it The database is running version 9204 EE on WinNT Sp6; and the statement is a parallel direct load into partitioned table selecting from a 12.2GB source table. ALTER SESSION ENABLE PARALLEL DML ; INSERT /*+ APPEND PARALLEL(TRANSACTION_NEW,4) */ INTO TRANSACTION_NEW (select * from TRANSACTIONS); I'm seeing segments created in the temp tablespace (from v$sort_usage) Sess# User Name TABLESPACE CONTENTS ext BLOCKS SZ_MB - - --- - -- -- 9 SYS TEMP2 TEMPORARY 1629 208512 1629 11 SYS TEMP2 TEMPORARY 1629 208512 1629 12 SYS TEMP2 TEMPORARY 1629 208512 1629 13 SYS TEMP2 TEMPORARY 1629 208512 1629 I've enough space and it'll finish by tomorrow morning which is the deadline but does anyone know why TEMP is required and what the end to end process is? I would have expected to have seen temporary segments created, but in the partitions own tablespace. It doesnt seem optimal to me. Thanks in advance for your help, Regards, Adrian
RE: middle tier centric application
Weblogic is an application server. Beans are java snippets executed by the httpd proces themselves. Beans cannot access/generate HTML. If you wand Java code do HTML, then we are talking servlets. Servlets are executed by separate processes spawned by the httpd processes (servlet engine). Servlets and beans can connect to the database using JDBC and they can do prefetch. That's as far as it goes. Force that Java guy to explain you what is it that he wants to, in English language and using classic terminology. If he can not, he doesn't know what he's doing and he's just trying to raise his own price by using incomprehensible terminology. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Subject: middle tier centric application Whenever I talk to DB people or read DB articles/books the consensus is to use a database centric application. A person who just started recently says he has had alot of success with 'caching' in a middle tier using BEA Weblogic and limiting calls to the database. Does anyone have any experiences with this? He says that the 'beans' also make it highly portable. Just started reading Tom Kyte's new book and he says this is a big no no. However, I like to keep myself open minded to people with differing ideas and not have a total database bias. -- 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). 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: 'query rewrite' system privg
My guess is that just because the Mat View is enabled for query rewrite doesn't mean that it's going to happen. The Query Rewite attribute on the Mat View probably indicates that it is eligible for rewrite. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 16, 2003 11:05 AM To: Multiple recipients of list ORACLE-L Hello list , I am using oracle 9.2.0.1.0 enterprise edition on windows A user in my database is able to create materialized views with query rewrite enabled. But I have not given him 'query rewrite' system privilege. Isn't it required to create a mat. view with query rewrite enabled ? drop user test cascade; create user test identified by test default tablespace users temporary tablespace temp quota unlimited on users; grant create session, create table, create materialized view to test ; Now this user is able to create materialized view mymatview tablespace users build immediate refresh on demand enable query rewrite as select * from dual ; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 'query rewrite' system privg
Nope. It's required to use it, not to create it. By enabling query rewrite, you enable the RDBMS to rewrite your query and use it to resolve your select, even if the view itself was not mentioned in it. You can always create material view and do select from it. Material views are snapshots with fancy names. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 11:05 AM To: Multiple recipients of list ORACLE-L Subject: 'query rewrite' system privg Hello list , I am using oracle 9.2.0.1.0 enterprise edition on windows A user in my database is able to create materialized views with query rewrite enabled. But I have not given him 'query rewrite' system privilege. Isn't it required to create a mat. view with query rewrite enabled ? drop user test cascade; create user test identified by test default tablespace users temporary tablespace temp quota unlimited on users; grant create session, create table, create materialized view to test ; Now this user is able to create materialized view mymatview tablespace users build immediate refresh on demand enable query rewrite as select * from dual ; -- 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). 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: I know its early since OOW is just over BUT
Joe Testa scribbled on the wall in glitter crayon: Bill, you submitted and didnt get an acknowledgement that it was submitted? yup. i tried 4 times with 3 different browsers and 3 different email addresses. i'll give it one more try. -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] Two things are infinite: the universe and human stupidity; and I'm not sure about the the universe. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Raid Arrays and Power Loss
Hi, what is your OS and filesystem? Regards zhu chao msn:[EMAIL PROTECTED] www.cnoug.org - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 12:34 PM Last Friday was hot here, and rumor has it our 230 KV power line sagged and touched some tree branches. The local power company shut it off. Leaving our systems to depend on UPS. About 30 minutes afterwards one system produced these errors. This was jus before the system went dead Fri Sep 12 12:58:40 2003 Errors in file /opt/oracle/admin/BBRO/bdump/bbro_ckpt_1420.trc: ORA-00206: error in writing (block 3, # blocks 1) of controlfile ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl' ORA-27063: skgfospo: number of bytes read/written is incorrect SVR4 Error: 5: I/O error Additional information: -1 Additional information: 8192 Fri Sep 12 12:58:42 2003 Errors in file /opt/oracle/admin/BBRO/bdump/bbro_ckpt_1420.trc: ORA-00221: error on write to controlfile ORA-00206: error in writing (block 3, # blocks 1) of controlfile ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl' ORA-27063: skgfospo: number of bytes read/written is incorrect SVR4 Error: 5: I/O error Additional information: -1 Additional information: 8192 Fri Sep 12 12:58:42 2003 CKPT: terminating instance due to error 221 Instance terminated by CKPT, pid = 1420 -- --- Things look pretty shaky here. When things were restarted the following error was produced. Fri Sep 12 13:32:01 2003 ORA-00204: error in reading (block 1, # blocks 1) of controlfile ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl' ORA-27091: skgfqio: unable to queue I/O SVR4 Error: 6: No such device or address Additional information: 1 The raid array had not been powered on -- - However Fri Sep 12 15:33:08 2003 ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl' ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or directory Additional information: 3 Fri Sep 12 15:33:11 2003 ORA-205 signalled during: alter database mount... Now the file system is available, but the file itself has disappeared. It was not corrupted, just disappeared. We duplex a copy to an internal disk. So recovery was easy. However once this was fixed Fri Sep 12 16:18:58 2003 Thread recovery: start rolling forward thread 1 Fri Sep 12 16:18:58 2003 Errors in file /opt/oracle/admin/BBRO/udump/bbro_ora_1804.trc: ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: '/u2/oradata/BBRO/redo0301.log' ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or directory Additional information: 3 ORA-313 signalled during: ALTER DATABASE OPEN... -- --- These files are on a RAID 1 LUN. Both copies of the file are gone. Again not corrupted but gone. I don't know if using duplexing rather than RAID 1 would have mattered here, but I am changing things so that one group of redo logs is on internal disk and written via the duplexing method. Ian MacGregor Stanford linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: zhu chao INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Connect to a remote database without a link
The COPY command does NON-dblink connect to the remote database. -Original Message- Does anyone have an example of connecting to a remote database without a database link? I think that I have seen it done before by putting in the username and password and tnsnames connection information right into the select statement. Can it be done? -- 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: middle tier centric application
I'll agree with Tom Kyte to a point. Caching database rows in the middle tier is a bad idea since you have no idea if they've been changed at the database level by another non three tier application, read that as SQL*Plus for instance. To get around these problems WebLogic it's similar variants have to query the database to see if the row in cache is the same as the row in the database (column by column) then either process the update requested by the end user or send a incomprehensible error message back. YUCK!! At a minimum this results is twice the amount of data being sent between the middle tier server and the database, how inefficient!! Now if your going to cache an entire panel as PeopleSoft calls them which are composed of several rows of data from tables that change infrequently that's not such a bad idea, although with some of the fun we've had recently with cached panels becoming corrupt I may well change my mind. BTW, Java Beans are fairly flexible and portable so he's not onto a bad idea. But as with any programming language you can easily program yourself into some very nasty corners. One should not use those containers for more than their meant to do and caching data is not one of those purposes. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, September 16, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Whenever I talk to DB people or read DB articles/books the consensus is to use a database centric application. A person who just started recently says he has had alot of success with 'caching' in a middle tier using BEA Weblogic and limiting calls to the database. Does anyone have any experiences with this? He says that the 'beans' also make it highly portable. Just started reading Tom Kyte's new book and he says this is a big no no. However, I like to keep myself open minded to people with differing ideas and not have a total database bias. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Configuring RMAN
Title: Message Just try entering rman. When you get the rman prompt just connect to the target ( which will be the previously set oracle sid. Then you can create the catalog, register the databases, etc. Ruth -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Ramon E. EstevezSent: Tuesday, September 16, 2003 10:19 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Configuring RMAN Thanks Ruth and Belinda, That's what I'm trying to do, connect to the DB to create the catalog and register the DB. This is what I get when trying to connect to rman [EMAIL PROTECTED] oracle]$ rman rman/[EMAIL PROTECTED]rman: can't open rman/[EMAIL PROTECTED][EMAIL PROTECTED] oracle]$ TIA Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ruth GramoliniSent: Tuesday, September 16, 2003 8:54 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Configuring RMAN You have to create the catalog. Check the docs to see how to do this. In 8.1.7 I think it is simply create catalog. Then you have to register the databases you want to use this catalog for, etc. The docs are quite good. HTH, Ruth -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Ramon E. EstevezSent: Monday, September 15, 2003 7:24 PMTo: Multiple recipients of list ORACLE-LSubject: Configuring RMAN Hi list, I am implementing RMAN in an RH AS 2.1 environment on Oracle 8.1.7 and at the prompt When using rman catalog rman/[EMAIL PROTECTED] I get rman: can't open catalog I recreated the password file and the same error. TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994
RE: Configuring RMAN
Title: Message $ rman target sys/password catalog rmanadmin/password RMAN create catalog RMAN register database That's all. -OR- $rman RMAN connect target sys/password RMAN connect catalog rmanadmin/password RMAN create catalog; RMAN register database; -Scott Stefick -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 9:19 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Configuring RMAN Thanks Ruth and Belinda, That's what I'm trying to do, connect to the DB to create the catalog and register the DB. This is what I get when trying to connect to rman [EMAIL PROTECTED] oracle]$ rman rman/[EMAIL PROTECTED]rman: can't open rman/[EMAIL PROTECTED][EMAIL PROTECTED] oracle]$ TIA Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ruth GramoliniSent: Tuesday, September 16, 2003 8:54 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Configuring RMAN You have to create the catalog. Check the docs to see how to do this. In 8.1.7 I think it is simply create catalog. Then you have to register the databases you want to use this catalog for, etc. The docs are quite good. HTH, Ruth -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Ramon E. EstevezSent: Monday, September 15, 2003 7:24 PMTo: Multiple recipients of list ORACLE-LSubject: Configuring RMAN Hi list, I am implementing RMAN in an RH AS 2.1 environment on Oracle 8.1.7 and at the prompt When using rman catalog rman/[EMAIL PROTECTED] I get rman: can't open catalog I recreated the password file and the same error. TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994
RE: Configuring RMAN
Title: Meddelande Try this instead: $ORACLE_HOME/bin/rman rman/[EMAIL PROTECTED] If you don't use $ORACLE_HOME/bin it finds another "rman" that exists in the O/S. Med vänliga hälsningar/ Kind regards -- Veriba AB Per Berghäll Brigadgatan 10 581 31 Linköping Tele: +46 (0)13-362600 Fax: +46 (0)13-362625 mailto:[EMAIL PROTECTED] http://www.veriba.se -- -Ursprungligt meddelande-Från: Ramon E. Estevez [mailto:[EMAIL PROTECTED] Skickat: den 16 september 2003 16:19Till: Multiple recipients of list ORACLE-LÄmne: RE: Configuring RMAN Thanks Ruth and Belinda, That's what I'm trying to do, connect to the DB to create the catalog and register the DB. This is what I get when trying to connect to rman [EMAIL PROTECTED] oracle]$ rman rman/[EMAIL PROTECTED]rman: can't open rman/[EMAIL PROTECTED][EMAIL PROTECTED] oracle]$ TIA Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ruth GramoliniSent: Tuesday, September 16, 2003 8:54 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Configuring RMAN You have to create the catalog. Check the docs to see how to do this. In 8.1.7 I think it is simply create catalog. Then you have to register the databases you want to use this catalog for, etc. The docs are quite good. HTH, Ruth -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Ramon E. EstevezSent: Monday, September 15, 2003 7:24 PMTo: Multiple recipients of list ORACLE-LSubject: Configuring RMAN Hi list, I am implementing RMAN in an RH AS 2.1 environment on Oracle 8.1.7 and at the prompt When using rman catalog rman/[EMAIL PROTECTED] I get rman: can't open catalog I recreated the password file and the same error. TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994
RE: Connect to a remote database without a link
Title: Message You can always use sqlplus copy command to bring back some data without a db link. 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] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Terrian, Tom (Contractor) (DAASC)Sent: Tuesday, September 16, 2003 11:15 AMTo: Multiple recipients of list ORACLE-LSubject: Connect to a remote database without a link Does anyone have an example of connecting to a remote database without a database link? I think that I have seen it done before by putting in the username and password and tnsnamesconnection information right into the select statement. Can it be done? Tom
RE: Is Cary's new book shipping now?
Title: Is Cary's new book shipping now? Raj, The book will be in the OReilly warehouses tomorrow (9/17), presumably outbound to stores on the same or next day. Id expect preorders to arrive at customers homes on or near this weekend. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic101 in Sydney - Hotsos Symposium 2004 March 710 Dallas - Visit www.hotsos.com for schedule details... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jamadagni, Rajendra Sent: Tuesday, September 16, 2003 9:44 AM To: Multiple recipients of list ORACLE-L Subject: Is Cary's new book shipping now? Anyone know? Hotsos says expected in 09/2003 Oreilly shows info as if it is shipping, bookpool tells me my order is still partially out of stock. Cary any ideas when it is going to be published? Thanks 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 !
Re: Configuring RMAN
only on some OS, like linux. joe Per Berghäll wrote: Try this instead: $ORACLE_HOME/bin/rman rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] If you don't use $ORACLE_HOME/bin it finds another rman that exists in the O/S. Med vänliga hälsningar/ Kind regards -- *Veriba AB* Per Berghäll Brigadgatan 10 581 31 Linköping Tele: +46 (0)13-362600 Fax: +46 (0)13-362625 mailto:[EMAIL PROTECTED] _http://www.veriba.se_ http://www.veriba.se/ -- -Ursprungligt meddelande- *Från:* Ramon E. Estevez [mailto:[EMAIL PROTECTED] *Skickat:* den 16 september 2003 16:19 *Till:* Multiple recipients of list ORACLE-L *Ämne:* RE: Configuring RMAN Thanks Ruth and Belinda, That's what I'm trying to do, connect to the DB to create the catalog and register the DB. This is what I get when trying to connect to rman [EMAIL PROTECTED] oracle]$ rman rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] rman: can't open rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] [EMAIL PROTECTED] oracle]$ TIA *Ramon E. Estevez* [EMAIL PROTECTED] 809-535-8994 -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Ruth Gramolini *Sent:* Tuesday, September 16, 2003 8:54 AM *To:* Multiple recipients of list ORACLE-L *Subject:* RE: Configuring RMAN You have to create the catalog. Check the docs to see how to do this. In 8.1.7 I think it is simply create catalog. Then you have to register the databases you want to use this catalog for, etc. The docs are quite good. HTH, Ruth -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of* Ramon E. Estevez *Sent:* Monday, September 15, 2003 7:24 PM *To:* Multiple recipients of list ORACLE-L *Subject:* Configuring RMAN Hi list, I am implementing RMAN in an RH AS 2.1 environment on Oracle 8.1.7 and at the prompt When using rman catalog rman/[EMAIL PROTECTED] I get rman: can't open catalog I recreated the password file and the same error. TIA, *Ramon E. Estevez* [EMAIL PROTECTED] 809-535-8994 -- 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: IOUG April 18-22, Toronto
Everyone: Speaking as a Focus Area Manager, we are missing the following types of presentations: 1. Presentations for beginners, i.e.: the basics - too many of our presenters concentrate on the intermediate or advanced. Let me tell you that we WANT to see more beginner presentations. 2. Troubleshooting type presentations helping users diagnose both performance and development problems. 3. REAL Advanced presentations and not ones that you think are advanced. Comments returned over the past few years indicate that the advanced' presentations are not as advanced as stated. 4. Tighter quality sessions that offer concrete technical value and ROI for our audience. Should be enough Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, September 16, 2003 9:50 AM To: Multiple recipients of list ORACLE-L Subject:IOUG April 18-22, Toronto I asked my manager if I can go, maybe I can present a paper. Now I just have to decide what topic to present on. I don't want to do something that is on the bleeding edge, I want to do something that would be useful to the largest number of people. I leave the marketing to Oracle Corp., they know the newer products best it seems to me. I am not a concepts person, I don't go by the product descriptions and features, I go by practical experience. (aka Trial by Fire) Right now we are still planning / testing a migration to 9iAS 9.0.2. on Windows (I know, no comments please), maybe I can do a paper on how to install, configure, secure, and manage 9iAS effectively. If you have any other suggestions, don't hesitate to mention them -- what would be most useful to you at your site? Do I ever want to go to this conference! Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice 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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-600
Title: Message This is on an old 7.3.4 database. I can't find the same error on Metalink. Anybody have any ideas what might be the cause? ORA-00600: internal error code, arguments: [17114], [1074346728], [], [], [], [], [], [] Ron Smith
Embaded transactions
Hi Listers, I have two transactions one embedded into another. The inner transaction have commit. Is it possible to rollback all (the inner and the outer) transaction if the outer one fail? Thank you for your help, Kader __ 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: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Embedded transactions
Title: RE: Embedded transactions no. 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: Kader Ben [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 16, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Subject: Embaded transactions Hi Listers, I have two transactions one embedded into another. The inner transaction have commit. Is it possible to rollback all (the inner and the outer) transaction if the outer one fail? Thank you for your help, Kader __ 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: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Unix- How to remove the first few lines(N) in a file without
Lets not forget about the vernerable ed... # # strip of the header of the input file # ed $data_filename EOF 1,5d w q EOF # Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] ail.ee To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Re: Unix- How to remove the first few lines(N) in a file without .com 09/16/2003 05:54 AM Please respond to ORACLE-L (reposting) Afaik, vi can run in non-interactive, batch mode too. But I'd go with tail +6 Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, September 14, 2003 10:49 PM Mladen ,I want to automate this thing. So don't want to go with :1,5d stuff --- Mladen Gogala [EMAIL PROTECTED] wrote: The best thing to do would be something like: vi filename :1,5d :x! That would do the trick. Also this: * #!/usr/bin/perl -w use strict my $ind=1; open FILE1,/file1/path||die Cannot open file1:$!\n; open FILE2,/file2/path||die Cannot open file2:$!\n; # Skip 5 lines for($ind=1;$ind=5;$ind++) { FILE1; } # copy files while (FILE1) { print FILE2 $_; } print I'm all done\n; On 2003.09.14 12:14, Tim Gorman wrote: sed '6,$p' filename new-filename on 9/14/03 7:49 AM, Oracle DBA at [EMAIL PROTECTED] wrote: Hi List, I want to remove the first 5 lines of the text from unix text file. Is there a command to do it without opening a file manually? (I don't want to use (DD command) For example, == 1 to be removed 2 to be removed 3 to be removed 4 to be removed 5 to be removed a s == Any help would be really appreciated. TIA Sami __ 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: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
Re: ORA-600
Doc ID: Note:34782.1 Subject: ORA-600 [17114] KGH Bad magic number in header Type: REFERENCE Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 29-FEB-1996 Last Revision Date: 29-OCT-2002 Note: For additional ORA-600 related information please read [NOTE:146580.1] PURPOSE: This article discusses the internal error ORA-600 [17114], what it means and possible actions. The information here is only applicable to the versions listed and is provided only for guidance. ERROR: ORA-600 [17114][a][b][c][d][e] VERSIONS: versions 7.X to 8.X DESCRIPTION: Oracle has detected that the magic number in a memory chunk header has been overwritten. This is a heap (in memory) corruption and there is no underlying data corruption. The error may occur in the one of the process specific heaps (the Call heap, PGA heap, or session heap) or in the shared heap (SGA). FUNCTIONALITY: HEAP MANAGEMENT IMPACT: PROCESS FAILURE MEMORY CORRUPTION, POSSIBLE INSTANCE FAILURE NON DATA CORRUPTIVE - No underlying data corruption. SUGGESTIONS: If you think you are not hitting any of the known issues shown below, then you need to set event 10235 in your init.ora file :- event=10235 trace name context forever, level 1 While the event is set, the next time you get the error a trace file will be generated in your USER_DUMP_DEST directory. Contact Oracle Support Services and supply the trace file. Known Issues: Bug 898074: PRIVATE MEM CORR ON PARTITION TABLE NON-PARTITION-KEY PREDICATE fixed in 8.0.6.1 and 8.1.6.0 releases Bug 573746: -- DBMS_SQL DEFINE_ARRAY / ARRAY FETCH TO LARGE ARRAY MAY CAUSE ORA-600[17114] fixed in 8.0.4.4, 8.0.5.0 and 8.1.5.0 releases Bug 1280983: ORA-600 [17114]/ORA-600 [17112] USING STAR_TRANSFORMATION fixed in 8.1.7.0 Hemant At 08:14 AM 16-09-03 -0800, you wrote: This is on an old 7.3.4 database. I can't find the same error on Metalink. Anybody have any ideas what might be the cause? ORA-00600: internal error code, arguments: [17114], [1074346728], [], [], [], [], [], [] Ron Smith Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Configuring RMAN
Ramon E. Estevez scribbled on the wall in glitter crayon: Tks Joe and Per But the same results Red Hat Linux Advanced Server release 2.1AS/i686 (Pensacola) login: oracle Password: DELL-installed Red Hat Linux Mon Aug 25 09:59:40 CDT 2003 Profile ejecutado [EMAIL PROTECTED] oracle]$ cd $ORACLE_HOME/bin [EMAIL PROTECTED] bin]$ export ORACLE_SID=BDRP [EMAIL PROTECTED] bin]$ rman [EMAIL PROTECTED] bin]$ rman rman/[EMAIL PROTECTED] rman: can't open rman/[EMAIL PROTECTED] [EMAIL PROTECTED] bin]$ Please any help would be appreciated. is the rman database on this box? what about the target? is the listener for this box configured to access both? if another box is involved, is the listener there configured to see the other database? -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] Reality is merely an illusion, albeit a very persistent one. - - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Configuring RMAN
Hi! cd'ing to a directory doesn't help in unix unless directory . in PATH is before /usr/bin or whereever the redhat linux rman is located. Type which rman in your prompt and you'll see which rman is being used. You have to run $ORACLE_HOME/bin/rman if you want to get right rman. Or modify your path variable to have $ORACLE_HOME/bin before other linux bin directories (btw, I wouldn't do that, I believe system bin dirs should always be first in path) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 7:34 PM Tks Joe and Per But the same results Red Hat Linux Advanced Server release 2.1AS/i686 (Pensacola) login: oracle Password: DELL-installed Red Hat Linux Mon Aug 25 09:59:40 CDT 2003 Profile ejecutado [EMAIL PROTECTED] oracle]$ cd $ORACLE_HOME/bin [EMAIL PROTECTED] bin]$ export ORACLE_SID=BDRP [EMAIL PROTECTED] bin]$ rman [EMAIL PROTECTED] bin]$ rman rman/[EMAIL PROTECTED] rman: can't open rman/[EMAIL PROTECTED] [EMAIL PROTECTED] bin]$ Please any help would be appreciated. Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Joe Testa Sent: Tuesday, September 16, 2003 12:05 PM To: Multiple recipients of list ORACLE-L only on some OS, like linux. joe Per Berghäll wrote: Try this instead: $ORACLE_HOME/bin/rman rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] If you don't use $ORACLE_HOME/bin it finds another rman that exists in the O/S. Med vänliga hälsningar/ Kind regards -- *Veriba AB* Per Berghäll Brigadgatan 10 581 31 Linköping Tele: +46 (0)13-362600 Fax: +46 (0)13-362625 mailto:[EMAIL PROTECTED] _http://www.veriba.se_ http://www.veriba.se/ -- -Ursprungligt meddelande- *Från:* Ramon E. Estevez [mailto:[EMAIL PROTECTED] *Skickat:* den 16 september 2003 16:19 *Till:* Multiple recipients of list ORACLE-L *Ämne:* RE: Configuring RMAN Thanks Ruth and Belinda, That's what I'm trying to do, connect to the DB to create the catalog and register the DB. This is what I get when trying to connect to rman [EMAIL PROTECTED] oracle]$ rman rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] rman: can't open rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] [EMAIL PROTECTED] oracle]$ TIA *Ramon E. Estevez* [EMAIL PROTECTED] 809-535-8994 -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Ruth Gramolini *Sent:* Tuesday, September 16, 2003 8:54 AM *To:* Multiple recipients of list ORACLE-L *Subject:* RE: Configuring RMAN You have to create the catalog. Check the docs to see how to do this. In 8.1.7 I think it is simply create catalog. Then you have to register the databases you want to use this catalog for, etc. The docs are quite good. HTH, Ruth -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of* Ramon E. Estevez *Sent:* Monday, September 15, 2003 7:24 PM *To:* Multiple recipients of list ORACLE-L *Subject:* Configuring RMAN Hi list, I am implementing RMAN in an RH AS 2.1 environment on Oracle 8.1.7 and at the prompt When using rman catalog rman/[EMAIL PROTECTED] I get rman: can't open catalog I recreated the password file and the same error. TIA, *Ramon E. Estevez* [EMAIL PROTECTED] 809-535-8994 -- 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: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list,
RE: Configuring RMAN
Type which rman. If the answer is /usr/X11R6/bin/rman then you're not dealing with oracle utility, but the lovely thing described below. There is also a utility called spam, which serves to prepare spam, spam, egg, bacon and spam. PolyglotMan(1) PolyglotMan(1) NAME PolyglotMan, rman - reverse compile man pages from format- ted form to a number of source formats SYNOPSIS rman [ options ] [ file ] DESCRIPTION PolyglotMan takes man pages from most of the popular fla- vors of UNIX and transforms them into any of a number of text source formats. PolyglotMan was formerly known as RosettaMan. The name of the binary is still called rman , for scripts that depend on that name; mnemonically, just think reverse man. Previously PolyglotMan required pages to be formatted by nroff prior to its processing. With version 3.0, it prefers [tn]roff source and usually produces results that are better yet. And source process- ing is the only way to translate tables. Source format translation is not as mature as formatted, however, so try formatted translation as a backup. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ramon E. Estevez Sent: Tuesday, September 16, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Configuring RMAN Tks Joe and Per But the same results Red Hat Linux Advanced Server release 2.1AS/i686 (Pensacola) login: oracle Password: DELL-installed Red Hat Linux Mon Aug 25 09:59:40 CDT 2003 Profile ejecutado [EMAIL PROTECTED] oracle]$ cd $ORACLE_HOME/bin [EMAIL PROTECTED] bin]$ export ORACLE_SID=BDRP [EMAIL PROTECTED] bin]$ rman [EMAIL PROTECTED] bin]$ rman rman/[EMAIL PROTECTED] rman: can't open rman/[EMAIL PROTECTED] [EMAIL PROTECTED] bin]$ Please any help would be appreciated. Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Joe Testa Sent: Tuesday, September 16, 2003 12:05 PM To: Multiple recipients of list ORACLE-L only on some OS, like linux. joe Per Berghäll wrote: Try this instead: $ORACLE_HOME/bin/rman rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] If you don't use $ORACLE_HOME/bin it finds another rman that exists in the O/S. Med vänliga hälsningar/ Kind regards -- *Veriba AB* Per Berghäll Brigadgatan 10 581 31 Linköping Tele: +46 (0)13-362600 Fax: +46 (0)13-362625 mailto:[EMAIL PROTECTED] _http://www.veriba.se_ http://www.veriba.se/ -- -Ursprungligt meddelande- *Från:* Ramon E. Estevez [mailto:[EMAIL PROTECTED] *Skickat:* den 16 september 2003 16:19 *Till:* Multiple recipients of list ORACLE-L *Ämne:* RE: Configuring RMAN Thanks Ruth and Belinda, That's what I'm trying to do, connect to the DB to create the catalog and register the DB. This is what I get when trying to connect to rman [EMAIL PROTECTED] oracle]$ rman rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] rman: can't open rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] [EMAIL PROTECTED] oracle]$ TIA *Ramon E. Estevez* [EMAIL PROTECTED] 809-535-8994 -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Ruth Gramolini *Sent:* Tuesday, September 16, 2003 8:54 AM *To:* Multiple recipients of list ORACLE-L *Subject:* RE: Configuring RMAN You have to create the catalog. Check the docs to see how to do this. In 8.1.7 I think it is simply create catalog. Then you have to register the databases you want to use this catalog for, etc. The docs are quite good. HTH, Ruth -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of* Ramon E. Estevez *Sent:* Monday, September 15, 2003 7:24 PM *To:* Multiple recipients of list ORACLE-L *Subject:* Configuring RMAN Hi list, I am implementing RMAN in an RH AS 2.1 environment on Oracle 8.1.7 and at the prompt When using rman catalog rman/[EMAIL PROTECTED] I get rman: can't open catalog I recreated the password file and the same error. TIA, *Ramon E. Estevez* [EMAIL PROTECTED] 809-535-8994 -- Please see the official ORACLE-L FAQ:
RE: Embedded transactions
Title: Message Sure there is, remove the inner commit and commit them both together. The fact that you want to roll back the inner one dependant on the state of completion of the outer one indicates that what you have is really one transaction that has been mistakenly divided into two. Allan -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 11:30 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Embedded transactions no. 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: Kader Ben [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 16, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Subject: Embaded transactions Hi Listers, I have two transactions one embedded into another. The inner transaction have commit. Is it possible to rollback all (the inner and the outer) transaction if the outer one fail? Thank you for your help, Kader __ 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: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]
Re: RE: Embedded transactions
if you need to 'rollback' everything, then you should make it one transaction. You can add savepoints and rollback to: if you want to limit it that way. commit means complete. You should not commit unless you are sure you may not want to rollback. why are you committing in the inner transaction? From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/09/16 Tue PM 12:29:39 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Embedded transactions no. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Tuesday, September 16, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Hi Listers, I have two transactions one embedded into another. The inner transaction have commit. Is it possible to rollback all (the inner and the outer) transaction if the outer one fail? Thank you for your help, Kader __ 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: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Title: RE: Embedded transactions no. 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: Kader Ben [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 16, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Subject: Embaded transactions Hi Listers, I have two transactions one embedded into another. The inner transaction have commit. Is it possible to rollback all (the inner and the outer) transaction if the outer one fail? Thank you for your help, Kader __ 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: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Connect to a remote database without a link
Deprecated? Already? That sure didn't last long. As far as what data types, I think it is whatever you can grab with a select statement. If you have long datatype, you need to do a set long 12345 (or whatever) other stuff to set are set arraysize 100 (or whatever) set copycommit 1000 (or whatever) I like the command. It seems to do a decent job of hauling over sizable chunks of data. -Original Message- From: Pete Finnigan [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 11:45 AM To: Multiple recipients of list ORACLE-L Subject: Re: Connect to a remote database without a link Hi Stephen, The COPY command is a SQL*Plus command and allows SQL*Plus to act as a pipe for want of a better description between two databases to copy data. It is deprecated as far as I know? and i don't think it handles some of the newer data types. I think the OP meant from within SQL rather than SQL*Plus. kind regards Pete In article [EMAIL PROTECTED], Stephen Lee [EMAIL PROTECTED] writes The COPY command does NON-dblink connect to the remote database. -Original Message- -- 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: 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: RAC Parallel Query Issues
Thanks Mogens, It works great with no parallelism set. But when parallelism is set to DEFAULT it fails (intermittently). The tables are imported from a Non-Rac production environment. Found a note on Metalink last night which says DEFAULT is calculated as : CPU_COUNT*PARALLEL_THREADS_PER_CPU and DOP is DEFAULT * INSTANCES. The DOP it was using was 48 (6 cpus*4 thr/cpu*2 instances) This is the same setting in Production(infact with more cpus and hence larger DOP) but has been running fine. I guess the issue is magnified due to slaves being spawned at the other node and the QC sync'ing with them. I see huge number 'IPC send completion sync' events during this time. I had to alter degree from 'Default' to 2 for some tables and disable parallelism to smaller lookup tables to get it working. These went unnoticed in a single instance box. Thanks, Ravi. --- Mogens_Nørgaard [EMAIL PROTECTED] wrote: I'm not sure I understand. Is this a query that should access a 470 record table and which uses Parallel Query in a RAC environment? And when it works, it executes in less than a second? If yes, have you tested this query without Parallel Query? If no, where did I misunderstand you? Best regards, Mogens Ravi Kulkarni wrote: We are on 2-Node Rac 9204/Solaris8. We are having intermittent issues with parallel queries (The table has only 470 records, executes 1sec otherwise): SQL / select count(*)from eod * ERROR at line 1: ORA-12805: parallel query server died unexpectedly Trace File has: kxfp_send_callback Send timed out to slave 65535 inst 1 (qref 0x63f85fd0) *** 2003-09-15 18:33:25.034 *** SESSION ID:(63.533) 2003-09-15 18:33:25.034 kxfp_send_callback Send timed out to slave 65535 inst 1 (qref 0x63fc2004) kxfplsig Could not signal error 10388 in server P032 with serial 371201 dp 0x61a822d0, q 0x60f286b0, pr 0x5f457168, cqr 0x63f97584, err 10387 Interrupt Info top=1 size=8 top err=-2147473260 Query May be hanging.Check V$PX_SESSION OPIRIP: Uncaught error 12800. Error stack: ORA-12800: system appears too busy for parallel query execution ORA-10387: parallel query server interrupt (normal) v$px_session : has number of Slave Processes hanging. Truss for process on Instance 1: door_return(0x, 0, 0x, 0) (sleeping...) lwp_cond_wait(0xFE7F5548, 0xFE7F5558, 0xFE7EEDB0) (sleeping...) lwp_cond_wait(0xFE7F5548, 0xFE7F5558, 0xFE7EEDB0) Err#62 ETIME read(0, 0xFE6C35E4, 1024) (sleeping...) signotifywait() (sleeping...) door_return(0x, 0, 0x, 0) (sleeping...) lwp_cond_wait(0xFE7F5548, 0xFE7F5558, 0xFE7EEDB0) (sleeping...) Instance 2: poll(0x02FF15CC, 2, 2500) (sleeping...) poll(0x02FF15CC, 2, 2500) = 0 poll(0x02FF15CC, 2, 0) = 0 poll(0x02FF15CC, 2, 2500) (sleeping...) poll(0x02FF15CC, 2, 2500) = 0 poll(0x02FF15CC, 2, 0) = 0 poll(0x02FF15CC, 2, 2500) (sleeping...) poll(0x02FF15CC, 2, 2500) = 0 Any inputs would be greatly appreciated. Thanks, Ravi. __ 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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ravi Kulkarni INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Configuring RMAN
Tks Joe and Per But the same results Red Hat Linux Advanced Server release 2.1AS/i686 (Pensacola) login: oracle Password: DELL-installed Red Hat Linux Mon Aug 25 09:59:40 CDT 2003 Profile ejecutado [EMAIL PROTECTED] oracle]$ cd $ORACLE_HOME/bin [EMAIL PROTECTED] bin]$ export ORACLE_SID=BDRP [EMAIL PROTECTED] bin]$ rman [EMAIL PROTECTED] bin]$ rman rman/[EMAIL PROTECTED] rman: can't open rman/[EMAIL PROTECTED] [EMAIL PROTECTED] bin]$ Please any help would be appreciated. Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Joe Testa Sent: Tuesday, September 16, 2003 12:05 PM To: Multiple recipients of list ORACLE-L only on some OS, like linux. joe Per Berghäll wrote: Try this instead: $ORACLE_HOME/bin/rman rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] If you don't use $ORACLE_HOME/bin it finds another rman that exists in the O/S. Med vänliga hälsningar/ Kind regards -- *Veriba AB* Per Berghäll Brigadgatan 10 581 31 Linköping Tele: +46 (0)13-362600 Fax: +46 (0)13-362625 mailto:[EMAIL PROTECTED] _http://www.veriba.se_ http://www.veriba.se/ -- -Ursprungligt meddelande- *Från:* Ramon E. Estevez [mailto:[EMAIL PROTECTED] *Skickat:* den 16 september 2003 16:19 *Till:* Multiple recipients of list ORACLE-L *Ämne:* RE: Configuring RMAN Thanks Ruth and Belinda, That's what I'm trying to do, connect to the DB to create the catalog and register the DB. This is what I get when trying to connect to rman [EMAIL PROTECTED] oracle]$ rman rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] rman: can't open rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] [EMAIL PROTECTED] oracle]$ TIA *Ramon E. Estevez* [EMAIL PROTECTED] 809-535-8994 -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Ruth Gramolini *Sent:* Tuesday, September 16, 2003 8:54 AM *To:* Multiple recipients of list ORACLE-L *Subject:* RE: Configuring RMAN You have to create the catalog. Check the docs to see how to do this. In 8.1.7 I think it is simply create catalog. Then you have to register the databases you want to use this catalog for, etc. The docs are quite good. HTH, Ruth -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of* Ramon E. Estevez *Sent:* Monday, September 15, 2003 7:24 PM *To:* Multiple recipients of list ORACLE-L *Subject:* Configuring RMAN Hi list, I am implementing RMAN in an RH AS 2.1 environment on Oracle 8.1.7 and at the prompt When using rman catalog rman/[EMAIL PROTECTED] I get rman: can't open catalog I recreated the password file and the same error. TIA, *Ramon E. Estevez* [EMAIL PROTECTED] 809-535-8994 -- 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: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Configuring RMAN
Thanks Mladen, But the same result --- -- --- - -- 1 BDRP LOBO 8.1.7.4.0 01-SEP-03 OPENNO 1 STARTED ALLOWEDNO ACTIVEPRIMARY_INSTANCE 1 row selected. SVRMGR exit Server Manager complete. [EMAIL PROTECTED] oracle]$ rman catalog=rman/[EMAIL PROTECTED] rman: can't open catalog=rman/[EMAIL PROTECTED] [EMAIL PROTECTED] oracle]$ rman target=rman/[EMAIL PROTECTED] rman: can't open target=rman/[EMAIL PROTECTED] [EMAIL PROTECTED] oracle]$ sqlplus rman/[EMAIL PROTECTED] SQL*Plus: Release 8.1.7.0.0 - Production on Tue Sep 16 10:42:15 2003 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option JServer Release 8.1.7.4.0 - Production SQL Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Mladen Gogala Sent: Tuesday, September 16, 2003 10:45 AM To: Multiple recipients of list ORACLE-L Probably because you need correct command argument. Try rman catalog= mailto:catalog=rman/[EMAIL PROTECTED] rman/[EMAIL PROTECTED] or rman traget= mailto:traget=rman/[EMAIL PROTECTED] rman/[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Connect to a remote database without a link
Hi Stephen, The COPY command is a SQL*Plus command and allows SQL*Plus to act as a pipe for want of a better description between two databases to copy data. It is deprecated as far as I know? and i don't think it handles some of the newer data types. I think the OP meant from within SQL rather than SQL*Plus. kind regards Pete In article [EMAIL PROTECTED], Stephen Lee [EMAIL PROTECTED] writes The COPY command does NON-dblink connect to the remote database. -Original Message- -- 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: Is Cary's new book shipping now?
Title: Message Aw, man, now that stupid Annie song is gonna be running through my head for the rest of the day. Thanks a lot, Brian. --Walt Weaver Bozeman, Montana -Original Message- From: Brian McGraw [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 9:20 AM To: Multiple recipients of list ORACLE-L Subject: RE: Is Cary's new book shipping now? I believe the official publication date is 09/17. Tomorrow, Tomorrow Youre only a Day Away Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mladen Gogala Sent: Tuesday, September 16, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Subject: RE: Is Cary's new book shipping now? September 2003. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jamadagni, Rajendra Sent: Tuesday, September 16, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Subject: Is Cary's new book shipping now? Anyone know? Hotsos says expected in 09/2003 Oreilly shows info as if it is shipping, bookpool tells me my order is still partially out of stock. Cary any ideas when it is going to be published? Thanks 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 ! 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 LLCand 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.
RE: Configuring RMAN
Title: RE: Configuring RMAN Try it without the equal sign: $ rman catalog rman/[EMAIL PROTECTED] RMAN create catalog; -Scott Stefick -Original Message- From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 16, 2003 10:50 AM To: Multiple recipients of list ORACLE-L Subject: RE: Configuring RMAN Thanks Mladen, But the same result --- -- --- - -- 1 BDRP LOBO 8.1.7.4.0 01-SEP-03 OPEN NO 1 STARTED ALLOWED NO ACTIVE PRIMARY_INSTANCE 1 row selected. SVRMGR exit Server Manager complete. [EMAIL PROTECTED] oracle]$ rman catalog=rman/[EMAIL PROTECTED] rman: can't open catalog=rman/[EMAIL PROTECTED] [EMAIL PROTECTED] oracle]$ rman target=rman/[EMAIL PROTECTED] rman: can't open target=rman/[EMAIL PROTECTED] [EMAIL PROTECTED] oracle]$ sqlplus rman/[EMAIL PROTECTED] SQL*Plus: Release 8.1.7.0.0 - Production on Tue Sep 16 10:42:15 2003 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option JServer Release 8.1.7.4.0 - Production SQL Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Mladen Gogala Sent: Tuesday, September 16, 2003 10:45 AM To: Multiple recipients of list ORACLE-L Probably because you need correct command argument. Try rman catalog= mailto:catalog=rman/[EMAIL PROTECTED] rman/[EMAIL PROTECTED] or rman traget= mailto:traget=rman/[EMAIL PROTECTED] rman/[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [SPAM:#] Re: Raid Arrays and Power Loss
The OS is Solaris 5.8. The file systems is Veritas. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 16, 2003 8:25 AM To: Multiple recipients of list ORACLE-L Hi, what is your OS and filesystem? Regards zhu chao msn:[EMAIL PROTECTED] www.cnoug.org - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 12:34 PM Last Friday was hot here, and rumor has it our 230 KV power line sagged and touched some tree branches. The local power company shut it off. Leaving our systems to depend on UPS. About 30 minutes afterwards one system produced these errors. This was jus before the system went dead Fri Sep 12 12:58:40 2003 Errors in file /opt/oracle/admin/BBRO/bdump/bbro_ckpt_1420.trc: ORA-00206: error in writing (block 3, # blocks 1) of controlfile ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl' ORA-27063: skgfospo: number of bytes read/written is incorrect SVR4 Error: 5: I/O error Additional information: -1 Additional information: 8192 Fri Sep 12 12:58:42 2003 Errors in file /opt/oracle/admin/BBRO/bdump/bbro_ckpt_1420.trc: ORA-00221: error on write to controlfile ORA-00206: error in writing (block 3, # blocks 1) of controlfile ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl' ORA-27063: skgfospo: number of bytes read/written is incorrect SVR4 Error: 5: I/O error Additional information: -1 Additional information: 8192 Fri Sep 12 12:58:42 2003 CKPT: terminating instance due to error 221 Instance terminated by CKPT, pid = 1420 -- --- Things look pretty shaky here. When things were restarted the following error was produced. Fri Sep 12 13:32:01 2003 ORA-00204: error in reading (block 1, # blocks 1) of controlfile ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl' ORA-27091: skgfqio: unable to queue I/O SVR4 Error: 6: No such device or address Additional information: 1 The raid array had not been powered on -- - However Fri Sep 12 15:33:08 2003 ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl' ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or directory Additional information: 3 Fri Sep 12 15:33:11 2003 ORA-205 signalled during: alter database mount... Now the file system is available, but the file itself has disappeared. It was not corrupted, just disappeared. We duplex a copy to an internal disk. So recovery was easy. However once this was fixed Fri Sep 12 16:18:58 2003 Thread recovery: start rolling forward thread 1 Fri Sep 12 16:18:58 2003 Errors in file /opt/oracle/admin/BBRO/udump/bbro_ora_1804.trc: ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: '/u2/oradata/BBRO/redo0301.log' ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or directory Additional information: 3 ORA-313 signalled during: ALTER DATABASE OPEN... -- --- These files are on a RAID 1 LUN. Both copies of the file are gone. Again not corrupted but gone. I don't know if using duplexing rather than RAID 1 would have mattered here, but I am changing things so that one group of redo logs is on internal disk and written via the duplexing method. Ian MacGregor Stanford linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: zhu chao INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
restriction on the number of columns in select statement.
Can someone tell me the restriction on the # of columns in the select clause of the statement.. We are running into sort key too long - ORA-01467. I am told there is no order by or group by in the query. I need to look @ the query to make sure there are no references in the statement that generates a implicit sort. I tried to search on the restriction and could not comeup with anything. Thanks for your help Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Cary's new book shipping now?
Preordered: Qty 1 :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Tuesday, September 16, 2003 11:05 AM To: Multiple recipients of list ORACLE-L Raj, The book will be in the O'Reilly warehouses tomorrow (9/17), presumably outbound to stores on the same or next day. I'd expect preorders to arrive at customers' homes on or near this weekend. Cary Millsap Hotsos Enterprises, Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-600
Title: Message http://tinyurl.com/njtq 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: Smith, Ron L. [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 16, 2003 12:15 PMTo: Multiple recipients of list ORACLE-LSubject: ORA-600 This is on an old 7.3.4 database. I can't find the same error on Metalink. Anybody have any ideas what might be the cause? ORA-00600: internal error code, arguments: [17114], [1074346728], [], [], [], [], [], [] Ron Smith 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: RE: Is Cary's new book shipping now?
the big question is when will the .pdf be available for download on kazaa? (Im kidding and Im buying a copy). From: Jesse, Rich [EMAIL PROTECTED] Date: 2003/09/16 Tue PM 01:44:35 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Is Cary's new book shipping now? Preordered: Qty 1 :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Tuesday, September 16, 2003 11:05 AM To: Multiple recipients of list ORACLE-L Raj, The book will be in the O'Reilly warehouses tomorrow (9/17), presumably outbound to stores on the same or next day. I'd expect preorders to arrive at customers' homes on or near this weekend. Cary Millsap Hotsos Enterprises, Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: restriction on the number of columns in select statement.
Title: RE: restriction on the number of columns in select statement. it means total length of column sizes in group/order by cannot exceed your block size. See http://tinyurl.com/nk93 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: Murali_Pavuloori/[EMAIL PROTECTED] [mailto:Murali_Pavuloori/[EMAIL PROTECTED]] Sent: Tuesday, September 16, 2003 1:30 PM To: Multiple recipients of list ORACLE-L Subject: restriction on the number of columns in select statement. Can someone tell me the restriction on the # of columns in the select clause of the statement.. We are running into sort key too long - ORA-01467. I am told there is no order by or group by in the query. I need to look @ the query to make sure there are no references in the statement that generates a implicit sort. I tried to search on the restriction and could not comeup with anything. Thanks for your help Murali. 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
backup problem
All - I am implementing RMAN on my unix boxes. The dbs are already in archivelog mode for about a year. The system admin was backing up the files from cold backups. Today we realize the backups are no good. The tape is unreadable. Most of the archived logs (.arc) files have been removed from the system. Now I have no way to put them back! How can I set rman to start backing up from today forward? Hoping to get a good backup and dependable from rman. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: LeRoy Kemnitz INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Session Stat interpretation - total runtime
I believe that a number of threads have already discussed how to equate the total runtime of a given session to its individual stats as shown in v$sesstat, but I could not find on my collection of threads relating to this subject. The stats below shows that the individual session stat is more than the total runtime. I calculated session stat using the wait events (1268 secs) + CPU used by this session (182141/100) = 3089 secs, whereas the total runtime is only 2622 secs (sysdate - logon_time). Could somebody help in accounting for the discrepancy? Appreciate any input on this. DB SESSION EVENTS REPORT == SessionStat IDST# Name VALUE === === 3112 CPU used by this session 182141 3111 CPU used when call started 182141 3190 CR blocks created 318 31 238 SQL*Net roundtrips to/from client 2168273 31 177 active txn count during cleanout 12876 31 197 branch node splits 20 31 223 buffer is not pinned count 3240239 31 222 buffer is pinned count 2172655 31 237 bytes received via SQL*Net from client 106496601 31 236 bytes sent via SQL*Net to client 353672034 31 110 calls to get snapshot scn: kcmgss 1955374 31 107 calls to kcmgas 7836 31 105 calls to kcmgcs 6384 3171 change write time 2694 31 178 cleanout - number of ktugct calls 31196 31 165 cleanouts only - consistent read gets 1638 31 193 cluster key scan block gets 636 31 192 cluster key scans 318 3181 commit cleanout failures: block lost 2704 3184 commit cleanout failures: buffer being written 8 3185 commit cleanout failures: callback failure 2 3186 commit cleanouts 103823 3187 commit cleanouts successfully completed 101109 31 176 commit txn count during cleanout 25135 3144 consistent changes 318 3141 consistent gets 8913902 31 102 consistent gets - examination 6640509 31 207 cursor authentications 13 31 163 data blocks consistent reads - undo records applied 318 3143 db block changes 3610861 3140 db block gets 4591125 31 175 deferred (CURRENT) block cleanout applications 88288 3176 dirty buffers inspected 9386 3126 enqueue conversions 122 3127 enqueue releases 12117 3125 enqueue requests 12117 31 235 execute count 1939464 3179 free buffer inspected 9386 3175 free buffer requested 711023 3178 hot buffers moved to head of LRU 29338 31 174 immediate (CR) block cleanout applications 1638 31 173 immediate (CURRENT) block cleanout applications 18011 31 203 index fetch by key 1971817 31 204 index scans kdiixs1 235827 31 196 leaf node 90-10 splits 3234 31 195 leaf node splits 6992 31 0 logons cumulative 1 31 1 logons current 1 3117 messages sent 6363 31 164 no work - consistent read gets 2027606 31 2 opened cursors cumulative 733 31 3 opened cursors current 10 31 233 parse count (hard) 13 31 232 parse count (total) 1103 31 230 parse time cpu 18 31 231 parse time elapsed 20 3142 physical reads 662867 3195 prefetched blocks 320225 3196 prefetched blocks aged out before use 1227 3114 process last non-idle time 1063669608 31 7 recursive calls 8236 31 8 recursive cpu usage 112 31 116 redo buffer allocation retries 14 31 114 redo entries 1808956 31 122 redo log space requests 14 31 123 redo log space wait time 36 31 115 redo size 623135736 3173 redo synch time 276 3172 redo synch writes 138 31 171 rollback changes - undo records applied 29 31 166 rollbacks only - consistent read gets 318 31 194 rows fetched via callback 792660 3113 session connect time 1063669608 31 9 session logical reads 13505027 3120 session pga memory 41565776 3121 session pga memory max 41565776 3115 session uga memory 38816520 3116 session uga memory max 38816520 31 103 shared hash latch upgrades - no wait 848093 31 242 sorts (memory) 123 31 244 sorts (rows) 36156497 31 190 table fetch by rowid 2103679 31 189 table scan blocks gotten 368716 31 188 table scan rows gotten 32838820 31 184 table scans (long tables) 118 31 183 table scans (short tables) 8 31 172 transaction rollbacks 15 31 6 user calls 2168275 31 4 user commits 123 31 227 workarea executions - optimal 244 31 226 workarea memory allocated 37534 3193 write clones
Re: RE: Embedded transactions
Thanks guys for your inputs, I just want include a procedure (which include commit) into my package testing. Have nice a day, Kader --- [EMAIL PROTECTED] wrote: if you need to 'rollback' everything, then you should make it one transaction. You can add savepoints and rollback to: if you want to limit it that way. commit means complete. You should not commit unless you are sure you may not want to rollback. why are you committing in the inner transaction? From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/09/16 Tue PM 12:29:39 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Embedded transactions no. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Tuesday, September 16, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Hi Listers, I have two transactions one embedded into another. The inner transaction have commit. Is it possible to rollback all (the inner and the outer) transaction if the outer one fail? Thank you for your help, Kader __ 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: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Embedded transactions no. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Tuesday, September 16, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Hi Listers, I have two transactions one embedded into another. The inner transaction have commit. Is it possible to rollback all (the inner and the outer) transaction if the outer one fail? Thank you for your help, Kader __ 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: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Cary's new book shipping now?
The stupid song fixer: http://load.pquinn.com/binaries/fries/ It's @#%!$*( Flash, but there's a link to an MP3 remix at the bottom of the page. Enjoy! Christmas is coming! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Tuesday, September 16, 2003 12:25 PM To: Multiple recipients of list ORACLE-L Aw, man, now that stupid Annie song is gonna be running through my head for the rest of the day. Thanks a lot, Brian. --Walt Weaver Bozeman, Montana -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Is Cary's new book shipping now?
Will there be an MP3 version, with Cary singing? -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 1:55 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Is Cary's new book shipping now? the big question is when will the .pdf be available for download on kazaa? (Im kidding and Im buying a copy). From: Jesse, Rich [EMAIL PROTECTED] Date: 2003/09/16 Tue PM 01:44:35 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Is Cary's new book shipping now? Preordered: Qty 1 :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Tuesday, September 16, 2003 11:05 AM To: Multiple recipients of list ORACLE-L Raj, The book will be in the O'Reilly warehouses tomorrow (9/17), presumably outbound to stores on the same or next day. I'd expect preorders to arrive at customers' homes on or near this weekend. Cary Millsap Hotsos Enterprises, Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). 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: backup problem
go to the bookstore and pick up rman book by robert freeman, thats a good start. joe PS: i just went thru this weekend with some co-horts, restoring database with loss of all controlfiles and rman repository, excellent learning experience(glad i did it on my laptop about 6 months ago). LeRoy Kemnitz wrote: All - I am implementing RMAN on my unix boxes. The dbs are already in archivelog mode for about a year. The system admin was backing up the files from cold backups. Today we realize the backups are no good. The tape is unreadable. Most of the archived logs (.arc) files have been removed from the system. Now I have no way to put them back! How can I set rman to start backing up from today forward? Hoping to get a good backup and dependable from rman. TIA -- 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).
[Fwd: backup problem]
Woop! Dumb question. Never mind. Original Message Date: Tue, 16 Sep 2003 12:02:54 -0500 To: ORACLE-L ORACLE-L [EMAIL PROTECTED] All - I am implementing RMAN on my unix boxes. The dbs are already in archivelog mode for about a year. The system admin was backing up the files from cold backups. Today we realize the backups are no good. The tape is unreadable. Most of the archived logs (.arc) files have been removed from the system. Now I have no way to put them back! How can I set rman to start backing up from today forward? Hoping to get a good backup and dependable from rman. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: LeRoy Kemnitz INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Raid Arrays and Power Loss
Okay, core questions: -as someone asked, what's the make/model of storage? -has your raid array lost its config? In other words, is the storage there, just with an empty vtoc/volume table/partition table (insert your particular OS nomenclature) -Is the filesystem good, just empty? When you say the file is gone, is the /u1 directory empty, or is the filesystem structure there, just that file is gone? Okay, I just saw your message that shows its solaris 8 + veritas. Here's what probably happened. The box was powered on without the RAID array powered on and consequently veritas doesn't see the disk groups/volumes that are on the RAID array. Have you tried doing (as root): vxconfigd -km enable This will cause a rescan of the existing volume groups. Afterwards, what does a vxprint -hrt look like? In general, power loss to a RAID array will not produce the results you describe - I think its far more likely that a system-array interaction is preventing proper access to your storage. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MacGregor, Ian A. Sent: Tuesday, September 16, 2003 12:34 AM To: Multiple recipients of list ORACLE-L Subject: Raid Arrays and Power Loss Last Friday was hot here, and rumor has it our 230 KV power line sagged and touched some tree branches. The local power company shut it off. Leaving our systems to depend on UPS. About 30 minutes afterwards one system produced these errors. This was jus before the system went dead Fri Sep 12 12:58:40 2003 Errors in file /opt/oracle/admin/BBRO/bdump/bbro_ckpt_1420.trc: ORA-00206: error in writing (block 3, # blocks 1) of controlfile ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl' ORA-27063: skgfospo: number of bytes read/written is incorrect SVR4 Error: 5: I/O error Additional information: -1 Additional information: 8192 Fri Sep 12 12:58:42 2003 Errors in file /opt/oracle/admin/BBRO/bdump/bbro_ckpt_1420.trc: ORA-00221: error on write to controlfile ORA-00206: error in writing (block 3, # blocks 1) of controlfile ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl' ORA-27063: skgfospo: number of bytes read/written is incorrect SVR4 Error: 5: I/O error Additional information: -1 Additional information: 8192 Fri Sep 12 12:58:42 2003 CKPT: terminating instance due to error 221 Instance terminated by CKPT, pid = 1420 -- --- Things look pretty shaky here. When things were restarted the following error was produced. Fri Sep 12 13:32:01 2003 ORA-00204: error in reading (block 1, # blocks 1) of controlfile ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl' ORA-27091: skgfqio: unable to queue I/O SVR4 Error: 6: No such device or address Additional information: 1 The raid array had not been powered on -- - However Fri Sep 12 15:33:08 2003 ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl' ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or directory Additional information: 3 Fri Sep 12 15:33:11 2003 ORA-205 signalled during: alter database mount... Now the file system is available, but the file itself has disappeared. It was not corrupted, just disappeared. We duplex a copy to an internal disk. So recovery was easy. However once this was fixed Fri Sep 12 16:18:58 2003 Thread recovery: start rolling forward thread 1 Fri Sep 12 16:18:58 2003 Errors in file /opt/oracle/admin/BBRO/udump/bbro_ora_1804.trc: ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: '/u2/oradata/BBRO/redo0301.log' ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or directory Additional information: 3 ORA-313 signalled during: ALTER DATABASE OPEN... -- --- These files are on a RAID 1 LUN. Both copies of the file are gone. Again not corrupted but gone. I don't know if using duplexing rather than RAID 1 would have mattered here, but I am changing things so that one group of redo logs is on internal disk and written via the duplexing method. Ian MacGregor Stanford linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself
Re: Configuring RMAN
your path could still be pointing elsewhere first and not the current directory. $ORACLE_HOME/bin/rman joe Ramon E. Estevez wrote: Tks Joe and Per But the same results Red Hat Linux Advanced Server release 2.1AS/i686 (Pensacola) login: oracle Password: DELL-installed Red Hat Linux Mon Aug 25 09:59:40 CDT 2003 Profile ejecutado [EMAIL PROTECTED] oracle]$ cd $ORACLE_HOME/bin [EMAIL PROTECTED] bin]$ export ORACLE_SID=BDRP [EMAIL PROTECTED] bin]$ rman [EMAIL PROTECTED] bin]$ rman rman/[EMAIL PROTECTED] rman: can't open rman/[EMAIL PROTECTED] [EMAIL PROTECTED] bin]$ Please any help would be appreciated. Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Joe Testa Sent: Tuesday, September 16, 2003 12:05 PM To: Multiple recipients of list ORACLE-L only on some OS, like linux. joe Per Berghäll wrote: Try this instead: $ORACLE_HOME/bin/rman rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] If you don't use $ORACLE_HOME/bin it finds another rman that exists in the O/S. Med vänliga hälsningar/ Kind regards -- *Veriba AB* Per Berghäll Brigadgatan 10 581 31 Linköping Tele: +46 (0)13-362600 Fax: +46 (0)13-362625 mailto:[EMAIL PROTECTED] _http://www.veriba.se_ http://www.veriba.se/ -- -Ursprungligt meddelande- *Från:* Ramon E. Estevez [mailto:[EMAIL PROTECTED] *Skickat:* den 16 september 2003 16:19 *Till:* Multiple recipients of list ORACLE-L *Ämne:* RE: Configuring RMAN Thanks Ruth and Belinda, That's what I'm trying to do, connect to the DB to create the catalog and register the DB. This is what I get when trying to connect to rman [EMAIL PROTECTED] oracle]$ rman rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] rman: can't open rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] [EMAIL PROTECTED] oracle]$ TIA *Ramon E. Estevez* [EMAIL PROTECTED] 809-535-8994 -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Ruth Gramolini *Sent:* Tuesday, September 16, 2003 8:54 AM *To:* Multiple recipients of list ORACLE-L *Subject:* RE: Configuring RMAN You have to create the catalog. Check the docs to see how to do this. In 8.1.7 I think it is simply create catalog. Then you have to register the databases you want to use this catalog for, etc. The docs are quite good. HTH, Ruth -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of* Ramon E. Estevez *Sent:* Monday, September 15, 2003 7:24 PM *To:* Multiple recipients of list ORACLE-L *Subject:* Configuring RMAN Hi list, I am implementing RMAN in an RH AS 2.1 environment on Oracle 8.1.7 and at the prompt When using rman catalog rman/[EMAIL PROTECTED] I get rman: can't open catalog I recreated the password file and the same error. TIA, *Ramon E. Estevez* [EMAIL PROTECTED] 809-535-8994 -- 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).