ORACLE Not available

Error detail 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. Running

[Email protected] admin]$ sqlplus ' sys/[email protected]: 1521/ORCL as Sysdba '

2. Run:

Sql>startup

3. Test:

Sql>select * from User_tables;

OK shows in addition to very many results!

At this point Tnsnames.ora content:

# 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 run:

Lsnrctl start

ORACLE Not available