Deploying the Oracle on Bare Metal Solution Ulasan

Ramakoteswara P. · Diulas lebih dari 2 tahun lalu

Yarema M. · Diulas lebih dari 2 tahun lalu

Jordi M. · Diulas lebih dari 2 tahun lalu

Caio B. · Diulas lebih dari 2 tahun lalu

Ryan L. · Diulas lebih dari 2 tahun lalu

jal s. · Diulas lebih dari 2 tahun lalu

Eliott S. · Diulas lebih dari 2 tahun lalu

SHAIK F. · Diulas lebih dari 2 tahun lalu

Angel Ricardo P. · Diulas lebih dari 2 tahun lalu

Juan Gustavo G. · Diulas lebih dari 2 tahun lalu

Scott M. · Diulas lebih dari 2 tahun lalu

Pablo C. · Diulas lebih dari 2 tahun lalu

Silas J. · Diulas lebih dari 2 tahun lalu

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. · Diulas lebih dari 2 tahun lalu

Shashi K. · Diulas lebih dari 2 tahun lalu

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. · Diulas lebih dari 2 tahun lalu

Shashi K. · Diulas lebih dari 2 tahun lalu

Rafael D. · Diulas lebih dari 2 tahun lalu

Dazahet M. · Diulas lebih dari 2 tahun lalu

Leela N. · Diulas lebih dari 2 tahun lalu

Nice Lab with good hands-on understanding

Ganesh J. · Diulas lebih dari 2 tahun lalu

Shriyansh s. · Diulas lebih dari 2 tahun lalu

Davor V. · Diulas lebih dari 2 tahun lalu