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: Why can't I find bug 909635 ?

Re: Why can't I find bug 909635 ?

From: William Beilstein <BeilstWH_at_obg.com>
Date: Mon, 19 Mar 2001 06:51:24 -0800
Message-ID: <F001.002D0833.20010319063544@fatcity.com> 






See the attached message from Metalink



         The import is failing due to statistics on the tables prior to
         the export.  The way to avoid the errors during import, do one
         of the following:

         -Run the import with Analyze=N

         -Remove the statistics from the tables in the schema that is
          being exported prior to the export. Export the schema and then
          import the schema. 
   





 Explanation




         This was a problem filed with [BUG:909635].  What was concluded
         was that the value of dba_tab_columns.num_nulls for the tables
         being exported that generated the ORA-20001 errors had a negative
         NUM_NULLS column before the export was produced.

         The workaround was to either set analyze to N on the import or
         remove statistics prior to the export.  There was no patch
         created for this problem.




 .




>>> Cherie_Machler_at_gelco.com 03/19/01 08:50AM >>>




I have an error on an 8.1.5 export/import.
Metalink shows a reference to bug 909635.
When I search the bug database putting the
bug number 909635 in the bug number field
and pressing search, the search engine


replies that there were no hits.



How can this be?  If a bug is identified in
the knowledge base, it must exist and be
searchable in the bug database.



Sometimes I get so frustrated with Metalink.
We pay so many hundreds of thousands


of dollars for support and I can't even search
Metalink, much less get a person to tell me
the answers to questions that I have.



Can anyone tell me what I might be doing
wrong or forward any information on this
bug to me?



Thanks,



Cherie Machler


Gelco Information Network






"djordjej" <djordjej_at_home.com>@fatcity.com on 03/19/2001 07:26:34 AM



Please respond to ORACLE-L_at_fatcity.com 



Sent by:  root_at_fatcity.com 




To:   Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:





Here is the document from Metalink regading this error:



HTH.


Djordje






Doc ID:


        Note:49946.1


 Subject:

        OERR: ORA 27072 skgfdisp:
        I/O error
 Type:
        REFERENCE
 Status:
        PUBLISHED

                                 Content Type:
                                                  TEXT/PLAIN
                                 Creation Date:
                                                  21-NOV-1997
                                 Last Revision Date:
                                                  08-JUN-1999
                                 Language:
                                                  USAENG







 Error:  ORA-27072


 Text:   skgfdisp: I/O error





 Cause:  read/write/readv/writev system call returned error, additional


         information indicates starting block number of I/O
 Action: check errno




 Explanation:


   This error was introduced in Oracle8.



   The error is raised in port specific code so the exact system calls
   preceeding the error can vary between platforms. The error indicates
   that a read or write call either:



    
  
  1.   returned an error
    or
  
  2.   returned a value indicating that the number of bytes
read/written
            does not match the number of bytes we asked to read/write






   Hence the error number reported may or may not be meaningful.
   If the read/write returned an error then the ERRNO reported corresponds
   to the actual read/write call used. If the read/write returned a
different


   number of bytes to that expected then ERRNO is just the left over error
   from some previous system call and should be ignored.



   Additional information is the first BLOCK NUMBER being read/written
   in the named file.



 Diagnosis:


    
  
  1.   2Gb limits (or other limits) can cause this sort of error so check if
      the filename reported in the corresponding error is a large file.
      The block number in the additional information can help show if you
      are close to this limit.

  
  2.   It is helpful to know the system call which caused the error so
      exact version information is important. If the error is repeatable at
      will then TRUSS or similar may help identify the call raising the
error.

  
  3.   Determine if the file/s are on raw devices / logical raw volumes or
      file system files.






 References / Known Bugs etc..




   There are several known issues that can cause this error, plus it can be
   a non-Oracle problem so it is important to collect all the information:


    2Gb or not 2Gb  - file limits in Oracle              [NOTE:62427.1]
      See the above article as an anchor point for 2Gb issues on various
      platforms.
      Eg: Solaris 2Gb issue                              [BUG:774252]
    Backup of RAW controlfile                            [NOTE:60953.1]
    Sequent AIO issue                                    [NOTE:64632.1]







> Hello All,
>
> J ust now i got a error   select  count(*) from s_org_ext.
>
> SQLWKS> select count(*) from s_org_ext;  where S_org_ext is Name of the
> Table.
> COUNT(*)
> ----------
> ORA-01115:
> ORA-01110:  4: /db/oracle/oradata/tlisuser/data03.dbf
> ORA-27072: skgfdisp:
> SVR4 Error: 25: Inappropriate ioctl for device
> Additional information: 262132
>
> But When I do  select x,y,z,t,..... from s_org_ext then No error occured.
>
> The size of that Table is 2.4GB. Its Initial extent is 1Gb and Next is


1mb.

>
> Vesion of Orcale 8.0.5 and OS is Sun solaris 5.6
>
> Developped got this error while executing a procedure. I think that
> procedurte will be insert into data into s_org_ext.
>
> PLease tell me what i will do. I think datafile will be damagaed. can not
> coiped on OS prompt when last time I took backup.
>
> Please help me.,
>
> Regards,
> Saroj.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> --
> Author: Dash, Saroj  (CAP,CEF)
>   INET: Saroj.Dash_at_gecapital.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: djordjej
  INET: djordjej_at_home.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: 
  INET: Cherie_Machler_at_gelco.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: William Beilstein
  INET: BeilstWH_at_obg.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 Mon Mar 19 2001 - 08:51:24 CST












Original text of this message













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