Home » Server Options » Spatial » ORA-29902,ORA-13209 and ORA-06512 (Oracle 11g,11.1.0.6.0 and WINXP)
ORA-29902,ORA-13209 and ORA-06512 [message #352108] Mon, 06 October 2008 03:46 Go to next message
anil_mk
Messages: 146
Registered: August 2006
Location: Bangalore, India
Senior Member

Hi All,

As i am using Oracle 11g and when I tried to execute the below statement

SELECT /*+ INDEX(cola_markets cola_spatial_idx) */
c.mkt_id, c.name FROM cola_markets c WHERE SDO_NN(c.shape,
SDO_geometry(2001, NULL, SDO_point_type(10,7,NULL), NULL,
NULL), 'sdo_num_res=2') = 'TRUE';

Got the error like

ERROR at line 1:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-13209: internal error while reading SDO_INDEX_METADATA table
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 333

And the table which is used above cola_markets has spatial index(MDSYS.SPATIAL_INDEX) on shape column.

Please suggest if anyone have idea about SPATIAL.

Thanks & Regards,
Anil MK
Re: ORA-29902,ORA-13209 and ORA-06512 [message #356627 is a reply to message #352108] Fri, 31 October 2008 10:08 Go to previous messageGo to next message
SteveSerra
Messages: 5
Registered: October 2008
Location: Nashua, NH
Junior Member
Anil,

What patch level are you using?

This sounds like a bug that was fixed.

Please check metalink for fix, if nothing looks like a fit
post a bug.

thanks and sorry for inconvenience,

Steve
Re: ORA-29902,ORA-13209 and ORA-06512 [message #389947 is a reply to message #356627] Wed, 04 March 2009 04:58 Go to previous messageGo to next message
anil_mk
Messages: 146
Registered: August 2006
Location: Bangalore, India
Senior Member

Hi Steve,

How to check which patch my Database is using?
Is there a query? if so please let me know

Thanks & Regards

Anil MK
Re: ORA-29902,ORA-13209 and ORA-06512 [message #390482 is a reply to message #389947] Fri, 06 March 2009 09:37 Go to previous messageGo to next message
SteveSerra
Messages: 5
Registered: October 2008
Location: Nashua, NH
Junior Member
Anil,

One way is to use EM cosole, this is documented in the user's guide or you can get patchsets.sh


From http://www.dbazine.com/oracle/or-articles/phelps1

Using patchsets.sh

The Oracle-provided patch-comparison utility, patchsets.sh, is a handy tool for reviewing patchset levels. Family Pack versions, fully installed products, and shared installed products, along with the latest version available, are displayed in the output. Information about the latest version of this utility can be reviewed in MetaLink Note 139684.1.

This utility is updated frequently by Oracle. Before running the script, download the current version from the following FTP site: ftp://oracle-ftp.oracle.com/apps/patchsets/PATCHSET_COMPARE_TOOL/patchsets.sh.

The instance owner can use the tool by executing the following:

patchsets.sh connect=[userid]/[password]

Here's an example:

$patchsets.sh connect=apps/apps_password

More details about the parameters available for this script can be found by using the -h parameter for online help. Figure 5-2 shows an example of the output of patchsets.sh from MetaLink Note 139684.1.

The output for the file will contain the following columns for each product group:

+ Baseline Version: Displays the version provided with the release.
+ Running Version: Displays the current version installed for each product.
+ Latest Available, Status: Displays the current version available for the product. The Status portion of the column consists of two parts: the patchset status (Rel is short for released, Sup for superseded, and Obs for obsoleted) and the distribution status (By_Metal indicates it is on MetaLink, Not_Dist means it is not available, and By_Dev means it is available from development only).

Review the output to find any products that have updates available.

thanks

Steve
Re: ORA-29902,ORA-13209 and ORA-06512 [message #393742 is a reply to message #390482] Tue, 24 March 2009 04:28 Go to previous message
anil_mk
Messages: 146
Registered: August 2006
Location: Bangalore, India
Senior Member

Thank you Steve for your quick reply.
I will try the procedure what you mentioned and if I get any problem I will let you know.


Regards,

Anil MK
Previous Topic: Problem with Oracle Spatial query (merged)
Next Topic: Updating a table with an SDO_GEOMETRY column (merged)
Goto Forum:
  


Current Time: Thu Mar 28 14:46:50 CDT 2024