Oracle Spatial Error ORA-29532: Java call terminated by uncaught Java exception ORA-06512: at “MDSYS.SDO_UTIL”, line 196

This error is received in 11g release, but fixed in 12c release :

 

ORA-29532: Java call terminated by uncaught Java exception: java.lang.RuntimeException
ORA-06512: at “MDSYS.SDO_UTIL”, line 196

is there any workaround for this problem in 11g …. YES:

1. Drop the spatial index on the geometry table
2. Run the update
3. Rebuild the spatial index

 

sqlplus error ORA-12560

This could be known and primitive to many people, however i am putting it to help the community in general from different technical-levels.

when you initiate sqlplus and trying to connect to your database instance you face the following error:

ORA-12560: TNS:protocol adapter error

 

if you are using windows OS, you need to check the following:

  1. check that the database services is up and running, go to the search icon and search for “services” and ensure all Oracle services are up and running.
  2.   if Oracle database is up and running fine, then check your environment variables in  CMD, you need to set the following:

 

set ORACLE_HOME=D:\app\db33\product\12.1.0\dbhome_33

set ORACLE_SID= ORACLE33

set PATH=D:\app\db33\product\12.1.0\dbhome_33\bin

to check that its reflected, execute the following to verify the value of ORACLE_HOME:

echo %ORACLE_HOME%

windows cmd oracle environment variables

now try initiating sqlplus and it will be working 🙂