Delphix Products

Expand all | Collapse all

The Network Adapter could not establish the connection

Jump to Best Answer
  • 1.  The Network Adapter could not establish the connection

    Posted 05-28-2017 10:47:00 AM
    Hope you all having great times,

    We restarted the engine this morning and rebooted the Linux target hosting Oracle DBs. The engine was is up and running again, but the target is running without the listener. here's the output when I try to oraenv a vdb on the target using delphix user:

    -bash-4.1$ . oraenv
    ORACLE_SID = [Vsim_Ed8] ?
    ORACLE_HOME = [/home/oracle] ?
    ORACLE_BASE environment variable is not being set since this
    information is not available for the current user ID delphix.
    You can set ORACLE_BASE manually if it is required.
    -bash-4.1$ lsnrctl
    -bash: lsnrctl: command not found
    Accessing any DB on the target using SQLdev is not possible either giving the same issue: "The Network Adapter could not establish the connection". We tried oraenv it with another user with more privileges but got same response. Any help is much appreciated since we're still at the early stages of testing and the tool keeps impressing everybody here. 

    Kind regards,
    Abdullah




  • 2.  RE: The Network Adapter could not establish the connection
    Best Answer

    Posted 05-28-2017 12:42:00 PM
    Hi, From the command output it seems that no oracle_home is set, this because delphix never updates the oratab file. So you can't use oraenv script unless you update the oratab file with the vdb entries. You have to set oracle_home manually to it's path and export the oracle_sid to get things fine. Reg rds, Mouhssine


  • 3.  RE: The Network Adapter could not establish the connection
    Best Answer

    Posted 05-28-2017 05:20:00 PM
    Abdullah,

    As Mouhssine states, this is a common outcome with Oracle VDBs.

    HERE is a link to a UNIX/Linux shell-script to be called from a ConfigureClone hook on an Oracle VDB to set entries into the ORATAB and TNSNAMES files.  This is offered without warranty and has been tested only briefly on Linux and Solaris, and I know someone who uses it on AIX too.

    Hope this helps...

    -Tim


  • 4.  RE: The Network Adapter could not establish the connection

    Posted 05-29-2017 06:17:00 AM
    Thanks, your help is very appreciated.