| Ora-27101 : shared memory realm does not exist [message #67607] |
Mon, 15 November 2004 03:17  |
karen
Messages: 19
Registered: January 2002
|
Junior Member |
|
|
Hi,
I'm getting the following errors when I try to connect :
ORA-01034 : <A class=iAs style="COLOR: darkgreen; BORDER-BOTTOM: darkgreen 1px solid; BACKGROUND-COLOR: transparent; TEXT-DECORATION: underline" href="http://www.tek-tips.com/viewthread.cfm?qid=951653&page=1#" target=_blank>ORACLE[/url] not available
Ora-27101 : shared memory realm does not exist
When I start my <A class=iAs style="COLOR: darkgreen; BORDER-BOTTOM: darkgreen 1px solid; BACKGROUND-COLOR: transparent; TEXT-DECORATION: underline" href="http://www.tek-tips.com/viewthread.cfm?qid=951653&page=1#" target=_blank>pc[/url] oracle does not start up by itself so I go to run -> cmd and type in :
set oracle_sid = grms
sqlplus /nolog
conn system/manager as sysdba
startup
The <A class=iAs style="COLOR: darkgreen; BORDER-BOTTOM: darkgreen 1px solid; BACKGROUND-COLOR: transparent; TEXT-DECORATION: underline" href="http://www.tek-tips.com/viewthread.cfm?qid=951653&page=1#" target=_blank>database[/url] then starts up.
Problem is I still get the error if I try to connect through Toad or <A class=iAs style="COLOR: darkgreen; BORDER-BOTTOM: darkgreen 1px solid; BACKGROUND-COLOR: transparent; TEXT-DECORATION: underline" href="http://www.tek-tips.com/viewthread.cfm?qid=951653&page=1#" target=_blank>sql[/url]*plus.
My tnsnames is correct. I checked it a few times.
The funny thing is that if I plug my network cable out, and restart my pc, my oracle starts up by itself and I don't have any problems.
So that let me think that maybe it is some sort of network problem or security setting. I know an outside contractor came to our company and changed some of the security settings on our network. Closed some of the ports etc. Don't know exactly what. My user belongs to the ORA_DBA group on my pc. Can't find ORA_DBA on the domain. So if I have to add it to the domain - how ?
My listener is started.
Do you think this can be the problem? Or am I totally looking at the wrong place? I don't have a lot of network/security knowledge. Does anybody have some suggestions what I must look for. I can contact the guy who changed our security setting, but at this stage I don't even know what to ask him.
Thanks
Karen
|
|
|
|
|
|
|
|
| Re: Ora-27101 : shared memory realm does not exist [message #67720 is a reply to message #67607] |
Wed, 26 January 2005 21:32  |
krishna
Messages: 141
Registered: October 1998
|
Senior Member |
|
|
Hi,
Just restart the server and login are root and follow the instructions.
> su - root
root> sqlplus sqlplus /nolog
root> connect sys as sysdba
root> enter password
>root startup force
and start the listener.
This will work.
Thanks,
Krishna Nimishakavi
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Ora-27101 : shared memory realm does not exist [message #67732 is a reply to message #67720] |
Wed, 09 February 2005 01:15 |
Nick
Messages: 64
Registered: February 2000
|
Member |
|
|
Sorry also for my english. :-)
I did this: #SQLNET.AUTHENTICATION_SERVICES= (NTS)
After that, i opened the Database again in DBA Stundio and after that, it worked well.
But if I restart the Server or the service, the Database is down again, i will get the Error 2701 again and i have to restart it again.
Any Ideas what i can do?
Thank for your help.
|
|
|
|
|
|
|
|
|
|
| Re: Ora-27101 : shared memory realm does not exist [message #354861 is a reply to message #67607] |
Tue, 21 October 2008 12:34 |
KbCb
Messages: 2
Registered: October 2008
|
Junior Member |
|
|
I have been getting the "Shared Memory Realm Does Not Exist" error on my oracle instance as well... When I do the following, it works again:
sqlplus /nolog
connect sys as sysdba
startup force
It then loads the database and things are working again. Even if I restart the oracle services it continues to work (for a while). But, after a while it stops working. For example, I ran with the database for about 24 hours, and then it stopped working again, and I started receiving the "Shared memory realm does not exist" error again.
Anyone have any ideas why this is occurring?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
