How to create a new connection in oracle sql developer
To create a new connection in Oracle SQL Developer, follow these steps:
- Launch Oracle SQL Developer: Open Oracle SQL Developer on your computer.
- Click on the "Connections" tab: In the top menu bar, click on "View" and then select "Connections" or use the keyboard shortcut Ctrl + 6 (Windows) or Command + 6 (Mac).
- Click on the "New" button: In the Connections tab, click on the "New" button (or press Ctrl + N on Windows or Command + N on Mac).
- Enter the connection details: In the "Create New Database Connection" dialog box, enter the following information:
- Username: Enter the username you want to use to connect to the database.
- Password: Enter the password for the username.
- Hostname: Enter the hostname or IP address of the database server.
- Port: Enter the port number used by the database server (default is 1521).
- SID: Enter the Service ID (SID) of the database instance (optional).
- Database: Enter the name of the database you want to connect to (optional).
- Choose the connection type: Select the type of connection you want to create:
- Basic: Connect to a database using a username and password.
- TNS: Connect to a database using a TNS (Transparent Network Substrate) connection.
- Easy Connect: Connect to a database using a simple connection string.
- Click "Connect": Click the "Connect" button to establish the connection.
- Save the connection: If you want to save the connection, click "OK" to save it as a new connection in the Connections tab.
Alternatively, you can also create a new connection by clicking on the "File" menu and selecting "New" > "Database Connection" or by using the keyboard shortcut Ctrl + Shift + N (Windows) or Command + Shift + N (Mac).
Note: Make sure you have the correct Oracle client software installed on your computer and that the database server is running and accessible before attempting to create a new connection.