{"id":1565,"date":"2017-02-05T16:47:46","date_gmt":"2017-02-05T15:47:46","guid":{"rendered":"https:\/\/clemente.pamplona.name\/dba\/?p=1565"},"modified":"2017-02-05T16:48:41","modified_gmt":"2017-02-05T15:48:41","slug":"comma-separated-alias-in-tnsnames-ora","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/comma-separated-alias-in-tnsnames-ora\/","title":{"rendered":"comma separated alias in tnsnames.ora"},"content":{"rendered":"<p>Today we are gonna see a easy way to maintain clear the tnsnames.ora <\/p>\n<p>Lets see our file:<\/p>\n<pre>\r\nPROD=\r\n  (DESCRIPTION=\r\n     (ADDRESS=(PROTOCOL=tcp)(HOST=host1)(PORT=1521))\r\n     (CONNECT_DATA=\r\n        (SERVICE_NAME=factura)\r\n     )\r\n  )\r\nPRODUCCION=\r\n  (DESCRIPTION=\r\n     (ADDRESS=(PROTOCOL=tcp)(HOST=host1)(PORT=1521))\r\n     (CONNECT_DATA=\r\n        (SERVICE_NAME=factura)\r\n     )\r\n  )\r\nFACTURACION=\r\n  (DESCRIPTION=\r\n     (ADDRESS=(PROTOCOL=tcp)(HOST=host1)(PORT=1521))\r\n     (CONNECT_DATA=\r\n        (SERVICE_NAME=factura)\r\n     )\r\n  )\r\n<\/pre>\n<p>As you can see, we have three identical entries for the same database. This makes our file bigger and more difficult to maintain.<br \/>\nHow can we solve it?<br \/>\nEasy, You can  specify multiple net_service_name separated by command in a single entry. <\/p>\n<p>This will be :<\/p>\n<pre>\r\nPROD,PRODUCCION,FACTURACION=\r\n  (DESCRIPTION=\r\n     (ADDRESS=(PROTOCOL=tcp)(HOST=host1)(PORT=1521))\r\n     (CONNECT_DATA=\r\n        (SERVICE_NAME=factura)\r\n     )\r\n  )\r\n<\/pre>\n<p>As you can see, easy and clear <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today we are gonna see a easy way to maintain clear the tnsnames.ora Lets see our file: PROD= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=host1)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=factura) ) ) PRODUCCION= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=host1)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=factura) ) ) FACTURACION= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=host1)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=factura) ) ) As you &hellip; <a href=\"http:\/\/clemente.pamplona.name\/dba\/comma-separated-alias-in-tnsnames-ora\/\">Sigue leyendo <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[565,567,273],"tags":[713,711],"class_list":["post-1565","post","type-post","status-publish","format-standard","hentry","category-11g-en","category-12c-en","category-sin-categoria-en","tag-comma-separated","tag-tnsnames-ora"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1565","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/comments?post=1565"}],"version-history":[{"count":2,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1565\/revisions"}],"predecessor-version":[{"id":1567,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1565\/revisions\/1567"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=1565"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=1565"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=1565"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}