I am trying to connect to the Oracle DB hosted in a windows machine with my android app...
I have two instances ( SID's ) in my machine ,
one instance is created with agile DB installer - Agile
the other one is created with DBCA - ORCL
I am able to connect to Agile Instance from my mobile , able to query the results.
but I am not able to connect to the ORCL instance from my android app
IT is give a error like : TNS-12518: TNS:listener could not hand off client connection
What could be the reason?/
DB server - 188.8.131.52
Connecting mobile devices directly to an RDBMS is not recommended. It is technically possible, but there are serious security implications, not to mention performance, battery life, etc.
This forum is for a product specifically designed to solve this problem the right way: Oracle Database Mobile Server (DMS).
With DMS, you simply develop a standard Android application using the built-in local database, SQLite. (you can also use Berkeley DB on Android for a complete Oracle solution, this is especially helpful for large data sets). You then bundle the sync client with your application, and DMS will take care of the rest, keeping you local database in sync with the Oracle RDBMS backend.
You will need to define the relationship between the mobile and backend databases beforehand, this is done using a tool called Mobile Database Workbench (MDW). You can read about that here:
and you can browse all the docs here:
download here to try it out:
As added benefits, you get the ability for the app to function in disconnected mode, and it offers some basic device mgmt capability.
Hope that helps.