Check to see if the QDBA account has any jobs set to run.
If so, you should break and remove them. It does set up
jobs so the chances are good that this is the issue.
-----Original Message-----
Sent: Wednesday, February 28, 2001 8:55 AM
To: Multiple recipients of list ORACLE-L
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kimberly Smith
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).
