RE: 8.1.6 upgrade

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: 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kimberly Smith
  INET: kimberly.smith_at_gmd.fujitsu.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).