Search Discussions

62 discussions - 255 posts

  • Hello all, I'm trying to do a PITR of an database. Backupsets were restored from tape and I registered them in our RMAN catalog. The restore works fine, but the recover fails with : unable ...
    Holvoet, JoHolvoet, Jo
    Aug 28, 2013 at 2:02 pm
    Aug 29, 2013 at 10:32 am
  • Dear experts, I am interested if anyone knows how to get in EM12c some functionality for 12c database. For example creating managing PDB , CDB and etc..... Thanks in advance. *-----------------* ...
    Aug 26, 2013 at 2:33 pm
    Aug 30, 2013 at 3:03 pm
  • Hi, I'm a newbie, so I'm sorry if question is very easy for yours or it isn't possible .. I have a production database in Oracle RAC 10g, and a test database in simple oracle 10g instance. Production ...
    Aug 12, 2013 at 8:32 am
    Aug 27, 2013 at 1:42 pm
  • Hi all, I am getting a strange issue. After impdp the schema of user plateau to a target database, plateau user is not able to insert data to one of the table owned by itself and getting the ...
    Lu JiangLu Jiang
    Aug 27, 2013 at 3:40 pm
    Aug 27, 2013 at 7:01 pm
  • Lists Could you please throw me some good advantages of an Oracle linux over a RH linux ? We have huge bunch of servers to migrate to linux from Solaris. We do have all kind of db HA technology ...
    Prabhu KrishnaswamyPrabhu Krishnaswamy
    Aug 22, 2013 at 9:10 pm
    Sep 10, 2013 at 1:58 am
  • Anyone know how/from where this value is sourced? is it from v$timer? it is time in microseconds since when? Plus i suspect it is platform dependent ... Thanks for your answers in advance Raj -- ...
    Aug 22, 2013 at 12:49 pm
    Aug 24, 2013 at 1:09 am
  • Hello Gurus, I have a task to purge aud$ table and it need to done in automated way on every month. Please help on sharing the purge script to schedule in db scheduler -Naga -- ...
    Nagaraj SNagaraj S
    Aug 9, 2013 at 4:55 am
    Aug 11, 2013 at 1:37 pm
  • List, As part of minimizing the downtime associated with some critical applications, we are exploring the available options. We are planning a hardware patch that will require us to shutdown the ...
    Ram KRam K
    Aug 4, 2013 at 11:48 pm
    Aug 7, 2013 at 6:42 pm
  • Have a question for the list. What do you think would be the best way to provide a set of schema-specific alerts with fairly sophisticated trigger and notification settings? OEM (or your general ...
    Jeremy SchneiderJeremy Schneider
    Aug 27, 2013 at 7:49 pm
    Aug 28, 2013 at 5:45 pm
  • Hi All. I have a problem with a SQL which is not giving a good cardinality estimate. The original SQL is pretty complex with many joins but I have managed to replicate the issue with a simple test ...
    Rajiv IyerRajiv Iyer
    Aug 29, 2013 at 11:44 am
    Aug 29, 2013 at 2:11 pm
  • Raj, You're almost there. Your trace file shows: *** 2013-08-23 15:24:25.823 But your calculation uses sysdate: ------------------begin cut------------------ with x as (select 1377285865823053 as t, ...
    Yong HuangYong Huang
    Aug 24, 2013 at 5:41 pm
    Aug 27, 2013 at 11:59 am
  • The door slams shut next Tuesday 03-Sep at midnight; please don't be on the wrong side of it... :-) http://www.rmoug.org/training/2014-abstract-submission/ The RMOUG "Training Days 2014" conference ...
    Tim GormanTim Gorman
    Aug 30, 2013 at 2:01 pm
    Sep 4, 2013 at 12:26 pm
  • Hey all, We're currently running our production 11.2 DBs on POWER6 (P550) and will be replacing the server soon. From what I've been able to gather, the raw single-threaded "throughput" improvement ...
    Rich JesseRich Jesse
    Aug 8, 2013 at 2:34 pm
    Aug 9, 2013 at 4:50 pm
  • Dog Days of Summer. Oracle on RHEL 6.3 ASM I'm trying to restore a single node of a RAC instance for DR practice. The controlfile is on tape. I started the instance in nomount, connected ...
    David BarbourDavid Barbour
    Aug 8, 2013 at 9:26 pm
    Aug 9, 2013 at 1:44 am
  • I have a requirement to copy 80 mllion rows table from PROD to DEV. This table is 28 GB in size, has 4 indexes built on its columns. 11gR2 (, Linux Redhat 6 environment. What would be the ...
    Aug 2, 2013 at 7:37 pm
    Aug 5, 2013 at 4:29 pm
  • Putting together a calendar of solid talks at OOW. THere is a publicly editable calendar spreadsheet here ...
    kyle Haileykyle Hailey
    Aug 28, 2013 at 9:22 pm
    Aug 30, 2013 at 2:37 pm
  • *Does anyone here know what he is talking about?* Possibly not your DW architect :-) Oracle has memory allocations for many things, for temporary workareas, for commonly accessed data etc... So if ...
    Connor McDonaldConnor McDonald
    Aug 26, 2013 at 12:59 pm
    Aug 27, 2013 at 11:36 pm
  • Env: Oracle 3 node RAC on RHELinux 64-bit Oracle Docs say: -------------------------------------------------------------------- Stage 8: Fetch Rows of a Query Result In the fetch phase, rows ...
    Christopher Taylor2Christopher Taylor2
    Aug 8, 2013 at 6:29 pm
    Aug 10, 2013 at 3:25 pm
  • Any knows of a 3rd party tool that can connect directly to an Oracle database and generate display html awr/ash reports. Looking for non-oem tools. -- ---------------------------------------- Thank ...
    Aug 6, 2013 at 4:44 pm
    Aug 8, 2013 at 1:44 am
  • Hi I have a doubt about the archive process. One redo log group have at least 2 members. When the ARCn process reads it to create the archive log, did it always reads member 1? or its random? Cause ...
    Ricard MartínezRicard Martínez
    Aug 1, 2013 at 6:13 pm
    Aug 2, 2013 at 10:41 am
  • Dear, I have a Data Guard in place. The PRIMARY is on Data Center 1 (DC1). The STANDBY is on Data Center 2 (DC2). In both Data Centers we have a tape device. I want to backup the archives from the ...
    Aug 27, 2013 at 4:38 pm
    Aug 30, 2013 at 10:42 am
  • Dear experts, We have 2 node RAC DB which we added to our EM12c. When I relocating the SCAN Listeners the EM12c didn't monitor the listeners anymore, manager shows wrong locations for SCAN ...
    Aug 26, 2013 at 8:40 am
    Aug 26, 2013 at 11:29 am
  • If I have a sql server table, can I create an oracle view of that table? ciao, Brian This email message may contain legally privileged and/or confidential information. If you are not the intended ...
    Zelli, BrianZelli, Brian
    Aug 21, 2013 at 5:18 pm
    Aug 21, 2013 at 6:02 pm
  • Hi list While I wait for support's answer on this, does anyone know if dbms_scheduler is supported in a snapshot standby database. All of our jobs have disappeared and we can't apparently create new ...
    Niall LitchfieldNiall Litchfield
    Aug 8, 2013 at 10:05 am
    Aug 8, 2013 at 1:27 pm
  • Env: Websphere 6.1 JVM using ojdbc5.jar connecting to Oracle database using JDBC Some of the JDBC threads hang and the JVM spins eating CPU until it's practically useless and requires ...
    Christopher Taylor2Christopher Taylor2
    Aug 1, 2013 at 8:48 pm
    Oct 11, 2013 at 10:41 am
  • I thought there was a master view that listed all the V$ and GV$ columns but I can't seem to put my hands on it now. Is there a way to generate this (specifically search for a column_name) on fixed ...
    Christopher Taylor2Christopher Taylor2
    Aug 28, 2013 at 12:48 pm
    Aug 28, 2013 at 3:39 pm
  • This is my first post in Oracle-l Freelists group. I have been following this list for quite some time and have learnt a lot about how dba's handle their day to day tasks. Thank You !! I have a ...
    Praveen RamananPraveen Ramanan
    Aug 21, 2013 at 6:44 pm
    Aug 22, 2013 at 9:59 pm
  • In some cases using RAM disk to store a temp tablespace can be beneficial for performance. It can improve your operations using temporary segments. And it is safe since it is only temporary files ...
    Gleb OtochkinGleb Otochkin
    Aug 21, 2013 at 1:28 pm
    Aug 22, 2013 at 12:26 am
  • I see these in the awr report itself, but could not locate it in any of the dba_hist_* views. Could not find a view to compute it as well. I have an awr report showing a database with '%Busy CPU' of ...
    Aug 9, 2013 at 4:39 pm
    Aug 10, 2013 at 3:18 pm
  • http://apex.oracle.com/pls/apex/f?p=34841:11 I have not installed EM 12c yet. I have literally not had the hardware to standup another DB to host this. Some new hardware is being setup now and I want ...
    Dba DBADba DBA
    Aug 8, 2013 at 4:00 pm
    Aug 9, 2013 at 3:07 pm
  • I am looking for a 32bit version of Oracle express to download. I think the 11G downloads are all 64 bit So does anyone know where I can still get Oracle 10G Express 32bit for Linux? John Dunn ...
    John DunnJohn Dunn
    Aug 7, 2013 at 9:56 am
    Aug 7, 2013 at 1:00 pm
  • Hello We are trying to move from modplsql to apex listener for our apex applications. We have 3 choices (a) use 10.1.3 application server: I can deploy it quickly because we already have custom oc4j ...
    Kumar MadduriKumar Madduri
    Aug 5, 2013 at 3:49 am
    Aug 6, 2013 at 1:40 am
  • Has anyone experienced ORA-600's using materialized views on the April 2013 PSU? If so, did you find a work around? Were there any relevant MOS docs you may point me to? RAC (3 node cluster ...
    Ryan JanuaryRyan January
    Aug 29, 2013 at 7:16 pm
    Aug 30, 2013 at 2:11 pm
  • Hi Mark, Good point about the online redo. The mantra "never back up your online redo logs" kind of makes you forget about them in these situations. I hadn't attempted a resetlogs though - never got ...
    Holvoet, JoHolvoet, Jo
    Aug 30, 2013 at 8:33 am
    Aug 30, 2013 at 9:29 am
  • I need to do some bin sorting. I saw Jonathan Lewis's page, the asktom discussion, and toms summary of it in Oracle Magazine. I need to do something a little different. I am trying to ...
    Dba DBADba DBA
    Aug 29, 2013 at 3:48 pm
    Aug 29, 2013 at 4:30 pm
  • Hi, I would like to know how can we measure response from all components which are collectively responsible to serve a user request. Like a user executes an update, how shall we identify time spent ...
    Aug 26, 2013 at 4:53 am
    Aug 26, 2013 at 8:17 am
  • Praveen: You have tangentially brought up one of my favorite topics: In general, if you want to definitely document something, then instrument your code. The most basic instrumentation for backups ...
    Mark W. FarnhamMark W. Farnham
    Aug 23, 2013 at 2:36 pm
    Aug 23, 2013 at 2:58 pm
  • Having some trouble with 2 agents I just deployed. Control box is 64bit W2008 running 12.1.0..3 EM. My summary page shows 2 platforms (w2008 and w2003). If I select Targets/Hosts I see 4 boxes. EM ...
    Storey, Robert (DCSO)Storey, Robert (DCSO)
    Aug 21, 2013 at 5:48 pm
    Aug 21, 2013 at 8:07 pm
  • The installation works perfectly until we are running the root.sh script. It does most of what it needs to but fails when trying to rmtcopy. "Failed to rmtcopy "/tmp/fileYX17Oj" to ...
    MacGregor, Ian A.MacGregor, Ian A.
    Aug 9, 2013 at 5:40 pm
    Aug 10, 2013 at 1:31 am
  • Andrew, I've been able to speed up the Oracle Installer by changing the encryption options in putty to Blowfish Start putty Load the session expand SSH In the encryption cipher selection box, click ...
    Steve GardinerSteve Gardiner
    Aug 8, 2013 at 7:56 pm
    Aug 9, 2013 at 1:30 pm
  • Interesting that when you go to an individual database, then click on Server, Jobs, you don't see any of the dbms_jobs jobs in the database, only the ones created using the newer dbms_scheduler. Has ...
    Patrice sur GMailPatrice sur GMail
    Aug 7, 2013 at 2:24 pm
    Aug 8, 2013 at 10:02 am
  • Straight forward error & resolution. In attempting to increase this parameter using 'alter system set ... scope=memory;', it worked successfully. 'show parameter' shows the new value. However, the ...
    Aug 6, 2013 at 4:41 pm
    Aug 6, 2013 at 4:44 pm
  • Hi, Is there any resource in the Oracle Spatial to re-scale a polygon, for example: Initial polygon: area 99.93235 length 39.98647 at point X=269138.90513 Y=175802.23506 Z= 0.00000 at point ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Aug 1, 2013 at 12:05 am
    Aug 1, 2013 at 12:38 am
  • Late last year, Oracle support assisted us with creating and publishing a master outline and then linking it to our EBS R12 system. User's are finally checking it out and noticed several topics were ...
    Jeffrey BeckstromJeffrey Beckstrom
    Aug 30, 2013 at 2:53 pm
    Aug 30, 2013 at 2:53 pm
  • On an 11.2 database, if I have a GRP and the destination fills up, I can dynamically point it to a larger filesystem, but will the flb files continue to generate into the new destination. Most of the ...
    Aug 28, 2013 at 7:27 pm
    Aug 28, 2013 at 7:27 pm
  • for linux 64 bit has been released on support.oracle.com. See patch 13390677. there are a few new features, including a backport of redaction from 12.1 ...
    Thomas RoachThomas Roach
    Aug 28, 2013 at 12:28 am
    Aug 28, 2013 at 12:28 am
  • I logged into forums.oracle.com, I was presented a Sign-in page, did that. After about 30 minutes, logged to MOS, I got another sign-in page. did that. Searched something, one of the link in the ...
    Aug 27, 2013 at 5:14 pm
    Aug 27, 2013 at 5:14 pm
  • Can you explain how you got these values? What query did you use? Just to be safe you might also want to include your version of Oracle RDBMS. Don. -- Don Seiler http://www.seiler.us -- ...
    Don SeilerDon Seiler
    Aug 26, 2013 at 4:12 pm
    Aug 26, 2013 at 4:12 pm
  • Oaktable World is on again. Oaktable World is the conference that grew out of it's underground roots formerly known as Oracle Closed World. Twice as many speakers this year including Tanel Poder, ...
    kyle Haileykyle Hailey
    Aug 23, 2013 at 4:32 pm
    Aug 23, 2013 at 4:32 pm
  • I've used MOS note #1062983.1 when recreating my ASM diskgroups - I haven't used it lately, but found it to be pretty reliable in the past ( days). It covers the difference between ...
    Andy ColvinAndy Colvin
    Aug 23, 2013 at 4:43 am
    Aug 23, 2013 at 4:43 am
Group Navigation
period‹ prev | Aug 2013 | next ›
Group Overview
grouporacle-l @

99 users for August 2013

Rjamya: 13 posts Holvoet, Jo: 11 posts Mark W. Farnham: 10 posts Outsider: 8 posts Hans Forbrich: 7 posts Peter Sharman: 7 posts Andrew Kerber: 6 posts Mark Bobak: 6 posts Christopher Taylor2: 5 posts Fmh: 5 posts Jonathan Lewis: 5 posts Niall Litchfield: 5 posts Norman Dunbar: 5 posts Patterson, Joel: 5 posts Tim Gorman: 5 posts Yong Huang: 5 posts Iggy Fernandez: 4 posts kyle Hailey: 4 posts Lu Jiang: 4 posts Oliver: 4 posts
show more