From: Mark D Powell <markp7832@my-deja.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Newbie: ORA-01653 and ORA-01119
Date: Fri, 02 Feb 2001 13:58:26 GMT
Organization: Deja.com
Lines: 85
Message-ID: <95eedt$su4$1@nnrp1.deja.com>
References: <MPG.14e36348da7ccc259897fc@news.earthlink.net> <95c9d8$2am$1@nnrp1.deja.com> <MPG.14e378cb31c72ba3989800@news.earthlink.net>
NNTP-Posting-Host: 199.228.142.8
X-Article-Creation-Date: Fri Feb 02 13:58:26 2001 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)
X-Http-Proxy: 1.0 x52.deja.com:80 (Squid/1.1.22) for client 199.228.142.8
X-MyDeja-Info: XMYDJUIDmarkp7832


In article <MPG.14e378cb31c72ba3989800@news.earthlink.net>,
  Richard <huddler@earthlink.net> wrote:
> In article <95c9d8$2am$1@nnrp1.deja.com>, markp7832@my-deja.com
 says...
> > In article <MPG.14e36348da7ccc259897fc@news.earthlink.net>,
> >   Richard <huddler@earthlink.net> wrote:
> > > Oracle Enterprise 8.1.5
> > > SPARC 2.7 64 bit
> > >
> > > Getting the error message
> > >
> > > > ORA-01653: unable to extend table SYS.TCAS_TCPPKTDATA
> > > > by 12137 in tablespace SYSTEM
> > >
> > > when attempting to insert records into a database.  Inserts are
 done
 via
> > > ODBC and JDBC, and were working with no problems until we hit some
 wall
> > > and started getting ORA-01653 two days ago.
> > >
> > > The datafile storage is on
 path /data/oracledb/oradata/TCAS.  /data
 is
> > > the sole partition on a very large disk.  16 GB of that space is
> > > currently AVAILABLE.
> > >
> > > When I attempt to use the SQLPLUS interfact the ALTER TABLESPACE
 ADD
> > > DATAFILE, I get ORA-01119 (no space on device).  I directly
 specify
 the
> > > '/data/oracledb/oradata/TCAS/<datafile>.dbf' -- but I still get an
 ORA-
> > > 01119.  (There's 16 GB free on that device.  I don't get it.)
> > >
> > > When I attempt to simply resize the datafile
> > > '/data/oracledb/oradata/TCAS/system01.dbf' I get a file not found
 error.
> > >
> > > I can list that file, currently sized at 183+ MB.  I'm very sure
 I'm
> > > typing correctly.
> > >
> > > I am going quite nuts over this.  Any help greatly appreciated.
 
> > Ignoring the fact you apparently have user objects in the system
> > tablespace under the SYS id...
>
> (I didn't build the database, I just have to solve this problem.)
>
> > ....since you have space on the disk, have you
> > checked to see if you have filled the OS level file system?  You did
> > not specifiy how you are checking the space and maybe it is
 something
> > simple. Have you checked the ulimit for the Oracle account? Was the
> > database built on conventional files or were links to raw partitions
> > used requiring you to first create another link and add it to the
> > database?
>
> /data is the sole mount point on the device.  df -k shows 16+ GB
> available--3% used--on /data.
>
> /data/oracledb/oradata/TCAS is where the data files are.
>
> I don't believe it's an OS file system problem.
>
> I'll check the ulimit, though.  Thanks for the "is it plugged in?"
> reminder.
>
> --
> No one dies wishing they'd spent more time at the office.
>
> This post simply contains some of my personal opinions.
> ObURL:  http://home.earthlink.net/~huddler
>
If has occurred to me that the ORA-01119 can be caused by permissions.
Does the the current Oracle owning account own the file system?
--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com
http://www.deja.com/