Delphix Products

I'm playing with preinstalled VMware lab. Everything seems ok but I cannot find info about the meaning of that little blue "x" icon appeared on the source db.
Again. If I want to modify the source db which is the listening port on the app on source?
">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1447792/RackMultipart20160711-116875-14ayxw5-11-07-2016_11-52-55_inline.jpg?1468230825">
#DemoEnvironment

Hi, This mean that the connexion betweeb the engine and database isn't workink. Check your listener is up our the you have a jdbc connector configured at the delphix env. Regards, Mouhssine

Mh...it seems that in linuxsource OVA oracle is not installed at all. I'm not an expert of Oracle on Linux but script don't work failing on lsnrctl "file not found" error. Running oracle.landshark script on /home/delphix it report me that installations files are missing.
Anyway, at this point I've not understood the lab environment. I was able to provision XE db to target and to have the choice to add/remove users using http://linuxtarget:1080 app portal. 

Giacomo, 

On the linuxsource, as the delphix user:

source ~/XE.env
lsnrctl status

Hi Adam,
below is the output. What I would do is to modify source to see the effects after a refresh on VDB. I was able to simulate several case with two targets, one for dev and the other for qa, creating a template with two users. Good.
Then I've tried to access, as from manual to  linuxsource:1080, but I've got the image attached, then I saw that blue icon. I'm able to provision new vdb but there's no access to the source db; I don't remember but that icon was not present after first setup of landshark.


login as: delphix
delphix@ls's password:
Last login: Mon Jul 11 12:34:32 2016 from 192.168.174.1

[delphix@linuxsource ~]$
[delphix@linuxsource ~]$
[delphix@linuxsource ~]$
[delphix@linuxsource ~]$ source ~/XE.env
[delphix@linuxsource ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 11-JUL-2016 16:21:09

Copyright (c) 1991, 2011, 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.2.0 - Production
Start Date                11-JUL-2016 12:17:35
Uptime                    0 days 4 hr. 3 min. 36 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/diag/tnslsnr/linuxsource/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linuxsource)(PORT=1521)))
The listener supports no services
The command completed successfully
 

Hi, Can get the output of this command please on the source env. ps -ef | grep smon Regards, Mouhssine

[delphix@linuxsource ~]$ ps -ef | grep smon
delphix  10231 10213  0 16:42 pts/0    00:00:00 grep smon

The XE database should be running on start. Have you tried rebooting the Linuxsource?

You can also su - and run service oracle-xe restart

Here the listener alert.xlm

<msg time='2016-07-11T16:21:09.133+02:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>WARNING: Subscription for node down event still pending
 </txt>
</msg>
<msg time='2016-07-11T16:21:09.133+02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>11-JUL-2016 16:21:09 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=linuxsource.delphix.priv)(USER=delphix))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647040)) * status * 0
 </txt>
</msg>
<msg time='2016-07-11T16:21:40.290+02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>11-JUL-2016 16:21:40 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=delphix))(SERVICE_NAME=XEXE)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=delphix))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50081)) * establish * XEXE * 12514
 </txt>
</msg>
<msg time='2016-07-11T16:21:40.290+02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
 </txt>
</msg>
<msg time='2016-07-11T16:21:40.290+02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>11-JUL-2016 16:21:40 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=delphix))(SERVICE_NAME=XEXE)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=delphix))) * (ADDRESS=(PROTOCOL=tcp)(HOST=::1)(PORT=51860)) * establish * XEXE * 12514
 </txt>
</msg>
<msg time='2016-07-11T16:21:40.291+02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
 </txt>
</msg>
<msg time='2016-07-11T16:26:36.982+02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>11-JUL-2016 16:26:36 * 12502
 </txt>
</msg>
<msg time='2016-07-11T16:26:36.983+02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>TNS-12502: TNS:listener received no CONNECT_DATA from client
 </txt>
</msg>
<msg time='2016-07-11T16:26:36.983+02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>11-JUL-2016 16:26:36 * 12502
 </txt>
</msg>
<msg time='2016-07-11T16:26:36.983+02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>TNS-12502: TNS:listener received no CONNECT_DATA from client
 </txt>
</msg>
<msg time='2016-07-11T16:26:36.985+02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>11-JUL-2016 16:26:36 * 12502
 </txt>
</msg>
<msg time='2016-07-11T16:26:36.985+02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>TNS-12502: TNS:listener received no CONNECT_DATA from client
 </txt>
</msg>
<msg time='2016-07-11T16:26:37.103+02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>11-JUL-2016 16:26:37 * 12502
 </txt>
</msg>
<msg time='2016-07-11T16:26:37.103+02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>TNS-12502: TNS:listener received no CONNECT_DATA from client
 </txt>
</msg>
<msg time='2016-07-11T16:26:41.770+02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>11-JUL-2016 16:26:41 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=delphix))(SERVICE_NAME=XEXE)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=delphix))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50205)) * establish * XEXE * 12514
 </txt>
