Thursday , June 13 2024

How To Connect To Oracle With Toad

To connect to Oracle with Toad, you need to download and install Toad.

TNS Information

You must write the tns information of the database you want to connect to the TNSNAMES.ora file.

You can find the file by searching the tnsnames.ora file under the app folder in your operating system.

Below you can see an example of a tns information.

You can use the article titled “How To Find Oracle  Service Name (SERVICE_NAME parameter on TNS)” to find out what you will write in SERVICE_NAME.

Connect To Oracle With Toad

After writing tns information, open Toad and click on new connection as below.

On the screen that appears, we find the database in the Database tab on the right side, and click on connect.

The names that appear in the list here are the names you write in place of “databasetoconnect” in tns information.

Next, on the screen below we write a username, which is previously defined and authorized to connect to oracle.

We will write the database name to the Database section and click OK.

If there is no problem with your permissions and your TNS, you will be connected to the database.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *