How to connect after creating a user in SQL*Plus?

To connect to a newly created user in SQL*Plus, you can follow these steps:

  1. Open the command prompt or terminal window.
  2. accessing SQLplus
  3. Enter the connection information:
SQL> connect username/password@hostname:port/service_name

其中:among them

  1. The username is the username of a newly created user.
  2. The password is for newly created users.
  3. The hostname is the name or IP address of the database server.
  4. The port is the default port number of the database server, which is 1521.
  5. service_name is the service name of the database.
  1. Press the Enter key and wait for the connection to be successful.

After successfully connecting, you will see a prompt similar to the following in SQL*Plus:

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

Now you can perform SQL queries and commands in SQL*Plus.

bannerAds