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

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist错误：

1.

检查flash_recovery_area文件夹是否存在

D:\Oracle\product\10.2.0\db_1\database\SPFILEORCL.ORA中查看db_recovery_file_des路径下是否有flash_recovery_area文件夹，如果没有则新建

然后startup数据库

2.

SQL> conn / as sysdba;
已连接到空闲例程。
SQL> startup;
ORACLE 例程已经启动。

Total System Global Area 1603411968 bytes
Fixed Size                  2176168 bytes
Variable Size             889195352 bytes
Database Buffers          704643072 bytes
Redo Buffers                7397376 bytes

3.

SQL> startup open hstestdb

ORACLE 例程已经启动。
Total System Global Area 1603411968 bytes
Fixed Size                  2176168 bytes
Variable Size             889195352 bytes
Database Buffers          704643072 bytes
Redo Buffers                7397376 bytes
ORA-01504: ???? 'HSTESTDB' ??? db_name 'LMTC9' ???


SQL> alter database open resetlogs;

数据库已更改。