FAQ

Search Discussions

120 discussions - 546 posts

  • Hello everybody: Can anyone point me to a document/article/book explaining how to use OID to resolve service names instead of tnsnames.ora? thank you Gene Gurevich Please consider the environment ...
    Genegurevich_at_discover.comGenegurevich_at_discover.com
    Aug 19, 2009 at 3:22 pm
    Sep 17, 2009 at 3:51 pm
  • Hi folks. At the recent 11g Dataguard Admin course it was strongly suggested we use LGWR and SYNC/ASYNC as the mechanism for log shipping from primary database. While in 10g doco both LGWR and ARCn ...
    Dbvision_at_iinet.net.auDbvision_at_iinet.net.au
    Aug 31, 2009 at 2:04 am
    Sep 7, 2009 at 8:17 am
  • Any of you guys/gals replicating LIVE datafiles from one SAN to another in a remote location? We're looking at using HP's CA tool to replicate LIVE datafiles across a WAN to another SAN. The ...
    Taylor, Chris DavidTaylor, Chris David
    Aug 27, 2009 at 1:42 pm
    Sep 2, 2009 at 10:25 am
  • Hi All, I had a quick question that I was hoping the list could help me out with. We have a group of developers who are requesting the ability to kill their own processes in the database ...
    Michael SchmittMichael Schmitt
    Aug 17, 2009 at 3:34 pm
    Aug 20, 2009 at 9:36 am
  • Hi, I just moved a database from one filesystem to another, edited the init.ora file to find the control files in the correct location, started up the database, renamed all of the datafiles, logfiles ...
    Maureen EnglishMaureen English
    Aug 4, 2009 at 5:36 am
    Aug 11, 2009 at 11:39 pm
  • If you're running 10.2.0.4 cpu patch 24, is there a version number for this like 10.2.0.4.24? Chris Taylor Sr. Oracle DBA Ingram Barge Company Nashville, TN 37205 Office: 615-517-3355 Cell ...
    Taylor, Chris DavidTaylor, Chris David
    Aug 24, 2009 at 4:23 pm
    Aug 26, 2009 at 12:26 pm
  • Hi All, Many Thanks to Robert Freeman, Mark Bobak, Dick Goulet for helping me out on my previous question on incomplete recovery. Unfortunately I did not get a chance to resolve the issue as another ...
    Sundar mahadevanSundar mahadevan
    Aug 8, 2009 at 7:16 pm
    Aug 14, 2009 at 8:36 pm
  • How about: alter tablespace read only; Obviously, not good on a production system, but since you mentioned this is to test a code path and (presumably) in a development instance, it should work ...
    Bobak, MarkBobak, Mark
    Aug 27, 2009 at 1:41 am
    Aug 31, 2009 at 7:46 pm
  • Hello I have date data in a record from txt file. When the field in the record contain '00000000' I want to replace it with '19000101'. How can I convince sql loader to do this? TIA -- Adar Yechiel ...
    Yechiel AdarYechiel Adar
    Aug 19, 2009 at 12:33 pm
    Aug 23, 2009 at 3:00 pm
  • I just tried to install 11.1.0.7 64 bit on Red Hat 4 and it did not go on cleanly. I get the hint that maybe only Red Hat 5 is what "really" goes with 11.1.0. I've not had any trouble with 11.1.0.7 ...
    Ray StellRay Stell
    Aug 7, 2009 at 2:09 pm
    Aug 11, 2009 at 12:06 pm
  • Ok 11.1.0.7 data guard setup, test environment on solaris. I've configured(you'd think this shouldn't be possible), To do standby redo log apply but NOT real-time with a delay. Here is the output ...
    TESTAJ3_at_nationwide.comTESTAJ3_at_nationwide.com
    Aug 4, 2009 at 3:16 pm
    Aug 4, 2009 at 5:54 pm
  • Hi DBA gurus, I need to flashback our EBS database to 10 hours ago, also hope the last five hours data can be recovered with export/import. Is there a way to find which table's/schema's data has been ...
    Jiang, LuJiang, Lu
    Aug 3, 2009 at 6:15 pm
    Aug 4, 2009 at 2:57 pm
  • we have ORACLE database 10GR2 on LINUX server. I found one thing very wield: SQL select count(username) from v$process; COUNT(USERNAME) 99 SQL select count(username) from v$session COUNT(USERNAME) 16 ...
    Dba1 mccDba1 mcc
    Aug 21, 2009 at 5:26 pm
    Aug 23, 2009 at 2:10 pm
  • Steve, First, yes, you can create an expression based index. In fact, that's why the DBA_IND_EXPRESSIONS view exists. They're actually all expressions. Been a while since I've played with this.... ...
    Bobak, MarkBobak, Mark
    Aug 19, 2009 at 9:14 pm
    Aug 21, 2009 at 1:40 pm
  • Hey all, In 10.1, we have a recurring situation where a user (or users) will attempt to pull large tables through a Websphere v5 app. The Websphere "node" (I think it's called) will heapdump from the ...
    Rich JesseRich Jesse
    Aug 17, 2009 at 4:34 pm
    Aug 19, 2009 at 2:18 pm
  • Hi list, I know it's unsecure, unsupported and ugly. But given this situation: I need a recovery of a tablespace, all archivelogs are there, bu I miss one from last night. I want to do a "complete" ...
    Martin KlierMartin Klier
    Aug 6, 2009 at 4:24 pm
    Aug 10, 2009 at 7:51 am
  • Hi listers, I have a HP Unix box that has Oracle 10g R2 installed on it. There is already an instance running and a database attached to it. I need to create another instance and database. There is ...
    Amir GheibiAmir Gheibi
    Aug 7, 2009 at 8:18 am
    Aug 7, 2009 at 6:55 pm
  • Hi Gurus, We are using oracle 10.2.0.3 on sparc solaris 64 bit with 16 CPU and 32GB of physical memory. Our sga_target is 12G and pga target is 15G. We are receiving ORA-32690: Hash Table ...
    Taral DesaiTaral Desai
    Aug 27, 2009 at 4:20 am
    Aug 28, 2009 at 7:12 pm
  • Hello all, I have systems that need to take data from other systems like most of you probably have to do. I need to take from sql server and other oracle systems. I can do it the old fashion way of ...
    Zelli, BrianZelli, Brian
    Aug 18, 2009 at 6:36 pm
    Aug 24, 2009 at 11:12 am
  • Hi Gurus, I'm trying to upgrade my test 2 node RAC presently on 9.2.0.8 to 10.1.0.4 . I can only upgrade it to 10.1 because my test servers only have 512 MB RAM. These are just fine for my home ...
    Sundar mahadevanSundar mahadevan
    Aug 17, 2009 at 8:12 pm
    Aug 18, 2009 at 5:39 pm
  • Hi all, The following is my query result against v$pgastat view. PGA_AGGREGATE_TARGET is set to 1G. According to Oracle' documentation, Oracle should attempts to keep the amount of private memory ...
    Jiang, LuJiang, Lu
    Aug 10, 2009 at 5:56 pm
    Aug 12, 2009 at 10:26 am
  • Listers, On our non-rac environment we have upgraded 10g ASM home to 11g ASM home.Can we mount diskgroup belonging to 10g RDMS from 10g ASM home even though the ocssd.bin process is running out of ...
    Sanjeev mSanjeev m
    Aug 3, 2009 at 4:52 am
    Aug 12, 2009 at 4:48 am
  • Hi All, We recently had a disk fault on one of our test servers. After replacing the drive I recovered the database using RMAN only to encounter an ORA-600 [3020] part way relating to blocks in the ...
    Charlotte HammondCharlotte Hammond
    Aug 5, 2009 at 9:29 pm
    Aug 7, 2009 at 2:17 am
  • Hi all, I have below trace files in udump as kiran_ora_4714776_vvp42660.trc kiran_ora_1638558_vvp42660.trc kiran_ora_4571498_vvp42660.trc kiran_ora_5574948_vvp42660.trc I am trying to merge all this ...
    Balakrishna YBalakrishna Y
    Aug 5, 2009 at 12:29 pm
    Aug 6, 2009 at 12:31 pm
  • One of our clients is interested in using Oracle Application Express on our 10.2.0.4 database. We haven't installed it. There's a concern in our DBA team that the APEX installed packages could ...
    Yong HuangYong Huang
    Aug 28, 2009 at 7:41 pm
    Aug 31, 2009 at 2:32 pm
  • I am trying to determine how many physical reads and physical writes are happening on one of my database servers. I tried using the "sar - b" command, but the physical reads and writes always appears ...
    Bill ZakrzewskiBill Zakrzewski
    Aug 28, 2009 at 7:49 pm
    Aug 29, 2009 at 11:24 am
  • Hello all, I ran the cpu patch for July overnight and I wanted to look at the log for it to double-check something. I looked in the notes but where the heck does it put the log for the opatch?????? ...
    Zelli, BrianZelli, Brian
    Aug 24, 2009 at 1:44 pm
    Aug 24, 2009 at 4:47 pm
  • Hello everyone!! We are working on the 11g Edition of our RMAN book. If you have read previous editions of the book, you know that we have some chapters specific to the MML interfaces to RMAN such as ...
    Robert FreemanRobert Freeman
    Aug 21, 2009 at 7:35 pm
    Aug 24, 2009 at 2:48 pm
  • Oracle 11g 64bit Redhat Builtin HTTP server We still havent solved this Are there logs of disconnects we can look at? -- Howard A. Latham -- http://www.freelists.org/webpage/oracle-l
    Howard LathamHoward Latham
    Aug 21, 2009 at 5:32 pm
    Aug 24, 2009 at 2:06 pm
  • (Version 11.1) I'm just in the process of setting up rman for a machine. Somehow I have a situation where when I do a "crosscheck archivelog all" I get told about a whole bunch of failures for ...
    Steve BaldwinSteve Baldwin
    Aug 18, 2009 at 12:30 am
    Aug 18, 2009 at 6:17 am
  • All, We have two applications that use one database, and the database is configured with character set WE8ISO8859P1. One of the applications needs to handle multiple languages so the vendor wants us ...
    Fred TillyFred Tilly
    Aug 12, 2009 at 7:58 am
    Aug 14, 2009 at 9:54 pm
  • Dear List, Why am I unable to access Database Control via http://bplnap11.dpsg.net:1158/em ? *$ emctl status dbconsole* Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0 Copyright (c) ...
    Roger XuRoger Xu
    Aug 10, 2009 at 8:40 pm
    Aug 11, 2009 at 6:22 pm
  • Hi All, I would like to know if an incomplete recovery is possible in the following scenario: control file back up from May 05, 2009. Incremental level 0 backup taken on Jul 21, 2009 that completed 8 ...
    Sundar mahadevanSundar mahadevan
    Aug 7, 2009 at 5:30 pm
    Aug 7, 2009 at 7:37 pm
  • I'm testing a D/R situation, specifically a Netbackup redirected client restore, source being a 10.2.0.4 RAC two-node instance; restoring to a single-instance. After restoring the spfile, restarting ...
    Jeffery ThomasJeffery Thomas
    Aug 5, 2009 at 7:43 pm
    Aug 5, 2009 at 8:42 pm
  • SQL audit create procedure Audit complete. SQL audit create any procedure Audit complete. SQL audit drop any procedure Audit complete. Why does this fail? Isn't this just the opposite of CREATE ...
    Ethan PostEthan Post
    Aug 21, 2009 at 2:19 pm
    Sep 10, 2009 at 3:55 pm
  • Hi Experts, In my SQL*Plus session, if I press Enter twice, it goes back to the prompt. How do I change this kind of behavior? SQL select tablespace_name 2 from dba_tablespaces 3 where ...
    Roger XuRoger Xu
    Aug 24, 2009 at 7:03 pm
    Aug 24, 2009 at 8:28 pm
  • (11.1) I have taken a level 0 incremental backup from system A (a 2 node cluster) and I'm trying to restore it to system B. Here's what I've done ... Used dd to initialise iscsi targets used by ASM ...
    Steve BaldwinSteve Baldwin
    Aug 18, 2009 at 10:07 am
    Aug 19, 2009 at 5:39 am
  • What is the best way to see if a string contains a valid number? 10gR2 thanks, Mike -- http://www.freelists.org/webpage/oracle-l
    Michael MooreMichael Moore
    Aug 18, 2009 at 6:19 pm
    Aug 18, 2009 at 9:15 pm
  • Hi I have a database where a JDBC app using connection pool makes a connection.Currently there are 30 sessions inside the database and most fo them being inactive. The max sessions parameter is ...
    HrishyHrishy
    Aug 14, 2009 at 6:40 am
    Aug 17, 2009 at 7:16 am
  • Hi I had 3 Node RAC on Solaris and I am facing one scenario very frequently where a select query start taking too much time in execution. It take only few seconds but after some time it changed to ...
    Sanjay MishraSanjay Mishra
    Aug 14, 2009 at 1:56 am
    Aug 14, 2009 at 7:34 pm
  • Folks, Is anyone either using or has tested Sun's QFS file system for Oracle RAC? I would like to know the pros and cons of QFS. Any feedback will be appreciated. Thanks Amir -- ...
    Hameed, AmirHameed, Amir
    Aug 13, 2009 at 8:50 pm
    Oct 19, 2009 at 9:46 am
  • Need to load some data into a remote database. i.e the data is on a machine that does not not have an oracle installed Is there an oracle client installation option that would allow me to install ...
    John DunnJohn Dunn
    Aug 14, 2009 at 8:45 am
    Sep 2, 2009 at 8:12 am
  • If I understand correctly, I think you're looking for Metalink 223543.1. Regards, Brandon Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise ...
    Allen, BrandonAllen, Brandon
    Aug 31, 2009 at 9:43 pm
    Aug 31, 2009 at 11:33 pm
  • Oracle 11g Redhat Linux 64Bit I've got a lot on otherwise I would trawl the manuals How do I Activate a standby ?- for test purposes without affecting the primary - so I get twow orking dbs on ...
    Howard LathamHoward Latham
    Aug 28, 2009 at 1:09 pm
    Aug 30, 2009 at 3:00 am
  • Hi Oracle-Listers, We have this system where materialized views are scheduled to rebuild within the same maintenance window in which Oracle runs the automatic GATHER_STATS_JOB. Not the best idea, but ...
    Chen ShapiraChen Shapira
    Aug 27, 2009 at 12:30 am
    Aug 28, 2009 at 4:48 pm
  • Hi Uwe, From memory, I thought, even back in 8i days, if index supporting PK was unique, then it was dropped when constraint is disabled. If it's non-unique, then it's retained when constraint ...
    Bobak, MarkBobak, Mark
    Aug 20, 2009 at 1:13 pm
    Aug 25, 2009 at 8:23 am
  • Hi Friends, I would like to know which Oracle tools must I install for show maps. I have some tables with columns that have datatype SDO_GEOMETRY and would like to see the map of polygons. The ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Aug 22, 2009 at 2:06 pm
    Aug 24, 2009 at 8:28 pm
  • Oracle 10.2.0.4 on RHAS 4u7 We're trying to setup a streams environment between two sites. The network between the sites is not the best. When I start up the propagation process, it dies within a ...
    MkbMkb
    Aug 22, 2009 at 7:10 pm
    Aug 24, 2009 at 2:37 am
  • List I'm trying to figure out someone that potientially can be basic I know awr and ash contain data about users that were connected I'm trying to find a way to tell at a point in time how many users ...
    Fuad ArshadFuad Arshad
    Aug 21, 2009 at 5:31 pm
    Aug 21, 2009 at 6:06 pm
  • Hi list members, just want to make you aware of the following issue that might occur when optimizer_capture_sql_plan_baselines is set to TRUE in 11g. My case was RAC with 11.1.0.7 + cpuJuly2009 + ...
    Andre van WinssenAndre van Winssen
    Aug 17, 2009 at 2:26 pm
    Aug 20, 2009 at 10:00 am
Group Navigation
period‹ prev | Aug 2009 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions120
posts546
users154
websiteoracle.com

154 users for August 2009

Roger Xu: 22 posts Bobak, Mark: 19 posts Jared Still: 18 posts : 14 posts Allen, Brandon: 14 posts Goulet, Richard: 14 posts Yong Huang: 13 posts Rich Jesse: 12 posts Sundar mahadevan: 12 posts Martin Berger: 11 posts Robert Freeman: 11 posts Karl Arao: 10 posts Martin Klier: 10 posts Matthew Zito: 10 posts TESTAJ3_at_nationwide.com: 10 posts Crisler, Jon: 9 posts Niall Litchfield: 9 posts Stefan Knecht: 9 posts Jiang, Lu: 8 posts Lyall Barbour: 8 posts
show more
Archives