Not able to connect Landshark Source DB(XEXE) from Delphix Express

  • 0
  • 1
  • Problem
  • Updated 2 years ago
  • Solved
Dear Support Team,

I have been facing the source database connection in my landshark environment. earlier i was able able to do all the operation in delphix express. I am able to see all the environment and dSource in GUI. Can you please help me how to add valid User credentials and fix this issue. i have tried with delphix express console to set the credentials but its giving error. Please help me on this.

Regards,
Jitendra
Photo of Jitendra Kumar

Jitendra Kumar

  • 252 Points 250 badge 2x thumb
  • frustrated

Posted 2 years ago

  • 0
  • 1
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,420 Points 10k badge 2x thumb
Can you please provide screenshots of the issue you are experiencing?
Photo of Jitendra Kumar

Jitendra Kumar

  • 252 Points 250 badge 2x thumb
Please look into the attachment.
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,420 Points 10k badge 2x thumb
Ok. I see the issue. Log in to the Linuxsource as the delphix user and at the command prompt, type the following (in italics)
  1. export ORACLE_SID=XEXE
  2. sqlplus / as sysdba
  3. ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
  4. ALTER USER delphixdb IDENTIFIED BY delphixdb;
  5. quit
  6. exit
Now link your dsource with the 'delphixdb' username and 'delphixdb' password.
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,420 Points 10k badge 2x thumb
type this command:

ls -la ~
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,420 Points 10k badge 2x thumb
Show me a screenshot of that.
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,420 Points 10k badge 2x thumb
Ok. Thanks. Revised instructions:

 Log in to the Linuxsource as the delphix user and at the command prompt, type the following (in italics)
  1. source ~/XE.env
  2. sqlplus / as sysdba
  3. ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
  4. ALTER USER delphixdb IDENTIFIED BY delphixdb;
  5. quit
  6. exit
Photo of Jitendra Kumar

Jitendra Kumar

  • 252 Points 250 badge 2x thumb
Thank you so much Adam for the quick support.