FAQ

Oracle > oracle-l > August 2010

Search Discussions

70 discussions - 153 posts

  • I have a few business users (who can't really do SQLplus), runs adhoc data pulls/validation. Currently they connect to the db using MS Access/ODBC to view the data. Constantly they run into ...
    Upendra NUpendra N
    Aug 17, 2010 at 4:02 am
    Aug 19, 2010 at 9:35 pm
  • Hi All, I have a doubt during the dataguard configuration in oracle 10g. We have primary server which is 32 bit Linux OS and 32 bit databae server and standby server which is 64 bit Linux OS and 64 ...
    KRISHNA MOORTHYKRISHNA MOORTHY
    Aug 18, 2010 at 3:33 am
    Aug 20, 2010 at 1:51 am
  • Hi, I am taking Materialized Views that were initially built on a 9i database and rebuilding them on a 10g database - verbatim. I am noticing that the performance is noticeably degraded. Checked out ...
    Chuck BoddyChuck Boddy
    Aug 19, 2010 at 3:47 pm
    Aug 19, 2010 at 7:13 pm
  • Hi all, (Oracle 11.1.0.7) We're using named services to implement application node affinity on a RAC database. These services were created using : srvctl add service -s srv_xxx -d rac11d -r rac11d2 ...
    Steve BaldwinSteve Baldwin
    Aug 17, 2010 at 12:48 am
    Aug 18, 2010 at 4:23 am
  • Gus! We have OEM repository on a different server than the database server. Once you get to know OEM, it is fantastic. It is all click and enter. That is all. Never put the OEM repository on the ...
    Ram SrinivasanRam Srinivasan
    Aug 8, 2010 at 1:29 pm
    Aug 10, 2010 at 7:13 am
  • Hello, I have tried to search in a clob column using the like operator, but I can see that it doesn't work as expected. Is there a way of using a longer kind of varchar2 column, say... one that ...
    Octavian RasnitaOctavian Rasnita
    Aug 30, 2010 at 4:56 pm
    Aug 31, 2010 at 3:56 pm
  • Sounds like a business case to upgrade to oracle 11 and use the active data guard option :) Stefan Stefan P Knecht CEO & Founder s_at_10046.ch 10046 Consulting GmbH Schwarzackerstrasse 29 CH-8304 ...
    Stefan KnechtStefan Knecht
    Aug 27, 2010 at 5:43 am
    Aug 30, 2010 at 5:30 am
  • Were any of the data files on the file system 'sparse'? Sparse files occur when disk blocks are empty, and rather than allocating a block on disk, the inode makes a note that the block is empty. In ...
    David RobertsDavid Roberts
    Aug 23, 2010 at 10:10 pm
    Aug 26, 2010 at 6:57 pm
  • �Hi all, Environment: Oracle 11.2 Error: ORA-06510: PL/SQL: unhandled user-defined exception We are having an issue with a vendor supplied package that is wrapped so I can not look at the source ...
    Jack van ZanenJack van Zanen
    Aug 24, 2010 at 6:10 am
    Aug 25, 2010 at 8:53 am
  • Dear list members, I would like to know if someone has an experience in the following solution. Configuration example : 2 IBM servers that are located on different blade chassis are connected to 2 ...
    Michael ElkinMichael Elkin
    Aug 5, 2010 at 4:52 am
    Aug 6, 2010 at 11:30 am
  • I'm having trouble working with a table of records. I am trying to do the following: SQL declare 2 type updated_contract_record_type is record (d_contract_id number, transaction_date date); 3 type ...
    Clay ColburnClay Colburn
    Aug 28, 2010 at 12:06 am
    Aug 28, 2010 at 2:38 am
  • Greetings All, Following is the part of trace file which was generated on Production DB, checked ORA-00600 lookup and it shows that the description on of this error is not yet published. Any idea or ...
    Arvind KumarArvind Kumar
    Aug 10, 2010 at 11:33 am
    Aug 25, 2010 at 8:31 am
  • -- http://www.freelists.org/webpage/oracle-l
    Ram RamanRam Raman
    Aug 19, 2010 at 9:35 pm
    Aug 20, 2010 at 9:54 am
  • I would strongly discourage the use of method_opt= 'FOR ALL INDEXED COLUMNS SIZE 1' unless you really know what you are doing and why you are doing it. More here ...
    Greg RahnGreg Rahn
    Aug 13, 2010 at 4:55 pm
    Aug 19, 2010 at 3:53 pm
  • Is that true if you are using external redundancy? On Fri, Aug 13, 2010 at 7:49 AM, David Robillard wrote: -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- ...
    Andrew KerberAndrew Kerber
    Aug 13, 2010 at 12:57 pm
    Aug 19, 2010 at 3:53 pm
  • A caveat; all of my practical knowledge of TSM/TDPO dates from 10 years ago and is unlikely to be accurate with regards the latest versions. First question: What version of TDPO are you using? (I was ...
    David RobertsDavid Roberts
    Aug 19, 2010 at 7:53 am
    Aug 19, 2010 at 1:05 pm
  • No, the error is in plain view. It won't compile. Try alter package user.air_life_usage compile body. then show errors. Dick Goulet Senior Oracle DBA/NA Team Lead PAREXEL International From ...
    Goulet, RichardGoulet, Richard
    Aug 10, 2010 at 10:49 pm
    Aug 11, 2010 at 3:32 pm
  • Personally, I've never understood the whole idea behind extended RAC. What's the point? Seems to me, you're taking an already complex technology (RAC), and adding another layer of complexity (the ...
    Bobak, MarkBobak, Mark
    Aug 5, 2010 at 12:36 pm
    Aug 8, 2010 at 4:10 am
  • Subodh, This is not really a question of accuracy. All of these tools serve different purposes. The patchsets.sh script simply tells you what family packs and minipacks are installed on your system, ...
    John PiwowarJohn Piwowar
    Aug 6, 2010 at 6:32 am
    Aug 6, 2010 at 12:17 pm
  • In another test run I was expecting the loading of that fact table to take more as the new partitons get added to that table with primary key enabled. But it turned out to be a flat (almost) time for ...
    Anupam PandeyAnupam Pandey
    Aug 4, 2010 at 5:02 am
    Aug 4, 2010 at 2:17 pm
  • John, These "dead" processes, are they processes on the db server or on the application server? In neither case it seems normal to me that a process keeps existing after a failed connection attempt, ...
    D'Hooge FreekD'Hooge Freek
    Aug 31, 2010 at 3:58 pm
    Sep 2, 2010 at 10:16 am
  • You use the bonding driver - just like you do for Ethernet, iirc. What problem are you experiencing? What do your ifcfg- files look like? Matt From: oracle-l-bounce_at_freelists.org On Behalf Of ...
    Matthew ZitoMatthew Zito
    Aug 31, 2010 at 8:36 pm
    Sep 1, 2010 at 2:56 pm
  • Comments inline: So this one is finding a literal '/' in the data. eg GF/2 ... and this one is doing something slightly different it is finding the Pattern 'GF_2' in the middle of a string. Normally ...
    Jared StillJared Still
    Aug 30, 2010 at 5:25 pm
    Aug 31, 2010 at 4:56 pm
  • OH, PLEASE not an IBM Blade center!! Those blades have the awfulness heat control mechanism there ever could be. Had one at my last gig & the darn thing kept overheating (in a 55 degree datacenter) ...
    Goulet, RichardGoulet, Richard
    Aug 27, 2010 at 2:15 pm
    Aug 30, 2010 at 7:54 am
  • Metalink has some good articles. In my practice I've encountered the following issues: "hw contention" event which is for example fixed in 10.2.0.4 but the fix is not enabled by default. You have to ...
    Laimutis.Nedzinskas_at_seb.ltLaimutis.Nedzinskas_at_seb.lt
    Aug 27, 2010 at 4:03 am
    Aug 27, 2010 at 4:45 am
  • See my post http://jhdba.wordpress.com/2010/01/06/flashback-disabled-automatically-a-minor-rant/ John From: oracle-l-bounce_at_freelists.org On Behalf Of Hsieh, Joan Sent: 24 August 2010 19:20 To ...
    John HallasJohn Hallas
    Aug 25, 2010 at 10:34 am
    Aug 27, 2010 at 4:27 am
  • I think it depends on if you are a senior or junior DBA. If you are junior DBA then I think courses are better. It gives you more exposure, more hands on, instructor one-on-one,etc. If your a senior ...
    DaveDave
    Aug 24, 2010 at 3:37 pm
    Aug 25, 2010 at 6:16 pm
  • Maureen, You'll want to take a look at: http://www.oracle.com/technetwork/database/features/availability/maa-wp-10gdataguardroletransitionss-133727.pdf It's old, but it discusses Streams and DG ...
    Job MillerJob Miller
    Aug 24, 2010 at 12:31 am
    Aug 25, 2010 at 8:49 am
  • Good golly this should not be that hard. I have two 2 node rac databases, RAC1 and PROD. RAC1 works fine, created at install. I create PROD manually. I can start and stop the database with srvctl ...
    Ethan PostEthan Post
    Aug 25, 2010 at 1:47 am
    Aug 25, 2010 at 2:28 am
  • Look for events with regional OUGs. Rocky Mountain OUG has a great event in February, UTah OUG has a good one in May, Kansas City OUG has had an event in the past and I hope they find a way to ...
    Daniel FinkDaniel Fink
    Aug 24, 2010 at 6:58 pm
    Aug 24, 2010 at 9:50 pm
  • Thanks for the sanity check Dan, I had not even looked at the name of the index - had I done so I might have had sense enough to not write all the stuff about rebuilding it. :) Jared Still ...
    Jared StillJared Still
    Aug 24, 2010 at 7:16 pm
    Aug 24, 2010 at 7:18 pm
  • MIke, 1)Client is going in wrong direction mostly, what is the size of total database, after breaking what it will be for each, which systems, applications will be running on it...merging of ...
    Subodh DeshpandeSubodh Deshpande
    Aug 19, 2010 at 7:10 am
    Aug 19, 2010 at 4:16 pm
  • I'm not familiar with login.sql, can you elaborate? -- http://www.freelists.org/webpage/oracle-l
    Clay ColburnClay Colburn
    Aug 17, 2010 at 10:50 pm
    Aug 17, 2010 at 11:04 pm
  • Someone said that 10g client is not compatible with windows 2008 OS, is that true? ciao, Brian This email message may contain legally privileged and/or confidential information. If you are not the ...
    Zelli, BrianZelli, Brian
    Aug 16, 2010 at 2:13 pm
    Aug 16, 2010 at 2:18 pm
  • I just installed Grid/ASM 11.2 and created a single disk group called DATA. Somehow it got created with Typical redundancy instead of external, so I have lost half my total storage space. I need to ...
    Ethan PostEthan Post
    Aug 13, 2010 at 10:48 pm
    Aug 14, 2010 at 12:29 am
  • Hmm, when I read Open SuSE then I immediately thought about "ah, somebody else using xen". But then you asked about virtual box. Is there a reason you don't use para-virtualisation? Performance might ...
    Martin BachMartin Bach
    Aug 4, 2010 at 8:37 pm
    Aug 4, 2010 at 8:37 pm
  • hi, All, We are testing HP DL380 G7 with Redhat Linux 5.4, load it with lots of very small SQL (through a jdbc client with 50~100~200 session) continuesly issue SQL to database server; It is 2 ...
    Zhu,ChaoZhu,Chao
    Aug 3, 2010 at 4:14 pm
    Aug 3, 2010 at 4:35 pm
  • hello dbas, Some one asked me that teradata can create index for only a subset of rows of a table. We have a huge table (5 billion) which is for few months of data but the data for most part is ...
    Dd yakkaliDd yakkali
    Aug 2, 2010 at 11:36 pm
    Aug 3, 2010 at 12:52 am
  • This issue was resolved, Just thought to share so that it will be helpful for someone else. Apparently all the trouble was due to a new juniper firewall installed which would fragment and drop the ...
    gidhin K. joygidhin K. joy
    Aug 2, 2010 at 8:37 am
    Aug 2, 2010 at 12:10 pm
  • Hello everyone, Who out there has done any flavour of the above upgrade and also moved some of the options to the SYSAUX tablespace. Metalink note 243246.1 talks about it, but i am missing ...
    Lyallbarbour_at_sanfranmail.comLyallbarbour_at_sanfranmail.com
    Aug 31, 2010 at 1:53 pm
    Aug 31, 2010 at 1:53 pm
  • CHANGE # 1 is op5.2, CHANGE # 2 is op5.1, CHANGE # 3 is op11.2, CHANGE #4 is op5.20. Â First of all, the four change vectors formed a redo record, the SCN recorded on the redo record is the commit ...
    崔华崔华
    Aug 31, 2010 at 12:14 pm
    Aug 31, 2010 at 12:14 pm
  • Hi William hacked?! cheers Sven -- http://www.freelists.org/webpage/oracle-l
    Sven AluoorSven Aluoor
    Aug 31, 2010 at 9:54 am
    Aug 31, 2010 at 9:54 am
  • Thanks Gilles & Martin, That was correct. May be I was bit reluctant to read over OUI summary screen :) Thanks! Gidhin -- http://www.freelists.org/webpage/oracle-l
    gidhin K. joygidhin K. joy
    Aug 28, 2010 at 3:10 am
    Aug 28, 2010 at 3:10 am
  • Also have a look on technet for the underlying o/s error (183) that might help. On 27 Aug 2010 08:15, "Martin Klier" wrote: Good CEST morning. I try to run two instances out of one oracle_home on a ...
    Niall LitchfieldNiall Litchfield
    Aug 27, 2010 at 7:37 am
    Aug 27, 2010 at 7:37 am
  • Is there something in v$archive_gap? What happened to the first log that did not get applied? Is it still on the primary server? Was it transferred to the standby server? Can you transfer and ...
    Ingrid VoigtIngrid Voigt
    Aug 27, 2010 at 7:17 am
    Aug 27, 2010 at 7:17 am
  • If its one of the new "master notes" I'm.rather impressed with them. On 26 Aug 2010 16:35, "Martin Bach" wrote: Hi there, There is a good note on mos about troubleshooting grid infrastructure ...
    Niall LitchfieldNiall Litchfield
    Aug 26, 2010 at 6:37 pm
    Aug 26, 2010 at 6:37 pm
  • This document by Mike Dietrich even mentions export/import of database version 6.0.36 to 11gR2 :) http://apex.oracle.com/pls/apex/f?p=20225:2:1434835130397970 -- Karl Arao karlarao.wordpress.com ...
    Karl AraoKarl Arao
    Aug 26, 2010 at 5:22 am
    Aug 26, 2010 at 5:22 am
  • Hey Evan, Coming from a sysadmin background (and programming before that), I think what you just accomplished is no small feat for a non-DBA, much less a non-Oracle non-DBA. Well done! Rich -- ...
    Rich JesseRich Jesse
    Aug 25, 2010 at 2:57 pm
    Aug 25, 2010 at 2:57 pm
  • DROP DATABASE INCLUDING BACKUPS with RMAN in Oracle 10g Release 2 http://luhartma.blogspot.com/2006/04/drop-database-including-backups-with.html Michael Dinh : XIFIN : 858.436.2929 Â NOTICE OF ...
    Michael DinhMichael Dinh
    Aug 24, 2010 at 8:17 pm
    Aug 24, 2010 at 8:17 pm
  • Very good morning Norman, Thanks for the reply first of all! I asked this question because this came up at two different places, one in a conversation with an oracle professional and the 2nd, in a ...
    Aman SharmaAman Sharma
    Aug 23, 2010 at 7:15 am
    Aug 23, 2010 at 7:15 am
Aug 2010
12
Group Navigation
period‹ prev | Aug 2010 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions70
posts153
users92
websiteoracle.com

92 users for August 2010

: 9 posts Niall Litchfield: 7 posts Jared Still: 6 posts Bobak, Mark: 4 posts Chuck Boddy: 4 posts Kenneth Naim: 4 posts Steve Baldwin: 4 posts Upendra N: 4 posts David Roberts: 3 posts Ethan Post: 3 posts Jack van Zanen: 3 posts Kellyn Pedersen: 3 posts KRISHNA MOORTHY: 3 posts Laimutis.Nedzinskas_at_seb.lt: 3 posts Stefan Knecht: 3 posts Subodh Deshpande: 3 posts Andrew Kerber: 2 posts Anupam Pandey: 2 posts Arvind Kumar: 2 posts Clay Colburn: 2 posts
show more
Archives