Search Discussions

196 discussions - 1,193 posts

  • Hi, I am using dd to read data out of oracle datafiles from an oracle 9i database on solaris. I am using the following command: dd if=/location_to_oracle_datafile_and_file_name.DBF bs=8192 skip=11764 ...
    Naqi MirzaNaqi Mirza
    Feb 7, 2007 at 8:15 am
    Feb 11, 2007 at 4:04 pm
  • Hello. We are doing a RAC install on RedHat Linux.[2.6.9-34.ELsmp #1 SMP ]. Currently on 2 nodes, Clusterware is installed successfully. OCFS2 of clusterware and ASM for database. ASM is working ...
    Shivaswamy RaghunathShivaswamy Raghunath
    Feb 8, 2007 at 7:37 pm
    Feb 12, 2007 at 6:21 pm
  • Hi! Problem: in monitoring (OEM) we have got "needles" on activity figure (RDBMS ver. We believe slow log writer is responsible for them. Question: what can we do about it? ...
    Remigiusz Soko�owskiRemigiusz Soko�owski
    Feb 21, 2007 at 1:24 pm
    May 9, 2008 at 3:10 am
  • Does anybody work in a Data Center type of environment which houses databases for multiple/various clients (both government and private companies)? How are background checks handled? The reason that ...
    J. DexJ. Dex
    Feb 21, 2007 at 2:12 am
    Feb 27, 2007 at 11:39 pm
  • We have just implemented RMAN against our largest Siebel implementation (don't laugh - but it's less then 1/2 terrabyte). We did so because now that we have upgraded to Oracle 10gR2 ( we can ...
    Michael FontanaMichael Fontana
    Feb 12, 2007 at 4:15 pm
    Feb 13, 2007 at 9:37 pm
  • As part of my 32-to-64-bit server migration, we also want to move our storage to Oracle ASM. However I have some questions about some things going into ASM, and hoping you folks can clear the smoke ...
    Don SeilerDon Seiler
    Feb 23, 2007 at 5:52 pm
    Feb 27, 2007 at 4:55 am
  • Hi All, we have Oracle 64-bit database on AIX 5300-03 64 bit. File systems for data files and redo logs mounted with cio and filesystemio_options set to async (by default for Oracle ...
    Andrey GoryunovAndrey Goryunov
    Feb 20, 2007 at 8:12 am
    Feb 21, 2007 at 7:02 pm
  • Has anyone used this? http://www.enterprisedb.com/solutions/gotoracle.do "EnterpriseDB offers an enterprise-class alternative to Oracle at a fraction of the cost. .... Making the switch from Oracle ...
    Ray FeigheryRay Feighery
    Feb 21, 2007 at 5:45 am
    Feb 22, 2007 at 3:38 pm
  • Hello I am curious how those of you that use an RMAN catalog go about backing it up. I'm running Netbackup 5.1MP7 and backup 5 databases to a master server. My rman catalog database is on a separate ...
    Fred SmithFred Smith
    Feb 7, 2007 at 3:19 pm
    Feb 8, 2007 at 7:56 pm
  • Hi Anyone here use Stripe.All.Mirror.Everything methology? The one claimed by Mr Loaiza 6 years ago? Not long ago I posted to list several I/O problems I have with Storage. I was told yesterday that ...
    Feb 1, 2007 at 8:52 pm
    Feb 3, 2007 at 4:59 pm
  • Hello. My environment is HP UX 11i. DB Version On this database I have Oracle replication is in action, replicating certain tables to another database. I have a very high occurance and time ...
    Shivaswamy RaghunathShivaswamy Raghunath
    Feb 20, 2007 at 10:45 pm
    Mar 2, 2007 at 3:07 am
  • Hello List, Is it possible to share a database sequence between multiple databases? Not in RAC of course. We are planning to have two databses exchanging information (replicating) using third party ...
    Syed Jaffar HussainSyed Jaffar Hussain
    Feb 26, 2007 at 9:13 am
    Feb 27, 2007 at 6:17 am
  • We have 1 development box, 1 test database, and one production database all about 10 GBs each. I am the sole Oracle person on the team. My background is more on the developer side than DBA side. I ...
    Feb 27, 2007 at 5:48 pm
    Feb 28, 2007 at 9:23 pm
  • hi all, i have 3 nodes of 9204 RAC under rhel 2.1 SQL host lsnrctl status LSNRCTL for Linux: Version - Production on 19-FEB-2007 10:53:44 Copyright (c) 1991, 2002, Oracle Corporation. All ...
    Ujang JaenudinUjang Jaenudin
    Feb 19, 2007 at 5:15 am
    Feb 26, 2007 at 7:26 am
  • Hi List, Is there a way though which I can found out the column name causing an ORA-01438? I tried tracing the session, unfortunately, the trace file doesn't have any cluses about the column causing ...
    Syed Jaffar HussainSyed Jaffar Hussain
    Feb 21, 2007 at 9:11 am
    Feb 22, 2007 at 4:06 pm
  • <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" Here is who has responded so far... Bill Connor Suzy Vordos Walt Weaver Babette Turner-Underwood Barbara Baker Robert Freeman Cosmin ...
    Tim GormanTim Gorman
    Feb 9, 2007 at 10:33 pm
    Feb 12, 2007 at 6:43 pm
  • Folks What additional SETUP is needed to ADD the 2nd instance to STATSPACK? NOTE - SQL ?/rdbms/admin/spcreate has been Run from the 1st RAC instance. Running sprepins shows only 1 instance, below SQL ...
    Feb 6, 2007 at 2:37 pm
    Feb 23, 2007 at 3:22 pm
  • One of my sysadmin's got this from Oracle today. They call it a "patch" but from what I can tell this would be a new install. Anyone have any specs on exactly what all this software monitors, how ...
    Ethan PostEthan Post
    Feb 19, 2007 at 6:10 pm
    Feb 20, 2007 at 7:21 pm
  • Hi all, While investigating a hot table in, I see that one of the SELECTs hitting it has multiple children. No big deal, I'll just use my buddy V$SQL_SHARED_CURSOR to see the issue, right? ...
    Rich JesseRich Jesse
    Feb 21, 2007 at 4:21 pm
    Feb 27, 2007 at 5:04 pm
  • hi all, anyone working w/ the slew of Oracle Apps out there? I'm looking to print out master ERD's, for each of the schema's --for learning purposes -- including the columns, joins, pk's, fk's and ...
    Cosmin ioanCosmin ioan
    Feb 2, 2007 at 4:46 pm
    Feb 12, 2007 at 8:59 pm
  • After we upgraded one of our databases from to, our rman backup took 4 to 5 times longer. We began seeing that 65% of the time was being spent in control file sequential reads. We ...
    Orysia HusakOrysia Husak
    Feb 26, 2007 at 9:46 pm
    Feb 28, 2007 at 5:47 pm
  • Dear all, I've been asked to help "tuning" an Hibernate+Oracle application. After a first glance at the application, I feel that the best tuning advice would be mv Hibernate /dev/null but - does ...
    Alberto Dell'EraAlberto Dell'Era
    Feb 9, 2007 at 8:08 pm
    Feb 13, 2007 at 1:27 pm
  • Do you use an IFILE parameter in a network configuration file (tnsnames.ora, sqlnet.ora, other) to consolidate entries in a central location? I guess it's an obsolete practice and I should stop. I've ...
    Jacques KilchoerJacques Kilchoer
    Feb 8, 2007 at 9:32 pm
    Feb 12, 2007 at 8:43 am
  • Hi List, I am looking for pointers to material that could help exam preparation ( besides standard sources ). -- Regards, Ranko Mosic Contract Senior Oracle DBA B. Eng, Oracle 10g, 9i Certified ...
    Ranko MosicRanko Mosic
    Feb 2, 2007 at 1:54 am
    Feb 3, 2007 at 4:38 pm
  • Hi all I was wondering what event does Oracle show when the process cannot get CPU cycles? TIA Alex -- http://www.freelists.org/webpage/oracle-l
    Feb 28, 2007 at 8:23 am
    Feb 28, 2007 at 7:44 pm
  • Hi I had faced an interesting scenario yesterday when I moved some code from Dev to QA and tried to execute the queries, they behaved very differently. QA was newly refreshed with the data using ...
    Sanjay MishraSanjay Mishra
    Feb 19, 2007 at 4:52 pm
    Feb 20, 2007 at 4:29 pm
  • Hi all, I've been handed a vendor (let's call them "A") database that has a schema wide open with GRANT SELECT, INSERT, UPDATE, DELETE TO PUBLIC on all of the hundreds of tables. Now I need ...
    Rich JesseRich Jesse
    Feb 13, 2007 at 10:12 pm
    Feb 19, 2007 at 5:51 pm
  • This past weekend, we patched our Production Sun servers with Solaris patches and the Oracle DST patch. On two of those servers which host standby databases (one server for physical, one server for ...
    Mark StricklandMark Strickland
    Feb 13, 2007 at 8:34 pm
    Feb 16, 2007 at 1:12 pm
  • Those of you that work in the USA, or even for USA based companies know what I'm referring to here. I am curious what type of reporting you do to document the tests for your SOX controls in regards ...
    Jared StillJared Still
    Feb 12, 2007 at 6:48 pm
    Feb 14, 2007 at 1:26 pm
  • Hi, We have a query like following that includes the & symbol and since this is a special character so Oracle prompts for the input. Is there any way to suppress this special character in a query ...
    Harvinder SinghHarvinder Singh
    Feb 5, 2007 at 9:02 pm
    Feb 6, 2007 at 9:27 pm
  • I am getting weird results from a NOT IN and NOT EXISTS query. Could this be because of NULL's or is it a bug? XX is the child table. YY is the parent table. There are some NULL's in XX.PH column ...
    Feb 1, 2007 at 7:47 pm
    Feb 1, 2007 at 10:06 pm
  • Primary DB Configuration: a 2 node RAC cluster Solaris: 5.9 Generic_118558-25 sun4u sparc SUNW,Netra-T12 Oracle: RAC Veritas Cluster: Symantec/Veritas Storage Foundation for Oracle RAC 4.1 ...
    Daniel koehneDaniel koehne
    Feb 27, 2007 at 8:12 pm
    Mar 9, 2007 at 10:51 pm
  • Of recruiters, and indeed their candidates. So I got a CV (resume) today. The agent's email was entitled "The Best Developer in England" and urged me to get in contact quickly to avoid a 'bidding ...
    Niall LitchfieldNiall Litchfield
    Feb 6, 2007 at 9:57 am
    Feb 8, 2007 at 5:34 pm
  • Someone just passed this on to me. I checked a coupl of my systems and didn't find it. It's an editor for modifying dbfs. The page: <http://www.petefinnigan.com/weblog/archives/00000999.htm refers to ...
    William WagmanWilliam Wagman
    Feb 1, 2007 at 1:40 am
    Feb 1, 2007 at 7:23 pm
  • Hi all, We have a query which is run everyday and was running OK till last week. The query starts hanging for the past 2 days when run. Oracle is 9.2. We run this query for today's date ...
    Ram RamanRam Raman
    Feb 28, 2007 at 7:13 pm
    Mar 2, 2007 at 2:21 am
  • Last week at RMOUG there was a round table discussion on DST patching. I was rather insistent that there was a utltzuv3.sql script. As many of you know, there is not. The script is utltzuv2.sql, but ...
    Jared StillJared Still
    Feb 20, 2007 at 8:04 pm
    Feb 24, 2007 at 8:47 pm
  • Hi DBAs, We are testing our application (Fox Pro using ODBC) on a brang new server with Oracle10g (10.2). We having some performance problems regarding some SQL statement. The problem is: With the ...
    Luc DemancheLuc Demanche
    Feb 20, 2007 at 8:38 pm
    Feb 20, 2007 at 11:22 pm
  • Elementary question but.... Say I have schema data_owner - this guy owns his data and can do what he likes in that schema. I want to create a user "data_select" who can only select from "data_owner" ...
    Feb 14, 2007 at 5:48 pm
    Feb 17, 2007 at 12:13 am
  • Anyone know of a white paper or other writings on the subject? I'd really appreciate links!! Dick Goulet, Senior Oracle DBA 45 Bartlett St Marlborough, Ma 01752, USA Tel.: 508.573.1978 |Fax ...
    Richard J. GouletRichard J. Goulet
    Feb 13, 2007 at 9:04 pm
    Feb 15, 2007 at 8:01 pm
  • We're AIX 5.2 Oracle 9206 and need to export data from prod to our test instance for refresh. I thought I had read where I could use pipes and export/move data to test box/import all at the same time ...
    Feb 13, 2007 at 1:28 am
    Feb 14, 2007 at 12:29 am
  • Per note *359515.1* nfs mounts are supported for datafiles with oracle 10. Does anyone know if the same applies for 9.2 databases? I urgently need to create a clone of a 9.2 environment, but suprise ...
    Niall LitchfieldNiall Litchfield
    Feb 7, 2007 at 10:30 am
    Feb 8, 2007 at 6:48 pm
  • folks, and luckily user was SHUTDOWN ABORT database after make datafiles OFFLINE, so when startup, it always try to find the missing undo file..... this is worst case, please help me on this ...
    Ujang JaenudinUjang Jaenudin
    Feb 28, 2007 at 1:45 pm
    Feb 28, 2007 at 9:54 pm
  • Hi All, We are uprading our PeopleSoft environment this weekend from Oracle to Oracle (with DST and Oct CPU patches) on Aix 5.3. The PeopleTools will also be upgraded to PeopleTools ...
    Parvez BashirParvez Bashir
    Feb 23, 2007 at 6:03 pm
    Feb 27, 2007 at 11:35 pm
  • Is there anything else for name resolution, except OID and tnsnames? I am not installing yet another database just for the name resolution. There used to be Oracle*Names, but some smart guy decided ...
    Mladen GogalaMladen Gogala
    Feb 21, 2007 at 4:17 pm
    Feb 27, 2007 at 6:01 pm
  • Hi Folks, I have a ASM instance running on Solaris 9 with the following scenario: All raw disk slices are 5GB in size I have created a normal redundancy ASM diskgroup with two failure groups ...
    Hameed, AmirHameed, Amir
    Feb 23, 2007 at 6:13 pm
    Feb 25, 2007 at 10:56 pm
  • Hi all, Our DB team came up with the following DST strategy in an attempt to balance risk with patch application resource costs for a target space of 73 dev/test and 55 production databases (2 8i, 35 ...
    Parvez BashirParvez Bashir
    Feb 22, 2007 at 3:51 am
    Feb 23, 2007 at 4:23 pm
  • I will attempt to summarize what I have gleaned and applied. There is no official patchset for utltzuv2.sql, patchset 5601428 before upgrading. There is however a 4689959 patchset for the ...
    Feb 7, 2007 at 2:07 pm
    Feb 22, 2007 at 10:54 pm
  • In all the research and testing I have done, I cannot find a function that will return the timezone for what you need. You can get the time in a different timezone and some things like that, but I ...
    Feb 15, 2007 at 7:48 pm
    Feb 16, 2007 at 6:59 pm
  • or node if you prefer. :) This document is the place to start - ML Note *403659.1** * Don't be misled by its title "*2007 Daylight Saving Time Changes For Oracle Applications"* It contains to the top ...
    Jared StillJared Still
    Feb 12, 2007 at 9:28 pm
    Feb 14, 2007 at 3:54 pm
  • Listers, I need to identify memory chunks (addresses + sizes) within large pool where certain areas are located. I know how to do it with shared pool areas. The total area size is in X$KSMSS and ...
    Alex GorbachevAlex Gorbachev
    Feb 11, 2007 at 5:37 pm
    Feb 12, 2007 at 5:43 pm
Group Navigation
period‹ prev | Feb 2007 | next ›
Group Overview
grouporacle-l @

250 users for February 2007

Alex Gorbachev: 49 posts Jared Still: 43 posts Allen, Brandon: 34 posts Kevin Closson: 33 posts Niall Litchfield: 29 posts Joel.Patterson_at_crowley.com: 28 posts Nigel Thomas: 26 posts Mercadante, Thomas F \(LABOR\): 24 posts Dennis Williams: 22 posts Mark J. Bobak: 20 posts Syed Jaffar Hussain: 20 posts Kerber, Andrew: 19 posts Richard J. Goulet: 19 posts Tim Gorman: 16 posts LS Cheng: 15 posts Naqi Mirza: 15 posts Don Seiler: 14 posts Fmhabash_at_gmail.com: 14 posts Ghassan Salem: 14 posts Mladen Gogala: 14 posts
show more