Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have downloaded Oracle XE 11.2.0-1.0 and installed it on a CentOS 6.3 virtual machine with 1.5GB memory and 3GB of swap.

SYS and SYSTEM set to have password 123456. I have set ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe/ and ORACLE_SID=XE.

I can connect to this database with SQL Developer with the SYSTEM user. But when I want to connect with sqlplus it says:

ERROR.
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0

ps -fe | grep pmon shows this:

oracle    1164    1    0    11:26    ?    00:00:00    xe_pmon_XE

I have logged in as root user and I just type sqlplus with no arguments then it asks for user name and password.

Can anyone help?

share|improve this question
    
That usually means you haven't started Oracle (but the listener is running). –  a_horse_with_no_name Sep 3 '12 at 6:39
    
@a_horse_with_no_name I can create tables, ... in the database using sql developer. –  Majid Azimi Sep 3 '12 at 6:46
    
is there a pmon process running? what is the output of ps -fe|grep pmon? I am not familiar with sqldeveloper. what connection data do you use to connect to the system? –  miracle173 Sep 3 '12 at 6:47
    
i misread your post. how do you connect with sqlplus? –  miracle173 Sep 3 '12 at 6:48
1  
Try removing the final / in ORACLE_HOME, and don't try to log in with root. Use the oracle user. –  Mat Sep 3 '12 at 7:02

1 Answer 1

up vote 1 down vote accepted

I have removed the trailing / from ORACLE_HOME and it solved my problem.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.