The Network Adapter could not establish the connection

  • 1
  • 1
  • Problem
  • Updated 12 months ago
  • Solved
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
Photo of Abdullah alsuwailem

Abdullah alsuwailem

  • 240 Points 100 badge 2x thumb

Posted 12 months ago

  • 1
  • 1
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,632 Points 4k badge 2x thumb
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
Photo of Tim Gorman

Tim Gorman, Field Services

  • 2,794 Points 2k badge 2x thumb
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
Photo of Abdullah alsuwailem

Abdullah alsuwailem

  • 240 Points 100 badge 2x thumb
Thanks, your help is very appreciated.