ORACLE not available, oracleavailable

ORACLE not available, oracleavailable
ERROR Description: ERROR: ORA-01034: ORACLE not availableORA-27101: shared memory realm does not exist process ID: 0 session ID: 0 serial number: 0

 

Solution:

1. Execute

[Oracle @ ay1401_135826z admin] $ sqlplus 'sys/Hello54987663 @ localhost: 1521/orcl as sysdba'

 

2. Execute:

SQL> startup

 

3. test:

SQL> select * from user_tables;

OK, except for many results!

 

The content of tnsnames. ora is as follows:

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.orcl =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))    (CONNECT_DATA =      (SID = orcl)    )  )    

Listener. ora content:

# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora# Generated by Oracle configuration tools.LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))    )  )SID_LIST_LISTENER=  (SID_LIST=(SID_DESC=         (GLOBAL_DBNAME=orcl)         (SID_NAME=orcl)         (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/)       )      )

 

 

Appendix:

Oracle listener startup execution:

Lsnrctl start

A ORA-01034: ORACLE not available

Normally, sometimes the virtual machine will not save the things you installed before after the restart, and occasionally encounter it, saving your time and reinstalling it. Of course, if you have installed everything (especially the oracle software), check your environment variable configuration. Most of the errors are caused by incorrect environment variables.

What is oracle not available?

Did you select the "Install software only" option during installation?
Generally, this error is caused by the absence of a database.
Click Start> All Programs> Oracle-Db11g_home> Configure and port tools> Database configuration Assistant (DBCA) To Go To The DBCA tool interface, select "Create a database ". Click "Next" step by step as required, and then click "finish ".
This error does not occur after the database is created.