Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ORA-12641: Authentication service failed to initalize

5,270 views
Skip to first unread message

eric

unread,
Mar 6, 2008, 2:43:13 PM3/6/08
to
i've already gone through the steps to obtain my ticket with ktpass,
and setup krb5.conf, krb.conf, and tnsnames.ora.

when i obtain my ticket (it appears to work -- no errors produced).
however, when i go to connect: sqlplus /@kb_oracle i get the following
error: ERROR: ORA-12641: Authentication service failed to initalize,
and get prompted to enter my password? anyone have any ideas??

thanks,

eric

joel garry

unread,
Mar 6, 2008, 4:11:38 PM3/6/08
to

Note:185897.1 on metalink is a troubleshooting guide, it notes the
usual answer (enable tracing), as well as
"Problem: Typographical error in the sqlnet.ora file.
Most of the setting for Kerberos authentication in the sqlnet.ora file
have the string '.KERBEROS5_' within them. The 'S5' often gets entered
incorrectly. "

There's also a possible NTS issue if you are using windows, but since
you don't say, I won't.

jg
--
@home.com is bogus.
http://blogs.zdnet.com/projectfailures/

eric

unread,
Mar 6, 2008, 6:24:49 PM3/6/08
to

thanks. i had tracing enabled, but didn't see anything helpful. i'll
go back and check over my stuff again. we are using windows (server
2003). if i had my config here right now, i'd post it (but i'm mobile
right now). i do remember this line though...

SQLNET.AUTHENTICATION_SERVICES=(KERBEROS5, BEQ)

Frank van Bortel

unread,
Mar 7, 2008, 2:07:25 PM3/7/08
to
Check if you have the correct encryption mechanism; MS Windows 2000
uses CRC by default, not MD5. MS Windows 2003 seems to use MD5
by default, but better make sure. Oracle wants MD5.
More options on http://vanbortel.blogspot.com, the "Kerberos errors"
entry.

If the encryption type is the cause, it should become visible
when tracing.

Just curious - why kerberos on Windows when OS authetication
will work? Even AD for LDAP is supported on MS.

--

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up

eric

unread,
Mar 11, 2008, 3:57:53 PM3/11/08
to
On Mar 7, 3:07 pm, Frank van Bortel <frank.van.bor...@gmail.com>
wrote:

> eric wrote:
> > i've already gone through the steps to obtain my ticket with ktpass,
> > and setup krb5.conf, krb.conf, and tnsnames.ora.
>
> > when i obtain my ticket (it appears to work -- no errors produced).
> > however, when i go to connect: sqlplus /@kb_oracle i get the following
> > error: ERROR: ORA-12641: Authentication service failed to initalize,
> > and get prompted to enter my password? anyone have any ideas??
>
> > thanks,
>
> > eric
>
> Check if you have the correct encryption mechanism; MS Windows 2000
> uses CRC by default, not MD5. MS Windows 2003 seems to use MD5
> by default, but better make sure. Oracle wants MD5.
> More options onhttp://vanbortel.blogspot.com, the "Kerberos errors"

> entry.
>
> If the encryption type is the cause, it should become visible
> when tracing.
>
> Just curious - why kerberos on Windows when OS authetication
> will work? Even AD for LDAP is supported on MS.
>
> --
>
> Regards,
> Frank van Bortel
>
> Top-posting in UseNet newsgroups is one way to shut me up

thanks. i'll have a look at that. here's what i was using for ktpass:

ktpass -princ oraclesrv/oracle11gtest...@MYDOMAIN.COM -
DesOnly -crypto DES-CBC-CRC -ptype KRB5_NT_PRINCIPAL -mapuser
svcoracle.mydomain.com -pass {my password omitted} -out C:
\keytab.svcoracle

