Search Discussions

71 discussions - 311 posts

  • How do people do proactive monitoring? We have certain database level metrics set in OEM that will alert us if the thresholds get exceeded. The idea is that if we start getting a lot of these alerts ...
    Armstrong-Champ, Joseph WilliamArmstrong-Champ, Joseph William
    Sep 19, 2013 at 1:55 pm
    Sep 25, 2013 at 12:21 am
  • -- http://www.freelists.org/webpage/oracle-l
    Karth PanchanKarth Panchan
    Sep 5, 2013 at 10:30 am
    Sep 9, 2013 at 8:49 pm
  • I thought and still think that restore validate command is good enough for us to make sure that all the blocks in the RMAN backups are intact. Is there really a need to physically restore the DB ...
    Hariharan, AbhishekHariharan, Abhishek
    Sep 22, 2013 at 6:47 pm
    Sep 29, 2013 at 2:22 am
  • I am helping a sysadmin archive a regulated system that is slated for retirement. Long story short is we have it up and running on a HP-UX emulator but have the network interfaces turned off. We also ...
    David MannDavid Mann
    Sep 12, 2013 at 3:07 pm
    Sep 14, 2013 at 2:00 pm
  • Hi all, I'm working on a Linux test RAC (I've been working with RAC on Windows for several years now, but RAC on Linux is a new beast to me). I've hit a bit of a challenge, and not sure if this is ...
    Uzzell, StephanUzzell, Stephan
    Sep 9, 2013 at 2:45 pm
    Sep 11, 2013 at 12:09 pm
  • Hi All, I have an Oracle 11g R2 over a windows server 2008 (am the first of hating Windows, but that's what I have...); it has 10 GB of SGA, 500 process limit -400 processes avg-, db on archive ...
    David Ramírez ReyesDavid Ramírez Reyes
    Sep 25, 2013 at 6:07 pm
    Sep 30, 2013 at 4:00 pm
  • Hi All, I have a system on 4-node RAC that I'm trying to help with. They have a process that inserts rows into a table. A database job then takes those rows and processes them into another ...
    Walker, Jed SWalker, Jed S
    Sep 6, 2013 at 3:56 pm
    Nov 22, 2013 at 6:06 pm
  • Hi, I ran a simple SELECT statement where I drove a FTS on a large table and then trace it at level 8. Below is the SQL statement: select /*+ full(MMT) */ count(*) from apps.mtl_material_transactions ...
    Hameed, AmirHameed, Amir
    Sep 13, 2013 at 7:48 pm
    Sep 14, 2013 at 8:36 pm
  • Hello, We have a user that wants to use transportable tablespaces to consistently refresh a query database for a set of users. (Oracle, will be soon) For example, they have 3 ...
    Michael SchmittMichael Schmitt
    Sep 5, 2013 at 3:50 pm
    Sep 7, 2013 at 11:55 am
  • Hi RAC gurus Few RAC question 1. If I had OCR/Voting Disk in ASM diskgroup with Normal Redundancy and three Disk defined in ASM Diskgroup creation are from three different SAN. Now question is that ...
    Sanjay MishraSanjay Mishra
    Sep 26, 2013 at 10:43 pm
    Sep 28, 2013 at 11:03 pm
  • Hi Need some help from Oracle RAC people who created the test environment on Linux using Oracle Virtual Box. Here is my configuration 1. Installed OEL 6 update 4 on Dell Server with software on ...
    Sanjay MishraSanjay Mishra
    Sep 25, 2013 at 3:21 am
    Sep 27, 2013 at 2:11 pm
  • Hi DBAs, I've an interesting situation here. I'm installing 11g ( on AIX 6.1 machine. It'd a 10g installation before. 11g is installed in different ORACLE_HOME. We normally create database ...
    Saad KhanSaad Khan
    Sep 18, 2013 at 6:33 pm
    Sep 18, 2013 at 10:04 pm
  • Dear, I want to install second EM12c and connect it to existing EM12c Oracle Database repository. Is it possible ? Can I keep two EM12c repository in one database ? The installation of repository ...
    Sep 3, 2013 at 10:05 am
    Sep 18, 2013 at 6:06 pm
  • Hi list, I'm a registered attendee of next week OOW. But since its my first participation, was wondering if any of the DBAs can give a snap of what to expect. I've an idea and my calendar is already ...
    Saad KhanSaad Khan
    Sep 17, 2013 at 2:09 am
    Sep 17, 2013 at 10:33 pm
  • Oracle 11 RH Enterprise Hello all -back from Holidays and trying to run a duplicate for standby script that has worked many time. Now rman is terminating with Starting Restore at 11-SEP-13 Aborted No ...
    Howard LathamHoward Latham
    Sep 11, 2013 at 10:29 am
    Sep 11, 2013 at 12:24 pm
  • G'day. I'm stumped about this one. We've got a few 11gR1 databases that have been in use for several years. They work well, had dbconsole configured but no management packs. Today I added them to the ...
    De DBADe DBA
    Sep 4, 2013 at 10:08 am
    Sep 6, 2013 at 2:40 am
  • We get a data feed from SQLServer to load into some oracle tables. On the Oracle side, the FK constraint is failing after the load. When reviewing the data that was sent, I discovered that: (parent ...
    Chris TaylorChris Taylor
    Sep 27, 2013 at 9:31 pm
    Sep 30, 2013 at 7:57 pm
  • Whenever I try to use the dbms_metadata.get_ddl the output is not valid. I think the issue must be terminal related. The docs say use these: SQL SET PAGESIZE 0 SQL SET LONG 1000000 SQL SELECT ...
    Ray StellRay Stell
    Sep 30, 2013 at 2:15 pm
    Sep 30, 2013 at 6:17 pm
  • Is there a way I can control users to limit the queries they run? Either by # of rows or time? Googling only seems to show how to do it IN a query. Brian This email message may contain legally ...
    Zelli, BrianZelli, Brian
    Sep 17, 2013 at 6:52 pm
    Sep 18, 2013 at 4:54 am
  • Thanks for taking the time to read this. I am new to CC, have used EM console before. Just installed EM12C (version 12 release 3) on OEL Linux dbuslnxoem01 2.6.39-400.109.4.el6uek.x86_64, running on ...
    Mike boliganMike boligan
    Sep 10, 2013 at 3:43 pm
    Sep 15, 2013 at 7:27 pm
  • I have a SQL statement that is part of a PL/SQL package. I have fudged values in the statement for privacy reasons. SELECT oel.header_id, oel.line_id, oel.org_id, oel.ordered_item ...
    Hameed, AmirHameed, Amir
    Sep 12, 2013 at 2:21 pm
    Sep 14, 2013 at 3:47 pm
  • column values looks like: SYSDATE+7/24 TRUNC(SYSDATE + 1) + 2.75/24 Required output: +7/24 +1 + 2.75/24 Thanks -- http://www.freelists.org/webpage/oracle-l
    Sep 13, 2013 at 10:13 am
    Sep 14, 2013 at 1:38 am
  • Hi Folks, We have a need to use V$_SEQUENCES.NEXTVALUE column in our custom programs to try and solve an issue that was introduced when we implemented RAC and is impacting our custom programs. Since ...
    Hameed, AmirHameed, Amir
    Sep 6, 2013 at 2:10 pm
    Sep 9, 2013 at 1:27 pm
  • I am working with OEL 6.4 to become familiar with the latest release. Does anyone know what group the iscsi initiator is in? In the past it was one of the options under one of the basic groups (such ...
    Andrew KerberAndrew Kerber
    Sep 30, 2013 at 2:26 pm
    Oct 1, 2013 at 1:18 pm
  • Goals/Givens: 1. Bash script 2. Solaris 5.10 3. Building this to run from Control-M job scheduler tool 4. hide the username/password from the command line (from ps -Aef) 5. parallelize the $sqlfile ...
    Chris TaylorChris Taylor
    Sep 25, 2013 at 4:56 pm
    Sep 25, 2013 at 6:45 pm
  • I have run into a problem with the 12c agent. Something happened with the file system, and most of the agent directories have been corrupted. I installed a new agent, but when it went in it showed as ...
    Andrew KerberAndrew Kerber
    Sep 18, 2013 at 4:19 pm
    Sep 19, 2013 at 4:05 pm
  • Hi We use Oracle At the moment I do data scrubbing with SQL scripts. The SQL commands quite simple. Now I need to give this task to customer. The customer understands very well the data, ...
    Lukas LehnerLukas Lehner
    Sep 16, 2013 at 8:05 am
    Sep 17, 2013 at 4:13 am
  • Regards, Amihay Gonen Oracle Domain Export -- http://www.freelists.org/webpage/oracle-l
    Amihay GonenAmihay Gonen
    Sep 22, 2013 at 3:08 pm
    Sep 22, 2013 at 10:07 pm
  • Some of the DBAs on here crossover between being DBAs and SAs. This is a question more for these guys. I am rather disturbed by what I wrote below. Oracle VMWare Esxi 4 CPU Server 7 VMs on ...
    Dba DBADba DBA
    Sep 17, 2013 at 8:04 pm
    Sep 18, 2013 at 7:44 pm
  • All, We are building some new systems and there have been concerns about performance. We would like to test the performance of the Netapp NAS that was chosen for the database files. Does anyone know ...
    Malcolm LawrenceMalcolm Lawrence
    Sep 10, 2013 at 2:50 pm
    Sep 11, 2013 at 4:33 am
  • Oracle on Linux (RH6). I have a Dataguard config with one primary, one physical standby and five snapshot standbys. The physical standby has 0 lag, and all of the five snapshot standbys are ...
    Don SeilerDon Seiler
    Sep 10, 2013 at 6:10 pm
    Sep 10, 2013 at 7:54 pm
  • We are thinking of implementing dataguard for several of our production databases, some in 10g, some in 11g. One of the colleagues is suggesting an idea of just having one unix server and install ...
    C PC P
    Sep 1, 2013 at 7:22 pm
    Sep 4, 2013 at 11:25 am
  • Hey all, I’ve just released DataWalker. It’s a data unloader utility and data block examination tool. Whilst it runs on Windows it can examine data files from any OS. You can get more info here ...
    Sep 25, 2013 at 2:11 am
    Oct 2, 2013 at 7:18 pm
  • Hi I had built the two node RAC using Virtual Box on Dell 2970 with 4G memory to each Node VM. when I tried to create Database, it basically hang at one point and stayed there for almost a day and ...
    Sanjay MishraSanjay Mishra
    Sep 30, 2013 at 6:23 pm
    Oct 1, 2013 at 1:30 am
  • Hi All I have just read through http://www.oracle.com/technetwork/database/features/availability/edition-based-redefinition-1-133045.pdf This looks damn interesting! But am thinking if at all anyone ...
    Edwin devadanamEdwin devadanam
    Sep 26, 2013 at 5:30 am
    Sep 27, 2013 at 8:21 pm
  • I could not make it to Oracle Openworld this year... So does anyone know if the Openworld handouts/presentations are available on the Oracle website? I poked around the Openworld site and I couldn't ...
    Grabowy, ChrisGrabowy, Chris
    Sep 25, 2013 at 10:36 pm
    Sep 26, 2013 at 11:51 am
  • I thought I remembered some discussion that the licensing for encryption of Oracle Net traffic in changed and that Advanced Security options was no longer required. I can't find anything ...
    Stephens, ChrisStephens, Chris
    Sep 24, 2013 at 6:19 pm
    Sep 24, 2013 at 6:59 pm
  • Good morning/afternoon/evening all A colleague is running into an issue installing GI on a pair of RH 6.3 nodes. cluvfy passes on both nodes, but the installer itself fails with INFO ...
    Niall LitchfieldNiall Litchfield
    Sep 17, 2013 at 1:30 pm
    Sep 19, 2013 at 2:46 pm
  • Oracle 11.1g Redhat Linux Enterprise I have now verified that this is not a box specific issue It happens on two boxes. "Aborted" message at beginning of duplicate database using rman. Now the big ...
    Howard LathamHoward Latham
    Sep 17, 2013 at 9:15 am
    Sep 17, 2013 at 10:51 am
  • Hi Limin We're a NFS and NetApp shop, but I've never tried this as we use Data Guard for DR. However, did you see this NetApp technical report: http://www.netapp.com/us/media/tr-3455.pdf? In the ...
    Austin HackettAustin Hackett
    Sep 12, 2013 at 8:15 pm
    Sep 16, 2013 at 7:55 pm
  • Dear, I am trying to set up add second OMS in my environment via Add Management Service<https://beanr-mocc101.anr.psaemea:7802/em/console/paf/procedureView?guid=D0A5F7717F9C14B7E0438741C00AB264 in ...
    Sep 13, 2013 at 3:15 pm
    Sep 16, 2013 at 1:53 am
  • Hello all, I’ve just released RedoWalker, a command line tool to dump DDL, INSERTS, UPDATES, DELETES and associated UNDO from the Oracle redo logs. It should work on Oracle 10g and later. It ...
    Sep 10, 2013 at 7:18 pm
    Sep 11, 2013 at 5:06 am
  • /ົ–z¯y£«iÉ^×OöÿOù 'õ<uÿ]ÿžŒ0{§©¢‚¶­zØb°0m¡¢âžìH®ŠßõÓýÿÓþQ -- http://www.freelists.org/webpage/oracle-l
    Sep 3, 2013 at 8:49 am
    Sep 6, 2013 at 2:57 pm
  • Hi, Our Oracle DBA Team is researching options to achieve the below goal - How can the Informatica ETL application be setup so that the ETL "WorkFlow name" & ETL "Session name" pass into the Oracle ...
    Scott L McMillanScott L McMillan
    Sep 4, 2013 at 10:40 pm
    Sep 5, 2013 at 7:32 pm
  • I saw this on the web a while back. I think either Tom Kyte or Connor McDonald write it. It was a simple test where multiple sessions are opened with an without bind variables. Starts with 1 session, ...
    Dba DBADba DBA
    Sep 3, 2013 at 4:16 pm
    Sep 3, 2013 at 5:20 pm
  • Dear list, Been awhile since posting here, hopefully this is something simple. I have a need for makefiles to be used to compile Oracle forms and menus. Seems to me I have seen or used to have a ...
    Jared StillJared Still
    Sep 12, 2013 at 12:51 am
    Sep 27, 2013 at 3:37 pm
  • I have a number of long technical word docs ... including screenshots of oracle installer etc ( inserted pictures into the word doc ). Some of these I want to eventually publish via google BlogSpot ...
    John HurleyJohn Hurley
    Sep 26, 2013 at 1:38 am
    Sep 26, 2013 at 4:57 pm
  • I've just going over the parameters which can be changed at PDB level (select * From parameter where ispdb_modifiable='TRUE';) ISPDB_MODIFIABLE VARCHAR2(5) Indicates whether the parameter can be ...
    Amihay GonenAmihay Gonen
    Sep 23, 2013 at 11:56 am
    Sep 23, 2013 at 12:07 pm
  • hello if anyone has installed Oracle R Enterprise on 11gR2, SLES 11 (with or without the Oracle R distribution) I would appreciate hearing about any issues or gotchas encountered. thanks in ...
    Norman CobleyNorman Cobley
    Sep 21, 2013 at 7:18 pm
    Sep 22, 2013 at 9:17 am
  • Folks, Has anyone come up with the pros and cons of various replication products to use in a DW? Comparison would have been made on license cost,complexity,implementation difficulties,knowledge ...
    Sep 14, 2013 at 1:01 am
    Sep 14, 2013 at 1:13 am
Group Navigation
period‹ prev | Sep 2013 | next ›
Group Overview
grouporacle-l @

117 users for September 2013

Martin Klier: 13 posts Maaz Anjum: 10 posts Hameed, Amir: 9 posts Sanjay Mishra: 9 posts Andrew Kerber: 8 posts Norman Dunbar: 8 posts Radoulov, Dimitre: 7 posts Rjamya: 7 posts Armstrong-Champ, Joseph William: 6 posts Jared Still: 6 posts Mark W. Farnham: 6 posts Outsider: 6 posts David: 5 posts Bobby Curtis: 5 posts David Fitzjarrell: 5 posts David Ramírez Reyes: 5 posts kyle Hailey: 5 posts Saad Khan: 5 posts Chris Taylor: 4 posts De DBA: 4 posts
show more