Re: An Oracle 10g on W2K3 server frustration

ABW wrote:

> Dear Experts:
> I tried unsuccessfully to install Oracle 10g DB server on Windows
> 2003.
> When it started to install the database, it would give me
> ORA-12560 and ORA-12514.

Suggestion: installation and database creation are two completely different things. I keep railing at Oracle itself for forgetting the distinction, but to no evident effect. But Users have it in their power to make the distinction. Do a software only install, and leave database creation till later.

How clean is the Windows 2003 machine? Is it running antivirus software (temporarily stop it if so, for the duration of the installation). Is it running a firewall (stop it if so). Zone Alarm? Get rid of it.

On a freshly-installed bog-standard Windows 2003 server, with no patches from MS applied, and no other software installed, the installation of Oracle is generally a piece of cake.

> I went over the TNSNAMES.ORA and LISTENER.ORA and everything seemed to
> be normal.

That won't cut it. "Seems to be normal" means nothing, especially when error messages from Oracle indicate otherwise.

I doubt that at this stage it actually has anything to do with either of these things. I'd be looking at a clean install of Windows, and no funny business with AV or F/W software, first. Then a software-only install of Oracle that completes without incident. Then a manual creation of a Listener using netca, then the creation of a database using one of the templates.

> SID: orcl & global database name: orcl.mydomain.com.
> I have a Windows 2003 server with two NICs (multihoming)

I'd sort that out, too. No wonder you get networking issues. Get rid of one of the cards, get Oracle working with one of them, then add the second card back in.

> with 2 static
> IP addresses (not obtained via DHCP).
> Any idea, comment, pointer?

It might not be very scientific, but get yourself back to a bog-standard, basic, no-frills, and no surprises, machine. Install Oracle. And only then add in frilly bits like multiple NICs, AV and F/W software.

Regards
HJR  
> Thank You
Received on Sat Oct 09 2004 - 18:49:50 CDT