求助--ORA-01034: ORACLE not available

[wufeifei_1985]

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

[Oraclefans_]

机器物理内存多少？把sga_max_size设置为物理内存的50%.

[iqlife]

数据库没有启动。。

CONN / AS SYSDBA
STARTUP

[心中的彩虹]

[Quote=引用楼主 wufeifei_1985 的回复:]
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
[/Quote]
oracle_sid 指定问题

set oracle_sid='''

在关闭重启

[iihero]

原因：
1. 环境变量没导全
2. oracle_sid没指定

[dawugui]

ORA-01034 ORACLE not available

Cause: Oracle was not started. 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.