Oracle数据库使用出现错误-状态: 失败 ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist

时间:2022-05-21 08:23:35

Oracle数据库使用出现错误-状态: 失败 ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist

解决办法:

1.确认Oracle相关服务已启动:

Oracle数据库使用出现错误-状态: 失败 ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist

2.修改pfile文件:

pfile根据Oracle安装的路径而定 ,本文路径:C:\app\Administrator\admin\orcl\pfile\init.ora.8172019101639

Oracle数据库使用出现错误-状态: 失败 ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist

3.pfile文件修改内容:

找到Network Registration,修改下面的local_listener="(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))",这个 (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) 内容可以从C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora文件找到

Oracle数据库使用出现错误-状态: 失败 ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist

Oracle数据库使用出现错误-状态: 失败 ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist

4.执行以下命令:

sqlplus /nolog 
conn system/manager as sysdba 
startup 
startup pfile=’C:\app\Administrator\admin\orcl\pfile\init.ora.8172019101639’

打开dos界面  输入如下:

Oracle数据库使用出现错误-状态: 失败 ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist

5、测试

打开sqlplus 输入 system 回车输入密码 回车

界面如下:

Oracle数据库使用出现错误-状态: 失败 ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist