<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
    主站蜘蛛池模板: 亚洲综合无码一区二区痴汉| 国产成A人亚洲精V品无码性色| 亚洲一级毛片中文字幕| 在线免费观看国产| 精品日韩亚洲AV无码| 久久精品一本到99热免费| 97亚洲熟妇自偷自拍另类图片| 国产在线一区二区综合免费视频| 国产成人亚洲合集青青草原精品 | 久久成人18免费网站| 久久久久亚洲AV无码专区桃色| 四虎精品成人免费视频| 国产综合精品久久亚洲| 免费无码黄网站在线看| 亚洲国产高清人在线| 57pao一国产成视频永久免费| 亚洲国产午夜电影在线入口| 中文字幕影片免费在线观看| 亚洲精品无码久久久久APP| 免费A级毛片在线播放不收费| 一级做a爱过程免费视频高清| 亚洲色欲色欲www在线丝| 2015日韩永久免费视频播放| 亚洲一区在线观看视频| 日本大片在线看黄a∨免费| 无码日韩人妻AV一区免费l | 在线看片无码永久免费视频| 亚洲精品永久在线观看| 国产成人精品久久亚洲| 中文字幕天天躁日日躁狠狠躁免费| 亚洲一级特黄特黄的大片| 免费日本黄色网址| 男人的天堂网免费网站| 亚洲AV成人噜噜无码网站| 亚洲性日韩精品一区二区三区 | 国产日韩AV免费无码一区二区| 亚洲首页在线观看| 免费少妇a级毛片| 97青青草原国产免费观看| 亚洲第一综合天堂另类专 | 最近中文字幕mv免费高清视频7|