Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Saving the config info of the whole oracle on my NT box?

Saving the config info of the whole oracle on my NT box?

From: Billy Collins <queerczar_at_unforgettable.com>
Date: Wed, 11 Oct 2000 03:20:47 GMT
Message-ID: <8s0maa$bdn$1@nnrp1.deja.com>

Hi,

When I try to use Oracle connect string in my ASP code, I get the following error:



Microsoft OLE DB Provider for Oracle error '80004005'

The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 (or greater) client software installation. You will be unable to use this provider until these components have been installed.


I read from help.com that one person gets around this by uninstalling Oracle (we use 8.1.6.0.0, NT 4) and re-installing it all over again!

QUESTIONS:

  1. Is this necessary? Is there any other solution to it?
  2. If not, and if I do un-install the whole Oracle from my NT box and re-install it, how can I minimize the effort required in creating the whole databases again?

I have a couple of databases (created with a "TYPICAL" configuration from the CD) and they are both on the same listener (Ora81TNSListener, the default I think). The info I have modified until now includes USERS, and TABLES. ALl else is default.

I presume that there is not too much effort involved because I can redo  all this stuff, but I'd really appreciate if someone could tell me how I can save (EXPORT) all the info about my Oracle databases now, including the databases + users + tables, and then re-import them back into the Oracle that I re-install?

PS: Its not difficult to see that I am not what they usually refer to as a "DBA" but then we are a "mama and papa" store! :)

Thanks a lot in advance,
WF

If you can CC me the reply as well, it'll be greatly appreciated!

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 10 2000 - 22:20:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US