Search Discussions

76 discussions - 401 posts

  • Hello DBA gurus, We recently upgraded our database from 9i to 11gR2 on Solaris 11 64-bit, Veritas File system (single instance). We tested thoroughly in our QA environment before the upgrade. But ...
    Bheemsen AithaBheemsen Aitha
    May 8, 2014 at 6:40 am
    May 11, 2014 at 12:00 am
  • Hi, I have a question about migrating data from MSSQL and Oracle. I'm working on a migration project from MSSQL and Oracle. I have around 1040 tables on source (MSSQL) side, database size could be ...
    Nik TekNik Tek
    May 11, 2014 at 8:17 pm
    May 12, 2014 at 10:36 pm
  • We've got these dba lunch meetups going in Chicago and we tried something new last week. Started lunch by "introducing" one of the members. The interviewee answers a few questions, and we keep the ...
    Jeremy SchneiderJeremy Schneider
    May 6, 2014 at 2:24 pm
    May 7, 2014 at 5:53 am
  • 17


    Question for all you folks. I have an 11g instance and I was wondering if I should switch to Automatic Shared Memory Management. Easier? Better? Brian This email message may contain legally ...
    Zelli, BrianZelli, Brian
    May 12, 2014 at 2:30 pm
    May 17, 2014 at 8:33 am
  • The place I work doesn't use grid control. They have about 600 active databases in the development regions. We lack hardware infrastructure. All of these databases are mounted on five Solaris 10 ...
    Freeman, Donald G. CTR (ABL)Freeman, Donald G. CTR (ABL)
    May 2, 2014 at 3:29 pm
    May 7, 2014 at 8:32 pm
  • Hello, I am trying to figure out why my rman archivelog backups to tape are not getting removed. This worked correctly at some point, so I am not sure if it was when we changed scripts or version ...
    Michael SchmittMichael Schmitt
    May 2, 2014 at 4:58 pm
    May 2, 2014 at 9:28 pm
  • It seems there are a number of methods to convert a stand-alone database to a RAC database.. but it's not clear to me if I have to first move the stand-alone database onto the cluster first.. the ...
    Chris KingChris King
    May 7, 2014 at 5:04 pm
    May 9, 2014 at 1:42 am
  • Hi all Ok, was a bit taken aback yesterday when an engineered informed me that HCC is not supported on EBS (12.1.3). I can't imagine that a Exa feature is not supported by now, nearly 6 years after ...
    George Leonard - Business ConnexionGeorge Leonard - Business Connexion
    May 7, 2014 at 5:43 am
    May 8, 2014 at 1:15 pm
  • Dear List, We have X4-2 Half Rack with 20TB flash cache with database size 8TB. I am very reluctant to enable flashcache compression as the size of the database is half of flashcache, but Oracle says ...
    Thomas P SThomas P S
    May 8, 2014 at 11:31 am
    May 10, 2014 at 3:31 am
  • Dear Experts, I have a few questions with reference to below scenario: Table Structure : feed_details( id_pk number, acc_number number, branch_code number, feed_date date, feed_type varchar2(1), ...
    Vijay sehgalVijay sehgal
    May 7, 2014 at 7:53 am
    May 7, 2014 at 8:26 pm
  • I am looking for different events to set that will corrupt a database, or mimic a crash or error condition. For testing and training purposes? Any awesome ways to break an oracle database beyond the ...
    Josh CollierJosh Collier
    May 12, 2014 at 6:17 pm
    May 16, 2014 at 1:06 pm
  • Without getting too much into the specific situation (which I'll include in the post below, for reference), is there any logical reason why Oracle would take a SELECT statement having plan "X" with a ...
    McPeak, MattMcPeak, Matt
    May 7, 2014 at 5:36 pm
    May 8, 2014 at 9:43 am
  • I have a linux shell script that used to run fine I had imp \'userid=sys/easyeasy as sysdba\' it used to work but now I get a too many parameters error. any ideas? rhat linux 4 Oracle 11.2 -- Howard ...
    Howard LathamHoward Latham
    May 29, 2014 at 4:15 am
    Jun 1, 2014 at 4:45 am
  • Rich, I used a similar process during a migration to 11g. The parallel importing of the tables went fine since impdp will spawn several processes (parallel=##) and each process will import one table ...
    Cunningham, MikeCunningham, Mike
    May 23, 2014 at 5:15 am
    May 29, 2014 at 4:15 am
  • Hello List, I have a question and maybe some of you guys are already doing this(or not). We have some old HP-UX PA Risc(11.11) and i want them monitored with our new OEM 12c( Looking at the ...
    Max scalfMax scalf
    May 3, 2014 at 8:18 pm
    May 5, 2014 at 4:35 pm
  • Also remember that another benefit is for those that don't have ability to create pl/sql objects in a particular database - they can still use that code in their SQL statements now... -----Original ...
    Jeff SmithJeff Smith
    May 23, 2014 at 4:45 am
    May 26, 2014 at 5:45 am
  • Hi friends, I had a temporary tablespace TEMP02 in the instance. I ran: $ df -h . Filesystem Size Used Avail Use% Mounted on /dev/f1/fold1 493G 154G 339G 32% /l/disk67 After it I ran : select * from ...
    Eriovaldo AndriettaEriovaldo Andrietta
    May 18, 2014 at 10:19 am
    May 18, 2014 at 7:42 pm
  • Hi, (this is a current production recovery and not a test). We are doing RMAN PITR for a database with more than 7000 archivelogs to be recovered. (Restore was successful, recovery is currently ...
    Ingrid VoigtIngrid Voigt
    May 15, 2014 at 9:22 am
    May 16, 2014 at 3:40 pm
  • I am in the process of upgrading grid from to on RedHat LinuxV5. I have installed the grid software. I would now like to install the latest PSU to the software so that once I ...
    Nabil JamaleddinNabil Jamaleddin
    May 15, 2014 at 6:38 pm
    May 15, 2014 at 9:25 pm
  • Is it possible to find out what sql statements are using up UNDO tablespace space? Oracle 10g Enterprise Edition John
    John DunnJohn Dunn
    May 13, 2014 at 8:29 am
    May 13, 2014 at 3:53 pm
  • All, Without going into too much detail as to why (at this point), I have the following statement: delete from BLDGASSIGNEDADDINT where ID_ADDITIONALINTEREST in (select pk from ADDINTEREST where ...
    Sweetser, JoeSweetser, Joe
    May 12, 2014 at 7:02 pm
    May 13, 2014 at 3:04 pm
  • Hi I dont usually seperate these files anymore. I only do if split mirror or snapshot technologies are used for backup or environment creation purposes. However if you are running AIX and using CIO ...
    Ls ChengLs Cheng
    May 7, 2014 at 2:50 pm
    May 8, 2014 at 10:24 pm
  • Hi all I remember when ASM just made it's appearance there was a paper available that explained how ASM distributes blocks when configured in normal or high, thinks like primary block owner and 8 ...
    George Leonard - Business ConnexionGeorge Leonard - Business Connexion
    May 2, 2014 at 5:41 am
    May 6, 2014 at 1:08 am
  • Hi Friends, Does anyone have detailed step by step configuration of Oracle 11g R2 RAC document with DNS server configuration in Virtual Box(O/s - RHEL or OEL) ? Thanks in advance. Regards, Sandip
    Sandip MukhopadhyaySandip Mukhopadhyay
    May 5, 2014 at 11:34 am
    May 5, 2014 at 3:46 pm
  • Hey all, The performance problems on the V$RMAN_STATUS fixed view is at it again for me, this time on on AIX 7.1. I've got a bunch of new DBs that I've created (and still creating more) and ...
    Rich JesseRich Jesse
    May 1, 2014 at 2:27 pm
    May 1, 2014 at 4:25 pm
  • This will likely be an SR, but I've more confidence in this group for this query. <background We have some databases that have the following history. single instance db (version 10 or so) add service ...
    Niall LitchfieldNiall Litchfield
    May 1, 2014 at 3:46 pm
    May 2, 2014 at 7:42 am
  • I am encountering the following errors during the use of data pump to migrate an EBS instance following instructions in "Export/import process for 12.0 or 12.1 using 11gR1 or 11gR2 (Doc ID 741818.1)" ...
    Rajesh AialavajjalaRajesh Aialavajjala
    May 29, 2014 at 3:15 am
    Jun 1, 2014 at 4:45 am
  • Hi, We currently have our main production database running on HP-UX with a standby database, also HP-UX, at our DR site. It's possible that we will lose funding for the DR site at some point in the ...
    Maureen EnglishMaureen English
    May 23, 2014 at 4:45 am
    May 26, 2014 at 5:45 am
  • Hello, This list is not appropriate for such requests. Cheers, Phil -- http://www.freelists.org/webpage/oracle-l
    Phil JonesPhil Jones
    May 26, 2014 at 4:45 am
    May 26, 2014 at 4:45 am
  • Hey all, Under 64-bit Win7, we have a temporary Oracle DB that we're using for a one-shot data move. We may need to replace the PC with something beefier and I was hoping that a "simple" HDD ...
    Rich JesseRich Jesse
    May 15, 2014 at 6:00 pm
    May 16, 2014 at 1:53 pm
  • Dear List, Currently I'm investigating a situation which I can not explain: I have a 2 node RAC (Linux64, RedHat) in Production. (It's a Peoplesoft application, but I don't think this is of any ...
    Martin BergerMartin Berger
    May 13, 2014 at 12:57 pm
    May 13, 2014 at 4:59 pm
  • This is probably a real newbie question.. I'm working on a new installation of RAC, and am testing an rman backup/restore. (I've done many rman backup/restores before on stand-alones.) I am puzzled ...
    Chris KingChris King
    May 12, 2014 at 6:55 pm
    May 12, 2014 at 7:34 pm
  • Hi guys, With the launch of 11.2 or was it 11.1 CRS and ASM was consolidated into the then new OGI stack, which included ASM now. This then included the placement of VOTE and OCR into ASM. I attended ...
    George Leonard - Business ConnexionGeorge Leonard - Business Connexion
    May 8, 2014 at 6:14 am
    May 8, 2014 at 12:48 pm
  • We have a database in an active/passive config using SunCluster. The problem is that when the cluster moves/bounces database services PeopleSoft services are not restarted and that causes issues. I ...
    Ethan PostEthan Post
    May 2, 2014 at 3:49 pm
    May 2, 2014 at 6:28 pm
  • Hi Can someone share the architecture or document or URL to manage Grid/Cloud control for Primary and DR side ? What I am looking is how to to keep sync OMS repository and can use DR Grid/Cloud ...
    Sanjay MishraSanjay Mishra
    May 23, 2014 at 4:45 am
    May 26, 2014 at 7:15 am
  • Cluster details: GI DB 2 node cluster on OEL with RH compatible kernel. 2 owner install: grid owns GI, oracle owns DB Question: When the DB software is installed, running root.sh ...
    Ruel, ChrisRuel, Chris
    May 26, 2014 at 5:45 am
    May 26, 2014 at 7:15 am
    Chris TaylorChris Taylor
    May 26, 2014 at 3:45 am
    May 26, 2014 at 4:45 am
  • The original request was to respond privately, but I appreciate the fact that Michael did not as I am looking for same thing. Thanks! From: <span class="m_body_email_addr" ...
    Coll-Barth, MichaelColl-Barth, Michael
    May 26, 2014 at 3:45 am
    May 26, 2014 at 3:45 am
  • Hi List, I am working with 12c and was able to use the new large data type for VARCHAR2 etc. I am now using a VARCHAR2(32767) and NVARCHAR2(16383) Now I noticed at the Data Dict that tables and other ...
    Hanan HitHanan Hit
    May 17, 2014 at 2:18 pm
    May 18, 2014 at 12:29 am
  • Hello List, I have a question with regards to RMAN Catalog. I know most of the steps except one that i am struggling with. So we have our RMAN catalog on AIX server(11gr2) right now and we want to ...
    Max scalfMax scalf
    May 13, 2014 at 3:31 pm
    May 14, 2014 at 8:03 pm
  • Hi Friends, I have 3 node Dataguard Environment(1 -Primary,2-Physical standby's) in Oracle VirtualBox(Version 4.3) for different testing scenario's in Oracle 11g R2 in OEL platform . I want to ...
    Sandip MukhopadhyaySandip Mukhopadhyay
    May 14, 2014 at 8:14 am
    May 14, 2014 at 9:09 am
  • This article starts with the licensing pitfalls of virtualizing Oracle databases, but goes further and touches on many Oracle licensing issues ...
    Dennis WilliamsDennis Williams
    May 7, 2014 at 6:36 pm
    May 8, 2014 at 12:17 am
  • ...includes the few videos on Oracle they have, too. http://http://www.packtpub.com Enjoy! Rich -- http://www.freelists.org/webpage/oracle-l
    Rich JesseRich Jesse
    May 6, 2014 at 1:11 pm
    May 7, 2014 at 2:04 pm
  • Hi, I wonder if anyone has encountered the problem of OUI and other Java tools freezing - at different places, depending on the options chosen - when installing (GI as well as database), or ...
    May 4, 2014 at 2:32 pm
    May 4, 2014 at 2:58 pm
  • We were originally given 90 GB LUNS. As part of storage migration to another vendor, we are being provisioned with 500 GB LUNS. From a migration point of view, is it ok to move the data from 90 GB ...
    Kumar MadduriKumar Madduri
    May 23, 2014 at 5:45 am
    May 26, 2014 at 6:15 am
  • Hi all, RAC on RHEL 5.7 with RHEL kernel CVE-2012-1675/COST workaround implemented (SSL communication between listeners and instances) The customer wants to upgrade the OS and the HW. The ...
    Radoulov, DimitreRadoulov, Dimitre
    May 16, 2014 at 3:34 pm
    May 26, 2014 at 3:45 am
  • To add to this, my company also offers video and in person training: http://www.brentozar.com/training/ We have one training coming up this fall in Philadelphia. All of the in-person presenters are ...
    Jeremiah PeschkaJeremiah Peschka
    May 23, 2014 at 4:45 am
    May 23, 2014 at 5:15 am
  • First, thanks everyone for all your assistance with my many newbee RAC questions. You've been a huge help! I just did my first failover test, and everything looked fine. When I brought the failed rac ...
    Chris KingChris King
    May 16, 2014 at 4:05 pm
    May 16, 2014 at 6:17 pm
  • Hi Can someone shared the script to map as what Oracle Database segment is located on particular ASM Disk in the Diskgroup ? We have 5 disk out of 40 disk in a diskgroup that are reported as high ...
    Sanjay MishraSanjay Mishra
    May 15, 2014 at 6:55 pm
    May 16, 2014 at 5:38 pm
  • Hello guys need help here... We have recently migrated from a Hp-UX superdome (PARISC) to hp-ux itanium with the same configuration at the db side. Oracle Disks were unmounted and mounted on ...
    Veerabasaiah CVeerabasaiah C
    May 15, 2014 at 11:17 pm
    May 15, 2014 at 11:28 pm
Group Navigation
period‹ prev | May 2014 | next ›
Group Overview
grouporacle-l @

124 users for May 2014

Yong Huang: 23 posts Mark W. Farnham: 20 posts Hans Forbrich: 13 posts Niall Litchfield: 13 posts Bheemsen Aitha: 12 posts Rich Jesse: 12 posts Seth Miller: 10 posts Iggy Fernandez: 9 posts Mark Bobak: 9 posts George Leonard - Business Connexion: 8 posts Justin Mungal: 8 posts Michael Schmitt: 8 posts Mohamed Houri: 8 posts Tim Gorman: 8 posts Chris King: 7 posts Ls Cheng: 7 posts Pete Sharman: 7 posts Chris Taylor: 6 posts Freeman, Donald G. CTR (ABL): 6 posts McPeak, Matt: 6 posts
show more