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: <Cherie_Machler_at_gelco.com>
Date: Mon, 19 Mar 2001 07:47:03 -0800
Message-ID: <F001.002D08EB.20010319072527@fatcity.com> 







Srini,



Thanks for the info.  That sure is irritating.



Cherie






Srini.Chavali_at_Cummins.com_at_fatcity.com on 03/19/2001 08:35:42 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:






Cherie,


This in itself is a bug !


I asked the same question at an Oracle education class about 18 months ago
and was told that the default visibility when creating an entry in the bug
database is "internal" - i.e. not visible outside of Oracle. Analysts have
been asked to set visibility to global when logging bugs in the database,
but if they forget to do so, you will not be able to search for it.
I cannot understand why the visibility cannot be changed after the bug is
created as "internal".


Go figure !


HTH



Srini Chavali


Oracle DBA


Cummins Inc






Cherie_Machler_at_gelco.com_at_fatcity.com on 03/19/2001 08:50:22 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:






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:
  INET: Srini.Chavali_at_Cummins.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).


Received on Mon Mar 19 2001 - 09:47:03 CST












Original text of this message













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