Getting error ORACLE not available in Oracle 11g

Question

I am not able to connect Oracle 11g in Windows 7. Could somebody please help me. Below is the error message that I am getting :

SQL> connect system   
Enter password:   
ERROR:
ORA-01034: ORACLE not available   
ORA-27101: shared memory realm does not exist   
Process ID: 0    
Session ID: 0 Serial number: 0

My tnsnames.ora file :

  XE =     
    (DESCRIPTION =   
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))  
   (CONNECT_DATA =   
       (SERVER = DEDICATED)   
       (ORACLE_SID = XE)    
       (SERVICE_NAME = XE)   
   )   
  )   

 EXTPROC_CONNECTION_DATA =   
   (DESCRIPTION =   
     (ADDRESS_LIST =   
       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))   
     )   
     (CONNECT_DATA =   
        (SID = PLSExtProc)   
        (PRESENTATION = RO)   
     )    
   )   

  ORACLR_CONNECTION_DATA =     
    (DESCRIPTION =     
      (ADDRESS_LIST =    
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))    
      )    
     (CONNECT_DATA =    
        (SID = CLRExtProc)    
        (PRESENTATION = RO)    
      )    
  )

I have started the listener service but still getting same error. Could somebody please help me in resolving this issue.

you should connect like sqlplus username/password@connect_identifier also check TNSPING — Exhausted
– Exhausted, Commented Dec 12, 2014 at 5:59
Exhausted : do you mean by this command : SQL> connect system/system@XE , getting same error. — Peter
– Peter, Commented Dec 12, 2014 at 6:17
Everything seems ok, It should work. try connecting other user except sys,system. — Exhausted
– Exhausted, Commented Dec 12, 2014 at 6:36
@Exhausted : Below is the output of TNSPING XE Command: : C:\>tnsping XE Used > parameter files: </code>C:\oraclexe\app\oracle\product\11.2.0\server\network\admin \sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (ORACLE_SI D = XE) (SERVICE_NAME = XE))) ) — Peter
– Peter, Commented Dec 12, 2014 at 6:40
@Exhausted : I tried with SCOTT/TIGER as well but getting same error. — Peter
– Peter, Commented Dec 12, 2014 at 6:47

karthick · Accepted Answer · 2017-04-20 21:02:24Z

1

You need to start the oracle instance first. set up oracle_home and oracle_sid.

export ORACLE_HOME=/u01/app/oracle/product/11.2/dbhome_1/ (choose per env)

export ORACLE_SID=dev

$ lsnrctl start $ sqlplus '/ as sysdba' SQL> startup

answered Apr 20, 2017 at 21:02

karthick

1211 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting error ORACLE not available in Oracle 11g

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related