Oracle Database Configuration Week 8

Today we will discuss building our own Oracle Database 10g & 21c; These will be our test environment, creating SQL queries and learning Oracle Database Administration. In addition, we will be configuring our Oracle database inside the windows environment on a Type II Hypervisor container in VMware. Finally, if you want to keep up with the Oracle database journey today, we will configure our environment and prepare to use Oracle Database Administration.?

Oracle Database 10g?

Oracle Database 10g Express edition is a little outdated but uses grid computing to provide resources to assets. In addition, Oracle 10g uses a dedicated blade server rack, which provides all help to allow Oracle to function correctly properly. Oracle 10g is likely to have more hardware base architecture and is costly. The "g" at the end of the database version stands for grid computing.?

• Remember: "g" means grid computing.

Oracle Database 21c

Oracle 21c is the most recent Oracle Cloud database version released by Oracle. It uses a cloud-based approach compared to grid computing and server blade racks. Oracle has become beneficial in developing cloud technology from a grid computing standpoint. Oracle 21c has a lot more advancement compared to the more long-term release Oracle 19c, so for this course, I recommend downloading 19c or 21c.?

• Remember: "c" means cloud computing.

SQLPlus?

When interacting with the Oracle database, we will use SqlPlus to conduct our queues and database management activity. For example, if we want complete access to our database, we can log into SQL Plus and access our database.?

We can perform many actions using SQL plus, such as examining our database tables and objects, Developing our batch scripts, Verifying the Database table's space & memory, and essentially performing database administration tasks. Listed below is the documentation that discusses how to use SQL Plus. I would keep this saved as we dig deeper into SQL Plus in later articles.?

• SQL PLUS DOCUMENTATION https://docs.oracle.com/cd/B19306_01/server.102/b14357/ch4.htm#CHDGEEFE

Installing Oracle Database 10g?& 21c

I linked beneficial videos that will help you set up your Oracle Database 10g & 21c that we will need to continue our learning journey using Oracle database technology.

• Installation Video:?https://youtu.be/Fh-1eO8SA9o
• Oracle Database 10g File: https://drive.google.com/file/d/1_LGZZOL9x2HUSArVoy2M4Sl6eCJ1JZqw/view
• Installation Video Oracle 21c: https://youtu.be/ZKVpFZEoFOY