请问大家,我的oracle数据库和WEB程序在一台服务器上运行,前一陈运行都没问题,但是昨晚突然出现以下错误日志,请帮忙解决,不胜感激!!!
现出现如下错误日志
[2006-10-13 21:17:5]MyInfo: DBCommon DbException=System.Data.OracleClient.OracleException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
at System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OracleClient.OracleConnection.Open()
at DBCommon..ctor(HttpResponse objHttpResponse)
------解决方法--------------------------------------------------------
这不一定是由于客户端引起的
需要登陆服务器看一下alert_sid.log
看看到底是什么原因造成oracle关闭
------解决方法--------------------------------------------------------
碰到这种问题大多数得重开server端的oracle
