{"id":391,"date":"2018-06-22T08:42:18","date_gmt":"2018-06-22T08:42:18","guid":{"rendered":"http:\/\/dbtut.com\/?p=391"},"modified":"2020-07-27T12:12:50","modified_gmt":"2020-07-27T12:12:50","slug":"how-to-connect-to-oracle-with-toad","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/","title":{"rendered":"How To Connect To Oracle With Toad"},"content":{"rendered":"

To connect to Oracle with Toad, you need to download and install Toad.<\/span><\/p>\n

TNS Information<\/h3>\n

You must write the tns information of the database you want to connect to the TNSNAMES.ora file.<\/p>\n

You can find the file by searching the tnsnames.ora file under the app folder in your operating system.<\/p>\n

Below you can see an example of a tns information.<\/p>\n

You can use the article titled “How To Find Oracle\u00a0 Service Name (SERVICE_NAME parameter on TNS)<\/a>” to find out what you will write in SERVICE_NAME.<\/p>\n

databasetoconnect=\n(DESCRIPTION=\n(ADDRESS=\nPROTOCOL=TCP)\n(HOST=nodename-scan.domain.local)\n(PORT=1521)\n)\n(CONNECT_DATA=\n(SERVER=dedicated)\n(SERVICE_NAME=servicename)\n)\n)<\/pre>\n
Connect To Oracle With Toad<\/h3>\n
After writing tns information, open Toad and click on new connection as below.<\/p>\n
<\/p>\n
On the screen that appears, we find the database in the Database tab on the right side, and click on connect.<\/p>\n
The names that appear in the list here are the names you write in place of “databasetoconnect” in tns information.<\/p>\n
<\/p>\n
Next, on the screen below we write a username, which is previously defined and authorized to connect to oracle.<\/p>\n
We will write the database name to the Database section and click OK.<\/p>\n
If there is no problem with your permissions and your TNS, you will be connected to the database.<\/p>\n
<\/p>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
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 …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":16086,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[9825,426,434,9826,431,433,9821,9824,9822,9823,429,430,432,421,427,428,281],"class_list":["post-391","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-connect-to-oracle-database-using-toad","tag-connect-to-oracle-with-toad","tag-connect_data","tag-connecting-to-oracle-database-with-toad","tag-description","tag-host","tag-how-to-configure-tnsnames-ora-and-the-oracle-instant-client-to-connect-with-toad","tag-how-to-connect-oracle-database-with-toad","tag-how-to-connect-oracle-with-toad","tag-how-to-connect-toad-with-oracle","tag-new-connection","tag-oracle-toad","tag-port1521","tag-service_name","tag-tns","tag-tns-information","tag-toad"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":2422,"today_views":0},"yoast_head":"\nHow To Connect To Oracle With Toad - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Connect To Oracle With Toad\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Connect To Oracle With Toad - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Connect To Oracle With Toad\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-22T08:42:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-07-27T12:12:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-3.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"557\" \/>\n\t<meta property=\"og:image:height\" content=\"327\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Connect To Oracle With Toad\",\"datePublished\":\"2018-06-22T08:42:18+00:00\",\"dateModified\":\"2020-07-27T12:12:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/\"},\"wordCount\":208,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-3.jpg\",\"keywords\":[\"connect to oracle database using toad\",\"Connect To Oracle With Toad\",\"CONNECT_DATA\",\"connecting to oracle database with toad\",\"DESCRIPTION\",\"HOST=\",\"how to configure tnsnames.ora and the oracle instant client to connect with toad\",\"how to connect oracle database with toad\",\"how to connect oracle with toad\",\"how to connect toad with oracle\",\"New Connection\",\"Oracle TOAD\",\"PORT=1521\",\"service_name\",\"TNS\",\"TNS Information\",\"toad\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/\",\"name\":\"How To Connect To Oracle With Toad - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-3.jpg\",\"datePublished\":\"2018-06-22T08:42:18+00:00\",\"dateModified\":\"2020-07-27T12:12:50+00:00\",\"description\":\"How To Connect To Oracle With Toad\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-3.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-3.jpg\",\"width\":557,\"height\":327},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Connect To Oracle With Toad\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"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.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Connect To Oracle With Toad - Database Tutorials","description":"How To Connect To Oracle With Toad","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/","og_locale":"en_US","og_type":"article","og_title":"How To Connect To Oracle With Toad - Database Tutorials","og_description":"How To Connect To Oracle With Toad","og_url":"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/","og_site_name":"Database Tutorials","article_published_time":"2018-06-22T08:42:18+00:00","article_modified_time":"2020-07-27T12:12:50+00:00","og_image":[{"width":557,"height":327,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-3.jpg","type":"image\/jpeg"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Connect To Oracle With Toad","datePublished":"2018-06-22T08:42:18+00:00","dateModified":"2020-07-27T12:12:50+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/"},"wordCount":208,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-3.jpg","keywords":["connect to oracle database using toad","Connect To Oracle With Toad","CONNECT_DATA","connecting to oracle database with toad","DESCRIPTION","HOST=","how to configure tnsnames.ora and the oracle instant client to connect with toad","how to connect oracle database with toad","how to connect oracle with toad","how to connect toad with oracle","New Connection","Oracle TOAD","PORT=1521","service_name","TNS","TNS Information","toad"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/","url":"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/","name":"How To Connect To Oracle With Toad - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-3.jpg","datePublished":"2018-06-22T08:42:18+00:00","dateModified":"2020-07-27T12:12:50+00:00","description":"How To Connect To Oracle With Toad","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-3.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-3.jpg","width":557,"height":327},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/22\/how-to-connect-to-oracle-with-toad\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Connect To Oracle With Toad"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"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.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/391","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=391"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/391\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/16086"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}