Home » Infrastructure » Windows » Oracle Installation on Windows XP Pro 64bit (Oracle 10g)
icon5.gif  Oracle Installation on Windows XP Pro 64bit [message #340568] Wed, 13 August 2008 05:37 Go to next message
Penfold
Messages: 112
Registered: June 2005
Senior Member
Hi,

I have a PC which has Windows XP Pro 64bit installed.

I've down loaded the 64bit installation of Oracle 10g, but I'm not sure which options to use during the install.

The application which will run on the PC is normally installed using an installation CD which has the option to install Oracle 32bit or MSDE. Once the selected database and application options have been selected the installation installs Oracle and then goes onto run the required scripts for the application; create database, schema's etc.

I have all the scripts available for the application, but how can I, or what do I need to do to install Oracle up to a stage where by I can then proceed to run my scripts?

Should you require any further information or have any questions regarding the above, please let me know.

Regards
Re: Oracle Installation on Windows XP Pro 64bit [message #340803 is a reply to message #340568] Thu, 14 August 2008 06:47 Go to previous messageGo to next message
Penfold
Messages: 112
Registered: June 2005
Senior Member
Hi,

Can anyone advise me, or give me some pointers?

Regards
Re: Oracle Installation on Windows XP Pro 64bit [message #340805 is a reply to message #340803] Thu, 14 August 2008 06:56 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I might be wrong, but
Quote:
application (...) installation CD which has the option to install Oracle
and
Quote:
what do I need to do to install Oracle
are somewhat contradictory.

Why would you pre-install Oracle database if this "application installation CD" already does the same?
Re: Oracle Installation on Windows XP Pro 64bit [message #340806 is a reply to message #340805] Thu, 14 August 2008 07:08 Go to previous messageGo to next message
Penfold
Messages: 112
Registered: June 2005
Senior Member
Hi,

Thanks for the reply.

I'll try and explain my question/problem a bit more clearly...

The application CD I have installs Oracle 10g 32bit configures and builds the database and then goes on to install the rest of the application.

This CD is fine for Windows 32bit, however, in this particular case the PC is running a 64bit version of Windows, so the version of Oracle on the CD is incompatable and doesn't install.

To over come this I require Oracle 10g 64bit installed.

I've donwloaded the 64bit version of Oracle required, and what I want/need to do is install it myself and then once done run the remaining scripts etc and install the application files manually.

What I'm not sure of is the options I need to choose when installing Oracle myself so I can then manually carry out the rest myself.

I hope that makes my question/query a bit more clear?

Regards
Re: Oracle Installation on Windows XP Pro 64bit [message #340809 is a reply to message #340806] Thu, 14 August 2008 07:18 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Perfectly clear Smile

Unless there are special requirements, I'd probably install the "Typical" configuration (i.e. let Oracle Universal Installer do the job). Pay attention to Installer's questions, don't forget to make notes about usernames and matching passwords, as well as other information.

You'll, though, probably have to manually create a schema (unless you can start the "application installation" from that point). It is done by using the CREATE USER statement. Don't forget to check required privileges (perhaps you can find them on a CD?) because - without granting them to the newly created user, installation script(s) will not be able to connect to the database, nor create objects in this schema.
Re: Oracle Installation on Windows XP Pro 64bit [message #340810 is a reply to message #340809] Thu, 14 August 2008 07:21 Go to previous messageGo to next message
Penfold
Messages: 112
Registered: June 2005
Senior Member
Thanks for you suggestion.

I will give this a go and see if I hit any problems or queries.

Will let you know how it goes.

Regards
Re: Oracle Installation on Windows XP Pro 64bit [message #340866 is a reply to message #340810] Thu, 14 August 2008 13:00 Go to previous messageGo to next message
Penfold
Messages: 112
Registered: June 2005
Senior Member
Hi,

I've managed to install Oracle and run the required scripts needed for my application.

However, whne I try and start my app I get the following message: -

Unable to load DLL: 'OraOps.dll': The specified module could not be found.
I've checked in the 'bin' directory and it's not there?

Any ideas how I can resolve this, is it because I didn't have an oracle client installed during the Oracle install?

This is what I though it was, so I tried installing a client, but the proble still exists and in fact the file isn't present on the PC after installing the client?

Any help would be appreciated.

Regards

[Updated on: Thu, 14 August 2008 13:01]

Report message to a moderator

Re: Oracle Installation on Windows XP Pro 64bit [message #340897 is a reply to message #340866] Thu, 14 August 2008 16:03 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
is it because I didn't have an oracle client installed during the Oracle install?

I don't think so. Oracle database doesn't require Oracle client in order to be successfully installed.

Unfortunately, I wouldn't know what is or where you could find OraOps.dll. I don't have it either (having Oracle 10g installed). Did you try to locate it on the (application) installation CD?
Re: Oracle Installation on Windows XP Pro 64bit [message #340960 is a reply to message #340897] Fri, 15 August 2008 05:35 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
That OraOps.dll is part of ODP.NET, a .NET data provider for Oracle, which might be some additional install that is not included in the standard installation.

ODP.NET FAQ
Re: Oracle Installation on Windows XP Pro 64bit [message #341293 is a reply to message #340960] Mon, 18 August 2008 04:09 Go to previous messageGo to next message
Penfold
Messages: 112
Registered: June 2005
Senior Member
Hi,

Thank you both for the replies.

Firstly let me say sorry, it was OraOps10.dll that isn't found not OraOps.dll

I have installed ODP.NET for x64bit and this doesn't resolve the issue.

The file installed is 'OraOps10w.dll' and not 'OraOps10.dll'.

Now I'm stumped Sad

Thanks & Regards
Re: Oracle Installation on Windows XP Pro 64bit [message #341295 is a reply to message #341293] Mon, 18 August 2008 04:18 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK, here it is. OraOps10.dll resides in C:\oracle\product\10.2.0\db_1\BIN directory (note that this is path on my computer; yours might be slightly different (the first part of it)). Its size is 324 KB (Oracle 10.2.0.1.0).
Re: Oracle Installation on Windows XP Pro 64bit [message #341296 is a reply to message #341293] Mon, 18 August 2008 04:18 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Google found me this as the first result.
Re: Oracle Installation on Windows XP Pro 64bit [message #341297 is a reply to message #341296] Mon, 18 August 2008 04:20 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
LOL, my first idea was to rename the file Smile
Re: Oracle Installation on Windows XP Pro 64bit [message #341302 is a reply to message #341297] Mon, 18 August 2008 04:34 Go to previous messageGo to next message
Penfold
Messages: 112
Registered: June 2005
Senior Member
Hi,

Have just tried this and even re-booted the PC.

I don't get the error regarding the missing dll, but instead I get: -

Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

Anyideas?

Regards
Re: Oracle Installation on Windows XP Pro 64bit [message #341307 is a reply to message #341302] Mon, 18 August 2008 05:18 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Ideas

Most of them point to .net permission problems.
Re: Oracle Installation on Windows XP Pro 64bit [message #341319 is a reply to message #341307] Mon, 18 August 2008 06:18 Go to previous message
Penfold
Messages: 112
Registered: June 2005
Senior Member
Hi,

Thanks for the ideas link, looking at one of the links it mentioned using the Microsoft ADO.NET driver instead of the Oracle 10g one.

Fortunately our app can use either, so I changed it to use the MS one and all is good.

Thank you to everyone who has spent time looking at this, appreciate it.

Thanks & Best Regards
Previous Topic: the stupid TNS Listener!
Next Topic: Daily export by Date
Goto Forum:
  


Current Time: Fri Dec 09 17:16:54 CST 2016

Total time taken to generate the page: 0.42419 seconds