Delphix Products

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

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

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

Thanks, your help is very appreciated.