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

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Sat, 20 Dec 2003 14:39:25 -0800
Message-ID: <F001.005DA8DD.20031220143925@fatcity.com>

• "Norris, Gregory T [ITS]" <gregory.t.norris_at_mail.sprint.com> wrote:
  > 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)
  

good call.
You'll also see this if a W2K Server that is running an Oracle Database is migrated from an NT4 or W2K domain to an "Active Directory".

unfortunately, the default value of this parameter in 8.1.6 and 8.1.7 was "(NTS)".

the use of the environment variable "TNS_ADMIN" pointing to a network share makes this a non-issue, but if you had config files on the user desktops, you'll be using a login script to push out a new copy.

then again, the developers that want to maintain their own fat client config files will still have to make modifications. (Hi Alan :) ).

I already got what I wanted for Christmas ... going to Hotsos!!

Pd

> -----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
>

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

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

---

Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Drake
  INET: discgolfdba_at_yahoo.com

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).

Received on Sat Dec 20 2003 - 16:39:25 CST