7 Replies Latest reply: Oct 16, 2013 11:46 PM by 969134 Branched from an earlier discussion. RSS

    Re: Installation failed: ./runInstaller: line 254: install/.oui cannot execute binary file

    969134

      I have installed Oracle.

      After install I have execute two scripts:

      /opt/oraInventory/orainstRoot.sh

      $ORACLE_HOME/root.sh

      It creates some files in:

      LISTENER_ORCL =

        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

       

       

      ORCL =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = orcl)

          )

        )

       

       

      After this database worked normally.

      SQLDeveloper could connect to Oracle.

      But after reboot nothing works.

      I have execute $ORACLE_HOME/dbstart but it not works.

      After this I manually starts a database:

      $ORACLE_HOME/sqlplus /nolog

      connect / as sysdba

      startup


      Startup is failed - no initORCL.ora.

      I have copied init.ora and edit it like this:

      db_name='ORCL'

      memory_target=1G

      processes = 150

      audit_file_dest='/opt/oracle/admin/orcl/adump'

      audit_trail ='db'

      db_block_size=8192

      db_domain=''

      db_recovery_file_dest='/opt/oracle/flash_recovery_area'

      db_recovery_file_dest_size=2G

      diagnostic_dest='/opt/oracle'

      dispatchers='(PROTOCOL=TCP) (SERVICE=ORCL)'

      open_cursors=300

      remote_login_passwordfile='EXCLUSIVE'

      undo_tablespace='UNDOTBS1'

      # You may want to ensure that control files are created on separate physical

      # devices

      #control_files = (ora_control1, ora_control2)

      control_files = (/opt/oracle/oradata/orcl/control01.ctl, /opt/oracle/flash_recovery_area/orcl/control02.ctl)

      compatible ='11.2.0'

       

      After this manipulations database starts.

      But SQLDeveloper cannot connect to it.

      It failed with:

      TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

       

      I am looking in listener.ora and tnsnames.ora, but it looks fine:

      listener.ora:

      LISTENER =

        (DESCRIPTION_LIST =

          (DESCRIPTION =

      #      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

            (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

          )

        )

       

      tnsnames.ora:

      LISTENER_ORCL =

        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

       

       

      ORCL =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = orcl)

          )

        )

       

      ADR_BASE_LISTENER = /opt/oracle

       

      I cannot understand what problem in???

       

       

       




        • 1. Re: Installation failed: ./runInstaller: line 254: install/.oui cannot execute binary file
          EdStevens

          969134 wrote:

           

          I have installed Oracle.

          After install I have execute two scripts:

          /opt/oraInventory/orainstRoot.sh

          $ORACLE_HOME/root.sh

          It creates some files in:

          LISTENER_ORCL =

            (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

           

           

          ORCL =

            (DESCRIPTION =

              (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

              (CONNECT_DATA =

                (SERVER = DEDICATED)

                (SERVICE_NAME = orcl)

              )

            )

           

           

          After this database worked normally.

          SQLDeveloper could connect to Oracle.

          But after reboot nothing works.

          I have execute $ORACLE_HOME/dbstart but it not works.

          After this I manually starts a database:

          $ORACLE_HOME/sqlplus /nolog

          connect / as sysdba

          startup


          Startup is failed - no initORCL.ora.

          I have copied init.ora and edit it like this:

          db_name='ORCL'

          memory_target=1G

          processes = 150

          audit_file_dest='/opt/oracle/admin/orcl/adump'

          audit_trail ='db'

          db_block_size=8192

          db_domain=''

          db_recovery_file_dest='/opt/oracle/flash_recovery_area'

          db_recovery_file_dest_size=2G

          diagnostic_dest='/opt/oracle'

          dispatchers='(PROTOCOL=TCP) (SERVICE=ORCL)'

          open_cursors=300

          remote_login_passwordfile='EXCLUSIVE'

          undo_tablespace='UNDOTBS1'

          # You may want to ensure that control files are created on separate physical

          # devices

          #control_files = (ora_control1, ora_control2)

          control_files = (/opt/oracle/oradata/orcl/control01.ctl, /opt/oracle/flash_recovery_area/orcl/control02.ctl)

          compatible ='11.2.0'

           

          After this manipulations database starts.

          But SQLDeveloper cannot connect to it.

          It failed with:

          TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

           

          I am looking in listener.ora and tnsnames.ora, but it looks fine:

          listener.ora:

          LISTENER =

            (DESCRIPTION_LIST =

              (DESCRIPTION =

          #      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

                (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

              )

            )

           

          tnsnames.ora:

          LISTENER_ORCL =

            (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

           

           

          ORCL =

            (DESCRIPTION =

              (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

              (CONNECT_DATA =

                (SERVER = DEDICATED)

                (SERVICE_NAME = orcl)

              )

            )

           

          ADR_BASE_LISTENER = /opt/oracle

           

          I cannot understand what problem in???

           

           

           




           

           

          You should have started a new thread for this.  It just makes things confusing if you intend to just keep one thread running for whatever problems you encounter.

           

          I promise you that root.sh did not create your tns files (listener.ora, tnsnames.ora, sqlnet.ora).

           

          For basic connectivity problems,

          see: http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/  (Help! I can’t connect to my database  )

          see: http://edstevensdba.wordpress.com/2011/02/16/sqlnet_client_cfg/  ( Help! I can’t connect to my database (part duex) )

          see: http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/ (ora-12154 TNS:could not resolve the connect identifier specified)

          see: http://edstevensdba.wordpress.com/2011/02/27/tnsping-101/  (tnsping-101 )

          see: http://edstevensdba.wordpress.com/2011/03/19/ora-12514/  (ora-12514  Listener does not know of requested service )

          • 3. Re: Installation failed: ./runInstaller: line 254: install/.oui cannot execute binary file
            969134
            You should have started a new thread for this.  It just makes things confusing if you intend to just keep one thread running for whatever problems you encounter.
            Pl do not post duplicates - Re: Installation failed: ./runInstaller: line 254: install/.oui cannot execute binary file

            Oh! Excuse me. I accidentally wrote a reply to the wrong topic.



             

             

            I am starting database manually because command:

            $ORACLE_HOME/bin/dbstart $ORACLE_HOME

            does not work and there is no any console output.

             

            What is there in /etc/oratab ?


            ./lsnrctl status tells than there is no services associated with listener.

            Try the following :

             

             

            - stop the listener

             

            - remove/rename listener.ora

             

            - start the listener

             

            - wait up to a minute and retry.

             

             

            What happens ?

             

            I shall try to do it tomorrow. And I shall write about results.

             

            I promise you that root.sh did not create your tns files (listener.ora, tnsnames.ora, sqlnet.ora).

             

            $ORACLE_HOME/root.sh creates this files in:

            ls /usr/local/bin

            coraenv  dbhome  oraenv

             

            Maybe I need specify another path for $ORACLE_HOME/root.sh?

            • 4. Re: Installation failed: ./runInstaller: line 254: install/.oui cannot execute binary file
              EdStevens

              969134 wrote:

               

              You should have started a new thread for this.  It just makes things confusing if you intend to just keep one thread running for whatever problems you encounter.
              Pl do not post duplicates - Re: Installation failed: ./runInstaller: line 254: install/.oui cannot execute binary file

              Oh! Excuse me. I accidentally wrote a reply to the wrong topic.



               

               

              I am starting database manually because command:

              $ORACLE_HOME/bin/dbstart $ORACLE_HOME

              does not work and there is no any console output.

               

              What is there in /etc/oratab ?


              ./lsnrctl status tells than there is no services associated with listener.

              Try the following :

               

               

              - stop the listener

               

              - remove/rename listener.ora

               

              - start the listener

               

              - wait up to a minute and retry.

               

               

              What happens ?

               

              I shall try to do it tomorrow. And I shall write about results.

               

              I promise you that root.sh did not create your tns files (listener.ora, tnsnames.ora, sqlnet.ora).

               

              $ORACLE_HOME/root.sh creates this files in:

              ls /usr/local/bin

              coraenv  dbhome  oraenv

               

              Maybe I need specify another path for $ORACLE_HOME/root.sh?

               

              Maybe I need specify another path for $ORACLE_HOME/root.sh?

               

              NO!

              root.sh does what it does and it does it correctly.  I was pointing out that your assertion that it created your tns config files (tnsnames.ora, listener.ora, sqlnet.ora) is incorrect.  Forget about root.sh.  It has nothing to do with your problem ... unless you start monkeying around with it or what it does.

              • 5. Re: Installation failed: ./runInstaller: line 254: install/.oui cannot execute binary file
                969134

                What is there in /etc/oratab ?


                tail -n 200 /etc/oratab

                #

                 

                 

                 

                # This file is used by ORACLE utilities.  It is created by root.sh

                # and updated by the Database Configuration Assistant when creating

                # a database.

                 

                # A colon, ':', is used as the field terminator.  A new line terminates

                # the entry.  Lines beginning with a pound sign, '#', are comments.

                #

                # Entries are of the form:

                #   $ORACLE_SID:$ORACLE_HOME:<N|Y>:

                #

                # The first and second fields are the system identifier and home

                # directory of the database respectively.  The third filed indicates

                # to the dbstart utility that the database should , "Y", or should not,

                # "N", be brought up at system boot time.

                #

                # Multiple entries with the same $ORACLE_SID are not allowed.

                #

                #

                orcl:/opt/oracle/product/11.2.0:N

                 

                Try the following :

                 

                 

                - stop the listener

                 

                - remove/rename listener.ora

                 

                - start the listener

                 

                - wait up to a minute and retry.

                 

                 

                What happens ?

                 

                 

                 

                ./lsnrctl status

                 

                LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-OCT-2013 08:21:21

                 

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

                 

                Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))

                STATUS of the LISTENER

                ------------------------

                Alias                     LISTENER

                Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

                Start Date                17-OCT-2013 08:21:08

                Uptime                    0 days 0 hr. 0 min. 12 sec

                Trace Level               off

                Security                  ON: Local OS Authentication

                SNMP                      OFF

                Listener Parameter File   /opt/oracle/product/11.2.0/network/admin/listener.ora

                Listener Log File         /opt/oracle/diag/tnslsnr/Nikita/listener/alert/log.xml

                Listening Endpoints Summary...

                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

                The listener supports no services

                The command completed successfully

                 

                 

                 

                 

                mv /opt/oracle/product/11.2.0/network/admin/listener.ora /opt/oracle/product/11.2.0/network/admin/listener_copy.ora

                 

                 

                ./lsnrctl stop

                 

                ./lsnrctl start

                 

                 

                ./lsnrctl status

                 

                LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-OCT-2013 08:31:01

                 

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

                 

                Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

                STATUS of the LISTENER

                ------------------------

                Alias                     LISTENER

                Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

                Start Date                17-OCT-2013 08:30:57

                Uptime                    0 days 0 hr. 0 min. 4 sec

                Trace Level               off

                Security                  ON: Local OS Authentication

                SNMP                      OFF

                Listener Log File         /opt/oracle/diag/tnslsnr/Nikita/listener/alert/log.xml

                Listening Endpoints Summary...

                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=nikita.localdomain.localdomain)(PORT=1521)))

                The listener supports no services

                The command completed successfully

                 

                 

                 

                 

                 

                For basic connectivity problems,

                see: http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/  (Help! I can’t connect to my database  )

                see: http://edstevensdba.wordpress.com/2011/02/16/sqlnet_client_cfg/  ( Help! I can’t connect to my database (part duex) )

                see: http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/ (ora-12154 TNS:could not resolve the connect identifier specified)

                see: http://edstevensdba.wordpress.com/2011/02/27/tnsping-101/  (tnsping-101 )

                see: http://edstevensdba.wordpress.com/2011/03/19/ora-12514/  (ora-12514  Listener does not know of requested service )

                 

                I have read it all. Now I am understand that my main problem in listener.ora. I need configure it statically or dinamically. There must be some listening service.

                • 6. Re: Installation failed: ./runInstaller: line 254: install/.oui cannot execute binary file
                  969134

                  SQL> show parameter db_name;

                   

                  NAME                     TYPE     VALUE

                  ------------------------------------ ----------- ------------------------------

                  db_name                  string     ORCL

                  SQL> show parameter db_domain;

                   

                  NAME                     TYPE     VALUE

                  ------------------------------------ ----------- ------------------------------

                  db_domain                 string

                  SQL> show parameter service_names;

                   

                  NAME                     TYPE     VALUE

                  ------------------------------------ ----------- ------------------------------

                  service_names                 string     ORCL

                  SQL>

                  • 7. Re: Installation failed: ./runInstaller: line 254: install/.oui cannot execute binary file
                    969134

                    I have rename listener.ora and it works after a cup of tee!!!

                    ./lsnrctl status

                     

                    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-OCT-2013 08:46:53

                     

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

                     

                    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

                    STATUS of the LISTENER

                    ------------------------

                    Alias                     LISTENER

                    Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

                    Start Date                17-OCT-2013 08:30:57

                    Uptime                    0 days 0 hr. 15 min. 55 sec

                    Trace Level               off

                    Security                  ON: Local OS Authentication

                    SNMP                      OFF

                    Listener Log File         /opt/oracle/diag/tnslsnr/Nikita/listener/alert/log.xml

                    Listening Endpoints Summary...

                      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=nikita.localdomain.localdomain)(PORT=1521)))

                    Services Summary...

                    Service "ORCL" has 1 instance(s).

                      Instance "ORCL", status READY, has 2 handler(s) for this service...

                    The command completed successfully

                     

                    SQLDeveloper can connects to Database now!