Home > IT Answers > Oracle > Get the following error when logging into SQLPlus – ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist
Oracle2000
5 pts.
 Get the following error when logging into SQLPlus – ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist
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.

Software/Hardware used:
ASKED: March 11, 2009  8:41 PM
UPDATED: March 12, 2009  6:10 AM
RELATED QUESTIONS
Answer Wiki:
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>apporacleproduct10.2.0serverdatabase (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
Last Wiki Answer Submitted:  March 12, 2009  6:10 am  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _