[Dspace-tech] ORACLE - FATAL org.dspace.storage.rdbms.InitializeDatabase @ Caught Exception

[José Eslava]

Hi,

I have a DSpace configuration with Oracle 10g XE, when I run "ant fresh_install"
I get this error messages:

C:\dspace-1.5.2\dspace\target\dspace-1.5.2-build.dir>ant fresh_install
Buildfile: build.xml

init_installation:

init_configs:

setup_database:
[java] 2009-09-02 10:25:06,797 INFO org.dspace.core.ConfigurationManager
@
Loading system provided config property (-Ddspace.configuration): config/dspace
.cfg
[java] 2009-09-02 10:25:06,812 INFO org.dspace.core.ConfigurationManager
@
Using default log4j provided log configuration,if uninitended, check your
dspac
e.cfg for (log.init.config)
[java] 2009-09-02 10:25:06,812 INFO org.dspace.storage.rdbms.InitializeDat
abase @ Initializing Database
[java] 2009-09-02 10:25:08,232 FATAL org.dspace.storage.rdbms.InitializeDat
abase @ Caught exception:
[java] java.sql.SQLException: Excepci¾n de E/S: The Network Adapter
could n
ot establish the connection
[java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseEr
ror.java:112)
[java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseEr
ror.java:146)
[java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseEr
ror.java:255)
[java] at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387
)
[java] at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnecti
on.java:420)
[java] at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:16
5)
[java] at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriver
Extension.java:35)
[java] at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801
)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:582)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:185)
[java] at org.apache.commons.dbcp.DriverManagerConnectionFactory.create
Connection(DriverManagerConnectionFactory.java:65)
[java] at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(
PoolableConnectionFactory.java:294)
[java] at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(G
enericObjectPool.java:974)
[java] at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.j
ava:176)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:582)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:207)
[java] at org.dspace.storage.rdbms.DatabaseManager.getConnection(Databa
seManager.java:550)
[java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseMana
ger.java:923)
[java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDa
tabase.java:100)

BUILD FAILED
C:\dspace-1.5.2\dspace\target\dspace-1.5.2-build.dir\build.xml:585: Java
returne
d: 1

Total time: 5 seconds
C:\dspace-1.5.2\dspace\target\dspace-1.5.2-build.dir>
MCE José Eslava
Web Security

[Larry Stone]

This message means there is a problem in your JDBC configuration:
probably db.url has the wrong hostname or port number. Also check
db.username and db.password. Make sure the same values work with a
simpler Oracle client like SQLPlus (although you'll have to rearrange
the URL, it has a different pattern).

/lcs

[Stuart Lewis]

This issue may be affecting you:

http://jira.dspace.org/jira/browse/DS-269

Thanks,

Stuart Lewis
IT Innovations Analyst and Developer
Te Tumu Herenga The University of Auckland Library
Auckland Mail Centre, Private Bag 92019, Auckland 1142, New Zealand
Ph: 64 9 373-7599 x81928
http://www.library.auckland.ac.nz/

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
DSpace-tech mailing list
DSpac...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

[José Eslava]

Hi Stuart,

 

These are some code lines of my dspace.cfg. I tested the URL with Netbeans and the connections works fine.

 

# Database name ("oracle", or "postgres")

#db.name = ${default.db.name}

#db.name = postgres

db.name = oracle

 

# URL for connecting to database

db.url = jdbc:oracle:thin:@//localhost:1521/XE

#db.url = jdbc:postgresql://localhost:5432/dspace

 

# JDBC Driver

#db.driver = ${default.db.driver}

db.driver = oracle.jdbc.OracleDriver

 

# Database username and password

#db.username = ${default.db.username}

#db.password = ${default.db.password}

db.username = dspace

db.password = dspace

 

---

[Brett, Hamish]

UNCLASSIFIED

Hi

 

I am attempting to reconfigure our statistics. However when I run the required scripts I am not getting any stats older than 2 months ago.

 

When I look in the .dat files in /dspace/log that have been generated they are almost except for the last 2 months empty even though a lot has occured for the last 3 years.

 

I am pretty sure I have all the log files.

 

I have only changed the date in the dstat.cfg file.

 

