Solved

REINSTALL ORACLE AT WINDOWS SERVER 2000

Posted on 2013-05-10
10
386 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 19

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
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
LVL 19

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 19

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 19

Accepted Solution

by:
strivoli earned 500 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 19

Expert Comment

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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
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.
Via a live example, show how to take different types of Oracle backups using RMAN.

739 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