How to create a Database Connection Using SQL Developer ?

To create a database connection:

1. In the Connections navigator in SQL Developer, right-click the Connections node.
2. Then click New Connection.

   The New / Select Database Connection dialog box appears, with the Oracle tab displayed.

   Enter the following information:

   • In the Connection Name field, enter the name to use for this database connection.

   • In the Username field, enter the name of the user for whom this database connection is being created.

   • In the Password field, enter the password for the user.

   • In the Connection Type field, select the database connection type as per your DB.

     The connection types are:

     • Basic

     • TNS

     • LDAP

     • Advanced

     • Local/Bequeath

     
     

     
     
     
     

     
     

     When you choose a connection type, the fields below will change to be appropriate for the selected connection type. This example describes the fields for the Basic connection type.

   • In the Role field, select Default or SYSDBA, based on the role assigned to the user.

   • In the Hostname field, enter the name of the host where the database is located.

   • In the Port field, enter the port for the database.

   • In the SID field, enter the SID for the database (when the database connection is for a non-CDB user or for a multitenant container database (CDB) user):

     
     

     
     
3. In the Service name field, enter the service name for the pluggable database (PDB), including the domain name (when the database connection is for a PDB user):

4. Optionally, click Test to test that the data you provided will allow the specified user to connect to the database.

5. When you are finished, click Connect to connect using the database connection, or click Save to save the database creation.

Thanks for Reading !