Can't connect to Oracle after domain join

From: Massimo <barone_at_mclink.it>
Date: Tue, 4 Apr 2006 19:32:42 +0200
Message-ID: <e0uajp$2btm$1@newsreader1.mclink.it>

Hi to all; I have an Oracle 8 database running on a Windows Server 2003 computer which is a stand-alone server; the Oracle DB works perfectly.

I'm in the process of building a domain and moving all servers and clients into it, but when I join that server to the domain, Oracle stops working. Actually, it's working fine (services are up and running), but any client application (including those running on the server itself) can't no longer connect to it; SQLPlus gives an error of "shared memory realm doesn't exist". If I remove the computer from the domain and make it a stand-alone server again, everything resumes working.

The domain is a Windows 2003 Active Directory domain, and I think the problem can somewhat be related to the DNS suffix the computer gets automatically after joining the domain; before this, it didn't have any DNS suffix. The hostname and the IP address of the server didn't change, anyway.

Can someone please help me with this?

Thanks

Massimo Received on Tue Apr 04 2006 - 12:32:42 CDT