Deploying the Oracle on Bare Metal Solution Reviews

Ramakoteswara P. · Reviewed מעל 2 שנים ago

Yarema M. · Reviewed מעל 2 שנים ago

Jordi M. · Reviewed מעל 2 שנים ago

Caio B. · Reviewed מעל 2 שנים ago

Ryan L. · Reviewed מעל 2 שנים ago

jal s. · Reviewed מעל 2 שנים ago

Eliott S. · Reviewed מעל 2 שנים ago

SHAIK F. · Reviewed מעל 2 שנים ago

Angel Ricardo P. · Reviewed מעל 2 שנים ago

Juan Gustavo G. · Reviewed מעל 2 שנים ago

Scott M. · Reviewed מעל 2 שנים ago

Pablo C. · Reviewed מעל 2 שנים ago

Silas J. · Reviewed מעל 2 שנים ago

This lab, as written, is difficult to achieve in 2 hours on the first try. ON my 3rd attempt, I was able to get through everything in 70 minutes, so it is doable. Here's what worked for me. Create an OTN account ahead of time. I could not grab the download URL and use it with curl to send the output to Google Cloud. So, what I did instead is download the oracle installer zip file to my PC, upload it to one of my own GCP storage buckets, make a signed URL. This is all done before starting the lab, and shaves off about 30 minutes from time that would otherwise be spent in the lab. With that done, start the lab, grab the zip file from GCS and move it from bastion to bare metal server. This scp step took about 15 minutes for me, and there's no obvious way to speed it up. Another issue I found is that the ansible playbook installer can abort and leave a half-installed Oracle DB. I could not figure out how to recover from this problem before my lab timed out. So, I started again, this time I kept my mouse cursor on top of the ssh session window the entire time. Possibly, if you move away from the ssh session (eg send an email or something like that) the session can time out, and this of course will leave the DB installation in an incomplete state. So, if you get an error message "ORA-65011: Pluggable database PDBORCL does not exist." at step 6 of Task 3, you should probably just quit the lab and start over. I got it all to work on the 3rd try, by using cloud shell and jiggling my mouse cursor every minute on the ssh session screen. After the DB is fully and correctly installed, the rest (Task 4) is straightforward. Advice to Google: Please come up with a better way to get the Oracle installer zip file onto the bastion host. The current procedure is both hacky and slow. Advice to some other reviewers. Oracle software is commercial software and can only be downloaded in accordance with Oracle's terms. This is why every student needs to create a separate OTN account and download their own copy of the large ZIP file. Putting this file onto github or similar repo would violate Oracle's conditions. It might be good to point out that Oracle software is large, complex and very powerful. Anyone who has built an Oracle DB from scratch, including installing an OS on a bare metal machine, knows that doing all of that manually can easily take a day or more. So, being able to do all of this in an hour is a huge accomplishment. Additional comment. You can copy the large ZIP file from the bastion host to the bare metal server with rsync. It is MUCH faster than scp. (about 30 seconds). here is the command: rsync LINUX.X64_193000_db_home.zip oracle@$BMSIP:/u01/app/oracle/product/19.3.0/dbhome_1/LINUX.X64_193000_db_home.zip Note that rsync does not by itself use encryption, which is probably the main reason that it is so much faster than scp. I don't think that is a concern in this context. The source file is available to anyone after signing up at OTN, and file integrity can be checked with md5sum or sha256sum.

Norbert K. · Reviewed מעל 2 שנים ago

Shashi K. · Reviewed מעל 2 שנים ago

This lab, as written, is difficult to achieve in 2 hours on the first try. ON my 3rd attempt, I was able to get through everything in 70 minutes, so it is doable. Here's what worked for me. Create an OTN account ahead of time. I could not grab the download URL and use it with curl to send the output to Google Cloud. So, what I did instead is download the oracle installer zip file to my PC, upload it to one of my own GCP storage buckets, make a signed URL. This is all done before starting the lab, and shaves off about 30 minutes from time that would otherwise be spent in the lab. With that done, start the lab, grab the zip file from GCS and move it from bastion to bare metal server. This scp step took about 15 minutes for me, and there's no obvious way to speed it up. Another issue I found is that the ansible playbook installer can abort and leave a half-installed Oracle DB. I could not figure out how to recover from this problem before my lab timed out. So, I started again, this time I kept my mouse cursor on top of the ssh session window the entire time. Possibly, if you move away from the ssh session (eg send an email or something like that) the session can time out, and this of course will leave the DB installation in an incomplete state. So, if you get an error message "ORA-65011: Pluggable database PDBORCL does not exist." at step 6 of Task 3, you should probably just quit the lab and start over. I got it all to work on the 3rd try, by using cloud shell and jiggling my mouse cursor every minute on the ssh session screen. After the DB is fully and correctly installed, the rest (Task 4) is straightforward. Advice to Google: Please come up with a better way to get the Oracle installer zip file onto the bastion host. The current procedure is both hacky and slow. Advice to some other reviewers. Oracle software is commercial software and can only be downloaded in accordance with Oracle's terms. This is why every student needs to create a separate OTN account and download their own copy of the large ZIP file. Putting this file onto github or similar repo would violate Oracle's conditions. It might be good to point out that Oracle software is large, complex and very powerful. Anyone who has built an Oracle DB from scratch, including installing an OS on a bare metal machine, knows that doing all of that manually can easily take a day or more. So, being able to do all of this in an hour is a huge accomplishment.

Norbert K. · Reviewed מעל 2 שנים ago

Shashi K. · Reviewed מעל 2 שנים ago

Rafael D. · Reviewed מעל 2 שנים ago

Dazahet M. · Reviewed מעל 2 שנים ago

Leela N. · Reviewed מעל 2 שנים ago

Nice Lab with good hands-on understanding

Ganesh J. · Reviewed מעל 2 שנים ago

Shriyansh s. · Reviewed מעל 2 שנים ago

Davor V. · Reviewed מעל 2 שנים ago