delphix / dxtoolkit

Scripts that remotely interact with Delphix engine APIs
Apache License 2.0
38 stars 32 forks source link

"[05-23-2022] [Error while provisioning VDB through dxtoolkit command]" #207

Closed shashidhara-bv closed 1 year ago

shashidhara-bv commented 2 years ago

Expected Behavior VDB has to be provisioned on execution of "dx_provision_vdb" with required parameters

Actual Behavior When I am trying to execute "dx_provision_vdb" command with required parameters, on execution getting bellow error "Cause: Validation of user environment failed."

Steps To Reproduce the Problem Execute dxtoolkit command "dx_provision_vdb" by passing parameters like ./dx_provision_vdb -d engine , -group , -sourcename, -targetname, -dbname, -environment, -type, -envinst

Screenshots Attached step by step screenshots image 1 image 2 image 3

Version Continuous Data 6.0.13.1

Additional Context When I browse for the solution, find suggestion like, issue is due to 'user privilege' but for the same host I have provisioned VDB through UI by logging with same user. Please find attached CLI exec screenshots for more details and suggest us the solution.

pioro commented 2 years ago

Hello,

I can't see a mount point being specified here - what mount point are you using in GUI ? If you don't specify a "-mntpoint" parameter a default /mnt/provision is used and this can cause problems.

Also could you please run the followng steps:

go to your home directory: cd /home/

run dxtoolkit with a full list of parameters and -debug 3 /opt/oracle/admin/dxtoolkit/install/dxtoolkit2/dx_provision_db -d xxxxxxxxxx -debug 3

This should create a debux_xxxx directory in your home folder where xxxx will be an engine name. Could you please zip this folder and send to me ?

regards, Marcin

shashidhara-bv commented 2 years ago

HI Marcin,

We are using "/mnt/nfs" as "Mount Base" in GUI while provisioning VDB, attached screenshot below.

[cid:725a1b8e-4645-41c4-9267-9a3d6cf8172d]

image

As per the suggestion included mountpoint parameter "-mntpoint /mnt/nfs" which I used in GUI from home directory but no luck.

Tried with below options from home directory, please verify the screenshot 1 --debug 3 2 -debug 3 3 without "-envUser oracle" 4 without "-envUser oracle" and with mountpoint parameter "-mntpoint /mnt/nfs" -debug 3 5 with mountpoint parameter "-mntpoint /mnt/nfs" --debug 3

[cid:bfb5ea77-ad51-4e3c-aef9-c4c84248c0a1]

image (2)

Please let us know is it possible to get into a call with screen share and resolve the issue at mutually convenient date and time.

Regards, Shashidhar.


