[Geonetwork-devel] Re: Installation problems - FIXED

[<pgr...@uw...>]

Finally, I managed to install geonetwork.  Carl's suggestion to install 
2.0.1 over 2.0.0 was right on the money.  Thanks Carl.
I've got it running on Fedora Core 3 + Tomcat 5.5.12 + Oracle 10g 
(10.1.0.3.0)

The install program erroneously modifies the mckoi section instead of the 
oracle section.  I disabled that one.
This is the oracle section manually edited in config.xml (custom stuff in 
capitals):

<resource enabled="true">
        <name>main-db</name>
        <provider>jeeves.resources.dbms.DbmsPool</provider>
        <config>
                <user>MY_USERID</user>
                <password>MY_PASSWORD</password>
                <driver>oracle.jdbc.driver.OracleDriver</driver>
 <url>jdbc:oracle:thin:@//MY_SERVER_ADDRESS:1521/MY_SERVICE</url>
                <poolSize>4</poolSize>
        </config>
</resource>

The URL format according to Oracle (see: oracle jdbc faq):

---QUOTE FAQ---
The basic format of a service URL is:

   jdbc:oracle:thin:[<user>/<password>]@//<host>[:<port>]/<service>
   jdbc:oracle:oci:[<user>/<password>]@//<host>[:<port>]/<service>

Examples:

   jdbc:oracle:thin:@//myserver.com/customer_db
   jdbc:oracle:oci:scott/tiger@//myserver.com:5521/customer_db
---END QUOTE---

I initially used the SID method, which is apparently obsolete, but it 
worked fine:

---QUOTE FAQ---
# Thin Driver, a 100% Java driver for client-side use without an Oracle 
installation, particularly with applets. 
The Thin driver type is thin. To connect user scott with password tiger to 
a database with SID (system identifier) 
orcl through port 1521 of host myhost, using the Thin driver, you would 
write :

   Connection conn = DriverManager.getConnection
            ("jdbc:oracle:thin:@myhost:1521:orcl", "scott", "tiger");
---END QUOTE---

I'm glad I got this to work.  Thanks

Paul