No question at this time
DBA Top 10
1 M. Cadot 15900
2 B. Vroman 15500
3 A. Kavsek 10000
4 T. Boles 6800
5 J. Schnackenberg 5800
6 M. Hidayathullah ... 3900
7 P. Wisse 1800
8 T. P 700
9 B. Derous 500
9 R. Wauben 500
9 H. Steijntjes 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48209
Total active users1645
Act. users last 24h6
Act. users last hour0
Registered user hits last week186
Registered user hits last month812
Go up

Ora-12638 credential retrival failed
Next thread: downloading of oracle 9i & oracle 10 g for solaris & linux
Prev thread: PL/SQL text within TRIGGERs

Message Score Author Date
Dear Friends, I have just reload win2000 in my...... kanaiya rami Jun 22, 2004, 11:43
>SQLNET.AUTHENTICATION_SERVICES= (NTS) change ...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Syed Jaffar Jun 22, 2004, 12:16
Thanks, After changing this it started working....... kanaiya rami Jun 22, 2004, 12:41
I am also interested to know this detail!... *   Shariq khan Jun 22, 2004, 12:52
do you use the local system account for your oracl...... Freek D'Hooge Jun 22, 2004, 13:13
Hi, I can't get your point. Pl. specify the exa...... kanaiya rami Jun 22, 2004, 13:38
in windows, oracle is being executed as a service....... Freek D'Hooge Jun 22, 2004, 14:53
Hi, Well, I have installed the oracle as Admini...... kanaiya rami Jun 23, 2004, 07:06
If u change SQLNET.AUTHENTICATION_SERVICES= (NTS...... Ammar Semle Jun 28, 2004, 08:56

Follow up by mail Click here


Subject: Ora-12638 credential retrival failed
Author: kanaiya rami, India
Date: Jun 22, 2004, 11:43, 5112 days ago
Os info: windows2000
Oracle info: 9.2.0.1
Message: Dear Friends,

I have just reload win2000 in my m/c and change the domain name and reinstall the oracle. Now when I am going to connect to database at another location system is giving error : "Ora-12638 credential retrival failed".mY SQLNET.ORA,TNSNAMES.ORA AND SQLNET TRACE FILES ARE AS UNDER.

My Sqlnet file is as below.
# SQLNET.ORA Network Configuration File: D:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
trace_level_client = 16
trace_unique_client = yes
trace_file_client = cli.trc
trace_directory_client = h:\nettrace
log_file_client = sqlnet.log
log_directory_client=h:\nettrace

TNSNAMES.ORA FILE IS AS UNDER

# TNSNAMES.ORA Network Configuration File: c:\Oracle\Ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

KALUPUR.TEST.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = KALUPUR)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = KALUPUR.TEST.world)
)

SQLNET TRACE FILE IS AS UNDER
***********************************************************************
Fatal NI connect error 12638, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.1.100)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=KALUPUR.TEST.world)(CID=(PROGRAM=E:\oracle\ora92\bin\sqlplusw.exe)(HOST=TESTSERVER)(USER=Administrator))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
Time: 22-JUN-2004 13:34:32
Tracing to file: h:\nettrace\cli_636_1.trc
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

Please help me.
Thanks in advance.
ken
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Ora-12638 credential retrival failed
Author: Syed Jaffar, Saudi Arabia
Date: Jun 22, 2004, 12:16, 5112 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: >SQLNET.AUTHENTICATION_SERVICES= (NTS)

change NTS to none and try out.

sqlnet.authentication_services=(none)
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Ora-12638 credential retrival failed
Author: kanaiya rami, India
Date: Jun 22, 2004, 12:41, 5112 days ago
Message: Thanks,

After changing this it started working. But I cannot understand why it was happening. Before reloading this tnsnames.ora file working correctly with SqlNet Authentication parameter= NTS.Also when I am creating any new service through NET8 now it is also adding domain name with that. i.e if I will create for TEST than it will show in TNSNAMES.ORA . My domain name is warehouse.customer.world

TEST.WAREHOUSE.CUSTOMER.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.50.50)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TEST.CUSTOMER.WORLD)
)
)

Please help me in this regards.
Thanks in advance
ken
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Ora-12638 credential retrival failed
Author: *   Shariq khan, Oman
Date: Jun 22, 2004, 12:52, 5112 days ago
Message: I am also interested to know this detail!
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Ora-12638 credential retrival failed
Author: Freek D'Hooge, Belgium
Date: Jun 22, 2004, 13:13, 5112 days ago
Message: do you use the local system account for your oracle services or did you specify another account ?
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Ora-12638 credential retrival failed
Author: kanaiya rami, India
Date: Jun 22, 2004, 13:38, 5112 days ago
Message: Hi,

I can't get your point. Pl. specify the exact detials u want.

Thanks,
ken
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Ora-12638 credential retrival failed
Author: Freek D'Hooge, Belgium
Date: Jun 22, 2004, 14:53, 5112 days ago
Message: in windows, oracle is being executed as a service.

these services can run under the localsystem user, or you can provide a account yourself. (often done if you need to write to a shared directory on another server)
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Ora-12638 credential retrival failed
Author: kanaiya rami, India
Date: Jun 23, 2004, 07:06, 5111 days ago
Message: Hi,

Well, I have installed the oracle as Administrator user. And I am working through administrator user only for oracle.

Ken
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Ora-12638 credential retrival failed
Author: Ammar Semle, Oman
Date: Jun 28, 2004, 08:56, 5106 days ago
Message: If u change
SQLNET.AUTHENTICATION_SERVICES= (NTS)
to
SQLNET.AUTHENTICATION_SERVICES= (OSS)
u will not get the " Ora-12638 credential retrival failed" error;
basically it seems to change the external authentication mechanism from OS Security to OracleServerSecutiry ie. only PASSWORD file authentication.
This way u will not be able to connect using "/ as sysdba"
but "sys/oracle as sysdba" (or whatever is SYS password).

I don't know the exact cause of this problem on Win2K, but the solution i figured out after being at it for hours works!

Ammar Semle
Muscat.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here