From: Marcin Przepiorowski @.> Sent: Thursday, May 26, 2022 5:22 PM To: delphix/dxtoolkit @.> Cc: Shashidhara Vasanthkumar (OSV) @.>; Author @.> Subject: [EXTERNAL] Re: [delphix/dxtoolkit] "[05-23-2022] [Error while provisioning VDB through dxtoolkit command]" (Issue #207)

Caution! This email originated outside of FedEx. Please do not open attachments or click links from an unknown or suspicious origin.

Hello,

I can't see a mount point being specified here - what mount point are you using in GUI ? If you don't specify a "-mntpoint" parameter a default /mnt/provision is used and this can cause problems.

Also could you please run the followng steps:

go to your home directory: cd /home/

run dxtoolkit with a full list of parameters and -debug 3 /opt/oracle/admin/dxtoolkit/install/dxtoolkit2/dx_provision_db -d xxxxxxxxxx -debug 3

This should create a debux_xxxx directory in your home folder where xxxx will be an engine name. Could you please zip this folder and send to me ?

regards, Marcin

— Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https://github.com/delphix/dxtoolkit/issues/207*issuecomment-1138456794__;Iw!!BL9GA0TyTA!elIGQakI-Kw-DGtJHE7oAhmOemdegDkHhHjdUZZnzQvy_znzRu9iNDYCSn8hy86sDb1YRheJjmEf9KWcJI979TdzQl42_q_FflUSrSc$, or unsubscribehttps://urldefense.com/v3/__https://github.com/notifications/unsubscribe-auth/AZI6HYXM462WW4YZEYGBRFLVL5QX5ANCNFSM5WULEC7Q__;!!BL9GA0TyTA!elIGQakI-Kw-DGtJHE7oAhmOemdegDkHhHjdUZZnzQvy_znzRu9iNDYCSn8hy86sDb1YRheJjmEf9KWcJI979TdzQl42_q_FC66s59o$. You are receiving this because you authored the thread.Message ID: @.***>

pioro commented 2 years ago

Hi,

I am sorry I mean to cd $HOME not cd /home.
You don't have a permissions to write to /home directory - Could you please change directory to the one where you can write into and run a script ?

Parameter -debug 3 requires to start dxtoolkit command from the directory where you have an write access, otherwise you will hit a problem which is related to lack of the write permission and this will happen before validation of your parameters.

If you want to give it a try - add -mntpoint /mnt/nfs without -debug 3 and test if this is working.

regards, Marcin

shashidhara-bv commented 2 years ago

HI Marcin,

I was occupied with other activity and not able to try your instructions in last 2 days.

From cd $HOME am able to execute 'dx_provision_vdb' command with below parameter and VDB's (MOTESVDB3, MOTESVDB4, MOTESVDB5 and MOTESVDB6) has been provisioned with and without -debug 3 but status is 'killed' instead of 'Completed'.

As an example, below command executed to provision MOTESVDB5 with -debug 3 which has provisioned but with status 'killed'. As instructed, extracted directory "debug_uapa0008" and attached zipped folder for your analysis. /opt/oracle/admin/dxtoolkit/install/dxtoolkit2/dx_provision_vdb -d uapa0008 -group 'Test VDB' -sourcename GMNIATS1 -targetname MOTESVDB5 -dbname MOTESDB5 -environment ACCS-SA-TGT-UDBA0140 -type oracle -envinst '/opt/oracle/product/19.0.0' -envUser oracle -mntpoint '/mnt/nfs' - debug 3

Below command executed with out -debug 3 which ended with status "killed" and when I checked in GUI VDB created with status "VDB Stopped" (please verify below screen shot for CLI and GUI) /opt/oracle/admin/dxtoolkit/install/dxtoolkit2/dx_provision_vdb -d uapa0008 -group 'Test VDB' -sourcename GMNIATS1 -targetname MOTESVDB6 -dbname MOTESDB6 -environment ACCS-SA-TGT-UDBA0140 -type oracle -envinst '/opt/oracle/product/19.0.0' -envUser oracle -mntpoint '/mnt/nfs'

[cid:2c94b556-9e49-470b-8b61-d6c423c13fd6]

[cid:fb5a886b-b5a8-4fb6-b7ed-f2d7e820281f]

Copied attached "debug_uapa0008" directory for your verification. Please verify and suggest us to create VDB without any issue. [cid:eded90bd-4666-4d96-bfbf-900284f09dc3]

Regards, Shashidhar.


From: Marcin Przepiorowski @.> Sent: Monday, May 30, 2022 1:54 PM To: delphix/dxtoolkit @.> Cc: Shashidhara Vasanthkumar (OSV) @.>; Author @.> Subject: [EXTERNAL] Re: [delphix/dxtoolkit] "[05-23-2022] [Error while provisioning VDB through dxtoolkit command]" (Issue #207)

Caution! This email originated outside of FedEx. Please do not open attachments or click links from an unknown or suspicious origin.

Hi,

I am sorry I mean to cd $HOME not cd /home. You don't have a permissions to write to /home directory - Could you please change directory to the one where you can write into and run a script ?

Parameter -debug 3 requires to start dxtoolkit command from the directory where you have an write access, otherwise you will hit a problem which is related to lack of the write permission and this will happen before validation of your parameters.

If you want to give it a try - add -mntpoint /mnt/nfs without -debug 3 and test if this is working.

regards, Marcin

— Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https://github.com/delphix/dxtoolkit/issues/207*issuecomment-1140855915__;Iw!!BL9GA0TyTA!afnuxG-UPowQVTFECWhWaNViZ-31bv3MG-WxPUBoziEvhzZznYVC2vwN6AJu94IiX1pLjZ3kyOpNrLN6MA_2TPJccsRwJO3f4Xwqk_0$, or unsubscribehttps://urldefense.com/v3/__https://github.com/notifications/unsubscribe-auth/AZI6HYTOVC5SNBJBH6NE5T3VMR3L7ANCNFSM5WULEC7Q__;!!BL9GA0TyTA!afnuxG-UPowQVTFECWhWaNViZ-31bv3MG-WxPUBoziEvhzZznYVC2vwN6AJu94IiX1pLjZ3kyOpNrLN6MA_2TPJccsRwJO3f-U0Iyc0$. You are receiving this because you authored the thread.Message ID: @.***>

shashidhara-bv commented 2 years ago

HI Aaron/Marcin,

Gentle remainder, Please suggest the solution for below issue and let us know if there is need of screen sharing session.

Regards, Shashidhar.


From: Shashidhara Vasanthkumar (OSV) @.> Sent: Wednesday, June 1, 2022 2:12 PM To: delphix/dxtoolkit @.>; delphix/dxtoolkit @.> Cc: Author @.>; Nandakishore Bappanadu Karunakar (OSV) @.>; Aaron Tully @.> Subject: Re: [EXTERNAL] Re: [delphix/dxtoolkit] "[05-23-2022] [Error while provisioning VDB through dxtoolkit command]" (Issue #207)

HI Marcin,

I was occupied with other activity and not able to try your instructions in last 2 days.

From cd $HOME am able to execute 'dx_provision_vdb' command with below parameter and VDB's (MOTESVDB3, MOTESVDB4, MOTESVDB5 and MOTESVDB6) has been provisioned with and without -debug 3 but status is 'killed' instead of 'Completed'.

As an example, below command executed to provision MOTESVDB5 with -debug 3 which has provisioned but with status 'killed'. As instructed, extracted directory "debug_uapa0008" and attached zipped folder for your analysis. /opt/oracle/admin/dxtoolkit/install/dxtoolkit2/dx_provision_vdb -d uapa0008 -group 'Test VDB' -sourcename GMNIATS1 -targetname MOTESVDB5 -dbname MOTESDB5 -environment ACCS-SA-TGT-UDBA0140 -type oracle -envinst '/opt/oracle/product/19.0.0' -envUser oracle -mntpoint '/mnt/nfs' - debug 3

Below command executed with out -debug 3 which ended with status "killed" and when I checked in GUI VDB created with status "VDB Stopped" (please verify below screen shot for CLI and GUI) /opt/oracle/admin/dxtoolkit/install/dxtoolkit2/dx_provision_vdb -d uapa0008 -group 'Test VDB' -sourcename GMNIATS1 -targetname MOTESVDB6 -dbname MOTESDB6 -environment ACCS-SA-TGT-UDBA0140 -type oracle -envinst '/opt/oracle/product/19.0.0' -envUser oracle -mntpoint '/mnt/nfs'

[cid:2c94b556-9e49-470b-8b61-d6c423c13fd6]

[cid:fb5a886b-b5a8-4fb6-b7ed-f2d7e820281f]

Copied attached "debug_uapa0008" directory for your verification. Please verify and suggest us to create VDB without any issue. [cid:eded90bd-4666-4d96-bfbf-900284f09dc3]

Regards, Shashidhar.


From: Marcin Przepiorowski @.> Sent: Monday, May 30, 2022 1:54 PM To: delphix/dxtoolkit @.> Cc: Shashidhara Vasanthkumar (OSV) @.>; Author @.> Subject: [EXTERNAL] Re: [delphix/dxtoolkit] "[05-23-2022] [Error while provisioning VDB through dxtoolkit command]" (Issue #207)

Caution! This email originated outside of FedEx. Please do not open attachments or click links from an unknown or suspicious origin.

Hi,

I am sorry I mean to cd $HOME not cd /home. You don't have a permissions to write to /home directory - Could you please change directory to the one where you can write into and run a script ?

Parameter -debug 3 requires to start dxtoolkit command from the directory where you have an write access, otherwise you will hit a problem which is related to lack of the write permission and this will happen before validation of your parameters.

If you want to give it a try - add -mntpoint /mnt/nfs without -debug 3 and test if this is working.

regards, Marcin

— Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https://github.com/delphix/dxtoolkit/issues/207*issuecomment-1140855915__;Iw!!BL9GA0TyTA!afnuxG-UPowQVTFECWhWaNViZ-31bv3MG-WxPUBoziEvhzZznYVC2vwN6AJu94IiX1pLjZ3kyOpNrLN6MA_2TPJccsRwJO3f4Xwqk_0$, or unsubscribehttps://urldefense.com/v3/__https://github.com/notifications/unsubscribe-auth/AZI6HYTOVC5SNBJBH6NE5T3VMR3L7ANCNFSM5WULEC7Q__;!!BL9GA0TyTA!afnuxG-UPowQVTFECWhWaNViZ-31bv3MG-WxPUBoziEvhzZznYVC2vwN6AJu94IiX1pLjZ3kyOpNrLN6MA_2TPJccsRwJO3f-U0Iyc0$. You are receiving this because you authored the thread.Message ID: @.***>

nitins85 commented 2 years ago

Hi Sashidhar, It's better to have a screen sharing session to discuss the issue. We can plan a session for next week. I have dropped you an email so that we can find a suitable slot.

Regards, Nitin