Understand Virtual Machines, IP Addressing, and the Linux vs Windows distinction — the three pillars every Oracle DBA must master before touching a production server.
Three essential topics. Each one broken into Explanation, Key Points, DBA Relevance, and a real Scenario. Click any tab to begin.
A Virtual Machine (VM) is a software-based computer that runs inside your real computer. It behaves exactly like a physical machine — it has its own operating system, storage, memory, and network — but it exists entirely as software.
A layer of software called a hypervisor (e.g., VMware, VirtualBox, Hyper-V) sits between the physical hardware and the VM. It carves up the host machine's resources and allocates them to one or more VMs, each completely isolated from the others.
Think of it like an app on your computer that pretends to be an entirely separate computer — it has its own desktop, files, and operating system, but it's really just a program running on your actual hardware.
In our context, we use Oracle VirtualBox (free software) to run Oracle Linux or CentOS inside a VM — as if it is a real server on your laptop.
Common Mistake: "My laptop is slow — can I still use a VM?"
Yes, but allocate resources carefully. A basic Oracle practice VM needs at minimum 4 GB RAM assigned to the VM and 100–150 GB disk space. Remember your host OS also needs memory to run alongside it.
You connect to a cloud server at work via SSH, and it runs Oracle Database in a VM on a physical rack server in a data center. Your local VM setup mimics that exact architecture — helping you learn the real-world workflow before your first production day.
An IP address (Internet Protocol Address) is a unique numerical label assigned to every device connected to a network. It serves two main purposes: identifying a device and providing its location on the network — similar to how a home address identifies and locates a house.
The most common format, IPv4, uses 4 sets of numbers separated by dots (e.g. 192.168.1.105), while the newer IPv6 uses hexadecimal groups separated by colons.
Your router gets one public IP from your ISP and assigns private IPs to all devices in your home via DHCP. NAT (Network Address Translation) lets all your devices share one public IP.
As a DBA, you connect to Oracle servers using their IP address via SSH. Knowing whether you're connecting to a private LAN IP or a public remote IP is fundamental to your daily work.
192.168.1.105. Supports ~4.3 billion addresses.2001:0db8::7334. Virtually unlimited addresses.10.x.x.x | 172.16–31.x.x | 192.168.x.x127.0.0.1 — refers to your own machine. Used to test local services.Assigned by your ISP, visible on the internet. Example: 103.21.58.10. This is how the outside world sees your network.
Used within your home/office network. Example: 192.168.1.x. Not directly reachable from the internet.
Used by servers and printers. A database server always needs a static IP so DBAs can reliably connect.
Assigned automatically by DHCP. Most home devices use dynamic IPs — fine for laptops, not for servers.
255.255.255.0).192.168.1.1).google.com) into IP addresses — the "phone book" of the internet.ssh oracle@192.168.1.20 — knowing the IP is step one.ip a inside the VM to find it and SSH in from your host.Your manager gives you a new Oracle server to manage. Before you can connect, you need its IP. On Windows you run ipconfig, on Linux/Mac you use ip a or ifconfig.
Inside your VirtualBox VM running Oracle Linux, you need to find the VM's IP address to SSH into it from your Windows host. You open the terminal and run ip a to discover its private address.
Once you have the IP, you can connect from your Windows host using an SSH tool like PuTTY or Windows Terminal — just like a real DBA connecting to a remote production server.
When you setup a Virtual Machine and installed a Linux OS inside it, you will be looking at two different environments on your screen — Windows on the outside, Linux on the inside.
This naturally raises an important question: "They both look like operating systems. Why does Oracle DBA use Linux and not Windows?"
Linux is free, open-source, lighter, and faster. It powers ~96% of all servers worldwide. Windows dominates desktop but loses on the server side because of cost, resource usage, and compatibility with developer tools.
For a DBA, Linux is the preferred platform because Oracle was originally built for Unix, and most enterprise Oracle deployments run on Linux. Its permissions model, SSH connectivity, and stability make it the clear choice.
| Feature | Linux | Windows |
|---|---|---|
| Cost | Free & open-source | Paid license (~₹8,000–15,000+) |
| Developer | Community / Linus Torvalds | Microsoft |
| Server Market Share | ~96% servers | ~72% desktop |
| Source Code | Open (anyone can view/modify) | Closed / proprietary |
| Security | Fewer malware threats, strong permissions | Larger attack surface (popular target) |
| GUI on Servers | Usually none (terminal only) | Full graphical interface |
| Shell / CLI | Bash, Zsh — native & powerful | PowerShell / CMD — less standard |
| Oracle DBA Use | ✅ Standard choice | ⚠️ Possible but rare in production |
/home/oracle and /Home/Oracle are different paths./home/oracle ≠ /Home/Oracle — this trips up every Windows-trained beginner.You are a Windows user starting your Oracle DBA journey. You open a VirtualBox VM running Oracle Linux. The screen shows only a black terminal — no Start menu, no desktop icons, no right-click.
On Linux, you navigate using cd, list files with ls, and read files using cat or tail. Case sensitivity means a wrong capital letter causes "No such file or directory" errors.
After practicing in your VM, this terminal-only environment feels natural — which is exactly how you will work on every real Oracle production server for the rest of your DBA career.
Essential vocabulary from this module. Hover each card for details.
A software-based computer running inside a physical machine, managed by a hypervisor. Has its own OS, storage, memory, and network.
Software layer between hardware and VMs that allocates resources. Examples: VirtualBox, VMware, Hyper-V.
The real, physical computer running the hypervisor and your main OS (Windows or macOS).
The virtual machine running on top of the host — completely isolated from it and from other VMs.
A unique numerical label assigned to every networked device. Identifies the device and its location on the network.
Linux command to display network interfaces and IP addresses. Also: ifconfig. Windows equivalent: ipconfig.
IPv4 uses 4 dot-separated numbers (e.g. 192.168.1.1). IPv6 uses 8 hex groups (e.g. 2001:db8::1) for vastly more addresses.
Dynamic Host Configuration Protocol — automatically assigns IP addresses to devices on a network. Used by most home routers.
Domain Name System — translates human-readable names like google.com into IP addresses like 142.250.195.46.
Network Address Translation — lets multiple devices share one public IP. Your router uses NAT to manage all home devices.
Displays memory usage in human-readable format. Shows total, used, and free RAM — essential for VM resource checks.
Special IP that refers to your own machine. Used to test local services without sending traffic over a network.
Everything you need to recall at a glance. One concept per step.
8 questions covering VMs, IP Addressing, and Linux vs Windows. Click any option to answer.