An example of an empty dat file is below.

 

Any advice for me

 

Thanks

 

Hamish

 

log_lines=0
warnings=0
general_summary=archive_item
general_summary=view_bitstream
general_summary=view_item
general_summary=view_collection
general_summary=view_community
general_summary=login
general_summary=search
general_summary=reject_licence
general_summary=oai_request
server_name=dspace-dsto.dsto.defence.gov.au
service_name=DSTO Publications Online
start_date=01/11/2007
end_date=30/11/2007
archive.Preprint=0
archive.Thesis or Dissertation=0
archive.All Items=78
archive.Research Paper=0
action.archive_item=0
action.search=0
action.view_bitstream=0
action.view_collection=0
action.view_community=0
action.oai_request=0
action.reject_licence=0
action.login=0
action.view_item=0
user_email=alias
search_floor=5
item_floor=20
host_url=http://dspace-dsto.dsto.defence.gov.au/dspace/
item_lookup=10
analysis_process_time=0

IMPORTANT: This email remains the property of the Australian Defence Organisation and is subject to the jurisdiction of section 70 of the Crimes Act 1914. If you have received this email in error, you are requested to contact the sender and delete the email.

[Stuart Lewis]

Hi Brett,

On 3/09/2009, at 4:34 PM, Brett, Hamish wrote:

I am attempting to reconfigure our statistics. However when I run the required scripts I am not getting any stats older than 2 months ago. 

When I look in the .dat files in /dspace/log that have been generated they are almost except for the last 2 months empty even though a lot has occured for the last 3 years.

 

I am pretty sure I have all the log files.

 

I have only changed the date in the dstat.cfg file.

 

An example of an empty dat file is below.

 

Any advice for me

I suspect what is happening is that your dspace.log.* files have rolled over their limit. In [dspace]/config/log4j.properties you can specify how many log files to keep, and how big each one can be before it rolls over. The default configuration is quite small (100 files at 1Mb each). So it sounds like you are getting through that many log files each 2 months.

The problem with the stats module as it stands, is that despite creating .dat files for log files which have now rolled over and been lost, it recreates them all each time. This means you lose all the older stats.

The easy short-term solution is to increase the size and/or number of log files that DSpace creates.

The better solution would be for someone to look at making sure current .dat files are not overwritten by the stats system. However... the stat system is getting a complete rewrite in the upcoming 1.6 release, so a lot of people are waiting for that instead.

I hope this helps,

[Brett, Hamish]

UNCLASSIFIED

Thankyou Stuart,

 

Just to confirm, if what you say is happening all older stats other than what is being displayed have been lost.

 

Regards,

 

Hamish

IMPORTANT: This email remains the property of the Australian Defence Organisation and is subject to the jurisdiction of section 70 of the Crimes Act 1914. If you have received this email in error, you are requested to contact the sender and delete the email.

From: Stuart Lewis [mailto:s.l...@auckland.ac.nz]

Sent: Thursday, 3 September 2009 3:21 PM
To: Brett, Hamish
Cc: dspac...@lists.sourceforge.net
Subject: Re: [Dspace-tech] Problem with Statistics [SEC=UNCLASSIFIED]

[Stuart Lewis]

Hi Brett,

I've not double-checked the behaviour recently, but I think the old reports (.html) files stay, so you can see older stats, but newer stats only contain data from the past few months rather than back to the inception of your installation.

Thanks,

Stuart Lewis
IT Innovations Analyst and Developer
Te Tumu Herenga The University of Auckland Library
Auckland Mail Centre, Private Bag 92019, Auckland 1142, New Zealand
Ph: 64 9 373-7599 x81928
http://www.library.auckland.ac.nz/

[Brett, Hamish]

UNCLASSIFIED

Thanks again Stuart,

 

Problem being I overwrote those old html files trying to get it going. Oh well.

 

Hamish

IMPORTANT: This email remains the property of the Australian Defence Organisation and is subject to the jurisdiction of section 70 of the Crimes Act 1914. If you have received this email in error, you are requested to contact the sender and delete the email.

From: Stuart Lewis [mailto:s.l...@auckland.ac.nz]

Sent: Thursday, 3 September 2009 6:54 PM