{"id":125,"date":"2015-05-23T15:59:53","date_gmt":"2015-05-23T13:59:53","guid":{"rendered":"http:\/\/anjo.pt\/wp\/keyword-oracle\/?p=125"},"modified":"2015-11-17T20:27:22","modified_gmt":"2015-11-17T19:27:22","slug":"oracle-wallet-on-windows-registry-share-with-other-users","status":"publish","type":"post","link":"https:\/\/anjo.pt\/keyword-oracle\/2015\/05\/23\/oracle-wallet-on-windows-registry-share-with-other-users\/","title":{"rendered":"Oracle wallet on Windows registry &#8211; share with other users"},"content":{"rendered":"<p>I\u00a0installed Oracle wallet to access passwordless to the remote databases, so I could do backups without specifying the password on any script.<\/p>\n<p>The\u00a0sqlnet.ora has the following information concerning the wallet:<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nWALLET_LOCATION =\r\n(SOURCE =\r\n(METHOD = reg)\r\n(METHOD_DATA = (KEY = DEFAULT)))\r\n\r\nSQLNET.WALLET_OVERRIDE = TRUE\r\nSSL_CLIENT_AUTHENTICATION = FALSE\r\n<\/pre>\n<p>The other day, I got the need of giving access to remote databases to another windows user, so he could run a refresh schema\/database script.<\/p>\n<p>He was getting the following error when trying to access any database:<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nORA-12578: TNS:wallet open failed\r\n<\/pre>\n<p>While I could just have set a different TNS_ADMIN variable pointing to\u00a0a sqlnet.ora with<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nSQLNET.WALLET_OVERRIDE =\u00a0FALSE\r\n<\/pre>\n<p>this was not the solution for him to use an automatic script.<\/p>\n<p>The solution was to export\/import the following branch of the registry from my windows user to the other windows user:<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n\\\\HKEY_CURRENT_USER\\SOFTWARE\\ORACLE\\WALLETS\r\n<\/pre>\n<p>Note that these entries contain the encrypted password to the wallet, allowing the user to add\/remove\/modify\/see the contents, including passwords, of the current wallet.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I\u00a0installed Oracle wallet to access passwordless to the remote databases, so I could do backups without specifying the password on any script. The\u00a0sqlnet.ora has the following information concerning the wallet: WALLET_LOCATION = (SOURCE = (METHOD = reg) (METHOD_DATA = (KEY = DEFAULT))) SQLNET.WALLET_OVERRIDE = TRUE SSL_CLIENT_AUTHENTICATION = FALSE The other day, I got the need [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,2,9],"tags":[],"class_list":["post-125","post","type-post","status-publish","format-standard","category-oracle","category-oracle-11g","category-security","czr-hentry"],"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/125","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/comments?post=125"}],"version-history":[{"count":1,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/125\/revisions"}],"predecessor-version":[{"id":126,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/125\/revisions\/126"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=125"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=125"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}