RE: !!Please Read - Oracle-L is moving!!

2004-01-28 Thread babette.turnerunderwood
Title: Message I must disagree . . . this resource is worth MUCH more than the minimal effort it took :-) But if it clears out the dead subscribers, perhaps we should list addresses every 6 months ;-) Babette Turner-Underwood work: [EMAIL PROTECTED] home: [EMAIL PROTECTED] 954-3752 (Mon

RE: !!Please Read - Oracle-L is moving!!

2004-01-28 Thread babette.turnerunderwood
Oops ... Had a typo in the second sentence It should have read But if it clears out the dead subscribers, perhaps we should CHANGE list addresses every 6 months ;-) I was AGREEING that the changing list addresses was a minimal amount of work compared to the amount that we get back out of

RE: !!Please Read - Oracle-L is moving!!

2004-01-28 Thread babette.turnerunderwood
Phew, I would hate to have the Oracle Goddess in disagreement with me. I have already had a bad enough day Arguing with one of the other DBAs about how long a recovery took. (It was just testing that recovery would work... Proof of concept... Not testing for recovery timing AAAarrgh!)

RE: IBM Workload Manager (WLM)

2003-12-30 Thread babette.turnerunderwood
We are using Oracle on OS/390 and WLM. If you are using AIX instead of MVS you will have a different flavour of WLM. Basically each of our databases on the mainframe runs within a service (think of services on Windows NT). Each service is associated with a WLM class. Originally, we capped each

RE: background process LGWR did not start

2003-12-05 Thread babette.turnerunderwood
Is it possible there are stuck memory segments (using ipcs -m when instance is shutdown) ?? Any other errors in alert log, etc ? - Babette -Original Message- Sent: 2003-12-04 9:34 AM To: Multiple recipients of list ORACLE-L Anyone know what might be causing this error? Oracle 8.1.7

RE: Anyone run into this strange ORA-00904 error ??

2003-12-03 Thread babette.turnerunderwood
Title: Message Thanks for all the ideas folks we decided to restore the TEST database instead of pursue so we would have less down time (problem was relatively recent). THEN in the middle of cold backup restore, I started seeing the same thing in my development instance . !!!

Anyone run into this strange ORA-00904 error ??

2003-12-02 Thread babette.turnerunderwood
Title: Anyone run into this strange ORA-00904 error ?? We started having a weird problem that looks like some kind of data dictionary corruption. My first choice is to run catalog / catproc. This did nothing to resolve the problem. Why am I able to describe an object, but get ORA-00904

RE: OT - MVS / Java / Oracle 9iAS

2003-12-01 Thread babette.turnerunderwood
Title: Message I got an e-mail from developer with more details. Hope this information is useful Full description of the exception being thrown is included below: java.lang.ClassFormatError: __Proxy0 (Illegal UTF8 string in constant pool)at java.lang.ClassLoader.defineClass0(Native

OT - MVS / Java / Oracle 9iAS

2003-11-28 Thread babette.turnerunderwood
Title: OT - MVS / Java / Oracle 9iAS I am a Java-idiot. I am hoping some of the brilliant people on this list can help me A developer came to me with a problem they are having. He is setting up a JVM to run under USS (Unix System Services) on OS/390 v2.10 He has java code that uses

RE: Happy Thanksgiving

2003-11-27 Thread babette.turnerunderwood
I can related to that. I recently started the South Beach diet (or at least as much of it as I can figure out, without actually reading up on it or anything). One day my 9 year old son was thinking of the Atkins diet and asked me, what kind of diet are you on Mommy? Are you on that Atgony

RE: Oracle Magazine Awards

2003-11-21 Thread babette.turnerunderwood
Title: Message The President of our local user group, Peter Smith, won the PL/SQL Developer of the Year award. We had our user group meeting yesterday afternoon. (I had previously arranged to have the Oracle Rep bring about 20 copies of the Oracle Magazine). We had fun publicly

RE: Finding overlapping time periods - suggestions please

2003-11-03 Thread babette.turnerunderwood
Mladen, Unfortunately, the density of your proposed option has warped the space continuum around us and made this option unusable... That and the fact I would have to take two years of University Mathematics to fully comprehend and appreciate the theory, makes this less than optimal in terms

Finding overlapping time periods - suggestions please

2003-10-31 Thread babette.turnerunderwood
Title: Finding overlapping time periods - suggestions please I was wondering if anyone had the need to find overlapping time periods and how to identify them efficiently. Here is the scenario: Elapsed minutes refer to the actual clock time either spent on a given task. Thus an activity

RE: Finding overlapping time periods - suggestions please

2003-10-31 Thread babette.turnerunderwood
Title: Message Reformating chart as came out really bad in e-mail ActivityStart---End---Elapsed---ElapsedElapsed--Prorated--Prorated TimeTime--Minutes---Mutlitask--Single---Multi-Minutes MinutesMinutes--Minutes

RE: Conflicting Java VM after Oracle 9.2 client install

2003-10-28 Thread babette.turnerunderwood
We had a similar problem with a IE application using a particular version of Java - it broke once we did an Oracle 9i client install. Not sure if the same thing might help you. The workaround that I used was to export the registry for the Java Version (HKEY_LOCAL_MACHINE - JavaSoft - Java

RE: Problem in dropping Materialized View

2003-10-17 Thread babette.turnerunderwood
Title: Message Re-create the materialized view and then try to drop it. Because you tried to rename it to the view name, I would say try it both as the view name and as the original name. I know it sounds silly but we had this problem once and creating it , will create whatever internal

RE: Opinions sought on possible TOAD replacement

2003-10-16 Thread babette.turnerunderwood
Title: Message We do something similar here. Developers gets Golden (from Benthic). Which has a nice little PL/SQL Editor and SQL spreadsheet. DBAs get TOAD. Babette Turner-Underwood work: [EMAIL PROTECTED] home: [EMAIL PROTECTED] 954-3752 (Mon - Fri 7am - 3pm) -Original

RE: COBOL TO ORACLE

2003-10-08 Thread babette.turnerunderwood
Welcome to MY world :-( Basically, we need to get a Volkswagen to run faster than a Ferrari. -Original Message- Sent: 2003-10-07 4:29 PM To: Multiple recipients of list ORACLE-L I went to IBM's web site (http://www-1.ibm.com/servers/eserver/zseries/os/) and found OS/390 -

RE: COBOL TO ORACLE

2003-10-07 Thread babette.turnerunderwood
Sorry for the delay ... Was at Ottawa Oracle User Group Days last week and spent the time since then playing catch-up Yes, we are using OS/390 v10. I STRONGLY suspect the SYSADMIN is wrong. There HAS to be swapping / paging going on, but he insists this is not the case. Babette

RE: COBOL TO ORACLE

2003-10-01 Thread babette.turnerunderwood
Then perhaps you can help me . . . We are suffering through a Pro*Cobol / Oracle on the mainframe implementation for a newly developed in house application. We have a mainframe with 1.7GB - 2GB REAL memory. 4 CPU machine - we have two logical CPUs in our LPAR We have 8 instances running (each

RE: Apps 11.5.8 and 9i

2003-09-23 Thread babette.turnerunderwood
22 CDs huh? Any one know where to get free trial software for Apps? Anyone want to burn me 22 CDs? Just kidding... I haven't work with Financials since 10.7 and feel like I am rapidly losing my financials skills. I want to set this up at home. I figure I would use it for my personal accounting