Oracle Database Express Edition (XE)

Guide: Installing Oracle XE 21c on Windows 11 Home

Step 1: Prepare the Installation Folder

1. Create the folder C:\oracle21c\product\21c.

2. Open CMD as Administrator and run:

   • icacls c:\oracle21c /inheritancelevel:d
   • icacls c:\oracle21c /remove:g *s-1-5-11

   This ensures the installer has full control without interference from standard Windows Home restrictions.

Step 2: Configure Network Protocols

1. Go to Control Panel > Network and Sharing Center > Change adapter settings.
2. Right-click your active connection (Wi-Fi or Ethernet) > Properties.
3. Ensure "Client for Microsoft Networks" and "File and Printer Sharing" are checked.
4. Select IPv4 > Properties > Advanced > WINS tab.
5. Select "Enable NetBIOS over TCP/IP".

Step 3: Activate and Use the "Super Admin"

1. In CMD (Admin), type: net user administrator /active:yes.
2. Sign out of your account and sign in as the user Administrator.
3. Download the Oracle XE 21c installer while in this session.

Step 4: The Installation

1. Right-click setup.exe and select Run as Administrator.
2. Set your password (write it down!) and use the path created in Step 1.
3. Crucial: When the Windows Firewall pops up, check both "Private" and "Public" networks.
4. Wait for the finish screen (it will show you the Connection Strings).

Step 5: Grant Permissions to your Standard User

1. While still in the Admin session, open CMD and type whoami to get your computer name and username (e.g., LAPTOP\User).
2. Add your user to the Oracle group:
   • net localgroup ORA_DBA "LAPTOP\User" /add
3. Verify it worked: net localgroup ORA_DBA. Your name should be on the list.
4. Sign out and return to your normal Windows user.

Step 6: Set Up Environment Variables (The Gap)

1. In your normal user, click Start and type "Edit the system environment variables".
2. Click Environment Variables (bottom right).
3. Under System Variables, find Path > click Edit > click New.
4. Paste the path to the Oracle bin folder. It usually looks like this:
   • C:\oracle21c\product\21c\dbhomeXE\bin
5. Click New under System Variables to create a new one:
   • Variable Name: ORACLE_SID
   • Variable Value: XE
6. Click OK on all windows and restart any open CMD windows.

Step 7: Connect to SQL Developer (The Gap)

1. Open Oracle SQL Developer.
2. Click the green + (New Connection).
3. Fill in the following:
   • Name: Local_XE
   • Username: sys
   • Role: SYSDBA (Do not forget this!)
   • Password: (The one you set during installation)
   • Hostname: localhost
   • Port: 1521
   • SID: xe
4. Click Test. If it says Success, click Connect.

Final Maintenance Tip

Now that you are back in your normal user and everything works, you can go back to the CMD (Admin) and hide the super admin again for security: net user administrator /active:no

If you encounter any issue let me know so I can help you out. // It was formmated with IA since I am not the best giving instructions