Oracle has started, connect to sqlplus, query, the following error ORA-01034: sharedmemoryrealmdoes
Oracle has started, connect to sqlplus, query, the following error ORA-01034: ORACLE not availableORA-27101: shared memory realm does
Oracle has been started. After connecting to sqlplus, perform the query. the following error occurs:
A ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
SQL> shutdown immediate;
A ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Think of the oracle user's environment variable that has just been modified. It should be that oracle_home cannot be found and modified again. It is normal.
Recommended reading:
ORA-01172, ORA-01151 error handling
ORA-00600 [2662] troubleshooting
Troubleshooting for ORA-01078 and LRM-00109
Notes on ORA-00471 Processing Methods
ORA-00314, redolog corruption, or missing Handling Methods
Solution to ORA-00257 archive logs being too large to store
,