How to set up Oracle 19c database on local

Please follow the below steps to set up oracle on your local machine

1. Login to Oracle website

https://www.oracle.com/in/database/technologies/oracle-database-software-downloads.html

2. Choose the below option and click on Download option.

This will take you to login page, enter the user credentials and sign in. This will begin the download.

3. Extract the zip

Once the zipped file is downloaded successfully, copy it to a desired directory and then unzip it. Then go inside the extracted directory and find run.exe file as shown below.

4. Run setup.exe and follow below steps

Let the installation happen. This location will be the oracle database home directory for this installation. Click on Next and click on Install. Installation will happen like this

Click on close and finish the installation.

5. Create a database in Oracle 19C

Run the below command on command prompt

dbca -J-Doracle.assistants.dbca.validate.ConfigurationParams=false

Following window will appear.

Congratulations! You have successfully created your Oracle 19c database with DBCA

6. Test the database

To check if your database is running properly, you can:

start a new SQLPlus session with an administrative account.

or connect to EM Express with SYS administrative account. If everything is okay, you should see below screen.