Deploying the Oracle on Bare Metal Solution avaliações

Ramakoteswara P. · Revisado há over 2 years

Yarema M. · Revisado há over 2 years

Jordi M. · Revisado há over 2 years

Caio B. · Revisado há over 2 years

Ryan L. · Revisado há over 2 years

jal s. · Revisado há over 2 years

Eliott S. · Revisado há over 2 years

SHAIK F. · Revisado há over 2 years

Angel Ricardo P. · Revisado há over 2 years

Juan Gustavo G. · Revisado há over 2 years

Scott M. · Revisado há over 2 years

Pablo C. · Revisado há over 2 years

Silas J. · Revisado há over 2 years

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. · Revisado há over 2 years

Shashi K. · Revisado há over 2 years

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. · Revisado há over 2 years

Shashi K. · Revisado há over 2 years

Rafael D. · Revisado há over 2 years

Dazahet M. · Revisado há over 2 years

Leela N. · Revisado há over 2 years

Nice Lab with good hands-on understanding

Ganesh J. · Revisado há over 2 years

Shriyansh s. · Revisado há over 2 years

Davor V. · Revisado há over 2 years