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