Ora-01034, ora-27101 troubleshooting

Ora-01034, ora-27101 troubleshooting

Error cause:

Solution: ora-27101

There may be 2 scenarios, which may lead you to encounter ORA-27101
1) Invalid ORACLE_HOME and ORACLE_SID (configured in environment variables)
2) Database is down (check whether the instance has been started)

Solution address: http://nimishgarg.blogspot.com/2013/06/ora-27101-shared-memory-realm-does-not.html

Print the message when executing the startup command.

========================================================== ======

As you can see, this is not a ora-27101 problem (because I have made sure that the environment variables, the instance is okay)

Ora-03113, that's the problem, archiving logs are full.

Solution: Add a log space or delete an archived log.

The following describes how to delete an archive log.