|Lesson 2||Managing Database Object Prerequisites |
|Objective||Background and equipment required for this course. |
Managing Database Object Prerequisites
This course is designed for professionals who want to become certified Oracle database administrators. Managing an Oracle database requires a broad range of technical knowledge. In order to take this course, you need to be very comfortable working in your current operating environment.
Specifically, you should:
- Be comfortable installing and configuring software.
- Know your operating system reasonably well. You must be comfortable navigating to different directories, editing text files, copying files, running programs, and so forth.
- Have access to a text editor, such as NotePad or vi.
- Preferably have access to an Oracle12c or Oracle13c database, so you can follow along with the examples and create the course project. You can still take the course if you do not have access to Oracle12c; you will just have to skip the hands-on exercises.
- Have access to basic Oracle administrative tools, such as Structured Query Language (SQL)*Plus and Oracle Enterprise Manager.
Once again, without access to these tools you can still take the course, but you will not be able to completely finish the hands-on exercises
- Have a basic understanding of relational databases and how they are used.
- Be reasonably familiar with SQL. You do not need to be an expert, but you should be able to understand and write simple
SELECT statements. You need to understand what it means to join two tables, and know how to do that.
- Be comfortable using command-line utilities rather than using only a graphical user interface (GUI).
Hardware Requirements for installing Oracle 13c on a Windows 2019 server:
The following are the hardware requirements for installing Oracle 13c on a Windows 2019 server:
- Processor: Intel or AMD 64-bit processor with a minimum of 2 cores
- Memory: 8 GB of RAM, 16 GB or more recommended
- Disk space: 20 GB of free disk space for the Oracle installation, plus additional space for data files, log files, and temporary files
- Network interface: A network interface card (NIC) with a minimum of 100 Mbps bandwidth
The following are some additional recommendations:
- Use a server with a RAID configuration to protect your data.
- Use a dedicated server for Oracle if possible. This will improve performance and reliability.
- Make sure that your server has the latest Windows 2019 updates installed.
- Check the Oracle compatibility matrix to ensure that your hardware and software are compatible with Oracle 13c.
Here are some additional tips for installing Oracle 13c on a Windows 2019 server:
- Disable the Windows firewall before starting the installation.
- Create a dedicated user account for Oracle.
- Run the installation as an administrator.
- Make sure that you have all of the necessary prerequisites installed.
- Follow the instructions in the Oracle installation guide carefully.
For guidance on hardware requirements, you might consider looking at Oracle 12c or Oracle 19c requirements as a reference:
General Guidance for Oracle 12c/19c
- Processor: A processor with 2 GHz frequency or higher. Oracle typically recommends multiple-core processors.
- Memory: At least 2GB of RAM is recommended for Oracle database installations. However, for production use, you may need substantially more, depending on the workload.
- Swap Space: Oracle recommends having a swap space equivalent to the amount of RAM available.
- Disk Space: At least 10GB of free disk space for the Oracle software, depending on options selected. The database files would require additional space, which varies depending on your specific requirements.
- File System: NTFS is commonly used for Oracle installations on Windows environments.
- Network: A network adapter connected to a TCP/IP network.
- Administrative Privileges: Administrative access is required for installing Oracle software.
- Microsoft .NET Framework: Some Oracle components may require a specific version of Microsoft .NET Framework to be installed.
- Display: Oracle Universal Installer requires a minimum screen resolution of 1024 x 768.
It's important to note that the above are just general guidelines. For the most accurate and detailed information, consult Oracle's official documentation for the specific version you are interested in. They will provide not only hardware but also software prerequisites that might be essential for a smooth installation and operation of the database system.
You can run your Oracle database on UNIX, Linux, and Windows platforms;
Any examples specific to an operating system, and there are not many, will be provided in both Windows and UNIX versions. If you are taking this course using some other operating system, you will need to be comfortable translating a UNIX or Windows example into the appropriate commands for that system.
In earlier courses in this curriculum, you created a database, called
COIN, to hold the examples for this course. You also created a user within that database. This course will make use of these entities in our examples.
You do not have to use the database and user name given for your hands-on examples, but the course will refer to these entities throughout the instructions. Simply replace this database and user name with ones of your own choosing.