From: Billy Collins <queerczar@unforgettable.com>
Newsgroups: comp.databases.oracle.misc
Subject: Saving the config info of the whole oracle on my NT box?
Date: Wed, 11 Oct 2000 03:20:47 GMT
Organization: Deja.com - Before you buy.
Lines: 51
Message-ID: <8s0maa$bdn$1@nnrp1.deja.com>
NNTP-Posting-Host: 202.66.57.154
X-Article-Creation-Date: Wed Oct 11 03:20:47 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0; DigExt)
X-Http-Proxy: 1.1 x62.deja.com:80 (Squid/1.1.22) for client 202.66.57.154
X-MyDeja-Info: XMYDJUIDbilly_collins


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 re-
do 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.