Jan 09
1

Oracle XE on Ubuntu Hardy

6 Comments

I just installed Oracle XE following the instructions I got from here. After the installation I was unable to successfully log into the Database Home page. It told me: Invalid Login Credentials. This seams to be a common problem with the Linux installation. The solution is all though very simple and is shown under “post installation tasks” at the end of this post.

Installation

 

Add this line to /etc/apt/sources.list file:

deb http://oss.oracle.com/debian unstable main non-free

Next, you will need to add the GPG key.

wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle  -O- | sudo apt-key add -

As root, type:

apt-get update
apt-get install oracle-xe
/etc/init.d/oracle-xe configure

 

Post Installation Tasks

To fix the “Invalid Login Credentials” bug: It looks like the installer sets the wrong password on the sys and system users when running the configure command. The solution is simple, just change the password.

First add you user to the dba group.

sudo usermod -a -G dba yourusername

Then log in with your OS username as sysdba.
Paste the following lines into a shell and press enter:

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

export PATH

(If you close the shell now, you will have to do it again, so keep it open. To make it persistent paste the lines into your ~/.bashrc file. )

sqlplus / as sysdba

And change the password

alter user system identified by newpassword;
alter user sys identified by newpassword;

Now you should be able to successfully log into the Database Home page with both the sys and the system user.

  • Twitter
  • Facebook
  • del.icio.us
  • Digg
  • Google Bookmarks
  • StumbleUpon
  • FriendFeed

Tags: ,

This entry was posted on January 1, 2009 at 18:55. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Posted in TechNotes Ubuntu by Hersson 6 Comments

6 Responses to "Oracle XE on Ubuntu Hardy"

  • Waqar
    Waqar says:
    July 13, 2009 at 13:56
    Reply

    thanks… it works for me

    just add sudo as …
    sudo usermod -a -G dba yourusername

  • Joe
    Joe says:
    July 24, 2009 at 12:13
    Reply

    Hi thank you very much for the tip.

    Just to add when executing the line:

    #ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

    make sure you don’t do by mistake:

    #ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/

    I did this and took me a while to figure out what had gone wrong — if you get it wrong sqlplus won’t connect to your instance as when you type:

    # PATH=$PATH:$ORACLE_HOME/bin

    it infact gets translated to

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

    instead of

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

  • Hersson
    Hersson says:
    July 24, 2009 at 14:53
    Reply

    Hi Joe.

    Thank you for your comment.
    Glad it worked out for you.

  • Fede
    Fede says:
    February 2, 2010 at 12:07
    Reply

    Works for me!, thanks! :)

  • Melvin Burgos
    Melvin Burgos says:
    February 12, 2010 at 05:44
    Reply

    Excelent I could changed SYSTEM password.

    In the Sql*plus console from “Oracle Database 10g Express Edition” Menu

    SQL> CONNECT / AS SYSDBA
    Conectado.

    SQL> alter user SYSTEM identified by ;

    Usuario modificado.

    Thanks.

Leave a Comment