Oracle Database Discussions

What happens if you try to start it manually ? Logon as oracle user and

$ lsnrctl start
and
$ sqlplus / as sysdba
SQL> startup

and post the results.

Here are the results of both commands.

Message 850 not found; No message file for product=network, facility=NL

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

This seems to be your problem. Did you set environment variables (.bash_profile) for oracle user ?

I added the following line for user oracle .bash_profile

export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin

But it still didn't work. Is that the right way of doing it?

The bin directory is one level too deep. Try this:
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

~Jer

After you do what Jer wrote, add this line to .bash_profile:

export PATH=$PATH:$ORACLE_HOME/bin

(In case it's not there already.)

Message was edited by:
jonjac

I did all that and i got the message when im trying to start the service:

Failed to start Oracle Net Listener using /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr and Oracle Express Database using /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus.

in my profile file:

ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
PATH = $PATH:$ORACLE_HOME/bin

my so is the Ubuntu.

help will be nice plz.

Check /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log for a more comprohensive error. You should also set your ORACLE_SID env. to XE when you try to start the database manually.

What do you get when you issue a lsnrctl start command?

If you get permission denied, try and shorten your IPC Key to a smaller value. I did mine to IPCKEY and it started up.

Hello,

I'm using ubuntu but I can start the service. I obtain this message.



root@jaibana:# /etc/init.d/oracle-xe start
Starting Oracle Net Listener.
Starting Oracle Database 10g Express Edition Instance.
Failed to start Oracle Net Listener using /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr and Oracle Express Database using /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus.

I had the same issue.

I'm running Ubuntu 10.04 amd64.

Before installing, I had to:
1. sudo apt-get install bc

Then I installed the packet.
sudo dpkg --force-architecture -i oracle-xe_10.2.0.1-1.0_i386.deb

Then I configured the system:
sudo /etc/init.d/oracle-xe configure

I resolved the boot issue by doing the following:
1. export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
2. export ORACLE_SID=XE
3. export PATH=$ORACLE_HOME/bin:$PATH
4. sudo apt-get install ia32-libs
5. sudo /etc/init.d/oracle-xe start

The killer for me was missing the ia32-libs.

It can help you...

http://forums.opensuse.org/english/get-help-here/install-boot-login/414654-how-install-oraclexe-opensuse-11-1-a.html