Hello,
Here is how Delphix attempts to discover ASE instances:
- Get the $SYBASE environment variable by looking for the environment variable in the user’s list of environment variables (the user as specified in the OS Username of the Add Environment dialogue). This must be defined for non-interactive logins. This can be tested by executing "ssh delphix_os_user@ase_host env | grep SYBASE".
- Get the path to the isql binary looking under $SYBASE
- List the running instances using ps (see get_ase_instances.sh for details).
- In Delphix 4.3 and higher, the get_ase_instances.sh script is no longer run. Instead it uses the ProcessExplorer java class
- For each instance:
- Get the list of ports by running isql and querying the syslisteners table (see get_ase_instance_ports.sh for details).
- Connect via JDBC using the port retrieved from syslisteners and the host/IP entered in the environment definition screen. After successfully connecting, retrieve @@servername. Use the first port that works where @@servername is the same as the value from ps.
- Using JDBC, populate page size, instance owner and other attributes for each instance.
- Discover the list of user databases for each instance by querying sysdatabases (excluding the system databases 'master', 'model', 'sybsystemdb', ‘sybsystemprocs' and ‘tempdb').
So what those error messages are telling you is that Delphix is unable to connect to those ASE instances using "isql". Error
4002 is usually a username/password issue.
Note that since only a single $SYBASE environment variable is used, only that
$SYBASE/interfaces file is used when connecting to each ASE instance. So if there are multiple ASE instances you wish to discover automatically, all of them need to be in the Delphix operating system user's
$SYBASE/interfaces file.