How to create a Database Connection Using SQL Developer ?
Author: neptune | 22nd-Feb-2022
To create a database connection:
- 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
DefaultorSYSDBA, 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):
- 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 !
#JavaScript #Hackerrank #Python #Motivation #AI #React.js #Testing #Interview #SQL #Selenium #LeetCode #Problem Solving #Machine learning #Java #GPT #AWS #API #IT #Algorithms #Github #Jobs #Microservice #Certifications #Projects #Google #Django #Story #Pip #Data Science #Postman #Health #Twitter #Elon Musk #Node.js
anonymous | Feb. 18, 2022, 12:54 a.m.
Awesome 😎