Skip to Content
author's profile photo Former Member
Former Member

EVENTS are not updated in SPfile.

Hi,

I have changed the EVENTs using below command and create P file from SPfile and restarted the Database. but when i am checking using show parametr event it is not showing. please see the commands ,are they correct.

but in initSID.ora it is showing.

ALTER SYSTEM SET

EVENT="10027 trace name context forever, level 1",

"10028 trace name context forever, level 1",

"10949 trace name context forever, level 2",

"10162 trace name context forever, level 1",

"10183 trace name context forever, level 1",

"10191 trace name context forever, level 1",

"10629 trace name context forever, level 32",

"10091 trace name context forever, level 1",

"10891 trace name context forever, level 1",

"14532 trace name context forever, level 1",

"38085 trace name context forever, level 1",

"38068 trace name context forever, level 100",

"44951 trace name context forever, level 1024",

"38087 trace name context forever, level 1",

"10411 trace name context forever, level 1"

SCOPE=SPFILE;

create pfile from spfile;

Best Regards,

Avinash Ravut.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 25, 2009 at 12:19 PM

    Not sure about it, but so far I have only seen this command with single quotes ' instead of double quotes ".

    Check the syntax in SAP note 601157.

    regards

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 25, 2009 at 12:51 PM

    initSID.ora contains

    event='10027 trace name context forever, level 1','10028 trace name context forever, level 1','10091 trace name context forever, level 1','10162 trace name context forever, level 1','10183 trace name context forever, level 1','10191 trace name context forever, level 1','10629 trace name context forever, level 32','10891 trace name context forever, level 1','14532 trace name context forever, level 1','38068 trace name context forever, level 100','38087 trace name context forever, level 1','44951 trace name context forever, level 1024'

    ...So single quote. For me best way to set this,

    1. take a backup of both SPFILE and P File.

    2.Change Even directly in P file.

    3. Shutdown database

    4. Create SPFILE from P file.

    5. Startup database.

    Or else you can use the procedure you are following..but just with a single quote.

    alter system set event='10027 trace name context forever, level 1','10028 trace name context forever, level 1','10091 trace name context forever, level 1','10162 trace name context forever, level 1','10183 trace name context forever, level 1','10191 trace name context forever, level 1','10629 trace name context forever, level 32','10891 trace name context forever, level 1','14532 trace name context forever, level 1','38068 trace name context forever, level 100','38087 trace name context forever, level 1','44951 trace name context forever, level 1024' scope=spfile;

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      If it relates to SAP why not change the parameters using BRTOOLS.

      Else

      Try using SCOPE=BOTH.

      or

      supply full path and

      CREATE PFILE = u2018$ORACLE_HOME/dbs/name.orau2019

      FROM SPFILE = u2018$ORACLE_HOME/dbs/name.orau2019;

      Regards

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.