Delphix Products

Expand all | Collapse all

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

Jump to Best Answer

Jitendra Kumar02-23-2017 04:59:00 AM

Jitendra Kumar02-23-2017 11:27:00 AM

Adam Bowen02-23-2017 11:28:00 AM

Adam Bowen02-23-2017 11:28:00 AM

Jitendra Kumar02-23-2017 11:37:00 AM

Jitendra Kumar02-23-2017 11:45:00 AMBest Answer

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

    Posted 02-22-2017 10:18:00 AM
    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



    #DemoEnvironment


  • 2.  RE: Not able to connect Landshark Source DB(XEXE) from Delphix Express

    Posted 02-22-2017 10:34:00 AM
    Can you please provide screenshots of the issue you are experiencing?


  • 3.  RE: Not able to connect Landshark Source DB(XEXE) from Delphix Express

    Posted 02-23-2017 04:59:00 AM
    Please">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1556193/RackMultipart20170223-110267-hlmbo7-Delphix_Error_inline.PNG?1487829490">Please look into the attachment.


  • 4.  RE: Not able to connect Landshark Source DB(XEXE) from Delphix Express

    Posted 02-23-2017 08:29:00 AM
    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.


  • 5.  RE: Not able to connect Landshark Source DB(XEXE) from Delphix Express

    Posted 02-23-2017 11:27:00 AM
    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1556311/RackMultipart20170223-4872-u85jnc-Source-DB-Error_inline.PNG?1487852799">


  • 6.  RE: Not able to connect Landshark Source DB(XEXE) from Delphix Express

    Posted 02-23-2017 11:28:00 AM
    type this command:

    ls -la ~


  • 7.  RE: Not able to connect Landshark Source DB(XEXE) from Delphix Express

    Posted 02-23-2017 11:28:00 AM
    Show me a screenshot of that.


  • 8.  RE: Not able to connect Landshark Source DB(XEXE) from Delphix Express

    Posted 02-23-2017 11:37:00 AM
    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1556313/RackMultipart20170223-10115-1ia3u3u-ls_list_inline.PNG?1487853435">


  • 9.  RE: Not able to connect Landshark Source DB(XEXE) from Delphix Express
    Best Answer

    Posted 02-23-2017 11:40:00 AM
    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


  • 10.  RE: Not able to connect Landshark Source DB(XEXE) from Delphix Express
    Best Answer

    Posted 02-23-2017 11:45:00 AM
    Thank you so much Adam for the quick support.