易截截图软件、单文件、免安装、纯绿色、仅160KB

oracle 9i 最近发现登陆报错 - Oracle / 基础和管理

用PL/SQL 登陆时弹出报错窗口,错误如下!
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist


请问,有没有人遇到这种情况,怎么解决?谢谢!

1. Oracle sid 正确?
2. Oracle home 正确?
3. 检查下数据库的状态。 是否运行正常。




------------------------------------------------------------------------------ 
Blog: http://blog.csdn.net/tianlesoftware 
网上资源: http://tianlesoftware.download.csdn.net 
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx 
Q Q 群:62697716

ORA-01034: ORACLE not available 
Cause: Oracle was not started up. Possible causes include the following: 
- The SGA requires more space than was allocated for it.

- The operating-system variable pointing to the instance is improperly defined.

Action: Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages. If Oracle has been initialized, then on some operating systems, verify that Oracle was linked correctly. See the platform specific Oracle documentation.


ORA-27101: shared memory realm does not exist 
Cause: Unable to locate shared memory realm
Action: Verify that the realm is accessible



引用
看一下你的安装目录DATABASE 下面的 ORADIM.LOG 文件
如果


相关问答:

是oracle的bug么?散分了! - Oracle / 基础和管理

本来要写个update语句
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
结果误写成
update table_a A
  set A.flag=1
  where ......

java怎么连接Oracle,急啊 - Java / Java相关

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

oracle spatial空间函数出错 - Oracle / 高级技术

在执行包的时候引用oracle spatial空间函数出错,出错情况如下
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

ORACLE连接方法 - VC/MFC / 数据库

如下VC6操作ORACLE连接方法为可报错:
_bstr_t connStr;
connStr="Provider=OraOLEDB.Oracle;User ID=scott;Password=tiger;Data Source=192.168.0.120;";
m_SqlConn->Open(_bstr_t(connStr),(_b ......

sql - Oracle / 非技术区

score表
scoreid course studentid score
1 数学 2 99
2 数学 3 60
3 数学 4 80
4 语文 5 79
5 语文 6 58
6 语文 1 66
7 英语 6 76
8 英语 4 87
9 英语 3 100
10英语 2 69
怎样得到没门课中分数最高的那 ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号