Re: 10g
Correct. You can follow his announcement on www.Oracle.com at 2PM PDT. Babette Turner-Underwood wrote: Yes, but then all the listers who have been DYING to fill us in, will be allowed to finally spill their guts, no? - Babette -Original Message- Mogens Norgaard Sent: Monday, September 08, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Yes, Larry will announce it tomorrow. The software will not be available to customers for a while, though. Boivin, Patrice J wrote: The release date and the shipping dates may be different, not sure. They also may not have it ready for all platforms at the same time, see OCS Release 2, there still is no version for Windows. Patrice. -Original Message- Sent: Saturday, September 06, 2003 3:44 PM To: Multiple recipients of list ORACLE-L I keep reading all the marketing material on 10g, is Tuesday the release date? (Larry Ellison Enabling the Grid -- The Power of 10 The Launch of Oracle's Next Version Database keynote) Thanks in advance, Jay -- 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). -- 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).
RE: Re: Oracle Masters exam
So, what was your reason for taking the OCM exam Tanel? Mark -Original Message- Tanel Poder Sent: 08 September 2003 22:10 To: Multiple recipients of list ORACLE-L About 50 I believe. But there are probably more DBAs in the world who don't give a damn about this (or any other) certification, because they're good and known without it anyway. Most of OCMs are currently from States, only few in Europe. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 08, 2003 11:39 PM Too many. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, September 08, 2003 3:40 PM To: Multiple recipients of list ORACLE-L Subject: Re: Re: Oracle Masters exam how many ocms are there world wide? Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). --- Incoming 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 --- 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: EM To Go
Apart from when you are on the move (to/from work), or sat at home in the evening, or at the pub, or shopping, or sat in Hooters.. How about when you're lay in bed on a Sunday morning (we've had customers fix problems in exactly this situation!)? Monitors are great - we sell one! - and IMHO should be used alongside PocketDBA, but you never can tell when you're going to get a spurious error message and will have to investigate. The point behind the PDA tools is not to have a gimmicky little hand held, or to constantly be in a reactive mode - the point is to be able to fix a problem from anywhere, at any time, within a minimum response time. Within true 24x7 environments I believe that you SHOULD be able to do this - or potentially start losing money from downtime when you can't get to your laptop. Unless of course you want to sit inside by a PC and a land line constantly whilst you are on call.. DBAs have lives too.. ;) PocketDBA is not just about adding a datafile or a user either, it can be used as a full diagnostics tool too. Perhaps you should take a look at it before judging it - there's an online demo here: http://demo.xb.com/xba/app.. BTW Dick, the latest version is a LOT better when viewed through a standard desktop sized browser as well now. It's now not only a PDA tool, but is context sensitive to desktop, PDA, laptop or tablet browsers. So you can use at work as well if wish, or even on your laptop. I'll get off my high horse now ;) Mark -Original Message- Binley Lim Sent: 08 September 2003 21:49 To: Multiple recipients of list ORACLE-L Good, you have a much lesser need for a vendor-grown monitoring PDA-tool to address problems, reactively, on the fly then. That was my point and I'm glad you agree ;-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 8:14 AM Binley, I've spent more time than I care to remember in reactive mode. It stinks, which is most likely why I wrote my own database monitor 10 years ago. At least when it sees a problem it's 4 or more hours into the future before the end users know it's going to happen. And at that, 70% of the time that homegrown monitor fixes the issue on it's own. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, September 08, 2003 3:09 PM To: Multiple recipients of list ORACLE-L NAW, Sounds like someone else needs to get a real production support job. Production issues ALL fall into one bucket, I needed to do something 10 minutes ago. If you think like that, jokingly or otherwise, you are likely to lock yourself into reactive mode versus proactive mode. I leave you to interpret that how you like. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- Incoming 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system
Re: Database Link
Hamid, Did you create the database link from the 9i database to the 8i database? One database does not know about the other database links. Ron [EMAIL PROTECTED] 09/08/03 05:39PM Dear List, I have two database one on 8.1.7.4 on sun Solaris 8.2 and another one on oracle 9.0.1(two separate box) I have created a database link under oracle 8 to oracle 9 database it's working fine from 8 to 9, but when I try to use this link from 9 to 8 it's failed to ORA-12154. Any idea what could be this?? Thanks allot for your help. Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-03113 on using create_stored_outlines
Hello list I need your help with a problem I am having whenever I start using outlines. I am using Oracle 9.2.0.1.0 enterprise edition on windows . Suppose two users scott and hr have select any table, create any outline privileges and select_catalog_role. SQL conn scott/[EMAIL PROTECTED] Connected. SQL select count (*) from scott.emp ; COUNT(*) -- 6 SQL conn hr/[EMAIL PROTECTED] Connected. SQL alter session set create_stored_outlines=hr; Session altered. SQL select count (*) from scott.emp ; COUNT(*) -- 6 SQL create table test as select * from scott.emp ; create table test as select * from scott.emp * ERROR at line 1: ORA-03113: end-of-file on communication channel (And I get a core dump file ) The same thing happens irrespective of the category name I use in alter session set create_stored_outlines , even when i specify alter session set create_stored_outlines=default;, and even when I use random values. But when I do the following then no problems : SQL conn hr/[EMAIL PROTECTED] Connected. SQL alter session set create_stored_outlines=false; Session altered. SQL create table test as select * from scott.emp ; Table created. Any ideas ? -- 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).
Resynchronizing the stored outline definition
Hello list , I am using Oracle 9.2.0.1.0 Enterprise edition on windows. I get an error while trying to resynchronze a private outline after I have edited it. I get this error when I use the identity statement SQL create private outline test from private test ; create private outline test from private test * ERROR at line 1: ORA-18004: outline already exists However the following succeeds : SQL exec dbms_outln_edit.refresh_private_outline ('TEST' ) ; PL/SQL procedure successfully completed. Any ideas why the identitiy statement fails ? ... -- 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: alter system reset
You are correct arup The parameter originally existed as *.parameter=value After running alter system set parameter=value sid='lahiri' ; it now exists as lahiri.parameter=value So either I specify the sid name while setting the parameters or I should use the following to reset the parameters alter system reset parameter sid='*' ; Thanks - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 20:29 ALTER SYSTEM RESET applies to RACs only and you need to give the SID parameter. When you said I find that shared_pool_size exists there, did it exist as the follwoing? *.shared_pool_size=... I bet it did. Note how you used the SID in setting the value alter system set shared_pool_size=40M scope=spfile sid='lahiri' ; This properly set the value for the SID lahiri, not globally. That is why the RESET operation was successful after the SET operation. The same is true for any other parameters that is reset. HTH. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 3:29 AM Yes , opened up spfile in a text editor and undo_suppress_errors exists. But I get the error , no matter which parameter I try to reset. ex: undo_management, undo_tablespace, undo_retention, pga_aggregate_target, workarea_size_policy, shared_pool_size, sort...etc, etc However when I open the spfile I find that shared_pool_size exists there , then I try resetting it (just to test it out) SQL alter system reset shared_pool_size scope=spfile sid='lahiri' ; alter system reset shared_pool_size scope=spfile sid='lahiri' * ERROR at line 1: ORA-32010: cannot find entry to delete in SPFILE SQL alter system set shared_pool_size=40M scope=spfile sid='lahiri' ; System altered. SQL alter system reset shared_pool_size scope=spfile sid='lahiri' ; System altered. Why does this happen ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 00:44 Does the entry even exist in the SPFILE? Open up the spfile in notepad and check the existence of the parameter in there. Do the following: SQL alter system set undo_suppress_errors = false scope=spfile sid='ananda'; System altered. SQL ALTER SYSTEM RESET undo_suppress_errors scope=spfile sid='ananda'; System altered. HTH. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 01, 2003 2:14 PM Hello list I am using Oracle 9.2.0.1.0 enterprise on windows. When I run the following ( connected as sysdba , and using an spfile called %oracle_home%\database\spfilelahiri.ora ) SQL show user USER is SYS SQL host echo %oracle_sid% LAHIRI SQL sho parameter db_name NAME TYPE VALUE db_namestring lahiri SQL ALTER SYSTEM RESET undo_suppress_errors SCOPE=BOTH SID='lahiri'; ALTER SYSTEM RESET undo_suppress_errors SCOPE=BOTH SID='lahiri' * ERROR at line 1: ORA-32010: cannot find entry to delete in SPFILE Any ideas ? I get the same problem irrespective of the parameter I try to reset. .. -- 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: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: Resynchronizing the stored outline definition
Hello list , I am using Oracle 9.2.0.1.0 Enterprise edition on windows. I get an error while trying to resynchronze a private outline after I have edited it. I get this error when I use the identity statement SQL create private outline test from private test ; create private outline test from private test * ERROR at line 1: ORA-18004: outline already exists However the following succeeds : SQL exec dbms_outln_edit.refresh_private_outline ('TEST' ) ; PL/SQL procedure successfully completed. Any ideas why the identitiy statement fails ? Might it be because the outline already exists ? 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).
RE: EM To Go
Mark Leith scribbled on the wall in glitter crayon: land line constantly whilst you are on call.. DBAs have lives too.. ;) OK, how come nobody ever told me i was allowed to have a life? and where the web site to order one?;-) -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] Sorry no quote today. Visit QLiner.com. -- 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).
Oracle and Perl
Can anyone tell me how to pick up the $ORACLE_SID or $ORACLE_HOME from within a Perl script? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: Oracle 9iOAS install help needed
Hi All, I am trying to install Oracle 9iAS on Win 2000 I installed Infra structure successfully. While trying to install next component OAS with BI/Forms I get a message Existing Oracle9iOAS Single Sign-On. Enter hostname and port number of existing Single Sign-On. Heck I do not know if it installed. I assume it is since infrastructure is installed. Obviously I am a first timer in OAS. I have about 300 pages of documentation but I can find nothing to troubleshoot. Does anyone have any experience they can share or URL's. Thanks Rick -- 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: Weird ORA-00060 (deadlock) with pragma autonomous
What version are you on??? There is a bug in 9.2.0.3, I was getting this error regularly on my rman repository db when an rman resync was run. I've patched to 9.2.0.4 and the error has gone away. ...JIM... [EMAIL PROTECTED] 9/8/03 11:09:27 PM We are getting a strange deadlock problem and I am having trouble understanding the cause and action. Metalink has not been too useful for this one. We have a procedure eg INS_REC that does an insert into table ABC. The procedure uses a pragma autonomous transaction. We have a package eg DO_SET_OF_WORK that selects from several tables and then based on the information selected will call the above procedure, along with several other procedures that will do inserts or deletes (on DIFFERENT tables). The package does opens a cursor to process all records selected. When we use pragma autonomous transaction AND commit in the procedure called, the package dies with an ORA-0060. When the pragma autonomous transaction is removed from the procedure, the package does not get a deadlock. There is only ONE user using this set of tables (in a separate schema from other users on the system) at the time this is occuring. I am puzzled. Another DBA suggested this may be related to FREELISTS, so I increased them for both the table and indexes that were being reported as deadlocking but it did not make any difference. Anyone have any other suggestions ? Thanks Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 send an email from unix command line?
Hi List I tried the following stuff but it says Service Unavailable. $mail -s Test Subject [EMAIL PROTECTED] body line1 body line2 Ctrl-D What should i do to make email stuff work? 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).
AW: Oracle and Perl
Hi, Ron my $ORA_SID = $ENV{'ORACLE_SID'} my ORAC_HOME = $ENV{'ORACLE_HOME'} should siffice ;) HTH. Milen -Ursprüngliche Nachricht- Von: Smith, Ron L. [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 9. September 2003 15:39 An: Multiple recipients of list ORACLE-L Betreff: Oracle and Perl Can anyone tell me how to pick up the $ORACLE_SID or $ORACLE_HOME from within a Perl script? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: question on spfile and pfile
Title: RE: question on spfile and pfile Create pfile='/path/initSID.ora' from Spfile='/path/spfileSID.ora'; Change initSID.ora Delete old spfile Create spfile='/path/spfileSID.ora' from Pfile='/path/initSID.ora'; All Done Scott Stefick MILPDS OCP Oracle DBA [EMAIL PROTECTED] 210-565-2540 -Original Message- From: CHEN,JIN [mailto:[EMAIL PROTECTED]] Sent: Monday, September 08, 2003 6:14 PM To: Multiple recipients of list ORACLE-L Subject: question on spfile and pfile Hi there, I found my SPFILE and PFILE are pointing to the same one that is spfileSID.ora. Now, I want to multiplex control file and books tell me to change in initSID.ora. I wonder how can create a initSID.ora from SPFILE. I knew there is one in $ORACLE_BASE/admin/SID/pfile when I created database. But I might change some parameters by alter database ... or alter system ..., like changing to ARCHIVELOG and multiplexing redo log. I am not sure if current spfile is different from that initSID.ora. Please help! thanks, Jin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: CHEN,JIN INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 and Perl
$ENV{ORACLE_HOME}, $ENV{ORACLE_SID} -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Smith, Ron L. Sent: Tuesday, September 09, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Subject: Oracle and Perl Can anyone tell me how to pick up the $ORACLE_SID or $ORACLE_HOME from within a Perl script? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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: Oracle 9iOAS install help needed
There is a ports.ini file somewhere in the infra and middle Oracle homes, they would tell you what port to use. Patrice. -Original Message- Sent: Tuesday, September 09, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Hi All, I am trying to install Oracle 9iAS on Win 2000 I installed Infra structure successfully. While trying to install next component OAS with BI/Forms I get a message Existing Oracle9iOAS Single Sign-On. Enter hostname and port number of existing Single Sign-On. Heck I do not know if it installed. I assume it is since infrastructure is installed. Obviously I am a first timer in OAS. I have about 300 pages of documentation but I can find nothing to troubleshoot. Does anyone have any experience they can share or URL's. Thanks Rick -- 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: 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: How to send an email from unix command line?
is sendmail running? $HOST:/ps -ef | grep mail root 250 1 0 Aug 24 ?0:00 /usr/lib/sendmail -bd -q15m root 2358 2295 0 08:18:42 pts/10:00 grep mail man mail or pester your admin if all else fails. For example we disable sendmail unless it's required. ~brian -Original Message- Sent: Tuesday, September 09, 2003 9:04 AM To: Multiple recipients of list ORACLE-L Hi List I tried the following stuff but it says Service Unavailable. $mail -s Test Subject [EMAIL PROTECTED] body line1 body line2 Ctrl-D What should i do to make email stuff work? 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: 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).
RE: How to send an email from unix command line?
Have you tried mailx? That's what we use here. Scott Canaan ([EMAIL PROTECTED]) -Original Message- Sent: Tuesday, September 09, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Hi List I tried the following stuff but it says Service Unavailable. $mail -s Test Subject [EMAIL PROTECTED] body line1 body line2 Ctrl-D What should i do to make email stuff work? 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: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 10g
Sweet! Oracle's Kumar likens ADDM to 'a genie in your database-if you have a performance problem, you just ask the database what the problem is and it automatically analyzes the complete database system and comes up with recommendations.' sarcasmNo more SQL tuning! No more STATSPACK! No more OEM/DBMS jobs! Wait a minute...no more DBA? Uh-oh./sarcasm I'm sorry Dave. I can't close the pod bay instance. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 2:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: 10g Correct. You can follow his announcement on www.Oracle.com at 2PM PDT. -- 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).
Documents in or outside the database.
Hi listers, We are working on a project that will have documents as attachments. The developers want to store the documents outside the database on the application server. I want to store the documents inside the database for recovery purposes. Is there a white paper or document that has performance information for blob/clob storage and retrievaldatabase performance information? TIA M. Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software
RE: 10g
You're up to 3 wishes and then it will crash ... I wonder if you have to rub the server or the disk box to get the genie ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Jesse, Rich Sent: Tuesday, September 09, 2003 10:35 AM To: Multiple recipients of list ORACLE-L Sweet! Oracle's Kumar likens ADDM to 'a genie in your database-if you have a performance problem, you just ask the database what the problem is and it automatically analyzes the complete database system and comes up with recommendations.' sarcasmNo more SQL tuning! No more STATSPACK! No more OEM/DBMS jobs! Wait a minute...no more DBA? Uh-oh./sarcasm I'm sorry Dave. I can't close the pod bay instance. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 2:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: 10g Correct. You can follow his announcement on www.Oracle.com at 2PM PDT. -- 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: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: offshoring article
Let's see if I have this straight, the US is nearly a half trillion dollars in debt. It is going to add at least another 87 billion to that number. It has just reduced taxes on its citizens. And, now it is good for the country to send its best paying jobs overseas. Looks to me like the US is determined to become a third world country at warp speed. Can't blame anyone overseas since the decisions are made in the US. --- Mogens_Nørgaard [EMAIL PROTECTED] wrote: They're hired by the people who came out of those very same universities. Most often McKinsey et al are hired to OK decisions that management have a hard time OK'ing themselves for various reasons. To be fair, of all the consulting companies that make money out of telling people that water runs downhill, McKinsey are among the very best. Ryan wrote: Here is a link to an article from McKinsey Co. My favorite positive is that offshoring IT jobs frees Americans up to do other jobs. Now they dont say 'what' jobs, but we are free to do them. If you dont know these are the guys who payed Chelsea Clinton 100k/year right out of college with no experience. If you explore their website they are more interested in where you went to school than anything else(notice how university comes before experience). who hires these guys? http://www.mckinsey.com/knowledge/mgi/offshore/ -- 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). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ 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: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to send an email from unix command line?
Is it not echo message body 1 | mailx -s Test Subject [EMAIL PROTECTED] Fraser Talbot M-I LLC Database Administrator Information Technology 832.295.2245 [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 09, 2003 9:04 AM To: Multiple recipients of list ORACLE-L Hi List I tried the following stuff but it says Service Unavailable. $mail -s Test Subject [EMAIL PROTECTED] body line1 body line2 Ctrl-D What should i do to make email stuff work? 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 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] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Talbot, Fraser INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 10g
Well... We've tried the Oracle Expert on 8i... Hopefully it works better in the newer versions. I also noticed that in 9i they dropped intelligent from the name Oracle Intelligent Agent. You always need someone to take responsibility for administering the databases. Patrice. -Original Message- Sent: Tuesday, September 09, 2003 11:35 AM To: Multiple recipients of list ORACLE-L Sweet! Oracle's Kumar likens ADDM to 'a genie in your database-if you have a performance problem, you just ask the database what the problem is and it automatically analyzes the complete database system and comes up with recommendations.' sarcasmNo more SQL tuning! No more STATSPACK! No more OEM/DBMS jobs! Wait a minute...no more DBA? Uh-oh./sarcasm I'm sorry Dave. I can't close the pod bay instance. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 2:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: 10g Correct. You can follow his announcement on www.Oracle.com at 2PM PDT. -- 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: 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).
Jobs and OEM... how to
Hi to everybody!! I would like to create a job that EXPort my database, but... I *do not* want to use OEM. OEM uses tcl and the intelligent agent to schedule its jobs... how can I create a job that can export my database? (no problem if I have to program with tcl files) Any ideas? any sample (would be better :-) TIA JL __ 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: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to send an email from unix command line?
mailx -s Test Subject [EMAIL PROTECTED] __EOF__ body line1 body line2 __EOF__ ..I couldn't find mailx on Linux, so use mail there... on 9/9/03 7:59 AM, Talbot, Fraser at [EMAIL PROTECTED] wrote: Is it not echo message body 1 | mailx -s Test Subject [EMAIL PROTECTED] Fraser Talbot M-I LLC Database Administrator Information Technology 832.295.2245 [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 09, 2003 9:04 AM To: Multiple recipients of list ORACLE-L Hi List I tried the following stuff but it says Service Unavailable. $mail -s Test Subject [EMAIL PROTECTED] body line1 body line2 Ctrl-D What should i do to make email stuff work? 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: 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).
RE: How to send an email from unix command line?
Try something like tar cf - /|uuencode my_system.tar|mailx -s This is my system, don't you like it? [EMAIL PROTECTED] That command would attach the complete backup of your system to the email message. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oracle DBA Sent: Tuesday, September 09, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Subject: How to send an email from unix command line? Hi List I tried the following stuff but it says Service Unavailable. $mail -s Test Subject [EMAIL PROTECTED] body line1 body line2 Ctrl-D What should i do to make email stuff work? 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: Jobs and OEM... how to
Title: RE: Jobs and OEM... how to Perl and cron. -Original Message- From: Jose Luis Delgado [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 09, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Subject: Jobs and OEM... how to Hi to everybody!! I would like to create a job that EXPort my database, but... I *do not* want to use OEM. OEM uses tcl and the intelligent agent to schedule its jobs... how can I create a job that can export my database? (no problem if I have to program with tcl files) Any ideas? any sample (would be better :-) TIA JL __ 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: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to send an email from unix command line?
Brian, Thanks for your response. snedmail is running. $ ps -ef|grep -i mail root 621 1 0 Aug 25 ?0:00 /usr/lib/sendmail -bd -q15m oracle 29802 28321 0 10:11:34 pts/60:00 grep -i mail --- Brian Dunbar [EMAIL PROTECTED] wrote: is sendmail running? $HOST:/ps -ef | grep mail root 250 1 0 Aug 24 ?0:00 /usr/lib/sendmail -bd -q15m root 2358 2295 0 08:18:42 pts/10:00 grep mail man mail or pester your admin if all else fails. For example we disable sendmail unless it's required. ~brian -Original Message- Sent: Tuesday, September 09, 2003 9:04 AM To: Multiple recipients of list ORACLE-L Hi List I tried the following stuff but it says Service Unavailable. $mail -s Test Subject [EMAIL PROTECTED] body line1 body line2 Ctrl-D What should i do to make email stuff work? 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: 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). __ 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).
RE: 10g
No, you get 3 wishes from the genie, after that you have to buy a licence for geniEE. Come to think of it, maybe the g in Oracle 10g stands for genie rather than grid? At 06:59 AM 9/9/2003 -0800, you wrote: You're up to 3 wishes and then it will crash ... I wonder if you have to rub the server or the disk box to get the genie ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Jobs and OEM... how to
Hi Stefick... thanks for your input... well, I was thinking about dbms_job, may be I was not so clear... thanks again. Regards JL --- Stefick Ronald S Contr ESC/HRIDD [EMAIL PROTECTED] wrote: Perl and cron. -Original Message- Sent: Tuesday, September 09, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Hi to everybody!! I would like to create a job that EXPort my database, but... I *do not* want to use OEM. OEM uses tcl and the intelligent agent to schedule its jobs... how can I create a job that can export my database? (no problem if I have to program with tcl files) Any ideas? any sample (would be better :-) TIA JL __ 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: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ 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: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9iOAS install help needed
Thanks for the reply. I already verified the correct port but no go. Thanks Rick Boivin, Patrice J To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: mpo.gc.ca Subject: RE: Oracle 9iOAS install help needed Sent by: [EMAIL PROTECTED] .com 09/09/2003 10:19 AM Please respond to ORACLE-L There is a ports.ini file somewhere in the infra and middle Oracle homes, they would tell you what port to use. Patrice. -Original Message- Sent: Tuesday, September 09, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Hi All, I am trying to install Oracle 9iAS on Win 2000 I installed Infra structure successfully. While trying to install next component OAS with BI/Forms I get a message Existing Oracle9iOAS Single Sign-On. Enter hostname and port number of existing Single Sign-On. Heck I do not know if it installed. I assume it is since infrastructure is installed. Obviously I am a first timer in OAS. I have about 300 pages of documentation but I can find nothing to troubleshoot. Does anyone have any experience they can share or URL's. Thanks Rick -- 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: 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). -- 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: RE: 10g
there are some semi-technical articles on otn about 10g. Im less than impressed with the pl/sql enhancements. anyone look at the HTML DB stuff? is that considerably better than the htp package or pl/sql server pages? From: Wolfgang Breitling [EMAIL PROTECTED] Date: 2003/09/09 Tue AM 11:24:27 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: 10g No, you get 3 wishes from the genie, after that you have to buy a licence for geniEE. Come to think of it, maybe the g in Oracle 10g stands for genie rather than grid? At 06:59 AM 9/9/2003 -0800, you wrote: You're up to 3 wishes and then it will crash ... I wonder if you have to rub the server or the disk box to get the genie ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Jobs and OEM... how to
How about a shell script, scheduled with AT or CRON? -Original Message- Sent: Tuesday, September 09, 2003 5:04 PM To: Multiple recipients of list ORACLE-L Hi to everybody!! I would like to create a job that EXPort my database, but... I *do not* want to use OEM. OEM uses tcl and the intelligent agent to schedule its jobs... how can I create a job that can export my database? (no problem if I have to program with tcl files) Any ideas? any sample (would be better :-) TIA JL __ 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: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Resynchronizing the stored outline definition
Perhaps some RTFM is in order here. A studios examination of the fine docs might suggest 'create or replace'. Jared On Tue, 2003-09-09 at 05:59, [EMAIL PROTECTED] wrote: Hello list , I am using Oracle 9.2.0.1.0 Enterprise edition on windows. I get an error while trying to resynchronze a private outline after I have edited it. I get this error when I use the identity statement SQL create private outline test from private test ; create private outline test from private test * ERROR at line 1: ORA-18004: outline already exists However the following succeeds : SQL exec dbms_outln_edit.refresh_private_outline ('TEST' ) ; PL/SQL procedure successfully completed. Any ideas why the identitiy statement fails ? ... -- 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Database Link
The error message should be a definite clue. If you're not familiar with the 'oerr' utility, now is the time to try it out. On either of your servers, type this command from the system command prompt: oerr ora 12154 The info provided there should make it clear that some modification are needed to your sqlnet ( net 8, oracle net, whatever) environment on the server with the 9i database. Jared On Mon, 2003-09-08 at 14:39, Hamid Alavi wrote: Dear List, I have two database one on 8.1.7.4 on sun Solaris 8.2 and another one on oracle 9.0.1(two separate box) I have created a database link under oracle 8 to oracle 9 database it's working fine from 8 to 9, but when I try to use this link from 9 to 8 it's failed to ORA-12154. Any idea what could be this?? Thanks allot for your help. Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Privileges associated with Role
Hi List How to look for all the privileges associated with particular Role(for example R1)? Alos does anyone have a query to identify ALL(either directly or thru role) the privileges granted on particular tables 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: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to send an email from unix command line?
Mladen Gogala scribbled on the wall in glitter crayon: Try something like tar cf - /|uuencode my_system.tar|mailx -s This is my system, don't you like it? [EMAIL PROTECTED] That command would attach the complete backup of your system to the email message. you, sir, are evil. i admire that.;-) -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] The most incomprehensible thing about the world is that it is comprehensible. - 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: Jobs and OEM... how to
Since DBMS_JOB executes PL/SQL code (and that's what you want to use), you'll have to write an external stored procedure, which calls Export, wrap it in PL/SQL procedure, and call it from DBMS_JOB. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Jose Luis Delgado Sent: Tuesday, September 09, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Hi Stefick... thanks for your input... well, I was thinking about dbms_job, may be I was not so clear... thanks again. Regards JL --- Stefick Ronald S Contr ESC/HRIDD [EMAIL PROTECTED] wrote: Perl and cron. -Original Message- Sent: Tuesday, September 09, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Hi to everybody!! I would like to create a job that EXPort my database, but... I *do not* want to use OEM. OEM uses tcl and the intelligent agent to schedule its jobs... how can I create a job that can export my database? (no problem if I have to program with tcl files) Any ideas? any sample (would be better :-) TIA JL __ 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: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ 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: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Oracle 9iOAS install help needed
I installed our Oracle 9iAS on Win 2000 following Oracle 9iAS Release 2 (9.0.2.0.1) Windows Installation Cookboook (Note: 21469.1). It's been a few months so I don't recall exactly how it went. The document does mention to verify the SSO Login by going to http://hostname.domain:port/pls/orasso, login using the 'orcladmin' username and the password for the 'ias_admin'. The port will be the HTTP Server port of your Infrastructure, (port by default). You most likely already tried this but thought I would post just in case. -Jeff -Original Message- Sent: Tuesday, September 09, 2003 7:59 AM To: Multiple recipients of list ORACLE-L Hi All, I am trying to install Oracle 9iAS on Win 2000 I installed Infra structure successfully. While trying to install next component OAS with BI/Forms I get a message Existing Oracle9iOAS Single Sign-On. Enter hostname and port number of existing Single Sign-On. Heck I do not know if it installed. I assume it is since infrastructure is installed. Obviously I am a first timer in OAS. I have about 300 pages of documentation but I can find nothing to troubleshoot. Does anyone have any experience they can share or URL's. Thanks Rick -- 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: Eberhard, Jeff INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 10g
Oracle's Kumar likens ADDM to 'a genie in your database-if you have a performance problem, you just ask the database what the problem is and it automatically analyzes the complete database system and comes up with recommendations.' If this works like Oracle Expert, then it's recommendations are worthless. 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).
ORA-01403 error, help!!!
If logged in SQL Plus the following SQL returns just one row: SELECT t$orno FROM ttdsls805501 WHERE t$user = 'exped9' GROUP BY t$orno; If I do use the same SELECT statement inside a stored procedure and have the returning value stored in a local variable: SELECT t$orno INTO eskaria FROM ttdsls805501 WHERE t$user = 'exped9' GROUP BY t$orno; where eskaria has been declared as: eskaria ttdsls805501.t$orno%TYPE; I get ORA-01403. I have no clue why I am getting this error, can you help please? Many thanks! .. Fermín Bernaus Berraondo Dpto. de Informática SAMMIC, S.A. [EMAIL PROTECTED] http://www.sammic.com Telf. +34 - 943 157 331 Fax +34 - 943 151 276 .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fermin Bernaus INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 and Perl
Worked Great! Thanks! Ron -Original Message- Sent: Tuesday, September 09, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Hi, Ron my $ORA_SID = $ENV{'ORACLE_SID'} my ORAC_HOME = $ENV{'ORACLE_HOME'} should siffice ;) HTH. Milen -Ursprüngliche Nachricht- Von: Smith, Ron L. [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 9. September 2003 15:39 An: Multiple recipients of list ORACLE-L Betreff: Oracle and Perl Can anyone tell me how to pick up the $ORACLE_SID or $ORACLE_HOME from within a Perl script? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-01403 error, help!!!
bash-2.05a$ oerr ora 1403 01403, 0, no data found // *Cause: // *Action: Make up some data. Use your imagination -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fermin Bernaus Sent: Tuesday, September 09, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Subject: ORA-01403 error, help!!! If logged in SQL Plus the following SQL returns just one row: SELECT t$orno FROM ttdsls805501 WHERE t$user = 'exped9' GROUP BY t$orno; If I do use the same SELECT statement inside a stored procedure and have the returning value stored in a local variable: SELECT t$orno INTO eskaria FROM ttdsls805501 WHERE t$user = 'exped9' GROUP BY t$orno; where eskaria has been declared as: eskaria ttdsls805501.t$orno%TYPE; I get ORA-01403. I have no clue why I am getting this error, can you help please? Many thanks! .. Fermín Bernaus Berraondo Dpto. de Informática SAMMIC, S.A. [EMAIL PROTECTED] http://www.sammic.com Telf. +34 - 943 157 331 Fax +34 - 943 151 276 .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fermin Bernaus INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: How to send an email from unix command line?
Thank you, thank you! I'm doing my best. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thater, William Sent: Tuesday, September 09, 2003 12:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to send an email from unix command line? Mladen Gogala scribbled on the wall in glitter crayon: Try something like tar cf - /|uuencode my_system.tar|mailx -s This is my system, don't you like it? [EMAIL PROTECTED] That command would attach the complete backup of your system to the email message. you, sir, are evil. i admire that.;-) -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] -- -- The most incomprehensible thing about the world is that it is comprehensible. - 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). 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: Privileges associated with Role
Select * from dba_sys_privs where grantee='R1'; Select * from dba_tab_privs where grantee='R1'; Select * from dba_tab_privs where owner='schema' and table_name='table_name'; -Original Message- Sent: Tuesday, September 09, 2003 12:14 PM To: Multiple recipients of list ORACLE-L Hi List How to look for all the privileges associated with particular Role(for example R1)? Alos does anyone have a query to identify ALL(either directly or thru role) the privileges granted on particular tables 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: 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).
chained/migrated rows
I am trying to redo my scripts to remove the chained rows on a table. I am running on AIX, oracle 9.2.0.4. The issue I am running into is not being able to issue DDL from inside a loop or remotely from unix. I want the script to be launched from cron, create cursor of all the non system tables(from oracle), loop through and analyze each one. Then create temp table and copy data and then delete data from orig and copy back to orig and then drop temp table. Some how need to get the info from oracle to unix and run it and pass it back. I use a daemon process to go back and forth. How does everyone else do it? These scripts haven't been touched since 1997. All ideas welcome. -- 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: Documents in or outside the database.
Compromise? BFILE? Unless we are actually trying to search the documents themselves, I store documents outside the database and store the pathname to the document location within the database itself. --- M.Godlewski [EMAIL PROTECTED] wrote: Hi listers, We are working on a project that will have documents as attachments. The developers want to store the documents outside the database on the application server. I want to store the documents inside the database for recovery purposes. Is there a white paper or document that has performance information for blob/clob storage and retrieval database performance information? TIA M. - Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-01403 error, help!!!
Fermin, Are you sure it is failing here? As Mladen said, 1403 is No Data Found. Do you have any other select statements in the Procedure? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 09, 2003 1:09 PM To: Multiple recipients of list ORACLE-L If logged in SQL Plus the following SQL returns just one row: SELECT t$orno FROM ttdsls805501 WHERE t$user = 'exped9' GROUP BY t$orno; If I do use the same SELECT statement inside a stored procedure and have the returning value stored in a local variable: SELECT t$orno INTO eskaria FROM ttdsls805501 WHERE t$user = 'exped9' GROUP BY t$orno; where eskaria has been declared as: eskaria ttdsls805501.t$orno%TYPE; I get ORA-01403. I have no clue why I am getting this error, can you help please? Many thanks! .. Fermín Bernaus Berraondo Dpto. de Informática SAMMIC, S.A. [EMAIL PROTECTED] http://www.sammic.com Telf. +34 - 943 157 331 Fax +34 - 943 151 276 .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fermin Bernaus INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Privileges associated with Role
This was posted here a while ago. I modified it to work through a database link but if you leave the database link blank it will work on your current database. It gives you all the privs (sys, role, and tab) granted directly to the userid as well as all the privs granted to it via roles. -- Posted by Jacques Kilchoer [EMAIL PROTECTED] on ORACLE-L set linesize 200 set pages 500 set verify off column sort_id noprint column priv_type format a31 column priv format a59 column grantable heading ADM format a3 column default_role heading DEF format a3 select 1 as sort_id, 'ROLE' as priv_type, a.granted_role as priv, a.admin_option as grantable, a.default_role as default_role from sys.dba_role_privslink a where grantee = upper('enter_username') union select 2 as sort_id, 'SYS PRIV' as priv_type, b.privilege as priv, b.admin_option as grantable, null as default_role from sys.dba_sys_privslink b where grantee = upper('enter_username') union select 5 as sort_id, 'TAB PRIV (ROLE ' || c.granted_role || ')' as priv_type, d.privilege || ' on ' || d.owner || '.' || d.table_name || '' as priv, d.grantable as grantable, c.default_role as default_role from sys.dba_role_privslink c, sys.dba_tab_privslink d where c.grantee = upper('enter_username') and d.grantee = c.granted_role union select 7 as sort_id, 'COL PRIV (ROLE ' || e.granted_role || ')' as priv_type, f.privilege || ' on ' || f.owner || '.' || f.table_name || ' (' || f.column_name || ')' as priv, f.grantable as grantable, e.default_role as default_role from sys.dba_role_privslink e, sys.dba_col_privslink f where e.grantee = upper('enter_username') and f.grantee = e.granted_role union select 4 as sort_id, 'TAB PRIV' as priv_type, g.privilege || ' on ' || g.owner || '.' || g.table_name || '' as priv, g.grantable as grantable, null as default_role from sys.dba_tab_privslink g where g.grantee = upper('enter_username') union select 6 as sort_id, 'COL PRIV' as priv_type, h.privilege || ' on ' || h.owner || '.' || h.table_name || ' (' || h.column_name || ')' as priv, h.grantable as grantable, null as default_role from sys.dba_col_privslink h where h.grantee = upper('enter_username') union select 3 as sort_id, 'SYS PRIV (ROLE ' || i.granted_role || ')' as priv_type, j.privilege as priv, j.admin_option as grantable, i.default_role as default_role from sys.dba_role_privslink i, sys.dba_sys_privslink j where i.grantee = upper('enter_username') and j.grantee = i.granted_role order by 1, 2, 3 ; undefine enter_username undefine link clear columns set linesize 80 set verify on Rothouse, Michael To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] mrothouse cc: @fcg.comSubject: RE: Privileges associated with Role Sent by: ml-errors 09/09/2003 01:54 PM Please respond to ORACLE-L Select * from dba_sys_privs where grantee='R1'; Select * from dba_tab_privs where grantee='R1'; Select * from dba_tab_privs where owner='schema' and table_name='table_name'; -Original Message- Sent:
Re: Can't query through a synonym, the solution
Nice on your part to share. Hi List Well, we figured it out. Here was the sequence of events T1 - init ora parameter dblink_encrypt_login set to true in the target database T2 - synonym created T3 - init ora parameter dblink_encrypt_login set to false in the target database The synonym created at T2 will never work again. Further if you reference that synonym you will cerate a connection to the target database that will not let you drop that synonym. Evil. Another thing to know about dblink_encrypt_login is that the Oracle Gateway products will not work with that parameter set to true. All of this just in case you ever have to deal with peach_fuzz_cheeked, checklist_toting, dumb_as_a_post auditors who want you to turn that parameter on. Allan L. Nelson Oracle DBA M-I L.L.C. (832) 295-2238 office (832) 351-4180 fax [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] __ 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] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Privileges associated with Role
I should have read your question more closely. The grants script that I provided will also work with a role instead of a userid. To get all the privileges granted on a table select * from dba_tab_privs where table_name = 'TABLE_YOU'RE_INTERESTED_IN'; Oracle DBA sami_resume To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @yahoo.com cc: Sent by: Subject: Privileges associated with Role ml-errors 09/09/2003 12:14 PM Please respond to ORACLE-L Hi List How to look for all the privileges associated with particular Role(for example R1)? Alos does anyone have a query to identify ALL(either directly or thru role) the privileges granted on particular tables 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: 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: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Weird ORA-00060 (deadlock) with pragma autonomous transaction
Babette, Could you post the deadlock trace file please. Henry -Original Message- Babette Turner-Underwood Sent: Tuesday, September 09, 2003 12:09 AM To: Multiple recipients of list ORACLE-L We are getting a strange deadlock problem and I am having trouble understanding the cause and action. Metalink has not been too useful for this one. We have a procedure eg INS_REC that does an insert into table ABC. The procedure uses a pragma autonomous transaction. We have a package eg DO_SET_OF_WORK that selects from several tables and then based on the information selected will call the above procedure, along with several other procedures that will do inserts or deletes (on DIFFERENT tables). The package does opens a cursor to process all records selected. When we use pragma autonomous transaction AND commit in the procedure called, the package dies with an ORA-0060. When the pragma autonomous transaction is removed from the procedure, the package does not get a deadlock. There is only ONE user using this set of tables (in a separate schema from other users on the system) at the time this is occuring. I am puzzled. Another DBA suggested this may be related to FREELISTS, so I increased them for both the table and indexes that were being reported as deadlocking but it did not make any difference. Anyone have any other suggestions ? Thanks Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-01403 error, help!!!
Fermin...: ORA-01403 means No data found... you should manage an EXCEPTION code in your procedure to catch this kind of error. HTH JL --- Fermin Bernaus [EMAIL PROTECTED] wrote: I get ORA-01403. I have no clue why I am getting this error, can you help please? Many thanks! __ 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: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 600-[25012] on delete of IOT table
Apologies for not replying immediately. Was tied up with something else. Searched again on metalink advanced option for quote 8.1.7.2 IOT [25012] /quote with MATCH all (AND(++)) option . Click on Doc ID: Note:165461.1 (ie) option 4 8.1.7.X Patch Sets - List of Bug Fixes by Problem Type Search for 25012 in that and you should get quote Bug 1527982 Abstract: ORA-600 [25012] Bitmap index-table mismatch after UPDATE of PARTITION KEY moves rows Details: If a partitioned table has LOCAL BITMAP INDEXES and the partition key is updated such that the row moves to a different partition then the bitmap index is not updated correctly causing subsequent errors (eg: ORA-600 [25012]) when accessing table data via the bitmap index. This bug is generic and reported on 8.1.6.2. It has been fixed in 9i and 8.1.7.2.0. A few backports to 8.1.6.3.0 are available. To reproduce: create table bmi_test (id number(5), val varchar(5)) partition by range (id) (partition low values less than (100) tablespace users, partition high values less than (200) tablespace users) enable row movement; insert into bmi_test values (1,'red'); commit; create bitmap index bmi_test_idx on bmi_test (val) local; update bmi_test set id=100 where id=1; commit; analyze table bmi_test validate structure cascade; The last command should result in Ora-1499. Ensure that you have run the utlvalid.sql from your $ORACLE_HOME/rdbms/admin directory or else you would get ORA-14508: specified VALIDATE INTO table not found instead of an ORA-1499. quote HTH GovindanK hi, GovindanK: I searched metalink and cannot find note:287936.999 you mentioned. And I did not move the IOT index segment and overflow segment online. I did those operation during system outage. Thanks. Regards zhu chao msn:[EMAIL PROTECTED] www.cnoug.org - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 05, 2003 9:54 AM Take a look at the Metalink Note:125149.1 ALERT: ONLINE Index Rebuild or IOT Table Move can Produce Corrupt Index As per the note it affects 8.1.(5/6/7).x It has the relevant info. Also take a look at the Docid: 287936.999. HTH GovindanK Sun solaris 8/oracle 8.1.7.2 64bit. After some database defrag(via alter table xxx move and alter index xxx rebuild), I got 600-25012 from my delete session and alert file. SQL DELETE FROM EOI_PDTLIST WHERE ROWNUM=1; DELETE FROM EOI_PDTLIST WHERE ROWNUM=1 * ERROR at line 1: ORA-00600: internal error code, arguments: [25012], [15], [32], [], [], [], [], [] This is index organized table with overflow segment. Maybe I foget to move that overflow segment, after move overflow segment , delete is ok. But according to metalink ,maybe there is data corruption. So I ask here if friends in this list has also hit this nasty problem too. Fri Sep 5 04:29:58 2003 Errors in file /export/home/oracle/admin/biddb/udump/biddb_ora_3602.trc: ORA-00600: internal error code, arguments: [25012], [15], [32], [], [], [], [], [] Fri Sep 5 04:30:33 2003 Errors in file /export/home/oracle/admin/biddb/udump/biddb_ora_3602.trc: ORA-00600: internal error code, arguments: [25012], [15], [32], [], [], [], [], [] Fri Sep 5 04:36:08 2003 I dbved the datafiles of that tablespace , nothing wrong. My account in metalink cannot open Itar now:( Thanks Zhu Chao www.cnoug.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Privileges associated with Role
dba_sys_privs role_sys_privs - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 21:44 Hi List How to look for all the privileges associated with particular Role(for example R1)? -- 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: Resynchronizing the stored outline definition
Duh,oh Thanks But Jared , the problem was that the FM itself told me to type : CREATE PRIVATE OUTLINE p_ol1 FROM PRIVATE p_ol1; Ref : Oracle 9i Database Performance Tuning Guide and Reference a96533.pdf page 7-9 , Chapter 7 : Using Plan Stability to Preserve Execution Plans, Section : Example of Editing Outlines Would really appreciate your input about the ora-03113 and core dump problem I keep getting when I use create_stored_outlines : Suppose two users scott and hr have select any table, create any outline privileges and select_catalog_role. SQL conn scott/[EMAIL PROTECTED] Connected. SQL select count (*) from scott.emp ; COUNT(*) -- 6 SQL conn hr/[EMAIL PROTECTED] Connected. SQL alter session set create_stored_outlines=hr; Session altered. SQL select count (*) from scott.emp ; COUNT(*) -- 6 SQL create table test as select * from scott.emp ; create table test as select * from scott.emp * ERROR at line 1: ORA-03113: end-of-file on communication channel (And I get a core dump file ) The same thing happens irrespective of the category name I use in alter session set create_stored_outlines , even when i specify alter session set create_stored_outlines=default;, and even when I use random values. But when I do the following then no problems : SQL conn hr/[EMAIL PROTECTED] Connected. SQL alter session set create_stored_outlines=false; Session altered. SQL create table test as select * from scott.emp ; Table created. Any ideas ? . - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 21:14 Perhaps some RTFM is in order here. A studios examination of the fine docs might suggest 'create or replace'. Jared On Tue, 2003-09-09 at 05:59, [EMAIL PROTECTED] wrote: Hello list , I am using Oracle 9.2.0.1.0 Enterprise edition on windows. I get an error while trying to resynchronze a private outline after I have edited it. I get this error when I use the identity statement SQL create private outline test from private test ; create private outline test from private test * ERROR at line 1: ORA-18004: outline already exists However the following succeeds : SQL exec dbms_outln_edit.refresh_private_outline ('TEST' ) ; PL/SQL procedure successfully completed. Any ideas why the identitiy statement fails ? ... -- 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [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: Privileges associated with Role
Hi I wrote script some time back that you use to find all privileges granted to a user or role, system, object and role. It does this hierarchically so that it shows privs granted to roles granted to roles etc. It is available from http://www.petefinnigan.com/tools.htm its the first script there: A sample output is: get user input NAME OF USER TO CHECK [ORCL]: DBSNMP OUTPUT METHOD [S/F]: S FILE NAME FOR OUTPUT [priv.lst]: OUTPUT DIRECTORY [/tmp]: old 162:lv_file_or_screen:='output_method'; new 162:lv_file_or_screen:='S'; old 164:open_file('file_name','output_dir'); new 164:open_file('priv.lst','/tmp'); old 166:get_privs('user_to_find',lv_tabs); new 166:get_privs('DBSNMP',lv_tabs); ...USER = DBSNMP has ROLE CONNECT which contains = ..SYS PRIV =ALTER SESSION grantable = NO ..SYS PRIV =CREATE CLUSTER grantable = NO ..SYS PRIV =CREATE DATABASE LINK grantable = NO ..SYS PRIV =CREATE SEQUENCE grantable = NO ..SYS PRIV =CREATE SESSION grantable = NO ..SYS PRIV =CREATE SYNONYM grantable = NO ..SYS PRIV =CREATE TABLE grantable = NO ..SYS PRIV =CREATE VIEW grantable = NO ...SYS PRIV =CREATE USER grantable = NO ...SYS PRIV =SELECT ANY DICTIONARY grantable = NO PL/SQL procedure successfully completed. SQL Hope this helps 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).
overloading and = comparisons in SQL
I don't know what to think re. this. There is a view here that produces an error, I identified why -- in one AND clause a number(9) datatype column is being joined with a varchar2(50) datatype column. The developer of this code says that this used to run, there must be something wrong with the server. I want to verify... Is there any kind of overloading invoked automatically when Oracle compares columns of different datatypes? i.e. if the varchar2(50) column only contains numbers, would Oracle convert it automatically to number before making the comparison? (My intuition says: NO. ) 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: overloading and = comparisons in SQL
My intuition says: NO. Your intution loses. :) drop table a; drop table b; create table a as select object_id, object_name from dba_objects where rownum 11 / create table b as select to_char(object_id) object_id_char, object_name from a / alter table b modify(object_id_char varchar2(50)); create or replace view abv as select a.object_name from a, b where a.object_id = b.object_id_char / select * from abv; update b set object_id_char = 'Z' || object_id_char / commit; select * from abv; Boivin, Patrice J [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/09/2003 01:49 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:overloading and = comparisons in SQL I don't know what to think re. this. There is a view here that produces an error, I identified why -- in one AND clause a number(9) datatype column is being joined with a varchar2(50) datatype column. The developer of this code says that this used to run, there must be something wrong with the server. I want to verify... Is there any kind of overloading invoked automatically when Oracle compares columns of different datatypes? i.e. if the varchar2(50) column only contains numbers, would Oracle convert it automatically to number before making the comparison? (My intuition says: NO. ) 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: overloading and = comparisons in SQL
You can have in a where clause a varchar2 column compared to a number column , if the varchar2 column only contains numeric then it will work. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Boivin, Patrice J Sent: Tuesday, September 09, 2003 4:49 PM To: Multiple recipients of list ORACLE-L I don't know what to think re. this. There is a view here that produces an error, I identified why -- in one AND clause a number(9) datatype column is being joined with a varchar2(50) datatype column. The developer of this code says that this used to run, there must be something wrong with the server. I want to verify... Is there any kind of overloading invoked automatically when Oracle compares columns of different datatypes? i.e. if the varchar2(50) column only contains numbers, would Oracle convert it automatically to number before making the comparison? (My intuition says: NO. ) 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 10g
It's also called Graham in a Box internally in Development because Graham Wood put some effort into it. It's Statspack on steroids plus more, but it will of course still be as useless as Statspack wrt system-wide measurement data. It does contain the SQL stuff if you ask it to, and that's useful. It will even - in EM - highlight if an execution plan hash value changed. The execution plan hash value was put into Statspack by Graham in 9i, but now it gets highlighted if it changed. Mogens Tanel Poder wrote: Oracle's Kumar likens ADDM to 'a genie in your database-if you have a performance problem, you just ask the database what the problem is and it automatically analyzes the complete database system and comes up with recommendations.' If this works like Oracle Expert, then it's recommendations are worthless. Tanel. -- 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).
Re: 10g
ADDM (pronouned Adam) is - as I wrote a minute ago - Statspack++ - for what it's worth. Of course you can't tell a damned thing about performance problems from system-data. Unless there's only one and the same user on the system in the observation internval. Active Session History (ASH), however, is a different story. Here they collect (down to every second) data about each session and what it spent its time doing. That's 10046 stuff being sampled in memory structures and stored in the repository in the SYSAUX tablespace. Very cool. Gaja will talk about it at our Database Forum - probably the day after he stars in BAARF. The Musical. Jesse, Rich wrote: Sweet! Oracle's Kumar likens ADDM to 'a genie in your database-if you have a performance problem, you just ask the database what the problem is and it automatically analyzes the complete database system and comes up with recommendations.' sarcasmNo more SQL tuning! No more STATSPACK! No more OEM/DBMS jobs! Wait a minute...no more DBA? Uh-oh./sarcasm I'm sorry Dave. I can't close the pod bay instance. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 2:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: 10g Correct. You can follow his announcement on www.Oracle.com at 2PM PDT. -- 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).
Re: offshoring article
Makes sense. Peter Barnett wrote: Let's see if I have this straight, the US is nearly a half trillion dollars in debt. It is going to add at least another 87 billion to that number. It has just reduced taxes on its citizens. And, now it is good for the country to send its best paying jobs overseas. Looks to me like the US is determined to become a third world country at warp speed. Can't blame anyone overseas since the decisions are made in the US. --- Mogens_Nørgaard [EMAIL PROTECTED] wrote: They're hired by the people who came out of those very same universities. Most often McKinsey et al are hired to OK decisions that management have a hard time OK'ing themselves for various reasons. To be fair, of all the consulting companies that make money out of telling people that water runs downhill, McKinsey are among the very best. Ryan wrote: Here is a link to an article from McKinsey Co. My favorite positive is that offshoring IT jobs frees Americans up to do other jobs. Now they dont say 'what' jobs, but we are free to do them. If you dont know these are the guys who payed Chelsea Clinton 100k/year right out of college with no experience. If you explore their website they are more interested in where you went to school than anything else(notice how university comes before experience). who hires these guys? http://www.mckinsey.com/knowledge/mgi/offshore/ -- 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). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ 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).
Re: overloading and = comparisons in SQL
Hi! Which kind of error? And where does it occur? What's the view code? Oracle does an implicit datatype conversion (if possible) when comparing different datatypes. Try to add the conversion explicitly with to_number for example try then. Note that Oracle can't use indexes in joins for implicitly or explicitly converted data - unless you have relevand function based indexes there... So, you might have problem in your design. Btw, did you change any versions recently? If you just went to 9.2.0.3 or 9.2.0.4, and started seeing your problem after that, then you might want to look at event 10499 on level 1 which is new starting from 9.2.0.3. (I doubt that you are hitting this problem, you didn't give us enough information). Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 11:49 PM I don't know what to think re. this. There is a view here that produces an error, I identified why -- in one AND clause a number(9) datatype column is being joined with a varchar2(50) datatype column. The developer of this code says that this used to run, there must be something wrong with the server. I want to verify... Is there any kind of overloading invoked automatically when Oracle compares columns of different datatypes? i.e. if the varchar2(50) column only contains numbers, would Oracle convert it automatically to number before making the comparison? (My intuition says: NO. ) 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). -- 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: Antw: Database Link
Yes I also have one from 9 to 8 but still the same error??? -Original Message- [mailto:[EMAIL PROTECTED] Sent: Monday, September 08, 2003 11:49 PM To: Multiple recipients of list ORACLE-L Hi Hamid, excuse me: AARRRGGHH! Ok, feeling better now. You can't use the db link this way. You have to create one on the 9i server that points to the 8i database. hth, Guido [EMAIL PROTECTED] 08.09.2003 23.39 Uhr Dear List, I have two database one on 8.1.7.4 on sun Solaris 8.2 and another one on oracle 9.0.1(two separate box) I have created a database link under oracle 8 to oracle 9 database it's working fine from 8 to 9, but when I try to use this link from 9 to 8 it's failed to ORA-12154. Any idea what could be this?? Thanks allot for your help. Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: overloading and = comparisons in SQL
It looks like it always converts a character column to a number (or date) before comparing, never the other way around: SQL create table a ( N1 number ); Table created. SQL create table b (c1 varchar2(50)); Table created. SQL insert into a values (1000); 1 row created. SQL insert into a values (2000); 1 row created. SQL commit; Commit complete. SQL insert into b values ('1000'); 1 row created. SQL insert into b values('abcd'); 1 row created. SQL commit; Commit complete. SQL select * from a, b where a.n1 = b.c1; select * from a, b where a.n1 = b.c1 * ERROR at line 1: ORA-01722: invalid number === the order in which the comparison is coded doesn't matter: SQL select * from a, b where b.c1 = a.n1; select * from a, b where b.c1 = a.n1 * ERROR at line 1: ORA-01722: invalid number === but you can explicitly cast the number as a varchar2, then the comparison succeeds: SQL select * from a, b where b.c1 = cast(a.n1 as varchar2(50)); N1 C1 -- -- 1000 1000 1 row selected. === or if you have other predicates which filter out offensive values before the comparison it works as well: SQL select * from a, b where b.c1 = a.n1 and b.c1 'a'; N1 C1 -- -- 1000 1000 1 row selected. The latter could be the reason the view sometimes works. At 12:49 PM 9/9/2003 -0800, you wrote: I don't know what to think re. this. There is a view here that produces an error, I identified why -- in one AND clause a number(9) datatype column is being joined with a varchar2(50) datatype column. The developer of this code says that this used to run, there must be something wrong with the server. I want to verify... Is there any kind of overloading invoked automatically when Oracle compares columns of different datatypes? i.e. if the varchar2(50) column only contains numbers, would Oracle convert it automatically to number before making the comparison? (My intuition says: NO. ) Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Resynchronizing the stored outline definition
Yeah, well, not all FM's are created equal. It's very common to see 'CREATE OBJECT' in documentation, Oracle or otherwise. I usually use 'CREATE OR REPLACE OBJECT' on objects that allow it, but that's just my preference. As for the ORA-3113, sounds like a bug. The 3113 is a generic error. Check the alert log and/or udump directory for trace file information. Check metalink for CTAS and 'ora-3113'. Looks like you may need to file a TAR. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/09/2003 12:24 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Resynchronizing the stored outline definition Duh,oh Thanks But Jared , the problem was that the FM itself told me to type : CREATE PRIVATE OUTLINE p_ol1 FROM PRIVATE p_ol1; Ref : Oracle 9i Database Performance Tuning Guide and Reference a96533.pdf page 7-9 , Chapter 7 : Using Plan Stability to Preserve Execution Plans, Section : Example of Editing Outlines Would really appreciate your input about the ora-03113 and core dump problem I keep getting when I use create_stored_outlines : Suppose two users scott and hr have select any table, create any outline privileges and select_catalog_role. SQL conn scott/[EMAIL PROTECTED] Connected. SQL select count (*) from scott.emp ; COUNT(*) -- 6 SQL conn hr/[EMAIL PROTECTED] Connected. SQL alter session set create_stored_outlines=hr; Session altered. SQL select count (*) from scott.emp ; COUNT(*) -- 6 SQL create table test as select * from scott.emp ; create table test as select * from scott.emp * ERROR at line 1: ORA-03113: end-of-file on communication channel (And I get a core dump file ) The same thing happens irrespective of the category name I use in alter session set create_stored_outlines , even when i specify alter session set create_stored_outlines=default;, and even when I use random values. But when I do the following then no problems : SQL conn hr/[EMAIL PROTECTED] Connected. SQL alter session set create_stored_outlines=false; Session altered. SQL create table test as select * from scott.emp ; Table created. Any ideas ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 21:14 Perhaps some RTFM is in order here. A studios examination of the fine docs might suggest 'create or replace'. Jared On Tue, 2003-09-09 at 05:59, [EMAIL PROTECTED] wrote: Hello list , I am using Oracle 9.2.0.1.0 Enterprise edition on windows. I get an error while trying to resynchronze a private outline after I have edited it. I get this error when I use the identity statement SQL create private outline test from private test ; create private outline test from private test * ERROR at line 1: ORA-18004: outline already exists However the following succeeds : SQL exec dbms_outln_edit.refresh_private_outline ('TEST' ) ; PL/SQL procedure successfully completed. Any ideas why the identitiy statement fails ? ... -- 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [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,
Re: overloading and = comparisons in SQL
where can i find a list of sqltrace events? seems that 10053 and 10046 are well documented on hotsos. how many are there? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 5:39 PM Hi! Which kind of error? And where does it occur? What's the view code? Oracle does an implicit datatype conversion (if possible) when comparing different datatypes. Try to add the conversion explicitly with to_number for example try then. Note that Oracle can't use indexes in joins for implicitly or explicitly converted data - unless you have relevand function based indexes there... So, you might have problem in your design. Btw, did you change any versions recently? If you just went to 9.2.0.3 or 9.2.0.4, and started seeing your problem after that, then you might want to look at event 10499 on level 1 which is new starting from 9.2.0.3. (I doubt that you are hitting this problem, you didn't give us enough information). Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 11:49 PM I don't know what to think re. this. There is a view here that produces an error, I identified why -- in one AND clause a number(9) datatype column is being joined with a varchar2(50) datatype column. The developer of this code says that this used to run, there must be something wrong with the server. I want to verify... Is there any kind of overloading invoked automatically when Oracle compares columns of different datatypes? i.e. if the varchar2(50) column only contains numbers, would Oracle convert it automatically to number before making the comparison? (My intuition says: NO. ) 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to send an email from unix command line?
cat filename|mailx -s subject mailid HTH GovindanK Hi List I tried the following stuff but it says Service Unavailable. $mail -s Test Subject [EMAIL PROTECTED] body line1 body line2 Ctrl-D What should i do to make email stuff work? 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: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
question about migrating to 9i
Im not going to physically do the migration, but I want to make sure certain features are set up. Let me know if Im missing any of the basics(anything that is a pain to add on my own later). Locally Managed tablespaces are the default right? Automatic Segment Allocation Undo Tablespace SPFILE any other goodies Im forgetting? Just basic settings. rest I can do myself.
RE: question about migrating to 9i
Ryan If you (or whoever) is using dbca, I believe all this is configured automatically. But watch the block size. That is the only thing you can't change later. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 09, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Im not going to physically do the migration, but I want to make sure certain features are set up. Let me know if Im missing any of the basics(anything that is a pain to add on my own later). Locally Managed tablespaces are the default right? Automatic Segment Allocation Undo Tablespace SPFILE any other goodies Im forgetting? Just basic settings. rest I can do myself. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to send an email from unix command line?
If you wanted to send as an attachment use 'elm' Madhu Reddy -Original Message- Sent: Tuesday, September 09, 2003 9:04 AM To: Multiple recipients of list ORACLE-L Hi List I tried the following stuff but it says Service Unavailable. $mail -s Test Subject [EMAIL PROTECTED] body line1 body line2 Ctrl-D What should i do to make email stuff work? 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: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: overloading and = comparisons in SQL
Boivin, Patrice J wrote: I don't know what to think re. this. There is a view here that produces an error, I identified why -- in one AND clause a number(9) datatype column is being joined with a varchar2(50) datatype column. The developer of this code says that this used to run, there must be something wrong with the server. I want to verify... Is there any kind of overloading invoked automatically when Oracle compares columns of different datatypes? i.e. if the varchar2(50) column only contains numbers, would Oracle convert it automatically to number before making the comparison? (My intuition says: NO. ) Patrice. Well, actually your intuition is wrong. When you have char_col = number_constant Oracle makes it to_number(char_col) = number_constant (the famous great example 'my column is indexed and yet it's damn slow - Ooops forgot the quotes') If your column actually only contains number without any numerical meaning (like EMPNO), no problem (that is, you don't care about speed, do you?). If it may contain '???' or '***', if other screening conditions make you skip over the 'offending' (for the to_number()) line, you may notice nothing. Now suppose that the execution plan changes, and you're toast. I guess that it's what happened to you. I have for some time wondered about the deep reason behind the to_number() applied to the characters rather than a to_char() applied to the numbers, which would have looked a safer bet, conversion-wise. My guess is that it comes from the sign - a to_char() applied to a number puts a space before it, just in case a sign would be needed, and therefore it becomes much more difficult to get a match in the equality. I can imagine people frantically ringing the support (in those pre-TAR days), saying 'The join doesn't work!!!'. There is also the NLS consideration (virgule ...) but I have always known this behaviour, even at a time when Oracle was slowly awaking to the existence of a world outside California and NLS was, to say the least, rudimentary. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: overloading and = comparisons in SQL
Courtesy Julian Dyke ( http://www.juliandyke.com ): SET SERVEROUTPUT ON DECLARE err_msg VARCHAR2(120); BEGIN dbms_output.enable (100); FOR err_num IN 1..10999 LOOP err_msg := SQLERRM (-err_num); IF err_msg NOT LIKE '%Message '||err_num||' not found%' THEN dbms_output.put_line (err_msg); END IF; END LOOP; END; / At 01:59 PM 9/9/2003 -0800, you wrote: where can i find a list of sqltrace events? seems that 10053 and 10046 are well documented on hotsos. how many are there? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 5:39 PM Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: question about migrating to 9i
Little tidbits I kind of like is setting a default temporary tablespace and setting it in the create database statement. You can also change the sys and system passwords in the create database statement. Plus, you can create the undo tablespace there too. I seem to be creating a lot of 9i databases around here right now and that stuff comes in kind of handy. :) --Walt Weaver Bozeman, Montana -Original Message- From: Ryan [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 3:59 PM To: Multiple recipients of list ORACLE-L Subject: question about migrating to 9i Im not going to physically do the migration, but I want to make sure certain features are set up. Let me know if Im missing any of the basics(anything that is a pain to add on my own later). Locally Managed tablespaces are the default right? Automatic Segment Allocation Undo Tablespace SPFILE any other goodies Im forgetting? Just basic settings. rest I can do myself.
Re: overloading and = comparisons in SQL
Wow. Extremely simple and extremely nice :) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 1:24 AM Courtesy Julian Dyke ( http://www.juliandyke.com ): SET SERVEROUTPUT ON DECLARE err_msg VARCHAR2(120); BEGIN dbms_output.enable (100); FOR err_num IN 1..10999 LOOP err_msg := SQLERRM (-err_num); IF err_msg NOT LIKE '%Message '||err_num||' not found%' THEN dbms_output.put_line (err_msg); END IF; END LOOP; END; / At 01:59 PM 9/9/2003 -0800, you wrote: where can i find a list of sqltrace events? seems that 10053 and 10046 are well documented on hotsos. how many are there? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 5:39 PM Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Antw: Database Link
That's a classic SQL*Net name resolution error. Something is not configured properly. I've had links that went both ways and the only problem was with the TIMESTAMP data type because 8.1.7 didn't know what to make of it. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hamid Alavi Sent: Tuesday, September 09, 2003 5:50 PM To: Multiple recipients of list ORACLE-L Subject: RE: Antw: Database Link Yes I also have one from 9 to 8 but still the same error??? -Original Message- [mailto:[EMAIL PROTECTED] Sent: Monday, September 08, 2003 11:49 PM To: Multiple recipients of list ORACLE-L Hi Hamid, excuse me: AARRRGGHH! Ok, feeling better now. You can't use the db link this way. You have to create one on the 9i server that points to the 8i database. hth, Guido [EMAIL PROTECTED] 08.09.2003 23.39 Uhr Dear List, I have two database one on 8.1.7.4 on sun Solaris 8.2 and another one on oracle 9.0.1(two separate box) I have created a database link under oracle 8 to oracle 9 database it's working fine from 8 to 9, but when I try to use this link from 9 to 8 it's failed to ORA-12154. Any idea what could be this?? Thanks allot for your help. Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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: OT: Oracle 9iOAS install help needed
are you using the full host name? webbox.mycompany.com? Is iasdb or whatever you named your infrastructure instance up and running? [EMAIL PROTECTED] 9/9/2003 8:59:26 AM Hi All,I am trying to install Oracle 9iAS on Win 2000I installed Infra structure successfully. While trying to install nextcomponent OAS with BI/Forms I get a messageExisting Oracle9iOAS Single Sign-On. Enter hostname and port number ofexisting Single Sign-On. Heck I do not knowif it installed. I assume it is since infrastructure is installed.Obviously I am a first timer in OAS. I have about 300 pages ofdocumentation but I can find nothing to troubleshoot. Does anyone have anyexperience they can share or URL's.ThanksRick-- 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.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: EM To Go
Dick, The obvious questions are: 1) what does it monitor? 2) what problems does it diagnose and fix on its own? Jared On Mon, 2003-09-08 at 13:14, Goulet, Dick wrote: Binley, I've spent more time than I care to remember in reactive mode. It stinks, which is most likely why I wrote my own database monitor 10 years ago. At least when it sees a problem it's 4 or more hours into the future before the end users know it's going to happen. And at that, 70% of the time that homegrown monitor fixes the issue on it's own. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, September 08, 2003 3:09 PM To: Multiple recipients of list ORACLE-L NAW, Sounds like someone else needs to get a real production support job. Production issues ALL fall into one bucket, I needed to do something 10 minutes ago. If you think like that, jokingly or otherwise, you are likely to lock yourself into reactive mode versus proactive mode. I leave you to interpret that how you like. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: overloading and = comparisons in SQL
example try then. Note that Oracle can't use indexes in joins for implicitly or explicitly converted data - unless you have relevand function based indexes there... So, you might have problem in your design. Just a little clarification to my own post just in case: The index can not be used in a join for the column that gets converted, either implicitly or explicitly, unless there is a corresponding function based index on the column. But other table in join, which' column isn't converted, can very well be looked up using index if optimizer chooses so. Cheers, 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: How to send an email from unix command line?
Or check out mpack Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan Madhusudana.Reddy@ bestbuy.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: How to send an email from unix command line? com 09/09/2003 04:24 PM Please respond to ORACLE-L If you wanted to send as an attachment use 'elm' Madhu Reddy -Original Message- Sent: Tuesday, September 09, 2003 9:04 AM To: Multiple recipients of list ORACLE-L Hi List I tried the following stuff but it says Service Unavailable. $mail -s Test Subject [EMAIL PROTECTED] body line1 body line2 Ctrl-D What should i do to make email stuff work? 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: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 10g
did oracle provide you with documentation on these tools or just the 10g database and you had to find it all yourself? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 5:39 PM ADDM (pronouned Adam) is - as I wrote a minute ago - Statspack++ - for what it's worth. Of course you can't tell a damned thing about performance problems from system-data. Unless there's only one and the same user on the system in the observation internval. Active Session History (ASH), however, is a different story. Here they collect (down to every second) data about each session and what it spent its time doing. That's 10046 stuff being sampled in memory structures and stored in the repository in the SYSAUX tablespace. Very cool. Gaja will talk about it at our Database Forum - probably the day after he stars in BAARF. The Musical. Jesse, Rich wrote: Sweet! Oracle's Kumar likens ADDM to 'a genie in your database-if you have a performance problem, you just ask the database what the problem is and it automatically analyzes the complete database system and comes up with recommendations.' sarcasmNo more SQL tuning! No more STATSPACK! No more OEM/DBMS jobs! Wait a minute...no more DBA? Uh-oh./sarcasm I'm sorry Dave. I can't close the pod bay instance. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 2:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: 10g Correct. You can follow his announcement on www.Oracle.com at 2PM PDT. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 10g
It will even - in EM - highlight if an execution plan hash value changed. We did that 2 years ago in Perl for Oracle DBA's :) Jared Mogens Nørgaard [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/09/2003 02:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: 10g It's also called Graham in a Box internally in Development because Graham Wood put some effort into it. It's Statspack on steroids plus more, but it will of course still be as useless as Statspack wrt system-wide measurement data. It does contain the SQL stuff if you ask it to, and that's useful. It will even - in EM - highlight if an execution plan hash value changed. The execution plan hash value was put into Statspack by Graham in 9i, but now it gets highlighted if it changed. Mogens Tanel Poder wrote: Oracle's Kumar likens ADDM to 'a genie in your database-if you have a performance problem, you just ask the database what the problem is and it automatically analyzes the complete database system and comes up with recommendations.' If this works like Oracle Expert, then it's recommendations are worthless. Tanel. -- 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).
Re: 10g
I have done it in Word using ctrl-B for few times ;) Tanel. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 10, 2003 2:04 AM Subject: Re: 10g It will even - in EM - highlight if an execution plan hash value changed. We did that 2 years ago in "Perl for Oracle DBA's" :) Jared Mogens Nørgaard [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/09/2003 02:34 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: 10gIt's also called "Graham in a Box" internally in Development because Graham Wood put some effort into it. It's Statspack on steroids plus more, but it will of course still be as useless as Statspack wrt system-wide measurement data. It does contain the SQL stuff if you ask it to, and that's useful. It will even - in EM - highlight if an execution plan hash value changed. The execution plan hash value was put into Statspack by Graham in 9i, but now it gets highlighted if it changed.MogensTanel Poder wrote:"Oracle's Kumar likens ADDM to 'a genie in your database-if you have aperformance problem, you just ask the database what the problem is and itautomatically analyzes the complete database system and comes up withrecommendations.'" If this works like Oracle Expert, then it's recommendations are worthless.Tanel. -- 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.comSan Diego, California-- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: How to send an email from unix command line?
Or telnet to your SMTP gateways port 25 and start scribbling keywords like helo and rcpt etc... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 2:44 AM Or check out mpack Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan Madhusudana.Reddy@ bestbuy.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: How to send an email from unix command line? com 09/09/2003 04:24 PM Please respond to ORACLE-L If you wanted to send as an attachment use 'elm' Madhu Reddy -Original Message- Sent: Tuesday, September 09, 2003 9:04 AM To: Multiple recipients of list ORACLE-L Hi List I tried the following stuff but it says Service Unavailable. $mail -s Test Subject [EMAIL PROTECTED] body line1 body line2 Ctrl-D What should i do to make email stuff work? 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: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
imp with dd pipe
Hi Friends, I exported with full=y my whole database(on AIX5.1,oracle8174), I exported with pipe and dd (bs=65536k)commands, Export went very well. But my problem now Iamimporting back with tables=mytable its just sitting there? with out any response. IfI query osits showing its running.. Iam trying toimport a particular tableI did't see any response.My parfile options are userid=u/p tables=mytable ignore=y commit=y buffer=400 indexes=n I tried to change block_size for dd command, But some times it worked, some times not. I tried to import one row table giving block_size 32k, its imported!! But for mytable its big with 40Millon rows with avg row size 300bytes.But 0 block_size its gave error(pls remember I exported with bs=65536k) saying "read fail". Could you people suggest any ideas? TIA Peter. Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software
Re: imp with dd pipe
Perhaps you could include the export command line. I'm having a difficult time understanding why you would use dd with export. Jared venkat Rama [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/09/2003 05:49 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:imp with dd pipe Hi Friends, I exported with full=y my whole database(on AIX5.1,oracle8174), I exported with pipe and dd (bs=65536k)commands, Export went very well. But my problem now Iam importing back with tables=mytable its just sitting there? with out any response. If I query os its showing its running.. Iam trying to import a particular table I did't see any response. My parfile options are userid=u/p tables=mytable ignore=y commit=y buffer=400 indexes=n I tried to change block_size for dd command, But some times it worked, some times not. I tried to import one row table giving block_size 32k, its imported!! But for mytable its big with 40Millon rows with avg row size 300bytes. But 0 block_size its gave error(pls remember I exported with bs=65536k) saying read fail. Could you people suggest any ideas? TIA Peter. Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software
HTML Report Question
Hi DBAs! I am trying to generate an HTML report, and send it through the mail in HTML format. Only one problem...Outlook thinks it's text not html, even though the first line of the report is html. I'm generating the report with... sqlplus -silent -markup HTML ON ...and then using mailx to send the output to my client mailbox. Any suggestions as to how I can make the mail come in as HTML? Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- 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).
RE: Weird ORA-00060 (deadlock) with pragma autonomous transaction
It is at work. I will bring it home (on floppy) and post it tomorrow. -Original Message- Henry Poras Sent: Tuesday, September 09, 2003 2:39 PM To: Multiple recipients of list ORACLE-L transaction Babette, Could you post the deadlock trace file please. Henry -Original Message- Babette Turner-Underwood Sent: Tuesday, September 09, 2003 12:09 AM To: Multiple recipients of list ORACLE-L We are getting a strange deadlock problem and I am having trouble understanding the cause and action. Metalink has not been too useful for this one. We have a procedure eg INS_REC that does an insert into table ABC. The procedure uses a pragma autonomous transaction. We have a package eg DO_SET_OF_WORK that selects from several tables and then based on the information selected will call the above procedure, along with several other procedures that will do inserts or deletes (on DIFFERENT tables). The package does opens a cursor to process all records selected. When we use pragma autonomous transaction AND commit in the procedure called, the package dies with an ORA-0060. When the pragma autonomous transaction is removed from the procedure, the package does not get a deadlock. There is only ONE user using this set of tables (in a separate schema from other users on the system) at the time this is occuring. I am puzzled. Another DBA suggested this may be related to FREELISTS, so I increased them for both the table and indexes that were being reported as deadlocking but it did not make any difference. Anyone have any other suggestions ? Thanks Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Weird ORA-00060 (deadlock) with pragma autonomous
We are on version 8.1.7.4 on the mainframe (OS390 platform) -Original Message- James Howerton Sent: Tuesday, September 09, 2003 10:05 AM To: Multiple recipients of list ORACLE-L What version are you on??? There is a bug in 9.2.0.3, I was getting this error regularly on my rman repository db when an rman resync was run. I've patched to 9.2.0.4 and the error has gone away. ...JIM... [EMAIL PROTECTED] 9/8/03 11:09:27 PM We are getting a strange deadlock problem and I am having trouble understanding the cause and action. Metalink has not been too useful for this one. We have a procedure eg INS_REC that does an insert into table ABC. The procedure uses a pragma autonomous transaction. We have a package eg DO_SET_OF_WORK that selects from several tables and then based on the information selected will call the above procedure, along with several other procedures that will do inserts or deletes (on DIFFERENT tables). The package does opens a cursor to process all records selected. When we use pragma autonomous transaction AND commit in the procedure called, the package dies with an ORA-0060. When the pragma autonomous transaction is removed from the procedure, the package does not get a deadlock. There is only ONE user using this set of tables (in a separate schema from other users on the system) at the time this is occuring. I am puzzled. Another DBA suggested this may be related to FREELISTS, so I increased them for both the table and indexes that were being reported as deadlocking but it did not make any difference. Anyone have any other suggestions ? Thanks Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Weird ORA-00060 (deadlock) with pragma autonomous transaction
Yes we have a commit in the procedure and we rollback if an exception is raised. That was one of the first things I looked at. It would have been nice if that was the only problem. - Babette -Original Message- Ryan Sent: Tuesday, September 09, 2003 12:29 AM To: Multiple recipients of list ORACLE-L transaction are you committing in the procedure with the autonomous transaction? do you have an exception block with a rollback? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 12:09 AM We are getting a strange deadlock problem and I am having trouble understanding the cause and action. Metalink has not been too useful for this one. We have a procedure eg INS_REC that does an insert into table ABC. The procedure uses a pragma autonomous transaction. We have a package eg DO_SET_OF_WORK that selects from several tables and then based on the information selected will call the above procedure, along with several other procedures that will do inserts or deletes (on DIFFERENT tables). The package does opens a cursor to process all records selected. When we use pragma autonomous transaction AND commit in the procedure called, the package dies with an ORA-0060. When the pragma autonomous transaction is removed from the procedure, the package does not get a deadlock. There is only ONE user using this set of tables (in a separate schema from other users on the system) at the time this is occuring. I am puzzled. Another DBA suggested this may be related to FREELISTS, so I increased them for both the table and indexes that were being reported as deadlocking but it did not make any difference. Anyone have any other suggestions ? Thanks Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: question about migrating to 9i
Ryan dbca is indeed available with Solaris. I used it today in fact. What I've learned about it is: - It runs in X-Windows. I don't have much expertise with X-Windows, but it seems to run fine from the Solaris console. - Unable to create a block size greater than 8k, at least what I've found. I believe the reason is that dbca doesn't create the data files, but has precreated files it just copies into place. That's my theory anyway. - All data files are created with autoextend on. But you can change that later. - The database is created with spfile which I don't like but it is easy enough to CREATE PFILE FROM SPFILE. - I am usually a skeptic of GUI tools, but I am really impressed with this tool. One alternative you could suggest to your production people is for them to use dbca on a test system to create a database close to the one you want. Then issue an ALTER DATABASE BACKUP CONTROLFILE TO TRACE. It creates a great script (two versions in one, actually) that you can review, edit, etc. This is an easy way to implement the 9i features you list without studying the manual for the syntax for each feature. Good luck, we production DBAs can be a touchy lot. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 09, 2003 5:55 PM To: Multiple recipients of list ORACLE-L they are doing it by hand i believe. no dbca. its a solaris system. dont think there is a dbca for solaris? Im not a production dba, so i dont know for certain,. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 6:14 PM Ryan If you (or whoever) is using dbca, I believe all this is configured automatically. But watch the block size. That is the only thing you can't change later. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 09, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Im not going to physically do the migration, but I want to make sure certain features are set up. Let me know if Im missing any of the basics(anything that is a pain to add on my own later). Locally Managed tablespaces are the default right? Automatic Segment Allocation Undo Tablespace SPFILE any other goodies Im forgetting? Just basic settings. rest I can do myself. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
imp with pipe and dd cmds
Hi Friends, I exported with full=y my whole database(on AIX5.1,oracle8174), I exported with pipe and dd (bs=65536k)commands, Export went very well. But my problem now Iam importing back with tables=mytable its just sitting there? with out any response. If I query os its showing its running.. Iam trying to import a particular table I did't see any response. My parfile options areuserid=u/ptables=mytableignore=ycommit=ybuffer=400indexes=n I tried to change block_size for dd command, But some times it worked, some times not. I tried to import one row table giving block_size 32k, its imported!! But for mytable its big with 40Millon rows with avg row size 300bytes. But 0 block_size its gave error(pls remember I exported with bs=65536k) saying "read fail". Could you people suggest any ideas? TIA Venkat Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software
Re: imp with dd pipe
Jared, My database size is big i.e more than 150GB, so Iam using pipe(mknod) feed thru dd input and output to tape, same way Iam importing back thru tape as input and pipe as a file input to imp. So Iam geting no response..I hope you understood now!! thanks [EMAIL PROTECTED] wrote: Perhaps you could include the export command line. I'm having a difficult time understanding why you would use dd with export. Jared venkat Rama [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/09/2003 05:49 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:imp with dd pipeHi Friends, I exported with full=y my whole database(on AIX5.1,oracle8174), I exported with pipe and dd (bs=65536k)commands, Export went very well. But my problem now Iam importing back with tables=mytable its just sitting there? with out any response. If I query os its showing its running.. Iam trying to import a particular table I did't see any response. My parfile options are userid=u/p tables=mytable ignore=y commit=y buffer=400 indexes=n I tried to change block_size for dd command, But some times it worked, some times not. I tried to import one row table giving block_size 32k, its imported!! But for mytable its big with 40Millon rows with avg row size 300bytes. But 0 block_size its gave error(pls remember I exported with bs=65536k) saying "read fail". Could you people suggest any ideas? TIA Peter. Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design software Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software
Oracle 11i
I would like to evaluate Oracle 11i. Could any body let me know what are pros and cons between Oracle 11i and Oracle Collaboration Suite? Is there any place where I can download Oracle 11i and related documents for trial? I can not find them on Oracle web site. Thanks for any inputs in advance. Nancy _ Send and receive larger attachments with Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anna Li INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 11i
Heh,heh forget it, they are very different products - Collaboration Suite is for e-mail, calendar sharing, messaging, file storing and conferencing. Oracle E-Business Suite 11i is an integrated ERP, CRM, MFG, yadda-yadda package, which doesn't help you with your e-mails or videoconferences, but helps you out when you're a big very complex company and you want to automate your processes in your company. (Well, that's the idea anyway). You can't download 11i, you can order it for evaluation from Oracle, it's about 50 CD (when the heck will they put it on DVD?), but you have to be a fairly serious company for getting the eval. Cheers, Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 5:24 AM I would like to evaluate Oracle 11i. Could any body let me know what are pros and cons between Oracle 11i and Oracle Collaboration Suite? Is there any place where I can download Oracle 11i and related documents for trial? I can not find them on Oracle web site. Thanks for any inputs in advance. Nancy _ Send and receive larger attachments with Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anna Li INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: imp with pipe and dd cmds
Are you sure that your exportfile is intact, that it was saved fully and correctly to tape and it is read fully and correctly from tape. And it is passed fully and correctly to the pipe? Shouldn't you have used exp with pipe and split for this purpose? Tanel. - Original Message - From: venkat Rama To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 10, 2003 5:09 AM Subject: imp with pipe and dd cmds Hi Friends,I exported with full=y my whole database(on AIX5.1,oracle8174), I exported with pipe and dd (bs=65536k)commands, Export went very well. But my problem now Iam importing back with tables=mytable its just sitting there? with out any response. If I query os its showing its running..Iam trying to import a particular table I did't see any response. My parfile options areuserid=u/ptables=mytableignore=ycommit=ybuffer=400indexes=nI tried to change block_size for dd command, But some times it worked, some times not. I tried to import one row table giving block_size 32k, its imported!! But for mytable its big with 40Millon rows with avg row size 300bytes. But 0 block_size its gave error(pls remember I exported with bs=65536k) saying "read fail". Could you people suggest any ideas?TIA Venkat Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design software
Re: Oracle 11i
The 11i docs, however, are available from docs.oracle.com. Latest version is 11.5.9. Tanel. You can't download 11i, you can order it for evaluation from Oracle, it's about 50 CD (when the heck will they put it on DVD?), but you have to be a fairly serious company for getting the eval. Cheers, Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 5:24 AM I would like to evaluate Oracle 11i. Could any body let me know what are pros and cons between Oracle 11i and Oracle Collaboration Suite? Is there any place where I can download Oracle 11i and related documents for trial? I can not find them on Oracle web site. Thanks for any inputs in advance. Nancy _ Send and receive larger attachments with Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anna Li INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).