How to Connect PL/SQL Developer to Oracle Autonomous Transaction Processing (ATP)

Posted by kamus on November 26, 2019

Mode LastWriteTime Length Name ---- ------------- ------ ---- -a---- 2019/10/12 3:40 6661 cwallet.sso -a---- 2019/10/12 3:40 6616 ewallet.p12 -a---- 2019/10/12 3:40 3243 keystore.jks -a---- 2019/10/12 3:40 87 ojdbc.properties -a---- 2019/10/12 12:54 130 sqlnet.ora -a---- 2019/10/12 3:40 1776 tnsnames.ora -a---- 2019/10/12 3:40 3335 truststore.jks

需要修改sqlnet.ora文件，将WALLET_LOCATION的位置修改为解压之后的目录的绝对地址。在我的机器上，修改以后如下：

WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="C:\oracle\Wallet_DB201909261518")))
SSL_SERVER_DN_MATCH=yes

然后，设置Windows系统的环境变量TNS_ADMIN到wallet文件解压目录，设置方法不再赘述。设置完毕以后echo命令显示如下：

C:\oracle\Wallet_DB201909261518>echo %TNS_ADMIN%
C:\oracle\Wallet_DB201909261518

最后，启动PL/SQL Developer，新增Connection。

March 12, 2021 at 11:08 am

按这个配置方式，是不是意味着，如果我有俩个不同的环境用的不同的Wallet，那么我每次切换环境就必须重新配置一遍且无法同时连接俩个不同环境数据库，因为Wallet不一样。

March 12, 2021 at 12:02 pm

Oracle Cloud里有instance wallet和regional wallet的区别，如果直接下载regional wallet的话，可以访问同一个区域的所有实例。
参考这个链接：
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbconnecting.htm#AboutDownloadingClientCredentials

我搜到一个解决方案，实测有效。跨域也可以的，不用被限制在同一区域的数据库实例：
https://smart4solutions.nl/blog/oci-connections-to-multiple-autonomous-transaction-databases-in-the-oracle-always-free-cloud/

