RE: Unable to coonect to database after server upgraded from NT to W2K

From: Norris, Gregory T [ITS] <gregory.t.norris_at_mail.sprint.com>
Date: Fri, 19 Dec 2003 07:44:27 -0800
Message-ID: <F001.005DA70C.20031219074427@fatcity.com>

The server was probably added to a domain (or moved to a different one) as part of the upgrade. Try adding the following entry to your sqlnet.ora file.

SQLNET.AUTHENTICATION_SERVICES = (NONE) -----Original Message-----
Paul Vincent
Sent: Friday, December 19, 2003 8:49 AM
To: Multiple recipients of list ORACLE-L W2K

Hi folks,

Our server team has just upgraded a server from Windows NT4 to Windows 2000, and when I tried connecting to the database from my workstation, using OEM or TOAD, I get an error message after half a minute or so: "ORA-12535: TNS: Operation Timed Out", and cannot complete the connection.

Looking at the Event Log for the database, everything looks OK - it's up and running.

Likewise, the Listener log looks OK - the database service name is there.

Looking at .../network/log/sqlnet.log however, there's something odd:

- - - - Fatal NI connect error 12638, connecting to: (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

VERSION INFORMATION:

	TNS for 32-bit Windows: Version 8.1.6.3.0 - Production
	Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version

8.1.6.3.0 - Production
  Time: 19-DEC-2003 13:57:19
  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
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
- - - - -

I'm not getting very far with tracking down possible causes of these problems, so if it rings any bells with any of you, I'd appreciate any insights!

Regards,

Paul Vincent
Database Administrator
University of Central England

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Paul Vincent
INET: Paul.Vincent_at_uce.ac.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Norris, Gregory T [ITS]
INET: gregory.t.norris_at_mail.sprint.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------