PDA

View Full Version : Newbee: ORA-27101: shared memory realm does not exist


Christian Ruediger
01-20-2004, 06:53 AM
Hello folks,

i am new to oracle so i'm sorry if my question is trivial.
I have Installen Oracle 8.1.7 successful on a SUN SOLARIS System.
Now i would like create a new database manually as describes in the
Administrators Manual. Thus i am trying to get connectet with sqlplus.
So here is my Problem:
Each time I'd like to connect in sqlplus I get the following
Error-Message:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory

I discovered that I get this Message independent of the username and
password i inserted before. So i assumed that my user password
combination is not known to oracle.
How do get get to know which users exist for oracle administration?
Or has anyone an Idea why i cant connect.

I've searched the net for answers but i havent found any matches yet.

This is what i did to connect:

bash-2.03$ ./sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jan 20 16:18:28 2004

(c) Copyright 2000 Oracle Corporation. All rights reserved.

SQL> connect userX As sysdba
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory

Christian Ruediger
01-20-2004, 07:32 AM
Christian Ruediger wrote: Hello folks, i am new to oracle so i'm sorry if my question is trivial. I have Installen Oracle 8.1.7 successful on a SUN SOLARIS System. Now i would like create a new database manually as describes in the Administrators Manual. Thus i am trying to get connectet with sqlplus. So here is my Problem: Each time I'd like to connect in sqlplus I get the following Error-Message: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory I discovered that I get this Message independent of the username and password i inserted before. So i assumed that my user password combination is not known to oracle. How do get get to know which users exist for oracle administration? Or has anyone an Idea why i cant connect. I've searched the net for answers but i havent found any matches yet. This is what i did to connect: bash-2.03$ ./sqlplus /nolog SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jan 20 16:18:28 2004 (c) Copyright 2000 Oracle Corporation. All rights reserved. SQL> connect userX As sysdba Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory

My Question is already answered.
I didnt start the instance.
The following lines fixed that:

sqlplus /nolog
connect / as sysdba
startup
exit


MyLounge.com Site Map
Forum: Cars, Cell Phone, Database, Games, Home Improvement, IT, Music, School, Sports, Web Design, Web Server, Weight Loss

The MyLounge.com forum is intended for informational use only and should not be relied upon and is not a substitute for any advice. The information contained on MyLounge.com are opinions and suggestions of members and is not a representation of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for the accuracy, completeness or usefulness of any postings or the qualifications of any person responding. Please consult a expert or seek the services of an attorney in your area for more accuracy on your specific situation. Please note that our forums also serve as mirrors to Usenet newsgroups. Many posts you see on our forums are made by newsgroup users who may not be members of MyLounge.com Term of Service