Shulou(Shulou.com)06/02 Report--

Question:

```Connect to oracle using sqlplus, prompting ORA-01034 and ORA-27101. The details are as follows:

ERROR:

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

* * solution: * * 1. Check whether the monitoring of oracle and the service of oracle are enabled. ```start oracle listening: under the cmd command line window, enter lsnrctl start, and enter enter to start listening. ```! [] (https://cache.yisu.com/upload/information/20200311/29/173248.jpg?x-oss-process=image/watermark,size_16,text_QDUxQ1RP5Y2a5a6i,color_FFFFFF,t_100,g_se,x_10,y_10,shadow_90,type_ZmFuZ3poZW5naGVpdGk=)2,```, enter sqlplus / nolog, enter enter; enter conn / as sysdba, enter ```3, ```, enter startup, enter enter. This step is to start the oracle service. If the startup startup is told that it has been started, you can enter shutdown immediate; and wait for the shutdown to finish, and then enter startup ```to wait a few seconds. After the command is run, you can connect. Similarly, ORA-01012 errors can also be resolved using this method.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.