as QDBA do
execute q$bgproc.stop_driver;
note the results
log out, then in as internal
drop user qdba cascade;
and
let us know what happens, OK?
-----Original Message-----
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 11:55 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: 8.1.6 upgrade
I just upgraded my test server from 8.1.6.1.1. to 8.1.6.3.0, then up to
8.1.6.3.1.. You can get 8.1.6.3.1. at
ftp://oracle-ftp.oracle.com/server/patchsets/wgt_tech/server/windowsNT/81pat
chsets/81631/
I had previously installed a trial version of Savant QDiagnostics, but after
de-installing the thing I am left with a QDBA account that cannot be
deleted.
Drop user qdba cascade hangs whether I do it from DBA Studio, SQL*Plus or
svrmgrl.
I logged a TAR with Oracle, their response was to ask me a dozen questions,
as if they haven't seen this before.
I created a dummy user, created a table, inserted some records into it, then
successfully dropped the table and the user. So I think this has to do with
either memory shortage on my test machine, or the QDBA user itself. Perhaps
those "compressed" packages it owns in the database.
Anyway, I had no apparent problems, except now the Oracle Management Server
service refuses to start, it says something like "the environment pointers
have changed". I haven't logged a TAR regarding that yet, I have to answer
the dozen questions Oracle Support threw at me.
Let me know if you find out anything more, we plan to upgrade to 8.1.6 this
summer and I have to verify that this version is actually stable.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des syst�mes
Technology Services | Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO | R�gion des Maritimes, MPO
E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Original Message-----
From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 11:26 AM
To: Multiple recipients of list ORACLE-L
Subject: 8.1.6 upgrade
Hi all,
Has anyone upgraded 8.1.6 EE on Windows NT to 8.1.6.3.0? I
have done
exactly what oracle said to do and it appears as though it is
missing a .dll
and without the installation is hosed. Do you have to upgrade to
some other
version first? The instance I upgraded was 8.1.6.1, then when it
crashed I
tried a reinstall and it still gives me the same error. Any help
would be
great, I see nothing in the documentaition with the patch that says
I have
to be at anything other than 8.1.6.
Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing
Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
