Joe,
Here's brief from metalink.. for details Check this
Doc ID: 252273.1
STARTUP MIGRATE was introduced in 9.2 as a mechanism to be sure that most
everything that needs to be done to run an upgrade script or a patch
script is done automatically. In the past, customers were expected to
adjust certain initialization parameters prior to beginning an upgrade or
applying a a patch, but most of this is now done automatically by STARTUP
MIGRATE. When a customer starts a database in MIGRATE mode, the following
ALTER SYSTEM commands will be set automatically:
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET "_SYSTEM_TRIG_ENABLED"=FALSE SCOPE=MEMORY;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0 SCOPE=MEMORY;
ALTER SYSTEM SET AQ_TM_PROCESSES=0 SCOPE=MEMORY;
ALTER SESSION SET NLS_LENGTH_SEMANTICS=BYTE;
Regards,
..Ponnusamy
At 01:14 PM 1/22/2004 -0800, Joe LaCascio wrote:
I'm looking at the notes to apply patch 4 to
Oracle 9.2.0.3. After
installing the products.jar file, one of the steps is to run
startup migrate
then run catpatch.sql
I've looked on technet as well as the documentation CD and can not
find
any info on startup migrate.
Can someone point me in a direction to find out about this? All I
can
find is that it's new in 9.2.
Thanks,
Joe
Regards,
..
.Ponnu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ponnu
INET: ponnu_at_kyocera-wireless.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
Received on Thu Jan 22 2004 - 15:34:28 CST
