ORA-01034 ORACLE not available ORA-27101 shared memory realm does not exist

Question

I am getting the above error when trying to connect to a server database from a client using service name orcl  It is getting connected when I am using the other service name i e  dms  Below is my listener ora  SID LIST LISTENER      SID LIST        SID DESC          SID NAME   dms         SERVICE NAME   dms         ORACLE HOME    home oracle app oracle product 11 2 0 dbhome 1          PROGRAM   extproc           SID DESC         SID NAME   orcl        SERVICE NAME   dms         GLOBAL DBANME   orcl         ORACLE HOME    home oracle app oracle product 11 2 0 dbhome 1         PROGRAM   extproc            LISTENER      DESCRIPTION LIST        DESCRIPTION          ADDRESS    PROTOCOL   IPC  KEY   EXTPROC1521          ADDRESS    PROTOCOL   TCP  HOST   192 168 1 53  PORT   1521               ADR BASE LISTENER    home oracle app oracle and tnsnames ora ORCL      DESCRIPTION        ADDRESS    PROTOCOL   TCP  HOST   192 168 1 53  PORT   1521        CONNECT DATA          SERVER   DEDICATED         SERVICE NAME   orcl localdomain         ORACLE SID   dms         SERVICE NAME   orcl             DMS      DESCRIPTION        ADDRESS    PROTOCOL   TCP  HOST   192 168 1 53  PORT   1521        CONNECT DATA          SERVER   DEDICATED         SERVICE NAME   dms         ORACLE SID   dms              Please tell me what to do

User · Answer

Run in cmd   sqlplus   as sysdba    Then   SQL gt  create pfile  c  init ora  from spfile    Remove sga target line in init ora file  then   SQL gt  create spfile from pfile  c  init ora   SQL gt  startup

User · Answer

Sometimes  the database will not be mounted correctly  so we need to mount it manually  For that  shut it down and start it up then mount  Log in as oracle user  then run the following commands   sqlplus   as sysdba  shutdown immediate  startup nomount  alter database mount  alter database open

User · Answer

In my case here  I just had to resurrect a server that was 9 years old  and Oracle was giving me this error   For some reason  the server had been renamed  but the app oracle product 10 2 0 server network admin listener ora file was still declaring a LISTENER with the old HOST   I had to put the same name that I had in  etc hostname in the  etc hosts  and also fix the name used in the listener ora

User · Answer

ORA-01034 and ORA-27101 normally indicate that the database instance you re attempting to connect to is shut down and that you re not connected as a user who has permission to start it up   Log on to the server 192 168 1 53 and start up the orcl instance  or ask your DBA to do this for you

User · Answer

Make sure that your ORACLE HOME and ORACLE SID are correct To see the current values in windows  at the command prompt type  echo  ORACLE HOME    Then  echo  ORACLE SID    If the values are not your current oracle home and SID you need to correct them  This can be done in Windows environment variables    Check out  this page for more info

User · Answer

Also try directly startup  sqlplus  nolog conn   as sysdba startup

User · Answer

Had the same issue on windows XP  Resolved  The error was caused due to the system log being full   Control Panel -  Administrative Tools -  Event viewer Right click on application log  clear all events  optionaly save the log  Same process for system log  Restart and it should work

User · Answer

SQL gt  sqlplus  quot   as sysdba quot  SQL gt  startup   Oracle instance started   ------   Database mounted    Database opened   SQL gt  Quit I also got same problem I tried above mentioned steps and then it worked for me You can try

User · Answer

Your listener ora is misconfigured  There is no orcl service

User · Answer

Open command prompt and execute the below commands   set oracle sid DATABASE NAME sqlplus  nolog conn sys sys as sysdba shutdown abort startup

User · Answer

After wasting so much time i got to know that there was mistake in my syntax to connect with DB  I was using colon  quot   quot   instead of slash  quot   quot    1  if you use sid below is the syntax to get connection     quot jdbc oracle thin   hostname   port   SID  quot      2  if you use service name  below is the syntax to get connection   quot   jdbc oracle thin     hostname   port   servicename    quot

User · Answer

I hope you have resolved your issue  If you still got issue then double check again if you install this Oracle under a domain account  I found a thread that says Oracle XE giving same error when installing under domain account  Please use a local account instead   Source    https   community oracle com thread 2141735 start 0 amp tstart 0

User · Answer

SQL gt  sqlplus    as sysdba  SQL gt  startup        Oracle instance started       ------       Database mounted        Database opened   SQL gt  Quit   oracle hcis     lsnrctl start

User · Answer

This same error occurred to me even though the ORACLE HOME and ORACLE SID seemed to be correctly set up    The problem was in ORACLE HOME  which is not supposed to end with a slash character  When I removed the ending slash  it started to work properly       INCORRECT export ORACLE HOME  usr local oracle 11gR2        CORRECT export ORACLE HOME  usr local oracle 11gR2   So  even if it seems everything is configured fine  check your variables for this

User · Answer

I faced the same issue while creating the connection on SQLDeveloper  ORA-01034  ORACLE not available ORA-27101  shared memory realm does not exist   Solution    1 Update the listene ora file to include the SID     SID LIST LISTENER        SID LIST          SID DESC            SID NAME   PLSExtProc           ORACLE HOME   C  oraclexe app oracle product 11 2 0 server           PROGRAM   extproc                 SID DESC            SID NAME   CLRExtProc           ORACLE HOME   C  oraclexe app oracle product 11 2 0 server           PROGRAM   extproc                 SID DESC             GLOBAL DBNAME   XE DB            ORACLE HOME   C  oraclexe app oracle product 11 2 0 server            SID NAME   XE                   LISTENER        DESCRIPTION LIST          DESCRIPTION            ADDRESS    PROTOCOL   IPC  KEY   EXTPROC1            ADDRESS    PROTOCOL   TCP  HOST   USMUMTBALAKDAS2 us deloitte com  PORT   1521                    DEFAULT SERVICE LISTENER    XE    The Oraclexe directory may have the permission set to  ReadOnly   Change the directory sub-directory permission to read write and restart the listener services  Problem is solved

User · Answer

I hit the same shared memory realm does not exist symptom  on Windows  but for a different reason  I had just installed Oracle  XE  and after some troubleshooting  established that my installation was corrupt due to the presence of an ORACLE HOME environment property at the time I installed it   If this is TLDR  skip to  So to resolve     My initial symptom was   Message 850 not found  No message file for product NETWORK  facility NL   Apparently the Windows install reads the ORACLE HOME from the registry and doesn t need  and certainly in my case shouldn t have     an environment property   Remove it  as follows    Edit the system environment settings  Windows key and start typing  env  and you should see this option come up   Delete any User and System Environment Variables called ORACLE HOME  if present   make a note of their values  mainly out of interest  but may be of use if you want to put them back for some reason   Restart your machine  Don t muck around with just a log off - restart your machine  The Windows Oracle install uses Windows services by default and your installation is currently very bad - it needs a restart    Following the restart I was then able to get error messages other than  No message file     and could start looking at what the issue was  Setting the ORACLE SID to XE and connecting  XE I got as far as the errors in this page  namely the following symptoms   ORA-01034  ORACLE not available ORA-27101  shared memory realm does not exist   Another symptom was  When launching the  Get started  page it failed to connect  giving a not found error  if I recall correctly   despite the Windows listener  amp  XE services being started  As noted in another answer  this could be due to the windows services not being started  In my case those services were started  so something else was misconfigured   At this point  I figured maybe my install had just gone so badly wrong due to the presence of my bad ORACLE HOME environment property that I should reinstall   Previous reinstalls hadn t helped  but those had all been before I noticed the ORACLE HOME system environment property  probably set up by me a year ago     So to resolve    Close any app looking at the Oraclexe install directory  editors explorer cmd prompts  A quick trip to Add Remove programs and uninstall OracleXe Double-check you have no ORACLE HOME environment property set anywhere  remember - Windows will use registry entries to get it  Restart  take no chances - we re in this for the long term   Did you make sure there was no ORACLE HOME property  Run the Oracle installer again  as local admin account if applicable  You should be able to rejoice in a working install  I did  at least

[oracle] ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist

Examples related to oracle

Examples related to oracle11g

Examples related to ora-01034

Examples related to ora-27101