What does this icon mean?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
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?
Photo of Giacomo Milazzo

Giacomo Milazzo

  • 284 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Mouhssine SAIDI

Mouhssine SAIDI

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

Giacomo Milazzo

  • 284 Points 250 badge 2x thumb
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. 
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
Giacomo, 

On the linuxsource, as the delphix user:

source ~/XE.env
lsnrctl status
Photo of Giacomo Milazzo

Giacomo Milazzo

  • 284 Points 250 badge 2x thumb
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
 
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,632 Points 4k badge 2x thumb
Hi,

Can get the output of this command please on the source env.

ps -ef | grep smon

Regards,

Mouhssine
Photo of Giacomo Milazzo

Giacomo Milazzo

  • 284 Points 250 badge 2x thumb
[delphix@linuxsource ~]$ ps -ef | grep smon
delphix  10231 10213  0 16:42 pts/0    00:00:00 grep smon
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
The XE database should be running on start. Have you tried rebooting the Linuxsource?

You can also su - and run service oracle-xe restart
Photo of Giacomo Milazzo

Giacomo Milazzo

  • 284 Points 250 badge 2x thumb
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>
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
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
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,632 Points 4k badge 2x thumb
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 <<EOF
startup
EOF

Regards,

Mouhssine
Photo of Giacomo Milazzo

Giacomo Milazzo

  • 284 Points 250 badge 2x thumb
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.
(Edited)
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,632 Points 4k badge 2x thumb
Hi Giacocmo,

Please test my plan as it allows you to start things manually.

Regards,

Mouhssine
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,632 Points 4k badge 2x thumb
Hi,


run all block between double-quots as one command


"sqlplus as sysdba <

Mouhssine
(Edited)
Photo of Giacomo Milazzo

Giacomo Milazzo

  • 284 Points 250 badge 2x thumb
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.
Photo of Giacomo Milazzo

Giacomo Milazzo

  • 284 Points 250 badge 2x thumb
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
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
I posted the below before I saw this. Glad you got it sorted.
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,632 Points 4k badge 2x thumb
Hi,

Great stuff

Regards,

Mouhssine
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
In your log, I see delphix.priv Did you change your dns/hostname information?
Photo of Giacomo Milazzo

Giacomo Milazzo

  • 284 Points 250 badge 2x thumb
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 ;-)
Photo of Giacomo Milazzo

Giacomo Milazzo

  • 284 Points 250 badge 2x thumb
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...
(Edited)
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
database credentials are delphixdb/delphixdb or sys/delphixdb

the os credentials are delphix/delphix
Photo of Giacomo Milazzo

Giacomo Milazzo

  • 284 Points 250 badge 2x thumb
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...
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
what about /etc/sysconfig/network?

[root@linuxsource ~]# cat /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=linuxsource.delphix.local
(Edited)
Photo of Giacomo Milazzo

Giacomo Milazzo

  • 284 Points 250 badge 2x thumb
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....
(Edited)
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
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