Search Discussions

87 discussions - 244 posts

  • hi I have a script which is to be executed on many databases and different databases have different log in users/password. Login needs to be chosen based on parameter passed so if the parameter ...
    A JoshiA Joshi
    Jan 31, 2011 at 3:55 am
    Feb 3, 2011 at 4:35 pm
  • Hi, This question might seem a bit obvious for many of you, I'm just trying to figure out which would be the best way to clone a database using the physical standby (so i don't need to touch prod) ...
    David PintorDavid Pintor
    Jan 31, 2011 at 11:22 am
    Feb 1, 2011 at 7:48 pm
  • A followup. Startup mount works fine. restore database works fine. list incarnation works fine and says RESET SCN = 1948174. recover database until SCN 1948174. = command returns RMAN-03002 failure ...
    Ed LongEd Long
    Jan 21, 2011 at 6:55 pm
    Jan 27, 2011 at 8:01 am
  • Dear fellow oracle-l'ers, let me start with a "happy new year" to y'all first (for the politically correct of you: Happy change of the Gregorian calendar :-)! Recently, I've opened an enhancement ...
    Uwe KüchlerUwe Küchler
    Jan 11, 2011 at 3:36 pm
    Jan 12, 2011 at 7:14 pm
  • Unfortunately, no. Although I have mentioned it more than once, development refuses to even consider it. I've got meetings all day today but tomorrow I want to start looking into the DBA_HIST views ...
    Sandra BeckerSandra Becker
    Jan 27, 2011 at 3:13 pm
    Feb 2, 2011 at 9:13 pm
  • Karl must have missed this email, but I'll promote his scripts for him... I've had way too much fun with them not to! :) The AWR gen script, (awr_genwl.sql) was a source of great fun, that only after ...
    Kellyn PedersenKellyn Pedersen
    Jan 13, 2011 at 4:14 am
    Jan 16, 2011 at 4:01 am
  • Hello Can anyone suggest a freeware tool to format SQL Plus statements captured via other tools? Thanks. -- http://www.freelists.org/webpage/oracle-l
    Orlando LOrlando L
    Jan 31, 2011 at 8:45 pm
    Feb 1, 2011 at 6:48 am
  • hi, just preparing to some exams and found some typical queries on internet with answers for example TK 2: Which two steps are performed the first time any Update statement is issued after the ...
    Remigiusz SokolowskiRemigiusz Sokolowski
    Jan 14, 2011 at 10:56 am
    Jan 16, 2011 at 10:17 am
  • Hi, We have oracle 10g dataguard configuration (one standby database).It was working fine for last 6 months.Standby database has down for 2 days. I have copied the password file and restored the ...
    Jan 6, 2011 at 2:48 pm
    Jan 6, 2011 at 3:27 pm
  • hi, List friends, Oracle has been promoting this flash cache as second tier cache for oracle for a while; Just wondering whether anyone has used this within the industry? We typically have 30gb-60gb ...
    Jan 12, 2011 at 10:24 am
    Aug 28, 2011 at 1:56 am
  • Listers, I find myself at a loss right now. this is an 11g EM ( on Linux x86_64. I am trying to connect to the 'services' page of a cluster ( of 4 nodes. I connect to the EM, ...
    Guillermo Alan BortGuillermo Alan Bort
    Jan 27, 2011 at 8:07 pm
    Jan 30, 2011 at 7:26 am
  • QUEUESIZE *Purpose* Use the parameter QUEUESIZE to specify the number of concurrent connection requests that the listener can accept on a TCP/IP or IPC listening endpoint (protocol address). Embed ...
    Sheldon QuinnySheldon Quinny
    Jan 25, 2011 at 7:47 am
    Jan 27, 2011 at 8:44 am
  • I am looking for a way to implement conditional logic in a main sql script file, that calls other script files. In PLSQL, this is easy using regular IF THEN ELSE statements. It is even easy to add or ...
    Dylan FarreDylan Farre
    Jan 5, 2011 at 11:12 am
    Jan 9, 2011 at 3:20 am
  • Guys and Gals, I've a WebFocus developer here who is telling mew that he cannot use a view to query data from the database. The app developers have created and tuned these views to the n'th degree so ...
    Goulet, RichardGoulet, Richard
    Jan 5, 2011 at 12:29 pm
    Jan 5, 2011 at 3:29 pm
  • Hi All, Wish you all a very happy new year. I am trying to setup a 11gR2 non RAC with ASM on OEL 5.4 I am having trouble setting up ASM. I have an ACER laptop with 4GB RAM and 320 GB hard drive ...
    Sundar mahadevanSundar mahadevan
    Jan 1, 2011 at 10:57 pm
    Jan 3, 2011 at 4:26 pm
  • Hello, I am the organizer of PostgreSQL Conference. We are looking for a few Oracle talks from qualified individuals. Topics such as, "What PostgreSQL could learn from Oracle" would be great, ...
    Joshua D. DrakeJoshua D. Drake
    Jan 31, 2011 at 9:30 pm
    Feb 10, 2011 at 6:57 pm
  • Hi All, Sorry about this basic question. I can understand how dynamic registration works but does dynamic listener service registration completely eliminate the use of tnsnames.ora or do i keep the ...
    Sundar mahadevanSundar mahadevan
    Jan 27, 2011 at 9:42 pm
    Jan 31, 2011 at 1:50 pm
  • hi, we hit from time to time the following issue: - some rows from a table are locked there is no blocking session information and the session, which tries to acquire lock has blocking_session_status ...
    Remigiusz SokolowskiRemigiusz Sokolowski
    Jan 5, 2011 at 9:46 am
    Jan 5, 2011 at 1:49 pm
  • There is an Oracle whitepaper comparing RAC (wonderful, performant and simple) with SQL Server 2008 (awful, slow and complex :)) In it there is an interesting table for ERP schemas. Now I know some ...
    Niall LitchfieldNiall Litchfield
    Jan 20, 2011 at 1:31 pm
    Jan 27, 2011 at 11:09 am
  • Hi all, does anyone have already implemented a normal failover cluster with 2 or n-nodes using clusterware 11.2 and databases running 10gR2 ? How have you integrated database in the cluster? I ...
    Stefano CislaghiStefano Cislaghi
    Jan 26, 2011 at 10:56 am
    Jan 26, 2011 at 11:43 am
  • Yeah, its a matter of time. If I can just fix the output files with some simple commands its easy. To do it the other way, I have to go and modify 32 separate queries. -- Andrew W. Kerber 'If at ...
    Andrew KerberAndrew Kerber
    Jan 18, 2011 at 8:45 pm
    Jan 24, 2011 at 1:12 pm
  • Well, we got an EM alert saying SESSION x (I don't remember the session number) is blocking 1153 sessions... Apparently it was a latch contention... weird Alan.- -- ...
    Guillermo Alan BortGuillermo Alan Bort
    Jan 22, 2011 at 12:40 am
    Jan 23, 2011 at 5:56 am
  • I assume this is not 100% correct. see the possibilities of srvctl: srvctl add listener -h Adds a listener configuration to the Oracle Clusterware. Usage: srvctl add listener [-l ] [-s] [-p "[TCP:][, ...
    Martin BergerMartin Berger
    Jan 14, 2011 at 7:56 pm
    Jan 15, 2011 at 6:23 pm
  • Has a front cover with "My SQL" emblazoned all over it, at this rate someone where I work is going to suggest using it, what is happening to "My WORLD"!! Pete -- ...
    Peter HitchmanPeter Hitchman
    Jan 10, 2011 at 2:13 pm
    Jan 10, 2011 at 8:06 pm
  • Hello, Has anyone experience the following errors? I currently have a open SR with Oracle support and has been very difficult. Thanks. oracle_at_proddb06:db06:/oracle Recovery Manager: Release ...
    Michael DinhMichael Dinh
    Jan 9, 2011 at 12:52 am
    Jan 10, 2011 at 3:57 am
  • Because there are some folks out there that just can't function with a dumb terminal. You remember them, always HAD to have an X-term. Dick Goulet Senior Oracle DBA From ...
    Goulet, RichardGoulet, Richard
    Jan 7, 2011 at 6:59 pm
    Jan 7, 2011 at 7:56 pm
  • Do you have a call to dbms_datapump.start_job? Otherwise there must be a problem in the procedure. Dick Goulet Senior Oracle DBA From: oracle-l-bounce_at_freelists.org On Behalf Of Joe Smith Sent ...
    Goulet, RichardGoulet, Richard
    Jan 27, 2011 at 11:03 pm
    Feb 11, 2011 at 3:22 pm
  • Mike, Since you are already on 11.2, I would suggest that you install grid infrastructure for a standalone server (aka oracle restart). This will allow you to use srvctl to register the database in ...
    D'Hooge FreekD'Hooge Freek
    Jan 27, 2011 at 8:03 pm
    Jan 29, 2011 at 4:29 pm
  • http://oraclehack.blogspot.com/2010/10/ora-24247-network-access-denied-by.html Maybe this might help. Michael Dinh NOTICE OF CONFIDENTIALITY - This material is intended for the use of the individual ...
    Michael DinhMichael Dinh
    Jan 27, 2011 at 5:05 pm
    Jan 28, 2011 at 2:44 am
  • The parameter is called "_disable_logging". To quote Jonathan Lewis from a previous discossion in oracle-l titled "Disable logging in tablespace vs using hidden parameter _disable_logging": "Just as ...
    Harel SafraHarel Safra
    Jan 27, 2011 at 9:09 am
    Jan 27, 2011 at 6:33 pm
  • I got yours, but you sent it to me also. Thx. Joel Patterson Database Administrator 904 727-2546 From: Vishalaksha Vyas Sent: Thursday, January 06, 2011 4:24 PM To: Patterson, Joel Cc ...
    Jan 7, 2011 at 4:31 pm
    Jan 24, 2011 at 9:48 pm
  • Good morning/afternoon/evening all does anyone have a list of oracle's hosts for which communication is required for EM patching and provisioning to work correctly. I have https://updates.oracle.com ...
    Niall LitchfieldNiall Litchfield
    Jan 21, 2011 at 1:15 pm
    Jan 22, 2011 at 10:34 pm
  • Still not clear - where and how often does this get called - especially given that this is an autonomous trans My testing was on a rhel 11gr2 env What is the OS and hardware where you are getting ...
    Jan 19, 2011 at 10:17 pm
    Jan 20, 2011 at 10:11 am
  • Hi Everyone... I take care of 4 - Oracle 10GR2 Database on Windows Platform. I am looking for scripts or ways which can be implemented to monitor the growth of the tablespaces and ...
    Sheldon QuinnySheldon Quinny
    Jan 18, 2011 at 12:08 pm
    Jan 19, 2011 at 8:30 am
  • I suppose this is the temporary file with id 2 - AFAIK they are counted as db_files+temporary_file_id or so Regards Remigiusz -- Pole nakazi ...
    Remigiusz SokolowskiRemigiusz Sokolowski
    Jan 18, 2011 at 2:47 pm
    Jan 18, 2011 at 2:57 pm
  • Listers, I am doing some research on setting up v10.2 DG for couple of our databases. They both will be single instance DBs. We are looking into the new client connections automatically going to the ...
    Ram RamanRam Raman
    Jan 17, 2011 at 11:02 pm
    Jan 18, 2011 at 11:36 am
  • Hi list, May I ask for your guidance in configuring fast incremental backup. I have already setup RMAN (catalog) to run via cron level 0 on mondays and the rest of the days are level 1 each of the ...
    Jan 18, 2011 at 6:00 am
    Jan 18, 2011 at 8:38 am
  • Hello list Anyone have installed 2 CRS on 1 server? I know the normal configuration is to install 1 CRS and 1 or more databases on that CRS, but i need to know if it is possible to install 2 CRS on ...
    Ricard MartínezRicard Martínez
    Jan 13, 2011 at 3:57 pm
    Jan 13, 2011 at 4:03 pm
  • Hi, I am trying to understand how the named user licensing in Oracle database works and would like to know if I have the right understanding. Based on what I know, named user licenses are based on ...
    Hameed, AmirHameed, Amir
    Jan 11, 2011 at 2:46 pm
    Jan 11, 2011 at 2:57 pm
  • I have a physical dataguard database on a development system in noarchivelog mode. The archive log directory keeps filling up. Since it is development, I do not need to keep the archive logs. They ...
    Patrick ElliottPatrick Elliott
    Jan 6, 2011 at 2:35 pm
    Jan 6, 2011 at 3:26 pm
  • Hello All: Any idea on why this may be happening? root.sh ran successfully on node 1 When running it on node 2, it fails with this error. [root_at_asiadbg3dev2 grid]# /app/11.2.0/grid/root.sh Running ...
    Kumar MadduriKumar Madduri
    Jan 28, 2011 at 10:15 pm
    Jan 29, 2011 at 1:09 pm
  • Thanks, didn't know about that. A couple of folks pointed out the star - I guess I should have related that to the star on the favorites menu, though honestly I did not notice the start on the ...
    Jared StillJared Still
    Jan 23, 2011 at 2:38 am
    Jan 25, 2011 at 11:56 pm
  • So there's a query predicate on COL_B while COL_A is for a join and you have two other tables with their own predicates besides the join. Given that COL_B and not COL_A is a predicate IDX01 is ...
    Hemant K ChitaleHemant K Chitale
    Jan 21, 2011 at 12:14 am
    Jan 21, 2011 at 1:44 pm
  • Hi Amir, Have a look to rule-based transformation "rename schema". It should work in your case. Cheers, Gleb -- http://www.freelists.org/webpage/oracle-l
    Gleb OtochkinGleb Otochkin
    Jan 21, 2011 at 11:35 am
    Jan 21, 2011 at 1:21 pm
  • Dear DB admin gurus, I need some thoughts on this. We have a very large NOArchivelog database RAC 20 node RHEL4, 300+T spread on about 50 tablespaces, we want copy this to another RAC ...
    Dd yakkaliDd yakkali
    Jan 20, 2011 at 8:13 am
    Jan 20, 2011 at 9:13 am
  • These are some articles I found to be worth reading on this subject. �When should you rebuild an index?� by Jonathan Lewis, at http://www.dbazine.com/oracle/or-articles/jlewis14 �Oracle index ...
    Ron CriscoRon Crisco
    Jan 18, 2011 at 3:35 pm
    Jan 19, 2011 at 5:09 am
  • as always, it depends on what you exactly need. as has been said, there is no equivalence of storage snapshots. this means you simply can't move the databases over to an exadata and follow the exact ...
    Frits HooglandFrits Hoogland
    Jan 14, 2011 at 10:30 am
    Jan 14, 2011 at 8:14 pm
  • I think that is the last step, or pretty close to it. But I have to read the data from Oracle and write out those sqlplus files also. I am sure I can do it, but was hoping somebody already has ...
    Andrew KerberAndrew Kerber
    Jan 13, 2011 at 2:01 pm
    Jan 14, 2011 at 2:59 am
  • Good evening! I've got a question about ORION - is it possible to run ORION against ASM disks? I have checked the documentation which seems to be 10.2 still and it says no, but maybe there is some ...
    Martin BachMartin Bach
    Jan 12, 2011 at 5:15 pm
    Jan 12, 2011 at 10:29 pm
  • yes, around 8:30 am EST. -- http://www.freelists.org/webpage/oracle-l
    Paul DrakePaul Drake
    Jan 11, 2011 at 9:14 pm
    Jan 11, 2011 at 9:17 pm
Group Navigation
period‹ prev | Jan 2011 | next ›
Group Overview
grouporacle-l @

118 users for January 2011

: 9 posts Niall Litchfield: 9 posts Andrew Kerber: 7 posts Goulet, Richard: 7 posts Hemant K Chitale: 7 posts Subodh Deshpande: 7 posts Howard Latham: 6 posts Remigiusz Sokolowski: 6 posts Guillermo Alan Bort: 5 posts Harel Safra: 5 posts Joel.Patterson_at_crowley.com: 5 posts Rich Jesse: 5 posts Sundar mahadevan: 5 posts Amaral, Rui: 4 posts Bobak, Mark: 4 posts D'Hooge Freek: 4 posts Ed lewis: 4 posts Ed Long: 4 posts Fuad Arshad: 4 posts Michael Dinh: 4 posts
show more