ORA-27101: shared memory realm does not exist
Hi Listers, What could be the problem?? I'm getting the following error while connecting to the database on Solaris 8. ERROR:ORA-01034: ORACLE not availableORA-27101: shared memory realm does not existSVR4 Error: 2: No such file or directory Thanks to all Best Regards Munish Bajaj Blank Bkgrd.gif
RE: ORA-27101: shared memory realm does not exist
o Database is down. oWrong ORACLE_SID. o If your database processes is indeed up and you have the right ORACLE_SID, then you database might be in trouble. You can try to shut it down and restart it. Or you may choose to reboot oruse ipcs, ipcrm to clean it up. Because as not to mess other instances up. Richard -Original Message-From: Munish Bajaj [mailto:[EMAIL PROTECTED]Sent: Tuesday, June 03, 2003 2:00 AMTo: Multiple recipients of list ORACLE-LSubject: ORA-27101: shared memory realm does not exist Hi Listers, What could be the problem?? I'm getting the following error while connecting to the database on Solaris 8. ERROR:ORA-01034: ORACLE not availableORA-27101: shared memory realm does not existSVR4 Error: 2: No such file or directory Thanks to all Best Regards Munish Bajaj
RE: ORA-27101: shared memory realm does not exist
Check your alert log file to see what file is missing. Cheers -Original Message-From: Munish Bajaj [mailto:[EMAIL PROTECTED]Sent: 03 June 2003 07:00To: Multiple recipients of list ORACLE-LSubject: ORA-27101: shared memory realm does not exist Hi Listers, What could be the problem?? I'm getting the following error while connecting to the database on Solaris 8. ERROR:ORA-01034: ORACLE not availableORA-27101: shared memory realm does not existSVR4 Error: 2: No such file or directory Thanks to all Best Regards Munish Bajaj
Re: ORA-27101 Shared Memory Realm Does Not Exist
Dave, Thanks for the good article. I am trying for two separate instances on the same box, 8i and 9i. I am not installing anything just adding 9i. Thanks Rick [EMAIL PROTECTED] .tenet.edu To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: ORA-27101 Shared Memory Realm Does Not Exist 04/29/2002 05:31 PM Please respond to ORACLE-L Rick, Are you trying for two seperate versions of Oracle on the box, or did you remove the 8.1.6 to install 9i? If you did the latter, I'm afraid your uninstall did not go properly and your service isn't pointing to the right place. Oradim is the supported method for removing (renaming?) an Oracle instance, but here's some tips I got when I was new to the NT/2000 world from Novice DBA. I've sent this before, but you should take a look at your registry settings, they're probably the key to your problem and this document will help you know what to look for: Database Installation involves a set of procedures which need to be followed in order to have a proper working installation. If we follow these procedures the Installation will be fine and usually problems related to improper installation do not arise. But it is not always possible to get a proper installation for the first time. This document is a troubleshooting guide which would help to clear off the mess created by an improper installation in a WindowsNT system. First we need to know that During installation Oracle writes into certain directories (which we would have specified during installation) and also into the WindowsNT registry. WindowsNT registry is a repository of information about all the installed products and configurations on that system. When we are installing Oracle a directory is created in the registry which is name oracle which is present in the HKEY_LOCAL_MACHINE/SOFTWARE/ In the case of an improper installation the problems faced are · We may not be able to uninstall the incomplete installation · We may succeed in uninstalling the incomplete installation but yet face problems with WindowsNT Services. · Every time we log into WindowsNT we may get an error 'at least one system service failed to start' which may be an Oracle service from the earlier installation. · We may get an error while creating a database 'the database with the name you specified already exists please chose another name' which again may be attributed to an improper un-installation.(I am not pretty comfortable with the Oracle's Un-installation utility because I feel it does not uninstall everything) Keeping the above points in mind it would be better if we know where exactly to look in case we are faced with such problems. When oracle is installed it makes entries in the following places 1. The first and the foremost- the directory in which we install the Oracle database (say D:\Ora8i) 2. The second is the inventory it maintains in the directory c:\program files\oracle 3. The third HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE in the registry 4. The other place is HKEY_LOCAL_MACHINE/SYSTEM . Inside this entry there are three nodes controlset1,controlset2 and currentcontrolset. These nodes in turn have 4 nodes out of which 2 are important to us. They are Enum and Services. The Enum node has got two nodes out of which the 'root' node is of great interest to us because it stores details about all the services that are running on a WindowsNT system. The other node of interest from the controlsets is Services. The services node has got a list of services running on a WindowsNT system. In case we need to clean up the system after an incomplete installation we can follow the following steps Delete the home directory where Oracle is installed Delete the folder C
RE: ORA-27101 Shared Memory Realm Does Not Exist
Check memory on your server, you need to have enough physical RAM to hold your SGA and the Oracle processes. The services applet lies, sometimes it will say that a database NT service is running when in fact it is in a half-opened state. An easy way to test is to connect from the command line using sqlplus or (gasp!) svrmgrl. connect as internal or as sysdba. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, April 29, 2002 5:43 PM To: Multiple recipients of list ORACLE-L I just installed Oracle 9i on a WinNT 4 server. It already had 8.1.6. I installed Oracle 9 into a different home. The service/instance starts. When I try to connect via sqlplus / to create a database I get ORA-27101 Shared Memory Realm Does Not Exist . I have the oracle_sid set correctly. Any ideas as I have tried all I know but still get the same error. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-27101 Shared Memory Realm Does Not Exist
I just installed Oracle 9i on a WinNT 4 server. It already had 8.1.6. I installed Oracle 9 into a different home. The service/instance starts. When I try to connect via sqlplus / to create a database I get ORA-27101 Shared Memory Realm Does Not Exist . I have the oracle_sid set correctly. Any ideas as I have tried all I know but still get the same error. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-27101 Shared Memory Realm Does Not Exist
Rick, Are you trying for two seperate versions of Oracle on the box, or did you remove the 8.1.6 to install 9i? If you did the latter, I'm afraid your uninstall did not go properly and your service isn't pointing to the right place. Oradim is the supported method for removing (renaming?) an Oracle instance, but here's some tips I got when I was new to the NT/2000 world from Novice DBA. I've sent this before, but you should take a look at your registry settings, they're probably the key to your problem and this document will help you know what to look for: Database Installation involves a set of procedures which need to be followed in order to have a proper working installation. If we follow these procedures the Installation will be fine and usually problems related to improper installation do not arise. But it is not always possible to get a proper installation for the first time. This document is a troubleshooting guide which would help to clear off the mess created by an improper installation in a WindowsNT system. First we need to know that During installation Oracle writes into certain directories (which we would have specified during installation) and also into the WindowsNT registry. WindowsNT registry is a repository of information about all the installed products and configurations on that system. When we are installing Oracle a directory is created in the registry which is name oracle which is present in the HKEY_LOCAL_MACHINE/SOFTWARE/ In the case of an improper installation the problems faced are · We may not be able to uninstall the incomplete installation · We may succeed in uninstalling the incomplete installation but yet face problems with WindowsNT Services. · Every time we log into WindowsNT we may get an error 'at least one system service failed to start' which may be an Oracle service from the earlier installation. · We may get an error while creating a database 'the database with the name you specified already exists please chose another name' which again may be attributed to an improper un-installation.(I am not pretty comfortable with the Oracle's Un-installation utility because I feel it does not uninstall everything) Keeping the above points in mind it would be better if we know where exactly to look in case we are faced with such problems. When oracle is installed it makes entries in the following places 1. The first and the foremost- the directory in which we install the Oracle database (say D:\Ora8i) 2. The second is the inventory it maintains in the directory c:\program files\oracle 3. The third HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE in the registry 4. The other place is HKEY_LOCAL_MACHINE/SYSTEM . Inside this entry there are three nodes controlset1,controlset2 and currentcontrolset. These nodes in turn have 4 nodes out of which 2 are important to us. They are Enum and Services. The Enum node has got two nodes out of which the 'root' node is of great interest to us because it stores details about all the services that are running on a WindowsNT system. The other node of interest from the controlsets is Services. The services node has got a list of services running on a WindowsNT system. In case we need to clean up the system after an incomplete installation we can follow the following steps Delete the home directory where Oracle is installed Delete the folder C:\program files\oracle Note:- This clears off information about any other Oracle utility installed on that system. Delete the registry entry HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE Warning:- This clears off information about any other Oracle utility installed on that system and you may not be able to run those programs again. Delete the Oracle Related services from HKEY_LOCAL_MACHINE/SYSTEM/CONTROLSETx/ENUM/ROOT/ . They will be named with a prefix LEGACY_ORACLE... Note:- You will have to use regedt32.exe to invoke registry editor and not regedit. You will have to use the security menu and give permissions to yourself before deleting these entries. Else it will not work . It is to be noted that there are three control sets and all the three (in reality any 2) need to be cleared off these un-necessary entries. Delete the Oracle Related services from HKEY_LOCAL_MACHINE/SYSTEM/CONTROLSETx/SERVICES . They will have a prefix 'Oracle'. Hope this helps. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Rick_Cale@team health.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: ORA-27101 Shared Memory Realm Does Not Exist om
RE: ORA-27101: shared memory realm does not exist
Solaris 7 -Message d'origine- De : Henry Poras [mailto:[EMAIL PROTECTED]] Envoy : lundi 26 mars 2001 17:58 : Multiple recipients of list ORACLE-L Objet : RE: ORA-27101: shared memory realm does not exist What is the OS? -Original Message- Sent: Monday, March 26, 2001 10:41 AM To: Multiple recipients of list ORACLE-L I have this error when I try to connect to a 8.1.7 database instance. I don't really know what's happening. To give just an information, on the server machine I've 2 database engines (7.3.4 and 8.1.7) and on both engines there are 2 or more instances running. I've only one listener.ora file for both engines, with the correct ORACLE_HOMES Thank you folks ... @biy @lemu [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Cril Telecom Software France -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-27101: shared memory realm does not exist
I have this error when I try to connect to a 8.1.7 database instance. I don't really know what's happening. To give just an information, on the server machine I've 2 database engines (7.3.4 and 8.1.7) and on both engines there are 2 or more instances running. I've only one listener.ora file for both engines, with the correct ORACLE_HOMES Thank you folks ... @biy @lemu [EMAIL PROTECTED] Cril Telecom Software France
RE: ORA-27101: shared memory realm does not exist
What is the OS? -Original Message- Sent: Monday, March 26, 2001 10:41 AM To: Multiple recipients of list ORACLE-L I have this error when I try to connect to a 8.1.7 database instance. I don't really know what's happening. To give just an information, on the server machine I've 2 database engines (7.3.4 and 8.1.7) and on both engines there are 2 or more instances running. I've only one listener.ora file for both engines, with the correct ORACLE_HOMES Thank you folks ... @biy @lemu [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Cril Telecom Software France -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-27101: shared memory realm does not exist
Abiy, I'm not positive, but it appears that the server's Shared Memory may not be configured. Is the database started and open? I'm assuming not...if in fact Oracle can't allocate the SGA in Shared Memory. You may need to reconfigure your Shared Memory settings and recompile the UNIX Kernel. Check to see if these shared memory settings exist first. Ed Haskins] Oracle DBA Verizon Wireless -Original Message-From: ALEMU Abiy [mailto:[EMAIL PROTECTED]]Sent: Monday, March 26, 2001 10:41 AMTo: Multiple recipients of list ORACLE-LSubject: ORA-27101: shared memory realm does not exist I have this error when I try to connect to a 8.1.7 database instance. I don't really know what's happening. To give just an information, on the server machine I've 2 database engines (7.3.4 and 8.1.7) and on both engines there are 2 or more instances running. I've only one listener.ora file for both engines, with the correct ORACLE_HOMES Thank you folks ... @biy @lemu [EMAIL PROTECTED] Cril Telecom Software France
RE: ORA-27101: shared memory realm does not exist
If this is NT I have had this error as well. Mine was an error in the init.ora parameters, I forgot to comment something out. Kevin -Original Message- Sent: Monday, March 26, 2001 10:58 AM To: Multiple recipients of list ORACLE-L What is the OS? -Original Message- Sent: Monday, March 26, 2001 10:41 AM To: Multiple recipients of list ORACLE-L I have this error when I try to connect to a 8.1.7 database instance. I don't really know what's happening. To give just an information, on the server machine I've 2 database engines (7.3.4 and 8.1.7) and on both engines there are 2 or more instances running. I've only one listener.ora file for both engines, with the correct ORACLE_HOMES Thank you folks ... @biy @lemu [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Cril Telecom Software France -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).