Delphix Products

After creating vdb, how can i reset db password of user  automatically ?

#DemoEnvironment
#Masking

You can run a post hook script after provisioning VDB where you can change the password.

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

Hi, The hooks should be run at "config clone, post refresh" events. Sample : #!/bin/sh $ORACLE_HOME/bin/sqlplus / as sysdba <

This did not work. Delphix suggested to have a shell script at target os.  I did same and script was not called.


thanks
Ramji

Hi, Can you upload a screen of your hooks. Regards, Mouhssine

Please set Oracle_HOME and ORACLE_SID in your script. In order to access sqlplus you need to set the environment correct. 

That is also set.  for some reason script is not trigged after post refresh.

thanks
Ramji

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

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