Help: Oracle9i OLAP - DB crash -
10-09-2003
, 08:48 AM
I have been having problems with Oracle9i OLAP server and I thought
I'd see if anyone has any insight into it.
Here's the situation. I downloaded Oracle 9i from
"http://otn.oracle.com/software/index.html" onto my Windows XP
desktop. I made a JDBC Connection to Oracle 9i and attempt to process
the sample metadata of the "SH" schema (which comes with Oracle) using
a program very similar to the one found at:
http://www.engin.umich.edu/caen/wls/...e8.htm#1004288
I am able to make the initial connection and access the
MdmMetadataProvider, but when I make the "mp.getRootSchema()" call I
see the following error:
-----------------------------------------------------------------------------
java.sql.SQLException: Io exception: Connection reset by peer:
JVM_recv in socket input stream read
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:333)
at oracle.jdbc.driver.OracleStatement.executeNonQuery (OracleStatement.java:2061)
at oracle.jdbc.driver.OracleStatement.doExecuteOther( OracleStatement.java:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:2709)
at oracle.jdbc.driver.OraclePreparedStatement.execute Update(OraclePreparedStatement.java:589)
at oracle.jdbc.driver.OraclePreparedStatement.execute (OraclePreparedStatement.java:656)
at oracle.express.idl.ExpressMdmModule.MetadataProvid erInterfaceStub.getMetadataPropertyBags(MetadataPr oviderInterfaceStub.java:121)
at oracle.express.mdm.MetadataPropertyBagFetcher.fetc hMetadataPropertyBags(MetadataPropertyBagFetcher.j ava:57)
at oracle.express.mdm.MdmMetadataProvider.getMetadata Object(MdmMetadataProvider.java:324)
at oracle.express.mdm.MdmMetadataProvider.getRootSche ma(MdmMetadataProvider.java:395)
at TestOracle.main(TestOracle.java:45)
-----------------------------------------------------------------------------
The error seems to result from the fact that the database itself has
crashed, and needs to be restarted.
I could find nothing in the database's "alert log" to indicate the
root cause of this problem, nor have I have found anything online that
specifically deals with it. If anyone has any insight into this I
would greatly appreciate it. Thank you very much.
Joshua |