http://m.getsatisfaction.com/companies/delphix/topics?page=1 Topics in Delphix Community 1970-01-01T00:00:00Z 1330 817 39 188 0 238 http://m.getsatisfaction.com/topics/7843327 7843327 Segment mapping Special Character Handling 2019-01-19T09:03:26Z 2019-01-18T16:37:54Z madhu http://m.getsatisfaction.com/people/9919891 https://www.gravatar.com/avatar/fec406082bc409e8bbe2f6115c753532?d=identicon&s=55&r=PG madhu_44cy7i2bi7lkb Hi there, I understand that the input character set for Segment mapping Algorithm is&nbsp;US-ASCII 7 bit&nbsp;Alphabetic characters (letters and&nbsp;numbers). Which includes !@%^ etc. Why does the masking fail when special characters are encountered? Also I am trying to ignore the&nbsp;1⁄2 in one of the columns, which is not from the above character set, is there any way of doing this? I am using ALPA-NUM segment mapping. question 3 3 1 comment http://m.getsatisfaction.com/topics/7843334 7843334 Masking Fails encountering a leading space 2019-01-18T16:48:23Z 2019-01-18T16:48:23Z madhu http://m.getsatisfaction.com/people/9919891 https://www.gravatar.com/avatar/fec406082bc409e8bbe2f6115c753532?d=identicon&s=55&r=PG madhu_44cy7i2bi7lkb Hi there,<br alt="" name="" rel="" target="" title="" type="" value="" />I am trying to mask lets say the post code column, while preserving the first two Chars. I am using Alpha-num segment mapping but it appears the masking fails when there is a leading space, I do have a work around to trim the leading space, but trying to understand why it would fail anyways. I do not want to Ltrim the data as cleansing of data is unacceptable.<br alt="" name="" rel="" target="" title="" type="" value="" />so <br />"SW121 AT"&nbsp; &gt;&nbsp; "SW454 GF"<br alt="" name="" rel="" target="" title="" type="" value="" />" SW121 AT" &gt;&nbsp; " SG454 GF"<br alt="" name="" rel="" target="" title="" type="" value="" /> question 0 1 1 create http://m.getsatisfaction.com/topics/7842997 7842997 Oracle 12c Home Provisioning 2019-01-17T21:41:34Z 2019-01-17T21:41:34Z Carlos Cuellar http://m.getsatisfaction.com/people/9890776 https://www.gravatar.com/avatar/19f5cedcc4b6ea7ab1e74d484ac15539?d=identicon&s=55&r=PG carlos_cuellar_imrh9ktkrldmr <p alt="" name="" rel="" target="" title="" type="" value="">&nbsp;This is a follow up for article <a alt="" href="https://community.delphix.com/delphix/topics/delphix-oracle-home-provisioning-overview" name="" rel="nofollow" target="" title="" type="" value="">https://community.delphix.com/delphix/topics/delphix-oracle-home-provisioning-overview</a><br alt="" name="" rel="" target="" title="" type="" value="" />where it’s explained in detail how Delphix has various capabilities of provisioning Databases including Application binaries. There is tested that Oracle Homes can also be provisioned in a similar manner to VDB’s.</p> <p alt="" name="" rel="" target="" title="" type="" value="">&nbsp;</p> <p alt="" name="" rel="" target="" title="" type="" value="">But <b alt="" name="" rel="" target="" title="" type="" value="">Oracle 11g Binaries</b> were used in previous article and we wanted to test with hat <b alt="" name="" rel="" target="" title="" type="" value="">Oracle 12c Binaries</b> too to show a customer of this capability.</p> <p alt="" name="" rel="" target="" title="" type="" value="">&nbsp;</p> <p alt="" name="" rel="" target="" title="" type="" value="">Here we will walk through the entire process in a Single node with standalone configuration.</p> <p alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /> <a alt="" name="_Toc303001993" rel="nofollow" target="" title="" type="" value="">Oracle Home Provision</a></p> <p alt="" name="" rel="" target="" title="" type="" value="">As in the previous note, in order to provision Oracle Home, you have to make sure that Source and Target Environments have same physical characteristics, with respect to OS Version, make and model. Also, Provisioning Mount Point on the Target should&nbsp;<u alt="" name="" rel="" target="" title="" type="" value="">not</u>&nbsp;be a Symbolic Link.</p> <p alt="" name="" rel="" target="" title="" type="" value="">There are 2 prerequisites for this process to work:</p> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">1. -</b> Oracle RDBMS owner needs to be added in both source and target environments:</p><p alt="" name="" rel="" target="" title="" type="" value=""><img alt="" name="" rel="" src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1772527/RackMultipart20190117-17328-1h1nmi5-BinariesProv1_inline.png?1547760083" target="" title="Image httpsd2r1vs3d9006apcloudfrontnets3_images1772527RackMultipart20190117-17328-1h1nmi5-BinariesProv1_inlinepng1547760083" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /></p> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">2. -</b>&nbsp; You need to make sure that Oracle has privileges to write to&nbsp; Delphix user OS home.</p> <p alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value="">Here you have the steps below describe the process of Oracle RDBMS 12c Home Virtualization and Provisioning:</p> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">1.&nbsp;&nbsp;&nbsp;&nbsp;</b> Login to Delphix GUI as delphix_admin (or admin user when installing &nbsp;5.3.0 version or newer) user.</p> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">2.&nbsp;&nbsp;&nbsp;&nbsp;</b> Go to&nbsp;<b alt="" name="" rel="" target="" title="" type="" value="">Manage-&gt; Environments</b></p> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">3.&nbsp;&nbsp;&nbsp;&nbsp; </b>Select the Source Environment, which will be used for Oracle Home provisioning.</p> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">4.&nbsp;&nbsp;&nbsp;&nbsp;</b> In the Source Environment Page, click on&nbsp;<b alt="" name="" rel="" target="" title="" type="" value="">Databases</b>&nbsp;on the right side top of the screen.</p> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">5.&nbsp;&nbsp;&nbsp;&nbsp;</b> Select the Dataset Home Type as&nbsp;<b alt="" name="" rel="" target="" title="" type="" value="">Unstructured Files</b>&nbsp;and enter the correct path of Oracle Home that will be used for Oracle Home provisioning (Make sure to select Oracle RDBMS binaries owner as user to run this process):</p> <p alt="" name="" rel="" target="" title="" type="" value=""><img alt="" name="" rel="" src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1772529/RackMultipart20190117-48044-qu2jt5-BinariesProv2_inline.png?1547760223" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /></p> <br alt="" name="" rel="" target="" title="" type="" value="" /><p alt="" name="" rel="" target="" title="" type="" value="">Once done, this will create a new Source of Unstructured Files in the Source Environment:</p> <img alt="" name="" rel="" src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1772531/RackMultipart20190117-77774-1sukm9-BinariesProv3_inline.png?1547760587" target="" title="Image httpsd2r1vs3d9006apcloudfrontnets3_images1772531RackMultipart20190117-77774-1sukm9-BinariesProv3_inlinepng1547760587" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">6.&nbsp;&nbsp;&nbsp;&nbsp;</b> Go to&nbsp;<b alt="" name="" rel="" target="" title="" type="" value="">Manage -&gt; Databases -&gt; Add dSource</b>&nbsp;to add the Oracle binaries home as a dSource.</p> <p alt="" name="" rel="" target="" title="" type="" value="">Under&nbsp;<b alt="" name="" rel="" target="" title="" type="" value="">Advanced&gt;&gt;</b>&nbsp;option, you can include all the paths to be excluded in the dSource.</p> <img alt="" name="" rel="" src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1772532/RackMultipart20190117-20749-28vbag-BinariesProv4_inline.png?1547760630" target="" title="Image httpsd2r1vs3d9006apcloudfrontnets3_images1772532RackMultipart20190117-20749-28vbag-BinariesProv4_inlinepng1547760630" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /> <p alt="" name="" rel="" target="" title="" type="" value="">Executable owned by root cannot be provisioned. Delphix recommends to exclude&nbsp;<b alt="" name="" rel="" target="" title="" type="" value=""><i alt="" name="" rel="" target="" title="" type="" value="">oradism</i></b><i alt="" name="" rel="" target="" title="" type="" value="">, <b alt="" name="" rel="" target="" title="" type="" value="">extjob</b>, <b alt="" name="" rel="" target="" title="" type="" value="">jssu</b> </i>under <b alt="" name="" rel="" target="" title="" type="" value="">$ORACLE_HOME/bin</b> and <b alt="" name="" rel="" target="" title="" type="" value=""><i alt="" name="" rel="" target="" title="" type="" value="">externaljob.ora</i></b> under <b alt="" name="" rel="" target="" title="" type="" value="">$ORACLE_HOME/rdbms/admin</b> . Log/Trace files under <b alt="" name="" rel="" target="" title="" type="" value="">$ORACLE_HOME/rdbms/log</b> and <b alt="" name="" rel="" target="" title="" type="" value="">$ORACLE_HOME/network/log </b>are also candidates for exclusion as they don’t consume unwanted space:</p> <img alt="" name="" rel="" src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1772533/RackMultipart20190117-128763-xb6hv1-BinariesProv5_inline.png?1547760668" target="" title="Image httpsd2r1vs3d9006apcloudfrontnets3_images1772533RackMultipart20190117-128763-xb6hv1-BinariesProv5_inlinepng1547760668" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">7.&nbsp;&nbsp;&nbsp;&nbsp;</b> In the Next Screen, give a name for this <b alt="" name="" rel="" target="" title="" type="" value="">dSource</b> and choose the <b alt="" name="" rel="" target="" title="" type="" value="">Target</b> <b alt="" name="" rel="" target="" title="" type="" value="">Group</b>:</p> <img alt="" name="" rel="" src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1772534/RackMultipart20190117-14686-he05lw-BinariesProv6_inline.png?1547760699" target="" title="Image httpsd2r1vs3d9006apcloudfrontnets3_images1772534RackMultipart20190117-14686-he05lw-BinariesProv6_inlinepng1547760699" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">8.&nbsp;&nbsp;&nbsp;&nbsp;</b> Moving forward on the wizard provisioning process, you can select Snapsync Policy and create Hooks depending on the requirements.</p> <img alt="" name="" rel="" src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1772535/RackMultipart20190117-61663-s5q7b4-BinariesProv7_inline.png?1547760753" target="" title="Image httpsd2r1vs3d9006apcloudfrontnets3_images1772535RackMultipart20190117-61663-s5q7b4-BinariesProv7_inlinepng1547760753" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">9.&nbsp;&nbsp;&nbsp;&nbsp;</b> Once done, a dSource of vFiles for Provisioning Oracle Home will be created. This dSource can be provisioned to Target as the new Oracle Home using regular VDB provisioning techniques. You can take Snapshots as appropriate. Patching activities would definitely be a Use Case where Snapshots are taken before and after the software upgrade and you can keep a binaries library where you can identify when patches are applied and maintain them in case they are required.</p><p alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value=""><img alt="" name="" rel="" src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1772536/RackMultipart20190117-4903-1ar2bek-BinariesProv8_inline.png?1547760796" target="" title="Image httpsd2r1vs3d9006apcloudfrontnets3_images1772536RackMultipart20190117-4903-1ar2bek-BinariesProv8_inlinepng1547760796" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">10.&nbsp;&nbsp; </b>To Provision Oracle Home, expand the dSource. Click on&nbsp;<b alt="" name="" rel="" target="" title="" type="" value="">Provision</b>&nbsp;in the main page. Select appropriate environment on the left side. Enter correct path for the&nbsp;<b alt="" name="" rel="" target="" title="" type="" value="">Mount Point </b>(Mount Point to be created in target and owned by Oracle RDBMS user). Make sure the path is&nbsp;<u alt="" name="" rel="" target="" title="" type="" value="">not</u>&nbsp;a&nbsp;<b alt="" name="" rel="" target="" title="" type="" value=""><i alt="" name="" rel="" target="" title="" type="" value="">Symbolic Link</i></b>. And make sure you select Oracle RDBMS user to run this process.<br alt="" name="" rel="" target="" title="" type="" value="" /></p> <p alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value=""><img alt="" name="" rel="" src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1772537/RackMultipart20190117-44100-17f65bx-BinariesProv9_inline.png?1547760856" target="" title="Image httpsd2r1vs3d9006apcloudfrontnets3_images1772537RackMultipart20190117-44100-17f65bx-BinariesProv9_inlinepng1547760856" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value=""><img alt="" name="" rel="" src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1772538/RackMultipart20190117-98742-1wo5v3n-BinariesProv10_inline.png?1547760864" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /></p> <p alt="" name="" rel="" target="" title="" type="" value="">&nbsp;</p> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">11.&nbsp;&nbsp; </b>In the Next Screen, provide proper name for&nbsp;<b alt="" name="" rel="" target="" title="" type="" value="">vFiles Name</b>. Choose correct <b alt="" name="" rel="" target="" title="" type="" value="">Target Group</b> and <b alt="" name="" rel="" target="" title="" type="" value="">Snapsync</b> Policy.</p> <p alt="" name="" rel="" target="" title="" type="" value=""><img alt="" name="" rel="" src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1772539/RackMultipart20190117-63634-5t0gz0-BinariesProv11_inline.png?1547760903" target="" title="Image httpsd2r1vs3d9006apcloudfrontnets3_images1772539RackMultipart20190117-63634-5t0gz0-BinariesProv11_inlinepng1547760903" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /></p> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">12.&nbsp;&nbsp;</b> In the Next Screen, add a&nbsp;<b alt="" name="" rel="" target="" title="" type="" value="">Configure Clone</b>&nbsp;Hook for&nbsp;<b alt="" name="" rel="" target="" title="" type="" value="">Run Shell Command</b>&nbsp;Type for attaching Oracle Home to the Central Inventory. We used as an example the <b alt="" name="" rel="" target="" title="" type="" value="">attachHome</b> script provided by Oracle located in <b alt="" name="" rel="" target="" title="" type="" value="">$ORACLE_HOME/oui/bin </b>which is as follows:</p> <p alt="" name="" rel="" target="" title="" type="" value="">#!/bin/sh</p> <p alt="" name="" rel="" target="" title="" type="" value="">OHOME=&lt;MOUNT-POINT-PATH-ENTERED-IN-STEP-10&gt;</p> <p alt="" name="" rel="" target="" title="" type="" value="">OHOMENAME=&lt;Name for Oracle Home in Inventory&gt;</p> <p alt="" name="" rel="" target="" title="" type="" value="">CUR_DIR=`pwd`</p> <p alt="" name="" rel="" target="" title="" type="" value="">cd $OHOME/oui/bin</p> <p alt="" name="" rel="" target="" title="" type="" value="">./runInstaller -detachhome ORACLE_HOME=$OHOME ORACLE_HOME_NAME=$OHOMENAME $* &gt; /dev/null 2&gt;&amp;1</p> <p alt="" name="" rel="" target="" title="" type="" value="">./runInstaller -attachhome ORACLE_HOME=$OHOME ORACLE_HOME_NAME=$OHOMENAME $*</p> <p alt="" name="" rel="" target="" title="" type="" value="">cd $CUR_DIR</p> <p alt="" name="" rel="" target="" title="" type="" value="">mkdir -p $OHOME/rdbms/log</p> <p alt="" name="" rel="" target="" title="" type="" value="">mkdir -p $OHOME/network/log</p> <p alt="" name="" rel="" target="" title="" type="" value="">&nbsp;</p> <p alt="" name="" rel="" target="" title="" type="" value=""><u alt="" name="" rel="" target="" title="" type="" value="">For Example:</u></p> <p alt="" name="" rel="" target="" title="" type="" value="">#!/bin/sh</p> <p alt="" name="" rel="" target="" title="" type="" value="">OHOME=/mnt/provision/oraclebinaries</p> <p alt="" name="" rel="" target="" title="" type="" value="">OHOMENAME=Ora12ctest</p> <p alt="" name="" rel="" target="" title="" type="" value="">CUR_DIR=`pwd`</p> <p alt="" name="" rel="" target="" title="" type="" value="">cd $OHOME/oui/bin</p> <p alt="" name="" rel="" target="" title="" type="" value="">./runInstaller -detachhome ORACLE_HOME=$OHOME ORACLE_HOME_NAME=$OHOMENAME $* &gt; /dev/null 2&gt;&amp;1</p> <p alt="" name="" rel="" target="" title="" type="" value="">./runInstaller -attachhome ORACLE_HOME=$OHOME ORACLE_HOME_NAME=$OHOMENAME $*</p> <p alt="" name="" rel="" target="" title="" type="" value="">cd $CUR_DIR</p> <p alt="" name="" rel="" target="" title="" type="" value="">mkdir -p $OHOME/rdbms/log</p> <p alt="" name="" rel="" target="" title="" type="" value="">mkdir -p $OHOME/network/log</p> <p alt="" name="" rel="" target="" title="" type="" value="">&nbsp;</p> <p alt="" name="" rel="" target="" title="" type="" value="">You can see that we are also creating back the <b alt="" name="" rel="" target="" title="" type="" value="">network/rdbms</b> and <b alt="" name="" rel="" target="" title="" type="" value="">network/log</b> folders because we excluded them from the ingestion process.</p> <p alt="" name="" rel="" target="" title="" type="" value="">Also add a <b alt="" name="" rel="" target="" title="" type="" value="">PreStop</b> hook to detach the Oracle home(that will be useful when deleting this vfiles dataset) as follows:</p> <p alt="" name="" rel="" target="" title="" type="" value="">#!/bin/sh</p> <p alt="" name="" rel="" target="" title="" type="" value="">OHOME=&lt;MOUNT-POINT-PATH-ENTERED-IN-STEP-10&gt;</p> <p alt="" name="" rel="" target="" title="" type="" value="">OHOMENAME=&lt;Name for Oracle Home in Inventory&gt;</p> <p alt="" name="" rel="" target="" title="" type="" value="">CUR_DIR=`pwd`</p> <p alt="" name="" rel="" target="" title="" type="" value="">cd $OHOME/oui/bin</p> <p alt="" name="" rel="" target="" title="" type="" value="">./runInstaller -detachhome ORACLE_HOME=$OHOME ORACLE_HOME_NAME=$OHOMENAME $*</p> <p alt="" name="" rel="" target="" title="" type="" value="">cd $CUR_DIR</p> <p alt="" name="" rel="" target="" title="" type="" value="">&nbsp;</p> <p alt="" name="" rel="" target="" title="" type="" value="">For example:</p> <p alt="" name="" rel="" target="" title="" type="" value="">#!/bin/sh</p> <p alt="" name="" rel="" target="" title="" type="" value="">OHOME=/mnt/provision/oraclebinaries</p> <p alt="" name="" rel="" target="" title="" type="" value="">OHOMENAME=Ora12ctest</p> <p alt="" name="" rel="" target="" title="" type="" value="">CUR_DIR=`pwd`</p> <p alt="" name="" rel="" target="" title="" type="" value="">cd $OHOME/oui/bin</p> <p alt="" name="" rel="" target="" title="" type="" value="">./runInstaller -detachhome ORACLE_HOME=$OHOME ORACLE_HOME_NAME=$OHOMENAME $*</p> <p alt="" name="" rel="" target="" title="" type="" value="">cd $CUR_DIR</p> <p alt="" name="" rel="" target="" title="" type="" value="">&nbsp;</p> <p alt="" name="" rel="" target="" title="" type="" value=""><img alt="" name="" rel="" src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1772540/RackMultipart20190117-77104-ubpysf-BinariesProv12_inline.png?1547760980" target="" title="Image httpsd2r1vs3d9006apcloudfrontnets3_images1772540RackMultipart20190117-77104-ubpysf-BinariesProv12_inlinepng1547760980" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value=""><img alt="" name="" rel="" src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1772541/RackMultipart20190117-122502-15fmzxv-BinariesProv13_inline.png?1547760988" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /></p> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">13.&nbsp;&nbsp; </b>Complete the provisioning process by clicking&nbsp;<b alt="" name="" rel="" target="" title="" type="" value="">Finish</b>.</p> <p alt="" name="" rel="" target="" title="" type="" value=""><img alt="" name="" rel="" src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1772543/RackMultipart20190117-34922-7geomd-BinariesProv14_inline.png?1547761039" target="" title="Image httpsd2r1vs3d9006apcloudfrontnets3_images1772543RackMultipart20190117-34922-7geomd-BinariesProv14_inlinepng1547761039" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value=""></p> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">14.&nbsp;&nbsp;</b> Once the provisioning process completes, Oracle Home will be made available on the Target Environment. One can also verify the Central Inventory Contents for Hook updates.</p> <p alt="" name="" rel="" target="" title="" type="" value="">·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Under the Mount Point directory used for Provisioning, check for <b alt="" name="" rel="" target="" title="" type="" value="">oraInst.loc</b> file.</p> <p alt="" name="" rel="" target="" title="" type="" value="">·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b alt="" name="" rel="" target="" title="" type="" value="">inventory_loc</b>&nbsp;would point to the Central Inventory Location.</p> <p alt="" name="" rel="" target="" title="" type="" value="">·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Go to <b alt="" name="" rel="" target="" title="" type="" value="">ContentsXML</b> directory under Central Inventory Location. Check inventory.xml file for relevant updates of the new provisioned Oracle Home.</p> <p alt="" name="" rel="" target="" title="" type="" value="">For the above Example, one would find the following entry (IDX may vary depending on number of Oracle Homes)</p> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">&lt;HOME NAME="Ora12ctest" LOC="</b> <b alt="" name="" rel="" target="" title="" type="" value="">/mnt/provision/oraclebinaries " TYPE="O" IDX="1"/&gt;</b></p> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">&nbsp;</b></p> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">&nbsp;</b></p> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">Example:</b></p> <p alt="" name="" rel="" target="" title="" type="" value=""><img alt="" name="" rel="" src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1772544/RackMultipart20190117-37333-1fgtx9v-BinariesProv15_inline.png?1547761091" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /></p> <p alt="" name="" rel="" target="" title="" type="" value="">Refresh the Environment to make sure that the Provisioned Home is now reflected in Delphix. Go to&nbsp;<b alt="" name="" rel="" target="" title="" type="" value="">Manage-&gt;Environments</b>&nbsp;and pick the right environment and click on the refresh icon:</p> <p alt="" name="" rel="" target="" title="" type="" value=""><img alt="" name="" rel="" src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1772545/RackMultipart20190117-98199-m47xd7-BinariesProv16_inline.png?1547761129" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /></p> <p alt="" name="" rel="" target="" title="" type="" value="">With this we have completed virtualizing Oracle 12c binaries. Now we can provision vDBs using the newly virtualized binaries.</p> <p alt="" name="" rel="" target="" title="" type="" value="">&nbsp;</p> <p alt="" name="" rel="" target="" title="" type="" value="">Here is one example when provisioning a vDB on the environment where the virtualized binaries have been provisioned previously:</p> <p alt="" name="" rel="" target="" title="" type="" value=""><img alt="" name="" rel="" src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1772546/RackMultipart20190117-5837-pzxnz9-BinariesProv17_inline.png?1547761168" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /></p> <p alt="" name="" rel="" target="" title="" type="" value="">After provisioning the new <b alt="" name="" rel="" target="" title="" type="" value="">vDB</b>, you can confirm the binaries used for it by selecting the <b alt="" name="" rel="" target="" title="" type="" value="">vDB</b>, going to <b alt="" name="" rel="" target="" title="" type="" value="">Configuration</b> tab and then on <b alt="" name="" rel="" target="" title="" type="" value="">Source</b> tab looking into <b alt="" name="" rel="" target="" title="" type="" value="">Repository</b> value:</p> <p alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value=""><img alt="" name="" rel="" src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1772547/RackMultipart20190117-72912-r5pq2w-BinariesProv18_inline.png?1547761196" target="" title="Image httpsd2r1vs3d9006apcloudfrontnets3_images1772547RackMultipart20190117-72912-r5pq2w-BinariesProv18_inlinepng1547761196" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /></p> <br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /> article 0 1 3 create http://m.getsatisfaction.com/topics/7841473 7841473 Login and Session cookie examples in Groovy 2019-01-14T19:54:42Z 2019-01-14T17:07:40Z Bradford Byrd http://m.getsatisfaction.com/people/9915160 https://www.gravatar.com/avatar/e4f769ea3831f701e9820f3934c1131d?d=identicon&s=55&r=PG bradford_byrd I'm trying to perform some rest commands against delphix from Jenkins pipelines. &nbsp;I have a groovy script trying to get a session, then login token. This is on a windows host. &nbsp;From the bash examples, it looks like its adding to a cookie with each curl call.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Here's the code:<br alt="" name="" rel="" target="" title="" type="" value="" /><pre alt="" name="" rel="" target="" title="" type="" value="">def delphix_url = "172&#46;31&#46;79&#46;14"def urlString = "<a alt="" href="http://${delphix_url}/resources/json/delphix&quot;" name="" rel="nofollow" target="" title="" type="" value="">http:&#47;&#47;${delphix_url}/resources/json/delphix"</a>;<br alt="" name="" rel="" target="" title="" type="" value="" />def login_params = "{\"type\"=\"LoginRequest\"\n"<br alt="" name="" rel="" target="" title="" type="" value="" />login_params += "\"username\"=\"delphix_admin\"\n"<br alt="" name="" rel="" target="" title="" type="" value="" />login_params += "\"password\"=\"delphix\"\n}"<br alt="" name="" rel="" target="" title="" type="" value="" />def api_params = "{\"type\": \"APISession\",\n"<br alt="" name="" rel="" target="" title="" type="" value="" />api_params += "\"version\": {\n"<br alt="" name="" rel="" target="" title="" type="" value="" />api_params += "\"type\": \"APIVersion\",\n"<br alt="" name="" rel="" target="" title="" type="" value="" />api_params += "\"major\": 1,\n"<br alt="" name="" rel="" target="" title="" type="" value="" />api_params += "\"minor\": 7,\n"<br alt="" name="" rel="" target="" title="" type="" value="" />api_params += "\"micro\": 0}\n"<br alt="" name="" rel="" target="" title="" type="" value="" />api_params += "}"<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />&#47;&#47; Do the Session<br alt="" name="" rel="" target="" title="" type="" value="" />separator()<br alt="" name="" rel="" target="" title="" type="" value="" />println "API Params"<br alt="" name="" rel="" target="" title="" type="" value="" />println api_params<br alt="" name="" rel="" target="" title="" type="" value="" />URLConnection con = "${urlString}/session"&#46;toURL()&#46;openConnection();<br alt="" name="" rel="" target="" title="" type="" value="" />con&#46;setDoOutput(true);<br alt="" name="" rel="" target="" title="" type="" value="" />con&#46;setDoInput(true);<br alt="" name="" rel="" target="" title="" type="" value="" />con&#46;setRequestProperty("Content-Type", "application/json");<br alt="" name="" rel="" target="" title="" type="" value="" />con&#46;outputStream&#46;withWriter { writer -&gt;<br alt="" name="" rel="" target="" title="" type="" value="" />&nbsp; writer &lt;&lt; api_params<br alt="" name="" rel="" target="" title="" type="" value="" />}<br alt="" name="" rel="" target="" title="" type="" value="" />def postRC = con&#46;getResponseCode()<br alt="" name="" rel="" target="" title="" type="" value="" />def cresp = con&#46;getHeaderField("Cookies")<br alt="" name="" rel="" target="" title="" type="" value="" />&#47;&#47;def response = con&#46;inputStream&#46;withReader { Reader reader -&gt; reader&#46;text }<br alt="" name="" rel="" target="" title="" type="" value="" />def response = con&#46;getInputStream()&#46;getText()<br alt="" name="" rel="" target="" title="" type="" value="" />println "URL: " + "${urlString}/session"<br alt="" name="" rel="" target="" title="" type="" value="" />println "Result: " + postRC<br alt="" name="" rel="" target="" title="" type="" value="" />println "Cookie: " + cresp<br alt="" name="" rel="" target="" title="" type="" value="" />println "Response: " + response<br alt="" name="" rel="" target="" title="" type="" value="" />def cookie = "user=mary17; domain=airtravelbargains&#46;com; path=/autos"<br alt="" name="" rel="" target="" title="" type="" value="" />&#47;&#47; Do the Login<br alt="" name="" rel="" target="" title="" type="" value="" />separator()<br alt="" name="" rel="" target="" title="" type="" value="" />println "Login Params"<br alt="" name="" rel="" target="" title="" type="" value="" />println login_params<br alt="" name="" rel="" target="" title="" type="" value="" />con = "${urlString}/login"&#46;toURL()&#46;openConnection();<br alt="" name="" rel="" target="" title="" type="" value="" />&#47;&#47;con&#46;setRequestProperty("Cookie", cookie)<br alt="" name="" rel="" target="" title="" type="" value="" />con&#46;setUseCaches(true)<br alt="" name="" rel="" target="" title="" type="" value="" />con&#46;setDoOutput(true);<br alt="" name="" rel="" target="" title="" type="" value="" />con&#46;setDoInput(true);<br alt="" name="" rel="" target="" title="" type="" value="" />con&#46;setRequestProperty("Content-Type", "application/json");<br alt="" name="" rel="" target="" title="" type="" value="" />con&#46;outputStream&#46;withWriter { writer -&gt;<br alt="" name="" rel="" target="" title="" type="" value="" />&nbsp; writer &lt;&lt; login_params<br alt="" name="" rel="" target="" title="" type="" value="" />}<br alt="" name="" rel="" target="" title="" type="" value="" />postRC = con&#46;getResponseCode()<br alt="" name="" rel="" target="" title="" type="" value="" />cresp = con&#46;getHeaderField("Cookies")<br alt="" name="" rel="" target="" title="" type="" value="" />&#47;&#47;def response = con&#46;inputStream&#46;withReader { Reader reader -&gt; reader&#46;text }<br alt="" name="" rel="" target="" title="" type="" value="" />response = con&#46;getInputStream()&#46;getText()<br alt="" name="" rel="" target="" title="" type="" value="" />println "URL: " + "${urlString}/login"<br alt="" name="" rel="" target="" title="" type="" value="" />println "Result: " + postRC<br alt="" name="" rel="" target="" title="" type="" value="" />println "Cookie: " + cresp<br alt="" name="" rel="" target="" title="" type="" value="" />println "Response: " + response<br alt="" name="" rel="" target="" title="" type="" value="" />println response</pre><br alt="" name="" rel="" target="" title="" type="" value="" />Here's the output. &nbsp;You can see, the cookie parameter is empty after getting a 200 on session.<br alt="" name="" rel="" target="" title="" type="" value="" /><pre alt="" name="" rel="" target="" title="" type="" value="">API Params {"type": "APISession", "version": { "type": "APIVersion", "major": 1, "minor": 7, "micro": 0} } URL: http:&#47;&#47;172&#46;31&#46;79&#46;14/resources/json/delphix/session Result: 200 Cookie: null Response: {"type":"OKResult","status":"OK","result":{"type":"APISession","version":{"type":"APIVersion","major":1,"minor":7,"micro":0},"locale":null,"client":null},"job":null,"action":null} #--------------------------------------------------------------------------------# Login Params {"type"="LoginRequest" "username"="delphix_admin" "password"="delphix" } URL: http:&#47;&#47;172&#46;31&#46;79&#46;14/resources/json/delphix/login Result: 200 Cookie: null Response: {"type":"ErrorResult","status":"ERROR","error":{"type":"APIError","details":"No API session has been established&#46;","action":"Create an API session by calling /resources/json/delphix/session&#46;","id":"exception&#46;webservices&#46;session&#46;nosession","commandOutput":null,"diagnoses":null}} {"type":"ErrorResult","status":"ERROR","error":{"type":"APIError","details":"No API session has been established&#46;","action":"Create an API session by calling /resources/json/delphix/session&#46;","id":"exception&#46;webservices&#46;session&#46;nosession","commandOutput":null,"diagnoses":null}}<br alt="" name="" rel="" target="" title="" type="" value="" /></pre> question complete 1 2 1 comment http://m.getsatisfaction.com/topics/7840468 7840468 Can we integrate our existing sensitive data discovery process with Delphix Masking? 2019-01-11T22:26:20Z 2019-01-11T22:20:53Z Robert Patten http://m.getsatisfaction.com/people/8928297 https://www.gravatar.com/avatar/0e2be7823043a6a3d2efb4491368a461?d=identicon&s=55&r=PG robert_patten Can we integrate our existing sensitive data discovery process with Delphix Masking? If we already know where our sensitive data is in our databases why should we use the Delphix profiler? question complete 1 1 1 create delphix profiler http://m.getsatisfaction.com/topics/7840323 7840323 SQL Server CDC (Change Data Capture) 2019-01-11T18:53:51Z 2019-01-11T18:30:16Z Alfredo Cerrillo http://m.getsatisfaction.com/people/9753516 https://www.gravatar.com/avatar/d734b9045b32ac9e74e361a44ded7636?d=identicon&s=55&r=PG alfredo_cerrillo SQL Sever has a functionality called Change Data Capture, wich allows to keep track of changes made to data (like an automatic log for every change).<br alt="" name="" rel="" target="" title="" type="" value="" />When a restore is performed, CDC data isn't restored by default, it is neccesary to add the KEEP_CDC parameter to the RESTORE command to include CDC bits <a alt="" href="https://devjef.wordpress.com/2014/11/18/restoring-or-moving-a-database-with-cdc-enabled/" name="" rel="nofollow" target="" title="" type="" value="">https://devjef.wordpress.com/2014/11/18/restoring-or-moving-a-database-with-cdc-enabled/</a>.<br alt="" name="" rel="" target="" title="" type="" value="" />There is a way to pass additional parameters to Delphix RESTORE process? question complete 3 2 1 comment http://m.getsatisfaction.com/topics/7839776 7839776 Diverse data sources? Not a Problem. We've got you covered. 2019-01-10T15:42:54Z 2019-01-10T15:42:54Z MichaelT http://m.getsatisfaction.com/people/9706172 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11297306/Torok_medium.png michael_torok Hello everyone!<br /><br />It's been an exciting start to the new year here at Delphix and we wanted to take a minute to share&nbsp;some exciting news with our community. <br /><br />We can now extend the same Delphix platform capabilities with which you are familiar&nbsp;to the data source of your choice, extending the security you know&nbsp;and use&nbsp;on a regular basis.&nbsp;<br /><br />Delphix supports a wide range of data sources, from MySQL, PostgreSQL, Amazon Web Services RDS, MongoDB to z/OS, in addition to Oracle, SQL Server, SAP ASE, IBM DB2, and SAP Hana. <br /><br />Be a single source of secure data for your environments. <br /><br />We would love to hear from you! If you are interested in knowing more, reach out to me using a private&nbsp;message or email,&nbsp;and I will get you in touch with our product team.<br />Of course, you can read more here, too:&nbsp;&nbsp;&nbsp;<br /><a href="https://www.delphix.com/data-sheet/data-source-integration" rel="nofollow" target="_blank" title="Link https//wwwdelphixcom/data-sheet/data-source-integration">https://www.delphix.com/data-sheet/data-source-integration</a><br /><br />Thank you!<br />Michael <br />...and the entire Delphix&nbsp;Team update 0 1 1 create amazon web services, ibm db2, oracle, product announcement, sap ase, sap hana, sql server, databases, datasources, mysql http://m.getsatisfaction.com/topics/7831741 7831741 Library issue with dxtoolkit2 version 2.3.7 and 2.38 - Dependent module /usr/lib/libcrypto.so could not be loaded. 2019-01-04T09:59:48Z 2018-12-19T23:35:36Z Ansamma Mathews http://m.getsatisfaction.com/people/9869150 https://www.gravatar.com/avatar/85253e7a1fcfab17b86d83caead17bb2?d=identicon&s=55&r=PG ansamma_mathews Hi,&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" />I am trying out automating VDB provisioining.&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" />I have engine version 5.1.9 and&nbsp; had&nbsp; Toolkit version 2.3.2 .&nbsp;<br />I am executing the tollkit from AIX to provision an Oracle VDB on to Oracle platform.&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Command for VDB creaton was :<br alt="" name="" rel="" target="" title="" type="" value="" />/oraback01/admin/delphix_scripts/DX_KIT/dxtoolkit2/dx_provision_vdb -engine app1002p \<br alt="" name="" rel="" target="" title="" type="" value="" />&nbsp;-sourcename WPRNSAC1 -group SAC_VDB_TRAINING -targetname V_TEST environment uora1009n \<br alt="" name="" rel="" target="" title="" type="" value="" />&nbsp;-dbname V_TEST -envinst /opt/oracle/product/12.1.0.2 -type oracle \<br alt="" name="" rel="" target="" title="" type="" value="" />&nbsp;-mntpoint /mnt/delphix -envUser svcdpx -listeners BSCLISTENER \<br alt="" name="" rel="" target="" title="" type="" value="" />&nbsp;-archivelog no -redoGroup 5 -redoSize 250 -autostart yes<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />It failed with an error:<br alt="" name="" rel="" target="" title="" type="" value="" />Error: source-&gt;allowAutoVDBRestartOnHostReboot-&gt;The field "{0}" is required.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />It looks like -autostart=yes s not getting translated to&nbsp;source.allowAutoVDBRestartOnHostReboot properly.&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />So, I downloaded the version 2.3.7 and 2.3.8 of the toolkit and tried again.&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" />This time I am gettign an error :<br alt="" name="" rel="" target="" title="" type="" value="" />0509-150&nbsp; &nbsp;Dependent module /usr/lib/libcrypto.so could not be loaded.<br alt="" name="" rel="" target="" title="" type="" value="" />&nbsp; &nbsp; &nbsp; &nbsp; 0509-022 Cannot load module /usr/lib/libcrypto.so.<br alt="" name="" rel="" target="" title="" type="" value="" />&nbsp; &nbsp; &nbsp; &nbsp; 0509-026 System error: Cannot run a file that does not have a valid format.<br alt="" name="" rel="" target="" title="" type="" value="" />&nbsp; &nbsp; &nbsp; &nbsp; 0509-022 Cannot load module /tmp/par-737663647078/cache-5bc4fc3becf630d1a27dbd5d2730a625d4d4f61b/8b879676.so.<br alt="" name="" rel="" target="" title="" type="" value="" />&nbsp; &nbsp; &nbsp; &nbsp; 0509-150&nbsp; &nbsp;Dependent module /tmp/par-737663647078/cache-5bc4fc3becf630d1a27dbd5d2730a625d4d4f61b/8b879676.so could not be loaded. at /loader/HASH(0x110122898)/DynaLoader.pm line 193.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><br />I tried setting up the LD_LIBRARY_PATH to include /usr/bin and the libraries are in that location.&nbsp; It didn't make any difference.&nbsp;<br /><br />Has anyone faces it? Any suggestions ?&nbsp; problem complete 8 2 1 comment http://m.getsatisfaction.com/topics/7836214 7836214 Does delphix support SFTP connection with Private key for file masking 2019-01-03T18:47:59Z 2019-01-02T20:59:06Z santosh kumar http://m.getsatisfaction.com/people/9146772 https://www.gravatar.com/avatar/293750ee0adfcfb027b66f6ba8bef907?d=identicon&s=55&r=PG santosh_kumar_elqum1dgzw9qv We are in need of masking AWS S3 bucket object, primarily different type of files. From masking engine, connection to be created with USER/PASSWORD and SSH key.<br /><br />Like, Filezilla or WinSCP clients have an option (Advanced) to connect SFTP servers by using SSH key pair. Does Delphix has any such option? or different ways to connect (other than normal user &amp; password)&nbsp;&nbsp; question complete 4 2 1 comment http://m.getsatisfaction.com/topics/7835937 7835937 How to create file name patterns of file masking in Delphix 5.2.6.1 version. 2019-01-02T17:27:05Z 2019-01-02T10:30:09Z Ashok Kumar http://m.getsatisfaction.com/people/9901321 https://www.gravatar.com/avatar/0e971778af640656d02b7f6c96f1b167?d=identicon&s=55&r=PG ashok_kumar_e56dbhhettd36 question complete 1 3 1 comment http://m.getsatisfaction.com/topics/7836011 7836011 Database routing 2019-01-02T15:26:00Z 2019-01-02T15:00:42Z Suja http://m.getsatisfaction.com/people/9872171 https://www.gravatar.com/avatar/d2c82e9375402890ff5752e21e54a6db?d=identicon&s=55&r=PG suja_c26ohh9eix9ua We have single application instance hosted on a server and we have multiple vdbs using Delphix which contains different type of test data.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Can I connect my application instance to multiple vdbs and route the DB calls appropriate as per test data requirement.&nbsp; question complete 1 2 1 comment http://m.getsatisfaction.com/topics/7835381 7835381 Happy New Year! 2018-12-31T17:36:15Z 2018-12-31T17:36:15Z MichaelT http://m.getsatisfaction.com/people/9706172 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11297306/Torok_medium.png michael_torok First, let me be one of the first (since I’m early) to wish you a Happy New Year on behalf of the Delphix Community Management team and on behalf of the larger Delphix family. Happy New Year!<br /><br />I know there are a number of you who believe that resolutions are like wishes, that is, you keep them to yourself or they don’t come true. I’m more of the ideology that resolutions get stronger when they are socially reinforced. So, I’m going to throw this out here in the community to see what resolutions come back on the ripples.<br /><br />Starting with me, since I’m the one currently typing away here on New Year’s Eve. I know I’m not alone. Throw down a resolution for 2019. Heck, we can make it a new tradition. <br /><ul><li>How are you going to take DataOps to the next level this year?</li><li> What projects will you own and conquer in the new year?</li><li> What is on your horizon?&nbsp;</li></ul><br /><b>Community Resolution Time</b><br />It is only with you that we can achieve the community goal... help us make it happen.<br /><br />In 2019, we resolve to provide an ever-increasingly engaging, dynamic, flexible, interesting and colorful community in which and from which you can easily find and participate in all Delphix learning, education, social, open-source, and engagement platforms. update 0 1 1 create community, new year, new year's, resolutions http://m.getsatisfaction.com/topics/7832538 7832538 Using dx_create_env to Create Target MS SQL Clusters 2018-12-28T05:48:28Z 2018-12-22T03:35:11Z TimHav http://m.getsatisfaction.com/people/9892260 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11361631/picture_medium.png tim_havecker Hello, <br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Toolkit Function: dx_create_env<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />I have creating Hosts down via Powershell and combining with your toolkit, but after looking through documentation on github etc. I am a little perplexed on how to create a Target MS SQL Cluster via&nbsp; the toolkit after multiple failed tries ( always comes out as a Host and not a Cluster when looking in the gui) , using the -help function there is nothing there that specifies Clusters other than -ClusterName and -ClusterLocation; but as the help file suggests it seems to be for Oracle RAC. <br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Is there anyway of doing this via toolkit for MS SQL Clusters? or anything that can lead me in the right direction. Ive tried searching here, but have not found anything as of yet.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Thanks in advance<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Tim<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /> question complete 2 2 1 comment http://m.getsatisfaction.com/topics/7792337 7792337 Masking Mainframe DB2 and Informix Database 2018-12-21T09:31:33Z 2018-09-13T19:30:02Z Viswas Patnala http://m.getsatisfaction.com/people/8643806 https://www.gravatar.com/avatar/554c142b5613a80d91453bdb19db07e0?d=identicon&s=55&r=PG viswas_patnala We are using 5.2.4 version of masking engine in our organization. Does this version support masking mainframe DB2 and Informix database? <br />Masking Documentation shows as supported for mainframe db2 but this option is missing in "Create Connection". We can see all other db connections like oracle, sql server, File-VSAM, etc. question complete 2 3 1 comment http://m.getsatisfaction.com/topics/7831699 7831699 Oracle VDB provisioning - setting up ConfigTempate gives an error 2018-12-20T21:25:00Z 2018-12-19T21:38:36Z Ansamma Mathews http://m.getsatisfaction.com/people/9869150 https://www.gravatar.com/avatar/85253e7a1fcfab17b86d83caead17bb2?d=identicon&s=55&r=PG ansamma_mathews I am trying to use a config template for VDB provisioining for Oracle.&nbsp;&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />This was done by setting&nbsp;&nbsp;source.configTemplate .&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" />I am getting an error :<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />&nbsp; Error: The input parameters "configTemplate" and "configParams" are mutually exclusive.<br alt="" name="" rel="" target="" title="" type="" value="" />&nbsp; Action: Provide only one of the parameters and try again.<br alt="" name="" rel="" target="" title="" type="" value="" />app1003p database provision *&gt; unset source.configParams<br alt="" name="" rel="" target="" title="" type="" value="" />app1003p database provision *&gt; commit<br alt="" name="" rel="" target="" title="" type="" value="" />The following validation errors are present:<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />&nbsp; &nbsp; source.configParams The field has to be set.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Correct these errors and try again, or abort the operation.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />How do I get around it ?&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /> question active 2 2 1 comment