Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

event or _trace_evnet init parms on upgrade

edited Oct 31, 2014 3:08PM in Database Install/Upgrade/Opatch (MOSC) 1 commentAnswered ✓


Oracle 10.2.0.4 Std Ed One

Windows Server 2003 32-bit

Upgrading to 11.2.0.4 Std Ed One

Working out the procedures on a VBox testbed.  For the setup, I created the vm, installed 10.2, then patched it up to 10.2.0.4.  I then used dbca to create a general purpose database, without the sample schema.

Prior to the upgrade I executed utlu112i_5.sql.  It suggested the following additional queries:

SELECT (translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2

WHERE  UPPER(name) ='EVENT' AND isdefault='FALSE'

SELECT (translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2

WHERE  UPPER(name) ='_TRACE_EVENTS' AND isdefault='FALSE'

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center