Hi,
In the zip file you send me I can see that:
{"timeflowPointParameters":{"type":"TimeflowPointSemantic","container":"ORACLE_DB_CONTAINER-973","location":"LATEST_SNAPSHOT"},"container":{"type":"OracleDatabaseContainer","name":"vtrinlwc","group":"GROUP-42","sourcingPolicy":{"logsyncMode":"UNDEFINED","logsyncInterval":5,"logsyncEnabled":false,"type":"OracleSourcingPolicy","loadFromBackup":false}},"source":{"archivelogMode":false,"type":"OracleVirtualSource","mountBase":"/delphix/provision","nodeListenerList":[],"allowAutoVDBRestartOnHostReboot":false,"operations":{"configureClone":[],"type":"VirtualSourceOperations","preRefresh":[],"postRefresh":[]},"configTemplate":"DATABASE_TEMPLATE-12"},"sourceConfig":{"services":[],"linkingEnabled":false,"repository":"ORACLE_INSTALL-183","databaseName":"vtrinlwc","instance":{"type":"OracleInstance","instanceName":"vtrinlwc","instanceNumber":1},"type":"OracleSIConfig","uniqueName":"vtrinlwc"},"type":"OracleProvisionParameters"}
and response from Delphix Engine
{
"action" : "ACTION-179057",
"type" : "OKResult",
"job" : "JOB-96064",
"result" : "ORACLE_DB_CONTAINER-1215",
"status" : "OK"
}
so job was started and it failed with this error
{
"percentComplete" : 36,
"timestamp" : "2020-07-13T11:48:07.764Z",
"messageAction" : "Review the Oracle alert log for more details.",
"diagnoses" : [],
"messageCode" : "exception.oracle.targetscripts.db.recovery",
"messageCommandOutput" : "command: umask 027; . $DB_SCRIPT_DIR/setup-oraenv.sh; $DLPX_SHELL $DB_SCRIPT_DIR/doRecoveryWithBackupCF.sh $DB_SCRIPT_DIR \"$LOGON_STR\"\noutput:END_OF_SETUP\nEND_OF_SETUP\nMOUNT_DATABASE_COMPLETED\nLOG_MODE=NOARCHIVELOG\n\nPL/SQL procedure successfully completed.\nLASTEST_CHECKPOINT_CHANGE_NUMBER=\n alter database open\n*\nERROR at line 1:\nORA-00603: ORACLE server session terminated by fatal error\nORA-01092: ORACLE instance terminated. Disconnection forced\nORA-00704: bootstrap process failure\nORA-00604: error occurred at recursive SQL level 1\nORA-00904: \"ACDRROWTSINTCOL#\": invalid identifier\nProcess ID: 23558\nSession ID: 1144 Serial number: 46852\n\n\nORA-24324: service handle not initialized\nORA-01041: internal error. hostdef extension doesn't exist\nORACLE_RECOVERY_ERROR\n",
"eventType" : "ERROR",
"messageDetails" : "Failed to apply logs in database recovery.",
"type" : "JobEvent",
"state" : null
}
Could you please confirm that ZIP file you sent me is an output from your run ? It is for this VDB - vtrinlwc
regards,
Marcin
------------------------------
Marcin Przepiorowski
Technical Principal
Delphix
------------------------------
Original Message:
Sent: 07-16-2020 05:31:02 AM
From: Srividya Srinivasan
Subject: Issue with dx_provision_vdb
Yes I am able to create VDB on that server using GUI and script. For this database I can create using GUI. Only with script it is not working. Also I got this error if i see on the last page of the debug
-Entering Engine::getEngineName
Problem with starting job
Error: source->allowAutoVDBRestartOnHostReboot->The field "{0}" is required.
-Can't submit job for operation resources/json/delphix/database/provision
error $VAR1 = {
'source' => {
'allowAutoVDBRestartOnHostReboot' => {
'action' => undef,
'id' => 'exception.validation.field.missing',
'details' => 'The field "{0}" is required.',
'commandOutput' => undef,
'diagnoses' => undef
}
}
};
$VAR2 = 1;
-Check your input parameters and try again.
------------------------------
Srividya Srinivasan
Community Member
Delphix Community Members
Original Message:
Sent: 07-16-2020 03:04:19 AM
From: Marcin Przepiorowski
Subject: Issue with dx_provision_vdb
Hi,
It's is outside of scope of Dxtoolkit support but I would suggest to add server name and IP address to /etc/hosts.
Are you able to create VDB on that server using GUI ?
regards,
Marcin
------------------------------
Marcin Przepiorowski
Technical Principal
Delphix
Original Message:
Sent: 07-15-2020 03:57:38 PM
From: Srividya Srinivasan
Subject: Issue with dx_provision_vdb
We have other VDBs running on this server. I have this on /etc/hosts file
127.0.0.1 localhost.localdomain localhost
------------------------------
Srividya Srinivasan
Community Member
Delphix Community Members
Original Message:
Sent: 07-15-2020 03:21:34 AM
From: Marcin Przepiorowski
Subject: Issue with dx_provision_vdb
Hello,
I can see that job has been started, so new Dxtoolkit is working OK
but now you have a problem with Delphix job itself and this is an Oracle error
ORA-00603: ORACLE server session terminated by fatal error
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: \"ACDRROWTSINTCOL#\": invalid identifier
Process ID: 23558\nSession ID: 1144 Serial number: 46852
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist\nORACLE_RECOVERY_ERROR\n",
Are you provisioning this VDB to a new server ? Do you have a name of this server in /etc/hosts
and name is not pointing to 127.0.0.1 ?
regards,
Marcin
------------------------------
Marcin Przepiorowski
Technical Principal
Delphix
Original Message:
Sent: 07-14-2020 11:27:18 AM
From: Srividya Srinivasan
Subject: Issue with dx_provision_vdb
Sorry about that. Reattaching
------------------------------
Srividya Srinivasan
Community Member
Delphix Community Members
Original Message:
Sent: 07-14-2020 08:54:08 AM
From: Marcin Przepiorowski
Subject: Issue with dx_provision_vdb
Hi Srividya,
Your zip file contain an empty directory.
Could you please check if there are any files generated ?
regards,
Marcin
------------------------------
Marcin Przepiorowski
Technical Principal
Delphix
Original Message:
Sent: 07-14-2020 07:37:27 AM
From: Srividya Srinivasan
Subject: Issue with dx_provision_vdb
Hi - any updates ?
------------------------------
Srividya Srinivasan
Community Member
Delphix Community Members
Original Message:
Sent: 07-13-2020 12:50:37 PM
From: Michael Torok
Subject: Issue with dx_provision_vdb
Perfect!
------------------------------
Michael Torok
Director of Knowledge and Community Management
Delphix
Original Message:
Sent: 07-13-2020 12:49:25 PM
From: Srividya Srinivasan
Subject: Issue with dx_provision_vdb
I emailed it directly but after seeing your message about the popup I tried from another browser and was able to upload here as well. Thanks for the help
------------------------------
Srividya Srinivasan
Community Member
Delphix Community Members
Original Message:
Sent: 07-13-2020 10:06:01 AM
From: Michael Torok
Subject: Issue with dx_provision_vdb
Please feel free to send it to me directly and I will attach it. Michael.torok@delphix.com
The upload file button pops up a new window, so it could be stopped by popup blockers.
Thanks,
Michael
------------------------------
Michael Torok
Director of Knowledge and Community Management
Delphix
Original Message:
Sent: 07-13-2020 09:55:39 AM
From: Srividya Srinivasan
Subject: Issue with dx_provision_vdb
Yes I tried to click on the Upload File earlier but no window opened up. So wanted to see if I was missing something. Is there another way I can send the zip file ?
------------------------------
Srividya Srinivasan
Community Member
Delphix Community Members
Original Message:
Sent: 07-13-2020 09:33:54 AM
From: Michael Torok
Subject: Issue with dx_provision_vdb
Hi Srividya,
When you reply, there are is a button at the bottom right of the screen which says "Upload file". Click that button and you will be guided through uploading your zip file. Please see the image below.
------------------------------
Michael Torok
Director of Knowledge and Community Management
Delphix
Original Message:
Sent: 07-13-2020 07:01:15 AM
From: Srividya Srinivasan
Subject: Issue with dx_provision_vdb
I have the zip file. how do I attach here ?
------------------------------
Srividya Srinivasan
Community Member
Delphix Community Members
Original Message:
Sent: 07-13-2020 03:14:17 AM
From: Marcin Przepiorowski
Subject: Issue with dx_provision_vdb
Hello,
Could you please run this command with -debug 3 and zip a debug_xxxx directory and attach here ?
xxxx is a name of your Delphix Engine and this subdirectory will be created your current working directory.
If you want to define auto start option in the provisioning command you can use this option and choose one yes or no
dx_provision_db -autostart [yes|no] ........
regards,
Marcin
------------------------------
Marcin Przepiorowski
Technical Principal
Delphix
Original Message:
Sent: 07-10-2020 04:27:43 PM
From: Srividya Srinivasan
Subject: Issue with dx_provision_vdb
Downloaded version 2.4.7 and got the same error
Error: source->allowAutoVDBRestartOnHostReboot->The field "{0}" is required.
Job wasn't defined. If there is no error on the screen, try with -debug flag to find a root cause.
------------------------------
Srividya Srinivasan
Community Member
Delphix Community Members
Original Message:
Sent: 07-10-2020 12:22:56 PM
From: Marcin Przepiorowski
Subject: Issue with dx_provision_vdb
Hi,
Could you please upgrade to the latest version and let me know if this is working OK ?
Here is a link:
https://github.com/delphix/dxtoolkit/releases/tag/v2.4.7
regards,
Marcin
------------------------------
Marcin Przepiorowski
Technical Principal
Delphix
Original Message:
Sent: 07-10-2020 11:44:27 AM
From: Srividya Srinivasan
Subject: Issue with dx_provision_vdb
dxtoolkit2-2.3.8.1-redhat7.tar
------------------------------
Srividya Srinivasan
Community Member
Delphix Community Members
Original Message:
Sent: 07-10-2020 11:08:28 AM
From: Marcin Przepiorowski
Subject: Issue with dx_provision_vdb
Hi,
What version of Dxtoolkit are you using ?
You may need to upgrade it as well, if you have a new version of Delphix Engine.
regards,
Marcin
------------------------------
Marcin Przepiorowski
Technical Principal
Delphix
Original Message:
Sent: 07-09-2020 11:45:01 PM
From: Srividya Srinivasan
Subject: Issue with dx_provision_vdb
We recently upgraded our delphix engine to 5.3.8.1. After the upgrade I ran one of our provisioning jobs and it failed. Then I downloaded the latest dxtoolkit but it still keeps failing.
Old command
----------------
dx_provision_vdb -type oracle -group "<groupname>" -sourcename <srcname> -targetname <tgtname> -dbname <tgtname> -srcgroup "<groupname>" -timestamp LATEST_SNAPSHOT -environment <envname> -template <template> -envinst <oraclehome> -instname <instname> -uniqname <name> -mntpoint <mnt> -archivelog no
When using the above command, got this error -
command output:
Problem with starting job
Error: source->allowAutoVDBRestartOnHostReboot->The field "{0}" is required.
Job wasn't defined. If there is no error on the screen, try with -debug flag to find a root cause.
===============================
command exit code: 1
New command
------------------
dx_provision_vdb -type oracle -group "<groupname>" -sourcename <srcname> -targetname <tgtname> -dbname <tgtname> -srcgroup "<groupname>" -timestamp LATEST_SNAPSHOT -environment <envname> -template <template> -envinst <oraclehome> -instname <instname> -uniqname <name> -mntpoint <mnt> -archivelog no -autostart yes -allowAutoVDBRestartOnHostReboot true
With the new command, I get the following error
Unknown option: allowAutoVDBRestartOnHostReboot
------------------------------
Srividya Srinivasan
Community Member
Delphix Community Members
------------------------------