8 Replies Latest reply: Feb 2, 2012 12:53 AM by 720851 RSS

    after a successfull install, I can not launch oracle DB XE

    898236
      hello,

      I installed oracle db XE 10.2.0.1.0 on a centos 6.2 (~redhat) but I can't start it.
      I succeeded in launching it after the installation but after a reboot it is not launched (apex on my web browser gives me an error : page not found or similar).

      I logged in the oracle account but it didn't worked.
      (more infos if you want)

      when I enter "su - oracle" in a terminal, I have this :

      ------------------------------------------------------------------------------------------------------------
      -bash-4.1$ su - oracle
      Mot de passe :
      -bash-4.1$ export DISPLAY=new-host-3:0
      -bash-4.1$ /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/startdb.sh
      xsetroot: unable to open display 'new-host-3:0'
      xsetroot: unable to open display 'new-host-3:0'
      -bash-4.1$ export DISPLAY=new-host-3:0.0
      -bash-4.1$ /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/startdb.sh
      xsetroot: unable to open display 'new-host-3:0.0'
      xsetroot: unable to open display 'new-host-3:0.0'
      -bash-4.1$ export DISPLAY=:0.0
      -bash-4.1$ /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/startdb.sh
      No protocol specified
      xsetroot: unable to open display ':0.0'
      No protocol specified
      xsetroot: unable to open display ':0.0'
      -bash-4.1$ export DISPLAY=:0
      -bash-4.1$ /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/startdb.sh
      No protocol specified
      xsetroot: unable to open display ':0'
      No protocol specified
      xsetroot: unable to open display ':0'


      and with my account (in which xclock works) :

      [olivier@new-host-3 ~]$ /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/startdb.sh
      [olivier@new-host-3 ~]$
      ...seems ok yet the cursor appears only one second after the entering of the command, and the database does not have the time to be launched.
      -------------------------------------------------------------------------------------------------------

      can you help me?
      I can give you more informations if you want.

      thanks,

      olivier

      Edited by: 895233 on 30 janv. 2012 12:06
        • 1. Re: after a successfull install, I can not launch oracle DB XE
          clcarter
          $ export DISPLAY=new-host-3:0
          Are you expecting an X gui for database administration or an installer? Its not there. Setting DISPLAY is needed for any not-XE database software installation, but not for XE.

          As the oracle user, use the env .sh setup for your shell ... bash? Also note there must be a space between the dot and <full path>.sh source line:
          $ . /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh
          $ lsnrctl start
          ...
          $ sqlplus /nolog
          connect /as sysdba;
          ... Connected. --or-- Connected to idle instance.
          startup;
          exit
          $ lsnrctl status 
          ...
          Endpoints Summary...
          ... TCP ... host= ... port=1521 ...
          ... http ... host= ... port=8080 ...
          If you don't have both endpoints showing in the `lsnrctl status` output, the http:...:8080\apex pages will not work. Also verify that the host= values are correct.
          • 2. Re: after a successfull install, I can not launch oracle DB XE
            898236
            Hello

            thanks!

            I tried the commands you gave me and here is the result :

            -----------------------------------------------------------------------------------------------------
            [olivier@new-host-3 ~]$ su - oracle
            Mot de passe :
            -bash-4.1$ . /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh
            -bash-4.1$ lsnctl start
            -bash: lsnctl : commande introuvable
            -bash-4.1$ whereis lsnctl
            lsnctl:
            -bash-4.1$ lsnrctl start

            LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 30-JANV.-2012 23:32:49

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

            TNS-01106: Le processus d'écoute LISTENER a déjà été lancé
            -bash-4.1$ sqlplus /nolog

            SQL*Plus: Release 10.2.0.1.0 - Production on Lun. Janv. 30 23:33:00 2012

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

            SQL> connect /as sysdba
            Connecté.
            SQL> startup;
            ORA-01081: impossible de lancer ORACLE déjà en cours - fermer d'abord le thread
            SQL> exit
            Déconnecté de Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
            -bash-4.1$ lsnrctl status

            LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 30-JANV.-2012 23:33:57

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

            Connexion à (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
            STATUT du PROCESSUS D'ECOUTE
            ------------------------
            Alias LISTENER
            Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
            Date de départ 30-JANV.-2012 18:20:03
            Durée d'activité 0 jours 5 heures 13 min. 54 sec
            Niveau de trace off
            Sécurité ON: Local OS Authentication
            SNMP OFF
            Service par défaut XE
            Fichier de paramètres du processus d'écoute /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
            Fichier journal du processus d'écoute /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
            Récapitulatif d'écoute des points d'extrémité...
            (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
            Récapitulatif services...
            Le service "PLSExtProc" comporte 1 instance(s).
            L'instance "PLSExtProc", statut UNKNOWN, comporte 1 gestionnaire(s) pour ce service...
            La commande a réussi
            -bash-4.1$
            ----------------------------------------------------------------------------------------------------------------------------

            it's in french, but you can see there is nothing about the HTTP port... and apex does not work.

            could you help me, or tell me where it could come from?
            the best thing I could do would be a script which would be launched at the startup of the OS.


            olivier
            • 3. Re: after a successfull install, I can not launch oracle DB XE
              898236
              well, I'm disappointed :

              I launched dbschema, a java little program which seems to be practical in creating databases, but I can't connect to my database :

              here are the connection values:
              connection string : jdbc:oracle:thin:@HOST:PORT:DB
              with:
              host : localhost
              port : 1521
              user : lolveley
              DB : XE

              here is the error message :
              Error
              oracle.net.ns.NetException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

              Does my program needs the web listener (on port 1234 - not 8080 -) to work?
              it seems rather strange.
              • 4. Re: after a successfull install, I can not launch oracle DB XE
                898236
                I saw this : [http://www.zyxware.com/articles/2008/12/24/oracle-xe-solution-to-cannot-access-http-127-0-0-1-8080apex-errors]

                but I did not found the file /etc/hostname...

                Edited by: lolveley on 30 janv. 2012 16:30
                • 5. Re: after a successfull install, I can not launch oracle DB XE
                  898236
                  it seems it works.

                  I found the missing file, hostname (in /proc/sys/kernel) and added an alias for new-host-3.

                  then, /etc/init.d/oracle-xe force-reload and it worked.

                  but I have to make it run at the startup, it's not finished.
                  • 6. Re: after a successfull install, I can not launch oracle DB XE
                    clcarter
                    have to make it run at the startup
                    That requires updating the RC setup, perhaps you have a run level or Service Management GUI to enable/disable and specify when services get started or stopped for the various run levels.

                    Or, check your /etc/rc.d/rc?.d directories, if centOS uses that particular format.

                    There should be soft links pointing to /etc/rc.d/init.d/oracle-xe script. The soft links cause the system to call the script when the system performs a runlevel change, with either a start (S* links) or stop (K* links) argument.

                    Run level 5 is the desktop GUI, run level 3 is multi-user mode with networking but no GUI, run level 6 is reboot. You most certainly want a K link in rc6.d so that the database gets shut down properly with a system shutdown. These may not be correct for centOS, use your service management GUI program, or manually it should go something like this:
                    $ cd /etc/rc.d/rc6.d
                    # verify init.d path to script
                    $ ls ../init.d/oracle-xe
                    ... oracle-xe
                    $ sudo ln -s ../init.d/oracle-xe K05oracle-xe
                    # verify the soft link
                    $ ls -l K05*
                    ... K05oracle-xe -> ../init.d/oracle-xe
                    $ cd ../rc5.d
                    $ sudo ln -s ../init.d/oracle-xe S80oracle-xe
                    Be sure to check the alert log after rebooting, it is important that the database performs its shutdown. Not absolutely required, the instance is supposed to "repair" and ensure consistency when it does its startup, but you don't ever want to take away the database files from the instance before shutting down if at all possible.
                    • 7. Re: after a successfull install, I can not launch oracle DB XE
                      898236
                      hello

                      thank you very much for helping me but I think my problem is resolved : I restarted the OS and the database has been correctly launched (I mean I did nothing).

                      thank you again!

                      PS : I will mark this post as answered but I have an other problem, urgent (for tomorrow, knowing at my home it is 20h40) : I would like to access to the detabase remotely, and I can't.

                      if you can have a look...
                      • 8. Re: after a successfull install, I can not launch oracle DB XE
                        720851
                        For me, this fixed it!

                        Please see my Feb.1, 10:50pm post

                        Don's 3D