7 Replies Latest reply on Oct 12, 2010 11:43 AM by 804743

    Troubles with install of XE

    785598
      Greeting,

      I should start out saying I am quite new to Oracle and have never installed a DBMS, of any type, previously. That said, I have installed, so of, 10g XE in Ubantu 10.04. Sort of because nothing actually seems to work.

      1. Using Firefox to access the database home page will not. I've tried 12.0.0.1:8080/apex and localhost:8080/apex and both get can't connect errors. A proxy server is not used on my network and checking the connection options it appears to be set up the way it should.

      2. When I try to start the database from the command line (sqlplus / as sysdba; startup) the following results:
      ORACLE instance started.

      Total System Global Area 100663296 bytes
      Fixed Size 1257380 bytes
      Variable Size 92274780 bytes
      Database Buffers 4194304 bytes
      Redo Buffers 2936832 bytes
      ORA-00205: error in identifying control file, check alert log for more info

      Looking for the control files,

      SQL> SHOW PARAMETERS control_files

      NAME TYPE
      ------------------------------------ ---------------------------------
      VALUE
      ------------------------------
      control_files string
      /usr/lib/oracle/xe/app/oracle/
      product/10.2.0/server/dbs/ora_
      control1, /usr/lib/oracle/xe/a
      pp/oracle/product/10.2.0/serve
      r/dbs/ora_control2

      These files do not exist and a search of the extant directories for "ora_control" finds nothing remotel similar.

      I looked into creating the control files but after looking at the syntax I have no idea what to use for the various parameters.

      Any thoughts on how to resolve these issues greatly appreciated...
        • 1. Re: Troubles with install of XE
          jariola
          Hi,

          Did you run configure script ?
          sudo /etc/init.d/oracle-xe configure
          This might helpful. And I propose you install XE from repo
          https://help.ubuntu.com/community/Oracle10g
          http://www.debian-administration.org/articles/430


          Regards,Jari
          • 2. Re: Troubles with install of XE
            785598
            I did run the configure script and it seemed to execute correctly. I took a look at the other links and did not see anything regarding "...install XE from repo" and it's not clear to me what that means anyway?

            Thanks...
            • 3. Re: Troubles with install of XE
              jariola
              Hi,

              You add repository your source list and then
              sudo apt-get install oracle-xe
              Check second link

              Regards, Jari
              • 4. Re: Troubles with install of XE
                785598
                I tried the procedure in the second link by adding "deb http://oss.oracle.com/debian/ unstable main non-free" to the /etc/apt/sources.list (which I could not do with the sudo echo command; it had to be added by using sudo vi to edit the file?). Then ran "sudo apt-get update" and got the following error:

                W: GPG error: http://oss.oracle.com unstable Release: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 2E2BCDBCB38A8516


                I have no idea why the echo did not work nor any what the pubkey issue is about!
                • 5. Re: Troubles with install of XE
                  804743
                  All the installation experts out there, Is 10g Xe supported on Centos 5.2 (a variant of redhat)?

                  I have several problems in the installation. Any help is appreciated.

                  1. installation log seems to have errors in it, but all directories/files seemed to be copied correctly. Here is the output of
                  rpm -ivh oracle-xe-univ-10.2.0.1-1.0.i386.rpm > install.log 2>&1
                  cat install.log
                  cat install.log
                  Preparing... ##################################################
                  /var/tmp/rpm-tmp.15157: line 89: bc: command not found
                  /var/tmp/rpm-tmp.15157: line 90: bc: command not found
                  /var/tmp/rpm-tmp.15157: line 95: bc: command not found
                  /var/tmp/rpm-tmp.15157: line 96: test: !=: unary operator expected
                  oracle-xe-univ ##################################################
                  Executing Post-install steps...

                  /var/tmp/rpm-tmp.88744: line 37: bc: command not found
                  /var/tmp/rpm-tmp.88744: line 38: bc: command not found
                  /var/tmp/rpm-tmp.88744: line 39: bc: command not found
                  /var/tmp/rpm-tmp.88744: line 40: bc: command not found
                  /var/tmp/rpm-tmp.88744: line 41: bc: command not found
                  /var/tmp/rpm-tmp.88744: line 42: bc: command not found
                  /var/tmp/rpm-tmp.88744: line 43: bc: command not found
                  /var/tmp/rpm-tmp.88744: line 44: bc: command not found
                  /var/tmp/rpm-tmp.88744: line 45: test: !=: unary operator expected
                  /var/tmp/rpm-tmp.88744: line 50: bc: command not found
                  /var/tmp/rpm-tmp.88744: line 51: test: !=: unary operator expected
                  /var/tmp/rpm-tmp.88744: line 56: bc: command not found
                  You must run '/etc/init.d/oracle-xe configure' as the root user to
                  configure the database.

                  2. Next, I ran ' /etc/init.d/oracle-xe configure' command. No errors were reported. However, there were log files in the $ORACLE_HOME/config/log directory.
                  # ls -l
                  total 16
                  -rw-r--r-- 1 oracle dba 1758 Oct 12 04:43 cloneDBCreation.log
                  -rw-r--r-- 1 oracle dba 398 Oct 12 04:43 CloneRmanRestore.log
                  -rw-r--r-- 1 oracle dba 988 Oct 12 04:43 postDBCreation.log
                  -rw-r--r-- 1 oracle dba 569 Oct 12 04:43 postScripts.log

                  A sample of contents is as follows;

                  # cat cloneDBCreation.log
                  Create controlfile reuse set database "XE"
                  *
                  ERROR at line 1:
                  ORA-01034: ORACLE not available


                  BEGIN dbms_backup_restore.zerodbid(0); END;

                  *
                  ERROR at line 1:
                  ORA-01034: ORACLE not available


                  ORA-01034: ORACLE not available
                  ORA-27101: shared memory realm does not exist
                  Linux Error: 2: No such file or directory
                  LRM-00116: syntax error at 'audit_file_dest' following '='
                  ORA-01078: failure in processing system parameters
                  Create controlfile reuse set database "XE"
                  *
                  ERROR at line 1:
                  ORA-01034: ORACLE not available


                  alter system enable restricted session
                  *
                  ERROR at line 1:
                  ORA-01034: ORACLE not available


                  alter database "XE" open resetlogs
                  *
                  ERROR at line 1:
                  ORA-01034: ORACLE not available


                  alter database rename global_name to "XE"
                  *
                  ERROR at line 1:
                  ORA-01034: ORACLE not available


                  alter system switch logfile
                  *
                  ERROR at line 1:
                  ORA-01034: ORACLE not available


                  alter system checkpoint
                  *
                  ERROR at line 1:
                  ORA-01034: ORACLE not available


                  alter database drop logfile group 3
                  *
                  ERROR at line 1:
                  ORA-01034: ORACLE not available


                  ALTER TABLESPACE TEMP ADD TEMPFILE '/usr/lib/oracle/xe/oradata/XE/temp.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
                  *
                  ERROR at line 1:
                  ORA-01034: ORACLE not available


                  select tablespace_name from dba_tablespaces where tablespace_name='USERS'
                  *
                  ERROR at line 1:
                  ORA-01034: ORACLE not available


                  select sid, program, serial#, username from v$session
                  *
                  ERROR at line 1:
                  ORA-01034: ORACLE not available


                  alter user sys identified by "oracle"
                  *
                  ERROR at line 1:
                  ORA-01034: ORACLE not available


                  alter user system identified by "oracle"
                  *
                  ERROR at line 1:
                  ORA-01034: ORACLE not available


                  alter system disable restricted session
                  *
                  ERROR at line 1:
                  ORA-01034: ORACLE not available


                  [root@localhost log]#

                  3. Then, when I try to start the database manually and check its status.
                  # /etc/init.d/oracle-xe start
                  Starting Oracle Database 10g Express Edition Instance.

                  [root@localhost log]# /etc/init.d/oracle-xe status

                  LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 12-OCT-2010 05:37:03

                  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 12-OCT-2010 04:43:36
                  Uptime 0 days 0 hr. 53 min. 27 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=localhost.localdomain)(PORT=1521)))
                  Services Summary...
                  Service "PLSExtProc" has 1 instance(s).
                  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                  The command completed successfully
                  [root@localhost log]#

                  Again, no error reported, but clearly database not started.

                  4. I also cannot access Database home page. Output of lnsrctl is :

                  lsnrctl status

                  LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 12-OCT-2010 05:39:55

                  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 12-OCT-2010 04:43:36
                  Uptime 0 days 0 hr. 56 min. 18 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=localhost.localdomain)(PORT=1521)))
                  Services Summary...
                  Service "PLSExtProc" has 1 instance(s).
                  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                  The command completed successfully
                  [root@localhost log]#
                  • 6. Re: Troubles with install of XE
                    jariola
                    Hi,

                    Seems you have not installed package bc. Install that and then reinstall db



                    Regards,
                    Jari
                    • 7. Re: Troubles with install of XE
                      804743
                      Thanks a lot for a quick and precise answer! It works like a charm after installing bc.