Trouble setting up Delphix database user

  • 0
  • 1
  • Problem
  • Updated 3 years ago
  • Solved
Hi,

I'm trying to setup Landshark as a sandbox using the sample provided on a memory stick in the training summit.  I'm trying to add the built-in Oracle database for my source and connect to it.  In the environments view, I find the proper database.  When trying to authenticate to it given the user/pass combo "delphixdb/delphixdb," I get an error that the user does not exist.

Upon further probing, I found a createDelphixDBUser.sql script and from the User guide a createDelphixDBUser.sh script. Running the script, I get the following:


[delphix@delphix-source ~]$ ./createDelphixDBUser.sh

This script will create the Delphix database user

Database User will be created in instance <XEXE>
If you would like to create the DB user in a different Database Instance,
please enter the desired SID or press <Enter> to proceed.
XEXE
select 'Version=' || version from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
Unable to get database version from database instance <XEXE>.


Is this saying the server is not up?  I'm confused how to resolve this. When doing a lsnrctl, I get the following:

[delphix@delphix-source scripts]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 02-DEC-2015 14:57:17

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                01-DEC-2015 14:15:59
Uptime                    1 days 0 hr. 41 min. 18 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/diag/tnslsnr/delphix-source/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=delphix-source)(PORT=1521)))
The listener supports no services
The command completed successfully


Which shows that its running, correct?  I'm confused as to how to resolve this.  Any help would be appreciated!


Thanks,
Scott
Photo of John Scott Diorio

John Scott Diorio

  • 140 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
Official Response
Hey Scott. First, I see that you changed the name of your linux VM. That is going to create some problems. You should change it back to linuxsource and reboot. If you have changed the target, also change that back to linuxtarget, and reboot. Did you follow this quickstart guide? 

https://docs.delphix.com/display/LS22/Quick+Start+Guide+for+the+Delphix+Landshark+Environment