</msg>
<msg time='2016-07-11T16:26:41.770+02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
 </txt>
</msg>
<msg time='2016-07-11T16:26:41.771+02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>11-JUL-2016 16:26:41 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=delphix))(SERVICE_NAME=XEXE)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=delphix))) * (ADDRESS=(PROTOCOL=tcp)(HOST=::1)(PORT=51984)) * establish * XEXE * 12514
 </txt>
</msg>
<msg time='2016-07-11T16:26:41.771+02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
 </txt>
</msg>
<msg time='2016-07-11T16:38:12.456+02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>WARNING: Subscription for node down event still pending
 </txt>
</msg>
<msg time='2016-07-11T16:38:12.456+02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>11-JUL-2016 16:38:12 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=linuxsource.delphix.priv)(USER=root))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647040)) * status * 0
 </txt>
</msg>
<msg time='2016-07-11T16:39:05.157+02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>WARNING: Subscription for node down event still pending
 </txt>
</msg>
<msg time='2016-07-11T16:39:05.157+02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>11-JUL-2016 16:39:05 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=linuxsource.delphix.priv)(USER=delphix))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647040)) * status * 0
 </txt>
</msg>
<msg time='2016-07-11T16:41:52.064+02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>WARNING: Subscription for node down event still pending
 </txt>
</msg>
<msg time='2016-07-11T16:41:52.064+02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='linuxsource.delphix.priv'
 host_addr='192.168.174.128'>
 <txt>11-JUL-2016 16:41:52 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=linuxsource.delphix.priv)(USER=delphix))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647040)) * status * 0
 </txt>
</msg>

There's a chance that if you suspend/resume your VM that the oracle xe process may die. If that happens, just reboot the linuxsource or su - and run service oracle-xe restart

Hi, Right you should have your db up, just try Adam's plan. If it doesn't come up you have some throuble with the startup script, you can still start things manually this way. Connect as oracle user to source server. source ~/XE.env sqlplus as sysdba <

First thing I did...a reboot I mean, of all envs. I've tied also to restart. No luck.
Btw, using VMware workstation on my laptot I expect that I can suspend VMs, and this what I normally do.

Hi Giacocmo, Please test my plan as it allows you to start things manually. Regards, Mouhssine

Hi,

run all block between double-quots as one command

"sqlplus as sysdba <

Mouhssine

Uh...seems I've solved. Now the listener is linked to XEXE db.
Attempt to have data on linuxsource:1080 was successful.
First, some google search to understand how to log as sysdba.,.. :-)
My suspects reading the log was confirmed. The host name was changed from linuxsource.delphix.local to linuxsource.delphix.priv ...and this stopped the listener.

I've added also the old name to the hosts file and then executed the startup as sysdba

Now as delphix I can read:
[delphix@linuxsource ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 11-JUL-2016 17:06:18

Copyright (c) 1991, 2011, 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.2.0 - Production
Start Date                11-JUL-2016 16:47:51
Uptime                    0 days 0 hr. 18 min. 26 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/diag/tnslsnr/linuxsource/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linuxsource)(PORT=1521)))
Services Summary...
Service "XEXDB" has 1 instance(s).
  Instance "XEXE", status READY, has 1 handler(s) for this service...
Service "XEXE" has 1 instance(s).
  Instance "XEXE", status READY, has 1 handler(s) for this service...
The command completed successfully

I've got it in another way, Just for info.
I've run sqlplus, at the user name prompt I put 'sys as sysdba', no password, the the SQL> prompt appeared.

Hi, Great stuff Regards, Mouhssine

In your log, I see delphix.priv Did you change your dns/hostname information?

I posted the below before I saw this. Glad you got it sorted.

Yeah..shame on me. :-)
I've just reported that I've discovered that! My Oracle knowledge is so old! I though that new version of listener was a little bit more intelligent reading at hosts file ;-)

Please don't laugh..I've got another issue...I've erroneusly unlinked the XE db in the linuxsource...
I'm trying to follow instruction but I have no idea of user credentials to be use...

database credentials are delphixdb/delphixdb or sys/delphixdb

the os credentials are delphix/delphix

I'll try, 
But in mean time I'm going crazy,
I've changed hosts, resolv and hostname command with the old name (linuxsource.delphix,local) but what the os restarts I've the delphix.priv name...
and listener doesn't start!

Is there some script that delphix engine run using old name?
Is there a way to change the name looked for the listeter?

Damned linux...services that use their own names instead to use the one linked to the os...

what about /etc/sysconfig/network?

[root@linuxsource ~]# cat /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=linuxsource.delphix.local

Forgot it! :-/ An half dozens of files...
I remember another useful file, listener.ora, containing the name...It does not seem there's one somewhere, the only I found is a commented one....

There isn't one for XE. The listener is started without a config file. You can see this in the /etc/init.d/oracle-xe file