RE: 8.1.6 upgrade

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:BoivinP_at_mar.dfo-mpo.gc.ca] 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: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>

        -----Original Message-----
        From:   Kevin Kostyszyn [SMTP:kevin_at_dulcian.com]
        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
        kevin_at_dulcian.com

        --
        Please see the official ORACLE-L FAQ: http://www.orafaq.com
        --
        Author: Kevin Kostyszyn
          INET: kevin_at_dulcian.com

        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: ListGuru_at_fatcity.com (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: BoivinP_at_mar.dfo-mpo.gc.ca


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: ListGuru_at_fatcity.com (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).