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

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

969134 Newbie
Currently Being Moderated

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 Guru
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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!