Oracle Error Code/Message: "shared memory realm does not exist"
Questions tagged [ora-27101]
8 questions
65
votes
17 answers
ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
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 =
…
maverick
- 1,458
- 5
- 20
- 28
4
votes
1 answer
Oracle 11g XE - sudden ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist
Windows 7 32 bit laptop
Local instance of Oracle 11g XE
Firstly I have been researching this myself before asking and while there are many references/suggestions around I've not been able to fix the issue for myself.
All of a sudden when i try to…
user3548783
- 175
- 2
- 2
- 9
2
votes
0 answers
ORACLE not available
I installed Oracle 11g express edition on my windows7 OS.
But I got an error always.
My regedit.exe;
ORACLE_HOME : C:\oraclexe\app\oracle\product\11.2.0\server
ORACLE_SID : XE
and
My Environment Variables settings;
ORACLE_HOME :…
kenan altan
- 41
- 3
- 6
1
vote
0 answers
Oracle database error (ORA-12505, ORA-01078, ORA-00600)
I am a beginner who has just begun to study Spring. And I'm using Boot Camp on a MacBook. I am having a problem linking SQL Developer to my database.
I downloaded Oracle 11g Express Edition and SQL Developer to link Oracle database to use STS. But…
Angel Choi
- 107
- 5
1
vote
1 answer
Error while connecting to Oracle using JDBC
I am trying to connect to Oracle DB using JDBC.
I have put ojdbc.jar in classpath.
ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist IBM AIX RISC System/6000
Hardik Mishra
- 14,779
- 9
- 61
- 96
0
votes
1 answer
Can connect using SQL Developer, but cannot connect using SQL*PLUS (ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist)
I recently installed Oracle Database 18c.
I have no problem connecting to the database using SQL Developer.
However, when I try to connect using SQL*PLUS, I'm given the error messages in the subject headline.
Can anyone tell me why this is?
Here is…
DrVonSamuel
- 41
- 1
- 5
0
votes
1 answer
I am able to connect to my schema via Oracle SQL Developer but not via JDBC
I am trying to connect to a schema on Oracle 11g on remote server via JDBC and I am getting following error while I am able to successfully connect through Oracle SQL Developer. I used the same JDBC code to connect many others schema which was…
bihari_gamer
- 422
- 5
- 15
0
votes
1 answer
Oracle Connection Probelem: ORA-01034: ORA-27101
The oracle was working properly on the server but suddenly from 2 days ago I've not been able to connect it, unfortunately the server manager is not around for weeks and I am not familiar with oracle very much, I appreciate your help in advance.
The…
Shane
- 128
- 1
- 3
- 15