Fatal Ni Connect Error 12638 Connecting To
Contents |
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this tns-12638: credential retrieval failed site About Us Learn more about Stack Overflow the company Business Learn more sqlnet.authentication_services= (nts) about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators
Ora-609
Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:
Oracle Support
Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top ORA-12528 and ORA-12505 error on Oracle database 11g up vote 2 down vote favorite 1 It's been one week since I last tried to run my final project that I worked on in my last internship at some banking company. Suddenly, my webapps (Java project) in Eclipse can't start. In the log it says that it failed to make a connection to the Oracle database, with some error listener in it. So I try to connect the database manually from the SQL developer. It says ORA-12528: TNS:Listener: All Appropriate instances are blocking new connections. I've read some solutions, and I tried to restart the Oracle services including the orcl and listener. After I restarted it, the error becomes ORA-12505: TNS:listener does not currently know of SID given in connect descriptor. After a while, it becomes ORA-12528 again. Can someone help? My thesis defense is next week. alert_ORCL.txt log (SID=ORCL): *********************************************************************** Fatal NI connect error 12641, connecting to: (LOCAL=NO) VERSION INFORMATION: TNS for 32-bit Windows: Version 11.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production Time: 05-MAR-2015 21:28:24 Tracing not turned on. Tns error struct: ns main err code: 12641 TNS-12641: Authentication service failed to initialize ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 o
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
ORA-12638: credential retrieval failed tips Oracle Error Tips by Stephanie F. Question: I am getting the ORA-12638 error when I try to connect to Oracle:SQL> connect sys as sysdba; ORA-12638 credential retrieval failed How do I resolve this ORA-12638 error? Answer: The http://dba.stackexchange.com/questions/94739/ora-12528-and-ora-12505-error-on-oracle-database-11g 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. 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 http://www.dba-oracle.com/t_ora_12638_credential_retrieval_failed.htm completed. The ORA-12638 is an Oracle database error, indicating that the SQL*Net client was unable to connect to the database. In Windows, the Oracle Windows client attempt to use your current Windows domain credentials to authenticate you with the Oracle server. This could fail because the Windows box is not configured to support Windows authentication or because the credentials you use to login to your local machine are not sufficient to allow you to login to the server. There are several possible resolutions for the ORA-12638 error: 1: In on Windows, bounce the server (stop and re-start) the Windows services for Oracle. 2: The following direction was given, and once administered, was a successful resolution to ORA-12638: Please change the sqlnet.ora file in the $ORACLE_HOME/network/admin directory. Change the following entry and the ORA-12638 error will disappear: Change - SQLNET.AUTHENTICATION_SERVICES= (NTS) To: - SQLNET.AUTHENTICATION_SERVICES= (NONE) �� Burleson is the American Team Noadapter error If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can http://www.dbasupport.com/forums/showthread.php?34228-TNS-protocol-adapter-error post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 6 of 6 Thread: TNS:protocol http://www.progtown.com/topic1936714-fatal-ni-connect-error-12638-it-is-how-much-critical.html adapter error Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 02-27-2003,03:14 AM #1 tosahil View fatal ni Profile View Forum Posts Junior Member Join Date Feb 2003 Posts 14 TNS:protocol adapter error When I try to log in to server it is giving me TNS-12560[TNSrotocol adapter error] and TNS-12628 error. From client I am able to log in. SQLNET log looks like this. What can be the problem? -------------------------------------------------------------- Fatal NI connect error 12638, connecting to: (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) VERSION INFORMATION: TNS for fatal ni connect 32-bit Windows: Version 8.1.6.0.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.6.0.0 - Production Time: 26-FEB-2003 15:29:16 Tracing not turned on. Tns error struct: nr err code: 0 ns main err code: 12638 TNS-12638: Credential retrieval failed ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 Sahil Patel Reply With Quote 02-27-2003,03:25 AM #2 Orca777 View Profile View Forum Posts Senior Member Join Date Apr 2002 Location Germany.Laudenbach Posts 448 Hi, have you set the oracle_sid? i think on the server you will connect locally. And locally connect ( direct ) requires the correct setting of ORACLE_SID Orca Reply With Quote 02-27-2003,06:49 AM #3 anandkl View Profile View Forum Posts Senior Advisor Join Date Aug 2001 Location chennai,bangalore Posts 840 When you connect to oracle from the server do not user the host string,just login with username/password... Please let me know if this worked. regards anandkl anandkl Reply With Quote 02-27-2003,06:57 AM #4 ratfink View Profile View Forum Posts Junior Member Join Date Mar 2002 Posts 25 I am having this problem a
»Databases »Fatal NI connect error 12638 - it is how much critical? Pages 1 You must login or register to post a reply Topic RSS feed Posts [ 5 ] 1 Topic by 123 2014-10-25 12:12:49 123 Member Offline Registered: 2008-08-05 Posts: 7,172 Topic: Fatal NI connect error 12638 - it is how much critical? The second day in basis climbs every minute here the such.Thus that do not complain, problems with a connection to basis as were not and are not present. Simply paid attention that began swell strongly alert.log.Who faced - what sense of these errors and in what their reason?Basis 11gR2 11.2.0.1OS Win2008 R2 EE SP1*********************************************************************** Fatal NI connect error 12638, connecting to: (LOCAL=NO) VERSION INFORMATION: TNS for 64-bit Windows: Version 11.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production Time: 20-OKT-2014 3:54:18 PM Tracing not turned on. Tns error struct: ns main err code: 12638 TNS-12638: Failure at extraction of accessories ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 opiodr aborting process unknown ospid (11288) as a result of ORA-609 Mon Oct 20 3:54:38 PM 2014 *********************************************************************** Fatal NI connect error 12638, connecting to: (LOCAL=NO) VERSION INFORMATION: TNS for 64-bit Windows: Version 11.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production Time: 20-OKT-2014 3:54:38 PM Tracing not turned on. Tns error struct: ns main err code: 12638 TNS-12638: Failure at extraction of accessories ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 opiodr aborting process unknown ospid (9308) as a result of ORA-609 2 Reply by Melkomyagkii_newbi 2014-10-25 13:19:50 Melkomyagkii_newbi Member Offline Registered: 2012-04-20 Posts: 338 Re: Fatal NI connect error 12638 - it is how much critical? http://lmgtfy.com/?q=Fatal NI connect error 12638Try to include. Under the first link: wrote: ORA-12638: Credential retrieval failedCause: The authentication service failed to retrieve the credentials of a user.Action: Enable tracing to determine the exact error.Still and here such wrote: 2: The following direction was given, and once administered, was a successful resolution to ORA-12638:Please change the sqlnet.ora file in the $ORACLE_HOME/network/admin directory. Change t