To create a database 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:
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
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):
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 !