我没有太看懂这个解决方案是怎么完成的？
security=(MY_WALLET_DIRECTORY = “C:\\Oracle\\wallets\\dev”
这里指向的目录跟文章中说创建的两个目录（devdomain和tstdomain），完全没有关系，是怎么找到密钥的呢？

October 28, 2021 at 5:44 pm

你通过本地的SQL*Plus可以顺利连接ADW吗？如果是连线关闭，可能是本地防火墙的问题？ADW那边没有什么额外需要设置的，只需要下载好Wallet之后，就是可以正常连接的。

Leave a Reply Cancel reply

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

Comment * </p><p class="comment-form-author"><label for="author">Name <span class="required">*</span></label> <input id="author" name="author" type="text" value="" size="30" maxlength="245" autocomplete="name" required=""/></p> <p class="comment-form-email"><label for="email">Email <span class="required">*</span></label> <input id="email" name="email" type="email" value="" size="30" maxlength="100" aria-describedby="email-notes" autocomplete="email" required=""/></p> <p class="comment-form-url"><label for="url">Website</label> <input id="url" name="url" type="url" value="" size="30" maxlength="200" autocomplete="url"/></p> </aside><aside id="recent-comments-2" class="widget widget_recent_comments"><h3 class="widget-title">Recent Comments</h3><ul id="recentcomments"><li class="recentcomments"><span class="comment-author-link">kamus</span> on <a href="https://www.dbform.com/2023/10/10/unlocking-the-power-key-features-of-mogdb/#comment-448772">Unlocking the Power: Key Features of MogDB</a></li><li class="recentcomments"><span class="comment-author-link">Jace</span> on <a href="https://www.dbform.com/2023/10/10/unlocking-the-power-key-features-of-mogdb/#comment-439639">Unlocking the Power: Key Features of MogDB</a></li><li class="recentcomments"><span class="comment-author-link">kamus</span> on <a href="https://www.dbform.com/2022/06/09/renew-alienware-alpha-r1-with-pop_os/#comment-355460">Renew Alienware Alpha R1 with Pop!_OS</a></li><li class="recentcomments"><span class="comment-author-link"><a href="https://www.dbform.com/2022/06/09/renew-alienware-alpha-r1-with-pop_os/" class="url" rel="ugc">Renew Alienware Alpha R1 with Pop!_OS – Channel [K]</a></span> on <a href="https://www.dbform.com/2021/12/19/make-a-perfect-terminal-experience-from-zero-in-3-steps/#comment-324208">Make a perfect terminal experience from zero in 3 steps</a></li><li class="recentcomments"><span class="comment-author-link"><a href="https://www.mobisoftinfotech.com" class="url" rel="ugc external nofollow">Richard Devis</a></span> on <a href="https://www.dbform.com/2021/12/19/make-a-perfect-terminal-experience-from-zero-in-3-steps/#comment-255169">Make a perfect terminal experience from zero in 3 steps</a></li></ul></aside><aside id="archives-2" class="widget widget_archive"><h3 class="widget-title">Archives</h3> <label class="screen-reader-text" for="archives-dropdown-2">Archives</label> <option value="">Select Month</option> <option value="https://www.dbform.com/2024/08/"> August 2024 (1)</option> <option value="https://www.dbform.com/2024/01/"> January 2024 (1)</option> <option value="https://www.dbform.com/2023/10/"> October 2023 (1)</option> <option value="https://www.dbform.com/2023/04/"> April 2023 (1)</option> <option value="https://www.dbform.com/2022/10/"> October 2022 (1)</option> <option value="https://www.dbform.com/2022/09/"> September 2022 (2)</option> <option value="https://www.dbform.com/2022/07/"> July 2022 (2)</option> <option value="https://www.dbform.com/2022/06/"> June 2022 (1)</option> <option value="https://www.dbform.com/2022/05/"> May 2022 (2)</option> <option value="https://www.dbform.com/2021/12/"> December 2021 (1)</option> <option value="https://www.dbform.com/2021/06/"> June 2021 (1)</option> <option value="https://www.dbform.com/2020/11/"> November 2020 (1)</option> <option value="https://www.dbform.com/2020/02/"> February 2020 (1)</option> <option value="https://www.dbform.com/2019/11/"> November 2019 (3)</option> <option value="https://www.dbform.com/2019/10/"> October 2019 (3)</option> <option value="https://www.dbform.com/2019/07/"> July 2019 (1)</option> <option value="https://www.dbform.com/2019/06/"> June 2019 (1)</option> <option value="https://www.dbform.com/2019/05/"> May 2019 (3)</option> <option value="https://www.dbform.com/2018/12/"> December 2018 (1)</option> <option value="https://www.dbform.com/2018/08/"> August 2018 (1)</option> <option value="https://www.dbform.com/2018/05/"> May 2018 (2)</option> <option value="https://www.dbform.com/2018/02/"> February 2018 (1)</option> <option value="https://www.dbform.com/2017/08/"> August 2017 (1)</option> <option value="https://www.dbform.com/2017/04/"> April 2017 (1)</option> <option value="https://www.dbform.com/2017/03/"> March 2017 (1)</option> <option value="https://www.dbform.com/2016/12/"> December 2016 (1)</option> <option value="https://www.dbform.com/2016/11/"> November 2016 (1)</option> <option value="https://www.dbform.com/2016/04/"> April 2016 (1)</option> <option value="https://www.dbform.com/2016/03/"> March 2016 (1)</option> <option value="https://www.dbform.com/2015/10/"> October 2015 (1)</option> <option value="https://www.dbform.com/2015/07/"> July 2015 (1)</option> <option value="https://www.dbform.com/2015/05/"> May 2015 (1)</option> <option value="https://www.dbform.com/2015/04/"> April 2015 (1)</option> <option value="https://www.dbform.com/2014/11/"> November 2014 (1)</option> <option value="https://www.dbform.com/2014/10/"> October 2014 (1)</option> <option value="https://www.dbform.com/2014/09/"> September 2014 (1)</option> <option value="https://www.dbform.com/2014/08/"> August 2014 (4)</option> <option value="https://www.dbform.com/2014/06/"> June 2014 (1)</option> <option value="https://www.dbform.com/2014/02/"> February 2014 (1)</option> <option value="https://www.dbform.com/2013/09/"> September 2013 (1)</option> <option value="https://www.dbform.com/2013/08/"> August 2013 (4)</option> <option value="https://www.dbform.com/2013/07/"> July 2013 (2)</option> <option value="https://www.dbform.com/2013/04/"> April 2013 (1)</option> <option value="https://www.dbform.com/2013/02/"> February 2013 (1)</option> <option value="https://www.dbform.com/2013/01/"> January 2013 (1)</option> <option value="https://www.dbform.com/2012/10/"> October 2012 (1)</option> <option value="https://www.dbform.com/2012/09/"> September 2012 (10)</option> <option value="https://www.dbform.com/2012/07/"> July 2012 (3)</option> <option value="https://www.dbform.com/2012/06/"> June 2012 (2)</option> <option value="https://www.dbform.com/2012/04/"> April 2012 (4)</option> <option value="https://www.dbform.com/2012/03/"> March 2012 (1)</option> <option value="https://www.dbform.com/2012/02/"> February 2012 (1)</option> <option value="https://www.dbform.com/2012/01/"> January 2012 (2)</option> <option value="https://www.dbform.com/2011/12/"> December 2011 (5)</option> <option value="https://www.dbform.com/2011/11/"> November 2011 (2)</option> <option value="https://www.dbform.com/2011/10/"> October 2011 (8)</option> <option value="https://www.dbform.com/2011/09/"> September 2011 (3)</option> <option value="https://www.dbform.com/2011/08/"> August 2011 (2)</option> <option value="https://www.dbform.com/2011/07/"> July 2011 (3)</option> <option value="https://www.dbform.com/2011/05/"> May 2011 (3)</option> <option value="https://www.dbform.com/2011/04/"> April 2011 (4)</option> <option value="https://www.dbform.com/2011/03/"> March 2011 (5)</option> <option value="https://www.dbform.com/2011/02/"> February 2011 (3)</option> <option value="https://www.dbform.com/2011/01/"> January 2011 (3)</option> <option value="https://www.dbform.com/2010/12/"> December 2010 (1)</option> <option value="https://www.dbform.com/2010/11/"> November 2010 (3)</option> <option value="https://www.dbform.com/2010/10/"> October 2010 (3)</option> <option value="https://www.dbform.com/2010/09/"> September 2010 (1)</option> <option value="https://www.dbform.com/2010/08/"> August 2010 (2)</option> <option value="https://www.dbform.com/2010/07/"> July 2010 (5)</option> <option value="https://www.dbform.com/2010/06/"> June 2010 (5)</option> <option value="https://www.dbform.com/2010/05/"> May 2010 (2)</option> <option value="https://www.dbform.com/2010/04/"> April 2010 (8)</option> <option value="https://www.dbform.com/2010/03/"> March 2010 (7)</option> <option value="https://www.dbform.com/2010/02/"> February 2010 (3)</option> <option value="https://www.dbform.com/2010/01/"> January 2010 (3)</option> <option value="https://www.dbform.com/2009/12/"> December 2009 (11)</option> <option value="https://www.dbform.com/2009/11/"> November 2009 (6)</option> <option value="https://www.dbform.com/2009/10/"> October 2009 (2)</option> <option value="https://www.dbform.com/2009/09/"> September 2009 (5)</option> <option value="https://www.dbform.com/2009/08/"> August 2009 (3)</option> <option value="https://www.dbform.com/2009/07/"> July 2009 (6)</option> <option value="https://www.dbform.com/2009/06/"> June 2009 (4)</option> <option value="https://www.dbform.com/2009/05/"> May 2009 (13)</option> <option value="https://www.dbform.com/2009/04/"> April 2009 (10)</option> <option value="https://www.dbform.com/2009/03/"> March 2009 (10)</option> <option value="https://www.dbform.com/2009/02/"> February 2009 (12)</option> <option value="https://www.dbform.com/2009/01/"> January 2009 (5)</option> <option value="https://www.dbform.com/2008/12/"> December 2008 (14)</option> <option value="https://www.dbform.com/2008/11/"> November 2008 (2)</option> <option value="https://www.dbform.com/2008/10/"> October 2008 (7)</option> <option value="https://www.dbform.com/2008/09/"> September 2008 (9)</option> <option value="https://www.dbform.com/2008/08/"> August 2008 (15)</option> <option value="https://www.dbform.com/2008/07/"> July 2008 (14)</option> <option value="https://www.dbform.com/2008/06/"> June 2008 (7)</option> <option value="https://www.dbform.com/2008/05/"> May 2008 (8)</option> <option value="https://www.dbform.com/2008/04/"> April 2008 (9)</option> <option value="https://www.dbform.com/2008/03/"> March 2008 (17)</option> <option value="https://www.dbform.com/2008/02/"> February 2008 (6)</option> <option value="https://www.dbform.com/2008/01/"> January 2008 (19)</option> <option value="https://www.dbform.com/2007/12/"> December 2007 (21)</option> <option value="https://www.dbform.com/2007/11/"> November 2007 (13)</option> <option value="https://www.dbform.com/2007/10/"> October 2007 (9)</option> <option value="https://www.dbform.com/2007/09/"> September 2007 (8)</option> <option value="https://www.dbform.com/2007/08/"> August 2007 (10)</option> <option value="https://www.dbform.com/2007/07/"> July 2007 (14)</option> <option value="https://www.dbform.com/2007/06/"> June 2007 (9)</option> <option value="https://www.dbform.com/2007/05/"> May 2007 (15)</option> <option value="https://www.dbform.com/2007/04/"> April 2007 (17)</option> <option value="https://www.dbform.com/2007/03/"> March 2007 (14)</option> <option value="https://www.dbform.com/2007/02/"> February 2007 (9)</option> <option value="https://www.dbform.com/2007/01/"> January 2007 (20)</option> <option value="https://www.dbform.com/2006/12/"> December 2006 (12)</option> <option value="https://www.dbform.com/2006/11/"> November 2006 (12)</option> <option value="https://www.dbform.com/2006/10/"> October 2006 (6)</option> <option value="https://www.dbform.com/2006/09/"> September 2006 (10)</option> <option value="https://www.dbform.com/2006/08/"> August 2006 (19)</option> <option value="https://www.dbform.com/2006/07/"> July 2006 (13)</option> <option value="https://www.dbform.com/2006/06/"> June 2006 (12)</option> <option value="https://www.dbform.com/2006/05/"> May 2006 (9)</option> <option value="https://www.dbform.com/2006/04/"> April 2006 (12)</option> <option value="https://www.dbform.com/2006/03/"> March 2006 (19)</option> <option value="https://www.dbform.com/2006/02/"> February 2006 (20)</option> <option value="https://www.dbform.com/2006/01/"> January 2006 (19)</option> <option value="https://www.dbform.com/2005/12/"> December 2005 (25)</option> <option value="https://www.dbform.com/2005/11/"> November 2005 (23)</option>