Monday, August 1, 2011

ORA-44410: XE edition single instance violation error

I am trying to run Oracle XE on Oracle Virtual Box

/oracle/db/xe/app/oracle/product/10.2.0/server/bin/sqlplus

"Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
"


cd
vi .bash_profile

export ORACLE_BASE=/oracle/db/xe/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/server/
export ORACLE_SID=XE

PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin



source .bash_profile

sqlplus / as sysdba

"connected to an idle instance"

select * from dual
"ORA-01034: ORACLE not available"

startup

"ORA-44410: XE edition single instance violation error"

shutdown abort
"ORACLE instance shut down"

startup
"ORA-44410: XE edition single instance violation error"

GRRRRRR!


lsnrctl status

"Instance "PLSExtProc", status UNKNOWN"


The solution is provided by Paulo (thank you soooo much) in his comment:


I've run into the exactly same problem and made exactly the same mistake:

export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/server/

Remove the trailing backslash from the path. Also add TNS_ADMIN. Here is my complete .bash_profile:

$ cat .bash_profile
export ORACLE_BASE=/usr/lib/oracle/xe/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/server
export ORACLE_SID=XE
export TNS_ADMIN=$ORACLE_HOME/network/admin
export PATH=$PATH:$ORACLE_HOME/bin


6 comments:

Paulo said...

I'v run into the exactly same problem and made exactly the same mistake:

export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/server/

Remove the trailing backslash from the path. Also add TNS_ADMIN. Here is my complete .bash_profile:

$ cat .bash_profile
export ORACLE_BASE=/usr/lib/oracle/xe/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/server
export ORACLE_SID=XE
export TNS_ADMIN=$ORACLE_HOME/network/admin
export PATH=$PATH:$ORACLE_HOME/bin

I hope this helps.

Pierluigi Vernetto said...

great stuff Paulo, I have updated my post with your solution.

Thanks again!

Sérgio Berlotto Jr said...

Tks for this solution !
Works fine for me...
Save my life ! :-)

Эрнест Куттубаев said...

Thanks for solution.
was having the same problem, solution worked for me

adesst said...

Super! Problem away...

Gurram Vinaychandra said...

Not sure what, but issue is solved once system team rebooted the machine.