FAQ

Search Discussions

168 discussions - 995 posts

  • Hi Folks, Has anyone had much experience (good or bad) with running their Oracle DB's on the "vmware" product from VMware Inc. Speaking to local re-sellers there appears to be a division of opinon as ...
    O'Neill, S. \(Sean\)O'Neill, S. \(Sean\)
    Jul 19, 2007 at 1:18 pm
    Jul 30, 2007 at 7:06 pm
  • Update FYI: I just did a shutdown abort on 10.2.0.1 and got: ORA-01187: cannot read from file 201 because it failed verification tests. Had to drop and re-create the TEMP tablespace.... Joel ...
    Joel.Patterson_at_crowley.comJoel.Patterson_at_crowley.com
    Jul 2, 2007 at 7:06 pm
    Jul 7, 2007 at 1:59 am
  • RHEL4, Standard Edition 9.2.0.8 Can anyone point me to a good document for setting up a standby database for Standard Edition? I'm specifically looking for something that will tell me how to put in ...
    Sandra BeckerSandra Becker
    Jul 6, 2007 at 2:50 pm
    Jul 14, 2007 at 1:58 pm
  • I posed this question over at the oracle ASM forum as well. We are trying to wipe out ASM. We have been trying to follow a couple metalink notes, and threads both here and in oracle-l, not to mention ...
    Charles SchultzCharles Schultz
    Jul 24, 2007 at 2:53 pm
    Aug 1, 2007 at 2:21 pm
  • Hi All, Have a doubt on transaction isolation. My requirement is to query several tables several times inside a piece of code. The data needs to be consistent across multiple queries. The underlying ...
    DBA DeepakDBA Deepak
    Jul 10, 2007 at 9:09 am
    Jul 28, 2007 at 10:38 pm
  • Hello everyone, Over the years, I've read differing opinions on balancing the os cache and the database cache. Seems like I remember there were some advocates for minimizing the os cache and ...
    RobynRobyn
    Jul 9, 2007 at 6:03 pm
    Dec 21, 2007 at 10:36 am
  • Anyone else catch the presentation this morning? I caught some of it, but was on a conference call and getting the kids ready at the same time so I was in and out and only got brief notes. Besides, ...
    Allen, BrandonAllen, Brandon
    Jul 11, 2007 at 5:50 pm
    Jul 16, 2007 at 5:51 am
  • Hello List, I would like hear from you about the common mistakes by most of the DBAs do regarding the backup and recovery. I would think of the following: Never testing their backups. No good backup ...
    Syed Jaffar HussainSyed Jaffar Hussain
    Jul 4, 2007 at 12:23 pm
    Jul 9, 2007 at 2:32 pm
  • I seem to run into lots of issues using RMAN. Maybe I'm just unlucky with RMAN more frequently than others. Anyway an interesting issue popped up while trying to restore autobackup copies of an ...
    Jared StillJared Still
    Jul 31, 2007 at 7:11 pm
    Aug 2, 2007 at 4:02 pm
  • I had a weird situation where I had 3 PC and Oracle 10g Client is installed on them. I had installed one of the VB application on all three connecting to Oracle 10g DB. One PC is able to read the ...
    Sanjay MishraSanjay Mishra
    Jul 10, 2007 at 10:45 pm
    Jul 11, 2007 at 6:43 pm
  • 15

    Hi,

    Hi, We have a mixed environment of SQL Server and Oracle. Because of this, we now have a need to transfer table data between them. This would be on a continuing basis, probably on off-peak hours. Our ...
    Dennis CutshallDennis Cutshall
    Jul 16, 2007 at 4:02 pm
    Jul 17, 2007 at 5:31 pm
  • all, when adding the 3rd node, i got this error, but the installation shown me to run root.sh on ORACLE_HOME. my question, what is this script do ? Remote 'UpdateNodeList' failed on node: 'af-xxx2' ...
    Ujang JaenudinUjang Jaenudin
    Jul 9, 2007 at 6:45 am
    Jul 11, 2007 at 4:41 am
  • It is recommended to use two Gigabit Switches for RAC Node Interconnect communication to provide Redundancy and performance. Is there any setup required on beside configuring two interface like eth1 ...
    Sanjay MishraSanjay Mishra
    Jul 13, 2007 at 4:02 pm
    Jul 15, 2007 at 1:03 am
  • We have Oracle 10.2.0.3. There is one field, test1 that is definite as char(2). When we use 'where test1<88', it works fine in 9i, but we get 'ORA-01722 invalid number' error in 10g. Once I add ...
    David BoydDavid Boyd
    Jul 3, 2007 at 5:42 pm
    Jul 10, 2007 at 9:00 pm
  • Hi I have a batch process running and it seems that it's waiting for I/O all the time, the strange thing is it shows 400 seconds waits! EVENT CONSISTENT_GETS SPID WAIT_TIME SECONDS_IN_WAIT STATE SEQ# ...
    AmonteAmonte
    Jul 27, 2007 at 9:09 am
    Jul 30, 2007 at 5:27 pm
  • Hello to you all, I'm planning to activate the /3GB flag on a Windows server running Oracle Database, in order to extend the memory that can be used by Oracle. The server has the following ...
    Richard SaintsRichard Saints
    Jul 16, 2007 at 9:38 pm
    Jul 18, 2007 at 2:02 pm
  • Greetings, A couple of weeks ago I posted a query regarding difficulties I am encountering with a new installation such that the CRS is hanging intermittently. I am installing Oracle CRS 10.2.0.1.0 ...
    William WagmanWilliam Wagman
    Jul 30, 2007 at 3:55 pm
    Jul 31, 2007 at 5:53 pm
  • In the past few weeks I've been asked a number of times if the Sun T2000 is a viable Oracle database host. I've not had an opportunity to use this host so I'm reaching out to the user community for ...
    Greg RahnGreg Rahn
    Jul 18, 2007 at 9:47 pm
    Jul 22, 2007 at 1:16 am
  • How can I set my script to only keep one copy of a dump file? On Linux, I have the following line in the script (which is run nightly by cron). Yet I always seem to end up with 2 days worth of dmp ...
    J. DexJ. Dex
    Jul 17, 2007 at 2:51 pm
    Jul 17, 2007 at 9:31 pm
  • Greetings, I realize this is an Oracle list but I am hoping someone may be experienced enough with Linux to assist me here. I am attempting to install CRS 10.2.0.1.0 on two separate clusters both ...
    William WagmanWilliam Wagman
    Jul 11, 2007 at 4:03 pm
    Jul 11, 2007 at 10:48 pm
  • Owner export taken on Solaris 8i. Owner import done on Solaris 9i. Just rebuilding a database after a major controller corruption on a Solaris 8i database on the weekend. We needed to get a business ...
    Michael McMullenMichael McMullen
    Jul 4, 2007 at 12:40 pm
    Jul 5, 2007 at 1:51 pm
  • Hi, Having a bit of a problem with the CBO on 9.2.0.6, and I wonder if anyone can offer any advice? I have a query that looks like this: SELECT FPGI.FPGI_ID L_FPGI_ID, FPGI.FPGI_UMI_PAGE_NUMBER ...
    Bobak, MarkBobak, Mark
    Jul 10, 2007 at 8:54 pm
    Jul 26, 2007 at 12:54 pm
  • Hello to everyone We are planning to implement backups of our databases by utilizing snapshots feature of NetaApp filers. Are there some bad experiences with this NetApp's feature? Any hints, ...
    Vladimir BaracVladimir Barac
    Jul 12, 2007 at 6:07 am
    Jul 21, 2007 at 1:01 am
  • Hi all, I have got a column defined as NUMBER(20) and want to use bit functions on it. It seems that oracle bitand function is restricted in length. To give an example: select ...
    Stefan KuhnStefan Kuhn
    Jul 19, 2007 at 12:18 pm
    Jul 19, 2007 at 8:11 pm
  • Hi all, Can you please suggest me how to import the whole database from the export dump?( I mean the whole database). Thanks in advance, Ann -- http://www.freelists.org/webpage/oracle-l
    AnantAnant
    Jul 10, 2007 at 3:23 pm
    Jul 17, 2007 at 5:37 pm
  • I'm on an Oracle performance project and a project participant made a statement regarding measurement intrusion. Is the statement below accurate? "So the Heisenberg uncertainty principle mandates we ...
    Ted CoyleTed Coyle
    Jul 31, 2007 at 7:39 pm
    Aug 1, 2007 at 4:12 pm
  • Is there a way to change the "running services" status in the "Services" window from Automatic to Manual via a batch script? I have a batch script that uses oradim to shutdown/startup my 9207 ...
    J. DexJ. Dex
    Jul 18, 2007 at 8:03 pm
    Jul 19, 2007 at 9:11 pm
  • I've been spending some time on my system trying to do time accounting by comparing output from sqlnet trace files and 10046 traces. While doing this, I've realized I don't understand what is going ...
    Henry PorasHenry Poras
    Jul 13, 2007 at 6:15 pm
    Jul 17, 2007 at 11:12 pm
  • Hi group, I've got a very urgent installation request on one of the boxes with SUSE Linux 9- 64bit on that. I'm gonna install oracle 9.2.0.4 on that. I downloaded media from OTN but when I'm running ...
    Khan, Muhammad SKhan, Muhammad S
    Jul 27, 2007 at 3:25 pm
    Jul 31, 2007 at 5:58 pm
  • Hi Listers, I am working with a 2-node RAC system and we are thinking about using Data Guard's physical database feature for DR Do you know if we can use a single instance physical Standby database ...
    D chengD cheng
    Jul 27, 2007 at 7:50 pm
    Jul 29, 2007 at 8:01 am
  • Hi Stefan comments inline On 7/16/07, Stefan Kuhn wrote: It doesn't really make sense to consider a primary key for a view. A view is, simplifying a bit, a stored query, primary keys apply to the ...
    Niall LitchfieldNiall Litchfield
    Jul 16, 2007 at 11:22 am
    Jul 16, 2007 at 8:17 pm
  • Folks Need to Setup a 2 Instance ASM-RAC Database from scratch for an internal Test Benchmark. What Commands are used to create an External ASM Disk Group on Solaris 10? Any Additional Solaris ...
    VIVEK_SHARMAVIVEK_SHARMA
    Jul 9, 2007 at 8:08 am
    Jul 11, 2007 at 12:31 pm
  • Today one of my developers asked about having java code in our DB (10.2.0.2). He had already been playing around with it some, and found it much slower. Not really a scientific test, but he found ...
    Don SeilerDon Seiler
    Jul 3, 2007 at 9:56 pm
    Jul 7, 2007 at 9:09 pm
  • Hi all Not being a storage guru, I need some help I have been through the papers on racsig and done some googling "asm mirroring" and looking for product specific papers and cant find anything ...
    Peter McLartyPeter McLarty
    Jul 27, 2007 at 2:08 am
    Jul 29, 2007 at 12:14 am
  • Hi all, We've a 2-node RAC cluster with a database up and running using ASM and we're trying to add another database to the cluster via DBCA. It shows up a popup with the following message at the ...
    Ravi GaurRavi Gaur
    Jul 23, 2007 at 4:15 pm
    Jul 26, 2007 at 3:40 pm
  • Problem is simple - I need to get id (and other values by which I can not group) of rows with some maximum value. Below two examples, which do the thing any suppositions to use a "better"/other way ...
    Remigiusz SokolowskiRemigiusz Sokolowski
    Jul 24, 2007 at 1:58 pm
    Jul 25, 2007 at 9:03 am
  • Hello all, What are the limitations of materialized views across character sets? We will be upgrading the source database for many, many materialized views to Oracle 10.2.0.2 in a few months. We will ...
    RobynRobyn
    Jul 13, 2007 at 11:49 pm
    Jul 18, 2007 at 2:19 pm
  • I got one AIX server where I want to check as what are the Oracle installed in it. Is there I can get this information from any Log. There is not oratab in /etc or /var/opt/oracle. Is it possible ...
    Sanjay MishraSanjay Mishra
    Jul 12, 2007 at 4:30 pm
    Jul 13, 2007 at 2:17 pm
  • I want to install 10gR2 software and security Patch on a Linux box that is already running 9206 databases. Do I need to shutdown all of the 9206 databases before installing? (I know they need to be ...
    J. DexJ. Dex
    Jul 31, 2007 at 4:28 pm
    Jul 31, 2007 at 5:51 pm
  • Hi,I am in the process of setting up 2node RAC with the following components:Oracle 10g R2 RACOracle ClusterwareAIX 5L 5.3HP StorageASMFollowing are shared disks for storage:on Node1:/dev/rhdisk10 -- ...
    Venkata Giri PGVenkata Giri PG
    Jul 24, 2007 at 3:36 pm
    Jul 25, 2007 at 4:23 pm
  • I'm researching options to access an Informix database Right now, the process involves generating a flat text file, ftp and importing into our Oracle Database . I know I can create an external table ...
    BobBob
    Jul 23, 2007 at 11:44 pm
    Jul 25, 2007 at 2:27 pm
  • Hi listers, I have just read the Oracle White paper: http://www.oracle.com/technology/products/database/oracle11g/pdf/performance-11g-whitepaper.pdf On page 11 there is a following statement: " .. ...
    Milen KulevMilen Kulev
    Jul 20, 2007 at 9:19 am
    Jul 22, 2007 at 8:21 pm
  • Hi, We are trying to setup a subset rule on source table using 200+ in-list values and experiencing ORA-936 errors, not sure if it is a bug/restriction. Have checked Oracle docs and found no ...
    Krishna sarabuKrishna sarabu
    Jul 20, 2007 at 3:19 pm
    Jul 20, 2007 at 6:40 pm
  • Hi all, I have configuration of one primary and one physical standby. the backups are done on standby and recovery catalog is in use. if I connect using rman on primary and catalog, primary is ...
    Goran bogdanovicGoran bogdanovic
    Jul 18, 2007 at 9:07 am
    Jul 19, 2007 at 7:48 pm
  • Hi We are planning to use outlines while upgrading from 9.2.0.6 to 9.2.0.8 due to many SQL plan changes. Solaris 2.9, 9.2.0.8 Production is a busy 3 node RAC cluster, Applications version 11.5.8 ...
    Shamsudeen, RiyajShamsudeen, Riyaj
    Jul 18, 2007 at 4:23 pm
    Jul 19, 2007 at 5:17 pm
  • Folks How are the Oracle Cluster Registry (OCR) & Voting Disk (VD) to be Made Concurrently VISIBLE / Shareable to BOTH Database (Solaris 10) Nodes? Same is seemingly needed to initiate the CRS ...
    VIVEK_SHARMAVIVEK_SHARMA
    Jul 17, 2007 at 7:56 am
    Jul 18, 2007 at 8:08 am
  • We tried to setup ORACLE RAC under VMWARE. I follow document (http://www.oracle-base.com/articles/10g/OracleDB10gR2RACInstallationOnCento s4UsingVMware.php) setup share disk under VMware and use ...
    Dba1 mccDba1 mcc
    Jul 16, 2007 at 7:45 pm
    Jul 17, 2007 at 8:53 pm
  • hi all, I have a (two-fold) question about object dependencies when a particular object is recompiled: a query can be run pre and post object compilation to determine the objects that got invalidated ...
    Cosmin IoanCosmin Ioan
    Jul 11, 2007 at 5:06 pm
    Jul 16, 2007 at 7:12 am
  • Okay, I'm feeling rather stupid about these questions, but I figured I'd better hear from the experts. I've been tasked to work on another database project who's DBA has retired, but he still works ...
    Bill FergusonBill Ferguson
    Jul 12, 2007 at 12:35 pm
    Jul 12, 2007 at 2:29 pm
  • ��������Hello, gurus I have some problems with Oracle 10.2.0.3 on Windows 2003 32-bit. We have PGA_AGGREGATE_TARGET set to 350 MB and a SGA of 2200 MB. Some of the sessions are shared server ones ...
    Yavor IvanovYavor Ivanov
    Jul 10, 2007 at 1:21 pm
    Jul 11, 2007 at 2:58 pm
Group Navigation
period‹ prev | Jul 2007 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions168
posts995
users222
websiteoracle.com

222 users for July 2007

Alex Gorbachev: 38 posts Robert Freeman: 31 posts Alexander Fatkulin: 26 posts Kerber, Andrew W.: 26 posts Joel.Patterson_at_crowley.com: 25 posts Allen, Brandon: 23 posts Closson, Kevin A: 23 posts Niall Litchfield: 23 posts LS Cheng: 20 posts Bobak, Mark: 19 posts Jared Still: 19 posts Dan Norris: 18 posts Hallas, John (EXP N-ARM): 18 posts Randy Johnson: 18 posts Sanjay Mishra: 18 posts William Wagman: 16 posts Charles Schultz: 14 posts Hemant K Chitale: 13 posts Ujang Jaenudin: 13 posts Mark W. Farnham: 12 posts
show more
Archives