Search Discussions

106 discussions - 560 posts

  • We currently use ASM for all instances on a block storage SAN. The sysadmins and storage admins are migrating all 11g instances over to NetApp storage with Direct NFS (RHEL on VMWare is in the mix as ...
    Dana NibbyDana Nibby
    Aug 7, 2012 at 12:46 pm
    Aug 28, 2012 at 5:54 am
  • Hi list, I'm still coming up to speed with 11g and I just came across the new, seemingly undocumented, feature of "adaptive direct path reads*" for full table scans. I stumbled upon it because I've ...
    Allen, BrandonAllen, Brandon
    Aug 30, 2012 at 8:46 pm
    Oct 4, 2012 at 2:23 am
  • I believe that .tnsnames.ora (note the preceding dot) is also checked. If that isn't the culprit, have you tried running tnsping under truss to see what files are inspected? Dave .... -- ...
    David RobertsDavid Roberts
    Aug 21, 2012 at 2:54 pm
    Aug 22, 2012 at 1:28 pm
  • G'day, Yesterday the Unix sysadm rebooted a Sun M5000 on which I am running a Solaris11 zone with Oracle installed in it. ASM has 2 disk groups, each with 2 disks. Before the reboot we ...
    De DBADe DBA
    Aug 3, 2012 at 9:17 am
    Aug 6, 2012 at 12:51 pm
  • I did some research on this. But the answer is No. Most of our clients use OID (Oracle LDAP), even when they use JDBC. I remember a few years ago we enabled some logging in OID to see what client ...
    Yong HuangYong Huang
    Aug 25, 2012 at 4:31 pm
    Aug 29, 2012 at 2:13 pm
  • I have been using Grid Control since, perhaps before. I notice in the latest release, one cannot show time-period graphs such as 24 hour CPU utilization. Attempts to do so return a page ...
    MacGregor, Ian A.MacGregor, Ian A.
    Aug 3, 2012 at 8:26 pm
    Aug 15, 2012 at 4:05 am
  • I have a huge table in my OLTP DB, that has 100 million+ rows (pls don't ask why), and is partitioned. I know it doesn't make sense for my App to ever do a FTS on it.. But Oracle at times picks up ...
    Aug 24, 2012 at 12:37 am
    Aug 24, 2012 at 9:45 pm
  • Previously installed Oracle 10G and 11G R1. Yesterday, installed Today decided to shutdown the 11g r1 listener and start the 11g r2 listener. Would then change ports on 11g r1 and restart ...
    Jeffrey BeckstromJeffrey Beckstrom
    Aug 15, 2012 at 11:37 am
    Aug 21, 2012 at 12:30 pm
  • I've got a hypothetical question for y'all. :) I'm considering possible options for recovering data following a TRUNCATE TABLE command, with the help of a physical standby database, without requiring ...
    Adric NorrisAdric Norris
    Aug 23, 2012 at 9:40 pm
    Aug 24, 2012 at 3:32 pm
  • Well, I thought I followed all the steps for putting in the patch for the listener poison bug. But when I reach the point where its time to switch the remote listener to the secure port, I cant get ...
    John SmithJohn Smith
    Aug 11, 2012 at 10:38 pm
    Sep 4, 2012 at 3:14 pm
  • RHEL 5.6 Oracle We've noticed that on two of our RACs (same config, Grid, DB install) that our ASM log files are going stale. On one of them the files haven't been written to since May and ...
    Walker, Jed SWalker, Jed S
    Aug 15, 2012 at 2:32 pm
    Aug 20, 2012 at 3:44 pm
  • Hi all, My AWR report shows 'log file sync' among the top five events. When I look at the 'Foreground Wait Events', I see the following: Avg %Time Total Wait wait Waits % DB Event Waits -outs Time ...
    Hameed, AmirHameed, Amir
    Aug 6, 2012 at 7:56 pm
    Aug 23, 2012 at 10:12 pm
  • Hi I have installed Cloud Control 12c on a Windows network and successfully set up all of the hosts except one, which is at an overseas site. Before commencing I checked that I could make a secure ...
    Gerry MillerGerry Miller
    Aug 3, 2012 at 5:28 am
    Aug 7, 2012 at 12:58 am
  • This will probably be an SR to be sure about it, but I'm wondering if anyone has seen this and knows already. I have an RAC built from scratch as I have a patch to install ...
    Walker, Jed SWalker, Jed S
    Aug 23, 2012 at 5:45 pm
    Aug 28, 2012 at 2:56 pm
  • Database Control To Be Desupported in DB Releases after 11.2 [ID 1484775.1] Hemant K Chitale http://hemantoracledba.blogspot.com -- http://www.freelists.org/webpage/oracle-l
    Hemant K ChitaleHemant K Chitale
    Aug 21, 2012 at 6:17 am
    Aug 22, 2012 at 8:29 pm
  • Is it still true that you can only run Oracle on Oracle's VM. A consise answer or reference to INDEPENDENT doc on this would be appreciated. -- Howard A. Latham -- ...
    Howard LathamHoward Latham
    Aug 9, 2012 at 9:15 am
    Aug 13, 2012 at 3:49 pm
  • I am interested in how you are utilizing Cloud Control 12c for monitoring Data Guard replication. For. Eg. I would like to be notified when a standby database hasn't caught up to primary with logs or ...
    Ramadoss, KarthikRamadoss, Karthik
    Aug 7, 2012 at 2:52 pm
    Aug 8, 2012 at 12:33 pm
  • Hi Can someone share his experience in upgrading some big databases like 1Tb or so from 10g to 11g and also moving them to new server. I had few database running in 10g and has to be moved to new ...
    Sanjay MishraSanjay Mishra
    Aug 24, 2012 at 6:34 pm
    Oct 28, 2012 at 11:44 pm
  • I don't think this is a big deal, but I'm looking for suggestions on what to tell them to get them to let this go. DB Version: OS: HP Unix. I have to update 2 million rows in a 100 GB table ...
    Dba DBADba DBA
    Aug 22, 2012 at 3:42 pm
    Aug 23, 2012 at 12:24 am
  • Hi List, This question goes to those of you who use OEM12c. We have a set of developers that want to access OEM to monitor performance in a database. I've found a way to allow them read only access ...
    Guillermo Alan BortGuillermo Alan Bort
    Aug 5, 2012 at 5:44 pm
    Aug 9, 2012 at 9:31 pm
  • Hey all, While I'm trying to debug some messes, I see that EM12c's Top Activity historical data shows at least one 30-minute time period from this morning where two of the Top Sessions have the same ...
    Rich JesseRich Jesse
    Aug 22, 2012 at 1:45 pm
    Aug 22, 2012 at 7:26 pm
  • G'day, Does anyone know how to escalate an SR on the Metalink replacement? I'm stuck with some schoolboy who cannot even read the problem description and keeps copying pages from the manual. I want ...
    De DBADe DBA
    Aug 16, 2012 at 12:43 am
    Aug 16, 2012 at 6:19 pm
  • I have a large INSERT ... SELECT parallel query involving dozens of hash joins, hundreds of millions of rows and strongly suspect we are getting bitten by an imbalance of workload distributed among ...
    Tornblad, JohnTornblad, John
    Aug 10, 2012 at 6:13 pm
    Aug 12, 2012 at 8:13 pm
  • Ok so a colleague of mine manages a large number of Oracle 10g XE databases and one of them is failing to open this morning because of a corrupt SYSTEM tablespace. And unfortunately the backups for ...
    Jeff ChircoJeff Chirco
    Aug 9, 2012 at 4:14 pm
    Aug 10, 2012 at 6:28 am
  • SQL SHO USER USER is "SYS" SQL CREATE TABLE JUNK (JUNQUE NUMBER); Table created. SQL DROP TABLE JUNK PURGE; DROP TABLE JUNK PURGE * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ...
    Thomas DayThomas Day
    Aug 2, 2012 at 1:40 pm
    Aug 3, 2012 at 6:53 am
  • This is Oracle running on AIX 5.3. Following the example in the "Using Oracle XML DB" I run: BEGIN DBMS_XMLSCHEMA.registerSchema( SCHEMAURL = ...
    Schauss, Peter (ESS)Schauss, Peter (ESS)
    Aug 28, 2012 at 2:59 pm
    Sep 6, 2012 at 10:51 pm
  • Dear All, I want to implement sso on 11gr2 database. I went through lot of documentation. Still confused. Could any please tell me what high level steps are? Regards, Harshan -- Harshan Eppurath ...
    Harshan eppuramHarshan eppuram
    Aug 30, 2012 at 6:50 pm
    Sep 2, 2012 at 2:33 pm
  • Hi All, I been trying to do a migration from the above set subject line , with the help of RMAN. Tired using this doc , but did not succeed. Database Migration From Windows to Linux Using RMAM by ...
    Sheldon QuinnySheldon Quinny
    Aug 27, 2012 at 4:02 pm
    Aug 28, 2012 at 6:42 pm
  • Guys/Gals, (3 Node RAC on RH 5.4 Linux) I'm new to RAC and we have an INSERT statement with a subselect - The INSERT uses an /*+ APPEND */ hint and is taking ABNORMAL amount of time to ...
    Chris TaylorChris Taylor
    Aug 21, 2012 at 8:53 pm
    Aug 23, 2012 at 1:13 pm
  • Hi: We are seeing this problem several times on Sun T3-1 servers. We also see the problem 1~2 times on Sun T4-1 Server The server has 128G memory, database version is, or ...
    Eagle FanEagle Fan
    Aug 14, 2012 at 3:17 am
    Aug 19, 2012 at 4:21 pm
  • I'm writing some queries to mine AWR data over time. There is one thing I am having trouble reverse engineering and would appreciate some help. The "Segments by Logical Reads" section show the top ...
    Keith MooreKeith Moore
    Aug 16, 2012 at 11:25 pm
    Aug 17, 2012 at 3:53 pm
  • Dear Team, Just an update Today I have checked my Grid and found more error messages Management Services and Repository with "Thread: XMLLoader0 xxxxxxx.xml Failed to load xxxxxxxxxxx.xml even after ...
    M MudhalvanM Mudhalvan
    Aug 8, 2012 at 5:47 am
    Aug 8, 2012 at 6:39 am
  • Hello List! We had database failure recently with /var/log/messages and the Alert Log Entries listed below at the bottom. Very odd. We rebooted the server with 20 databases. 19 came up and when we ...
    Steve MontgomerieSteve Montgomerie
    Aug 1, 2012 at 3:59 am
    Aug 5, 2012 at 6:38 pm
  • Aftenoon all. I can't figure out why the following view statement works in 9i but is dying in 11g2. I have 13 views for this one user. 12 created correctly but the 13th is giving me fits. Using toad, ...
    Storey, Robert (DCSO)Storey, Robert (DCSO)
    Aug 27, 2012 at 7:59 pm
    Aug 28, 2012 at 10:59 am
  • Hi, I am doing a manual upgrade from 10.2.04 to 11.2.03. I have installed Ran utlu112i.sql Copied TNSNAMES and LISTENER.ora,init.ora from 10g home to 11g home respective directories ...
    Nisha MohanNisha Mohan
    Aug 24, 2012 at 11:32 am
    Aug 27, 2012 at 8:30 am
  • We have pdf's stored in our database as blob as a secure file which is encrypted and we want to write these blobs out to the file system. I have written this procedure below but it is very slow. The ...
    Jeff ChircoJeff Chirco
    Aug 21, 2012 at 3:44 pm
    Aug 21, 2012 at 7:56 pm
  • I just saw a document say "ORACLE 11Gr2 certify on Redhat 6". Does ORACLE X86_64 10GR2 and 11GR1 also certify under Redhat 6? Any document prove that? Thanks. -- ...
    Dba1 mccDba1 mcc
    Aug 14, 2012 at 2:05 pm
    Aug 15, 2012 at 2:21 pm
  • Hello friends, I am analyzing some sql statments and found out in all queries the developer added the following where clause plus others... and exists (select 1 from dual) All queries has this code ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Aug 2, 2012 at 5:53 pm
    Aug 2, 2012 at 6:20 pm
  • Hello everyone, Will anyone please share your ideas on patching process? I have worked for company who seldom patch and then for company who patch everything. I am trying to find a happy medium and ...
    Michael DinhMichael Dinh
    Aug 31, 2012 at 5:37 pm
    Sep 4, 2012 at 4:54 pm
  • Has anyone on this list ever seen Oracle Database 11g Database Smart Flash Cache in production? Please don't confused this for Exadata Smart Flash Cache. -- http://www.freelists.org/webpage/oracle-l
    Kevin ClossonKevin Closson
    Aug 29, 2012 at 8:32 pm
    Aug 29, 2012 at 9:01 pm
  • Guys/Gals, As a few of you know I have taken a new job and one of the applications I'm responsible for has multiple dev and qa environments and one prod environment. ( RAC - 3 nodes in ...
    Christopher Taylor2Christopher Taylor2
    Aug 29, 2012 at 2:11 pm
    Aug 29, 2012 at 8:13 pm
  • Hi, I am trying to upgrade DB to using DBUA. 10g oracle is owned by user ora10gr4 and 11g oracle is owned by user ora11203. I started DBUA from 11g/bin path and while selecting DB i ...
    Nisha MohanNisha Mohan
    Aug 27, 2012 at 8:32 am
    Aug 27, 2012 at 6:59 pm
  • Is there anywhere to download the Oracle 9i or 10gR2 clients ? I've spent an hour today trying to find one. I have a very old Oracle 8i database that I need to connect to via a tool i have and ...
    Steve WalesSteve Wales
    Aug 26, 2012 at 7:12 pm
    Aug 27, 2012 at 10:34 am
  • Youch! If you really can't fit your processing need on a single node, then you usually need to set up application affinity for EBS to fight less with RAC architecture. So you probably do not want to ...
    Mark W. FarnhamMark W. Farnham
    Aug 23, 2012 at 7:12 pm
    Aug 24, 2012 at 4:27 pm
  • Hi, Database Version: OS: Solaris 10 We are using guaranteed restore points without enabling full flashback database logging. I'm trying to flashback a database to a guaranteed restore ...
    Fergal TahenyFergal Taheny
    Aug 10, 2012 at 10:48 pm
    Aug 20, 2012 at 5:32 am
  • Hello, We run Data guard in one of our environments and had to fail over to the physical standby today. We are going to need to rebuild the old primary server from scratch and setup Data ...
    Michael SchmittMichael Schmitt
    Aug 3, 2012 at 2:47 am
    Aug 3, 2012 at 5:06 pm
  • Hi, We have VPD enforced on a schema for few tables, but when logged-in as SYS, we can view those table's data. Is there a way (workaround) to restrict SYS from viewing the VPD-related tables? ...
    Deepak SharmaDeepak Sharma
    Aug 30, 2012 at 6:51 pm
    Aug 31, 2012 at 10:56 pm
  • Hey all, In one DB target's performance home page, the Average Active Sessions graph often shows huge temporary spikes in CPU Wait when on a Real Time display showing only Foreground ...
    Rich JesseRich Jesse
    Aug 31, 2012 at 2:16 pm
    Aug 31, 2012 at 3:10 pm
  • Yesterday, we upgraded one of our Oracle EBS DEV databases to Oracle 11G R2. This morning we received an email alert that around 10:30 p.m. last night, about a dozen and a half tablespaces had an ...
    Jeffrey BeckstromJeffrey Beckstrom
    Aug 28, 2012 at 12:41 pm
    Aug 28, 2012 at 3:32 pm
  • I think I already know the answer to this but does Oracle capture a connect string anywhere that a client uses to connect with? A JDBC connect string specifically. I was thinking it would be in the ...
    Chris TaylorChris Taylor
    Aug 24, 2012 at 8:37 pm
    Aug 25, 2012 at 7:43 pm
Group Navigation
period‹ prev | Aug 2012 | next ›
Group Overview
grouporacle-l @

157 users for August 2012

Hans Forbrich: 17 posts Niall Litchfield: 15 posts Storey, Robert (DCSO): 14 posts De DBA: 13 posts Robert Hanuschke: 12 posts Tim Gorman: 12 posts Jeffrey Beckstrom: 11 posts Patterson, Joel: 11 posts Rich Jesse: 11 posts Walker, Jed S: 11 posts Allen, Brandon: 10 posts Mark W. Farnham: 10 posts Taylor, Chris David: 10 posts Andy Gmail: 9 posts Guillermo Alan Bort: 9 posts Kevin Closson: 9 posts MacGregor, Ian A.: 9 posts Nisha Mohan: 9 posts Rjamya: 9 posts Peter Sharman: 8 posts
show more