【结贴】oracle11g下初始化安装报错，如下

amao800613

oracle11g下初始化安装报错，如下：

刚开始用10g的 ojdbc14.jar连接测试报错；然后换成 ojdbc5.jar测试可以通过。但是初始化报错。
2010.03.16 15:19:47 [org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:280)
]
java.sql.SQLException: ORA-00942: 表或视图不存在

        at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
        at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
        at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:686)
        at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:617)
        at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:559)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1077)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3425)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1202)
        at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:271)
        at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:67)
        at org.jivesoftware.util.JiveProperties.<init>(JiveProperties.java:49)
        at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:43)
        at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:495)
        at org.jivesoftware.wildfire.XMPPServer.initialize(XMPPServer.java:331)
        at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:409)
        at org.jivesoftware.wildfire.XMPPServer.<init>(XMPPServer.java:177)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
        at java.lang.Class.newInstance0(Class.java:350)
        at java.lang.Class.newInstance(Class.java:303)
        at org.jivesoftware.wildfire.starter.ServerStarter.start(ServerStarter.java:88)
        at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)
2010.03.16 15:19:47 [org.jivesoftware.wildfire.XMPPServer.verifyDataSource(XMPPServer.java:669)
] Database could not be accessed
java.sql.SQLException: ORA-00942: 表或视图不存在

        at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
        at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
        at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:686)
        at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:617)
        at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:559)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1077)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3425)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1202)
        at org.jivesoftware.wildfire.XMPPServer.verifyDataSource(XMPPServer.java:660)
        at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:413)
        at org.jivesoftware.wildfire.XMPPServer.<init>(XMPPServer.java:177)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
        at java.lang.Class.newInstance0(Class.java:350)
        at java.lang.Class.newInstance(Class.java:303)
        at org.jivesoftware.wildfire.starter.ServerStarter.start(ServerStarter.java:88)
        at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)
2010.03.16 15:19:47 [org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:443)
]
java.lang.IllegalArgumentException: java.sql.SQLException: ORA-00942: 表或视图不存在

        at org.jivesoftware.wildfire.XMPPServer.verifyDataSource(XMPPServer.java:670)
        at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:413)
        at org.jivesoftware.wildfire.XMPPServer.<init>(XMPPServer.java:177)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
        at java.lang.Class.newInstance0(Class.java:350)
        at java.lang.Class.newInstance(Class.java:303)
        at org.jivesoftware.wildfire.starter.ServerStarter.start(ServerStarter.java:88)
        at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)
Caused by: java.sql.SQLException: ORA-00942: 表或视图不存在

        at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
        at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
        at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:686)
        at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:617)
        at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:559)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1077)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3425)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1202)
        at org.jivesoftware.wildfire.XMPPServer.verifyDataSource(XMPPServer.java:660)
        ... 10 more

amao800613

今天我们公司刚跟起步签的合约，想验证下新版本来着。刚起步就错了！看看哪位遇见过这个问题？ojdbc5.jar而是能通过，但是不能初始化。

lixy

http://bbs.justep.com/forum.php?mod=viewthread&tid=28551

amao800613

看过那个帖子，现在报的是 oracle.jdbc.driver 的错。也就是说驱动文件ojdbc5.jar跟初始化的SQL语句之间有问题。刚安装的开发工具3109，根本就没动过路径。后面重新安装解决了。谢谢！