Delphix Products

 View Only
  • 1.  reset password after vdb creation

    Posted 06-08-2016 06:55:00 PM
    After creating vdb, how can i reset db password of user  automatically ?

    #DemoEnvironment
    #Masking


  • 2.  RE: reset password after vdb creation

    Posted 06-08-2016 07:02:00 PM
    You can run a post hook script after provisioning VDB where you can change the password.


  • 3.  RE: reset password after vdb creation

    Posted 06-08-2016 07:25:00 PM
    any sample please. I did write post hook up script. it did not work. there is no log to check where it went wrong.

    Thanks
    Ramji


  • 4.  RE: reset password after vdb creation

    Posted 06-08-2016 08:54:00 PM
    Hi, The hooks should be run at "config clone, post refresh" events. Sample : #!/bin/sh $ORACLE_HOME/bin/sqlplus / as sysdba <


  • 5.  RE: reset password after vdb creation

    Posted 06-09-2016 12:41:00 PM
    This did not work. Delphix suggested to have a shell script at target os.  I did same and script was not called.


    thanks
    Ramji


  • 6.  RE: reset password after vdb creation

    Posted 06-09-2016 01:10:00 PM
    Hi, Can you upload a screen of your hooks. Regards, Mouhssine


  • 7.  RE: reset password after vdb creation

    Posted 06-09-2016 01:58:00 PM



  • 8.  RE: reset password after vdb creation

    Posted 06-09-2016 03:51:00 PM
    Please set Oracle_HOME and ORACLE_SID in your script. In order to access sqlplus you need to set the environment correct. 


  • 9.  RE: reset password after vdb creation

    Posted 06-09-2016 04:34:00 PM
    That is also set.  for some reason script is not trigged after post refresh.

    thanks
    Ramji


  • 10.  RE: reset password after vdb creation
    Best Answer

    Posted 06-09-2016 04:45:00 PM
    Is it first time you are provisioning this VDB ? If so you need to keep the scripts path under Configure Clone tab. Please have a look at the hook operations options https://docs.delphix.com/display/DOCS50/_hook+operations


  • 11.  RE: reset password after vdb creation

    Posted 06-10-2016 04:44:00 AM
    Hi, Can you try please this plan. Modify the content of you hooks to be : echo "Invoked refresh hooks by vdb" >> /tmp/hooks Trigger a refresh on your vdb Check out if the file was created at /tmp directory of the target server. Regards, Mouhssine