Search Discussions

142 discussions - 798 posts

  • Hi, I just wanted to check to see if anyone out there have implemented Oracle11g in production yet and what the feedback is. I did a search but couldn't find this information. Appreciate your ...
    Chandra PabbaChandra Pabba
    Feb 20, 2009 at 3:29 pm
    Feb 26, 2009 at 10:44 pm
  • Because the day of the week (0-6 with 0=Sunday). Chris From: oracle-l-bounce_at_freelists.org On Behalf Of Eugene Pipko Sent: Tuesday, February 24, 2009 12:15 PM To: 'oracle-l@freelists.org' ...
    Newman, ChristopherNewman, Christopher
    Feb 24, 2009 at 6:23 pm
    Mar 18, 2009 at 5:31 pm
  • Environment: RAC/ASM on Solaris 10 I'm trying to find an efficient way to get the bind values for statements that are involved in a deadlock situation. So far, I'm able to get the bind ...
    Barun, VladoBarun, Vlado
    Feb 21, 2009 at 1:33 am
    Mar 5, 2009 at 10:55 pm
  • Hi All, I am newbie on windows. I am entering following command on dos command prompt oradim -startup -sid TEST �usrpwd manager -starttype SRVC,INST -pfile ...
    Harshan eppuramHarshan eppuram
    Feb 21, 2009 at 3:27 am
    Feb 25, 2009 at 2:33 pm
  • I just found Metalink note 781763.1 that addresses this exact issue and unfortunately the only solution appears to be moving to different hardware. Privileged/Confidential Information may be ...
    Allen, BrandonAllen, Brandon
    Feb 12, 2009 at 5:37 pm
    Jun 25, 2009 at 6:25 am
  • Is there away in rman to backup all logs on disk, but delete n days old ones. The backup ... Logs ... Delete input does not allow to have separate criteria for backup vs. Delete. Thanks -- ...
    Feb 17, 2009 at 7:35 pm
    Mar 25, 2009 at 4:25 am
  • Hello Good Morning!! Hope every one doing good. This morning I am trying to login to my windows database. It showing a strange error. How should I resolve this. D:\ sqlplus "/as sysdba" SQL*Plus ...
    Nilesh kumarNilesh kumar
    Feb 4, 2009 at 2:55 pm
    Feb 5, 2009 at 7:44 pm
  • Oracle 10g and 11g. REDHAT LInux I have just been told by a consultant that a standby on the same box as a primary is not recommended.(We also have a standby on another box) My feeling is that will ...
    Howard LathamHoward Latham
    Feb 3, 2009 at 10:55 am
    Feb 4, 2009 at 6:49 pm
  • *C:\Documents and Settings\nlitchfield sqlplus /nolog* *SQL*Plus: Release - Production on Mon Feb 9 21:11:14 2009* *Copyright (c) 1982, 2007, Oracle. All rights reserved.* *SQL * ** *I ...
    Niall LitchfieldNiall Litchfield
    Feb 9, 2009 at 9:12 pm
    Feb 11, 2009 at 4:40 pm
  • Hi, We have oracle 10G as sever version. For oracle client version : Any client version from 8i to 11G would probably work fine with 10G server version. However, can someone tell a stable client ...
    A JoshiA Joshi
    Feb 7, 2009 at 8:13 pm
    Feb 10, 2009 at 9:37 pm
  • Hello All, Good Afternoon!! Hope Every one is doing great and preparing for the Weekend!! I have a issue with the dataguard, The logs are not gettitng transferred in the Standby database from the ...
    Nilesh kumarNilesh kumar
    Feb 6, 2009 at 7:17 pm
    Feb 6, 2009 at 8:46 pm
  • Use the Query parameter of exp to get small enough parts of the table so that the successive *.dmp files cam be zipped up and moved? Jack C. Applewhite - Database Administrator Austin I.S.D. - MIS ...
    Feb 4, 2009 at 2:36 pm
    Feb 7, 2009 at 6:59 am
  • Greetings, I'm having a conversation with one of my co-workers re privileges, oracle and windows. I am working with Windows Server 2003, 64-bit and Oracle 10gR2. Our standard practice is to create an ...
    William WagmanWilliam Wagman
    Feb 10, 2009 at 5:06 pm
    Feb 19, 2009 at 1:31 pm
  • We have another performance problem to solve. The performance that was good, now is bad. Very bad with an unacceptable performance and nobody makes any changes to the system. Nor the analyst neither ...
    Roberto VeigaRoberto Veiga
    Feb 24, 2009 at 2:01 pm
    Feb 27, 2009 at 3:55 am
  • Hi, I am looking for a shell equivalent of set echo on. set -x works and gives the output on the screen. I am looking for a way so that it also goes to the LOGIFLE. So I can get the command being ...
    A JoshiA Joshi
    Feb 28, 2009 at 8:45 pm
    Mar 14, 2009 at 6:10 am
  • I have been tasked to replicate an alpha server with openvms on to a I64 integrity. I need to acquire pro*fortran to install on the integrity server. Do I need to buy the full enterprise oracle in ...
    Zakai KinanZakai Kinan
    Feb 18, 2009 at 4:00 am
    Feb 18, 2009 at 7:47 pm
  • Greetings, I'm running oracle on RHEL4, all 64-bit. I have a login.sql where a few usernames and passwords are defined and I am able to connect successfully... [oracle_at_critpinn ~]$ ...
    William WagmanWilliam Wagman
    Feb 19, 2009 at 9:19 pm
    Feb 23, 2009 at 11:25 pm
  • Hi Gurus, Kindly clarify my doubt on datafile size. I have noticed that the datafile size is different from OS level vs database. When I query to get the size of SYSAUX tablespace on database it ...
    Nagaraj SNagaraj S
    Feb 9, 2009 at 6:33 pm
    Feb 10, 2009 at 8:18 pm
  • I don't do alot of recoveries, so when I need to do something, I always end up googling it. So I want to write myself some notes for some of the basic scenarios. Here is my list so far. I keep notes ...
    Dba DBADba DBA
    Feb 7, 2009 at 8:27 pm
    Feb 10, 2009 at 12:12 pm
  • I upgraded yesterday from to and now I get this error when running rman: RMAN-10002: ORACLE error: ORA-00096: invalid value SIGNATURE for parameter remote_dependencies_mode, must be ...
    Zelli, BrianZelli, Brian
    Feb 28, 2009 at 11:46 am
    Mar 2, 2009 at 6:17 pm
  • Hi listers, What could cause an Insert in a Global Temporary Table takes a lot of time? This is how I do the insert: Insert into TT (...) Select .. From ... The insert is being done in a SP. The Temp ...
    Amir GheibiAmir Gheibi
    Feb 25, 2009 at 7:49 am
    Feb 25, 2009 at 5:46 pm
  • What is a quick way to find (thru SQL or otherwise) all the packs (partitioning, diagnostic etc.) that are installed in a database on a given server? -Thanks -- ...
    Deepak SharmaDeepak Sharma
    Feb 19, 2009 at 3:15 pm
    Feb 19, 2009 at 6:44 pm
  • We have a problem connecting to a database that we have not seen before, and I am wondering if any else has encountered it. OS: Windows2003 32-bit Database Version: Only one Oracle Home on ...
    Reimer, John J.Reimer, John J.
    Feb 10, 2009 at 9:42 pm
    Feb 19, 2009 at 6:15 pm
  • Hi, Does anyone know how to find list of all the SQLs involved in a transaction? Regards, Vishal Gupta http://www.vishalgupta.com -- http://www.freelists.org/webpage/oracle-l
    Vishal GuptaVishal Gupta
    Feb 3, 2009 at 3:59 pm
    Feb 12, 2009 at 2:12 am
  • Are you talking about using datapump and pipes? I am not familiar with using pipes with traditional export/import. If it's possible, can you please reference an article or manual that details this ...
    Michael FontanaMichael Fontana
    Feb 10, 2009 at 3:47 pm
    Feb 10, 2009 at 6:09 pm
  • Is there a way to figure what type of control file is in place without mounting a db? That is, without using the internal db views, via. some sort of file operation on the controlfile itself. thanks ...
    Ahbaid GaffoorAhbaid Gaffoor
    Feb 8, 2009 at 7:21 pm
    Feb 10, 2009 at 3:23 pm
  • Hi, listers A bit broad question... Is there a way to find out (by querying V$ views) what would be the optimal value for db_writer_processes parameter? As changing this parameter requires restart of ...
    Vladimir BaracVladimir Barac
    Feb 9, 2009 at 11:33 am
    Feb 9, 2009 at 4:54 pm
  • I have a question on how to grant select access to a table as part of the table create process, inside the database. I was hoping to use a system trigger (after create on schema). In testing, I ...
    Scott CanaanScott Canaan
    Feb 19, 2009 at 9:21 pm
    Feb 20, 2009 at 2:09 pm
  • Hi, If I have not done a dml transaction in a session : no update, delete or insert etc. I have only done select and some of the objects can be over a db link. So I can do a commit or rollback so ...
    A JoshiA Joshi
    Feb 12, 2009 at 9:31 pm
    Feb 18, 2009 at 12:27 pm
  • I wanted to get recommendations on tools for online reorg/defrag of multi-terrabyte Oracle database. Thanks in advance for your feedback. -Deepak -- http://www.freelists.org/webpage/oracle-l
    Deepak SharmaDeepak Sharma
    Feb 12, 2009 at 10:00 pm
    Feb 18, 2009 at 10:29 am
  • At the company where I'm working right now, I'm part of an architecture effort to come up with our standard design for RAC on Linux across the firm. There will be dozens or possibly hundreds of ...
    Jeremy SchneiderJeremy Schneider
    Feb 6, 2009 at 12:28 am
    Feb 6, 2009 at 7:18 pm
  • Hi, Oracle 10gR2 AIX 6 Within a SQL*Plus script I have a number of calls to PL/SQL procs. I want to, on failure of any of the PL/SQL scripts, drop back to the calling SQL*Plus script and on return ...
    Robertson Lee - lerobeRobertson Lee - lerobe
    Feb 5, 2009 at 5:08 pm
    Feb 6, 2009 at 2:54 pm
  • Hello Everyone Good Afternoon!! Hope Everyone is doing good!!. I am back with one more issue today. Nees your help please. I am getting an error message while creation of dataguard for oracle 10g on ...
    Nilesh kumarNilesh kumar
    Feb 5, 2009 at 8:30 pm
    Feb 6, 2009 at 6:19 am
  • Oracle 11g Redhat Linux, We lost the controlfile from a standby its not THAT important but whats the simplest way to rebuild it? We can backup the primary control file to trace; -- Howard A. Latham ...
    Howard LathamHoward Latham
    Feb 4, 2009 at 4:41 pm
    Feb 4, 2009 at 6:40 pm
  • Dear all, I get an old db from someone who left the company. It is Oracle 10g R2, but i do not have sys or system password, i have administrator privilege to that windows 2003 server where oracle ...
    Bao jiejieBao jiejie
    Feb 25, 2009 at 3:20 am
    Feb 26, 2009 at 10:14 pm
  • Hi All the docs i have read so far talk about how ASM keeps track of disks.But how does ASM keep track of datafiles and say this file belongs to this database etc. regards Hrishy -- ...
    Feb 25, 2009 at 11:15 am
    Feb 26, 2009 at 9:30 am
  • Hi, I use /*+ gather_plan_statistics */ and dbms_xplan.display_cursor(null, null, 'ALLSTATS LAST')) to show a query's plan statistics. There's a A-Time column in the output. Is it the actual time ...
    Feb 23, 2009 at 2:01 am
    Feb 25, 2009 at 7:36 am
  • Hi, List, Has anybody implemented Logical Standby for PeopleSoft database? From oracle documentation, logical standby doesn't support certain data types (collections, user-defined types, etc) and ...
    Li LiLi Li
    Feb 11, 2009 at 4:40 pm
    Feb 17, 2009 at 3:43 pm
  • I'm looking to brush up a bit on my RMAN knowledge, especially in the 11g arena as we begin to plan upgrades of various systems. I already have Oracle Database 10g RMAN Backup & ...
    Greg NorrisGreg Norris
    Feb 3, 2009 at 8:46 pm
    Feb 4, 2009 at 6:28 pm
  • We use FB DB pretty regularly to test application upgrades. We have thought to explore this feature in prod dbs and looking for real-life experience. Has anyone implemented it in production DB's. If ...
    Feb 25, 2009 at 4:22 pm
    Feb 25, 2009 at 10:08 pm
  • Hi all, Could you please tell me If oracle can be installed on Win 2000 or where I can lookup that information? I tried installing it, but installer (gui) won't start. I googled it and found ...
    Eugene PipkoEugene Pipko
    Feb 19, 2009 at 5:58 pm
    Feb 24, 2009 at 7:48 pm
  • Hi All, We are implementing TDE(Transidential Data Encryption) on a solaris box 10gr2 RAC ASM for one of client which is a Bank. We are facing following two issues. This is a 4 TDB database. Joining ...
    Harshan eppuramHarshan eppuram
    Feb 24, 2009 at 12:16 am
    Feb 24, 2009 at 10:01 am
  • All - I hit this bug and spend many hours on it. So I wanted to let others know about it. This was discovered very recently....last week I believe. https://bugzilla.novell.com/show_bug.cgi?id=399966 ...
    LeRoy KemnitzLeRoy Kemnitz
    Feb 16, 2009 at 4:53 pm
    Feb 16, 2009 at 9:58 pm
  • How do i supply "Cancel" in a Unix Shell script after the SQLPLUS command RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL; any tips/ suggestions highly appreciated. Thanks in Advance ( Hot ...
    Feb 13, 2009 at 4:17 am
    Feb 15, 2009 at 8:52 pm
  • Please help me see what am I doing wrong or missing. My system is (freshly installed): OS: OEL 5.2 64 bit Oracle: 64 bit dba' group is primary group for user 'oracle' (created via 'oracle ...
    Branimir PetrovicBranimir Petrovic
    Feb 13, 2009 at 7:50 pm
    Feb 14, 2009 at 12:52 am
  • I would recommend keeping your binary installs on the local filesystem of your servers - NetApp is expensive storage, and it's useful to keep that install local. As far as separating volumes, you ...
    Matthew ZitoMatthew Zito
    Feb 11, 2009 at 7:56 pm
    Feb 12, 2009 at 10:11 pm
  • Hi, Oracle 10.2 AIX 6 Really weird this one, googled and metalinked with no joy. Hope someone has seen this before. Got a couple of rather large complex views. When I try to recompile or grant select ...
    Robertson Lee - lerobeRobertson Lee - lerobe
    Feb 11, 2009 at 3:22 pm
    Feb 11, 2009 at 5:23 pm
  • can the standby handle the job? why not swithover to the standby, then once things are running smooth on the standby, drop the former primary, rebuild on the original primary, add that as a standby ...
    steve montgomerie(Bsteve montgomerie(B
    Feb 5, 2009 at 5:04 am
    Feb 8, 2009 at 6:25 am
  • I need a way to have Oracle execute a query but not send the output to my SQLPlus client -- ie I want to avoid the SQL*Net round trips. The larger SQL*Net round trips causes higher consistent gets ...
    Hemant K ChitaleHemant K Chitale
    Feb 2, 2009 at 3:19 pm
    Feb 5, 2009 at 6:26 pm
  • our company plan to use Hyperion product (version 9.3) and I need create ORACLE database before consult arrive. I checked Hyperion site and did not find any document say how to create DB or any ...
    Dba1 mccDba1 mcc
    Feb 27, 2009 at 7:29 pm
    Mar 2, 2009 at 3:12 am
Group Navigation
period‹ prev | Feb 2009 | next ›
Group Overview
grouporacle-l @

196 users for February 2009

Jared Still: 29 posts : 28 posts Niall Litchfield: 25 posts Dan Norris: 22 posts FMHabash: 21 posts Bobak, Mark: 19 posts Guillermo Alan Bort: 19 posts Stefan Knecht: 18 posts Howard Latham: 15 posts Nilesh kumar: 13 posts Xu, Roger: 12 posts Goulet, Richard: 11 posts M Rafiq: 11 posts Vishal Gupta: 11 posts William Wagman: 11 posts Crisler, Jon: 10 posts Deepak Sharma: 10 posts Mark W. Farnham: 10 posts Allen, Brandon: 9 posts Robert Freeman: 9 posts
show more