Solved

REINSTALL ORACLE AT WINDOWS SERVER 2000

Posted on 2013-05-10
10
383 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
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
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 restore a database from backup after a simulated disk failure using RMAN.

820 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