Graphic tutorial for installing oracle19c and SQL developer in Windows 10

Time:2022-5-11

First register an Oracle account.

Prepare compressed packages for Oracle and SQL developer

Oracle download address: https://www.oracle.com/database/technologies/oracle-database-software-downloads.html#19c

SQL develoer download address: https://www.oracle.com/tools/downloads/sqldev-downloads.html

在这里插入图片描述
在这里插入图片描述

Oracle installation

1. After decompressing the Oracle compressed package, click setup ext

在这里插入图片描述

2. Select create single instance database

在这里插入图片描述

3. Select desktop class

在这里插入图片描述

4. Select a user

You can create a non administrator window user yourself. Here bloggers use virtual accounts directly.

在这里插入图片描述

5. Set the storage location of the database. You’d better follow the default path and don’t change it. Remember when the password is set

在这里插入图片描述

If there is such an error prompt, you can ignore it. It’s just that the set password does not meet the specifications of Oracle

在这里插入图片描述

6. After confirming the installation information, click Install

在这里插入图片描述

This prompt pops up during installation. Click allow access.

在这里插入图片描述

The installation process is a little long. Take your time

在这里插入图片描述

7. This completes the installation.

在这里插入图片描述

8. Access in local browser https://localhost:5500/em/login

User name: sys

Password: the password set by the previous installation

在这里插入图片描述

When this screen is displayed, Oracle will run normally.

在这里插入图片描述

Installation and use of SQL developer

1. After extracting SQL developer, run sqldeveloper exe

在这里插入图片描述

2. Click the top left corner of the new connection

在这里插入图片描述

3. Edit connection information

  • Name: you can name it casually
  • User name: System
  • Password: the default is the password filled in when creating.
  • Sid: the database name when the database is created. If it is not changed, it defaults to orcl.

在这里插入图片描述

4. Testing

Select the SQL statement to run and press F5 or the small green arrow.

在这里插入图片描述

5. Create a new user

Create user username identified by password;

Grant connect, resource, DBA to user name;

After that, you can also log in to the database with the new user, but you should give the user the permission to connect.

This is the end of this article about the graphic tutorial of installing oracle19c and SQL developer in Windows 10. For more information about installing oracle19c and SQL developer in Windows 10, please search the previous articles of developpaer or continue to browse the relevant articles below. I hope you will support developpaer in the future!