Delphix Products

Expand all | Collapse all

What does this icon mean?

Jump to Best Answer

Mouhssine SAIDI07-11-2016 02:25:00 PM

  • 1.  What does this icon mean?

    Posted 07-11-2016 08:56:00 AM
    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


  • 2.  RE: What does this icon mean?

    Posted 07-11-2016 09:08:00 AM
    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


  • 3.  RE: What does this icon mean?

    Posted 07-11-2016 09:46:00 AM
    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. 


  • 4.  RE: What does this icon mean?

    Posted 07-11-2016 01:14:00 PM
    Giacomo, 

    On the linuxsource, as the delphix user:

    source ~/XE.env
    lsnrctl status



  • 5.  RE: What does this icon mean?

    Posted 07-11-2016 01:26:00 PM
    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
     


  • 6.  RE: What does this icon mean?

    Posted 07-11-2016 01:36:00 PM
    Hi, Can get the output of this command please on the source env. ps -ef | grep smon Regards, Mouhssine


  • 7.  RE: What does this icon mean?

    Posted 07-11-2016 01:43:00 PM
    [delphix@linuxsource ~]$ ps -ef | grep smon
    delphix  10231 10213  0 16:42 pts/0    00:00:00 grep smon




  • 8.  RE: What does this icon mean?

    Posted 07-11-2016 01:44:00 PM
    The XE database should be running on start. Have you tried rebooting the Linuxsource?

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



  • 9.  RE: What does this icon mean?

    Posted 07-11-2016 01:46:00 PM
    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>




  • 10.  RE: What does this icon mean?

    Posted 07-11-2016 01:46:00 PM
    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


  • 11.  RE: What does this icon mean?

    Posted 07-11-2016 01:48:00 PM
    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 <


  • 12.  RE: What does this icon mean?

    Posted 07-11-2016 01:49:00 PM
    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.


  • 13.  RE: What does this icon mean?

    Posted 07-11-2016 01:54:00 PM
    Hi Giacocmo, Please test my plan as it allows you to start things manually. Regards, Mouhssine


  • 14.  RE: What does this icon mean?

    Posted 07-11-2016 02:09:00 PM
    Hi,

    run all block between double-quots as one command

    "sqlplus as sysdba <

    Mouhssine


  • 15.  RE: What does this icon mean?

    Posted 07-11-2016 02:23:00 PM
    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





  • 16.  RE: What does this icon mean?

    Posted 07-11-2016 02:24:00 PM
    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.


  • 17.  RE: What does this icon mean?

    Posted 07-11-2016 02:25:00 PM
    Hi, Great stuff Regards, Mouhssine


  • 18.  RE: What does this icon mean?

    Posted 07-11-2016 02:28:00 PM
    In your log, I see delphix.priv Did you change your dns/hostname information?


  • 19.  RE: What does this icon mean?

    Posted 07-11-2016 02:32:00 PM
    I posted the below before I saw this. Glad you got it sorted.


  • 20.  RE: What does this icon mean?

    Posted 07-11-2016 02:33:00 PM
    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 ;-)



  • 21.  RE: What does this icon mean?

    Posted 07-11-2016 02:45:00 PM
    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...


  • 22.  RE: What does this icon mean?

    Posted 07-11-2016 02:57:00 PM
    database credentials are delphixdb/delphixdb or sys/delphixdb

    the os credentials are delphix/delphix


  • 23.  RE: What does this icon mean?

    Posted 07-11-2016 03:04:00 PM
    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...



  • 24.  RE: What does this icon mean?
    Best Answer

    Posted 07-11-2016 03:08:00 PM
    what about /etc/sysconfig/network?

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


  • 25.  RE: What does this icon mean?

    Posted 07-11-2016 03:11:00 PM
    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....


  • 26.  RE: What does this icon mean?

    Posted 07-11-2016 03:22:00 PM
    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