Hi Primoz,
Using GS 2.0.2 you can try setting up a JNDI <http://docs.geoserver.org/2.0.0/user/tutorials/tomcat-jndi/tomcat-jndi.html > connection pool. In the context.xml file on your GS webapp or Tomcat put something like <Resource name="jdbc/SomeName4Datastore" auth="Container" type="oracle.jdbc.pool.OracleDataSource" factory="oracle.jdbc.pool.OracleDataSourceFactory" driverClassName="oracle.jdbc.driver.OracleDriver" maxWait="100" maxActive="25" maxIdle="4" url="jdbc:oracle:thin:@jdbc:oracle:thin:@(DESCRIPTION =(load_balance=on)(ADDRESS = (PROTOCOL = TCP)(HOST = 10.192.60.167)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = <IP_ADDRESS>)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = <SID>)))" user="username" password=" password " /> I'm not sure, but I think the URL parameter must be defined like above when connecting to an Oracle 11g database. But you can try out the usual way. Setting this up you'll be using a connection pool created by the tomcat instance instead of the normal pool available by gs/geotools implementation. Hope this will help you. Cheers, Pedro Mendes De: Primoz Kogovsek [mailto:[email protected]] Enviada: segunda-feira, 13 de Setembro de 2010 15:11 Para: [email protected] Assunto: [Geoserver-users] connection to oracle 11g RAC Hello I am trying to connect geoserver to oracle 11g RAC to build new datastore. geoserver is returning me two error messages. 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: t*****:1521:********* ) or Could not list layers for this store, an error occurred retrieving them: null As I understand connection should go through service_name not SID. How can I define the connection to oracle in cluster? I can connect to oracle database version 10 that is on single server. geoserver wersion 2.0.2 Oracle 11g RAC OS: windovs server 2008 (32-bit) tomcat 6.0.29 Thanks
------------------------------------------------------------------------------ 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 [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
