RE: 8.1.6 upgrade

I used to use Q as well. What is happening is that the 'engine' is running inside the database via dbms_jobs. Stop the jobs from running (either from the Q menu) or stop the internal jobs.  

Good luck.    

John Fedock
jfedock_at_ixl.com <mailto:jfedock_at_ixl.com> iXL

-----Original Message-----
<mailto:BoivinP_at_mar.dfo-mpo.gc.ca> ]

Sent: Wednesday, February 28, 2001 11: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
<ftp://oracle-ftp.oracle.com/server/patchsets/wgt_tech/server/windowsNT/81pa
t>
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
<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


<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


<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:
  INET: jfedock_at_ixl.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).