Solved

REINSTALL ORACLE AT WINDOWS SERVER 2000

Posted on 2013-05-10
10
389 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
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 
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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

717 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