Oracle 10 报错 ORACLE not available

发布网友发布时间：2024-10-08 01:19

共1个回答

热心网友时间：2024-11-07 07:07

共享内存的问题。看看你的服务全启动了没，启动了。你可以试一试用命令行来启动
C:\Documents and Settings\LuckyStar>sqlplusSQL*Plus: Release 10.2.0.1.0 - Production on 星期五 8月 28 09:32:35 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.请输入用户名: test/123
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
请输入用户名:
C:\Documents and Settings\LuckyStar>sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on 星期五 8月 28 09:34:58 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL> connect /as sysdba
已连接到空闲例程。
SQL> startup
ORACLE 例程已经启动。Total System Global Area 281018368 bytes
Fixed Size 1248552 bytes
Variable Size 125829848 bytes
Database Buffers 150994944 bytes
Redo Buffers 2945024 bytes
数据库装载完毕。
数据库已经打开。
SQL>
SQL> 从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options 断开C:\Documents and Settings\LuckyStar>sqlplus test/123SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 8月 28 09:37:16 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionsSQL>
SQL> 从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options 断开C:\Documents and Settings\LuckyStar>