Hi Marwa,
If I understand you correctly, you can connect from sqlplus on your
GeoServer machine to your Oracle server, but a JDBC connection (as used by
GeoServer) fails. JDBC and sqlplus can use different methods of connection
(sqlplus has more possibilities), so the problem is most likely in your
listener.ora on the Oracle server, or the tnsnames.ora on your GeoServer
machine. What is the contents of each of those files? And tnsnames.ora on
the Oracle server?
What does "lsnrctl status" on the server show?
If you're wanting to do some reading, try
http://www.google.com.au/search?q=ora+12505+jdbc
Regards, Paul
From: marwa El-said [mailto:melsaid2...@hotmail.com]
Sent: Monday, 4 October 2010 9:49 PM
To: joyc...@hotmail.com; geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] Error while connect to oracle client 10 g
Hello all,
Thanks paul for your reply.
But I wanna to tell you that oracle 10g server is installed on a remote
server , and geoserver is installed on my pc "localhost"
I'm trying to connect from my local geoserver to oracle server to make a new
data store
But I couldn't do that
Moreover, I'm not familiar with oracle to know more about it, so I need a
sequence of steps to try to fix this errors or to make an oracle datastore
from geoserver.
About your suggested steps I tried them, they worked fine and I can connect
to my database through sqlplus from server and client
Thanks again & waiting other suggestions
Regards,
Marwa Elsaid
_____
From: joyc...@hotmail.com
To: melsaid2...@hotmail.com; geoserver-users@lists.sourceforge.net
CC: ahmed.ashm...@gt-egypt.com; marwa.mamd...@gt-egypt.com
Subject: RE: [Geoserver-users] Error while connect to oracle client 10 g
Date: Mon, 4 Oct 2010 09:00:48 +1000
Hi Marwa,
ORA-12505 is a very common Oracle error message. Unfortunately it can have a
lot of different causes. If you Google ORA-12505 you will find lots of
things to try.
> I'm using geoserver v2.0.2 & Oracle Server 10g installed on remote server,
also I have an oracle Client 11g for windows server 2008,
Remember that the Oracle connection you are trying to establish is from
GeoServer to Oracle Server; in your case this appears to be all on the one
machine "remote server". Is the 11g client you refer to also installed on
this machine? If so, be careful about which set of Oracle configuration you
are attempting to fix. Multiple Oracle homes is the source of much pain!
To help narrow down the possible problem(s) try these steps:
1. on the Oracle server, try to connect with sqlplus using a non-TNS
connection, eg, "sqlplus scott/tiger" - this one can still work
even if your Oracle listener is not running
2. on the Oracle server, try to ping the database, eg, "tnsping orcl"
3. on the Oracle server, try to connect with sqlplus using a TNS connection,
eg, "sqlplus scott/ti...@orcl"
4. on a client machine, try to connect with sqlplus using a TNS connection,
eg, "sqlplus scott/ti...@orcl"
Regards, Paul
_____
From: melsaid2...@hotmail.com
To: geoserver-users@lists.sourceforge.net
Date: Sun, 3 Oct 2010 18:16:40 +0200
CC: ahmed.ashm...@gt-egypt.com; marwa.mamd...@gt-egypt.com
Subject: [Geoserver-users] Error while connect to oracle client 10 g
Hello all,
I'm using geoserver v2.0.2 & Oracle Server 10g installed on remote server,
also I have an oracle Client 11g for windows server 2008,
First: I tried to create a new oracle data store of type "Oracle Database
(OCI)" but when i click on save button nothing happened.
Second: when I tried to create a new oracle data store I got an error as
following:
" Error creating data store, check the parameters. Error message: Unable to
obtain connection: Cannot create PoolableConnectionFactory (Listener refused
the connection with the following error: ORA-12505, TNS:listener does not
currently know of SID given in connect descriptor The Connection descriptor
used by the client was: 194.168.15.100:1521:GT_Data ) ".
this happens when I write the IP of oracle server in the host field,
but when I enter the service name in the host field I got that error
"Error creating data store, check the parameters. Error message: Unable to
obtain connection: Cannot create PoolableConnectionFactory (Io exception:
The Network Adapter could not establish the connection) ".
so, I wanna to know and understand what happened and why?
what I have to do to make a new data store to my remote oracle server 10g?
Third: I wanna to know what are the differences between oracle Data stores
types
- Oracle Database (OCI).
- Oracle Database (JNDI).
- Oracle Database.
Thanks,
Marwa Elsaid
----------------------------------------------------------------------------
-- Start uncovering the many advantages of virtual appliances and start
using them to simplify application deployment and accelerate your shift to
cloud computing. http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________ Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
