Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

common problem but do help

NickRobheartDec 4 2012 — edited Dec 5 2012
Hi,
My environment:
Windows 7 Ultimate (32-bit version)..

Looks like this issue seem to be resolved in many threads but I being a novice really didnt find the language to be simple. I normally use a home desktop in which I installed the SQL software . It was running fine before but since 2 days.
I have the error "ORA-01034: Oracle not available" when I login.

So just to let you know, I normally open the software using command search "sqlplus'' in Windows+R
It opens a black windows saying
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 4 20:49:13 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

and then normally I try to connect using the
Username: System
Password: ******

Then, it throws me the message
ORA-01034: Oracle not available
ORA-27101 shared memory realm does not exist

A computer restarted fixed the problem once but this time I have no luck.
I am just starting to study by my own.
I just downloaded the software and I am practicing at home.
No important application running but this issue is driving me crazy.
Any help is appreciated,


Thanks in advance
Nikhil
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 2 2013
Added on Dec 4 2012
27 comments
1,734 views