Moved to Virtual environment - 27101 error

[jfc1003]

Issue:
ORA-01034: Oracle not available
ORA-27101: shared memory realm does not exist

Cause: We used an imaging utility to image a server with a failing motherboard. We restored the image to a Hyper-V virtual environment. The virtual server runs just fine and all software functions correctly other than Oracle.

Before restoring the server, the imaging software prepares the Operating system to boot to new hardware which I believe resets some SIDs and such.

So the hardware change or something related has caused Oracle to not be happy. I can still get the old server to boot if I need to compare settings.

Ideas to resolve this issue?

 

[Turkbear]

Hi,
When you try to start the Oracle instance what errors do you get?

What OS in the Virtual environment?







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[jfc1003]

I guess I'm not sure what to say on the Oracle instance. The errors we get are listed at the beginning of the post. I am not an Oracle guru by any means. The Oracle DB is the foundation of a Lab management software we use. I get the same error when trying to start the software. I don't know how to start the instance of Oracle per se. The Oracle services are running.

The operating system is Server 2003.

 

[Turkbear]

Hi,
The Oracle services are separate from the actual Oracle instance...Check with your Oracle DBA ( or whoever set up the database..) - an Oracle instance has to be started
See if this helps:

http://download-uk.oracle.com/docs/cd/B28359_01/server.111/b28301/instance001.htm#CIHEDGEA

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[kutz13]

What state was the Oracle instance in when you imaged the server - shutdown completely, open, mounted etc?
I've had this a few times on MS server 2003 R2, more often than UNIX/Linux anyway, and normally a restart of the Oracle services or m/c reboot resolves things.

Check the specs of the virtual server match the original - cpu count, total ram, disk identifiers etc.

What version of Oracle are you using?

What is your disaster recovery process - RMAN, export dump, cold backup? Hopefully you'll not need it this time - but sooner or later you will. If you haven't got anything in place (and you can get the old m/c started) sort one out now!

The difference between eggs and bacon: The chickens involved but the pigs committed