Solved

REINSTALL ORACLE AT WINDOWS SERVER 2000

Posted on 2013-05-10
10
373 Views
Last Modified: 2013-05-13
Hi All,

I have problem with oracle application.
I've got message :

OraOLEDBplus.dll   : the specified module could be found.
Windows Server 2000 service pack 4

The computer is still old one.

My Question :

1. What is the problem ?
2. Could we install newer version, the express version ?
    Which version is suitable and how to install it ?
3. Where to find Tutorial how to use Oracle like SQL Management Studio.

Thank you.
0
Comment
Question by:emi_sastra
  • 5
  • 5
10 Comments
 
LVL 1

Author Comment

by:emi_sastra
Comment Utility
Hi All,

I have problem with oracle application.
I've got message :

OraOLEDBplus.dll   : The specified module could not be found.

After I click Ok, it shows :
Run-time error'3706' : provider cannot be properly installed

The computer is still old one.
Windows Server 2000 service pack 4

My Question :

1. What is the problem ?
2. Could I install newer version, the express version ?
    Which version is suitable and how to install it ?
3. Where to find Tutorial how to use Oracle like SQL Management Studio.
4. Could I use XP or Windows 7, install Oracle and restore existing data ?

Thank you.
0
 
LVL 19

Expert Comment

by:strivoli
Comment Utility
1. The DLL is missing. Restore it from a backup.
2. Newer versions don't work on W2000.
3. Oracle and SQL are two different products. There's no Tutorial like the one you are looking for.
4. You can use XP (not 7) and install Oracle 9 and then either:
a. Recover the missing DLL, or
b. Move data from W2000 to WXP.
0
 
LVL 1

Author Comment

by:emi_sastra
Comment Utility
-1. The DLL is missing. Restore it from a backup.
I have restored it, but no effect.

I try to install new version of Oracle at windows 7 64 bit.

Checking operating system requirements ...
Expected result: One of 5.0,5.1,5.2,6.0
Actual Result: 6.1
Check complete. The overall result of this check is: Failed <<<<
Problem: Oracle Database 11g is not certified on the current operating system.
Recommendation: Make sure you are installing the software on the correct platform.
========================================================

Checking service pack requirements ...
Check complete. The overall result of this check is: Not executed <<<<
OUI-18001: The operating system 'Windows Vista Version 6.1' is not supported.
Recommendation: Install the recommended Service Pack.
========================================================

Checking physical memory requirements ...
Expected result: 922MB
Actual Result: 4095MB
Check complete. The overall result of this check is: Passed
========================================================

Checking Network Configuration requirements ...
Check complete. The overall result of this check is: Failed <<<<
Problem: The install has detected that the primary IP address of the system is DHCP-assigned.
Recommendation: Oracle supports installations on systems with DHCP-assigned IP addresses; However, before you can do this, you must configure the Microsoft LoopBack Adapter to be the primary network adapter on the system.  See the Installation Guide for more details on installing the software on systems configured with DHCP.
========================================================

Checking the length of PATH environment variable...
Check complete. The overall result of this check is: Failed <<<<
Problem: The environment variable 'PATH' has more than allowable character limit.
Recommendation: During installation, Oracle appends ORACLE_HOME/bin folder to the PATH environment variable. The config tools that may be run post installation may depend on the PATH. However the PATH on your system has more than the allowable character limit.  Due to this, Oracle cannot append the ORACLE_HOME/bin folder in the PATH. On Windows XP and Windows 2003, the  maximum character allowed is 8191. On Windows 2000, NT and 98, the limit is 1023 characters. Remove any unwanted PATH entries.
========================================================

Checking for sufficient diskspace in TEMP location...
Check complete. The overall result of this check is: Passed
========================================================

Validating ORACLE_BASE location (if set) ...
Check complete. The overall result of this check is: Passed
========================================================

Checking Oracle Home path for spaces...
Check complete. The overall result of this check is: Failed <<<<
Problem: The Oracle Home you have specified contains spaces ( ) in the path.
Recommendation: You must choose an Oracle Home path that doesn't contain any spaces.
========================================================

Checking Oracle Home path for location ...
Check complete. The overall result of this check is: Passed
========================================================

Checking for proper system clean-up....
Check complete. The overall result of this check is: Passed
========================================================

Checking for Oracle Home incompatibilities ....
Actual Result: NEW_HOME
Check complete. The overall result of this check is: Passed
========================================================

Thank you.
0
 
LVL 19

Expert Comment

by:strivoli
Comment Utility
Which Oracle version are you trying to install? Is it Express Edition 11.2?
Which is the 7 edition you are trying to install Oracle on? Is it Professional?

I still suggest installing 9 on XP since moving data from 9 (on W2000) to 11 (on W7) might be a little difficult.
0
 
LVL 1

Author Comment

by:emi_sastra
Comment Utility
Oracle Database 11g
Win 7 Ultimate

Could I install Oracle 9 on win server 2003 or 2008?

Thank you.
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 19

Expert Comment

by:strivoli
Comment Utility
Install 9 on 2003.
0
 
LVL 1

Author Comment

by:emi_sastra
Comment Utility
Ok.

How to attach existing database to oracle ?

Thank you.
0
 
LVL 19

Accepted Solution

by:
strivoli earned 500 total points
Comment Utility
0
 
LVL 1

Author Closing Comment

by:emi_sastra
Comment Utility
Great.

Thank you very much for your help.
0
 
LVL 19

Expert Comment

by:strivoli
Comment Utility
You are welcome. Have a nice day.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to take different types of Oracle backups using RMAN.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now