7 Replies Latest reply: Apr 17, 2007 8:53 AM by cd_2 RSS

    Installing and Running Oracle XE on Ubuntu Linux 6.06 Dapper LTS

    526811
      Hiya.
      I've successfully installed Oracle XE, but I'm having one hell of a time getting it actually working.
      I've run the configure commands, and I've restarted the database.

      sanjay@sanjay-desktop:~$ sudo /etc/init.d/oracle-xe configure
      Oracle Database 10g Express Edition is already configured
      sanjay@sanjay-desktop:~$ sudo /etc/init.d/oracle-xe restart
      Shutting down Oracle Database 10g Express Edition Instance.
      Stopping Oracle Net Listener.

      Starting Oracle Net Listener.
      Starting Oracle Database 10g Express Edition Instance.

      It did not happen at all like Todd Trichler's guide to installing on Ubuntu (http://www.oracle.com/technology/tech/linux/install/xe-on-kubuntu.html) suggests that it would. As far as my shell is concerned, the database IS started. Firefox disagrees.
      I don't have too many ideas, now. Last night I had issues with not running as the Oracle user, but I'd at least expect the server to start and then say "bugger off", or to not start a all.

      I don't know what much of the following means, but perhaps someone here does: (I found it in my conquest of made-up parameters)

      sanjay@sanjay-desktop:~$ sudo /etc/init.d/oracle-xe reconfigure
      Usage: /etc/init.d/oracle-xe start
      sanjay@sanjay-desktop:~$ sudo /etc/init.d/oracle-xe status

      LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 17-APR-2007 02:36:46

      Copyright (c) 1991, 2005, Oracle. All rights reserved.

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER
      Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
      Start Date 17-APR-2007 02:23:41
      Uptime 0 days 0 hr. 13 min. 5 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Default Service XE
      Listener Parameter File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
      Listener Log File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sanjay-desktop)(PORT=1521)))
      Services Summary...
      Service "PLSExtProc" has 1 instance(s).
      Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
      Service "XE" has 1 instance(s).
      Instance "XE", status READY, has 1 handler(s) for this service...
      Service "XEXDB" has 1 instance(s).
      Instance "XE", status READY, has 1 handler(s) for this service...
      Service "XE_XPT" has 1 instance(s).
      Instance "XE", status READY, has 1 handler(s) for this service...



      Thanks for your time,
      Sanjay
        • 1. Re: Installing and Running Oracle XE on Ubuntu Linux 6.06 Dapper LTS
          cd_2
          Did you check if you could log into the database through sqlplus? As for access through the apex interface, have you tried exec dbms_xdb.sethttpport(8080); on the sqlplus prompt?

          C.
          • 2. Re: Installing and Running Oracle XE on Ubuntu Linux 6.06 Dapper LTS
            526811
            No.

            SQL> exec dbms_xdb.sethttpport(8080);
            SP2-0640: Not connected
            SP2-0641: "EXECUTE" requires connection to server
            SQL>

            Oracle isn't listening on 8080, I know for sure.

            root@sanjay-desktop:/usr/lib/oracle/xe/app/oracle/admin/XE/udump# netstat -an | grep oracle
            unix 2 [ ACC ] STREAM LISTENING 31500 /var/tmp/.oracle/s#10196.1
            unix 2 [ ACC ] STREAM LISTENING 31503 /var/tmp/.oracle/s#10196.2
            unix 2 [ ACC ] STREAM LISTENING 31498 /var/tmp/.oracle/sEXTPROC_FOR_XE
            • 3. Re: Installing and Running Oracle XE on Ubuntu Linux 6.06 Dapper LTS
              506787
              SQL> exec dbms_xdb.sethttpport(8080);
              SP2-0640: Not connected
              SP2-0641: "EXECUTE" requires connection to server
              SQL>

              --> you need to be connected to the database, not just fire up sqlplus. probably with sysdba privilege

              root@sanjay-desktop:/usr/lib/oracle/xe/app/oracle/admin/XE/udump# netstat -an | grep oracle
              unix 2 [ ACC ] STREAM LISTENING 31500 /var/tmp/.oracle/s#10196.1
              unix 2 [ ACC ] STREAM LISTENING 31503 /var/tmp/.oracle/s#10196.2
              unix 2 [ ACC ] STREAM LISTENING 31498 /var/tmp/.oracle/sEXTPROC_FOR_XE

              --> the component that lets oracle communicate with the outside world is the listener. Please try 'netstat -anp | grep tnslsnr'
              • 4. Re: Installing and Running Oracle XE on Ubuntu Linux 6.06 Dapper LTS
                cd_2
                You need to logon to the database, for example with
                sqlplus / as sysdba
                C.
                • 5. Re: Installing and Running Oracle XE on Ubuntu Linux 6.06 Dapper LTS
                  526811
                  Well don't I just feel like a genius?
                  I tried connecting as sysdba, but it is refusing my password. I know it is one of two passwords, so I'm going to have to reset it. I'm searching Google now.


                  sanjay@sanjay-desktop:~$ sudo netstat -anp | grep tnslsnr
                  Password:
                  tcp 0 0 0.0.0.0:1521 0.0.0.0:* LISTEN 4 767/tnslsnr
                  tcp 0 0 127.0.1.1:1521 127.0.1.1:52772 ESTABLISHED4 767/tnslsnr
                  unix 2 [ ACC ] STREAM LISTENING 11571 4767/tnslsnr / var/tmp/.oracle/sEXTPROC_FOR_XE
                  unix 2 [ ACC ] STREAM LISTENING 11573 4767/tnslsnr / var/tmp/.oracle/s#4767.1
                  unix 2 [ ACC ] STREAM LISTENING 11576 4767/tnslsnr / var/tmp/.oracle/s#4767.2
                  sanjay@sanjay-desktop:~$
                  • 6. Re: Installing and Running Oracle XE on Ubuntu Linux 6.06 Dapper LTS
                    526811
                    Done and done!
                    and it works.

                    Thanks a million, mate!

                    For those other guys who get screwed over by Ubuntu:
                    Download the .deb
                    Install said .deb
                    sudo /etc/init.d/oracle-xe configure
                    sudo /etc/init.d/oracle-xe restart
                    sudo passwd oracleJust to be sure ;-)
                    Logout. Login as oracle with above password.
                    Applications -> Oracle Database 10g Express Edition -> Run SQL Command Line
                    connect / as sysdba
                    exec dbms_xdb.sethttpport(8080);

                    Once again, thanks for the help.
                    • 7. Re: Installing and Running Oracle XE on Ubuntu Linux 6.06 Dapper LTS
                      cd_2
                      You're welcome. Usually I don't set a password to the oracle user, my path is:

                      sudo -s
                      su - oracle
                      source /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh
                      rlwrap sqlplus / as sysdba

                      But that's just me. Note: rlwrap gives you a "command history" but you need to install it.

                      C.