Connect to Oracle

To start using the server object, you should create and open a connection. If the server is empty, you need to create a new database.

Use Chat2DB to quickly connect to an Oracle server.

Official Documentation and Software:

• For complete information about Oracle, refer to the Official Documentation (opens in a new tab)
• To download Oracle database software, refer to Official Software Downloads (opens in a new tab)
• For more versions of Oracle JDBC drivers, refer to Official JDBC Driver Downloads (opens in a new tab)

Step 1: Create a New Connection

In the Toolbar, click the New icon (+), navigate to Data Source and select Oracle.

Step 2: Fill in the connection information

• Name: Customize the connection name for easy memorization
• Env: Select the connection environment, test, production, etc. to distinguish connections in different environments
• Storge: Select the connection storage type, currently supports local (LOCAL) and cloud (CLOUD)
• Host: Oracle server address, can be IP or domain name
• Port: Oracle server port, default is 1521
• Service type: Oracle server type, default is SID
• SID: Oracle server SID, optional, if not filled in, it will be automatically generated according to the above information
• Driver: Oracle driver, optional, there are thin, oci, oci8, etc., the default is thin
• Authentication: Oracle authentication method, username and password or no authentication required
• User: Oracle Username
• Password: Oracle password
• Database: Oracle database name, optional, if not filled in, it will connect to the default database
• URL: Oracle connection URL, optional, if not filled in, it will be automatically generated according to the above information
• Driver: Oracle driver, optional, if not filled in, it will be automatically identified according to the URL, you can also select it manually, and the driver configuration items will be displayed after manual selection
• SSH: Whether to use SSH connection, optional, if not filled in, it will not be used by default, and the SSH configuration items will be displayed after selection
• Advanced Configuration: Advanced configuration, optional, if not filled in, it will not be used by default, and the advanced configuration items will be displayed after selection

Step 3: Download driver

If you want to download Oracle's JDBC driver, click the Download Driver download button at the bottom of the dialog box. Of course, you can also manually upload your own driver (Upload driver)

Step 4: Configure SSH Channel (optional)

• USE SSH: Whether to use SSH channel

• SSH Host: SSH server address

• SSH Port: SSH server port, default 22

• Authentication: SSH authentication method, username and password or private key

• User: SSH username

• Password: SSH password

• Test the SSH connection: Test whether the SSH connection is normal

Step 5: Test the connection

Make sure that you can establish a connection to the database using the details provided.

To do this, click the test button in the lower left corner to test whether the connection is normal. If the connection is normal, it will show that the connection is successful, otherwise it will show that the connection failed. You can adjust the connection information according to the error message.

If there are any connection problems, refer to the Cannot connect to database (opens in a new tab) page.

Step 6: Save the connection

After the test connection is passed, click the Save button to save the connection information. The connection information will be displayed in the database list on the left. Click the connection information to view the connection details or delete the connection.