SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-22-2008, 06:28 PM
| ||||
| ||||
 ora-600 errors cant open a tar on this since its on an instance I have at home and its not for work. I checked metalink and Im not getting anything good. When I try to query dba_segments and hit the 'bytes' column, the application 'hangs' for a while and then issues SQL> select segment_name,bytes from dba_segments where rownum < 10; select segment_name,bytes from dba_segments where rownum < 10 * ERROR at line 1: ORA-00600: internal error code, arguments: [kpotcpop1], [], [], [], [], [], [], [] I checked metalink and hit the ora-600 lookup all I get is a few posts about problems with export and the need to re-run one of the catproc scripts. Which I have done. anyone ever hit this? Windows XP, 9.0.1 I can just blow away the instance, but Im curious about the problem.      |
|
02-22-2008, 06:28 PM
| |||
| |||
| Re: ora-600 errors i am re-running the catproc.sql script and am getting that same error in places while running the script. "Ryan" <rgaffuri@cox.net> wrote in message news:8gDmb.106501$a16.6748@lakeread01... > cant open a tar on this since its on an instance I have at home and its not > for work. I checked metalink and Im not getting anything good. > > When I try to query dba_segments and hit the 'bytes' column, the application > 'hangs' for a while and then issues > > SQL> select segment_name,bytes from dba_segments where rownum < 10; > select segment_name,bytes from dba_segments where rownum < 10 > * > ERROR at line 1: > ORA-00600: internal error code, arguments: [kpotcpop1], [], [], [], [], [], > [], > [] > > > I checked metalink and hit the ora-600 lookup all I get is a few posts about > problems with export and the need to re-run one of the catproc scripts. > Which I have done. > > anyone ever hit this? Windows XP, 9.0.1 > > I can just blow away the instance, but Im curious about the problem. > > |
|
02-22-2008, 06:28 PM
| |||
| |||
| Re: ora-600 errors Ryan wrote: >i am re-running the catproc.sql script and am getting that same error in >places while running the script. > > >"Ryan" <rgaffuri@cox.net> wrote in message >news:8gDmb.106501$a16.6748@lakeread01... > > >>cant open a tar on this since its on an instance I have at home and its >> >> >not > > >>for work. I checked metalink and Im not getting anything good. >> >>When I try to query dba_segments and hit the 'bytes' column, the >> >> >application > > >>'hangs' for a while and then issues >> >>SQL> select segment_name,bytes from dba_segments where rownum < 10; >>select segment_name,bytes from dba_segments where rownum < 10 >> * >>ERROR at line 1: >>ORA-00600: internal error code, arguments: [kpotcpop1], [], [], [], [], >> >> >[], > > >>[], >>[] >> >> >>I checked metalink and hit the ora-600 lookup all I get is a few posts >> >> >about > > >>problems with export and the need to re-run one of the catproc scripts. >>Which I have done. >> >>anyone ever hit this? Windows XP, 9.0.1 >> >>I can just blow away the instance, but Im curious about the problem. >> >> >> >> You are using Beta software. Upgrade to 9.2.0.4. -- Daniel Morgan http://www.outreach.washington.edu/e...ad/oad_crs.asp http://www.outreach.washington.edu/e...oa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply) |
|
02-22-2008, 06:30 PM
| ||||
| ||||
| Re: ora-600 errors Hi Ryan, Just tried it on XP 9.0.1 and it works..:-) SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production ..... SQL> select segment_name,bytes from dba_segments where rownum<10 SQL> / SEGMENT_NAME ------------------------------------------------------------------------ -------- BYTES ---------- FILE$ 12288 UNDO$ ..... kind regards Pete -- Pete Finnigan  ete@petefinnigan.comWeb site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. |
 |
« ORACLE or SQL SERVER (MS) ?
|
IN clause doesnt considers INDEXES in CBO mode ALL_ROWS , ( If we use approach suggested in AskTOM column) »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 01:51 AM.
