Ask the Expert

ORA-12638 and ORA-01031 on Windows cluster

We have a two-node Microsoft cluster running Windows 2000 Advanced Server SP4. Our cluster storage is SAN attached using dual HBAs. EMC PowerPath manages the dual paths to the SAN. The most critical resource on this cluster is our Oracle database. From time to time, we get the following event in the System Event log:
 
 Event ID: 1069
 Source: ClusSvc
 Message: Cluster resource 'database.prod.fedex.com' failed.
When this error occurs, we see these errors in the Oracle FailSafe logs at about the same time:
 
 Oracle Database <database.prod.fedex.com>: IsAlive Poll of resource
 database.prod.fedex.com failed on attempt number # with the following
 error: ORA-12638: Credential retrieval failed

 Oracle Database <database.prod.fedex.com>: IsAlive Poll of resource
 database.prod.fedex.com failed on attempt number # with the following
 error: ORA-01031: insufficient privileges
The Oracle 12638 error occurs more often than the 01031 error, but they both tend to show up when the Event ID 1069 appears in the Windows System Event log. Both nodes of this cluster are members of the same domain. The account that runs the Oracle database, Oracle FailSafe, and Microsoft Cluster services has Domain Administrator privileges, so I can't imagine it being a privilege issue unless the one or more of the cluster nodes is failing to authenticate against the domain. Any ideas?

    Requires Free Membership to View

In my experience, the ORA-12638: Credential retrieval failed message is frequently related to the SQLNET.ORA setting SQLNET.AUTHENTICATION_SERVICES. If it's set to NTS, check to see if you need Windows native authentication; if you don't, you might try commenting out or changing the parameter.

This was first published in May 2005

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: