Ora 01034 ora 27101 ошибка

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:

  1. Edit the system environment settings (Windows key and start
    typing ‘env’ and you should see this option come up.
  2. 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!)
  3. 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 & 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:

  1. Close any app looking at the Oraclexe install directory (editors/explorer/cmd prompts)
  2. A quick trip to Add/Remove programs and uninstall OracleXe
  3. Double-check you have no ORACLE_HOME environment property set anywhere, remember — Windows will use registry entries to get it.
  4. Restart (take no chances — we’re in this for the long term!)
  5. Did you make sure there was no ORACLE_HOME property?
  6. Run the Oracle installer again (as local admin account if applicable)
  7. You should be able to rejoice in a working install. I did, at least!
Источник

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:

  1. Edit the system environment settings (Windows key and start
    typing ‘env’ and you should see this option come up.
  2. 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!)
  3. 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 & 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:

  1. Close any app looking at the Oraclexe install directory (editors/explorer/cmd prompts)
  2. A quick trip to Add/Remove programs and uninstall OracleXe
  3. Double-check you have no ORACLE_HOME environment property set anywhere, remember — Windows will use registry entries to get it.
  4. Restart (take no chances — we’re in this for the long term!)
  5. Did you make sure there was no ORACLE_HOME property?
  6. Run the Oracle installer again (as local admin account if applicable)
  7. You should be able to rejoice in a working install. I did, at least!
Источник

In my previous articles i have given the basic idea about multiple oracle errors in detail. I have given the one by one errors.In this article i would like to throw light on most important error coming while working on oracle- ORA-27101: shared memory realm does not exist error. The ORA-27101: shared memory realm does not exist will come due to when local shared memory realm is not accessible. You can see more details in oracle documentation where you will find out multiple types of oracle errors in detail.

Why ” ORA-27101: shared memory realm does not exist ” is coming?

In this section i would like to give you the actual error coming and why that error is coming in detail. I would like to explain multiple scenarios with the error also try to give the resolution of the error.

There are two scenarios due to which this error is occurring :

Scenario 1 :ORACLE_HOME or ORACLE_SID is wrong

There are so many times where ORACLE_HOME and ORACLE_SID is wrong and due to that ORA-27101 error will come.

Scenario 2 : When Database itself is Down

There are so many times the database will be down due to network error and due to that ORA-27101 error will come.We require to check what kind of error is occurring.

Error Description :

[oracle@Amit_db~]$ sqlplus amit_database/Pass@W0RD
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 4 20:14:07 2020
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

I would like to discuss the scenarios in detail.Before that we require to think about the basic cause and its basic solution.

The basic Cause: The basic cause of this error is Unable to locate shared memory realm
Required Action: The DBA need to verify that the realm is accessible

How to resolve the Error –ORA-27101: shared memory realm does not exist ?

In this section i would like to give the 2 scenarios i explained in above paragraph and i will try to give the resolution for the error.

Scenario 1:Invalid ORACLE_HOME and ORACLE_SID:

The basic cause of ORA-27101 is usually due to the invalid ORACLE_HOME and ORACLE_SID parameters at Operating system level.

Steps to check whether ORACLE_HOME and ORACLE_SID Parameters set correct way,

Step 1 : Check whether the ORACLE_HOME is without slash

Step2 : We require to check the trailing slash at first step.

Example :

$ echo $ORACLE_HOME
$ /app/oracle/832/ << This is incorrect because of trailing slash /832/

$ echo $ORACLE_HOME
$ /app/oracle/832<<The oracle home is Correct because slash is not there

Step 3 : Check and Export Oracle SID

[oracle@Amit_db~]$ echo $ORACLE_HOME
/u01/app/oracle/product/10.2.0/amu_01

[oracle@192 ~]$ echo $ORACLE_SID
Amit_test_db

In above case ORACLE_SID is not right, we need to export ORACLE_SID to the valid one which is ora832

[oracle@Amit_db~]$ export ORACLE_SID=ora832
[oracle@Amit_db~]$ sqlplus amit_database/Pass@W0RD
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 4 20:14:07 2020
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Using above way we can resolve the issue with ORACLE_SID or ORACLE_HOME and we can resolve the issue.

Resolution :

Basically, to resolve ORA-27101, Once ORACLE_HOME and ORACLE_SID are correct, and then try to start SQL*Plus. 

ORA-27101: shared memory realm does not exist

Scenario 2: Database is down:

We can also face the ORA-27101 error when database is down.So to resolve the issue we require to start the database again.

[oracle@Amit_db~]$ sqlplus sys/sys as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on tue Aug 4 19:22:38 2020
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to an idle instance.

SQL> startup
ORACLE instance started.
Total System Global Area 1356784321 bytes
Fixed Size                  1234522bytes
Variable Size             187766663bytes
Database Buffers         102233333333bytes
Redo Buffers               23343334bytes
Database mounted.
Database opened.

Resolution :

To start the database again if it is down.

Using the database start operation you require to connect to the databases.These are the two scenarios for resolving ORA-27101: shared memory realm does not exist with examples.Hope you will get idea about resolving the ORA-27101: shared memory realm does not exist error.If you like this article or if you have any issues with the same kindly comment in comments section.

Источник

April 12, 2020

Sometimes you can get ” ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist ” error.

