8 Replies Latest reply: Mar 15, 2013 8:08 AM by 997161 RSS

    Database configuration failed

    922723
      Hi, good day.
      I'm installing oracle database 11g express edition on my opensuse 12.2
      The problem became when I execute the command '/etc/init.d/oracle-xe configure' to configure the instalation.
      Send me the next error:


      Starting Oracle Net Listener...Done
      Configuring database...
      Database Configuration failed. Look into /u01/app/oracle/product/11.2.0/xe/config/log for details

      I've abaut three days trying resolve this problem.

      The next are the logs that I have:

      **************Begin of CloneRmanRestore.log

      ORA-00119: invalid specification for system parameter LOCAL_LISTENER
      ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=linux-ux8x)(PORT=1521))'
      select TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      declare
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      select TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0

      **************End of CloneRmanRestore.log

      ***************Begin of CloneDBCreation.log
      Create controlfile reuse set database "XE"
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      BEGIN dbms_backup_restore.zerodbid(0); END;

      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      Linux-x86_64 Error: 2: No such file or directory
      ORA-00119: invalid specification for system parameter LOCAL_LISTENER
      ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=linux-ux8x)(PORT=1521))'
      Create controlfile reuse set database "XE"
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      alter system enable restricted session
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      alter database "XE" open resetlogs
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      alter database rename global_name to "XE"
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      alter system switch logfile
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      alter system checkpoint
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      alter database drop logfile group 3
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/XE/temp.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      select tablespace_name from dba_tablespaces where tablespace_name='USERS'
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      select sid, program, serial#, username from v$session
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      alter user sys identified by "oracle"
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      alter user system identified by "oracle"
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      alter system disable restricted session
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0

      ***************End of cloneDBCreation.log

      Well I hope somebody could help me.

      And Thanks to EveryBody

      Edited by: 919720 on 13-oct-2012 1:07
        • 1. Re: Database configuration failed
          phaeus
          Hello,
          please look that on linux-ux8x (the Host you install) a ping command succeeded.
          In case all your network test are fine. Your problem will be that no listener is running on your host, so start one with lsnrctl start.

          The error you have is that the local_listener Parameter is not resolve able.

          regards
          Peter
          • 2. Re: Database configuration failed
            922723
            OK Thanks Phaeus.

            I did that you said me, but now the problem is the next:

            when I execute the command lsnrctl start show me the next in the terminal:

            ***********************begin text on terminal
            LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 13-OCT-2012 09:55:17

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

            Starting /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr: please wait...

            TNSLSNR for Linux: Version 11.2.0.2.0 - Production
            System parameter file is /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
            Log messages written to /u01/app/oracle/product/11.2.0/xe/network/log/listener.log
            Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
            Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=linux-ux8x)(PORT=1521)))
            TNS-12545: Connect failed because target host or object does not exist
            TNS-12560: TNS:protocol adapter error
            TNS-00515: Connect failed because target host or object does not exist

            NL-08014: Failed to initialize Diagnosability framework, falling back to old network tracing/logging
            No valid ADR Base to use

            NL-08013: Invalid ADR Base directory

            Listener failed to start. See the error message(s) above...

            ***********************end text on terminal

            Now the next text is the listener.log file:

            ******************************begin of listener.log file

            TNSLSNR for Linux: Version 11.2.0.2.0 - Production on 13-OCT-2012 09:55:19

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

            System parameter file is /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
            Log messages written to /u01/app/oracle/product/11.2.0/xe/network/log/listener.log
            Trace information written to /u01/app/oracle/product/11.2.0/xe/network/trace/listener.trc
            Trace level is currently 0

            NL-08014: Failed to initialize Diagnosability framework, falling back to old network tracing/logging
            No valid ADR Base to use

            NL-08013: Invalid ADR Base directory
            Started with pid=14178
            Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
            Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=linux-ux8x)(PORT=1521)))
            TNS-12545: Connect failed because target host or object does not exist
            TNS-12560: TNS:protocol adapter error
            TNS-00515: Connect failed because target host or object does not exist

            NL-08014: Failed to initialize Diagnosability framework, falling back to old network tracing/logging
            No valid ADR Base to use

            NL-08013: Invalid ADR Base directory
            No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
            ******************************end of listener.log file

            Now, What do you advise me that I should do?
            • 3. Re: Database configuration failed
              orafad
              Is networking properly configured first?

              What output do you get from:

              $ ping linux-ux8x

              $ hostname
              • 4. Re: Database configuration failed
                922723
                When I do:
                ping linux-ux8x

                The message shown is:

                ping: unknown host linux-ux8x

                How I can configure my network?
                • 5. Re: Database configuration failed
                  orafad
                  Also post output from the second command.


                  Anyway, lets so if os config is proper for listener operation with default settings.
                  Try the following:

                  - stop the listener (probably not running in this case)

                  - rename listener parameter file (/u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora)

                  - start the listener


                  If starting it succeeds, wait at least 1 minute and run lsnrctl stat.

                  Edited by: orafad on Oct 19, 2012 10:17 AM
                  • 6. Re: Database configuration failed
                    Chris_0703
                    One of the things I noticed from the Oracle documentation is that the latest supported Linux verisons are Oracle/RHEL 5 and SLES 11, which were released in 2007 and 2009 respectively. The problem is that in OpenSuSE 12, they changed the startup script from sysvint to systemd. I don't know if that is what's causing it, but it might be a factor.

                    The feature was removed in 12.2, but in 12.1, you can choose the option of booting into sysvinit.
                    • 7. Re: Database configuration failed
                      922723
                      Ok thanks to help me. Is working now.
                      • 8. Re: Database configuration failed
                        997161
                        For the benefit of others, the issue in my case was simply that the hostname was unresolvable. Adding it to /etc/hosts is a quick workaround.