Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Ora-27107 Error when the Services are Running Properly and connecting earlier this week was fine.

Posted on 2003-11-21
18
Medium Priority
?
771 Views
Last Modified: 2012-05-04
I'm trying to connect to me 9.0.1 database and I keep getting the horrid Ora-27107 Shared Memory Realm does not exist.  I've stopped and started all of the services.  I've tried increasing the Shared Pool size.  The *.ora files haven't changed from Tueday, when I didn't have this problem.
What's the casue but most importantly, what's the fix?
Thank you
0
Comment
Question by:washdcanalyst
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 9
  • 9
18 Comments
 
LVL 23

Expert Comment

by:seazodiac
ID: 9801205
the fix is that  you are missing ORACLE_SID

make sure you have database listener and database up and running.

to verify these, at the command prompt:

"lnsrctl services"

you should see a long message saying

<database sid> has 1 service handler


"tnsping <oracle_sid>"

you should see a short message saying

connect to .....<oracle_sid> <host=..><port=...>
ok


then

in windows,
do "SET ORACLE_SID=<oracle_databae_you_connnect>",

in unix

do "export ORACLE_SID=<oracle_databae_you_connnect>"



last , try to connect again.
0
 

Author Comment

by:washdcanalyst
ID: 9801327
Didn't work.  I tried that hours ago.  Same result.
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 9802715
have you done these already?

make sure you have database listener and database up and running.

to verify these, at the command prompt:

"lnsrctl services"

you should see a long message saying

<database sid> has 1 service handler


"tnsping <oracle_sid>"

you should see a short message saying

connect to .....<oracle_sid> <host=..><port=...>
ok
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
LVL 23

Expert Comment

by:seazodiac
ID: 9802717
This error "Shared Memory Realm does not exist" generally means the database is not up.

also try these  steps:

1. Verify the service is running (This does not mean the DB is up).
2. Check the alert log for errors about why the database didn't come up.
3. From a command prompt:
sqlplus /nolog
connect / as sysdba
startup pfile=c:/path_to_pfile/initMYDB.ora
0
 

Author Comment

by:washdcanalyst
ID: 9802720
Yes, I've done that.  The listener is up and the db service is up.  I can stop and start them
easily without error.
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 9802724
ok, then do this:

 From a command prompt:
sqlplus /nolog
connect / as sysdba
startup pfile=c:/path_to_pfile/initMYDB.ora
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 9802737
sorry, you have not mentioned what OS you are running.

the above method is for UNIX

if you are in Windows:

From a command prompt:
sqlplus /nolog
connect sys/password@<sid> as sysdba
startup pfile=c:/path_to_pfile/initMYDB.ora
0
 

Author Comment

by:washdcanalyst
ID: 9802748
When I use EM, the password for sys works.
When I try your solution, it says invalid username/password.
0
 

Author Comment

by:washdcanalyst
ID: 9802753
There's a case of beer in it for you if you can get me back in business.
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 9802770
Ok, deal! ;-)

provide the following info:

1. where are you connecting from , a separate client machine or server machine itself?
2. how many oracle instances are there in the server machine?
3. what OS are you running? (my guess is windows, because you mentioned services)
4. Do you recall any work has been done on the server machine or database since the last good time?
0
 

Author Comment

by:washdcanalyst
ID: 9802803
Connecting from my desk, via Terminal Services to the server.  I have limited
success working in the Server room, the mouse does not work well on that terminal.

Only 1 instance of Oracle running

Windows 2000 Server

Nothing extraordinary has been done on the server between it working and it suddenly
not working.
0
 

Author Comment

by:washdcanalyst
ID: 9802834
OK, typo in the sys password.
I can log in, I can start the database, I can mount the database, I just can't Open the database.
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 9802839
better, post the shown error message then or it's the same error message?
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 9802874
so what did oracle say when you tried opening the database?
0
 

Author Comment

by:washdcanalyst
ID: 9802922
I need to repair the UNDO tablesspace.  Can I do that without the database Open?

Errors in file c:\oracle\admin\BWB\udump\ORA01636.TRC:
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: 'C:\ORACLE\ORADATA\BWB\UNDOTBS01.DBF'

Sat Nov 22 10:32:24 2003
Error 376 happened during db open, shutting down database
USER: terminating instance due to error 376
Instance terminated by USER, pid = 1636
ORA-1092 signalled during: ALTER DATABASE OPEN...
0
 
LVL 23

Accepted Solution

by:
seazodiac earned 860 total points
ID: 9803575
Oh, boy!

It isn't clear if this datafile is still available (possibly due to the media failure , file corruption, file deletion, or data file offline).
I suggest doing the following:

1. Mount the database.
2. Check the status of the datafile (see if the undo data file is online).
3. make sure the physical file exists (in the OS file system level)
3. Recover the datafile. (Do not use alter database, just RECOVER DATAFILE 'FILESPEC<file_path>'; )
4. Bring datafile online
5. Bring the db up.
0
 

Author Comment

by:washdcanalyst
ID: 9804112
Between you and 2 guys from Oracle (Matt/Martin) I've finally gotten the
instance back up.  I appreciate you sticking with me all morning.  It's been
a trying 2 days.  You have earned my respect (not to mention a case)
and at least 1 gold start.  Many thanks,
-chris
0
 

Author Comment

by:washdcanalyst
ID: 9804118
The ultimate problem was that we had used Windows compression on the
drive and it took 3 days for it to be a problem for Oracle.  Oracle states
that they do not support Windows compression (or any other for that matter).
But we needed the disk space.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question