<rt id="bn8ez"></rt>
<label id="bn8ez"></label>

  • <span id="bn8ez"></span>

    <label id="bn8ez"><meter id="bn8ez"></meter></label>

    Decode360's Blog

    業(yè)精于勤而荒于嬉 QQ:150355677 MSN:decode360@hotmail.com

      BlogJava :: 首頁 :: 新隨筆 :: 聯(lián)系 ::  :: 管理 ::
      302 隨筆 :: 26 文章 :: 82 評論 :: 0 Trackbacks
    ORA-12638: credential retrieval failed tips
    Oracle Error Tips by Stephanie F.
    ?
    The Oracle docs note this on the ora-12638 error:
    ?
    ORA-12638: Credential retrieval failed??
    Cause: The authentication service failed to retrieve the credentials of a user.?
    Action: Enable tracing to determine the exact error.

    On the Oracle Technology Network Forums, a user is able to successfully resolve ORA-12638 after some help from repliers.? The original question was referring to a problem installing Oracle Designer, in which the user was thrown ORA-12638, when testing the connection, before the installation had even finished.

    A replier pointed out to the user that ORA-12638 is "an Oracle database error, indicating that the Designer client was not able to connect to the database."

    Though sometimes ORA-12638 can be resolved by restarting the database services in cases where Oracle on Windows is being used, although for this user it was not helpful.
    ?
    However, the following direction was given, and once administered, was a successful resolution to ORA-12638:
    ?
    Please check the sqlnet.ora file. Change the following entry and try, this will work.
    ?
    Original Entry - SQLNET.AUTHENTICATION_SERVICES= (NTS)
    Modified Entry - SQLNET.AUTHENTICATION_SERVICES= (NONE)
    ?
    ?
    ?
    ?
    附關(guān)于ORA-12638問題原因的bolg一篇:http://zalbb.itpub.net/post/980/48931
    ?
    ------------------------------------------------------------------------
    ?
    ??? 前段時間在2003上裝測試數(shù)據(jù)庫, 有同事在連接時說報此錯誤, 我大致觀察揣摩的一下,發(fā)現(xiàn)一時間無法找到答案, 之后發(fā)現(xiàn)把數(shù)據(jù)庫的SQLNET.ORA文件中的此項SQLNET.AUTHENTICATION_SERVICES 注釋掉即可克服此錯誤,但具體原因也說不清楚,沒解決此問題,心里一直疙瘩著;前兩天想起此問題,用GOOGLE搜索了一下,在ITPUB 上發(fā)現(xiàn)一篇文章,說是把客戶端的SQLNET.ORA文件給刪除即可,試了一下,果真如此。但文章中的那人也解釋不清楚原因,后上METALINK問,ORACLE的技術(shù)人員給了兩篇文章讓我先閱讀。看完后作測試,才知道,對NTS的認(rèn)證方式又多了一層了解。
    ?
    ora-12638 錯誤的剖析
    ?
    Site(A, Server) Windows 2003(已成為域控制器), oracle9206(opatch5)
    Site(B, Client) windows 環(huán)境(2000,2003),oracle 數(shù)據(jù)庫或客戶端
    ?
    Site(A),Site(B) 的oraclenetworkadmin目錄下都有文件sqlnet.ora
    該文件中都有這一項 SQLNET.AUTHENTICATION_SERVICES= (NTS)
    ?
    現(xiàn)象1、當(dāng)Site(B)以域domain (此域不同于site(A)的域)身份登錄機(jī)器時,并且Site(A),Site(B) 中的sqlnet.ora 都有這一項 SQLNET.AUTHENTICATION_SERVICES 時,則會出現(xiàn):
    ?
    SQL> connect scott/1@lenovo
    ERROR:
    ORA-12638: Credential retrieval failed
    ?
    Warning: You are no longer connected to ORACLE.
    SQL>
    ?
    現(xiàn)象2、此時,若把客戶端Site(B) 的 sqlnet.ora文件中的這一項 SQLNET.AUTHENTICATION_SERVICES 還是被注釋掉#SQLNET.AUTHENTICATION_SERVICES= (NTS) 或 SQLNET.AUTHENTICATION_SERVICES= (NONE), 則均可以正常連接數(shù)據(jù)庫
    SQL> connect scott/1@lenovo
    Connected.
    ?
    現(xiàn)象3、當(dāng)客戶端Site(B)以本機(jī)身份登錄時,則不論 Site(B) 的 sqlnet.ora文件中的這一項 SQLNET.AUTHENTICATION_SERVICES = (NTS) 還是被注釋掉#SQLNET.AUTHENTICATION_SERVICES= (NTS) 或 SQLNET.AUTHENTICATION_SERVICES= (NONE), 均可以正常連接數(shù)據(jù)庫
    SQL> connect scott/1@lenovo
    Connected.
    ?
    ?
    原因:Site(A)是域控制器(vsts.com),若Site(B)也以域(domain)身份登錄機(jī)器,并且Site(A),Site(B)都采用操作系統(tǒng)認(rèn)證(NTS)方式,則需要雙方建立信任關(guān)系,要不就一方不采用(NTS)認(rèn)證。如:
    SQLNET.AUTHENTICATION_SERVICES=NONE 或#SQLNET.AUTHENTICATION_SERVICES=***
    ?
    Oracle 解釋如下:

    Either create trust between the two domains or change the client or server SQLNET.AUTHENTICATION_SERVICES such that NTS in not negotiated in the connection handshake. NTS is only negotiated if both client and server have SQLNET.AUTHENTICATION_SERVICES set to NTS.
    ?
    i.e. SQLNET.AUTHENTICATION_SERVICES=NONE
    ?
    解決方法:
    1、對兩個域建信任關(guān)系(沒測試此方法)。
    2、數(shù)據(jù)庫或客戶端的sqlnet.ora 中的 SQLNET.AUTHENTICATION_SERVICES=NONE或被注釋掉 #SQLNET.AUTHENTICATION_SERVICES。
    ?
    鑒與生產(chǎn)環(huán)境,無法對兩個域建信任關(guān)系后作測試,無奈!




    -The End-

    posted on 2008-10-20 21:54 decode360-3 閱讀(299) 評論(0)  編輯  收藏 所屬分類: Oracle
    主站蜘蛛池模板: 亚洲国产精品第一区二区| 中文字幕亚洲不卡在线亚瑟| 99亚洲精品高清一二区| 国产视频精品免费视频| 免费大学生国产在线观看p| 亚洲中文字幕无码久久| 亚洲av无码一区二区三区人妖| 曰曰鲁夜夜免费播放视频| 日本牲交大片免费观看| 亚洲香蕉成人AV网站在线观看 | 亚洲乱人伦精品图片| 在线视频免费观看爽爽爽| 亚洲人和日本人jizz| 日韩中文无码有码免费视频 | 亚洲国产成人精品91久久久| 美女羞羞视频免费网站| 亚洲免费视频在线观看| 亚洲精彩视频在线观看| 67194熟妇在线永久免费观看| 国产精品亚洲一区二区麻豆| 国产高清在线免费| 亚洲视频免费一区| 久草免费福利在线| 亚洲A∨无码无在线观看| 免费精品视频在线| 国产亚洲成av人片在线观看| 91香蕉国产线在线观看免费| 久久精品国产99国产精品亚洲| 国产片免费在线观看| 中国毛片免费观看| 亚洲成a人片7777| 国产免费av片在线播放 | 最近中文字幕完整版免费高清| 国产日本亚洲一区二区三区| 日本免费在线观看| 亚洲已满18点击进入在线观看| 亚洲高清偷拍一区二区三区| 99视频在线免费| 国产精品亚洲а∨无码播放麻豆 | 亚洲国产欧美一区二区三区| 精品国产日韩亚洲一区|