ORA-01034: ORACLE not available

Details of error are as follows.

ORA-01034: ORACLE not available

Cause: Oracle was not started up. Possible causes include the following:- The SGA requires more space than was allocated for it.

– The operating-system variable pointing to the instance is improperly defined.

Action: Refer to accompanying messages for possible causes and correct the problem mentioned
in the other messages. If Oracle has been initialized, then on some operating systems,

verify that Oracle was linked correctly. See the platform specific Oracle documentation.

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory

ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exis

This errors are taken because of the following reasons.

  • Oracle Instance is not started.
  • ORACLE_SID or ORACLE_HOME or both are not properly defined.
  • Size of SGA is smaller than an Oracle Instance requires.
  • Remote user might face it due to improper configuration of Listener.
  • Refer to accompanying messages for possible causes and correct the problem.


Linux-x86_64 Error: 2: No such file or directory


Check the Oracle SID and Oracle Home, if they are Ok or not ?


[oracle@MSDBdbadm01:/home/oracle:> echo $ORACLE_SID

[oracle@MSDBdbadm01:/home/oracle:> echo $ORACLE_HOME




Compare Oracle SID and Oracle home from oratab file. oratab files are exist under the following paths.


/etc/oratab

/var/opt/oracle/oratab




If they are not set correctly, then set them as follows.




Unix/Linux :


[oracle@MSDBdbadm01:/home/oracle:> ORACLE_SID=INSTANCE_NAME

[oracle@MSDBdbadm01:/home/oracle:> export ORACLE_SID

[oracle@MSDBdbadm01:/home/oracle:> export ORACLE_HOME=/u01/app/product/12.2.0/dbhome_1

[oracle@MSDBdbadm01:/home/oracle:> sqlplus / as sysdba

SQL> startup




Window :

C:\> set ORACLE_SID=INSTANCE_NAME
C:\> sqlplus / as sysdba

SQL> startup




Do you want to learn Oracle Database for Beginners, then Click and read the following articles.


Oracle Database Tutorials for Beginners ( Junior Oracle DBA )












About Mehmet Salih Deveci









I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.










Источник





          




Problem


This technote addresses the error «Shared memory Realm does not exist».  This can occur when you try to log into IBM® Rational® ClearQuest® on UNIX® platforms.





  



                       
  










Symptom


This Oracle error can occur when you try to log into the ClearQuest UNIX client:



Openlink Broker Error: Shared memory Realm does not exist.

OpenLink: [Oracle Server]ORA-01034: Oracle not available. ORA-27101: Shared memory realm does not exist. SVR4 Error: 2: No such file or directory [SQLSTATE:S1000]






Cause


The case of the Oracle SID or HOST values might be incorrect.  For example, the HOST or SID values of the connection options are stored all in upper case. The server may be defined with lower case values.






Environment


This problem occurs with ClearQuest environments hosted on Oracle databases.  It is observed when using UNIX-based operating systems.






Resolving The Problem


Change the connection options for your ClearQuest databases.  They should match the case of values as configured on the Oracle server.





  



                       
  






    

  1. To fix the user database connection options, you will need to login to ClearQuest Designer on Microsoft® Windows® computer. 
    2. 

  2. Select the menu option Database > Update User Database Properties.
    3. 

  3. This will bring up the Update User Database Properties dialog.
    4. 

  4. In the dialog, update the SID and/or HOST values so that they have the correct case.
    5. 

  5. Now update the Schema Repository. On the same computer, open the ClearQuest Maintenance Tool.
    6. 

  6. Select the menu option Schema Repository > Update.
    7. 

  7. Correct the connection options in the same manner.
    8. 


Disclaimer
  
  
 





All source code and/or binaries attached to this document are referred to here as «the Program». IBM is not providing program services of any kind for the Program. IBM is providing the Program on an «AS IS» basis without warranty of any kind. IBM WILL NOT BE LIABLE FOR ANY ACTUAL, DIRECT, SPECIAL, INCIDENTAL, OR INDIRECT DAMAGES OR FOR ANY ECONOMIC CONSEQUENTIAL DAMAGES (INCLUDING LOST PROFITS OR SAVINGS), EVEN IF IBM, OR ITS RESELLER, HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.












 Related Information 





          [{«Product»:{«code»:»SSSH5A»,»label»:»Rational ClearQuest»},»Business Unit»:{«code»:»BU053″,»label»:»Cloud & Data Platform»},»Component»:»Database Configuration\/Connectivity — Oracle»,»Platform»:[{«code»:»PF002″,»label»:»AIX»},{«code»:»PF010″,»label»:»HP-UX»},{«code»:»PF027″,»label»:»Solaris»}],»Version»:»2003.06.00;2003.06.12;2003.06.13;2003.06.14;2003.06.15;2003.06.16″,»Edition»:»»,»Line of Business»:{«code»:»LOB45″,»label»:»Automation»}}]
          






Источник







  



                       
  





	









    
    
    
    



    

                
Понравилась статья? Поделить с друзьями:

        
        

























    








			

  • Ora 01031 insufficient privileges ошибка
    • 

  • Ospp vbs ошибка 2147217394
    • 

  • Ora 01013 описание ошибки
    • 

  • Ora 01012 not logged on ошибка
    • 

  • Ose exe ошибка

    •