Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

REINSTALL ORACLE AT WINDOWS SERVER 2000

Posted on 2013-05-10
10
Medium Priority
?
397 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
10 Comments
 
LVL 1

Author Comment

by:emi_sastra
ID: 39154760
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 20

Expert Comment

by:strivoli
ID: 39160482
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
ID: 39160506
-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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 20

Expert Comment

by:strivoli
ID: 39160533
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
ID: 39160537
Oracle Database 11g
Win 7 Ultimate

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

Thank you.
0
 
LVL 20

Expert Comment

by:strivoli
ID: 39160557
Install 9 on 2003.
0
 
LVL 1

Author Comment

by:emi_sastra
ID: 39160649
Ok.

How to attach existing database to oracle ?

Thank you.
0
 
LVL 20

Accepted Solution

by:
strivoli earned 2000 total points
ID: 39160663
0
 
LVL 1

Author Closing Comment

by:emi_sastra
ID: 39160680
Great.

Thank you very much for your help.
0
 
LVL 20

Expert Comment

by:strivoli
ID: 39160720
You are welcome. Have a nice day.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Suggested Courses

618 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