Deploying the Oracle on Bare Metal Solution Reviews
5581 reviews
Pubg P. · Reviewed neredeyse 3 yıl ago
awful lab, a lot of errors for installing the database and after with Vertex, the proper zip file for installing db should be provided ASK [Unzip Oracle 19c Installer] ********************************************************************************************************************* fatal: [localhost]: FAILED! => {"ansible_facts": {"discovered_interpreter_python": "/usr/bin/python"}, "changed": true, "cmd": ["sh", "/u01/oracle-toolkit/scripts/1_setup.sh"], "delta": "0:00:00.007337", "end": "2023-05-16 10:04:30.813536", "msg": "non-zero return code", "rc": 9, "start": "2023-05-16 10:04:30.806199", "stderr": " End-of-central-directory signature not found. Either this file is not\n a zipfile, or it constitutes one disk of a multi-part archive. In the\n latter case the central directory and zipfile comment will be found on\n the last disk(s) of this archive.\nunzip: cannot find zipfile directory in one of LINUX.X64_193000_db_home.zip or\n LINUX.X64_193000_db_home.zip.zip, and cannot find LINUX.X64_193000_db_home.zip.ZIP, period.", "stderr_lines": [" End-of-central-directory signature not found. Either this file is not", " a zipfile, or it constitutes one disk of a multi-part archive. In the", " latter case the central directory and zipfile comment will be found on", " the last disk(s) of this archive.", "unzip: cannot find zipfile directory in one of LINUX.X64_193000_db_home.zip or", " LINUX.X64_193000_db_home.zip.zip, and cannot find LINUX.X64_193000_db_home.zip.ZIP, period."], "stdout": "Archive: LINUX.X64_193000_db_home.zip", "stdout_lines": ["Archive: LINUX.X64_193000_db_home.zip"]} ...ignoring TASK [Install Oracle 19c Software Only] *************************************************************************************************************** fatal: [localhost]: FAILED! => {"ansible_facts": {"discovered_interpreter_python": "/usr/bin/python"}, "changed": true, "cmd": ["sh", "/u01/oracle-toolkit/scripts/2_install_sw.sh"], "delta": "0:00:00.006035", "end": "2023-05-16 10:04:31.102654", "failed_when_result": true, "msg": "non-zero return code", "rc": 127, "start": "2023-05-16 10:04:31.096619", "stderr": "/u01/oracle-toolkit/scripts/2_install_sw.sh: line 4: ./runInstaller: No such file or directory", "stderr_lines": ["/u01/oracle-toolkit/scripts/2_install_sw.sh: line 4: ./runInstaller: No such file or directory"], "stdout": "", "stdout_lines": []} ...ignoring TASK [Perform Root Actions] *************************************************************************************************************************** fatal: [localhost]: FAILED! => {"ansible_facts": {"discovered_interpreter_python": "/usr/bin/python"}, "changed": true, "cmd": ["sh", "/u01/oracle-toolkit/scripts/3_root_actions.sh"], "delta": "0:00:00.006249", "end": "2023-05-16 10:04:31.501612", "msg": "non-zero return code", "rc": 127, "start": "2023-05-16 10:04:31.495363", "stderr": "/u01/oracle-toolkit/scripts/3_root_actions.sh: line 3: /u01/app/oraInventory/orainstRoot.sh: No such file or directory\n/u01/oracle-toolkit/scripts/3_root_actions.sh: line 4: /u01/app/oracle/product/19.3.0/dbhome_1/root.sh: No such file or directory", "stderr_lines": ["/u01/oracle-toolkit/scripts/3_root_actions.sh: line 3: /u01/app/oraInventory/orainstRoot.sh: No such file or directory", "/u01/oracle-toolkit/scripts/3_root_actions.sh: line 4: /u01/app/oracle/product/19.3.0/dbhome_1/root.sh: No such file or directory"], "stdout": "", "stdout_lines": []} ...ignoring TASK [Start Listener and Run DBCA] ******************************************************************************************************************** fatal: [localhost]: FAILED! => {"ansible_facts": {"discovered_interpreter_python": "/usr/bin/python"}, "changed": true, "cmd": ["sh", "/u01/oracle-toolkit/scripts/4_lsnr_dbca.sh"], "delta": "0:00:00.006603", "end": "2023-05-16 10:04:31.799541", "msg": "non-zero return code", "rc": 127, "start": "2023-05-16 10:04:31.792938", "stderr": "/u01/oracle-toolkit/scripts/4_lsnr_dbca.sh: line 4: lsnrctl: command not found\n/u01/oracle-toolkit/scripts/4_lsnr_dbca.sh: line 7: dbca: command not found", "stderr_lines": ["/u01/oracle-toolkit/scripts/4_lsnr_dbca.sh: line 4: lsnrctl: command not found", "/u01/oracle-toolkit/scripts/4_lsnr_dbca.sh: line 7: dbca: command not found"], "stdout": "", "stdout_lines": []} ...ignoring TASK [Update oratab] ********************************************************************************************************************************** fatal: [localhost]: FAILED! => {"ansible_facts": {"discovered_interpreter_python": "/usr/bin/python"}, "changed": true, "cmd": ["sh", "/u01/oracle-toolkit/scripts/5_oratab.sh"], "delta": "0:00:00.006627", "end": "2023-05-16 10:04:32.153292", "msg": "non-zero return code", "rc": 2, "start": "2023-05-16 10:04:32.146665", "stderr": "sed: can't read /etc/oratab: No such file or directory", "stderr_lines": ["sed: can't read /etc/oratab: No such file or directory"], "stdout": "", "stdout_lines": []} ...ignoring TASK [Set PDB to Open] ******************************************************************************************************************************** fatal: [localhost]: FAILED! => {"ansible_facts": {"discovered_interpreter_python": "/usr/bin/python"}, "changed": true, "cmd": ["sh", "/u01/oracle-toolkit/scripts/6_pdb_open.sh"], "delta": "0:00:00.005514", "end": "2023-05-16 10:04:32.466143", "msg": "non-zero return code", "rc": 127, "start": "2023-05-16 10:04:32.460629", "stderr": "/u01/oracle-toolkit/scripts/6_pdb_open.sh: line 3: sqlplus: command not found", "stderr_lines": ["/u01/oracle-toolkit/scripts/6_pdb_open.sh: line 3: sqlplus: command not found"], "stdout": "", "stdout_lines": []} ...ignoring TASK [Create DB Service] ****************************************************************************************************************************** fatal: [localhost]: FAILED! => {"ansible_facts": {"discovered_interpreter_python": "/usr/bin/python"}, "changed": true, "cmd": ["sh", "/u01/oracle-toolkit/scripts/7_set_dbora_service.sh"], "delta": "0:00:00.195402", "end": "2023-05-16 10:04:33.005473", "msg": "non-zero return code", "rc": 3, "start": "2023-05-16 10:04:32.810071", "stderr": "Job for dbora.service failed because the control process exited with error code. See \"systemctl status dbora.service\" and \"journalctl -xe\" for details.", "stderr_lines": ["Job for dbora.service failed because the control process exited with error code. See \"systemctl status dbora.service\" and \"journalctl -xe\" for details."], "stdout": "● dbora.service - Oracle Database Service\n Loaded: loaded (/usr/lib/systemd/system/dbora.service; enabled; vendor preset: disabled)\n Active: failed (Result: exit-code) since Tue 2023-05-16 10:04:32 UTC; 8ms ago\n Process: 27801 ExecStart=/u01/app/oracle/product/19.3.0/dbhome_1/bin/dbstart /u01/app/oracle/product/19.3.0/dbhome_1 (code=exited, status=203/EXEC)\n\nMay 16 10:04:32 bms-rhel-instance systemd[1]: Starting Oracle Database Service...\nMay 16 10:04:32 bms-rhel-instance systemd[27801]: Failed at step EXEC spawning /u01/app/oracle/product/19.3.0/dbhome_1/bin/dbstart: No such file or directory\nMay 16 10:04:32 bms-rhel-instance systemd[1]: dbora.service: control process exited, code=exited status=203\nMay 16 10:04:32 bms-rhel-instance systemd[1]: Failed to start Oracle Database Service.\nMay 16 10:04:32 bms-rhel-instance systemd[1]: Unit dbora.service entered failed state.\nMay 16 10:04:32 bms-rhel-instance systemd[1]: dbora.service failed.", "stdout_lines": ["● dbora.service - Oracle Database Service", " Loaded: loaded (/usr/lib/systemd/system/dbora.service; enabled; vendor preset: disabled)", " Active: failed (Result: exit-code) since Tue 2023-05-16 10:04:32 UTC; 8ms ago", " Process: 27801 ExecStart=/u01/app/oracle/product/19.3.0/dbhome_1/bin/dbstart /u01/app/oracle/product/19.3.0/dbhome_1 (code=exited, status=203/EXEC)", "", "May 16 10:04:32 bms-rhel-instance systemd[1]: Starting Oracle Database Service...", "May 16 10:04:32 bms-rhel-instance systemd[27801]: Failed at step EXEC spawning /u01/app/oracle/product/19.3.0/dbhome_1/bin/dbstart: No such file or directory", "May 16 10:04:32 bms-rhel-instance systemd[1]: dbora.service: control process exited, code=exited status=203", "May 16 10:04:32 bms-rhel-instance systemd[1]: Failed to start Oracle Database Service.", "May 16 10:04:32 bms-rhel-instance systemd[1]: Unit dbora.service entered failed state.", "May 16 10:04:32 bms-rhel-instance systemd[1]: dbora.service failed."]} ...ignoring PLAY RECAP ******************************************************************************************************************************************** localhost : ok=7 changed=7 unreachable=0 failed=0 skipped=0 rescued=0 ignored=7 [oracle@bms-rhel-instance dbhome_1]$ cd /u01/app/oracle/product/19.3.0/dbhome_1 [oracle@bms-rhel-instance dbhome_1]$ unzip LINUX.X64_193000_db_home.zip -d $ORACLE_HOME Archive: LINUX.X64_193000_db_home.zip End-of-central-directory signature not found. Either this file is not a zipfile, or it constitutes one disk of a multi-part archive. In the latter case the central directory and zipfile comment will be found on the last disk(s) of this archive. unzip: cannot find zipfile directory in one of LINUX.X64_193000_db_home.zip or LINUX.X64_193000_db_home.zip.zip, and cannot find LINUX.X64_193000_db_home.zip.ZIP, period. [oracle@bms-rhel-instance dbhome_1]$ ls -ltr
Evelina A. · Reviewed neredeyse 3 yıl ago
awful lab, a lot of errors for installing the database and after with Vertex, the proper zip file for installing db should be provided ASK [Unzip Oracle 19c Installer] ********************************************************************************************************************* fatal: [localhost]: FAILED! => {"ansible_facts": {"discovered_interpreter_python": "/usr/bin/python"}, "changed": true, "cmd": ["sh", "/u01/oracle-toolkit/scripts/1_setup.sh"], "delta": "0:00:00.007337", "end": "2023-05-16 10:04:30.813536", "msg": "non-zero return code", "rc": 9, "start": "2023-05-16 10:04:30.806199", "stderr": " End-of-central-directory signature not found. Either this file is not\n a zipfile, or it constitutes one disk of a multi-part archive. In the\n latter case the central directory and zipfile comment will be found on\n the last disk(s) of this archive.\nunzip: cannot find zipfile directory in one of LINUX.X64_193000_db_home.zip or\n LINUX.X64_193000_db_home.zip.zip, and cannot find LINUX.X64_193000_db_home.zip.ZIP, period.", "stderr_lines": [" End-of-central-directory signature not found. Either this file is not", " a zipfile, or it constitutes one disk of a multi-part archive. In the", " latter case the central directory and zipfile comment will be found on", " the last disk(s) of this archive.", "unzip: cannot find zipfile directory in one of LINUX.X64_193000_db_home.zip or", " LINUX.X64_193000_db_home.zip.zip, and cannot find LINUX.X64_193000_db_home.zip.ZIP, period."], "stdout": "Archive: LINUX.X64_193000_db_home.zip", "stdout_lines": ["Archive: LINUX.X64_193000_db_home.zip"]} ...ignoring TASK [Install Oracle 19c Software Only] *************************************************************************************************************** fatal: [localhost]: FAILED! => {"ansible_facts": {"discovered_interpreter_python": "/usr/bin/python"}, "changed": true, "cmd": ["sh", "/u01/oracle-toolkit/scripts/2_install_sw.sh"], "delta": "0:00:00.006035", "end": "2023-05-16 10:04:31.102654", "failed_when_result": true, "msg": "non-zero return code", "rc": 127, "start": "2023-05-16 10:04:31.096619", "stderr": "/u01/oracle-toolkit/scripts/2_install_sw.sh: line 4: ./runInstaller: No such file or directory", "stderr_lines": ["/u01/oracle-toolkit/scripts/2_install_sw.sh: line 4: ./runInstaller: No such file or directory"], "stdout": "", "stdout_lines": []} ...ignoring TASK [Perform Root Actions] *************************************************************************************************************************** fatal: [localhost]: FAILED! => {"ansible_facts": {"discovered_interpreter_python": "/usr/bin/python"}, "changed": true, "cmd": ["sh", "/u01/oracle-toolkit/scripts/3_root_actions.sh"], "delta": "0:00:00.006249", "end": "2023-05-16 10:04:31.501612", "msg": "non-zero return code", "rc": 127, "start": "2023-05-16 10:04:31.495363", "stderr": "/u01/oracle-toolkit/scripts/3_root_actions.sh: line 3: /u01/app/oraInventory/orainstRoot.sh: No such file or directory\n/u01/oracle-toolkit/scripts/3_root_actions.sh: line 4: /u01/app/oracle/product/19.3.0/dbhome_1/root.sh: No such file or directory", "stderr_lines": ["/u01/oracle-toolkit/scripts/3_root_actions.sh: line 3: /u01/app/oraInventory/orainstRoot.sh: No such file or directory", "/u01/oracle-toolkit/scripts/3_root_actions.sh: line 4: /u01/app/oracle/product/19.3.0/dbhome_1/root.sh: No such file or directory"], "stdout": "", "stdout_lines": []} ...ignoring TASK [Start Listener and Run DBCA] ******************************************************************************************************************** fatal: [localhost]: FAILED! => {"ansible_facts": {"discovered_interpreter_python": "/usr/bin/python"}, "changed": true, "cmd": ["sh", "/u01/oracle-toolkit/scripts/4_lsnr_dbca.sh"], "delta": "0:00:00.006603", "end": "2023-05-16 10:04:31.799541", "msg": "non-zero return code", "rc": 127, "start": "2023-05-16 10:04:31.792938", "stderr": "/u01/oracle-toolkit/scripts/4_lsnr_dbca.sh: line 4: lsnrctl: command not found\n/u01/oracle-toolkit/scripts/4_lsnr_dbca.sh: line 7: dbca: command not found", "stderr_lines": ["/u01/oracle-toolkit/scripts/4_lsnr_dbca.sh: line 4: lsnrctl: command not found", "/u01/oracle-toolkit/scripts/4_lsnr_dbca.sh: line 7: dbca: command not found"], "stdout": "", "stdout_lines": []} ...ignoring TASK [Update oratab] ********************************************************************************************************************************** fatal: [localhost]: FAILED! => {"ansible_facts": {"discovered_interpreter_python": "/usr/bin/python"}, "changed": true, "cmd": ["sh", "/u01/oracle-toolkit/scripts/5_oratab.sh"], "delta": "0:00:00.006627", "end": "2023-05-16 10:04:32.153292", "msg": "non-zero return code", "rc": 2, "start": "2023-05-16 10:04:32.146665", "stderr": "sed: can't read /etc/oratab: No such file or directory", "stderr_lines": ["sed: can't read /etc/oratab: No such file or directory"], "stdout": "", "stdout_lines": []} ...ignoring TASK [Set PDB to Open] ******************************************************************************************************************************** fatal: [localhost]: FAILED! => {"ansible_facts": {"discovered_interpreter_python": "/usr/bin/python"}, "changed": true, "cmd": ["sh", "/u01/oracle-toolkit/scripts/6_pdb_open.sh"], "delta": "0:00:00.005514", "end": "2023-05-16 10:04:32.466143", "msg": "non-zero return code", "rc": 127, "start": "2023-05-16 10:04:32.460629", "stderr": "/u01/oracle-toolkit/scripts/6_pdb_open.sh: line 3: sqlplus: command not found", "stderr_lines": ["/u01/oracle-toolkit/scripts/6_pdb_open.sh: line 3: sqlplus: command not found"], "stdout": "", "stdout_lines": []} ...ignoring TASK [Create DB Service] ****************************************************************************************************************************** fatal: [localhost]: FAILED! => {"ansible_facts": {"discovered_interpreter_python": "/usr/bin/python"}, "changed": true, "cmd": ["sh", "/u01/oracle-toolkit/scripts/7_set_dbora_service.sh"], "delta": "0:00:00.195402", "end": "2023-05-16 10:04:33.005473", "msg": "non-zero return code", "rc": 3, "start": "2023-05-16 10:04:32.810071", "stderr": "Job for dbora.service failed because the control process exited with error code. See \"systemctl status dbora.service\" and \"journalctl -xe\" for details.", "stderr_lines": ["Job for dbora.service failed because the control process exited with error code. See \"systemctl status dbora.service\" and \"journalctl -xe\" for details."], "stdout": "● dbora.service - Oracle Database Service\n Loaded: loaded (/usr/lib/systemd/system/dbora.service; enabled; vendor preset: disabled)\n Active: failed (Result: exit-code) since Tue 2023-05-16 10:04:32 UTC; 8ms ago\n Process: 27801 ExecStart=/u01/app/oracle/product/19.3.0/dbhome_1/bin/dbstart /u01/app/oracle/product/19.3.0/dbhome_1 (code=exited, status=203/EXEC)\n\nMay 16 10:04:32 bms-rhel-instance systemd[1]: Starting Oracle Database Service...\nMay 16 10:04:32 bms-rhel-instance systemd[27801]: Failed at step EXEC spawning /u01/app/oracle/product/19.3.0/dbhome_1/bin/dbstart: No such file or directory\nMay 16 10:04:32 bms-rhel-instance systemd[1]: dbora.service: control process exited, code=exited status=203\nMay 16 10:04:32 bms-rhel-instance systemd[1]: Failed to start Oracle Database Service.\nMay 16 10:04:32 bms-rhel-instance systemd[1]: Unit dbora.service entered failed state.\nMay 16 10:04:32 bms-rhel-instance systemd[1]: dbora.service failed.", "stdout_lines": ["● dbora.service - Oracle Database Service", " Loaded: loaded (/usr/lib/systemd/system/dbora.service; enabled; vendor preset: disabled)", " Active: failed (Result: exit-code) since Tue 2023-05-16 10:04:32 UTC; 8ms ago", " Process: 27801 ExecStart=/u01/app/oracle/product/19.3.0/dbhome_1/bin/dbstart /u01/app/oracle/product/19.3.0/dbhome_1 (code=exited, status=203/EXEC)", "", "May 16 10:04:32 bms-rhel-instance systemd[1]: Starting Oracle Database Service...", "May 16 10:04:32 bms-rhel-instance systemd[27801]: Failed at step EXEC spawning /u01/app/oracle/product/19.3.0/dbhome_1/bin/dbstart: No such file or directory", "May 16 10:04:32 bms-rhel-instance systemd[1]: dbora.service: control process exited, code=exited status=203", "May 16 10:04:32 bms-rhel-instance systemd[1]: Failed to start Oracle Database Service.", "May 16 10:04:32 bms-rhel-instance systemd[1]: Unit dbora.service entered failed state.", "May 16 10:04:32 bms-rhel-instance systemd[1]: dbora.service failed."]} ...ignoring PLAY RECAP ******************************************************************************************************************************************** localhost : ok=7 changed=7 unreachable=0 failed=0 skipped=0 rescued=0 ignored=7 [oracle@bms-rhel-instance dbhome_1]$ cd /u01/app/oracle/product/19.3.0/dbhome_1 [oracle@bms-rhel-instance dbhome_1]$ unzip LINUX.X64_193000_db_home.zip -d $ORACLE_HOME Archive: LINUX.X64_193000_db_home.zip End-of-central-directory signature not found. Either this file is not a zipfile, or it constitutes one disk of a multi-part archive. In the latter case the central directory and zipfile comment will be found on the last disk(s) of this archive. unzip: cannot find zipfile directory in one of LINUX.X64_193000_db_home.zip or LINUX.X64_193000_db_home.zip.zip, and cannot find LINUX.X64_193000_db_home.zip.ZIP, period. [oracle@bms-rhel-instance dbhome_1]$ ls -ltr
Evelina A. · Reviewed neredeyse 3 yıl ago
Shahrukh K. · Reviewed neredeyse 3 yıl ago
Jayadas C. · Reviewed neredeyse 3 yıl ago
Task 1, steps 5 and 6 should clarify that this can be done in one window.
Cory J. · Reviewed neredeyse 3 yıl ago
Jorge d. · Reviewed neredeyse 3 yıl ago
lot of errors
Pedro Paulo M. · Reviewed neredeyse 3 yıl ago
Ramakoteswara P. · Reviewed neredeyse 3 yıl ago
Ramakoteswara P. · Reviewed neredeyse 3 yıl ago
Yarema M. · Reviewed neredeyse 3 yıl ago
Jordi M. · Reviewed neredeyse 3 yıl ago
Caio B. · Reviewed neredeyse 3 yıl ago
Ryan L. · Reviewed neredeyse 3 yıl ago
jal s. · Reviewed neredeyse 3 yıl ago
Eliott S. · Reviewed neredeyse 3 yıl ago
SHAIK F. · Reviewed neredeyse 3 yıl ago
Angel Ricardo P. · Reviewed neredeyse 3 yıl ago
Juan Gustavo G. · Reviewed neredeyse 3 yıl ago
Scott M. · Reviewed neredeyse 3 yıl ago
Pablo C. · Reviewed neredeyse 3 yıl ago
Silas J. · Reviewed neredeyse 3 yıl 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 neredeyse 3 yıl ago
Shashi K. · Reviewed neredeyse 3 yıl ago
Shashi K. · Reviewed neredeyse 3 yıl ago
We do not ensure the published reviews originate from consumers who have purchased or used the products. Reviews are not verified by Google.