How to create a new connection in oracle sql developer

To create a new connection in Oracle SQL Developer, follow these steps:

  1. Launch Oracle SQL Developer: Open Oracle SQL Developer on your computer.
  2. 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).
  3. 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).
  4. 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).
  5. 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.
  6. Click "Connect": Click the "Connect" button to establish the connection.
  7. 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.