Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Ora 1652

RE: Ora 1652

From: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Thu, 20 Jul 2000 23:54:23 GMT
Message-Id: <10564.112599@fatcity.com>


Not the last time I looked I wasn't!

Welcome back Mladen, I've missed the grins from your posts.....

>From: "Gogala, Mladen" <MGogala_at_oxhp.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Ora 1652
>Date: Thu, 20 Jul 2000 08:05:16 -0800
>
>May I use RH 6.2? I know that this would make things a kind of
>too easy, but I really need glbc 2.1. And another question: is
>Rachel a real man?
>
>-----Original Message-----
>Sent: Thursday, July 20, 2000 12:24 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Wow. Once again, Mladen proves to the world (well, this list, anyway) that
>he has WAY too much time on his hands. :>)
>
>You can tell me all about RAID5, Legato, RMAN, and DLT-whatever. That's
>yuppie stuff. Try running Oracle on an e-Machine, Redhat 5.2 with 128mb
>RAM,
>Apache web server and 15 hosted sites. Takes a REEEALLLLL MAAAANNNNN (or
>Rachel) to run something like that!!!!
>
>And believe it or not, we're still in business. :>)
>
>:>) :>)
>
>--Walt Weaver
> Bozeman, Montana, USA
>
>P.S. Thanks for posting, Mladen. You haven't been doing enough of it
>lately.
>P.P.S I'm in for it now... should've just gone to bed...
>
>-----Original Message-----
>Sent: Wednesday, July 19, 2000 6:46 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Obviously, this error tells you that Oracle cannot extend segment. Oracle
>can fail to extend a segment only because of the lack of the necessary
>space
>in the tablespace. A common wisdom (and OFA, which is anything but the
>common wisdom)
>tells you to separate different object types into the different
>tablespaces.
>Tablespace system should be used for DICTIONARY TRANSACTIONS ONLY. If you
>see somebody to use the tablespace SYSTEM as the temporary tablespace (see
>CREATE LUSER command options) please fell free to shoot the DBA. It would
>also
>be advisable to put the rollback segments into their separate tablespace
>and
>(I know I'm asking too much now!) to separate tables and indexes not only
>to
>the
>separate disks but to the separate controllers as well. When it comes to
>the
>system safety, words like RAID-5, EMC, Legato Networker and DLT7000 robot
>and RMAN
>come into my mind. Running a well designed database with 95% uptime is an
>expensive proposition.
>If you were an internet company, like let's say E-Bay, then you couldn't
>afford
>not to install patches, not to have a hot standby system and not have even
>a
>proper backup and keep your systems down for a week, could you?
>
>-----Original Message-----
>Sent: Wednesday, July 19, 2000 5:06 PM
>To: Multiple recipients of list ORACLE-L
>
>
>When I checked yesterday's alert logs, I found the following error:
>
>ORA-01652 unable to extend temp segment by (num) in tablespace SYSTEM.
>
>I've forgotten what the actual number was. The recommended action is to
>add
>a datafile. However, when I checked the existing datafile, it is less than
>50% full, with 20 MB remaining, and 11 MB in the next available extent.
>
>Does anyone have any idea what is causing this? For now, I plan to see if
>the error occurs again, and then add another datafile if necessary. The
>error occurred during business hours (ie. when the database was in use) and
>we also have developers working on an update, although they are supposed to
>be working on the development database.
>
>Thanks.
>
>- Kristen Cameron
>Indian and Northern Affairs Canada
>Yellowknife, NT
>
>--
>Author: Kristen Cameron
> INET: cameronkgd_at_inac.gc.ca
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Author: Gogala, Mladen
> INET: MGogala_at_oxhp.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Author: Weaver, Walt
> INET: wweaver_at_rightnowtech.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Author: Gogala, Mladen
> INET: MGogala_at_oxhp.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).


Received on Thu Jul 20 2000 - 18:54:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US