Get the following error when logging into SQLPlus – ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist

5 pts.
Tags:
Error Message ORA 01034
Error Message ORA 27101
Error ORA-12514
ORA-01034
ORA-27101
Oracle 10g
Oracle error messages
SQLPlus
Visual Studio 2005
When i try to log into Oracle SQL*Plus i get the following error ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist I'm using Oracle 10g Personal Edition Also getting the following error when trying to connect to an oracle database via VS2008 ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.

Answer Wiki

Thanks. We'll let you know when a new response is added.

I guess you are using ‘Express Edition’.

Please provide a little more information.

Are you trying to connect from a remote client, or locally ?
Were you able to connect from SQL*Plus before, or you have never been able to connect ?
Have you made changes to some database parameter (such as SGA size) ?
What is the operating system (database server and client) ?

You might find some useful information in the oradim log, which is usually under <oracle_home>\app\oracle\product\10.2.0\server\database\ (on a windows server).

Is Oracle started : show SQL*Plus a IDLE-Message ?, if so, start the datebase:

SQL> startup

Is the listener started ? use lsnrctl status, if not started, then use lsnrctl start

good luck

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following