[Geonetwork-devel] Re: Installation problems - FIXED

GeoNetwork GeoNetwork Developer
1

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):

main-db jeeves.resources.dbms.DbmsPool MY_USERID MY_PASSWORD oracle.jdbc.driver.OracleDriver jdbc:oracle:thin:@//MY_SERVER_ADDRESS:1521/MY_SERVICE 4

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

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

jdbc:oracle:thin:[/]@//[:]/
jdbc:oracle:oci:[/]@//[:]/

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

2

pgrzeszc@anonymised.com wrote:

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)

Glad to be of hacking assistance. Now lets delve into CVS to find and fix this in a real fashion for users of the next release :slight_smile:

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):

Sorry for the almost corrrect URI, my JDBC Oracle is a bit rusty. I do still edit tnsnames.ora by hand.

C.