CODEWITHSUNDEEP
windowsoracle11g
Peter
Peter

Reputation: 185

Getting error ORACLE not available in Oracle 11g

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.

Upvotes: 0

Views: 1574

Answers (1)

karthick
karthick

Reputation: 121

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

Upvotes: 1

Related Questions