Symptom(s) ~~~~~~~~~~Database has been configured to start automatically whenever the server is rebooted. But the database does not start and any query to the database fails with Ora-27101 and Ora-1034 errors. Same errors are reported in the Oradim.log.ORA-01034 ORACLE not available ORA-27101 "Shared Memory Realm Does Not Exist"
Change(s) ~~~~~~~~~~DBAs are trying to automate the startup of the database when server reboots. The Registry key ORA_<SID>_AUTOSTART is set to TRUE and ORA_<SID>_PFILE is pointing to correct location. The "startmode" of Oracle service ORACLESERVICE<SID> has been set to AUTOMATIC. Cause ~~~~~~~The Oracle service ORACLESERVICE<SID> got corrupted for some unknown reasons and does not start the database successfully Fix ~~~~Recreate the Oracle service using ORADIM utilitya) delete the current service - c:\> oradim -delete -sid <sid_name>b) make sure the service has status DISABLED in Service Windows and it does not appear after refreshing the Service Windows. If the service still appears, reboot the server.c) create the service c:\> oradim -new -sid <sid> -startmode auto -pfile <absolute path of init.ora> References ~~~~~~~~~~~
修改了主机名是一个方面，你把 VM 拷走了，内存的配置，你是不是改动了，比如原来你给 VM 分配了4G, 等你拷走了，只分配给了2G ?
再看了一下， ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist 提示是数据库没有启动起来而已，看看alert日志的告警内容。 1.会不会是你的数据库自启动有问题了 2.如果没有自启动，你的数据库服务没有手动开启
首先出现这个错误，可能是下面几种情况吧 1，oracle没有正常关闭。ps aux|grep ORA 然后kill -9 进程名，杀死进程重新启动试试 2，oracle要求ip地址唯一， 你看下配置回来原来的ip地址试试。或者重新配置下监听。有对应ip的 3，/etc/hosts是否配置有ip对应的服务名
看看alert日志报什么错
http://blog.csdn.net/lpioneer/article/details/6109933
结果又回到csdn，真神奇。
~~~~~~~~~~Database has been configured to start automatically whenever the server
is rebooted. But the database does not start and any query to the database
fails with Ora-27101 and Ora-1034 errors. Same errors are reported in
the Oradim.log.ORA-01034 ORACLE not available
ORA-27101 "Shared Memory Realm Does Not Exist"
Change(s)
~~~~~~~~~~DBAs are trying to automate the startup of the database when
server reboots. The Registry key ORA_<SID>_AUTOSTART is set to
TRUE and ORA_<SID>_PFILE is pointing to correct location. The "startmode"
of Oracle service ORACLESERVICE<SID> has been set to AUTOMATIC.
Cause
~~~~~~~The Oracle service ORACLESERVICE<SID> got corrupted for some unknown
reasons and does not start the database successfully
Fix
~~~~Recreate the Oracle service using ORADIM utilitya) delete the current service -
c:\> oradim -delete -sid <sid_name>b) make sure the service has status DISABLED in Service Windows and it
does not appear after refreshing the Service Windows. If the service
still appears, reboot the server.c) create the service
c:\> oradim -new -sid <sid> -startmode auto -pfile <absolute path of init.ora>
References
~~~~~~~~~~~
另外，检查一下，是不是变化前后虚拟机内存大小变化过。
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist 提示是数据库没有启动起来而已，看看alert日志的告警内容。
1.会不会是你的数据库自启动有问题了
2.如果没有自启动，你的数据库服务没有手动开启
1，oracle没有正常关闭。ps aux|grep ORA 然后kill -9 进程名，杀死进程重新启动试试
2，oracle要求ip地址唯一， 你看下配置回来原来的ip地址试试。或者重新配置下监听。有对应ip的
3，/etc/hosts是否配置有ip对应的服务名
1. 停数据库，停监听器，修改操作系统主机名，重启操作系统；
2. 修改C:\WINDOWS\system32\drivers\etc下面的hosts文件中的主机名；3. 使用Net Configuration Assistant重建监听器；4. 使用Net Manger修改”服务命名”和”监听程序”中有关主机名的部分；5. 重启监听器：lsnrctl restart如果是IP地址变更，查看一下服务器上的hosts文件内容。