Personal notebook for Oracle, MySQL and SQL Server databases

Showing posts with label parameter. Show all posts
Showing posts with label parameter. Show all posts

Sunday, December 14, 2014

How to delete spfile entries in Oracle 11gr2


Do not use '' or 'NULL' values. Use instead following reset -value

alter system reset parameter scope sid='*';

e.g.

alter system reset db_file_name_convert scope=spfile sid='*';


Posted by Unknown at 12:41 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: parameter, pfile, spfile, sqlplus
Location: Kruununhaka, Helsinki, Suomi
Older Posts Home
Subscribe to: Posts (Atom)

About Me

Unknown
View my complete profile

Labels

2012 active active data guard adminshare adminshares aix asm automation awk backup chuser clustererror data guard dbsize diskgroup expdp failovercluster grid grid infrastructure impdp linux local_listener lvm microsoft mysql ora-00245 ora-error oracle oracle11gr2 oraenv oratab parameter passive patch patching pfile postscript prescript ps pwdadm rebalance remote_listener resolv rhel rman scan sccm sed shell skiperror solaris spfile sql sqlplus sqlserver sqlserver2012 standby static listener svccfg voting votingdisk windows2012

Blog Archive

  • ▼  2016 (2)
    • ▼  May (1)
      • Why EXPDP/IMPDP flashback_time is awesome?
    • ►  February (1)
  • ►  2015 (6)
    • ►  November (3)
    • ►  September (1)
    • ►  July (1)
    • ►  April (1)
  • ►  2014 (9)
    • ►  December (3)
    • ►  November (1)
    • ►  August (3)
    • ►  July (2)
Picture Window theme. Theme images by compassandcamera. Powered by Blogger.