we wanted to test out something secure (i'm very light-skilled in dba-
stuff), and our "team" wanted to use kerberos. i'll ask them why we're
not using os authentication. do you have an article, or best practices
to point me in the right direction? (i'd check out your website), but
i'm at work -- and can't get to it.

eric

Frank van Bortel

unread,
Mar 14, 2008, 3:14:58 PM3/14/08
to

You can do:
klist -k -e -K -t FILE:/<keytab>
to inspect what you actually got from the AD server
(what ktpass produced).

Get a ticket, using kinit -k -t <keytab>, and see
what gives, using klist.
klist -e will give you the encryption types.

eric

unread,
Mar 17, 2008, 9:20:41 AM3/17/08
to
On Mar 14, 3:14 pm, Frank van Bortel <frank.van.bor...@gmail.com>
> > ktpass -princ oraclesrv/oracle11gtest.mydomain....@MYDOMAIN.COM -

> > DesOnly -crypto DES-CBC-CRC -ptype KRB5_NT_PRINCIPAL -mapuser
> > svcoracle.mydomain.com -pass {my password omitted} -out C:
> > \keytab.svcoracle
>
> > we wanted to test out something secure (i'm very light-skilled in dba-
> > stuff), and our "team" wanted to use kerberos. i'll ask them why we're
> > not using os authentication. do you have an article, or best practices
> > to point me in the right direction? (i'd check out your website), but
> > i'm at work -- and can't get to it.
>
> > eric
>
> You can do:
> klist -k -e -K -t FILE:/<keytab>
> to inspect what you actually got from the AD server
> (what ktpass produced).
>
> Get a ticket, using kinit -k -t <keytab>, and see
> what gives, using klist.
> klist -e will give you the encryption types.
>
> --
>
> Regards,
> Frank van Bortel
>
> Top-posting in UseNet newsgroups is one way to shut me up- Hide quoted text -
>
> - Show quoted text -

i tried klist with the syntax you described above, and it didn't work
(i get -- Usage: klist <tickets | tgt | purge>)

also, i'm still stuck on okinit oraclesrv/oracle11gtest.mydomain.com.
it returns the error: okinit: client not found in kerberos database.

i'm going to try and set it up in a test lab today and see if i get a
different result.

Frank van Bortel

unread,
Mar 17, 2008, 4:34:57 PM3/17/08
to
eric wrote:

>
> i tried klist with the syntax you described above, and it didn't work
> (i get -- Usage: klist <tickets | tgt | purge>)
>

Oops - MicroSoft Windows?
There's a kerberos ticket viewer somewhere; used it once
@work - not @work now, so can't help you

vdeol...@ncf.edu

unread,
Nov 9, 2015, 9:28:16 AM11/9/15
to
Eric,

I know that this was many, many moons ago, but I am now where you were then. Did you get these problems resolve, and if so, do you recall what the roadblocks were?

Many thanks.

Peter Schneider

unread,
Nov 12, 2015, 11:20:18 AM11/12/15
to
I would even dare to say that this was many, many suns ago ;-)

So don't hold your breath waiting for an answer.

Regards
Peter

--
Climb the mountain not to plant your flag, but to embrace the challenge,
enjoy the air and behold the view. Climb it so you can see the world,
not so the world can see you. -- David McCullough Jr.

vdeoliveira

unread,
Nov 17, 2015, 1:30:49 AM11/17/15
to
Attempting to set up oracle 12c with kerberos authentication for a class next semester has been hands down the most frustrating task I have ever been given in IT.

I have seriously been scouring so much of the internet that I came across this post again and forget that I had left a comment.


Noons

unread,
Nov 17, 2015, 3:28:38 AM11/17/15
to
On 17/11/2015 5:30 PM, vdeoliveira wrote:
> Attempting to set up oracle 12c with kerberos authentication for a class next semester has been hands down the most frustrating task I have ever been given in IT.
>
> I have seriously been scouring so much of the internet that I came across this post again and forget that I had left a comment.
>
>


Careful! You'll be classed as a "bad dba" for DARING to say their
authentication is nothing but a load of CRAP!

A. Mehoela

unread,
Nov 18, 2015, 5:04:48 PM11/18/15
to
Don't scare the man away, for once we had something on topic.
0 new messages