dbTalk Databases Forums  

Help: Oracle9i OLAP - DB crash

comp.databases.olap comp.databases.olap


Discuss Help: Oracle9i OLAP - DB crash in the comp.databases.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Joshua Kramer
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.