Search Discussions

98 discussions - 519 posts

  • So, I am getting this error on one of our virtual Linux servers: ORA-00210: cannot open the specified control file ORA-00202: control file: '/u01/app/oracle/datafiles/devdb/control01.ctl' ORA-27086 ...
    Andrew KerberAndrew Kerber
    Jul 26, 2011 at 7:38 pm
    Jul 30, 2011 at 3:02 pm
  • hi, I wonder do You experience such behavior of metalink as follows: When I leave metalink without logout and the next day try to login I have got the message below (even despite the fact I provide ...
    Remigiusz SokolowskiRemigiusz Sokolowski
    Jul 20, 2011 at 7:38 am
    Aug 4, 2011 at 4:50 pm
  • I just want to get an idea of where some of you fall on this statement... Truth Statement: Due to the differences in Oracle and Microsoft database products, an individual person cannot provide ...
    Taylor, Chris DavidTaylor, Chris David
    Jul 28, 2011 at 6:46 pm
    Jul 30, 2011 at 2:13 pm
  • Hi, What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? I have tried to find this since quite some time, Only thing I have found is that it is required for ...
    Paresh YadavParesh Yadav
    Jul 6, 2011 at 1:30 am
    Jul 13, 2011 at 9:59 pm
  • A table level export (via data pump) is failing with an ORA-01555. The curious thing (to me, anyway) about this is that the tablespace containing the table is set to READ-ONLY so I don't get what ...
    Brad PeekBrad Peek
    Jul 15, 2011 at 5:24 pm
    Jul 21, 2011 at 12:21 pm
  • So, today we had a very boring and long presentation by Quest about foglight... I must admit I spaced out 10 minutes in, so I honestly don't know what they are offering... they are saying that their ...
    Guillermo Alan BortGuillermo Alan Bort
    Jul 13, 2011 at 2:36 pm
    Jul 18, 2011 at 5:57 pm
  • About RMAN incremental updated backup, what 's the difference between using the �until time� clause in RECOVER COPY OF DATABASE and not including this clause? As a requirement, the customer is asking ...
    Mek sMek s
    Jul 13, 2011 at 7:41 am
    Jul 27, 2011 at 2:48 am
  • Platform Redhat Linux 3 Databases on 1 box 2 dbs upgraded ok the other one very old - was once v7 has hundreds of invalid objects and status of server component invalid. Can't downgrade as the other ...
    Howard LathamHoward Latham
    Jul 12, 2011 at 11:06 am
    Jul 17, 2011 at 11:19 am
  • So... I'm very annoyed today with one of out beloved developers... Due to some "security" measures (in fact it was a political issue) we had to do a database refresh and upgrade all in one step using ...
    Guillermo Alan BortGuillermo Alan Bort
    Jul 28, 2011 at 2:47 pm
    Jul 28, 2011 at 7:59 pm
  • We have been seeing lots of deadlock errors lately in load testing environments and they all have been due to enq: TX - allocate ITL entry. In reviewing the statspack report for the periods of ...
    Jul 20, 2011 at 10:37 pm
    Jul 25, 2011 at 9:10 pm
  • Is anyone else having problems with the ORA-600 lookup tool on MOS? I keep getting a page that says "null There was an error while rendering the article." Rodd Holman rodd.holman_at_gmail.com -- ...
    Rodd HolmanRodd Holman
    Jul 19, 2011 at 5:11 pm
    Jul 20, 2011 at 6:44 am
  • http://gigaom.com/cloud/facebook-trapped-in-mysql-fate-worse-than-death/ -- Stephane Faroult RoughSea Ltd <http://www.roughsea.com Konagora <http://www.konagora.com RoughSea Channel on Youtube ...
    Stephane FaroultStephane Faroult
    Jul 8, 2011 at 3:28 pm
    Jul 13, 2011 at 5:20 pm
  • We have ORACLE 10Gr2 and 11GR1 databases. We plan to clone database to other server and also rename it using "nightly backup". This nightly backup may be several weeks ago. In this case we can NOT ...
    Dba1 mccDba1 mcc
    Jul 5, 2011 at 8:01 pm
    Jul 6, 2011 at 1:41 pm
  • According to Note 1268725.1 and Bug 10263733, on RAC, the snapshot controlfile used during RMAN backup must be placed on shared storage. I've searched on MOS and Internet for what type of ...
    Yong HuangYong Huang
    Jul 20, 2011 at 8:35 pm
    Sep 7, 2011 at 7:48 pm
  • SQL connect scott/tiger_at_db11107 Connected. SQL select * from v$version; BANNER Oracle Database 11g Enterprise Edition Release - 64bit Production PL/SQL Release - Production ...
    Connor McDonaldConnor McDonald
    Jul 27, 2011 at 2:49 am
    Jul 27, 2011 at 7:41 pm
  • DB Version: OS: Hp-unix db_file_multblock_read_count 64 (4k block sizes. really old DB. no down time to re-create in an 8k block size DB) Not sure if these affect my current issue, but ...
    Dba DBADba DBA
    Jul 15, 2011 at 7:13 pm
    Jul 18, 2011 at 3:50 pm
  • Dear list, I messed up my ASM diskstring, after this and a reboot my cssd's do not start, because they can't find the voting files any more. Now one node is fencing, the other one just attempts to ...
    Martin KlierMartin Klier
    Jul 12, 2011 at 11:45 am
    Jul 12, 2011 at 7:51 pm
  • How do you download latest version of Oracle Database -- 11gR2 Sofware v3 ( on Solaris 10 ? -- or for that matter how about 11gR2 v2 ( on Solaris 10 ? I understand it is a "Full ...
    Jul 5, 2011 at 1:24 am
    Sep 2, 2011 at 4:33 pm
  • We're working on our patching strategy and I realize now that I'm a bit confused, or perhaps I'm now confused vs. not being confused before. Here's the note that has caused me some confusion: Note ...
    Taylor, Chris DavidTaylor, Chris David
    Jul 20, 2011 at 1:14 pm
    Jul 22, 2011 at 8:34 am
  • G'day The environment is APEX in Oracle 10g (Express initially), and Centos Directory Server 8.1. One of our Apex developers is trying to use LDAP to authenticate users to his application. The ...
    De DBADe DBA
    Jul 14, 2011 at 11:33 am
    Jul 15, 2011 at 2:45 am
  • I am not sure if this is documented. I am just curious. When Oracle does an inlist iterator, what is it doing under the cover. When I think "iterator", I think for i in array.start.. array.end run ...
    Dba DBADba DBA
    Jul 6, 2011 at 7:46 pm
    Jul 13, 2011 at 12:34 am
  • Now that something made me think of it again... I was a little late last year, (this a little more $). Anyone know anything about any symposiums this year. I kind of liked Michigans last year ...
    Jul 1, 2011 at 5:59 pm
    Jul 1, 2011 at 7:20 pm
  • It's my first post on oracle-l even if I follow you since two years by RSS :) and I'd like to say hello to all of you. I'm gathering informations about Oracle database embedded solutions and I ...
    Marco pbMarco pb
    Jul 15, 2011 at 1:07 pm
    Aug 3, 2011 at 1:26 pm
  • Hello oracle-l, We have an Oracle RAC on a 2-node Solaris 10 cluster on a NetApp FAS6080. This database is somewhat large, approximately 18 TB. We are using NetApp Snap Manager 3.1 for ...
    Lou AvramiLou Avrami
    Jul 26, 2011 at 8:34 pm
    Jul 31, 2011 at 7:44 am
  • Hi listers, Looking for a quick confirmation here - I think this should be possible, but like to confirm it before I start down this route. We had a SAN failure on a primary DB ( RAC). Failed ...
    Uzzell, StephanUzzell, Stephan
    Jul 26, 2011 at 3:22 pm
    Jul 27, 2011 at 9:20 am
  • *Hi Experts, In my RAC 11gR2 environments, we daily have these warnings in DBA_OUTSTANDING_ALERTS view. I would like to anticipate any kind of future problems, Could you please let me know how to ...
    Mek sMek s
    Jul 20, 2011 at 9:56 am
    Jul 20, 2011 at 4:31 pm
  • Hello, listers Could you recommend some GUI tool to display AWR data? Currently we are using SPViewer freeware version, and are planning to move to dbTrends (www.spviewer.com<http://www.spviewer.com/ ...
    Vladimir BaracVladimir Barac
    Jul 19, 2011 at 6:45 pm
    Jul 20, 2011 at 7:58 am
  • Hi I am upgrading from 11gR1 to 11gR2. As part of this, I am cleaning up some init.ora parameters that exists from the older versions. As per note 396009.1, the parameter db_cache_size should not be ...
    Kumar MadduriKumar Madduri
    Jul 17, 2011 at 8:35 am
    Jul 18, 2011 at 8:30 pm
  • List, We have a situation where a view is created on a table. The underlying column is defined as CHAR(18). We are doing this to a number of Oracle databases. On all of them the view creates ...
    Dennis WilliamsDennis Williams
    Jul 15, 2011 at 9:21 pm
    Jul 18, 2011 at 7:12 pm
  • If you have one server that has multiple databases with multiple listeners that have DIFFERENT IP addresses but co-exist on the same server, do you have to have separate Grid Control agents to ...
    P DP D
    Jul 15, 2011 at 3:09 pm
    Jul 15, 2011 at 5:27 pm
  • All, Oracle RDBMS on solaris 10 everytime I try running I hit this error . did a metalink search no luck . SQL exec dbms_workload_repository.create_snapshot; BEGIN ...
    K RK R
    Jul 8, 2011 at 1:49 pm
    Jul 13, 2011 at 10:13 pm
  • Howdy, In the throws of a DB upgrade from to, I see MOS 207303.1 and 1065024.1 say that an 11.2 client is not supported for connecting to a 10.1 DB. While I won't need that for our ...
    Rich JesseRich Jesse
    Jul 11, 2011 at 2:43 pm
    Jul 13, 2011 at 7:07 pm
  • Oracle Have a physical standby database on an alternate server/location which received a corrupt log file from the primary. Attempted to copy the logfile from the primary, but original file ...
    Jul 5, 2011 at 5:26 pm
    Jul 10, 2011 at 1:30 am
  • Is there a way to get notified that the shared pool is running out of memory before it actually occurs? We had a sudden unexpected spike of activity and the database was unable to allocate shared ...
    P DP D
    Jul 5, 2011 at 3:53 pm
    Jul 7, 2011 at 1:24 pm
  • There is some good, largely unwatched, stuff up at ...
    Niall LitchfieldNiall Litchfield
    Jul 5, 2011 at 7:40 am
    Jul 6, 2011 at 12:21 pm
  • So, how many of you guys have been told that your job description/job title is changing and then instructed review the job description and make changes as necessary? I understand that roles evolve ...
    Taylor, Chris DavidTaylor, Chris David
    Jul 21, 2011 at 6:25 pm
    Jul 31, 2011 at 4:13 pm
  • Hi Friends, I have to write a script shell to do a connection on the Oracle Database, execute a sql statment and generates a formated output file delimited by a specific separator. My issue is ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Jul 28, 2011 at 12:36 am
    Jul 29, 2011 at 12:18 am
  • We are going to use supplemental logging to work with Golden Gate. Golden Gate is going to be used to stream data to other Oracle Databases and to Teradata. I have some questions about supplemental ...
    Dba DBADba DBA
    Jul 19, 2011 at 2:48 pm
    Jul 22, 2011 at 2:30 pm
  • I have a two-node Oracle RAC environment running multiple databases on M3000 servers. Both servers are identical in configuration with the exception that server A has twice the amount of ...
    Hameed, AmirHameed, Amir
    Jul 19, 2011 at 1:59 pm
    Jul 20, 2011 at 6:02 pm
  • Many (many) years ago I used a report writer product called SQR, which in those days was owned and marketed by IBM (I think). It was a really neat piece of kit, enabling one to integrate the ...
    Peter RobsonPeter Robson
    Jul 15, 2011 at 8:29 pm
    Jul 18, 2011 at 3:18 pm
  • Hi all, I have a problem, cannot complete oracle recovery. Can anybody tell me what is wrong from the log I'm including? I see some Oracle errors there but it is not clear to me what exactly is ...
    Kedryna Marcin-HKP384Kedryna Marcin-HKP384
    Jul 15, 2011 at 1:57 pm
    Jul 15, 2011 at 8:01 pm
  • Hi, I am trying to apply the PSU, Patch 12311357 on the Single instance Standalone Grid Infrastructure; The Patch of the Grid infrastructure home ran successfully however, the Oracle database home ...
    Mek sMek s
    Jul 11, 2011 at 7:25 am
    Jul 11, 2011 at 10:53 am
  • Hi friends, I generated a file using imp / indexfile in order to know objects inside the .dmp. Then I saw that the initial value is too big to import it. How can I do an awk code in order to change ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Jul 10, 2011 at 11:55 am
    Jul 10, 2011 at 5:51 pm
  • Hi Friends, I have the following issue: I need to store a column VARCHAR2(45). If I am inserting data for first time I can, for example, save something like this ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Jul 2, 2011 at 6:46 pm
    Jul 3, 2011 at 12:13 am
  • I have been trying to chase down the same SQL being submitted against the same Solaris database from different query tools used in our organization. I have been striking out when trying to ...
    David MannDavid Mann
    Jul 21, 2011 at 6:34 pm
    Jul 23, 2011 at 6:31 pm
  • I am trying to test backup restore in this case, *why I am not able to restore my database to any point of time within the past 3 days of my recovery window?* I am changing my laptop time settings to ...
    Mek sMek s
    Jul 13, 2011 at 2:27 pm
    Jul 14, 2011 at 12:08 am
  • Well, since my company isnt able to bring on a new experience DBA until next year, I have been asked to train one of our system admins on the basic basics of oracle. Can someone point me to a good ...
    Andrew KerberAndrew Kerber
    Jul 13, 2011 at 2:52 pm
    Jul 13, 2011 at 4:54 pm
  • Database version: Oracle Database 11g Enterprise Edition Release - 64bit Production Platform: SunOS qadb120 5.10 Generic_138888-05 sun4v sparc SUNW,SPARC-Enterprise-T5120 In 11g, after DDL ...
    Du shenglinDu shenglin
    Jul 12, 2011 at 3:39 am
    Jul 12, 2011 at 4:45 pm
  • Someone, somewhere asked me if users connecting to a database using SID in the tnsnames file actually got connected to the SYS$USERS service. I have lost my note of where I was asked this, but ...
    Niall LitchfieldNiall Litchfield
    Jul 7, 2011 at 2:22 pm
    Jul 7, 2011 at 6:10 pm
  • hi, guys We ran into weird corruption in standby nodes in our first production oracle/linux deployment, which is pretty frustrate; Would appreciate if anyone else has ran into similar issues and ...
    Jul 6, 2011 at 3:03 pm
    Jul 7, 2011 at 3:45 pm
Group Navigation
period‹ prev | Jul 2011 | next ›
Group Overview
grouporacle-l @

168 users for July 2011

: 22 posts Guillermo Alan Bort: 21 posts Niall Litchfield: 19 posts Mek s: 17 posts Robert Freeman: 13 posts Saibabu Devabhaktuni: 12 posts Dba DBA: 11 posts Lange, Kevin G: 10 posts Taylor, Chris David: 10 posts kyle Hailey: 9 posts Tanel Poder: 9 posts Bobak, Mark: 8 posts David Fitzjarrell: 8 posts Jonathan Lewis: 8 posts Laimutis.Nedzinskas_at_seb.lt: 8 posts Mark W. Farnham: 8 posts Chitale, Hemant Krishnarao: 7 posts Connor McDonald: 7 posts Eriovaldo Andrietta: 7 posts Herring Dave - dherri: 7 posts
show more