Greetings, insomniacs and readers in other time zones.

For those of you trying to get bugs resolved, a new patch set might
contain your fix.
8.1.7.2.1 for NT is out - 100MB - and here's my rebuild script so far
...

Paul

(Yes, I *have* to apply every patch set as soon as it comes out)



important - read the patch_set_note.htm

rem rebuild_dictionary_81721.sql
rem set _SYSTEM_TRIG_ENABLED = FALSE in init.ora as mentioned in readme
shutdown immediate
rem reset system triggers as disabled
startup restrict
ALTER SESSION SET EVENTS '10520 TRACE NAME CONTEXT FOREVER, LEVEL 10';
@E:\Oracle\Ora81\rdbms\admin\catalog.sql;
@E:\Oracle\Ora81\rdbms\admin\catproc.sql;
REM ?\rdbms\admin\catrep.sql
@E:\Oracle\Ora81\rdbms\admin\utlrp.sql;
ALTER SESSION SET EVENTS '10520 TRACE NAME CONTEXT OFF';
create or replace java system
/

rem if you are using interMedia
@E:\Oracle\Ora81\javavm\install\load_jis.sql;
@E:\Oracle\Ora81\javavm\install\jisja.sql;
@E:\Oracle\Ora81\javavm\install\initjsp.sql;
@E:\Oracle\Ora81\javavm\install\jspja.sql;

shutdown immediate
rem reset system triggers as enabled in init.ora
startup restrict
@E:\Oracle\Ora81\ctx\admin\upgrade\u0801071.sql 
@E:\Oracle\Ora81\ctx\admin\upgrade\u0801072.sql 
@E:\Oracle\Ora81\ctx\admin\dr0pkh.sql 
@E:\Oracle\Ora81\ctx\admin\dr0plb.sql 
@E:\Oracle\Ora81\ctx\admin\dr0type.plb 
@E:\Oracle\Ora81\ctx\admin\dr0typec.plb 
shutdown 
rem run cold backup
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  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).

Reply via email to