How To Delete A Entry From SPFILE

Last day I updated the spfile, but I made a mistake, I write a non-existing SID, I want wrote IND1 (Instance number one) but wrote IND11. Now I have a entry for instance IND11. This is a typical error.

For remove it from spfile you must to reset the parameter as show below;

alter system reset memory_target scope=spfile sid=’IND11′;

Now I have a nice spfile. Next time I must to be more carefull.

HTH – Antonio NAVARRO.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s