RE: Error in creating tablespace

From: Nirmal Kumar Muthu Kumaran <NIRMALK_at_qtel.com.qa>
Date: Thu, 20 Sep 2001 03:23:58 -0700
Message-ID: <F001.0039352C.20010920025521@fatcity.com>

Hi,

Here the following are ERROR details:

> > ORA-19502: write error on file "C:\PAYROL.ORA", > > blockno 1 (blocksize=2048)

ORA-19502
ORA-19502write error on file name, blockno name (blocksize=num) Cause:A write error was detected on the output file. Action:Check that the file is not corrupt and retry the operation.

        2)      > > OSD-04026: Invalid parameter passed.
                > > O/S-Error: (OS 64) The specified network name is

----------------------------------------------------------------------------
-------------------------------------------------

OSD-04026
OSD-04026Invalid parameter passed
Cause:This is an internal error, not normally expected to occur. Action:Contact Oracle Worldwide Customer Support.

So please try to do the action's part from the help.

Regards,
Nirmal

> -----Original Message-----
> From: ASHRAF SALAYMEH [SMTP:ashraf_salaymeh_at_yahoo.com]
> Sent: Thursday, September 20, 2001 12:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Error in creating tablespace
>
> Hi List,
>
> I tryed to create the tablespace from svrmgr30
> as satar naghshineh told me.
> But i still face the same error...
> CREATE TABLESPACE PAYROLL
> DATAFILE 'C:\PAYROL.ORA' SIZE 10M
> SQL> /
> ERROR at line 1:
> > > ORA-19502: write error on file "C:\PAYROL.ORA",
> > > blockno 1 (blocksize=2048)
> > > ORA-27069: skgfdisp: attempt to do I/O beyond the
> > > range of the file
> > > OSD-04026: Invalid parameter passed.
> > > O/S-Error: (OS 64) The specified network name is
>
> Any one can tell me what I have to do?
>
> Regards,
> Ashraf
> --- satar naghshineh <satarnag_at_yahoo.com> wrote:
> > Salaam Ashraf Jon,
> >
> > It appears that Oracle has a problem writing to the
> > C
> > drive to create the datafile on the very first
> > block.
> > This error is usually the result of a size issue
> > over
> > 4gb for the datafile or a file that has been
> > autoextended. In your case, it appears it doesn't
> > like
> > the command (maybe some character is being passed
> > through the command?).
> >
> > Delete the file and re-try it again. try doing this
> > in
> > svrmgrl80 and put a ; at the end.
> >
> > Good Luck,
> > Satar Naghshineh
> >
> >
> >
> > --- ASHRAF SALAYMEH <ashraf_salaymeh_at_yahoo.com>
> > wrote:
> > > Hello list,
> > >
> > > I'm using Personal Oracle8 Database and Win98
> > > Platform
> > >
> > > I issued this command from Sqlplus8.0 :
> > >
> > > CREATE TABLESPACE PAYROLL
> > > DATAFILE 'C:\PAYROL.ORA' SIZE 10M
> > > SQL> /
> > >
> > > I am trying to create new tablespace Payroll but I
> > > have got this error!
> > >
> > >
> > > CREATE TABLESPACE PAYROLL
> > > *
> > > ERROR at line 1:
> > > ORA-19502: write error on file "C:\PAYROL.ORA",
> > > blockno 1 (blocksize=2048)
> > > ORA-27069: skgfdisp: attempt to do I/O beyond the
> > > range of the file
> > > OSD-04026: Invalid parameter passed.
> > > O/S-Error: (OS 64) The specified network name is
> > no
> > > longer available.
> > >
> > >
> > > The strange is you can see the PAYROLL.ORA under
> > C:\
> > > Directory
> > > After the error is displayed.
> > >
> > > But when you query :
> > >
> > > SQL> select tablespace_name
> > > from dba_data_files;
> > >
> > > you can find nothing, no tablespace is created at
> > > all...
> > >
> > > I wish someone can help me to solve this problem.
> > >
> > > Best Regards,
> > > Ashraf Salaymeh
> > >
> >
> >
> > __________________________________________________
> > Terrorist Attacks on U.S. - How can you help?
> > Donate cash, emergency relief information
> >
> http://dailynews.yahoo.com/fc/US/Emergency_Information/
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: satar naghshineh
> > INET: satarnag_at_yahoo.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).
>
>
> __________________________________________________
> Terrorist Attacks on U.S. - How can you help?
> Donate cash, emergency relief information
> http://dailynews.yahoo.com/fc/US/Emergency_Information/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: ASHRAF SALAYMEH
> INET: ashraf_salaymeh_at_yahoo.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nirmal Kumar  Muthu Kumaran
  INET: NIRMALK_at_qtel.com.qa

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 Sep 20 2001 - 05:23:58 CDT