Hey Sean:
The safest and easiest way to deal with this problem is to open up OEM and
change the properties on the tablespace ARTMPSPC to enable auto-extend. I
don't believe that you need to shutdown the database while you do this.
Warm regards,
Adam D Pederson
Principal Consultant
Digital Celerity LLC
---------------------
Work Phone: (925) 895-9500
Work Email: Adam.Pederson@DigitalCelerity.com
---------------------
Client Phone: (510) 627-2268
Client Email: Adam.Pederson@kp.org
---------------------
This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient, or have received this e-mail in error,
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG] On Behalf Of Sean Harrodine
Sent: Friday, January 02, 2004 5:44 AM
To: ARSLIST@ARSLIST.ORG
Subject: ORA-01652 error - ARTMPSPC
Hi there guys and gals.....Happy 2004 to all of you out there !!!
ARS 5.00.01 (no patches) & Oracle 8.1.7.0.0
I noticed a couple of days ago, that when entering a query on my live
server, not a particularily performance friendly query i hasten to add, i
get the following error messages returned.....
ARERR 552 & ORA-01652
Here is an extract of my Oracle alert log.....................
# tail /u01/home/dba/oracle/admin/rdyprd01/bdump/alertrdyprd01.log
SMON: enabling cache recovery
SMON: enabling tx recovery
Tue Dec 23 03:00:31 2003
Completed: alter database open
Tue Dec 23 15:30:20 2003
ORA-1652: unable to extend temp segment by 5 in tablespace ARTMPSPC
Tue Dec 23 15:32:16 2003
ORA-1652: unable to extend temp segment by 5 in tablespace ARTMPSPC
Tue Dec 23 15:43:59 2003
ORA-1652: unable to extend temp segment by 5 in tablespace ARTMPSPC
In Oracle, if i select all the information in table dbadatafiles for
tablespacename ARTMPSPC, i get the following.........
FILENAME = /u01/ordata1/oradata/rdyprd01/artmpspcrdyprd0101.dbf
FILEID TABLESPACENAME BYTES BLOCKS STATUS RELATIVEFNO AUT
MAXBYTES MAXBLOCKS INCREMENTBY USERBYTES USERBLOCKS
------- --------------- -------- ------ --------- ------------ --- --------
--------- ------------ ---------- -----------
10 ARTMPSPC 15728640 1920 AVAILABLE 10 NO
0 0 0 15720448 1919
Does anyone out there know................
Questions
1 - Exactly what the ARTMPSPC tablespace is used for ?
2 - To rectify this, i can just add another datafile presumably which is
what everyone on the web seems to do for this Oracle error ?
3 - Can i use RESIZE to increase the file 'safely' ?
And finally, do i need to shut down Remedy to perform either points 2 or 3 ?
TIA and i hope everyone had a good Xmas !!!
rgds,
Sean
UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com
Previous Topic
Index