12 comments on “Oracle XE on Ubuntu Hardy

  1. 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

  2. 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.

  3. Hi,
    I have done all the steps , but when I want to login to Oracle I get the message ‘Invalid login credentials’, I login with ‘system’ and the password I am sure is the one I gave when I installed Oracle. I would appreciate any help

  4. When I create the database link on XE, it gets created. But while referring to the object I am getting error. ORA-12154: TNS:could not resolve the connect identifier specified

    What could be the issue ?

Leave a Reply

Your email address will not be published. Required fields are marked *


seven − 2 =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>