This is very common. You use clones to test the application, and testing on upgraded database version is probably the most common clone usage.<\/p>\n
So, there’s an ‘Upgrade’ button, just near the refresh one, but this is a false-friend. It doesn’t upgrade anything but just sets the Oracle Home known by Delphix to the new one after you upgraded yourself. Because Delphix does not detect this change automatically. But Delphix requires it in order to run the toolkit actions. No problem, the upgrade of Oracle is easy with Oracle AutoUpgrade, and that’s just one additional manual action. So why is it called ‘Upgrade’ and not ‘Change Oracle Home’? That’s the problem: you can change only to a newer version Oracle Home. Then… how do you revert back to the previous version in order to refresh the clone? You can’t.<\/p>\n
That’s not exactly what I call a ‘CLI’ – Command Line Interface is supposed to accept actions and parameters other than stdin and return codes. But let’s try to automate that.<\/p>\n Here I’m showing a template for a Do-It-Yourself solution. Please don’t use it as-is. Test it. Because having access to the tty console rather than a clean CLI or API doesn’t allow for professional error handling.<\/p>\n This console is accessible through ssh with the admin user. Or an admin user that you have defined in the management console. This is not the setup console. You don’t want to have hardcoded passwords, so better use passwordless authentication. I’ll do all that from the database server as root. so I check my public key that I’ve generated with `ssh-keygen`:<\/p>\n This can be put once in the Delphix console.<\/p>\n This only time I’ll connect with the password I defined when creating the user from the GUI<\/p>\n this is all, now I can ssh without providing the password<\/p>\n Let’s see how to automate the manual actions given by the support engineer. Here is my script and I explain later:<\/p>\n First, I define the ssh connection as I’ll have to ssh many times to read the answer and continue. # as root (to see \/proc\/*\/cwd) here is how to get the ORACLE_HOME from an ORACLE_SID for a running instance: — Franck Pachot (@FranckPachot) May 5, 2021<\/a><\/p><\/blockquote>\n![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-2021-05-05-110130.jpg\")
<\/a>The only solution provided by the support (without additional consulting charges) is a manual action on the console. Not the Web console, but the telnet one.<\/p>\nSSH key<\/h3>\n
\nI’ve written a glossary about this: https:\/\/www.dbi-services.com\/blog\/delphix-a-glossary-to-get-started\/<\/a><\/p>\n\n# cat ~\/.ssh\/id_rsa.pub\nssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDRIw5638wyewN716iARPTKpaeCP+HtNOEa5TSKfI8Eh3h3EUwb+H3qzrWtv\/b0k147QC0ET93kf2Y4AgvoaFKvo3ms3U6pI5BtCBN3h49KCcj4k1sPKmytJap6G6C79BMZKoGbG6hOSQ7PbbHHPoSgSYiXrxaO3Rh8OqWl+EqSQ45TSLE5Nb6+YuASEeILSUv3fezE21\/kZ4dxsYJeE+6pfaUHCm\/sCTFKM7JZJsviQ\/3usq+7m8w+AreedQXAYERq9tDdCcrCUkmrj3OhiLh3YoYre8XkZ0QiBT1bwhkPlxGO5aN5bkihqm2ETF3y9sbdf2d\/xXpKTnx3tTWZo6tr root@dbserver\n<\/code><\/pre>\n\n\n:~$ ssh admin@10.0.1.10\nPassword: \n\nip-10-0-1-10> ls\n\n...\nuser\n...\n\nip-10-0-1-10> user\nip-10-0-1-10 user> ls\n\nObjects\nNAME EMAILADDRESS \ndev dev@nomail.com\nqa qa@nomail.com\nlabadmin labadmin@nomail.com\nadmin admin@nomail.com\n\nip-10-0-1-10 user> current\n\nip-10-0-1-10 user 'admin'> ls\nProperties\n type: User\n name: admin\n...\n \nip-10-0-1-10 user 'admin'> update\nip-10-0-1-10 user 'admin' update *> ls\nProperties\n type: User\n name: admin\n ...\n\nip-10-0-1-10 user 'admin' update *> set publicKey=\"ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDRIw5638wyewN716iARPTKpaeCP+HtNOEa5TSKfI8Eh3h3EUwb+H3qzrWtv\/b0k147QC0ET93kf2Y4AgvoaFKvo3ms3U6pI5BtCBN3h49KCcj4k1sPKmytJap6G6C79BMZKoGbG6hOSQ7PbbHHPoSgSYiXrxaO3Rh8OqWl+EqSQ45TSLE5Nb6+YuASEeILSUv3fezE21\/kZ4dxsYJeE+6pfaUHCm\/sCTFKM7JZJsviQ\/3usq+7m8w+AreedQXAYERq9tDdCcrCUkmrj3OhiLh3YoYre8XkZ0QiBT1bwhkPlxGO5aN5bkihqm2ETF3y9sbdf2d\/xXpKTnx3tTWZo6tr delphix@labserver\"\nip-10-0-1-10 user 'admin' update *> commit;\nip-10-0-1-10 user 'admin'> exit\nConnection to 10.0.1.10 closed.\n<\/code><\/pre>\n(re)set the Oracle Home<\/h3>\n
\nmanagement=admin@10.0.1.10 \n\nfor source in $({\nssh \"$management\" <<SSH\nsource\nls\nSSH\n} | awk '\/ true \/{ print $1}'\n) ; do\necho \"# looking if source=$source is on this server and finding oracle home\"\n{\nssh \"$management\" <<SSH\nsourceconfig\nselect $source\nls\nSSH\n} | awk '\/repository\/{sub(\"^ *repository: \",\"\");repo=$0; print source,sid,$0}\/ instanceName\/{sid=$NF}' source=$source |\nwhile read source sid repository ; do\n # this should run as root to see the current directory from\/proc\n dbs=$(readlink \/proc\/$(pgrep -f _pmon_$sid\\$)\/cwd)\n # process it only if home is found (this source is on this host\n if [ -n \"$dbs\" ] ; then\n home=$(dirname \"$dbs\")\n new=\"${repository%%\\'\/*}'${home}'\"\n if [ \"$repository\" != \"$new\" ] ; then\n echo \"## setting new repository source=$source (sid=$sid home=$home) to repository=$new (previous was $repository)\"\n ssh \"$management\" <<SSH\nsourceconfig\nselect $source\nupdate\nset repository=\"$new\"\ncommit\nls\nSSH\n fi\n fi\ndone\n\ndone\n<\/code><\/pre>\n
\nThe first block will list all sources (VDBs) known by Delphix, with ssh output processed by awk.
\nThe second block, for each source, will look at the configuration to get the “instanceName” which is the ORACLE_SID.
\nWith this, I’ll get the Oracle home with:<\/p>\n\n
ORACLE_HOME=$( dirname $(readlink \/proc\/$(pgrep -f _pmon_$ORACLE_SID$)\/cwd) )<\/p>\n