[Oracle-l] Ora 1652

Takes a REEEALLLLL MAAAANNNNN (or
Rachel) to run something like that!!!!

And believe it or not, we're still in business. :>)

From: "Gogala, Mladen"
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L
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).