Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Weird error when creating spatial index

505789Aug 30 2012 — edited Sep 3 2012
We have two databases. One for testing and another with some more data.

- When we try to create the index in testing, it works.
- When we try to create the index in the environment with more data, we get the following error

SQL> CREATE INDEX IDX_GPOT_BUILDING ON GPOT_BUILDING(POSITION) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARALLEL PARAMETERS('SDO_INDX_DIMS=2,LAYER_GTYPE=POINT');
CREATE INDEX IDX_GPOT_BUILDING ON GPOT_BUILDING(POSITION) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARALLEL PARAMETERS('SDO_INDX_DIMS=2,LAYER_GTYPE=POINT')
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13249: Error in Spatial index: index build failed
ORA-13249: Error in spatial index: [mdrcrtxfergm]
ORA-13249: Error in spatial index: [mdpridxtxfer]
ORA-29400: data cartridge error
ORA-12801: error signaled in parallel query server P014, instance
dg***d02.intranet.******.com:ZE**F2 (2)
ORA-13249: Error in spatial index: [mdpridxtxfergm]
ORA-29400: data cartridge error
ORA-01426: numeric overflow
ORA-06512: at "MDSYS.SDO_PRIDX", line 353
ORA-06512: at "MDSYS.SDO_PRIDX", line 342
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10
Any clues about that?

Edited by: usersp on Aug 30, 2012 10:24 AM

Comments

BluShadow

*** Moved to VirtualBox for better question alignment as "Documentation" is not the correct space to ask such a question - let me know if there's a more suitable Virtual product space and I can move it again if needed.

37660ed0-2283-43d5-9d12-8f57a6f3c35b

Can someone please answer above query? Thanks.

Nik

Hi.

Read this:

http://www.oracle.com/technetwork/server-storage/solaris11/documentation/solaris-11-3-faqs-2489291.pdf

Some parts from this Doc.

Q: Can I install Oracle Solaris 11 into a virtual environment?

A: Yes. Oracle Solaris 11 is a supported guest operating system on Oracle VM Server for SPARC, Oracle VM Server for x86, and Oracle VM VirtualBox. Oracle Solaris 11 is known to work on a number of other third-party virtualization offerings from vendors including VMware, Microsoft, and Red Hat.

So Solaris 11 work on VmWare platform, but not supported.

Regards,

Nik.

ErikB

Yes, it is supported.

For step by step directions on how to install look here; Installing Solaris x86 11.2 from an ISO in Virtualbox – Part 1 - Tales from the Datacenter

Erik

Wesley D-Oracle

Solaris 11 can run in VMware; however, only the x86_64 variant - as VMware does not have the ability to emulate SPARC architecture.

I suggest looking at VMware Sites for further information and support with installing Solaris 11 x86_64 as a guest virtual machine on VMware.

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 1 2012
Added on Aug 30 2012
#database-key-features, #spatial
9 comments
2,611 views