Use Oracle SQLDeveloper to connect to the database and create a user

1. Use the sys account to create a database connection

The installation of Oracle 11g will bring a tool called SQL Developer. It has very powerful functions and has never been known before. It also uses plsqldev and navicat to connect to the database, in fact, this tool has all the functions of the previous two software (if you say it is absolutely correct ). First, open SQL Developer, as shown in:

SQL Developer cannot be used to create an Oracle Database. It can only be used to connect to the created Database. We generally use Database Configuration Assistant (DBCA) to create a Database, as shown in:

After you open DBCA, follow the Wizard to create a database, which is very simple and will not be described here.

In SQL Developer, create a connection and click the "Green plus sign" in the upper left corner, as shown in:

Create a database connection, as shown in:

After completing the configuration, click "Test" to Test whether the database connection is correct, as shown in. "Status: Success" in the lower left corner indicates that the database connection is correct.

1 2 Next Page